Now in Date and time field sends to Google sheets text "Now" (not date and time)

Report a Bug
1
  1. My app has a form with date and time field. Default value is set as Now.
  2. When I fill out a form this date and time field automatically constrains current date and time. Important: I don’t touch this field.
  3. I press Save. App sends to Google sheets input data.
  4. In result in Google sheets new row appears but it contains just text “Now” in column Date and time - instead of date and time.
    Screenshot_20230501_214528~2
    Screenshot_20230501_214528~22408×1080 236 KB
2

‘Now’ is not a date. It’s just seen as text. Instead, you can add a current date special value component to your form.

1 Like