# Working with Data

**Contents:**

[Auto-generated row (primary key)](#auto-generated-row-primary-key)

[Dropdowns](#dropdowns)

[Limitations](#limitations)

### Auto-generated row (primary key)

When you connect your Google Sheet table to Jet Admin or add new tables, Jet Admin automatically generates a row value (primary key) - a unique identifier of a given row. 

When you set up relations (binding) in Jet Admin or create pretty much any logic, Jet Admin uses `ROW` to identify the records. This field can not be deleted.

### Dropdowns

Dropdowns are used a lot in Sheets, but to make them work correctly when you connect your data to Jet, follow the instructions below

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2Fantnj99QSLYXsUOOzI59%2Fstagessheets.JPG?alt=media&#x26;token=0b25cd23-aed7-4bf9-83b1-3311a941e596" alt=""><figcaption></figcaption></figure>

If you have dropdowns in your Sheet, and you want them to be transferred into Jet, you can't do it directly. Instead, click add a new file and choose the sheet that contains all the options for the dropdown

{% hint style="warning" %}
The values should be **unique** (no duplicates) AND the sheet has to have a **header row**, otherwise Jet will use a real value as a header
{% endhint %}

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FjZ3VaEWrSyocnPeQbNBr%2Fshdtf.JPG?alt=media&#x26;token=38b2f3f7-eaa1-4472-8c9f-624022f1f7e8" alt=""><figcaption></figcaption></figure>

After connecting it, it will look like this in Jet:&#x20;

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FtjfO14tF8eHt3eEPZ6iy%2Fstages.JPG?alt=media&#x26;token=13d3346a-3987-4118-9156-1ad764f3b5ff" alt=""><figcaption></figcaption></figure>

Now, after building your interface or applying one of the ready-to-use templates, you need to configure your select (dropdown) field in Jet Admin. By default, it looks like a basic input:

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FR3xzrfW1NVpXys848Izo%2Fdtjsfgy.JPG?alt=media&#x26;token=06f6f753-9977-46cb-9449-ce9c157f186b" alt=""><figcaption></figcaption></figure>

To make it a dropdown with the correct options, proceed to the settings and change the type of the field to "Select"

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FVDUeUrYiIBlld12uq6jw%2FScreenshot%20(202).png?alt=media&#x26;token=13986e3a-b3b1-4a4c-b0d7-d78d88ada4af" alt=""><figcaption></figcaption></figure>

The last thing that's left is to choose the "Load from resource" tab and then pick your Sheet that contains the dropdown options.

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FXUxDoqjuhHqKhDCHnakq%2Fdjfygvy.JPG?alt=media&#x26;token=76b41965-e1a3-4f17-a7e5-e717a4c8a31c" alt=""><figcaption></figcaption></figure>

### Limitations

It's essential to be aware of the limitations of Google Sheets while working in Jet Admin. There are two major limitations:

1. **Number of rows per minute** - this is the limitation that comes from Google Sheets API limits (read more [here](https://developers.google.com/sheets/api/limits)). So if you build a complex tool with lots of data, it might make sense to look for an alternative to Google Sheets

{% hint style="info" %}
You can use [Sync mode](https://docs.jetadmin.io/360-data-data-blending#sync-connection) to bypass this limitation
{% endhint %}

1. **Working with formulas** - Jet Admin supports formulas in Google Sheets for reading, which means that calculated fields in your Sheets. However, if you will change (Through Jet Admin) a value that's a result of a formula, it will be written as a value and the formula information will be lost for that field.

&#x20;


---

# Agent Instructions: 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:

```
GET https://docs.jetadmin.io/user-guide/integrations/google-sheets/working-with-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.