I would make action that trigger linktoform & Updates values, but it didn't works out

Hi, i try to make an action for return a items if the delivery was cancel

I would make the user fill up the cause for the cancel using form. And its recorded on another sheet, at the same time this action also update a values of the [Status].

I have tried using group action, however only the first action works out, and it doesn’t trigger the second action.

  1. First action is used to enter a value that link to form on another sheet.
  2. Second action is used to set the Update values in this row.

Is it possible to make this kind of action in appsheet?

Once the process transitions to a form and opens it, a Group action stops.

Maybe you want to reverse the sequence?

EDITED

Or you can use an action not to open a form but add a row to another table using the data from this row action instead? Then update the status of the current row.

2 Likes

Hi thanks for your kind reply @TeeSee1 ,

I try to reverse the sequence, but its only works for the first action which is Status change action, and didn’t trigger second action (linktoform) action.

Hmmm, i need to track the reason each times our item returned to our warehouse. therefore, i need user to input a reason (dynamic values) that recorded into another sheet.

If i add a row to another table, as far i know the user can’t input the data, cause data must be taken from first form. Or do you have any idea so the user still input that data?

I think this is exactly what you want to do.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Copying-some-values-to-a-specific-row-between-three-tables/m-p/401194#M157413

3 Likes

Excellent!

After i saw your Example app, I figured it out what to deploy in my apps. And Input function helps a lot for my problem

Thank you so much for all the help!

1 Like