> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/features/tableau-extension/configuration/schemas/form-builder/dynamic-values.md).

# Dynamic Values

A field does not have to be typed. With a default value you can fill it from the dashboard — a dimension, a measure, the mark your user selected — so the record carries context nobody had to enter by hand.

Open the configuration dialog, go to **Worksheet-schema**, pick your schema and open the **Form builder** tab. The **Default value** column holds an edit icon per field.

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-406e72db9c704ab1986900485a7a722500829dc9%2FScreenshot%202024-02-27%20at%202.44.45%E2%80%AFPM.png?alt=media" alt=""><figcaption></figcaption></figure>

### The Default value dialog

The dialog tells you the data type and style of the field you are working on, and offers three kinds of default:

* **none** — no default. The field starts empty.
* **static** — the same value every time. A text field asks for a **Default value**; a boolean shows a checkbox, where unticked means `false`.
* **dynamic** — the value is read from the dashboard.

For a dynamic default, pick a worksheet under **Select worksheet** and a column under **Select column**.

* **Overwrite value with dynamic value when editing rows.** — also apply the default when an existing record is opened, instead of only when one is created. This replaces whatever is in the field.
* **Use single value when multiple marks are selected.** — take the first value instead of joining them all.

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-412bbeddfcc4e05619047061ba98b345125e1e1f%2FScreenshot%202024-02-27%20at%202.44.08%E2%80%AFPM.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Make sure the data type of the column matches the data type of the field. A dynamic default does not convert anything.

Do not point a dynamic default at a worksheet holding large amounts of data: the extension reads it to resolve the value.
{% endhint %}

### Which row the value comes from

* **The same worksheet as the schema** — the mark your user selected decides the value. With several marks selected, the values are joined with the data separator, and the **Separate record for every selected mark** option can split them into one record per mark.
* **A different worksheet** — there is no relation to resolve, so the first row found is used, whatever the selection is. The dialog says so when you pick such a worksheet.
* **Data correction** — the unique identifier of the connected worksheet is used to find the matching row. If no match is found, the first row is used.

The data separator is a pipe (`|`) unless someone changed it. It is a server-wide setting on the **Advanced configuration** page of the [management console](https://docs.infotopics.com/features/management-console.md), under **Data separator** — not an extension setting.

{% content-ref url="/pages/rC2vJmnVVRcZS6H2HygH" %}
[Troubleshoot | Values](https://docs.infotopics.com/features/tableau-extension/configuration/schemas/form-builder/dynamic-values/troubleshoot-or-values.md)
{% endcontent-ref %}


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.infotopics.com/features/tableau-extension/configuration/schemas/form-builder/dynamic-values.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
