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.
e.g. [Status]=“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?
How about this path…
Stick with your Grouped action for 1&2, and add a form launch to that action… that form launches to the New Row … filled in with the data from the active row…
appsheet.com - Linktoform Example - This app shows how to link to a form and fill in default values Linktoform Example - This app shows how to link to a form and fill in default values appsheet.com
If I understood your request, you should be able to do it with one LINKTOFORM action.
@David_Hopkins That worked beautifully thank you.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |