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!
Need Content Title to Update Based on a Single Select Status
+17Hi @Eric_Grundhauser ,
Welcome to Airtable Community !
What do you mean by Content Title?
+31Hey @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
{Content Title}
&
SWITCH(
Status,
"Facebook", "/FB",
"Twitter", "/TW",
"Instagram", "/Instagram"
)
Hi @Eric_Grundhauser ,
Welcome to Airtable Community !
What do you mean by Content Title?
Oops, I meant the table’s primary field.
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
{Content Title}
&
SWITCH(
Status,
"Facebook", "/FB",
"Twitter", "/TW",
"Instagram", "/Instagram"
)
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!
+17Oh 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.