Range Value Assignment and Field Value Summary Guide

In this guide, we will explain how to use the “Range Value Assignment” field to automatically categorise numeric values into range segments (S, M, L) and then use the “Field Value Summary” field to calculate the most common value across multiple range segments.

What this form demonstrates:

• Converting numeric measurements into categories based on defined ranges
• Automatically determining the most frequently occurring category
• Displaying both the actual value and the percentage of the most common result

1. INITIAL SETUP:

Drag and drop the following fields onto your form:

• A "Paragraph" field (for displaying range instructions)
• Three "Number" fields (for entering measurements)
• Three "Text" fields (for displaying range segment results)
• Three "Range Value Assignment" fields (for converting numbers to categories)
• Two "Field Value Summary" fields (for calculating the most common value)
• Two additional "Text" fields (for displaying summary results)
• Rename the fields as needed.
• Set the fields sequence as shown in the screenshot.

2. CONFIGURE THE "PARAGRAPH" FIELD:

• Click the pencil icon of the "Paragraph" field.
• Set the label to: Measure Ranges: 0-10 S, 11-20 M, 21-30 L
• This serves as a reference for users to understand the range segments.

3. CONFIGURE THE "NUMBER" FIELDS:

First Number Field (Measure 1):

• Click the pencil icon of the first "Number" field.
• Rename the label to: Measure 1
• Leave min/max values empty (no restrictions).
• Note the Component ID (e.g., b68a-2237-be47) - you'll need this later.
• Save the changes.

Second Number Field (Measure 2):

• Click the pencil icon of the second "Number" field.
• Rename the label to: Measure 2
• Note the Component ID (e.g., d3d9-0dc3-6ce1).
• Save the changes.

Third Number Field (Measure 3):

• Click the pencil icon of the third "Number" field.
• Rename the label to: Measure 3
• Note the Component ID (e.g., 111a-c8cb-34d4).
• Save the changes.

4. CONFIGURE THE "TEXT" FIELDS FOR RANGE SEGMENTS:

First Text Field (Range Segment 1):

• Click the pencil icon of the first "Text" field.
• Rename the label to: Range Segment 1
• Set "Read Only" to: Yes (this field will be auto-populated).
• Note the Component ID (e.g., 4898-2fff-1346).
• Save the changes.

Second Text Field (Range Segment 2):

• Click the pencil icon of the second "Text" field.
• Rename the label to: Range Segment 2
• Set "Read Only" to: Yes
• Note the Component ID (e.g., 4644-1e38-a

5. CONFIGURE THE "RANGE VALUE ASSIGNMENT" FIELDS:

Range Value Assignment 1:

• Click the pencil icon of the first "Range Value Assignment" field.
• Rename the label to: Range Value Assignment 1
• Set "Source Field ID" to: b68a-2237-be47 (the Component ID of Measure 1).
• Set "Target Field ID" to: 4898-2fff-1346 (the Component ID of Range Segment 1).
• Configure the Range Segments:
• Segment 1: Min Value = 0, Max Value = 10, Output Value = S
• Segment 2: Min Value = 11, Max Value = 20, Output Value = M
• Segment 3: Min Value = 21, Max Value = 30, Output Value = L
• Enable "Clear Value If Outside Ranges" option.
• Save the changes.

Range Value Assignment 2:

• Click the pencil icon of the second "Range Value Assignment" field.
• Rename the label to: Range Value Assignment 2
• Set "Source Field ID" to: d3d9-0dc3-6ce1 (the Component ID of Measure 2).
• Set "Target Field ID" to: 4644-1e38-a202 (the Component ID of Range Segment 2).
• Configure the same Range Segments as above (S, M, L).
• Enable "Clear Value If Outside Ranges" option.
• Save the changes.

Range Value Assignment 3:

• Click the pencil icon of the third "Range Value Assignment" field.
• Rename the label to: Range Value Assignment 3
• Set "Source Field ID" to: 111a-c8cb-34d4 (the Component ID of Measure 3).
• Set "Target Field ID" to: 4b67-e7a9-8c3a (the Component ID of Range Segment 3).
• Configure the same Range Segments as above (S, M, L).
• Enable "Clear Value If Outside Ranges" option.
• Save the changes.

6. CONFIGURE THE OUTPUT TEXT FIELDS:

Most Common Range Value Field:

• Click the pencil icon of a new "Text" field.
• Rename the label to: Most Common Range Value
• Set "Read Only" to: Yes
• Note the Component ID (e.g., 58cd-32d1-3625).
• Save the changes.

Most Common Range Percent Field:

• Click the pencil icon of another "Text" field.
• Rename the label to: Most Common Range Percent
• Set "Read Only" to: Yes
• Note the Component ID (e.g., 6ff9-7a50-54e8).
• Save the changes.

7. CONFIGURE THE "FIELD VALUE SUMMARY" FIELDS:

Field Value Summary (Actual Value):

• Click the pencil icon of the first "Field Value Summary" field.
• Rename the label to: Field Value Summary Value
• Set "Summary Type" to: most_common_value
• Set "Result Format" to: actual_value
• Set "Output Field ID" to: 58cd-32d1-3625 (the Component ID of Most Common Range Value).
• Add Source Fields:
• Field 1: Field ID = 4898-2fff-1346 (Range Segment 1), Weight = 1
• Field 2: Field ID = 4644-1e38-a202 (Range Segment 2), Weight = 1
• Field 3: Field ID = 4b67-e7a9-8c3a (Range Segment 3), Weight = 1
• Enable "Calculate Only If All Values Entered" option.
• Save the changes.

Field Value Summary (Percentage):

• Click the pencil icon of the second "Field Value Summary" field.
• Rename the label to: Field Value Summary Percent
• Set "Summary Type" to: most_common_value
• Set "Result Format" to: percentage_value
• Set "Output Field ID" to: 6ff9-7a50-54e8 (the Component ID of Most Common Range Percent).
• Add the same Source Fields as above with Weight = 1 for each.
• Enable "Calculate Only If All Values Entered" option.
• Save the changes.

8. TESTING THE FORM:

1. Preview your form.
2. Enter a value between 0-30 in "Measure 1" field.
3. The "Range Segment 1" field should automatically display S, M, or L based on the value.
4. Repeat for "Measure 2" and "Measure 3".
5. Once all three measurements are entered, the "Most Common Range Value" will display the most frequently occurring category (S, M, or L).
6. The "Most Common Range Percent" will display the percentage (e.g., 66.67% if 2 out of 3 values match).

EXAMPLE SCENARIOS:

KEY CONFIGURATION NOTES:

• Range Segments define how numeric values are categorized. Values must fall within the min/max range (inclusive) to receive the output value.
• Clear Value If Outside Ranges ensures the target field is emptied if the source value doesn't fall within any defined range.
• Calculate Only If All Values Entered ensures the summary is only calculated when all source fields have values.
• Weight in Field Value Summary allows you to give more importance to certain fields (all set to 1 in this example for equal weight).

Let me know if you'd like me to adjust the format or add any additional details!

Claude is AI and can make mistakes. Please double-check responses.

For any questions, please contact us - [email protected] or the Formyoula in-app chat.