Updating another table field after doing an insert?

I have a table of scripts, that has a filed called questions (object).

This questions field stores a ref to the questionID, from my questions table.

when I create a new question on my front end, I want to update the related script by adding the questionID to that object field in scripts.

I cant do it as I do not know the id of the question at the time I create it?

Is there a way in Xano to update that column ?

I can can create new questions, and I do have a ref to the script in the questions DB:

But right now, in my scripts DB, I am manually entering the script_questions object field for the record with the questionIDs

5 replies