-
Goal: Show users in a custom form
-
Steps: Create a Query, show data in the table and create a custom form without
-
Details: I am firing a plain SELECT query and expecting that the data will return in an Array e.g.
[
{
"id":1,
"name": "John",
"age": 28
},
{
"id":2,
"name": "Baron",
"age": 32
},
]
instead, when I do query.data, I see that each field is wrapped in a array e.g.
[
"id": [1,2],
"name": ["John", "Baron"],
"age": [28, 32]
]
See the screenshot below for actual response.
So when I have to assign default value to a Custom Field, I have to use the following syntax:
getPersonData.data.name[0]
instead of a normal way:
getPersonData.data[0].name
Is this the way data is actually handled in Retool or there is some problem?
- Screenshots:
