I am using Airtable to create naming conventions. I have used the concatenate function to put together the code:
CONCATENATE({Country Code},"-",{Key Solutions Code},"-",{Digital PRG Code},"-",{Digital Platform Code},"-",Year,"-",Quarter,"-",{Purpose Code},"-",Description)
Digital PRG Type options are Paid Social, Paid Search, Web Content etc.
Digital Platform options are LinkedIn, Facebook etc.
What I am trying to figure out, is that when Digital PRG Type is selected as Web Content, then how can I build the formula to remove the hyphen in the formula campaign name. As of now, this is how the code looks in the front end:
GLB-PP-WC–2022-Q1-LG-TEST (you’ll notice the extra hyphen next to WC (web content) because the value in the table is blank (intended).
What I want to show is the code like this when Web Content is selected.
GLB-PP-WC-2022-Q1-LG-TEST
Thank you!
