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 |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |