Hi! Hello! I’m new, help please! Can i add the last value of the row of specific parameters? For example., I have the table:
Date People fruits vegetables
25.06.2019 Stanley 5 55
28.09.2019 Ivan 6 44
I need this - Ivan will decide to add a new fruit. in the row will be - 6. Stanley will add vegetables - the value “55” will be suggested in the row of vegetables.
In this link author says simply how to add the last value of a row
https://www.appsheet.com/samples/Initialize-forms-with-most-recent-value?appGuidString=18b39921-b8a8...
please, help me)) sorry for my English))
Welcome!!!
Did you check out the “Look under the hood” link? If you click this you can see how the app is put together; under Data>Columns you can see there’s a virtual column that’s using the MAXROW() formula to find the last row entered.
You can read more about maxrow() here:
Then in the initial value space, they used a de-reference formula to pull values from the maxrow() result.
You can read more about de-reference formulas here:
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |