Help

Re: Need Content Title to Update Based on a Single Select Status

1628 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Eric_Grundhause
5 - Automation Enthusiast
5 - Automation Enthusiast

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.