Help

Update a field when a different field is selected is a different column

Topic Labels: Automations
207 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jesspeck
4 - Data Explorer
4 - Data Explorer

Hi! I use Airtable for tv title tracking and I'm trying to see if it's possible to update a field ("Distribution Rights") when a separate field ("Distrbution Rights Details") is selected. Example listed below:

  • When "EXPECTED: All Media Worldwide" is selected in the "Distribution Rights Details" field, populate "Distribution Rights" field as "Global Expected"

Is this automation possible? If so, would it be possible to add additional options (when All Media Worldwide is selected, populate Global in Distribution Rights)?

1 Reply 1

Does this look right? 

SWITCH(
  {Distribution Rights Details},
  'EXPECTED: All Media Worldwide', 'Global Expected',
  'All Media Worldwide', 'Global in Distribution Rights'
)


Screenshot 2024-06-14 at 2.21.50 PM.png

Link to base