Issue with OpenAI "Ask About a Table" Functionality in my Glide App

Team ID:

  • In the Glide dashoard URL, e.g.
    https://go.glideapps.com/o/VG3BxpblfZTs2CULM4b4/

App ID:

  • In the Glide builder URL, e.g.
    https://go.glideapps.com/app/iW09LOK1TSLwi5lFdLpn/layout

Description
Hello Glide Community,

I hope you’re all doing well! I’m reaching out because I’ve encountered an issue with the OpenAI “Ask About a Table” functionality in my Glide app, and I’m hoping to get some assistance.

I’ve been using the “Ask About a Table” feature to enable users to ask questions about data in a spreadsheet connected to my Glide app. However, I’ve noticed that the responses generated by the OpenAI model are often inaccurate or incomplete, providing incorrect answers or missing relevant information.

For example, when I ask the model to identify the number of crops or beds listed in my farm spreadsheet, it frequently fails to detect all the items present, giving significantly fewer results than what actually exists in the data.

I’ve tried various troubleshooting steps, including ensuring the data is well-formatted and providing clear instructions to the model, but the issue persists. As a result, this problem is hindering the functionality and usability of my app.

I would greatly appreciate it if someone from the Glide team could take a look at this issue and provide guidance on how to resolve it. If there are any adjustments or improvements that can be made to the OpenAI integration or if there are alternative solutions available, I’m eager to explore them.

Thank you for your attention to this matter, and I look forward to your assistance in resolving this issue.

Best regards,

How to replicate
-Call the open AI Ask about a table functionality .

I think it’s not the intended use case (aggregation of data).

Please check what David said here.

Hi Anas! Do you have answers already in the table so AI can just find those values? Because I would not expect AI to do any analysis or calculations… It can only find info that is already exists in the table… At least that is how I understand this function is intended to work :woman_shrugging:

Thank you for your reply ! Do you know any other way (no matter how hacky it might be) to perform this (searching a glide table which is a google sheet and have the AI answer questions about that data)

I saw that zapier launched a new functionality called zapier central that does exactly this but unfortunately I can’t seem to integrate it with glide .

Any help would be much appreciated !

How many rows are we talking about here? Most straightforward way to me is inserting the data right in the prompt, but it may easily surpass the tokens limit.

About 500 rows. I’m sorry but I don’t get what you mean by inserting the data right in the prompt, are you talking about the source table you give the the "ask about a table " functionality ? because I already did that. If you mean something else please let me know !

I mean using some sort of a joined list and insert the data straight in your prompt with a template column, but if you have too much data then that might not be a good option.