My query columns are not displayed in the layout.
I use queries in my Glide tables. If I want to display a component such as text, a field or a list in the layout, all columns are available except the query columns. How can I use the query columns in the layout?
In my case, the query is intended to provide the correct answer based on three categories. The appropriate advice on gardening is to be selected based on month, temperature and weather.
Are there other methods for this? How can I avoid multiple relation?
Many thanks Bertram
A query (as well as a relation) is a link to rows. What you see is a representation of rows. Not a specific column in those rows.
Also, a Query is similar to a multiple Relation, so the potential is always there to link to multiple rows. With that, a Lookup column (which will return a specific column from a query or relation) will always be an array.
Regarding arrays, you can’t place an array (which can contain multiple values) into something that can only hold a single value, such as a text component.
If you had a single relation you could use a lookup column to retrieve a single value from that relation. With a query or multiple relation, your options are to use a Single Value column, which will return a single value from a single row, or a Joined List column, which will return all values from a single column in all rows, as a single comma delimited value.
TLDR…
Add a Single Value column to retrieve a specific column value from your query.
2 Likes
Hi @Jeff_Hager,
thank you for your advice. For me the Single Value column did not work, it was still the same issue. But with your help I found a work around. With a template a combined the three serch criterias in one field. Soi I had an identifier that I could generate in the same way in the data table. Finally I used a filter in the layout table to show only values with the identifier.
Thanks also to ibrahim17 and @Hassan_Nadeem
Regards Bertram