Hi there. I'm quite new to retool. Have only been using it a week and have set up basic queries from forms. I am unable to figure out so far how to do more a complex operation mentioned below.
I have a form that sends query1 on clicking submit button.
- If query1 is successful, I will get back an "id" value in the response data.
- I then want to build and trigger query2 which will need a dynamic url. The url will need the "id" as a part of the it.
- Also, query2's will have json data to be sent, which will also need to have the "id" value in it, along with a another value. i.e. the json payload sent for query2 should look something like this { "key1":"id", "key2":"other input value in original form"}
I am not really able to understand how to create queries that send their response data to be used in a second query. Transformers are read only. Query triggers can't send the url as well can they?