Number, Currency & Percentage Fields

 

 

This article explains how Number, Currency, and Percentage fields work in the Sintel Apps Designer and how to configure them correctly. When added to a form, they create corresponding numeric columns in the underlying SharePoint list.

1. Number Field

What It Is – A general-purpose numeric field for whole numbers or decimals.

Best Used For: 

• Quantities
• Scores
• Counts
• Numeric references
• Measurements

Key Properties:

Decimals – Controls the number of decimal places allowed. Can be set manually or left as Automatic.

Minimum Value –  Defines the lowest allowed value.

Maximum Value – Defines the highest allowed value.

Default Value – Set a pre-filled number if required.

Calculated – If enabled, the value can be calculated (used in advanced scenarios).

Placeholder – Text shown before a value is entered.

When to Use:

Use Number when the value:

• Does not represent money
• Is not a percentage
• Needs numeric validation
• May be used in logic or calculations

 

2. Currency Field

What It Is: A numeric field specifically formatted for monetary values.

Best Used For: 

• Budget amounts
• Expense claims
• Project costs
• Financial approvals

 

Key Properties:

Decimals – Controls decimal precision (typically 2).

Minimum / Maximum Value – Restrict allowed monetary range.

Format – Defines currency display format (e.g. $1,234.56).

Default Value – Pre-populate with a value if required.

Calculated – Can be used in calculated scenarios.

 

When to Use

• The value represents money
• Formatting consistency is important
• The field may appear in financial reporting
• Workflow approval thresholds depend on amount

 

3. Percentage Field

What It Is: A numeric field formatted as a percentage.

Best Used For

• Completion rates
• Risk levels
• Allocation percentages
• Performance metrics

Key Properties

Decimals – Controls precision of the percentage value.

Minimum Value – Typically set to 0.

Maximum Value – Commonly set to 100.

Default Value – Pre-fill if necessary

Calculated – Can be enabled for formula-based results.

When to Use

Use Percentage when:

• The value represents a proportion

• You need validation within a 0–100 range

• The value may drive logic conditions

 

 

Shared Properties (All Three Types)

All numeric fields also include:

• Title – Field label

• Required – Makes the field mandatory

• Unique – Prevents duplicate values (rarely used)

• State – Editable, Read-only, or inherited

• Label settings – Position and tooltip

• Theme and Styling – Font, size, colour

These fields can also be used in Logic rules and Workflow conditions.

Number vs Currency vs Percentage

Using Numeric Fields in Logic

Numeric fields are commonly used to:

• Trigger approval levels

• Validate ranges

• Show or hide sections

• Calculate totals

Example:

If Total Cost > 10,000, require Director approval.

Numeric validation improves process control.

Best Practices

• Test numeric-based workflow conditions thoroughly.

• Avoid Using Number instead of Currency for financial data

• Don’t allow unnecessary decimal places

 

➡️ Next article: Date and Time Fields – Configuration and Best Practices

Was this article helpful?

0 out of 5 stars

5 Stars		0%
4 Stars		0%
3 Stars		0%
2 Stars		0%
1 Stars		0%

5 Submit

Please Share Your Feedback

How Can We Improve This Article?

Name

Email

Submit