Condition in comparing with two lists

thomascope · 2024-07-24T12:16:04.617Z

Hello everybody,

I would like to know how to put nominative conditions for selection of a list located in the cell of a field.
I created a Slack clone.
You can create a new conversation, a popup opens and you select who you want to put in the conversation.
The trouble is that I can create multiple conversations with the same people (Curtis Franck and Beth Newlands Campbell and the one who created David Bezos)
(Screenshot 1).
How can we say at Bubble:
“you create the new conversation provided that it does not already exist?”

To show you, here is how the app is built:
There is a Custom State when you select people: CS_crisis_unit_channel. (Screenshot 2)

In the workflow, I have “Create a new thing” for the Message table with the content of the message (Content) and the author of the message: Current user. (Screenshot 3)

In this same workflow, there is a “create a new thing” for the tale chain.
(Screenshot 4).

And in the database to give an example, we can see that there are two times in the Channel table the same conversation with the same people (player1, player4, player3). (Screenshot 5)
I know how to make conditions with a conversation with only two people and by putting a :count<1
but, here I would like him to identify each of the people according to their identities to know if this conversation does not already exist.

Screenshot 2024-07-24 at 08.36.521982×1132 174 KB

Screenshot 2024-07-24 at 08.39.15708×226 18 KB

Screenshot 2024-07-24 at 08.41.001470×986 132 KB

Screenshot 2024-07-24 at 08.41.061516×1262 159 KB

Screenshot 2024-07-24 at 08.41.161442×352 41.9 KB

Is it possible ?
THANKS

boston85719 · 2024-07-24T13:08:30.126Z

thomascope:

Is it possible ?

yes, but likely not the best UX.

To do it, simply use the conversation list of users and then you should be able to access the ‘contains list’ operator to compare against your custom state list of users.

However, I say it might not be the best UX as this approach would assume, as far as I can tell from details in the post, that every time a user wants to have a conversation with the same group of users, it is about the same topic, which may not be the case.

I’d suggest giving a checkbox to allow the user to select to create a new conversation or not if there is an existing conversation found and also to give a title to the conversation, as groups of people may have multiple conversations taking place about different projects or something.

thomascope · 2024-07-24T14:48:45.603Z

HI,

Thank you for the reply.
When you said :
“To do it, simply use the conversation list of users and then you should be able to access the ‘contains list’ operator to compare against your custom state list of users.”

Is it like ly screenshot ?
How could I say Does not countain list ?
Because It only proposes me with “contain list” ?

Screenshot 2024-07-24 at 16.48.01684×700 43.4 KB

Thank you for your advise. For this moment , I don’t want to allow people to create several conversations with the same people because it is for a specific topic.

Thomas

boston85719 · 2024-07-24T15:28:17.647Z

thomascope:

How could I say Does not countain list ?
Because It only proposes me with “contain list” ?

If it does not provide a choice of ‘does not contain list’ then you can not say does not contain list.

Also, weren’t you asking for the below?

thomascope:

How can we say at Bubble:
“you create the new conversation provided that it does not already exist?”

If the condition of contains list is no, then the conversation doesn’t already exist

thomascope · 2024-07-24T15:44:31.284Z

I achieved to find the solution from another guy but without Containt list.

Tell me what do you think of it ?

Screenshot 2024-07-24 at 17.44.211470×904 104 KB

Toom