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.
Quick Base is not difficult. Except that there are like hundreds of easy things to learn. So you need to stumble hundreds of times once. Now you know this trick and hopefully you just need to stumble once per nugget learned. Or else watch all the videos in the Quick Base University. https://university.quickbase.com/