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.

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.