A solution to un-pivot table data
If this topic has been discussed and there are well known solutions to this topic - I apologize. I didn't come across any before I came up with the solution below. Background: I was working on a re...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThank you for posting. I think that just of your request is to create a row of data as a child table whenever the checkbox are checked.
An alternate solution would be to trigger a pipeline whenever the inspection record was added or edited. The first step of the pipeline would be to delete any existing children.
Then the next step would be to Search a helper table which lists all 28 possible rows, and then use Bulk Upsert and a For Each loop to create a row for all 28 possible choices.
Then have a formula on the child record to determine whether or not the child record was valid based on look ups of those 28 check boxes down to the child record.
Then the pipeline would delete children that were invalid.
Lots of ways to skin a cat! Yours definitely requires less knowledge of jinja/api and would be perhaps more approachable.
