Adding Line items numbers to a record....read on.

Question

I have an existing list of line items in a table. Thru a pipeline these lines items are bulk added to a Parent table Order header record. Is there a way to assign a unique line item #'s to each order's line item, starting with line item # 1. (so can't just show record id for each line item). The catch here is that that the user may add a line item individually (not in batch with the pipeline) to the order and that added item must equal the last line item # plus 1.

------------------------------
Cloudbase Services
------------------------------

markshnier__you · Answer

Try this as a Formula Query for sequential Line numbering

var text QUERY = "{20.EX.'" &amp; [Related Job] &amp; "'} AND {3.LTE.'" &amp; [Record ID#] &amp; "'}";Size(GetFieldValues(GetRecords($QUERY),3))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

georgebramhall2 · Answer

Of course...a query formula. Thanks Mark!!------------------------------George Bramhall------------------------------

georgebramhall2 · Answer

I just noticed that if I add a line item to the PO that may have a Record ID that is not greater than the last item that the added item is not added as the last item # but rather gets inserted in order of the record ID's shifting all other line items down one. Is there any way for these occassions where a line item is added after the fact that the new line item is now = to last item number plus one leaving all othe other line items at the same line item #?

------------------------------
George Bramhall
------------------------------

markshnier__you · Answer

Well normally, PO Lines lines are added to Purchase Orders by creating a new PO line records and adding them as child to the Parent PO header in sequential fashion.

Do you have a situation where PO lines are created and then later associated with a PO Header?&nbsp;
If that was the case then we would need a process to capture the date and time when that PO Line became associated with the Purchase Order header record and have the formula query look to that field.
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Adding Line items numbers to a record....read on.

4 Replies