Special Fields
Sheet Monkey recognizes special fields to make certain tasks easier
Sheet Monkey has "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.
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.
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.
This special reserved field will not be added to your spreadsheet as a column.
Capturing the client IP address from your form submission
You can capture the client IP address from form submissions by adding a hidden field with the value x-sheetmonkey-ip-address
to your form. This can be useful for geocoding user locations or preventing spam.
Sheet Monkey will automatically convert this value to the IP address of the client who submitted the form.
Inserting data at the top of your sheet
In certain situations you may want to add data to the top of your sheet rather than the bottom, especially in cases where you have a very large sheet. Sheet Monkey allows you to do this with the x-sheetmonkey-insert-data-top
form field. Add a hidden field to your form with this name and Sheet Monkey will insert the data at the top of your sheet rather than the bottom.
This special reserved field will not be added to your spreadsheet as a column.
This field only works for Google Sheets. Notion is not supported.
Inserting data into a specific worksheet
In certain situations you may want to add data to another worksheet, instead of the default sheet. Sheet Monkey allows you to do this with the x-sheetmonkey-insert-worksheet
form field. Add a hidden field to your form with this name and the value of the Worksheet that you want to insert into and Sheet Monkey will insert the data at that worksheet.
If you put in a name of a worksheet that does not exist on the linked sheet, your submission will not be inserted.
This field only works for Google Sheets. Notion is not supported.
Last updated