Validation Rules & Formulas

If i enter a number 100 then after saving of record it should be populated as one hundred only.
it should be work for 3 digit numbers..done in workflow ??

May 23, 2017
·
Like
0
·
Follow
1

Best Answer chosen by Sam Arora

Maharajan C
Hi Shanky,

You can use the formula field with return type Text or you can use the workflow with a field update in the some other Text Fields with the hep of below formula:

Replace the Enter_Number_Here__c with your field in Formula.This formula can only handle up to "999" though.
CASE(LEFT(TEXT(Enter_Number_Here__c / 100),1),
"1", "ONE HUNDRED",
"2", "TWO HUNDRED",
"3", "THREE HUNDRED",
"4", "FOUR HUNDRED",
"5", "FIVE HUNDRED",
"6", "SIX HUNDRED",
"7", "SEVEN HUNDRED",
"8", "EIGHT HUNDRED",
"9", "NINE HUNDRED",
""
)
& " " &

CASE(
LEFT(TEXT(MOD(Enter_Number_Here__c ,100) /10),1),
"2", "TWENTY",
"3", "THIRTY",
"4", "FORTY",
"5", "FIFTY",
"6", "SIXTY",
"7", "SEVENTY",
"8", "EIGHTY",
"9", "NINETY",
"1", IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "10", "TEN",
IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "11", "ELEVEN",
IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "12", "TWELVE",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "13", "THIRTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "14", "FOURTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "15", "FIFTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "16", "SIXTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "17", "SEVENTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "18", "EIGHTEEN",
   IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100)),2) = "19", "NINETEEN",

""
   )))))))))),

""
)

& " " &

IF(LEFT(TEXT(MOD(Enter_Number_Here__c ,100) /10),1) <> "1",
CASE(
TEXT(MOD(
MOD(Enter_Number_Here__c ,100),10)),
"1", "ONE",
"2", "TWO",
"3", "THREE",
"4", "FOUR",
"5", "FIVE",
"6", "SIX",
"7", "SEVEN",
"8", "EIGHT",
"9", "NINE",
""
), "")

Can you please Let me know if it works or not!!!

If it works mark this as a best answer!!!

Thanks,
Raj

May 23, 2017
·
Like
1
·
Dislike
0

This was selected as the best answer

Sam Arora
Error: Formula result is data type (Text), incompatible with expected data type (true or false).

May 23, 2017
·
Like
0
·
Dislike
0

Maharajan C
Don't choose the checkbox as a return type in fromula field.choos as like in below screenshot.

Can you please Let me know if it works or not!!!

If it works mark this as a best answer!!!

Thanks,
Raj

May 23, 2017
·
Like
0
·
Dislike
0

Sam Arora

May 23, 2017
·
Like
0
·
Dislike
0

Maharajan C
Don't use this formula in the Workflow criteria

-> Just set the criteria as field(The number field you used to get the numbers) not equalto null as like in below:

Then create a Field update like in below:

Can you please Let me know if it makes sense to you!!!

If it works mark this as a best answer!!!

Thanks,
Raj

May 23, 2017
·
Like
0
·
Dislike
0

Sam Arora
Which one formula is used in workflow criteria please suggest me if you have any idea ???

Thanks it works... but please tell me in workflow criteria???

May 24, 2017
·
Like
0
·
Dislike
0

Maharajan C
Ok Cool!!!

Just use like below screenshot:

:

Can you please Let me know if it makes sense to you!!!

Dont forget to mark the best answer!!!

Thanks,
Raj

May 24, 2017
·
Like
0
·
Dislike
0

Sam Arora

Thanks Maharaja C.......

May 24, 2017
·
Like
0
·
Dislike
0

Maharajan C
LOL Its my bad you are choosing the best answer the answer by you!!!

Thanks for giving credit to all my works!!!

May 24, 2017
·
Like
0
·
Dislike
0

Sam Arora
I didn't see ...Sorry 4 That..

May 24, 2017
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Validation Rules & Formulas

All Answers

You need to sign in to do that.