I then have a custom action becasue I want to create a row in another table when the signup form is submitted. The new row is added to the other table and the next step of the action is to set column values.
The issue I am having is that when a user first signs it it creates a row for that use, however when they submit the the form, it’s not setting the column values, it’s creating a new row, so I have a duplicate user. I’ve tried setting the colum values to ‘this row’ and to the user profile row’ but the same thing happens.
I’ve used custom forms a number of times but this one is just not working as I expected.
I think you need to create a relation from the first table to the second, then select that relation as the source of the “Set Columns” action. This way it locates the row you’ve already created, instead of trying to set the values of a new row it thinks doesn’t exist…
Another alternative would be to set the values straight from the “Add Row” action, as opposed to updating the row with another action immediately after it’s created.
Can you walk me through why you need to add a row to what seems like your Users table again?
If you have an Onboarding process, you build the entry components like a custom form, right on your details screen, which should be on top of your Users table, filtered to the right row using something like email is signed-in user.
Then, at the end of that process, you do set of actions needed, and you don’t add a new row to the Users table again.
