Special Fields

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.

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" 
/>