Create Numeric Identifier on Child Record

Question

I'm trying to number specific child records based on the parent record.

So for example, parent record has a record ID # 10. I add 3 child records. I'd like to number those child records 1, 2, 3 within a specific field I could use for reporting. How would I accomplish creating that field?

Many thanks!

------------------------------
Sheila Allas
------------------------------

MarkShnierYou · Answer

If you can ensure that you will never delete child records, then you can

Make a summary field of the # of Child records.
Look that up down to Children and call it [# of children (lookup)].

Then make a new field called SEQ and set it to be a snapshot field of [# of children (lookup)].

Note that this technique will only work on a going forward basis. It will not sequence existing records.

If you have knowledge that there will only ever be a small number of children, say under 10, then there could be another technique I can explain which will work for existing records.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community