EDIT - Sorry, I have two posts going on this question now. I didn’t want this specific question to get lost.
I’m trying to collect user data on a form and have it write into the user table for users who already have a profile set up, so I think I need to use the edit data action, but I can’t get it to write into the already existing user row. It keeps adding a new row. I keep partially getting it right, but I can’t figure out where I’m going wrong. I did a screen recording to show what I’m doing and I’m trying to figure out where my settings are going wrong.
I think I’m almost there, but now I’m not sure how and where I’m telling it to write the data to. I did a new screen recording to show where I’m at now. Thanks for your help! Don’t worry, the screen recording is under 3 minutes.
If you want to edit the already existing user row, it’s better to direct your collection straight to the user sheet. Otherwise, you will need a relation to establish the connection between the vendor sheet and the user sheet.
Assign the ‘show edit screen’ action to this collection component.
What is the difference between the different form components that I can choose from? When I try to add any of the components that say values from screen or values from user profile, it adds it in my components sidebar, but then doesn’t show anything in my overlay.
Let’s slow down a minute. I think we can take a much easier approach that doesn’t use forms at all.
Do you have a single relation in the vendor table linking vendor table to the user table? Are you able to create that link using email or something like that?
No, there isn’t anything linking the vendor table to the user table. I don’t really think that would work in my use case. I have another table where I have reps listed who will be attending on behalf of those vendors, but not every rep has an email, and sometimes they send different reps than what they originally told me.
