Currency

Use the Currency form control to create fields that accept monetary formats.

Note: You can arrange up to four of this control on a single row in the form.

Section Setting Description
(unlabeled) Title

Title for the field that will appear on the published form.

 

Name

Type a name for your Currency control for identity in the form designer. A variable of the same name is generated to hold the value that a user will enter in the Currency field.

To edit the Name, make sure to turn ON the toggle under Customize. If toggle is left OFF, the Name and Title will be the same.

  Connected to

Connect to a SharePoint column.

Only SharePoint columns of the same type as the selected control are available in the drop-down list. When connected, data entered via that field in the form is entered in the selected SharePoint column.

 

Currency type

Select a currency and monetary format.
 

Number of decimal places

You can choose up to five decimal places.
 

Default value

The value which automatically populates the field when the form loads.

Click in this field, and then click Insert to launch the Formula builder where you can create variables with applied formulas. The calculated value becomes the default value.

 

Range validation

If you want to set minimum and maximum range for the input values, turn ON the toggle under Use range validation, and the do the following:

  1. In Minimum value, specify the minimum value that your Currency field will accept.
  2. In Maximum value, specify the maximum value.
  3. In Range validation error message, specify a message that appears on the form when user enters out-of-range values.

For example, you may want the Currency field to accept between $100 and $500 only and if a user enters $750, then an error message displays: "The amount you entered exceeds the limit".

  Required

To require users to enter values in the Currency field, select Yes from the drop-down.

 

Custom required message

(Displays when you select Yes in Required)

The validation text which displays below the field when a value is not entered into the field and the user attempts to change page or submit the form.

  Visible To make the Currency field invisible on form load, select No. By default, Yes is selected.
  Read-only To make the Currency field as read-only, select Yes. If No is selected, users cannot enter values in the Currency field in published forms.
  Description

A description of the field to display below the field on the published form.

The description text will appear below the Currency field, in italic font style. For example, a description can inform user about the accepted minimum and maximum values.

  Tooltip Type any tips that may be helpful for users. The text will appear when the user hovers over the Tooltip icon.
  Shrink Reduces the width of the control when placed in a row with other form controls.
  Expand Increases the width of the control when placed in a row with other form controls.
Styling CSS class

Add a CSS class to apply a style to this form control. You can create the CSS class in the CSS code editor in form styles. Enter one class name or multiple class names separated by a space.

For more information, see Add a custom CSS to individual controls.

Border color

Border color to apply to the field.

To select a color, click the color box and use the color picker to specify the color you want. You can click on the color map to select the color or enter the Hex code.

To revert back to the global style, click Reset to global style.

  Control fill

The color to fill the inside of the field.

To select a color, click the color box and use the color picker to specify the color you want. You can click on the color map to select the color or enter the Hex code.

To revert back to the global style, click Reset to global style.

  Control input color

The font color of the input in the field.

To select a color, click the color box and use the color picker to specify the color you want. You can click on the color map to select the color or enter the Hex code.

To revert back to the global style, click Reset to global style.