Special Fields

Search…

Special Fields

Sheet Monkey recognizes a few special fields to make certain tasks easier

Sheet Monkey has a few "special fields" that make saving certain common types of data easier.
Saving a current date and time: 
Create a hidden field with a value of x-sheetmonkey-current-date-time and Sheet Monkey will automatically convert that value to a date and time in your Google Sheet.
<input type="hidden" name="Created" value="x-sheetmonkey-current-date-time" />
Saving a current date: 
Create a hidden field with a value of x-sheetmonkey-current-date and Sheet Monkey will automatically convert that value to a date in your Google Sheet.
Setting the Timezone
All of the times are saved at 0 UTC time. If you want to save dates and times in your own timezone, you'll need to set the timezone in your Sheet Monkey dashboard, under settings.
Click on the drop down menu and select "Settings" 
Redirecting after the form is submitted
Once a visitor to your website has successfully submitted a form, you often want to redirect them to  another location. Sheet Monkey allows you to do this with the x-sheetmonkey-redirect field. Put any URL into this field and the user will be automatically redirected to that URL after submitting your form.
<input 
    type="hidden" 
    name="x-sheetmonkey-redirect" 
    value="https://my-site.com/signup-success.html" 
/>
This special reserved field will not be added to your spreadsheet as a column.

Guides - Previous

Submitting Carrd forms to Google Sheets

Next - Guides

File uploads

Last modified 1yr ago

Copy link

Outline

Redirecting after the form is submitted