# AI Component Limitations for Choice Selections **URL:** \ **Category:** Ask for Help\ **Created:** [February 17, 2025, 11:16pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124 "2025-02-17T23:16:25Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [February 17, 2025, 11:16pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/1 "2025-02-17T23:16:25Z")
Okay - beating my head against a wall on this one. Having success using the Glide AI component to make choice lists that can perform actions. Cool. Where I am stuck is that the only way I can get choice lists to appear as options in AI choice lists is to use joined lists. This gets me half the way there… I need to decrement the count of an item if its selected from the list. I associate the updated count to the item so the choice component lists each item name and each item count from the two joined lists item 1 name (count) \* note this lists the first values in the joined lists item 2 name (count) \*\* note this lists the second values in the joined lists and so on BUT I need to update the original item count from my items list. this is the list that provides data to the joined list i use in the component. the only value I can update is always the first row of the table. I am unable to access the row of the selected item from the list. grrrrrr. The AI will tell me the updated value that is displayed on screen but I need to know how i can persist that value so I can them run an action to update the new count in the original list. Realize its tough to explain - but I imagine someone has run across this before. signed, desparate 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 18, 2025, 12:48am UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/2 "2025-02-18T00:48:56Z")
So it does have to be updated on the click, or you can theoretically push an update later with a button? I find using JSON in your case much easier than joined lists, though, I prefer to keep as few variables as needed. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [February 18, 2025, 1:18am UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/3 "2025-02-18T01:18:03Z")
I can update it later as opposed to right on the select. Will explore the json approach. Thanks ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [February 18, 2025, 4:52pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/4 "2025-02-18T16:52:02Z")
I have created a JSON object and a json query column that populates the names of my choices. When i swap out my joined list in the AI component with the json query column i only see the \*first row listed in my choice component. \*The choice list in the AI component needs a comma separated list to populate multiple items. the query JSON column only contains single values - hence the listing of only a single row in the choice list Questions 1. Can the glide AI component make a choice list from a json query column or do i need to convert that into a joinedlist ? 2. I’ve looked through the glide docs on JSON and objects and queries and must be missing something. i have all the columns of the data i need in my items table. i don’t understand what value it is to 1- combine these columns into a new json object, then 2- create queries that filter to the specicif column - i just end up with duplicate columns of the data already in the table. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 18, 2025, 11:22pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/5 "2025-02-18T23:22:03Z")
> [@Carl\_Johnson](#): > > Can the glide AI component make a choice list from a json query column or do i need to convert that into a joinedlist ? I would suggest you starting with the JSON from scratch (with a brand new component), and actually feed a sample of it to your component so it knows how it can be queried. Else, you’re just letting it trying to guess what the queries should be (i.e column names). You should use a JSON object to convert row-level values into a JSON, then combine them together, let’s say in the Users table, with a lookup, and then another JSON object to convert it to nested JSON array. ```auto { "data": [ { "item": "item 1", "attribute1": "value1" }, { "item": "item 2", "attribute1": "value2" } ] } ``` I imagine something like that. The “library” that Glide uses has a “template” function that is built for this exact stuff. Here’s an example on using JSON. > **[Thinh Dinh on LinkedIn: Glide's AI Component continues to amaze on how...](https://www.linkedin.com/posts/thinhcdinh_glides-ai-component-continues-to-amaze-on-activity-7275497740023832576-POmh)** > > Glide's AI Component continues to amaze on how versatile and reusable they can be. > > Today, a LowCode Agency client asked me if Glide's Fields component can… ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [February 19, 2025, 6:19pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/6 "2025-02-19T18:19:04Z")
thanks for the help. i got this working using a look up in users from the original table. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [February 21, 2025, 2:41pm UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/7 "2025-02-21T14:41:36Z")
btw - i checked out this again - and now that I am more familiar with JSON objects - I see how powerful this approach is generically. Definitely in my bookmarked Glide list. thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 22, 2025, 12:25am UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/8 "2025-02-22T00:25:08Z")
Yes, definitely my favorite way to build with JSON. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 1, 2025, 12:25am UTC](https://community.glideapps.com/t/ai-component-limitations-for-choice-selections/80124/9 "2025-03-01T00:25:39Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.