I want to use an AI Generate Text column in Glide to rank the importance of rows (1-10) in a 10,000-row table.
The ranking would be based on the row data and the user’s profile data, which updates dynamically as users interact with the app
Would implementing this be impractical due to the potentially massive token consumption and update counts it might generate?
Any advice on how to handle this more efficiently or alternative approaches ?
I think the biggest challenge at the moment for anyone reading your post is to try and understand what you are trying to achieve, because there is no enough context in your post. I think you will find that what you are trying to achieve can be achieved with ITE columns and the query column. I have seen people do wizard-like stuff with Glide even before AI came to town. My advice, open up about what you are doing, what you have done thus far and what is your end goal and you will get the help much quicker.
I am trying to sort events in an events table so that I can suggest them for particular users according to the user journey on the app and their profile details.
I don’t want to do it using ITE columns and ratings and points according to certain conditions because the client wants to integrate AI for that.
I’m also interested in further understanding the pricing of AI columns and the way Glide users usually use them and whether anyone has taken the risk of using them with data that changes very often and on a large number of rows.
Every time a cell in an AI column changes due to the source data changing = 1 update per cell. …for a 10k row table = 10k updates. Proceed with caution.
For that specific reason, it’s too dangerous to apply AI for something like this…
Also from my experience, it’s not that great to use AI to give a numeric rating to stuff as well.
Yes i guess its too costly.
I actually gave it a test trial and it wasn’t that bad with regards to rating.
I actually said, rate from 1 - 10 with an explanation. Having looked at a few explanations it seemed like the reasoning wasn’t very bad.
Note that my rating doesn’t have to be very exact, its just rating suggestions to give to a user so it really doesn’t matter that much how precise the rating.
Anyway will avoid using the AI column for this for the mean time and working on building my own rating depending on user past interaction and queries.
Due to the update issue I have been building a table for a separate form and placing the AI columns there. Then I give the user the option to use AI to to accomplish a task (create an email, analyze a file, etc.).
So is your solution only generate on demand?
Right now yes or as part of a workflow. My clients tend to be smaller businesses that have concerns about extra charges for excessive updates.
Might be the best option