I created records using an inline form in the following order:
1
2
3
4
5
However, when they were written into the table in Google Sheets, they appeared in this order instead:
2
1
5
3
4
I need them to be written in the table in the same order they were created in AppSheet. Is this possible?
If not, what alternative method can I use to sort them in the view so they appear in the correct order?
You could possibly use a relevant column to sort the inline view records to be shown in the summary view in the order you wish to have. When you say you wish to have a certain order of records , there should be some column that identifies that certain order. You could use such a column as a sort column in the summary view?
I think there isnโt another column that could be used for the sorting I need. The records are payment amounts that I have on paper. After I create them in the app, another person verifies that the amounts were entered correctly. However, since they appear in a different order, the verification process becomes difficult.
Please try adding a datetime type physical column called something like [Record_Added] with an initial value of NOW(), editable_if as FALSE and then please sort that inline view by [Record_Added] column in ascending order.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |