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
Hmmm, good point. i had never had a reason to try the Grid Edit It still works the "old" way. So if you do need to search numerically in grid edit yes, you may need to flip the sequence.
But still, keep in mind that when you are selecting records, you get to control what fields are showing in which sequence for "picking records". So you may choose to have a different format being presented to the user in Grid Edit than when viewing on a form.
But still, keep in mind that when you are selecting records, you get to control what fields are showing in which sequence for "picking records". So you may choose to have a different format being presented to the user in Grid Edit than when viewing on a form.