Title | Result |
Currently not used but later for Filtering | JSON-Array |
{
"Data": [
{
"Choices": "YES;NO;MAYBE",
"ColumnType": "Form 1",
"Data": "YES",
"FormName": "Form 1",
"QuestionNR": 1,
"Requried": "Yes",
"Title": "Would you recommend this Pizza?"
},
{
"Choices": "YES;NO;MAYBE",
"ColumnType": "Choices",
"Data": "MAYBE",
"FormName": "Form 1",
"QuestionNR": 3,
"Requried": "Yes",
"Title": "Would you recommend this Pizza?"
}
]
}
Clear(colNewTable);
ForAll(Datasource As X,
Collect(colNewTable,
ForAll(Table(ParseJSON(X.Result).Data),
{
Choices: Split(Text(Value.Choices),","),
ColumnType: Text(Value.ColumnType),
Data: Text(Value.Data),
FormName: Text(Value.FormName),
QuestionNR: Value(Value.QuestionNR),
Requried: Text(Value.Requried),
Title: Text(Value.Title),
FilterID: X.Title
}
)
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.