Automation run an action based off changes to a different sheet

I am making an app for personal use that tracks inventory and usage of items. One form updates an inventory table upon saving the form. 

I have a separate table that also needs to be updated based on the form that updates the inventory table, but I have to run this action manually. I'd like this to be an automated process based on changes to the usage log table. I am having a hard time finding resources to solve my problem. I am completely new to this and have 0 coding and development experience. 

0 4 139
4 REPLIES 4


@thebigJLT wrote:

I have a separate table that also needs to be updated based on the form that updates the inventory table,


In general for such requirements, one uses the reference actions.

Help article : Actions: The Essentials - AppSheet Help

The relevant excerpt from the article is in the screenshot below

Suvrutt_Gurjar_0-1733913444244.png

The sample app  Reference Actions - AppSheet from the help article Sample apps

The excerpt of the description of the app at Information/ App Documentation/Purpose is as follows:

"This app shows how to use reference actions. Reference actions are used to modify a row in one table via an action defined on another table. In this example, we have a Parent table and a Child table. The Parent table has an action called "+1 All" that adds 1 to the Number column of its associated children records. Try it out."

 

 

 

I appreciate your response, but I don't believe this will solve my problem, though. I have the actions/reference actions created and they work as intended. This issue at hand is that while one will run after saving the form, the other must be run manually. I cannot do a grouped action as they are on different tables. 

Is there a way to automate running the second action based upon changes to the usage log form? 

Al parecer tienes el mismo problema que yo, Imagino que tienes 2 tablas una referenciada a otra algo como Inventario y DetalleInventario la cual deseas que cada vez que ingreses registros a la tabla DetalleInventario la tabla principal Inventario haga el conteo de x cosas; si es asรญ necesitas tener dos acciones, la primera que calcule o haga lo que desees y la segunda que dispare esa accion mediante un bot.

Steve
Platinum 5
Platinum 5

@thebigJLT wrote:

I cannot do a grouped action as they are on different tables.


Sure you can, and @Suvrutt_Gurjar told you exactly how to do it.

Top Labels in this Space