How to make a form update a database row instead of new one?

[Joakim_Isoaho]

Hey I have a doc where people submit their profiles via form.

How can I let them edit the profiles later on? I thought an easy way would be to just submit the form again, but this creates a new profile.

Thanks!

[Johg_Ananda]

hey @Joakim_Isoaho welcome to the community! This question has been addressed here:

Launched: Pre-filled Form Fields

Pete, I think this is easily doable. Here’s how I would approach that problem: Guests fill out info on form the first time, information flows into table A Table A has a formula column that generates a link to a form with the row information pre-filled. The formula would use the Concatenate() formula to generate the link with that row’s information. You can send that link as a form to the guest, which would provide them view of their current information. Guest could update their information as …

[Erica_Wilson]

Hey @Johg_Ananda ! I’m grateful that you’ve already worked on this because I have a similar issue. I’m stuck on getting this step: Table A to have a formula column that generates a link to a form with the row information pre-filled. Could you help out with an example formula?
Thank you!!

[Johg_Ananda]

Hi @Erica_Wilson you need to use url parameters with your form. Its explained in this article here:

Launched: Pre-filled Form Fields

We’ve loved hearing about the incredible ways you’ve been using forms in the few weeks since they’ve launched, and wanted to share an exciting update based on your feedback. Starting today, you can update URLs for forms you publish to pre-fill fields in your forms. To do so: Publish your form Append text to your URLs to specify any fields that should be pre-filled (read on for more) [Prefilled Forms] URL Structure to Pre-Fill Fields To pre-fill fields, grab your published form URL and add …

Good luck let me know if you need more help.