Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Need Content Title to Update Based on a Single Select Status

Topic Labels: Automations
177 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! I’m trying to build an automation for a social media tracking table wherein when a user selects a status from a dropdown (ie Facebook, Twitter, Instagram, etc.) that Content Title will automatically have a suffix added (ie /FB, /TW, /IG, etc.). Any suggestions on how to build that? Thanks for the help!

5 Replies 5

Hi @Eric_Grundhauser ,

Welcome to Airtable Community !

What do you mean by Content Title?

Hey @Eric_Grundhauser, not really sure if this is what you’re looking for, but I figure I’d take a stab at it. Just used a formula field to add the suffix to the content title

Screenshot 2022-09-14 at 11.07.34 PM

{Content Title}
&
SWITCH(
  Status,
  "Facebook", "/FB",
  "Twitter", "/TW",
  "Instagram", "/Instagram"
)

Oops, I meant the table’s primary field.

Oh this is in the right direction I think. Although I’m trying to have it update the primary field, which will already have text entered. Thanks for helping me work through this!

Well you can do that with an automation then since there is already data there in the primary field.

You would need a formula field to help you though SWITCH( Status, "Facebook", "/FB", "Twitter", "/TW", "Instagram", "/Instagram" )

then use the output in this formula field to append the Primary field.