I am trying to make an Inventory management app, which has in-bound and out-bound products features, so products’ cost and quantity value will change when there are new inventory coming in (plan to use an average for products’ cost)
However, I see some examples from appsheet website that directly put formulas into the google sheet.
I have read https://help.appsheet.com/en/articles/961393-spreadsheet-formulas, but still don’t get it about the differences between using google sheet formula and app formula (I am quite new to the appsheet)
What are the differences between app formulas and google sheet formula?
What are the pros and cons to put formulas in the google sheet vs. app formula?
If you have useful resources or examples, could you please share or give some suggestions?
Solved! Go to Solution.
Hey @Poovich.
There are some big differences between sheet formulas and app formulas, I’ll try and highlight things below.
Computed by a server
all g-sheet formulas available (including custom formulas you might create with apps script)
Only calculated when new data hits the sheet
Computed by the end-user device
limited to only those supported by AppSheet
IF INSIDE A PHYSICAL COLUMN:
IF INSIDE A VIRTUAL COLUMN:
My general rule of thumb is this:
Treat your Google sheet like it’s a database table; it’s just a place to store data.
Hey @Poovich.
There are some big differences between sheet formulas and app formulas, I’ll try and highlight things below.
Computed by a server
all g-sheet formulas available (including custom formulas you might create with apps script)
Only calculated when new data hits the sheet
Computed by the end-user device
limited to only those supported by AppSheet
IF INSIDE A PHYSICAL COLUMN:
IF INSIDE A VIRTUAL COLUMN:
My general rule of thumb is this:
Treat your Google sheet like it’s a database table; it’s just a place to store data.
As an alternative to one or the other I offer the idea of putting the formula/calculation into Apps Script and running a trigger to update the formula “on change.” The script should be written to produce a text result back into the sheet so that it will not need to be calculated on sync.
Most of the method can be seen in this post:
[How to Integrate Google Apps Script & Trigger with an AppSheet App]
Just as a note, you probably want to be looking for the row that is edited rather than the last row. I made this mistake, but quickly realised my error.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |