Happy New Year everyone!
I was hoping you could help me with the following:
I have 2 types of things in my database: conversations and Users.
In Users, I have a field where with a list called X.
In conversations, I have a field called topic_ID and a field called user_id, which is the same as the unique id in Users.
I’m trying to change a thing - conversations, while these conditions exist:
- Go through every entry (or a thing) in conversations.
For each conversation, check for conversations’ unique ID and find the entry in Users that has the same unique ID.
- Once you found it, check if this entry’s list X contains an arbitrary value (let’s say XYZ) If it does, change this conversation topic ID to “ABC”, else do nothing
Any ideas on how to achieve this? I can run a workflow on one list of things, but I’m not sure how to compare it with another.