Reference property

TextDropDownField.Reference — TextDropDownField

A reference to the text drop-down field.

Referencing a text drop-down field is useful when writing formulas for the IncludedFields property of open report buttons, email report buttons, server relay buttons and reset buttons. When a text drop-down field is referenced from these formulas, it is made part of a report, is sent to a server or is reset, depending on the button.

This property is a read-only property, meaning that no formula can be assigned to it.

Referencing text drop-down fields from formulas

When referencing a text drop-down field from a formula, there is no need to write .Reference,Reference after the field name if a reference is sought. These formulas are equivalent when associated with the IncludedFields property of email report buttons:

{ TextDropDownField1, TextDropDownField2 }{ TextDropDownField1; TextDropDownField2 }
{ TextDropDownField1.Reference, TextDropDownField2.Reference }{ TextDropDownField1,Reference; TextDropDownField2,Reference }

Above, the IncludedFields property is looking for an array of references. As TextDropDownField1 and TextDropDownField2 can return references through their Reference properties, .Reference,Reference is implied.

Examples

{ TextDropDownField1 }{ TextDropDownField1 }

This formula is associated with the IncludedFields property of an open report button and causes the referenced text drop-down field to be included in the report.

{ TextDropDownField1.Reference }{ TextDropDownField1,Reference }

This formula is associated with the IncludedFields property of an open report button and causes the referenced text drop-down field to be included in the report. Writing out the Reference property in formulas (by writing TextDropDownField1.ReferenceTextDropDownField1,Reference) is rarely necessary.

IF(ResetAllFields, { App }, TextDropDownField1:TextDropDownField10)IF(ResetAllFields; { App }; TextDropDownField1:TextDropDownField10)

This formula is associated with the IncludedFields property of a reset button. If the ResetAllFields switch field is toggled to its "on" position, all fields of the app are reset (courtesy of AppApp being part of the first array). Otherwise, only TextDropDownField1, TextDropDownField10 and all fields that appear between them are reset.