function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Krishna_225Krishna_225 

How to store Currency in limits in currency field

I have a requirement where I need to store values in currency field as $2,00,000/$3,00,000. Basically, that field will be used to denote limits. I cannot do that using a currency field. WHen I tried to do that using text field, I am not recieving $ symbol(which is mandatory for both upper and lower limits) as the data is bulk uploaded using Data loader. Can anyone please help me with this requirement.
Thank you in advance.
Krish
NagendraNagendra (Salesforce Developers) 
Hi Krishna,

That's not possible using the native currency field. A text field is your option here.

But you can use Trigger+ Text field to easily achieve the same format. Just check in your trigger if the field is not null then add currency sign with that.

Or create two separate fields to store high and low amount and then use formula field to combine them into a single field.

Hope this helps.

Kindly mark this as solved if the reply was helpful so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue.

Thanks,
Nagendra
Krishna_225Krishna_225

Thanks Nagendra...
Can you please help me with the trigger to achieve that functionality as going with two separate currency feilds is not a likable solution for us.

Thank you in advance
Krish