> For the complete documentation index, see [llms.txt](https://developer.pitchly.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.pitchly.com/pitchly-field-types-returns.md).
# Pitchly Field Types/Returns
The following are all the field types in Pitchly, and sample return values when returned in a recordsConnection query.
\|  | Single-line Text: Short single-line text
Sample Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldpLdoGAFzJae8BfTG7","value":{"val":"Name"},"stringValue":"Name"}
|
\| ------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
\|  | Number: Number with possible decimal
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldFawgZ4fMZC7PRhjbE","value":{"val":2300},"stringValue":"2,300"}
|
\|  | Yes/No: Binary yes/no value
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldPSYXsMQY9qhLZB2Cg","value":{"val":true},"stringValue":"Yes"}
|
\|  | Multi-line Text: Long multi-line text (can store clickable URLs)
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldpLdoGAFzJae8BfTG7","value":{"val":"longer text"},"stringValue":"longer text"}
|
\|  | Dropdown: Picklist of predefined choices (limited to one selection)
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldnkQKPuSETPib3CPYm","value":{"val":"Lincoln"},"stringValue":"Lincoln"}
|
\|  | Dropdown Multiple: Picklist of predefined choices (multiple selections available)
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldeZsZWHw7yYuBjCgTf","value":{"val":\["Lincoln","Omaha"]},"stringValue":\["Lincoln","Omaha"]}
|
\|  | Date: Date in the format MM/DD/YYYY
Return Value:
|
\|  | Currency: Currency amount with symbol
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldxmggqWFyYsdTXjgRw","value":{"val":23045,"currency":"USD"},"stringValue":"$23,045"}
|
\|  | Attachment: Any type of file attachment, including images. type is the mime type of the file, and size is the size of the file in bytes. val is the URL of the file.
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldxmggqWFyYsdTXjgRw","value":{"val":"https\://..., "type":"image/jpeg", size: 50000},"stringValue":"https\://..."}
|
\|  | Reference: Creates a relationship/link to one record in another table
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldqrYiD9XpWw8AQkhEf","value":{"val":"wksdMHiQmzTt6Dhf9N77 recguqydmvmsWfCkJxHu"},"stringValue":"Jacob"}
|
\|  | Reference Multiple: Creates a relationship/link to multiple records in another table
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldKp2RtY9XnVw7mLs4Q","value":{"val":\["wksdMHiQmzTt6Dhf9N77recguqydmvmsWfCkJxHu","wksdMHiQmzTt6Dhf9N77recM4ria9LpqZvTnBxKe2"]},"stringValue":\["Jacob","Maria"]}
|
\|  | Lookup: Read-only subfield pulled from a referenced table
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldLk8QmzTt6Dhf9N7zXa","value":{"val":"Acme Inc"},"stringValue":"Acme Inc"}
|
\|  | Created At: Displays creation date and time
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldCr8AtZ9XmVw7mLs4Q","value":{"val":"2026-06-17T14:30:00.000Z"},"stringValue":"2026-06-17 2:30 pm"}
|
\|  | Updated At: Displays date and time of last update
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldUp8AtZ9XmVw7mLs4Q","value":{"val":"2026-06-17T18:45:00.000Z"},"stringValue":"2026-06-17 6:45 pm"}
|
\|  | Formula: Calculates values based on predefined logic
Return Value:
{"fieldId":"wksdMHiQmzTt6Dhf9N77|fldFm8La9XpWw8AQkhEf","value":{"val":1234.5},"stringValue":"1,234.5"}
|
---
# 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://developer.pitchly.com/pitchly-field-types-returns.md?ask=&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.