Modify two tables in the same workflow

[jayjay]

Hi everyone,

I currently have a problem and a little help would be appreciate :

I have :

• a table “user” with a list of “promotions”

• a table “promotions” with a list of “users” (called students)

I created a popup to edit the promotion. I would like to edit my two tables (user and promotion) in the same workflow :

• when an user is added to the list of student of the promotion, add the current promotion to the list of promotion, on the table user.

• when an user is removed from the list of student of the promotion, remove the current promotion to the list of promotion, on the table user.

Unfortunately, I did this workflow (see images below), it modifies my table promotion but not the user one (it doesn’t add the promotion to the list of promotions on the table “user”)

Do you have an idea where did I miss something ? thank you guys

[jared.gibb]

To clarify here:

sounds like you are saving the user onto each promotion object and then saving a list of all promotions that user has received onto the user object itself?

IMO, you don’t need to save that list to the user at all. Is there some particular reason you’re doing it that way?

[jayjay]

Hi @jared.gibb ,

thanks for your reply !

so yes, I’m saving the list of users onto the promotion object (as students) and on each of those students, I’m adding the promotion (because on the user object I have a field “promotions” which is a list of promotions). I did it like this because of some privacy rules I needed to setup.

[rgblabbr]

@jayjay I have a similar problem. Did you solved it?