On change value of text field trigger a query

[Vikas]

I want to trigger a query when text input field changes.
I have 3 queries:
query1 for add values.
query2 for read last added value
I am taking one text input field and reading last added value,
query3: this query will trigger on change text input field value

note: it works if I changed text input field manually, I want to do it automatically

[AnsonHwang]

@Vikas

, I want to do it automatically

Welcome to the community.
Hello what you mean do it automatically? share some screenshot?

[Vikas]

see above screenshot

[Vikas]

when Query1_add run it send data value to database, this added data viewed by Query2_view, I have taken textinput1 field to show last value.
Again when Query1_add query run then textinput1 field value changes, whenever value changes i want trigger query3.

[Vikas]

I am waiting , does anyone have solution for this?

[Vikas]

can you help me out @AnsonHwang I am waiting of your reply.

[AnsonHwang]

@Vikas

query1

Hello, Sorry for ignore.
Why not just run query3 in the success event handler of query1_add

[Vikas]

Thank you for your reply.
I want read last added data in query3.
when I use success event handler sometimes I didn't get last added data. I don't want to miss the data before running query3.

[Vikas]

I am expected I will get response from retool team. but...... no one their responded.

[AnsonHwang]

Hi, you can use additionalScope to pass the return value from query1 to query3.

query3.trigger({
 additionalScope:{
   query1Result: query1.data
}
})

and in the body of query3, you can use query1Result directly.

Here is some guide

The Query object | Retool Docs

How to use additional scope (additionalScope) in your queries

Why use additionalScope When writing queries you'd like to reuse with different input value(s), Retool's additionalScope might be helpful! See our docs here and some more in depth examples below. How to use additionalScope The additionalScope option allows you to pass variables to the query that aren't already defined in the global scope (e.g. text1.value). In order to use additionalScope, you must first trigger a query in an event handler or using the .trigger() method in a JS query. [imag…

[joeBumbaca]

Hey @Vikas! As @AnsonHwang mentioned, using additionalScope is the way to go here. You can await the return of the original query and then pass that information along to your query3 without needing a change event handler on the text input.

Here, I'm using the return value from query1 to pass some data ('Success!') to query5.

Let me know if you have any questions!