Update instead of Insert on Duplicate

Still haven’t figured out how I get a form entry to update the record if the primary key combination is a duplicate ?

Specific example:

-A ticketing function in an app
-People can reserve with their signed in email
-Next time if the same person is trying to reserve I would rather update the first entry instead of creating another row

That’s not how forms work. Forms will ALWAYS add a new record. If you want to update an existing record, then turn on editing for that existing record when viewing it’s details.

Otherwise you will have to do some sheet magic to find the last row in a form response sheet and update values on an existing row in a different sheet. Or you can use a relation and rollup to find the last record, then create another relation based on the rollup value and probably a template to get that last row. Then use lookups to get the the relevant data from the form response sheet.

I would instead just make sure they can see their existing reservations and allow them to update the record with the edit functionality.

In this scenario, is there a way to make fields “required?” For example, upon sign-up, I have the user’s email and the first screen they are taken to is “Update Profile.” Email is already filled in, but username, cellphone, etc. all need to be added to complete the profile. I would like to make those additional fields “required,” but cannot do so if not in a form. Any ideas would be appreciated. Thank you.

Create an if-then-else column in your User Profiles table:

  • If name is empty, then null
  • If phone is empty, then null
  • etc…
  • Else true

And then only allow them to leave that screen when that column is checked.

3 Likes

Thank you