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!
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.
@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?
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
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |