Hi,
I’m new to Glide and i work a lot to use it well, but i’m stucked in a way i don’t find a solution… maybe you could help ?
I want to create a open ai chatbot based on “themes” to chat about…
first, the user add a new theme to talk about (wich populate a table called “subjects”)
after that, he can “chat” with the chatbot about the theme he created (the conversation is reported in an other table, called “chat history”
As i would like the chatbot to remenber the whole conversation in it’s chatting…
So i imagined to create a template column to construct a GPT prompt based on :
the subject (and the first chatbot answer) > This is working
the list of the previous questions
the list of the chatbot answers
the prompt is “Please answer this row question, rembering 1), 2) and 3) contents”…
To do this, i have created a lookup column called “questions history” and an other one colled “answers history”, wich are based on a Relation column that list all table rows involved in the “theme” session ID.
The problem is that when the Relation column is ticked “Match multiple” (so i can collect all the questions and answers contents) i can’t select the lookup columns in the template replacement fields: they won’t appear. They only appear when “match multiple” is not ticked (Wich you will agree, is not what i want ).
The chat is configured with history, but it doesn’t work.
Exemple : in the conversation, i write : my name is Lionel, can you remember it ?
The chat answers : of course… then i ask : “what’s my” name ? and it says “i dont know”… It only refers to the first message.
Hi Jeff,
Thanks for you quick answer ! It worked !
Thank you very much. i did use this type of column and it did not work, but i’m sure, i did so many tests, i’m sure i did something wrong !
So : now, when i say my name il Lionel, can you remember it… The chatbot keeps it in mind.
Many Thanks !
It sounds like something’s wrong with this setup though. The bot should be taking into account the context window it’s able to remember, and as you only have 2 messages there, it should remember the first one.
Hi Thinh, thanks for your new message. I was thinking too “complete Chat with history” should remember a “session ID” conversation, but when i tested it (what’s my name again ?) the bot did not rember the previous message wher i was telling it my name… Maybe i do something wrong, but i passed the week reacreating all the youtube tutos about glide and ChatGpt, without any “conversational Bot” results…
I followed the (excellent) tutorial of Robert petitto : https://www.youtube.com/watch?v=Jjgy6uO1ENE but did not success to have a conversational bot, because in this tutorial, each question asked is about the “Recipe”. My projet is little different : The user create a subjet (for ex : "How to create a Google page ? ", or “How can have more customers in my beauty salon ?” , The chatbot gives a first answer. After that, the user can click on “Go further” and he enters in conversation with the bot, where all the conversation needs to be remembered in each bot interactions. Not just the first, like in Robert’s Tutorial.
Can you show us your configurations in some screenshots/a video? Your solution should work at the start, but at one point, if you don’t limit the memory of your prompt, it will lead to fail calls because you can exceed the max tokens amount.
).
