Related (to hopefully help anyone else affected by this issue):
- Ask the Community ▸ Accidentally converting text fields in a form to date fields
- Bugs ▸ Columns types changing on their own
- Bugs ▸ Text field turns into a date field when I type text with a date in it
Trigger:
There is no other row in the table with a non-blank value in this field. In other words, this conversion will happen if the table is empty, or if every other row in the table has no value for this column.
Current workaround:
Have a row somewhere with a non-blank value for this column, and filter it out of view.