Integrate time stamp into form (as hidden element)

Design help Custom code
1

Hey guys,

I want to pass a time stap as hidden element when a form is submitted.

The time stamp should look like that: YYMMDD

That shouldn’t be too hard, right ;)? Unfortunately I wasn’t able to get it right so far … :smiley:

Can anyone help me?

Thanks a lot in advance!

Michael

1 Like
2

One way is to use Zapier to handle the form. It automatically adds submittedAt: to the form data.

3

Hi @orgreeno,

thanks for the fast answer.

Is it possible to show the time stamp it the mentioned format YYMMDD using zapier?

As far as I remember it looked different …

Zapier generates: submittedAt: 2017-12-03T21:22:27.988Z

4

Here’s an example of one of my submissions:
submittedAt: 2017-11-30T15:20:17.750Z

Using the built-in “Format” action, you can get this - YYYY-MM-DD (2006-01-22) You may be able to customize even more, but I’m not sure.

5

I am quite sure it shouldn’t be too hard to get YYMMDD with a bit of JS … but I couldn’t figure out how so far …

6

I might have found a solution :smiley: …

I use the following JS in the body:

var today = new Date();
var dd = (today.getDate()).toString();
var mm = (today.getMonth()+1).toString(); 
var yy = (today.getFullYear()-2000).toString();
if(dd<10) 
{
    dd='0'+dd;
} 
if(mm<10) 
{
    mm='0'+mm;
} 
today = yy+mm+dd;


document.getElementById('timeStamp').value= today ;

And in the form:

<input type="hidden" name="timeStampID" id='timeStamp' />

1 Like
7

This will give you the user’s local time (as set on the computer).

8

Can I configure zappier to EST?

9

Hey @michael, great script. I need just that. I am trying to implement it but can’t seem to get it working. I am missing something?

Thanks for the help.

2020-05-12_13h59_42 2020-05-12_13h59_50 2020-05-12_14h00_10

10

Ok, I managed to do it. Here’s how…

Added this to Footer Code in Project Settings:

<script>
  
	var dt = new Date();
	var time = dt.getTime();
	//document.write(time);
  
    $( document ).ready(function() {
    
        // after the page elements are all loaded, then run the script

        $("#name").val(time);
        
        });
        
</script>

And then changed the ID of my regular input form field. Like so:

2020-05-12_14h46_07

11

Hey all! For anyone still looking to have a functioning hidden timestamp field on their Webflow form, a friend of mine edited the above javascript from Sebastian and included a timezone snippet to convert the timestamp to any timezone needed (so you don’t get form submissions from the user’s timezone).

<script>
	var dt = new Date().toLocaleString("en-US", {timeZone: "America/Chicago"});
    $( document ).ready(function() {
        // after the page elements are all loaded, then run the script
        $("#timeStampID").val(dt);
        });
</script>

Once you put that code in the tag of a specific page or add it to the Custom Code section in settings, you then add a text field to your form, set the name/ID to be timeStampID like Sebastian mentioned and set the field to display: none. That should do it, I tested this out in Zapier across different timezones and it worked flawlessly! Hope this helps anyone looking to integrate this :slight_smile:

1 Like