Need Content Title to Update Based on a Single Select Status

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!

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!

1 Like

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.