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 the record was created or updated by.
Let's say we have an 'Orders' table, which has our orders from both Shopify and Etsy. We have two separate requests, one importing orders from Shopify and one importing orders from Etsy. We do not know which order came from Shopify and which came from Etsy.
We could add a 'Single select' field called 'Platform' to our 'Orders' table.
For our Shopify request in Data Fetcher, we could add 'Shopify' as a fixed value in this field. For our Etsy request in Data Fetcher, we could add 'Etsy' as a fixed value in this field.
For each record in the orders table, we would then know which platform it came from:
- On the create request screen, clickto open the advanced settings.
- Under Add Fixed Value, select a Field from the output table using the dropdown.
- Enter or select the Value.