—the details of my case—
condition : i have database which will be written by users. and i want to use dataviewer to show the db. (user can click to see the detail of each item, or can change/delete if he/she is the writer)
the feature i need is ‘sorting’ and ‘filtering’ (to spreadsheet)
- sorting table : recent scheduled ones in first, and future ones in last (about schedule they wrote. not the time data saved)
- make several filtered clone sheet : so that user can view each specific type of data)
as you guys know, when i use ‘sort’ or ‘filter’ formula(/function) in google sheet, it needs original sheet.
so i may use datasource as original sheet, and make new sheet(s) using formula to project to dataviewer(s).
in that case, if user pick an item, the app needs to follow original row so that modify or delete the values. so i need to record each row id (of original data).
BUT , unlike what I expected, if original data deleted, then somehow row id doesn’t work as before. the value of row id changed.
and similarly, if i created new row to original sheet and if that row will be sorted in the middle of viewer sheet, then it doesn’t work what i expected too.
oh, and if i reboot the app, the row id comes back!! to what i expected.
for my understanding now, row id follows an order not the value.
sorry for not uploading screenshot.
but please let me know when the bug fixed. and what is the characteristic of row id, and what i have to do.
thank you for reading this. and always pulling for thunkable team.