I want to create an Action button in an Asset Management App to account for when items are exchanged at the same site.
What I want to do is
1 = Change various columns in the original row to indicate is collected.
2 = Create a new row with the same address and location notes as the original
3 = Clear/change various other columns in the new row.
Such as timestamping when the new item was dropped off.
I want it so if it’s a straight swap the user can just click Exchange (action) then Save the new row.
I don’t want them to have to manually change 5-6 columns for every swap.
I’ve created a Grouped action which can do 1 & 2.
But struggling with how to do 3.
Can 3 be done in an action, or do I have to create a set of Initial Value conditions?
Or is there some other way?