Make an action happen automatically when a new row has been added to a table

ae_daniel
Participant III

0 11 675
11 REPLIES 11

LeventK
Participant V

@ae.daniel
Are you accomplishing the first part via formโ€™s Form Saved Event action property?

Unfortunately I couldnโ€™t figure out how to do that, I am doing the first part with excel.

@ae.daniel
You can achieve what you want with a 2 step workflow rule as well. No need for spreadsheet formula(s)

I hit a road block a while back trying to figure out workflows


It doesnโ€™t give me any options when it asks me for the action and I donโ€™t know that to do about that

LOL ok wow, so I figured out I have to have an action to assign (I am in no way a programmer lol, I am just a social worker trying to figure out how to make some simple inventory tracking more automated to free up my staffs time). Now if I put the action as an overlay the action is doing EXACTLY what I need it to, but the problem is that you have to go to each individual item and apply the action, and the other problem is, you can hit the action twice or more, thus removing a one time inventory change twice or moreโ€ฆ Which is exactly why I want the action to be automated. Well Iโ€™m there now, the action works, but I am having trouble assigning the triggerโ€ฆ

ae_daniel
Participant III

Ok, more specifically, how do I make a workflow that uses changes in one table to trigger an action for another table?

There are a couple of ways to do it:
1.) You can use a DataChange Workflow rule to trigger an action for the target table
2.) You can use Webhook Workflow rule to trigger an AppSheet API Edit preset, where when edited, assigned actions will be triggered, AppFormulas will be re-calculated, any workflow rules assigned will be run automatically.

ae_daniel
Participant III

So as I have gotten a little bit better at using the platform, I have a slightly better idea of what I am trying to do and why I canโ€™t do it.

When I add a new row to the โ€œfood packagesโ€ table, I want the action that updates the โ€œquantityโ€ column to be triggered. But the app doesnโ€™t understand there is a relationship with the numbers in the columns across tables. Because I have that relationship defined in the spreadsheet but not the appโ€ฆ

Ok lol, so I didnโ€™t previously understand most of the directions you were giving me, because I was too novice at using the platform So I now understand I can accomplish the same thing if I define the relationship in the application using references. But that kinda means scrapping a lot of work Iโ€™ve already done I think I still have questions about this, I had found a work around, but it adds a vital extra step (that I canโ€™t figure out how to require) that my team might forget and it kinda muddles the whole point of having this tracking application haha

Hi @ae.daniel
Do you have a new question?

Oh yes, more like a request for direction, LeventK had mentioned to me when I originally created this post about the 2 step workflow rule, well I had no idea what he was talking about as I had not yet explored the function of workflows.
But I am thinking I can do this more simply than that,
when a new row is added to โ€œFood Packagesโ€ โ€”> Trigger action that multiplies each [Food Inventory]โ€œIn packageโ€ value by the value of new row in [Food Package]โ€œQuantityโ€ โ€”> Trigger action that takes that the result of that equation and subtracts it from [Food Inventory]โ€œQuantityโ€.

But that is doing a math function across two tables and I have NO idea how to accomplish that.

@ae.daniel
What kinda math functions?

Top Labels in this Space