Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Combining Fields and additional text based on Field Value

Topic Labels: Formulas
797 1
cancel
Showing results for 
Search instead for 
Did you mean: 
todcrowe
4 - Data Explorer
4 - Data Explorer

I have the following Fields

Template Type (options are either TEXT Only or With Weblink)

Title Line

Copy

Name of Link

URL

 

When user selects Template Type Text Only, I need a field that will display the full text and contents:

{"iconName":"safety","text":"Copy","title":"Title Line"}

When a user selects Template Type With Weblink, I need a field that will display the full text and contents:

{"title":"Title Line","text":"Copy","externalURLdisplayName":"Name of Link","externalURL":"URL","iconName":"safety"}

 

1 Reply 1
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @todcrowe,

This can be accomplished with a formula field using a SWITCH() statement or two IF statements