I asked ChatGPT for a solution, I need to split an enumlist and add each selection to a new row. It got quite close but the solution adds each selection to a new column instead of a row. The solution is below, would any of the 'Human' gurus take a look and suggest a change so it returns what I need. I've been on this all week ...
Many Thanks
Hey,
here you go man, the humanized version ๐
https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/357133
Great, so I got this to work. The Control table is the same as the target table. Which means the untouched result from the EnumList still exists in the first row. Quaestion is how do I remove that row:
Hey,
like this:
Slightly different as I have to call the group action later in a form save event, so i have to loop through the records and only select the row where [JobID] = [JobID and the enumlist is not blank:
SELECT(Ticksheet[ID], AND([JobID] = [_THISROW].[JobID], ISNOTBLANK([Other Description])))
It's taken some doing.... but thanks
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |