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

  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.

‘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