Order Line Numbers

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!

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

1 Like

This thread talks about how to do this:

1 Like

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

image

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

1 Like

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

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.