I have a form for invoices with a last_sent date column. I don’t want to populate the date when the form is initially filled out. The MySQL table column is a date field with NULL set to Yes and no initial value for the field. In Appsheet, when the initial value is left blank or left as NULL, it will not let me save the form unless a date is input. I’m guessing that the mm/dd/yy label shown before a date is input is actually a value that the form is trying to store instead of a placeholder value. Any workaround for this?
I’m guessing that the mm/dd/yy label shown before a date is input is actually a value that the form is trying to store instead of a placeholder value
No, it’s not.
I’ve never had an issue leaving a date column blank, and it being NULL in the backend. When you say “NULL set to Yes”, what exactly do you mean by that? Can you enter a record directly into the backend with a NULL value?
You always have such weird issues with MySQL that I’ve never experienced. I know you mentioned certain MySQL versions before, are you experiencing it across different versions again? Where is your server hosted? Have you ever tried to to establish a brand new connection to the database? Do you use it across several different apps? I really have no idea what might be pertinent here, just spit-balling.
Thanks Marc. Yes, a quick test with an AppSheet DB table proves that the problem is limited to MySQL tables. I don’t think it’s any particular version of MySQL that I’m using as I have several projects using a variety of hosts and MySQL versions, and they all seem to have the same quirks to them. Not sure why AppSheet has so many MySQL quirks to it. So, the question remains, is there a workaround for getting a date field, stored in MySQL to accept a blank value.
I am trying to migrate an application from a spreadsheet to MySQL and I have run into this problem when starting, this means that I cannot migrate the application because I often leave some datetime cells empty and if I want to move them to a MySQL table I might have to change the Pretty app logic and remember all the places I use it as well. Is there any alternative?
As I said above I’ve never had such an issue. Using version 8.0.18 hosted on Google cloud. Also never had to make any specific settings or anything either. If you can provide any extra details about the situation (look at my list of questions above for starters), perhaps something will stand out. You can also try to contact support directly about this, they might know more (if you can get through the initial layer of people who don’t know hardly anything).
1 Like