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