Hello,
I have a Retool DB Table, with a column of type date-time. I have set the column to;
UTC + 2
Default value: Now()
I use a workflow to bulk inserts some data into the table. The Date - time column should log the time of the insert, therefor set to Now().
When I run the first flow, the insert was performed correctly and the date/time is correct. However Retool automatically changed the column settings of the column. It changed the Default Value of the column from Now() to the date/time of the insert.
When I perform another insert, 12 minutes later, the printed time is the time of the previous insert and not Now()