Add fixed value to output

You can add a fixed (constant) value to every record written to the output table when a request runs. This lets you track which request created or updated the record, making it easy to identify the data source for each entry.

When to use fixed values

Fixed values are particularly useful when you're importing similar data from multiple sources into the same table. For example, if you have an "Orders" table that collects orders from both Shopify and Etsy, you can use fixed values to automatically tag each record with its source platform.

Here's how this works in practice:

1. Create an Airtable field in your output table to store the source information (e.g. a "Single select" field called "Platform" with "Shopify" and "Etsy" as options).

2. Create a separate requests for each data source.

3. Configure each request to automatically add the appropriate fixed value ("Shopify" for the Shopify request and "Etsy" for the Etsy request)

When the requests run, every imported record will be automatically tagged with its source, so you'll always know whether an order came from Shopify or Etsy.

How to add a fixed value

1. Navigate to the request screen in Data Fetcher.

2. Scroll down to the bottom and click to open the Advanced settings.

3. Under Add Fixed Value, select a Field from the output table using the dropdown.

4. Enter or select the Value you want to each record.

The fixed value will be applied to all records created / updated by this request.

Use Airtable values as fixed values

Instead of using a static value, you can reference values from your Airtable tables as fixed values. This is particularly useful for adding dynamic information like timestamps or configuration data that changes over time.

Common use cases:

• Add a timestamp showing when Data Fetcher last ran

• Include a source record ID or name when running on multiple records

How to set this up:

1. In the Value field, click the + button to open the table reference modal.

2. Select the Table and Field containing the value you want to use.

3. Choose the specific record with the cell value you need (optional).

4. Click Confirm.

For example, to automatically track when your data was last updated, you could create a formula field in an Airtable "Config" table with DATETIME_FORMAT(NOW(), 'YYYY-MM-DD HH:mm:ss') and reference that cell. Every time your request runs, it will add the current timestamp to your imported records.