Best format for Unique Number Generation
I am in need of unique numbers for multiple different tables and am wondering what the best format is for the structure. So far I know that I will need to track a letter to correspond to the table...
Forum Discussion
I would put the [Record ID#] portion last and I would suggest for human readability having some dashes or at least a space to separate the elements.
Q-18-03-1234
I would also suggest to zero pad the month like i did above
Q-18-03-1234
I would also suggest to zero pad the month like i did above
The new type ahead drop down record picker (which you probably have not experienced yet) is wonderful because it is essentially a live "contains" search regardless of the position of the numeric portion of the string. You can request early access now by putting in a support ticket.
But because that is imminent, you should have the record ID portion last for human convenience.
There is no performance difference for Quick Base.
But because that is imminent, you should have the record ID portion last for human convenience.
There is no performance difference for Quick Base.