Hidden Date and Time in form

Ask the community
1

Hello Everyone.

how do i save the current date and time in a form without asking the user to input it?

for example when the user submit a new form it will create a new raw in google sheet,
one of the cell in the raw i want it to be the current date,
another cell of the raw i want it to be the current time.

i’m using google sheet

thank you

2

Hello @Hazem,

I would suggest checking this Google Sheet extension that allows inserting time automatically

Hope this helps,

3

use a hidden field and pass custom value containing =text(now(),“YYYY-MM-DD hh:mm”)