Sheet function in MySql

[Ami]

Hello
Im building an app as a proof of concept for a company. Im using google sheet as my data. Right now i creating an inventory management module in which i use sheet formulas to keep an update of stock.
Should i chose to move my app to MySql, could formulas be implemented in MySql as well?

[Koichi_Tsuji]

Definitely not.

[Ami]

Thats what i thought.
So the question is, how can i sum not in a virtual column, data from other tables?

[Koichi_Tsuji]

Not sure your exact use case, but virtual column is the best place to run the calculation dynamically.

[Ami]

I know. Here is the thing.
I have a table with all products IDs and details.
A user requests a product in a form and the request is then approved, meaning that the total products in the main table should be updated to minus 1 of the original sum. This works with a virtual column, however, since my data is integrated with another softwate, i need the actual on sheet data to update.

[Ami]

@tsuji_koichi can i run a daily report that causes a data change in rows so it forces an edit thus re calculating app formula?

[Steve]

1111:

since my data is integrated with another softwate, i need the actual on sheet data to update.

You’ll need to use actions for this.

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

1111:

can i run a daily report that causes a data change in rows so it forces an edit thus re calculating app formula?

You can, if you’re okay with updates occurring infrequently rather than in near real time.

[Ami]

@Steve thanks, that is what i did, not ideal, but the best there is.