Automation. Modify automation or script needed?

[bedjik]

Hello, I would really appreciate if someone could help me to solve my puzzle)

I have a table "Schedule" where we input addresses, every address goes into 3 separate fields, 

"Street Name", "City" and "Zip Code"

So I created an automation (check images attached) where "Zip Code" field is auto filled with preset zip code when a "City" is chosen. Everything works fine, but automation works with one city only and my question is, is there a chance to modify automation where I can add options to fill zip codes for other cities in the same automation, not just one or I need something else and I chose the wrong path to do it.

I tried to create a separate automation for every city we have in the "City" field, but very quickly I was told by Airtable that my plan allows me to have only 40 automations and I have around 100 cities in the "City" field

Thank you in advance for those willing to help.

[ScottWorld]

This is not possible. Instead of using single select fields and automations, you need to use linked record fields and lookup fields to do this. To learn more about linked records and lookup fields, check out my Airtable training course at https://www.linkedin.com/learning/learning-airtable.

If you need more detailed help, post a message at TableForums, where it is easier for the experts to give help.

[TheTimeSavingCo · Accepted solution]

Hm, what if you used a formula field with `SWITCH()`to deal with this instead of an automation? 

SWITCH(
  City,
  "Dayton", "08810",
  "City 1", "12345",
  "City 2", "67890"
)

 Link to base

[bedjik]

Thank you TheTimeSavingCo, everything worked and you are the creative mind!