Hi everybody,
I am looking for the best way to do this :
I want to fill in a form with datas from the sale of a newspaper
One field represents the newspapers I bring to a vendor
Another field represents the unsold newspapers from the previous issue that I take back
So the number of unsold newspapers should fill the previous row
How to do this as implicitly as possible?
Thanks
Solved! Go to Solution.
I think you'll need a virtual column as a normal column with a formula will only be populated when the record (previous one) is updated. A VC is always calculated any time it is displayed. Another option would be to have the column value calculated in the spreadsheet, then it will update after each sync.
User | Count |
---|---|
17 | |
10 | |
7 | |
5 | |
5 |