Hi Everyone, I have an external API which returns data in JSON format. I want to put this data into a selection field inside Glide. The selection should also filter by the paramters which I can pass to the API. I have seen some discussions on the forum about creating an Helper table but in my case each user can have a separate set of list which will be based on the search parameters that will be passed to the API, which will then return the items that I need to display on the selection field. Please let me know how can I implement this. Thank you
By “selection field” do you mean a choice component?
A helper table usually uses user specific columns, so each user would see something different.
You could also consider creating a custom AI component that reads the JSON and creates a dropdown from that.
@Jeff_Hager yes I mean selection field
The helper table is usually user-specific anyway like Jeff suggested, so this works in your favor.
But recently I have good success using AI components in place of choice components in relatively complex use cases like this, you can also try it and feed it an image of the Glide choice component so the “look” can be consistent.