Currency Control is used to accept monetary values by letting the user set the amount and the currency of payment. Currency control has two components - Value & Unit where value accepts Currency value in decimals and Unit is the selection list to select the currency unit i.e. USD, GBP, INR, etc. For example, it can be used for various purposes like making bids or setting quotations for projects or assets.
- Label: Label is the text that is displayed above the Currency Control and helps the user to understand what they are supposed to do with the Currency Control.
- Properties: These properties help you customize the Label by changing the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.
- Type: The Type field is automatically generated depending upon the type of control used. In this case, it is a “timepicker” type.
- Unique Name: A Unique Name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name on the basis of the Label name given to the control. Since Currency is a composite control and consists of two parts it has two unique names one for Value and another for Unit.
- Submit Data: This field lets you determine whether to send the value of the control or not in a Workflow based on various control states. There are three conditions that could be set for this field.
- Always: If this condition is selected, the data in the Currency Control will be submitted irrespective of the state of the Currency Control.
- Never: If this condition is selected, the data in the Currency Control will never be submitted irrespective of the state of the Currency Control.
- No When Hidden: When this condition is selected, the data in the Currency Control will be submitted if the Currency Control is visible and not submitted when the Currency Control is hidden.
- Required: When you select the required option, the field becomes a mandatory field and the user can not submit the form without adding value for the field.
- Read Only: When you select this option, the user will no longer be able to edit this field.
- Hidden: The hidden option helps you to hide the field from the user. This might help to perform some computation you don’t want the user to see or if you want to show certain fields only when a specific condition is met/not met.
- Caching: When the caching option is selected and if a LOOKUP formula is applied to this control, the value that the LOOKUP returns will be cached and the user will be able to see this value in the Currency Control even when he accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offline mode as well and getting the latest data from the sheets always is not critical.
- Hide Label: This option hides the label of the Currency Control from the view.
- Theme: This lets you choose the color of the Container box. You can either enter a custom hex code value or use one from the available themes in the builder.
- Unit color: This is used to set the color in which the unit is displayed.
- Default Unit: This is used to set the default unit, which can be changed by the user while filling the currency field.
- Placeholder: It is a prompt that gives a hint to the user as to what has to be done. It is present in the field and is overridden when the user types something into it.
- Tooltip: This option lets you display a message when the cursor is positioned over the field.
- Format: There are three formatting options available. You can use one of these options as per the function of the numeric control. These options are:
- Normal: The normal format will display the number exactly as it is input by the user.
- Currency: The Currency format rounds off the input value to the nearest whole number.
- Accounting: The Accounting format is used for accounting purposes and it displays the negative values in brackets.
- Max Value: This option lets you to set the maximum value that this field will accept.
- Decimal Precision: Use this property to define the number of digits to be displayed after the decimal point. It can be defined as 0 if no decimal points are desired.
- Show Barcode Scanner: This creates an option to scan a barcode to enter data to the field when a device with a camera is used to access the microapp.
How to Use a Currency Control?
Start with selecting the Currency Control from the Advance section of the Controls Menu.
The Currency Control will then appear on the screen in the builder, you can then set all the above properties as per your requirements.
You can use the F option to bind data to the Currency Control and the V option to add validations to the field. You can learn more about validations here. There are four ways in which you can bind data to the Currency Control.
- Static Data: This allows you to directly type in the text that you want to display.
- Sheet: This allows you to get data from a sheet and display it in the Currency control.
- Control: This allows you to bind data to the Currency control by using another control’s value present in the microapp.
- Formula: This can be used to apply formulas and store the output of those formulas in Currency control. You can learn more about formulas here.
Preview of currency control
Following are the currency options available for the user: