Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Name property

DateTimeField.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 date and time fields matching a certain naming pattern through properties like DateTimeFields of form screens. Below, an example returns the latest date represented by all date and time fields whose names include the text string "Spring".

Examples

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

Returns a comma-separated text string containing the names of all date and time fields of the app.

MAX(FILTER(App.DateTimeFields, CONTAINS(App.DateTimeFields.Name, "Spring")))MAX(FILTER(App,DateTimeFields; CONTAINS(App,DateTimeFields,Name; "Spring")))

Returns the latest date represented by all date and time fields whose names include the text string "Spring".

LET(SpringFields := FILTER(App.DateTimeFields, CONTAINS(App.DateTimeFields.Name, "Spring")), TEXTJOIN(NEWLINE(), FALSE, SpringFields.Label & " — " & SpringFields.Value))LET(SpringFields := FILTER(App,DateTimeFields; CONTAINS(App,DateTimeFields,Name; "Spring")); TEXTJOIN(NEWLINE(); FALSE; SpringFields,Label & " — " & SpringFields,Value))

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