Hello there,
I want to create multiple rows from an EnumList of a single record using webhook. I tried this method long ago in which there has to be some dummy records available in main table. Can someone help me if I don't want dummy records?
Here is the expression I am using:
<<Start: TOP(ORDERBY(Inspections[ID],[_ROWNUMBER], FALSE), COUNT([_THISROW].[List]))>>
{
"ID": "<<UNIQUEID()>>",
"Question": "<<INDEX([_THISROW].[List], [_ROWNUMBER] - 1)>>",
"Date": "<<[_THISROW].[Date]>>",
"Shift": "<<[_THISROW].[Shift]>>",
"PID": "<<[_THISROW].[ID]>>"
},
<<End>>
You're asking for a workaround for the workaround? The workaround wouldn't exist if there was a better way, now would it?
You don't need "dummy" records per se, you just need a table with enough records to accommodate for the max possible size of your enumlist.
I see no reason why you shouldn't keep doing what you're already doing.
If I add table with enough records then I'll have to use that table in my Start Expression. Then the problem will be to get the Date, Shift and PID.
Ok?
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |