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.
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.
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.