[Automation] add a new row, then Move to the record

I am trying to set the automation.

In my app, there are 3 tables.

[Order table] ID_Order City
[Detail table] *auto save ID_Detail ID_Order Item Judge
[Info table] ID_Info ID_Detail ID_Order Information

Automation launched when [Judge] on detail filled in.

*Current setting

  1. If “Judge” = “Move to Info”, Add a new row to the “Info” table.
  2. All columns are inputed automatically.
  3. The view is return to “Starting View”

*What I want to do

  1. If “Judge” = “Move to Info”, Add a new row to the “Info” table.
  2. All columns are inputed automatically.
  3. Show this record with the specific view (not form view).

How can I show the specific view in the sequence of the automation?

Since the bot runs in the background, you cannot control UX transition which is only relevant in the foreground.

I actually tried setting one up by way of Grouped action, which in turn calls LINKTOROW/LINKTOFORM.

The event is called and the system gives no errors, but nothing really changes on the screen.

1 Like

Thank you for your kind advice.

Does “nothing really changes on the screen” means this combination does NOT work as intentionally even though following your instruction?

Means it does not work and it is EXPECTED. (I just confirmed my ‘logical’ reasoning )

You do not see changes that occur in the background in real time in the foreground.

The background process is not aware of your foreground environment.


Thank you.

I’ve tried to set, but seems not working.

In your screenshot, the “Grouped action” contains only 1 action.

To set the new record, need I add the action to make new record?

What I showed is very fragmentary.

I think what you want to do is similar to this which does not use a bot.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-to-Trigger-Secondary-Form-Based-on-Selection/m-p/404359#M158595

Thanks your comment.

I had try and errors, but it is difficult for me.

I’ve decided to follow this article.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Multiple-quot-row-selected-quot-event-actions/m-p/310092#M85890