Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 17, 2022 05:22 AM
Hey, I have a table where I have a formula column that automatically generates an Airtable form link that prefills a few data such as name and email before sending it.
What I noticed is after someone fills out the form and submits it, a new row is created rather than Updating/appending the row I used to create the formula, does anyone know how to resolve this?
Solved! Go to Solution.
Nov 17, 2022 12:21 PM
That way works. Or you can use RECORD_ID()
in the formula that generates the prefilled url.
Nov 17, 2022 07:02 AM
Forms always create a new record. They never directly update an existing record. You can add in an automation to update the original record. I usually use a hidden prefill of the original record ID to make identifying the original record easier.
Nov 17, 2022 08:53 AM
Yeah, that’s what I thought of doing. How did you add the original record id to the link? Was it by creating a new formula field that shows the record ID and adding that column as prefill?
Nov 17, 2022 12:21 PM
That way works. Or you can use RECORD_ID()
in the formula that generates the prefilled url.
Nov 18, 2022 01:13 AM
Thanks, that worked for me.
Nov 18, 2022 02:56 AM
Hey @kuovonne , there is a problem with the method you said where I use automation to update the original row.
I thought this method would not create a 2nd row when someone submits a response but it did anyway.
What could I do to delete the row that is created when someone submits a form and only have the original row or not create a row at all when someone submits a form but only update it through automations.
Nov 18, 2022 05:17 AM
As I said before, a form will always create a new record. You can then add in an automation to update the original record. Deleting one of the two records automatically is a little harder because there is no “delete record” action, but it can be done with a scripting automation. You can search these forums for more details.