Hey there!
Since I couldn’t find anything similar to my question I hope someone here can help me.
In my database I did an “ID creation”-form. Now I want to add the possibility to create more than one ID with the same beginning so the person creating the IDs doesn’t have to run the form x times, but could say “run x times”.
Formular for “fieldname”: concat(field(‘Bundeslaender’),‘‘,field(‘Kfz-Kennzeichen’),’’,right(concat(‘00000’, row_id()), 6))
Formular for “quantity_IDs” at the moment: if(field(‘quantity’) > 1, ‘true’, ‘false’)
It should be something like if(field(‘quantity’) > 1, add new rows with same ID beginning until reaching ‘quantity’, just add one row)
For example if I create an ID with “Bundeslaender” “BW” and “Kfz-Kennzeichen” “00S” with quantity 5 I would expect to get the IDs “BW_00S_000004”, “BW_00S_000005”, “BW_00S_000006”, “BW_00S_000007” and “BW_00S_000008”.
Thank you for your help!