I have a table with 30 questions and I would like to display the current number e.g. 1, 2,30, beside each question when showing it. The issue is this list is editable. So if I have a column and have numbers 1 to 30 in the column and then a user deletes e.g. row 15, and adds a new row, then I will have numbers 1-14, 16-31 numbers which is not what I want.
I can do this using a workflow rule and google script, and anytime a user adds or deletes an entry have the script regenerate the numbers, however I was hoping there was an easier way directly in appsheet. Note the number doesn’t have to be saved in the database, I just need the current index for each entry. Is there some context variable that I can access for this?