Today, I had one particular challenge I had was the need to dynamically display a field on a form based on the currency selected, and calculate its value accordingly. Here's how I tackled it:
Steps:
1.To begin, I had to unlock the properties in the advanced tab, this activates options that are block by default.
2.Next, I changed the display mode to 'Disable’. This ensured that while the field is displayed, users can not manually edit it
3.We'll set up the field to appear or disappear based on the chosen currency. Using conditional formatting.
4.Finally, I set the default value for the label. If the currency was USD, the label would display the value of the original currency text input. For any other currency, the label would automatically calculate the value by dividing it by the exchange rate.
Result
