Synchronize sums of values between two tables using a bot

[Izzat_Safrah]

Hello everyone. 

I'm looking for a way to automatically update inventory itself in the spreadsheet when purchases are added to the same item

Currently, only totals are shown using a virtual column and are not shown in the spreadsheet.

The virtual column works but then the correct sum is only shown in the app. The table is not updated until you edit and save again.

Is there a way to update the [STOCK TOTAL]?

______________________________

• IN Table "STOCK" I'm looking for a way to automatically update inventory itself In Column named  [STOCK TOTAL]

• In Table "PURCHASES"  there is a Column named [CODE] it Ref  from Table "STOCK"

______________________________

• IN Table"STOCK" I used a virtual column named [TOTAL] to calculate purchase totals for the same item In Table "PURCHASES"

• Table "PURCHASES"

______________________________

• Tables in UX

______________________________

NOTES:

Its working only by  AUTOATION  Schedule/Daily

And what i'm looking for to update it at same time when i add new purchas

Regards 🙂

[1minManager · Accepted solution]

Yes.  So in every form view you have the option to specifiy an action to run on save.  You'll need to create an action that does the same as your bot.  Checkout - https://support.google.com/appsheet/answer/10107706?hl=en&sjid=9339519957457044615-EU#

Simon, 1minManager.com

[Lynn · Accepted solution]

@Izzat_Safrah  As Simon says,you need to tie your Action to "On Form Save"

[1minManager · Accepted solution]

Yes.  So in every form view you have the option to specifiy an action to run on save.  You'll need to create an action that does the same as your bot.  Checkout - https://support.google.com/appsheet/answer/10107706?hl=en&sjid=9339519957457044615-EU#

Simon, 1minManager.com

[Izzat_Safrah]

Hi, @1minManager 

If i create action it will not update it by itself. I have to manually click on the action icon.

• This My Action Steps  ↴

______________________________

• Here Is What The Action Looks Like  ↴

[Lynn · Accepted solution]

@Izzat_Safrah  As Simon says,you need to tie your Action to "On Form Save"

[Rifad · Accepted solution]

You need to use another action to execute this action in purchases table using Data: execute an action on a set of rows

[Izzat_Safrah]

I follow your steps and Its working berfect.

@1minManager  @Lynn  @Rifad 

• This My Action Steps ↴

______________________________

• Here Is What The Action Looks Like  ↴

______________________________

Thank you for support 🙂

[LeviP]

Hello, 
what happens when you delete a record, it doesn't update the stock

[Izzat_Safrah]

" For delet record "

Need these steps to create bot with action.