Here is my formula. I added where I would like to add the carriage return as well as what field I would like bolded:
IF(ISPICKVAL(nihrm__HousingMethodName__c , "Rooming List"),
"Rooming List: Reservations made by Rooming List must be sent by " + TEXT(nihrm__CutoffDate__c) + ". A Master Rooming List template will be sent from 1440 following confirmation of contract. Rooming List template will include guest name paired with share-withs, if applicable.",
IF(ISPICKVAL(nihrm__HousingMethodName__c , "Individual Call-In"), "Individual Call-In: In order to assign individuals to specific rooms, room reservations will be required. Your attendees must call 844-544-1440 to book their reservation or book online via the provided link before the reservations Cut-Off date of " + TEXT(nihrm__CutoffDate__c) + ". When calling, each of your attendees must identify themselves as part of the group " + (Name) + ". Share-with requests will only be honored if the other guest has already made their reservation. 1440 will hold the rooms and negotiated rates listed in the section above named “Guestroom Package Accommodations” for Group participants to reserve on a first come first serve basis.
Online Group Reservation Link: As part of your booking package, 1440 will provide your guests a website to book overnight accommodations. This link will be provided to the Group main contact for distribution directly to your participants. 1440 will not be responsible for guest conference registration.",
IF(ISPICKVAL(nihrm__HousingMethodName__c , "Rooming List / Call-In"),
"Rooming List: Reservations made by Rooming List must be sent by " + TEXT(nihrm__CutoffDate__c) + ". A Master Rooming List template will be sent from 1440 following confirmation of contract. Rooming List template will include guest name paired with share-withs, if applicable.
Individual Call-In: In order to assign individuals to specific rooms, room reservations will be required. Your attendees must call 844-544-1440 to book their reservation or book online via the provided link before the reservations Cut-Off date of " + TEXT(nihrm__CutoffDate__c) + ". When calling, each of your attendees must identify themselves as part of the group " + (Name) + ". Share-with requests will only be honored if the other guest has already made their reservation. 1440 will hold the rooms and negotiated rates listed in the section above named “Guestroom Package Accommodations” for Group participants to reserve on a first come first serve basis.
Online Group Reservation Link: As part of your booking package, 1440 will provide your guests a website to book overnight accommodations. This link will be provided to the Group main contact for distribution directly to your participants. 1440 will not be responsible for guest conference registration.",
NULL)))
12 件の回答
The Carriage Return you can easily do with a simple
+ BR() +
Function
Unfortunately there are no Text Format Function in Formulas, for that you're getting into VisualForce, HTML, or CSS, or whatever the kids are into these days
