Docs · Mapping
Field mapping
The mapping says which source value goes into which Airtable field, and as what type. Rowvela checks every mapping against the table schema before the preview, so a wrong type is reported instead of written.
Choose the records
- Collection path points at the list of records in the response, for example
data.items. Leave it empty when the response itself is the list. - Expand nested lists (optional) turns each item of a nested list into its own row. An order with three line items becomes three rows; parent values stay available as
$parent.id. Add more levels for lists inside lists. - JMESPath transformation (optional) reshapes the whole response first, for bigger changes than a path can express.
Map fields
Each row has a Source field (a path such as customer.address.city or tags[0]), a Destination field (the Airtable field name) and a data type. Use Add field mapping for more rows. After Inspect source, Rowvela suggests mappings from the sample; Refresh source fields · no quota used fetches the source again without writing anything.
- Add fixed value writes the same value into every record, for example the name of the source.
- Add Airtable cell value reads a value from a cell in Airtable once per preview, for example a date to filter by.
- Create them in Airtable creates mapped fields that do not exist yet, with a matching type.
- Add numbered fields from sample keeps one record per source item and puts list positions into numbered fields instead of separate rows.
Data types
| Type | Airtable fields | Notes |
|---|---|---|
| Text | Single line, long text, rich text, email, URL, phone, single select | A single-select value must be an existing choice. |
| Number | Number, currency, percent, duration, rating | Rating accepts whole values from 1 to its maximum. |
| Boolean | Checkbox | An empty value means unchecked. |
| Date | Date, date and time | Date fields take YYYY-MM-DD; date-time fields take a full ISO time. |
| Multi-select | Multiple select | Choices must already exist. |
| Barcode | Barcode | Text keeps leading zeroes. |
| User / Users (multiple) | Collaborator fields | A user ID, or an email of someone already in the base. |
| Linked records | Link to another record | Matched by a field in the linked table; missing records can be created. |
| Attachments from URLs | Attachment | Public file URLs; Airtable downloads the files when the import runs. |
Computed fields (formula, rollup, lookup, autonumber, created and last-modified time) cannot be written. For attachments, Attachment write mode chooses Add to existing attachments or Write only if the cell is empty.
Expressions
Under Value settings, an Expression (optional) changes a value before it is converted: value / 100, round(value, 2), upper(trim(value)), concat("SKU-", text(value)), coalesce(value, "n/a"). Available functions are upper, lower, trim, text, number, abs, round, concat and coalesce. Use double quotes for text.