Condition in comparing with two lists

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.

Is it possible ?
THANKS

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.

1 Like

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” ?

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 :slight_smile:

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?

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

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

Tell me what do you think of it ? :slight_smile:

Toom