-
ChatterFeed
-
1Best Answers
-
1Likes Received
-
0Likes Given
-
2Questions
-
2Replies
How to convert a picklist value to a different value + combine it to another picklist value to = a new combine string
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.

Any ideas on how to properly get the value of No to help determine the output would be great.
Thanks!
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!
-
- HanSolo
- August 09, 2019
- Like
- 0
- Continue reading or reply
Lightning:InputField of date type accepting dummy text and saving as null.
Hi All,
We have a Lightning:InputField of date type. It's accepting dummy text like 'asdf' and saving as null to database.
How can I prevent user to enter dummy text rather than a proper date?
We have a Lightning:InputField of date type. It's accepting dummy text like 'asdf' and saving as null to database.
How can I prevent user to enter dummy text rather than a proper date?
-
- Surender_Patel
- June 21, 2018
- Like
- 1
- Continue reading or reply
LIghtning:inputField not accepting null values for Currency type. Getting error that "cannot be parsed as a number, Value: null, Runtime class: java.lang.String"
Hi All,
When we are trying to removing value in currency field (using lightning:inputField ) and try to update, It's throwing above said error.
Please help.
When we are trying to removing value in currency field (using lightning:inputField ) and try to update, It's throwing above said error.
Please help.
-
- Surender_Patel
- June 21, 2018
- Like
- 0
- Continue reading or reply
Lightning:InputField of date type accepting dummy text and saving as null.
Hi All,
We have a Lightning:InputField of date type. It's accepting dummy text like 'asdf' and saving as null to database.
How can I prevent user to enter dummy text rather than a proper date?
We have a Lightning:InputField of date type. It's accepting dummy text like 'asdf' and saving as null to database.
How can I prevent user to enter dummy text rather than a proper date?
-
- Surender_Patel
- June 21, 2018
- Like
- 1
- Continue reading or reply
How to convert a picklist value to a different value + combine it to another picklist value to = a new combine string
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.

Any ideas on how to properly get the value of No to help determine the output would be great.
Thanks!
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!
- HanSolo
- August 09, 2019
- Like
- 0
- Continue reading or reply
Starts with Vowel Sound
Hi,
Can anyone please let me know why is this checkbox 'Starts with a vowel sound' is used while creating objects in salesforce?
I read somewhere that 'This is used for languages where words need different treatment depending on the first character'.
If anyone can explain me with example on how it works that would be great.
Thanks in advance
Priya Nair
- VN
- April 26, 2010
- Like
- 0
- Continue reading or reply