Forum Discussion

TimT's avatar
TimT
Qrew Trainee
5 years ago

Formula for a field to label which order it is in

Hello, I have two tables, Parent table Task and child table Steps. Each Task has an initial step assigned to it via pipelines and when the user selects an option in the Step form, another pipeline ...
Formulas and functions
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Since you seem to be comfortable with pipelines, probably the easiest way is to make a summary field on the parent table to count the number of children and look that up down to children as [Current Step Count].

Then when a Step is created have the pipeline copy the value of the [Current Step Count (lookup)] into a scalar data entry field called [Step number].

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------