Order Line Numbers

[atusr]

Hi,

i created a table for Purchase Orders (POs), and a sub/child-table for the Order Lines (OLs).

Example:
PO-1
OL-1
OL-2

PO-2
OL-1
OL-2
Etc

What formulas or workaround do you recommend me to get a column at the OL table with the Order Line Number automatically starting again from 1 each time that the first line of a PO is created?

Thanks in advance!

[TheTimeSavingCo]

Hmm, this seems like it’d be easy enough to do but for the life of me I can’t figure out how to do this easily

The best thing I can come up a script that will set your order line numbers for you based on the linked purchase order, activated either by a button or an automation, but that seems super complicated for this

Lemme know if that’s something you want to deal with and I’ll see what I can do. Hopefully somebody else has an idea of how to do this without scripting

[ScottWorld · Accepted solution]

This thread talks about how to do this:

Automatic Sequential Numbering of Non-Sequential Items (READ JUN 9 2021 FOLLOW-UP) Show and tell

Summary This setup allows Airtable to automatically number collections of items that may not be in sequential order. Item length can be either fixed or variable, with only minor changes needed to the core system to accommodate the latter. Example To borrow from the thread that inspired this endeavor, say you’re building product codes that have a variant sub-code, and want that sub-code to automatically increment each time an item of a given product code is added in a new record. However, it n…

[Alexey_Gusev]

I’m too sleepy for longread, but i think, logic is clear (for automation) - when OL links to PO, use count of PO links to number OL. You can’t use value of PL which is not trigger, but you can evaluate it from ‘other side’ - by Find records - length

just for example (during test i decided to install ‘parent’ value)

[ScottWorld]

Great & simple solution, @Alexey_Gusev! :grinning_face_with_big_eyes: :raised_hands: :sparkles: