Using data from one query as output from an insert into

Queries and Resources
1

Hi i have this query:

insert into "GD_Unit_ttt"
("BMR_Record","Serial","BarCode","BatchNumberId","Location","Unit_Status")
VALUES ({{**Insert_BMR.data**)}},{{textInput27.value}},{{textInput26.value}},{{numberInput45.value}},2,1)

Where Insert_BMR.data 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.

image

2

Hi @Eyemind_ApS,

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

2 Likes
3

Thanks a lot! Worked as a charm.

1 Like