Hi there,
I have an airtable table that has for each country the shipping costs parameters.
Now I would like to update the shipping costs for a list of schedules (schedule = delivery with a date). I load the required country data in a first action step which gives me a list of country codes with the respective shipping costs.
Next action is a “Make Changes to a list” step, where I want to calculate the shipping costs for each schedule.
However when I do my calculaton I need to filter the list of countries to only that country with the code of my current schedule item.
However, I do not get that option:
Any other idea?
I could trigerr another workflow on each schedule item and then only load one coutnry item from airtable, however, that would require many more api calls…