I am using Google forms to add participants to a list, but Google forms do not automatically add incremental numbers, for example in my form it only add Timestamp, Member name and timestamp.
Now, the first entry will be placed in Row 2 (as the first row is used for headers in the Google Sheet.
I need a code that display the row number minus one as the entry number.
Thanks, I am using that at the moment, but, it is not "user friendly" as I would like the app to seamlessly integrate with sheets, without other custom formulas. I know how to do it, but a sports coach might not be so computer literate
In which case, call down your data from google sheets, and convert to a list.
Use the indexing in the list, just remove 1 from the index of an item (exclude the first item) and insert this as the first item for each response. You should end up with: