Hi, I'd like to use "Copy row and edit the co...

[Zsolt_Bako]

Hi, I’d like to use “Copy row and edit the copy” action to keep a filterable history of data changes.

I’d like to keep all the records editable but setting the initial value of a date field (“ModificationToTakeEffectOn”) in the copied row to NOW(). So our users can leave it if the modification should take effect immediately or they could change it for a future date.

Is it doable with a set of actions or there’s another way to achieve this workflow?

Thanks!

[John_Gardner]

This can be done by hiding the “System Action” for “Edit” and sneakily replacing it with your “Copy row” action.

You probably don’t have to hide the “Edit” action, you could just set your table to not allow edits.

[Zsolt_Bako]

@John_Gardner thanks for the advice on replacing the Edit button!

Does anyone have any recommendations on how to set

the initial value of a date field in the copied row to NOW()? Or how to set the initial value of any of the fields on the copied table to a different value than in the original row?

[John_Gardner]

Idea #2:

Since you need to change some of the data, use LINKTOFORM()

This is a newer feature, and I haven’t used it much yet, but it’s really great!

help.appsheet.com - Column Type: App (Deep Links) Column Type: App (Deep Links) help.appsheet.com