Hello!
I regularly have to export lists of entries of different lengths from a database as a PDF. It would be very nice if there was a way to assign a consecutive number (1, 2, 3, …) to the entries (lines of the list) during export.
It sounds very simple, but I haven’t found a way yet.
Thank you very much for your help!
Hi Just,
You’d need to add a Number field to your form and enter the values in manually. You could create the list of consecutive numbers in Excel in one big list and copy them to the clipboard. Then in Tap Forms, switch to the multi-column list view. Then click the first row of the newly added Number field column and paste in the list of numbers from the clipboard. Tap Forms will paste each number into the different records within that field’s column.
Then you could turn on the Auto-Increment switch of the Number field which will then create an incremented number each time you add a new record in that form. You can control what the next number will be when a new record is created, so set that value to 1 + the maximum number you pasted into your records from the above instructions.
Thanks,
Brendan
How about a saved search that contains the records to be exported. And then use a script to assign the numbers?