Single Line Text

Single line text fields are designed for inputting brief text and are a fundamental field type commonly used in databases. They are ideal for adding short text values in a table.

Users can enter text by clicking on a cell and typing directly. Standard text editing operations such as cut, copy, and paste are also supported.

Entered text can be utilized for filtering and sorting purposes. It supports text processing functions for extraction among other operations. Moreover, users can easily set default values for text fields to minimize repetitive input.

Show as

There are four common show as set for text fields:


This is the standard display format, where the text is shown without any special attributes.


Text set to display as a URL will open the user's default browser and navigate to the web address upon clicking.


Text set to display as an email address will open the user's default email application (such as Outlook, Mail, etc.) upon clicking.


Text set to display as a phone number will open the user's default communication app (such as FaceTime, Skype, etc.) upon clicking.

Setting the show as

  1. Right-click on the single line text field.

  2. Select "Edit Field."

  3. In the dialog that opens, choose the desired format and save.

Show as are not only applicable in single line text fields but can also be used in formula fields, summary fields, and references. For more details, please see show as.

Last updated