How to create an auto-number for a item label
We have searched QuickBase and the Internet and found nothing useful so here's to hoping someone has something useful to share. We are creating a printable form. One of the items on the form is an...
Forum Discussion
You have not really described you table and their relationships, but the usual trick is to do a summary field of the # records and then look that up back down to the child table. Then create a new field which is a numeric field type and edit its field properties to make it a snapshot of the lookup field. That snapshot will stay frozen once snapshotted and not change when the next child is created.
That field property setting is at the bottom of the field properties page. Note that it will not retroactively fix existing records. That snapshot is frozen when the record is saved.
That field property setting is at the bottom of the field properties page. Note that it will not retroactively fix existing records. That snapshot is frozen when the record is saved.
Ahhhhhh!!! Thanks, I couldn't find this little nugget.
Then create a new field which is a numeric field type and edit its field properties to make it a snapshot of the lookup field. That snapshot will stay frozen once snapshotted and not change when the next child is created. That field property setting is at the bottom of the field properties page. Note that it will not retroactively fix existing records. That snapshot is frozen when the record is saved.