Chained querys not retrieving the newly created id

đź’¬ App Building
1
  1. My goal: I have 2 chained querys where :
    1. 1st one is creating a new line in the main table
    2. 2nd one logs the creation in an event table
  2. Issue: When I try to get the new id value, it doesn’t give me the right value… I tried many things and asked ChatGPT but none of the solutions solve the issue…
    image
    image1911Ă—988 199 KB
  3. Steps I've taken to troubleshoot:
    1. split in multiple steps
    2. add logs (cf on the screen above…)
  4. Additional info: I mainly use GUI for the querys and tables are Retool database stored.

What would you recommend ?

Many thanks for your help and wishing everyone a happy new year.

4

Hi @pdekerdrel,

Welcome to the community! Thanks for this detailed question.

I recommend copy & pasting this code into a Javascript query instead of a script. Then, in the Advanced tab of the query, check on “Keep variable references inside the query in sync with your app” (at the bottom of the Advanced tab).

For performance purposes, by default, the value of external (to the JS query/script) variables are only read when the JS query is initially called. In order to refresh the value within the JS query itself, you need to check the optional Advnaced setting on. We don't have this setting on scripts