I am at my wits end.
I have been trying to create a system that displays all the records within a table. I have a form next to the table that I wanted to allow the user to enter a new record through. I also added two row actions to the table. One to move the record to another table and one to delete a record.
Some of the problems I have been having include getting blank record when moving a record, getting a blank record when deleting a record or queries running non-stop and deleting all my records.
I have tried writing my own SQL statements. That didn't work because I could not figure out how to insert a null value for a date. I tried using the GUI for the SQL query. I figured out how to enter null values, but still got errors such as no record, or the query not running at all.
I have tried triggering the query both directly and by running script. I have two or three other queries that I want to run after the initial query is successful, but was told they may not run in order and it was better to use a script.
If anyone could tell me what is the best and/or simplest way to insert, move, update and delete records, I would be very grateful. I have been working on this for two days and am starting to think I may have to try something other than retool.
Could you send a json export of you application with hardcoded queries? You can do so by opening the debug console and clicking the download icon.