Hi,
I am trying to create a workflow where I edit a users information, but with an extra action when if the name is being changed that it’s also changing the name in another table in Supabase.
To do so, the ID of that action looks like this:
And when I test it in the workflow environment it works, but when I edit it on the front-end, nothing happens.
At first I tried to use a foreign key in Supabase to get the name in the table, but it didn’t work, so that’s why I am using a workflow to get the name in the TeamMembers table. This was the only solution, I can come up with my NO-code skill level.
Have you the collection fetched on the front-end too? if you want update something in Supabase you should use the update collection workflow action, what are you using here to change the values?
Deleted my previous reply, because I thought I had the solution which wasn’t
Can you rubber ducky this a bit with some more screenshots of the logic and maybe explain where the inputs come from
Your formula always returns teammenber.data[0].id.
Use the if formula if you want a conditional value.
Thank you all for your answer.
I think I overcomplicated things at the start. I went back to Supabase and started all over again with the tables and the columns, and by doing so. It seems like the setup of the collections seems more logical.
I’m still in the learning process, but step by step we are moving forward.
