Webforms populate already existing row

Hi @Axel ,
Another solution I sometimes use:

  • Create another table containing the same columns as the first one, and an extra column containing a reference to the concerned row for example, as you said, the row_id
  • Create a form for this new table with the reference passed into the URL as prefilled non-modifiable field
  • Create an automation to modify the data of your first table each time a form is submitted in the second table

Doing so, as you will generate specific URLs for each row of the first table, you have the possibility to prefill every field with the data from the first table, allowing, for example, a user to modify all the personal data he fulfilled during his first submission.

Personally, I use n8n both for generating the specific URL for each row and to trigger the modification of the row when a “modification form” is submitted

Bests,
Benjamin

2 Likes