Copy only Specific Columns in a row

Wondering if there is a way to copy only specific data in a row and Edit it.

The copy function copies all column entries per row however we are looking to copy only a few entries and then edit it to update the rest.

Thank you.

You could use LINKTOFORM() action instead of copy row. In the expression you could designate which columns to prefill and in your column settings for editable_if you could do an expression that won’t let you edit the prefilled columns when on that particular form.

Of course in this setup the new row won’t get persisted until you hit the save button on the form.

1 Like

Thanks Markus, made a few tweaks and it works great!

1 Like