Solved: Copy only Specific Columns in a row

andrew_austin · 04-20-2021 07:24 AM

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

Markus_Malessa

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.

View solution in original post

Markus_Malessa

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.

andrew_austin

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