@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
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โฆ
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.
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?
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |