Add fixed value to output
Last updated
Last updated
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.
Let's say we have an 'Orders' table that lists our orders from both Shopify and Etsy. We have two separate requests for importing orders, one for Shopify and one for 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. We could do the same for our Etsy request.
Under Add Fixed Value, select a Field from the output table using the dropdown.
Enter or select the Value.
On the create request screen, click to open the advanced settings.
