Forums

Hidden Date Field

mduda 17 May, 2015
When I save my CF to Google, everything transfers. All is good. However, I need to find a way to include a date stamp. I have a script in Google, but it's not working because it's an onEdit function (which only updates when you are actually in the sheet making a change - the import does not affect it).

So, I was considering that maybe a better choice would be to add a hidden date field in my form. Can you provide guidance on how to do so? Or if you have a better CF solution?

Thanks!
GreyHead 18 May, 2015
Answer
Hi Mduda,

In the On Submit event, add a Custom Code action before the Export action with code like this
<?php
$form->data['GSheet']['date'] = date('Y-m-d');
?>

Bob
mduda 18 May, 2015
Perfect! Works like a charm! Thanks Bob!😀
This topic is locked and no more replies can be posted.