I want to create an Action button in an Asset...

(Simon Robinson) #1

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?

(David Hopkins) #2

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

(Aleksi Alkio) #3

If I understood your request, you should be able to do it with one LINKTOFORM action.

(Simon Robinson) #4

@David_Hopkins That worked beautifully thank you.