I am working on an action that gathers a “reason” from my user using the new [_INPUT] feature that displays a dropdown. I have that working, but what I need to do is copy the users selected reason to another table, but it does not seem to be working. The input does update the initial sheet but the action that copies that value to another sheet isn’t working. My initial action is a group of actions:
My question: are grouped actions fired async or synced? If my action_get_reason_from_user is awaiting user input, does the action_update_trip_reason wait for the initial action to complete or is it firing without the initial action finishing.
They are synchronous. They are executed in order top to bottom.
There are two ways to use the INPUT() function:
As a way to gather input from a user with a pop-up form.
Pass a value between actions acting on different data sources - requires an “execute an action on a set of rows” to bridge between the two.
It sounds like you are trying to grab input form the users, save it to Table 1 and then pass that same value on to Table 2. I have never tried combining these two in a single set of actions but it seems plausible. You would need the two separate INPUT() usages to make it work.
It sounds like you have the pop-up portion working in the first action.
The second action, action_update_ trip_reason, is likely of the type “execute an action on a set of rows”. The “Referenced action” there should be the one that uses the INPUT function to assign the value to your Table 2 row(s). When that expression in the “Referenced action” is implemented, your action, action_update_ trip_reason, should then display a section to add and assign the variable values to be passed. In your case, you would assign the column where you had saved the user input from the pop-up.