Instruct LIM to ask some questions in sequence and then perform API call based on the user answers

[QA-TonyHe]

Here is the detailed scenario:
I want to get the basic infomation of the user: name, age, gender, job.
to improve user experience, I prefer the LLM ask questions one by one to collect these data, rather than ask theuser to provide all these information at once.
after got the user basic info, I want to cell API to store this user to DB, the method I can think up is by custom function tool,

But I have trouble using the existing node,because it involves variables passing through chain and agent.

Can help work this out? thanks ahead.

[mdlmarkham]

To clarify - you want the AI to converse with the user and determine precisely what it is that they want to know, and then you want to use a tool to store this information to a database?

[Panconjugo23]

I'm also interested in that topic. Did you guys find a solution for this?

[gauravkaliadev]

Is there anything we can use in Flowise to achieve this?

[andydukes]

Hi, I responded to a similar question on discord earlier (copy below). Let me know if you still need help and I'll write some notes up.

• I’ve literally just got this solution working after a couple of weeks configuring and tuning so that part of my flow asks the user a series of questions, receives the answers, is able to verify that the user response is appropriate, and cycle through a list. while retaining the responses, after which it can kick off actions and execute tools based on the responses and also hand on to other agents etc.
  I will try and write up some notes and tips (and some cheats) next week and drop them to you if you are still in need of help / ideas?

[gauravkaliadev]

Hi, Thanks for responding. I have spent a few days myself to explore the options but i couldn't find anything promising. Could you share your insights please. Thanks

…

On Mon, Nov 11, 2024, 8:43 PM andydukes ***@***.***> wrote: Hi, I responded to a similar question on discord earlier (copy below). Let me know if you still need help and I'll write some notes up. - I’ve literally just got this solution working after a couple of weeks configuring and tuning so that part of my flow asks the user a series of questions, receives the answers, is able to verify that the user response is appropriate, and cycle through a list. while retaining the responses, after which it can kick off actions and execute tools based on the responses and also hand on to other agents etc. I will try and write up some notes and tips (and some cheats) next week and drop them to you if you are still in need of help / ideas? — Reply to this email directly, view it on GitHub <#2528 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5NF3GZKAJCBXTN2WHOQCJL2ADCRLAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRRGU4TCMQ> . You are receiving this because you commented.Message ID: ***@***.***>

[andydukes]

Hi! Sure no problem. I’ll find some time at the weekend and write up my notes and get them over to you. I’d would normally be happy just to forward the json flow to you, but it’s a clients project and they are actually on of the big AI owners so it’s just stuffed with confidential bits. I’ll have it with you by Sunday. Best AndySent from my iPhoneOn 14 Nov 2024, at 03:24, Gaurav Kalia ***@***.***> wrote: Hi, Thanks for responding. I have spent a few days myself to explore the options but i couldn't find anything promising. Could you share your insights please. Thanks

On Mon, Nov 11, 2024, 8:43 PM andydukes ***@***.***> wrote: Hi, I responded to a similar question on discord earlier (copy below). Let me know if you still need help and I'll write some notes up. - I’ve literally just got this solution working after a couple of weeks configuring and tuning so that part of my flow asks the user a series of questions, receives the answers, is able to verify that the user response is appropriate, and cycle through a list. while retaining the responses, after which it can kick off actions and execute tools based on the responses and also hand on to other agents etc. I will try and write up some notes and tips (and some cheats) next week and drop them to you if you are still in need of help / ideas? — Reply to this email directly, view it on GitHub <#2528 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5NF3GZKAJCBXTN2WHOQCJL2ADCRLAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRRGU4TCMQ> . You are receiving this because you commented.Message ID: ***@***.***>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: ***@***.***>

[gauravkaliadev]

Thanks, that sounds great. I'm really looking forward to it. Thanks

…

On Thu, Nov 14, 2024, 12:38 PM andydukes ***@***.***> wrote: Hi! Sure no problem. I’ll find some time at the weekend and write up my notes and get them over to you. I’d would normally be happy just to forward the json flow to you, but it’s a clients project and they are actually on of the big AI owners so it’s just stuffed with confidential bits. I’ll have it with you by Sunday. Best AndySent from my iPhoneOn 14 Nov 2024, at 03:24, Gaurav Kalia ***@***.***> wrote: Hi, Thanks for responding. I have spent a few days myself to explore the options but i couldn't find anything promising. Could you share your insights please. Thanks On Mon, Nov 11, 2024, 8:43 PM andydukes ***@***.***> wrote: > Hi, I responded to a similar question on discord earlier (copy below). Let > me know if you still need help and I'll write some notes up. > > - I’ve literally just got this solution working after a couple of > weeks configuring and tuning so that part of my flow asks the user a series > of questions, receives the answers, is able to verify that the user > response is appropriate, and cycle through a list. while retaining the > responses, after which it can kick off actions and execute tools based on > the responses and also hand on to other agents etc. > I will try and write up some notes and tips (and some cheats) next > week and drop them to you if you are still in need of help / ideas? > > — > Reply to this email directly, view it on GitHub > < #2528 (reply in thread)>, > or unsubscribe > < https://github.com/notifications/unsubscribe-auth/A5NF3GZKAJCBXTN2WHOQCJL2ADCRLAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRRGU4TCMQ> > . > You are receiving this because you commented.Message ID: > ***@***.***> > —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: ***@***.***> — Reply to this email directly, view it on GitHub <#2528 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5NF3GZ2IGI2IND5332NE6D2ARD6RAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRVGA2DINQ> . You are receiving this because you commented.Message ID: ***@***.***>

[andydukes]

Hi Gaurav, Sorry for the delay in getting this to you. I've attached the flow JSON for the Q&A Loop example. My own requirement was for a list of questions to be answered, one by one, and for the user input to be checked against a schema that described valid answers to the question - so I'm sure you will be able to simplify this for you own situation. NOTE: Make sure you change the Agent Memory path to match your own setup.  

…

On Nov 15, 2024, at 03:37, Gaurav Kalia ***@***.***> wrote: Thanks, that sounds greaa. Looking forward to it. Thanks On Thu, Nov 14, 2024, 12:38 PM andydukes ***@***.***> wrote: > Hi! Sure no problem. I’ll find some time at the weekend and write up my > notes and get them over to you. I’d would normally be happy just to forward > the json flow to you, but it’s a clients project and they are actually on > of the big AI owners so it’s just stuffed with confidential bits. I’ll have > it with you by Sunday. Best AndySent from my iPhoneOn 14 Nov 2024, at > 03:24, Gaurav Kalia ***@***.***> wrote: > Hi, > > > > Thanks for responding. > > > > I have spent a few days myself to explore the options but i couldn't find > > anything promising. > > > > Could you share your insights please. > > > > Thanks > > > > On Mon, Nov 11, 2024, 8:43 PM andydukes ***@***.***> wrote: > > > > > Hi, I responded to a similar question on discord earlier (copy below). > Let > > > me know if you still need help and I'll write some notes up. > > > > > > - I’ve literally just got this solution working after a couple of > > > weeks configuring and tuning so that part of my flow asks the user a > series > > > of questions, receives the answers, is able to verify that the user > > > response is appropriate, and cycle through a list. while retaining the > > > responses, after which it can kick off actions and execute tools based > on > > > the responses and also hand on to other agents etc. > > > I will try and write up some notes and tips (and some cheats) next > > > week and drop them to you if you are still in need of help / ideas? > > > > > > — > > > Reply to this email directly, view it on GitHub > > > < > #2528 (reply in thread)>, > > > > or unsubscribe > > > < > https://github.com/notifications/unsubscribe-auth/A5NF3GZKAJCBXTN2WHOQCJL2ADCRLAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRRGU4TCMQ> > > > > . > > > You are receiving this because you commented.Message ID: > > > ***@***.***> > > > > > > > —Reply to this email directly, view it on GitHub, or unsubscribe.You are > receiving this because you commented.Message ID: ***@***.***> > > — > Reply to this email directly, view it on GitHub > <#2528 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/A5NF3GZ2IGI2IND5332NE6D2ARD6RAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRVGA2DINQ> > . > You are receiving this because you commented.Message ID: > ***@***.***> > — Reply to this email directly, view it on GitHub <#2528 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFCWBNPI5L5TJRMO3XDWYI32AUC2BAVCNFSM6AAAAABIQNZ7HGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMRVHE3DMNI>. You are receiving this because you commented.

[gauravkaliadev]

Thanks @andydukes.

I can't see an attachment.

[andydukes]

Hi Guys.
Lets try this way
AgentFlow-QA-Loop-Example-Agents.json

[gauravkaliadev]

Thanks @andydukes .

I will give this a go.

[erlebach]

I am getting an error when importing your JSON file (in the Marketplace, or in AgentFlow or in ChatFlow). I am using Flowise 2.2.1 on the Mac. I attach

an image of the error message.

[andydukes]

Hi. Sorry only just saw your replay. I think if you create and empty canvas and then import the json into the new can as it should work :)

[jawadashraf]

Hi @andydukes ,

Thank you so much for the help.
How can I save the response to sqlite db.

Regards

[andydukes]

Hi. Add a tool node to the last LLM and add a simple tool that grabs the previous output and then either send the result somewhere or if you meant to ask how do you save the state back to the state table, then get the existing final LLM to output structure JSON to the state table. Hope this helps

[jawadashraf]

Thank you so much for the quick response.
I am trying to save the data to a new table that I created in the sqlite db.
Here is the testing code

const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('database.sqlite'); // I tried with the full path as well

const scenarioValue = $flow.state.scenarioValue;
const scenarioState = $flow.state.scenarioState;

db.serialize(() => {
    db.run('
        CREATE TABLE IF NOT EXISTS my_responses (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            user_id TEXT,
            question TEXT,
            response TEXT
        )
    ');
});

I get the error: sqlite3 module not found, even though it exists in node_modules table

Thanks

[YuriyT2232134fdfg]

My file downloaded fine. Thank you very much. And what exactly or what actions can be performed by this script? Thanks for the reply)