If I create a form view containing date columns named “Start Date” and “End Date”, where Start Date is configured to have an initial value of TODAY() and End Date is configured to no initial value (or an initial value of “”), the form displays today’s date in both columns. Is there a way for someone who is filling out this form to identify that “Start Date” has a date assigned, but “End Date” does not?
I was hoping to have the form show no value, or a grayed out value, in a date column that is currently blank, but I haven’t found a way to do this.
If you simply keep the “initial value” without any expression, the date column will show as the [delivery Date] column shows in the screenshot below. [Order Date] has an “initial value” setting of TODAY()
same behavior shown in your screenshot, so I created a new app using a new AppSheet database (keeping default columns), then viewed the app in various web browsers and clicked the Add button to display the form view.
It turns out that the unwanted behavior (blank date column shows today’s date in forms) only occurs when using Safari in macOS to view the app. Our office almost exclusively uses Safari in macOS, so this behavior has been an issue for us.
