Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Name property

NumberDropDownField.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 drop-down fields matching a certain naming pattern through properties like NumberDropDownFields of form screens. Below, an example returns the sum of all number drop-down field values in the app where the corresponding number drop-down field names include the text string "Weight".

Examples

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

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

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

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

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

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