Copy (Action)

[Moniker]

Copy Action (app: Copy this row and edit the copy)

1.My row contain the "Timestamp" column to capture the entry time by now() expression and it's hidden.

Problem : When copied and edit then save the row, the timestamp of the newly saved row remain the same as the row it copied from. I need it to be updated.

Any solution?

Thank you for your precious time in advance.

[Markus_Malessa]

Typically I would suggest to use the "Reset on Edit" behavior, but that would also result the value to be reset every time the row is edited via a save button click.

I think the best solution for this is rather than setting an initial column value is to create a bot for 'Add' only and set the column value then.

[jballester]

Group of actions

• Add a new row to another table (copy to the same table and incorporate Now() in the timestamp)
• Execute an action on a set of rows ( example ANY(SELECT(Table[Id],([Id]=(MAXROW("Table","_ROWNUMBER"))))) ) and Edit as referenced Action)

[Moniker · Accepted solution]

Found a work around.
1.I leave Timpstamp Column's "Initial Value" to blank.
2.I created an action button to set that column value to Now().
3.I set the Form View event action to that action button i created.
done and thank you all for your time.

[Steve]

Not a work-around, that's a legitimate, correct approach.