Populate column on insert via a query

When I insert a row, I need to populate one of the columns from a query. Is this possible or what exactly do I need to do to make this work? Here is my screenshot of my Insert a record:

I think your should create an new query for
. and referrence it in this query using {{ newQuery.data.theTime}}

1 Like

That worked! I've got one more SQL issue. I have two rows in my "entries" table. When I run this query ...

why is the "debugdate" column equal to 2023-07-20, when "theDate" column in the "entries" table are both "2023-07-19"?

Maybe timezone problem? you can config it in "theDate" column

1 Like