LinkedIn
Twitter
Hi Guys!
Would you please suggest what I should practice following the situation below.
-
When creating an invoice, in the usual databases total item amount is not stored in the database, rather calculate using unit price and quantity.
-
different discounts such as item wise or on invoice. discounts can be by percentage or by amount. If it is percentage, then calculation come into place.
-
Invoice grand total.
Guys, please suggest me 
whether I should use virtual column or I should calculate on the user interface such as form, then store in the google sheet physical table. Because I am concerned about the performance of appsheet.
Please share your experience and suggestions. I am relying on you.
Thanks in advance.
About virtual columns, a few things things to keep in mind:
- calculations with virtual columns may impact sync speed: the less, the better
- calculation with virtual columns are always accurate because calculated โon the flyโ (provided calculations ends and app is whole synced), while physical calculations are accurate on edition only
This being said, at reading your questions ==> always virtual columns.
Good luck 
Hi Aurelien! Thanks a lot.
It seems to me, you are in favour of Virtual column. Right? So, I am.
Wish you all the best.
