TimT
4 years agoQrew Trainee
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 runs to generate a new step that is then automatically related to the Task.
I am trying to find a way to make a formula field in the Steps table that says whether this is Step 1, Step 2, Step 3 in accordance to its Related Task. I keep getting stuck as to how to make this happen, i hope someone can help me out!
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 runs to generate a new step that is then automatically related to the Task.
I am trying to find a way to make a formula field in the Steps table that says whether this is Step 1, Step 2, Step 3 in accordance to its Related Task. I keep getting stuck as to how to make this happen, i hope someone can help me out!