Configure column properties

Column type

Property

Description

Address, LatLong, XY

See also: Mappable types

Optional Url for KML File

Specify a URL to a Keyhole Markup Language {KML) file used to display geographic data, most commonly on platforms like Google Earth or Google Maps, that allows for embedding and displaying location points, borders and shapes with different styles. See Use KML layers to display geographic data.

Geocoding enabled?

Turn on to allow geocoding of Address column types. See Geocode addresses.

Note: Applies to Address column types only.

Background image for the XY coordinates

Specify a URL for the image to use as the background image of the XY coordinates. See Mappable types.

Note: Applies to XY column types only.

ChangeCounter, ChangeLocation, ChangeTimestamp

See also: Track changes using Change column types

Columns

Add columns to be tracked for changes.

Values

Add the column values that trigger the change tracker.

Update mode

Control how the counter increments when data changes occur. 

• Accumulate (default): In this mode, the counter increments by one based on the number of times a tracked change occurred in a row. An individual row update might occur through a single save of a form, a single Quick Edit in a detail view, or a single action.
• Reset: In this mode, the counter resets to its initial value at the beginning of each update and counts the total number of changed columns that triggered the counter within that update. This mode makes it easy to detect that a particular change occurred during a given update, which is useful for setting up automations that only fire when a specific change occurs.

Note: Applies to ChangeCounter column types only.

Color, Enum, EnumList, Progress

See also: Enumerated types

Values

Add values that are presented as options.

Allow other values

Turn on to permit values that are not explicitly defined by the Values property.

Must be enabled if Valid If or Suggested values are used to specify values that are not defined by Values.

If on, Valid If may be used to limit what values are allowed beyond those defined by Values (if any).

Auto-complete other values

Turn on to allow AppSheet to auto-complete previously entered values to foster consistency and minimize typos.

Note: Allow other values must be enabled for this property to have any effect.

The values suggested when this property is on are in addition to those defined by Values and those provided by Valid If and Suggested values.

Base type

Select the base type for the values in the list.

Input mode

Select how you want to display the values. Valid settings include:

• Auto - Allow AppSheet to choose.
• Buttons - Horizontally stacked buttons.
• Stack - Vertically stacked buttons.
• Dropdown - Drop-down list.

Item separator

Enter one or more characters to use as the separator between each item.

Note: Applies to EnumList column types only.

Date

Use long date format

Turn on to allow use of long date formats.

DateTime

Ignore seconds

Turn on to ignore the seconds if specified in the date and time value.

Minimum date

Specify the minimum date allowed.

Maximum date

Specify the maximum date allowed.

Use long date format

Turn on to allow use of long date formats.

Decimal, Number, Percent, Price

Numeric digits

Set the number of numeric digits allowed.

Show thousands separator

Turn on to show the separator for values in the thousands. For example: 1,000

Display mode

Select a display mode. Valid settings include:

• Auto - Allow AppSheet to choose.
• Standard - Use +/- icons to increase or decrease value.
• Range - Use a range slider to select value.
• Label - Use a text box to enter value.

Maximum value

Set the maximum value allowed.

Minimum value

Set the minimum value allowed.

Increase/decrease step

Decimal digits

Set the number of decimal digits allowed. 

Note: Applies to Decimal column types only.

Currency symbol

Select the currency symbol in the drop-down.

Note: Applies to Price column types only.

Drawing, File, Image Signature, Thumbnail

Image/File folder path

Enter the folder path where images and files are saved using the Expression Assistant. Leave blank to use the default behavior.

Note: This value is only respected by some data sources.

Save externally

Not used.

Note: Shown for Signature column types only.

Duration

Ignore seconds

Turn on to ignore the seconds if specified in the duration value.

LongText, Name, Text

Maximum length

Set the maximum length.

Minimum length

Set the minimum length.

Phone

Callable

Turn on to allow calls to the number.

Textable

Turn on to allow texts to the number.

Ref

See also: References between tables

Source table

Select the table referenced by the column from the drop-down.

Is a part of?

Turn on to indicate that rows are considered to be part of the referenced source table. They can be added as line items in the form view of the referenced table and will be deleted if the referenced row is deleted. The deletes will not trigger automation rules.

External relationship name

Enter the name to use when referencing externally.

Input mode

Select how you want to display the values. Valid settings include:

• Auto - Allow AppSheet to choose.
• Buttons - Horizontally stacked buttons.
• Dropdown - Drop-down list.

Show

See also: Improve the presentation of detail and form views using Show types

Category

Select one of the categories from the drop-down based on the information you want to display.

Content

Enter the content to display for the Show type using the Expression Assistant. To just create a page break, leave this field blank. For example: "Update Information"

Time

Ignore seconds

Turn on to ignore the seconds if specified in the time value.

Url, Video

Launch externally

Turn on to open in your mobile device's browser.

Is hyperlink

Turn on to write values to a spreadsheet as clickable links rather than URL values.

Note: Applies to Url column types only.

Yes/No

Yes/No display values

Enter an expression that defines the custom display values for Yes or No. Defaults to Y and N.