# \#query **URL:** https://community.glideapps.com/tag/query/46.md [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) --- ## [Is is possible to use a single value column on the results of a query?](https://community.glideapps.com/t/is-is-possible-to-use-a-single-value-column-on-the-results-of-a-query/79866)
**Author:** [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)\ **Replies:** 9\ **Last updated:** [February 8, 2025, 3:29am UTC](https://community.glideapps.com/t/is-is-possible-to-use-a-single-value-column-on-the-results-of-a-query/79866 "2025-02-08T03:29:39Z")
I have a necessary query column in a table. Each row of that column contains a list that is the results of the query. Is it possible to use a single value column/from start and index directly into that list? I want to tr… --- ## [Query with random sort?](https://community.glideapps.com/t/query-with-random-sort/78032)
**Author:** [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Replies:** 13\ **Last updated:** [November 20, 2024, 5:01am UTC](https://community.glideapps.com/t/query-with-random-sort/78032 "2024-11-20T05:01:06Z")
I’m not sure if I’m missing something but can anyone confirm whether you can run a query and select the sort type as random? I’m not seeing this option. --- ## [Cannot use query as source for lookup field](https://community.glideapps.com/t/cannot-use-query-as-source-for-lookup-field/76700)
**Author:** [@Bleu.Elefant](https://community.glideapps.com/u/Bleu.Elefant)\ **Replies:** 2\ **Last updated:** [September 30, 2024, 12:57am UTC](https://community.glideapps.com/t/cannot-use-query-as-source-for-lookup-field/76700 "2024-09-30T00:57:31Z")
I am trying to use a query field as the source of a lookup, why does this not work. I am on free plan. --- ## [Collections not listing by Query sort order](https://community.glideapps.com/t/collections-not-listing-by-query-sort-order/76353)
**Author:** [@ScottLLC](https://community.glideapps.com/u/ScottLLC)\ **Replies:** 11\ **Last updated:** [September 14, 2024, 5:15pm UTC](https://community.glideapps.com/t/collections-not-listing-by-query-sort-order/76353 "2024-09-14T17:15:36Z")
I have a table that i am trying to group by descending date and then within that group sort by a billing code alphabetically. The underlying billing code data is not in any kind of order in the raw table. I understand … --- ## [Removing Dependency on USER Table for Dynamic Form Visibility and Navigation](https://community.glideapps.com/t/removing-dependency-on-user-table-for-dynamic-form-visibility-and-navigation/74691)
**Author:** [@Namra](https://community.glideapps.com/u/Namra)\ **Replies:** 4\ **Last updated:** [July 9, 2024, 12:34pm UTC](https://community.glideapps.com/t/removing-dependency-on-user-table-for-dynamic-form-visibility-and-navigation/74691 "2024-07-09T12:34:51Z")
Hi, I previously posted this question, but the solution did not work. I am now posting a detailed version. I have a button, “DisplayForm,” on a screen that makes the form of Table A visible. This visibility is dependent… --- ## [JSONata Advanced Functions: $filter, $exists, $not, $map](https://community.glideapps.com/t/jsonata-advanced-functions-filter-exists-not-map/72468)
**Author:** [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)\ **Replies:** 0\ **Last updated:** [April 10, 2024, 8:53pm UTC](https://community.glideapps.com/t/jsonata-advanced-functions-filter-exists-not-map/72468 "2024-04-10T20:53:42Z")
Glide uses JSONata in to query JSON in the Query JSON column. I’ve understood the simple syntax of mapping through arrays and objects. $rows\[2\].Name - Returns the name of the 3rd item in the array $rows\[\].Company.Name …