How do I add data to a new row and to a previous row?

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 Solved
0 5 395
1 ACCEPTED 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.

View solution in original post

5 REPLIES 5
Top Labels in this Space