Using data from one query as output from an insert into

Hi i have this query:

insert into "GD_Unit_ttt"
VALUES ({{****)}},{{textInput27.value}},{{textInput26.value}},{{numberInput45.value}},2,1)

Where is the Returning "id" output from another query. The query runs without errors, but the BMR_Record is inserted as null. But the data is there i think - see picture below.


Hi @Eyemind_ApS,

Have you tried {{[0] }}? It looks like the data value is an object containing an array called ID.


Thanks a lot! Worked as a charm.

1 Like