Add a row with prefilled data from the current form

[carribeiro]

In my CRM system, I need to add a new row with the same data from an existing row. The catch is, I can't just copy the entire record; I need to copy just a few specific fields. Also, the action to actually create the record needs to be done AFTER I finish editing (in other words I can't just clone the row and edit it later).

How can I just open the ADD form but prefilling a few fields with data from the current record? That would be my best choice I think.

A few more deatils: I want to copy the customer name & contact info from the current row, open the ADD form, and keep all the behavior that is already attached to the ADD form (it autoincrements the order number, creates a Google Drive folder with the name of the project, etc).

[1minManager]

Linktoform() called from an action button can create a new row with some of the values from the row it was created from

https://support.google.com/appsheet/answer/10106538?hl=en&sjid=14076448222584267249-EU