Visible property

NamedValue.Visible — Logical

Special value available in formulas:

Item

NamedValue

The named value this property is part of, enabling multiple checked items in the app designer to share the same formula and be updated all at once.

Consider the fields Field1 and Field2, which should only be considered to be valid if their values are greater than 4. Without using the Item value, the Valid property of Field1 would need to use the formula Field1 > 4Field1 > 4 and the Valid property of Field2 would need to use the formula Field2 > 4Field2 > 4.

Using Item, both formulas can read Item > 4Item > 4. This is useful if you have many fields and you want to be able to update their formulas all at once. To do so, click their check boxes in Calcapp Creator and make sure that a checked field is selected. Then, when you update a formula for one checked field, you update all the other checked fields too, which is a great timesaver.

Use Item in exactly the same way you'd use the regular name. NamedValue1.VisibleNamedValue1,Visible and Item.VisibleItem,Visible are equivalent, for instance.

Whether the named value is visible.

Named values are intended to be used to help cut down on repetition in formulas and to represent array data. As such, named values are by default invisible, and they are expected to be hidden in the apps you ship to users.

However, making named values visible can be helpful while developing an app. By making a named value visible, you can inspect the value it represents, which may shed light on why a formula referencing this named value does not work as expected.

You can also add a visible named value expressly for the purpose of inspecting a value in your app. A number field, switch field or a text field may also be used, but these fields can only be used to inspect numbers, logical values (TRUE or FALSE) or text strings, respectively.

In order to inspect the value of an array with a text field, you need to jump though hoops to convert the array to a text string first. There are no hoops to jump though with named values, as they can represent, and visualize, any value a formula can return.

Examples

SettingsScreen!ShowHiddenValuesSettingsScreen!ShowHiddenValues

Displays a hidden named value only if the switch field ShowHiddenValues, of the form screen SettingsScreen, has been toggled to its "on" position.

App.UserEmailAddress = "admin@example.com"App,UserEmailAddress = "admin@example.com"

Displays a hidden named value only if the signed-in user is admin@example.com.

USERHASTAG("Administrator")USERHASTAG("Administrator")

Displays a hidden named value only if the Administrator tag is associated with the signed-in user.