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. Sastri

  • Would you like to show as $2,00,000/$3,00,000? – Santanu Boral Oct 1 '18 at 6:28
  • yes...I need to get '/' in between both values – Sastri Oct 1 '18 at 6:34

That's not possible using native currency field. Text field is your option here.

But you can use Trigger+ Text field to easily achieve same format. Just check in your trigger if 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 single field.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.