Create multiple rows from a single enumlist using webhook

AppSheet AppSheet Q&A
, , ,
1

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]>>”
},
<>

2

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.

3

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.

4

Ok?