Remove Currency Options for a particular field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2022 04:54 AM
Hi Team,
I have a requirement to clear few currency options for a certain field. Can you help me out how can we achieve it?
Thanks in Advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2022 01:32 AM
Hey,
I think this is a global change itself rather than for a particular field but let me explore if we can anyhow meet your requirement.
Thanks,
Shreya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2022 01:52 AM
Hi Yesh,
The currency field symbol values are used globally therefore, we can't change the values for a particular table or conditions.
In order to achieve your requirement, you can create two separate fields one a drop-down with your limited currency symbols and other an integer and maybe merge these two in another field to present the value on the form as a read-only field.
Even if you are calculating something based on the currency value you can then refer the integer field and go ahead with the calculation code.
I will still look into this if there is any way to achieve your scenario.
Thanks,
Shreya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2022 03:00 AM
Hi Sherya,
Thank you for your suggestion. But we are trying to achieve it in one Field only. Don't want to use multiple fields to achieve this.
Thanks,
Yesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2022 03:03 AM
Hey,
I understand! I tried looking into multiple options but couldn't find any way of achieving this.
It is a global change across the instance, if we disable a single Symbol on the fx_currency table it will reflect on all the tables.
Thanks,
Shreya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-11-2022 07:49 AM
Eureka! Try this with a client script: