Create multiple rows from a single enumlist using webhook

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>>

0 3 123
3 REPLIES 3

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?

Top Labels in this Space