Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Name property

NumberField.Name — Text

The name, as assigned in Calcapp Creator.

Field names are normally assigned automatically by Calcapp Creator based on their labels, though a name can be provided manually as well.

Providing names manually makes it possible to find all number fields matching a certain naming pattern through properties like NumberFields of form screens. Below, an example returns the sum of all number field values in the app where the corresponding number field names include the text string "Weight".

Examples

TEXTJOIN(", ", FALSE, App.NumberFields.Name)TEXTJOIN(", "; FALSE; App,NumberFields,Name)

Returns a comma-separated text string containing the names of all number fields of the app.

SUM(FILTER(App.NumberFields, CONTAINS(App.NumberFields.Name, "Weight")))SUM(FILTER(App,NumberFields; CONTAINS(App,NumberFields,Name; "Weight")))

Returns the sum of all number field values in the app where the corresponding number field names include the text string "Weight".

LET(WeightFields := FILTER(App.NumberFields, CONTAINS(App.NumberFields.Name, "Weight")), TEXTJOIN(NEWLINE(), FALSE, WeightFields.Label & " — " & WeightFields.FormattedValue))LET(WeightFields := FILTER(App,NumberFields; CONTAINS(App,NumberFields,Name; "Weight")); TEXTJOIN(NEWLINE(); FALSE; WeightFields,Label & " — " & WeightFields,FormattedValue))

Returns a text string containing the labels and formatted values of all number fields whose names include the text string "Weight". Labels and formatted values are separated from one another with hyphens, and fields are separated from one another with line breaks.