I have a picklist field (QR_Service__c) with a value of "IA".
Another picklist field (Tax_Prep__c) with a value of "Yes".
I have a formula field (Quallified_Service__c) which combines the values of both picklists and outputs it to a text field (Qualified_Service__c) as: "Yes + IA"

I want to be able to change the word, "Yes" to "Tax Prep".
This would change the output to "Tax Prep + IA"

But if "No" is selected in the (Tax_Prep__c) picklist, the final output would be: "IA"

I tried a CASE function but its not accurate because I don't have the Yes or the No variable to determine the actual output. If someone was to select No, they would receive the same output as Yes, as shown here.

CASE (QR_Service__c,
"IA",'Tax Prep + IA',
"")

This is what the front end looks like.


Any ideas on how to properly get the value of No to help determine the output would be great.

Thanks!
 

Hello,

I created a Date Field in custom object TiFF1040 and named the Date field, Date Director of Sales Approved TiFF. The date renders perfectly in a regular lightning page, however, when I place the following string in Visualforce, it produces this output: Mon Jul 22 00:00:00 GMT 2019

However, I need it to show as 7/22/2019.

Any help is appreciated.

Thank you!

 

{!TiFF1040__c.Date_Director_of_Sales_Approved_TiFF__c}

 

I have a picklist field (QR_Service__c) with a value of "IA".
Another picklist field (Tax_Prep__c) with a value of "Yes".
I have a formula field (Quallified_Service__c) which combines the values of both picklists and outputs it to a text field (Qualified_Service__c) as: "Yes + IA"

I want to be able to change the word, "Yes" to "Tax Prep".
This would change the output to "Tax Prep + IA"

But if "No" is selected in the (Tax_Prep__c) picklist, the final output would be: "IA"

I tried a CASE function but its not accurate because I don't have the Yes or the No variable to determine the actual output. If someone was to select No, they would receive the same output as Yes, as shown here.

CASE (QR_Service__c,
"IA",'Tax Prep + IA',
"")

This is what the front end looks like.


Any ideas on how to properly get the value of No to help determine the output would be great.

Thanks!
 

Hello,

I created a Date Field in custom object TiFF1040 and named the Date field, Date Director of Sales Approved TiFF. The date renders perfectly in a regular lightning page, however, when I place the following string in Visualforce, it produces this output: Mon Jul 22 00:00:00 GMT 2019

However, I need it to show as 7/22/2019.

Any help is appreciated.

Thank you!

 

{!TiFF1040__c.Date_Director_of_Sales_Approved_TiFF__c}