Forum Discussion
Here is a similar thread to this topic that covered something very similar:
https://community.quickbase.com/discussion/autogenerating-number
The suggestion would be to use a formula-field to generate a formula version of the field and then copy that value using a pipeline so it remains static/stored.
------------------------------
Chayce Duncan
------------------------------
- MarkShnier__You2 years ago
Qrew Legend
Or just suffix it with the Record ID#. It will be unique and in sequence from low to high, but not sequential. Maybe it does not really need to be sequential?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- MichelleL2 years agoQrew Trainee
That was my plan from the get-go, but someone asked if we can do it the other way, and I said I'd figure out how, not realizing that it would be far more complicated than I anticipated. But I've reverted to the original numbering convention now, after going down a rabbithole of similar threads yesterday!
------------------------------
Michelle L
------------------------------