Forum Academy Marketplace Showcase Pricing Features

Add record number in database?

Hello Bubblers,

I am importing text records to database from a one-column CSV.
I need to number these records from 1 to N during import or after it.
I.e. imported text goes to Item_text field, and Item_no should present numbers 1, 2, 3,…N from first imported item to last. I cannot add record numbers to CSV.
Any ideas?

Regards,
Alex

Після імпорту запусти workflow з одним action “make changes to the list of things”.
Field to change: item_text field. Expression: do search for imported things where item_no is empty :count +1

Дякую, Сергій. Спробую.

It just adds number 1 to all records. Not different sequential numbers from 1 to N. There must be some kind of cycle I assume, but it does what it is supposed to do - finds 0 records in search, adds +1 and saves “1” to all items_no. Sorry, it does not work.