> For the complete documentation index, see [llms.txt](https://docs.sheetmonkey.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sheetmonkey.io/guides/special-fields.md).

# Special Fields

Sheet Monkey has "special fields" that make saving certain common types of data easier.

* [x-sheetmonkey-current-date-time](#saving-a-current-date-and-time)
* [x-sheetmonkey-current-date](#saving-a-current-date)
* [x-sheetmonkey-redirect](#redirecting-after-the-form-is-submitted)
* [x-sheetmonkey-ip-address](#capturing-the-client-ip-address-from-your-form-submission)
* [x-sheetmonkey-insert-data-top](#inserting-data-at-the-top-of-your-sheet)
* [x-sheetmonkey-insert-worksheet](#inserting-data-into-a-specific-worksheet)

#### 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.

```markup
<input type="hidden" name="Created" value="x-sheetmonkey-current-date-time" />
```

#### Saving a current date:&#x20;

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" ](/files/-MOxpp8WQBoWj1IVu4PB)

### 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.

```markup
<input 
    type="hidden" 
    name="x-sheetmonkey-redirect" 
    value="https://my-site.com/signup-success.html" 
/>
```

{% hint style="info" %}
This special reserved field will not be added to your spreadsheet as a column.
{% endhint %}

### 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.

```html
<input
    type="hidden"
    name="IP address"
    value="x-sheetmonkey-ip-address"
/>
```

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.

```html
<input
    type="hidden"
    name="x-sheetmonkey-insert-data-top"
    value="1"
/>
```

{% hint style="info" %}
This special reserved field will **not** be added to your spreadsheet as a column.
{% endhint %}

{% hint style="warning" %}
This field only works for Google Sheets. Notion is not supported.
{% endhint %}

### 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.

<figure><img src="/files/kfeQhYg7WQ8RrKtPcbgo" alt=""><figcaption></figcaption></figure>

```html
<input 
    type="hidden"
    name="x-sheetmonkey-insert-worksheet"
    value="Sheet2"
/>
```

{% hint style="danger" %}
If you put in a name of a worksheet that does not exist on the linked sheet, your submission will not be inserted.
{% endhint %}

{% hint style="info" %}
This field only works for Google Sheets. Notion is not supported.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.sheetmonkey.io/guides/special-fields.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.