Skip to main content
Question

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

  • August 21, 2023
  • 0 replies
  • 154 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Try this as a Formula Query for sequential Line numbering

var text QUERY = "{20.EX.'" & [Related Job] & "'} AND {3.LTE.'" & [Record ID#] & "'}";

Size(
GetFieldValues(
GetRecords($QUERY),3))



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------