Each field of any table can have an interface convenient for its function. Fields can only have one type of interface at a time.
By clicking the field name, you can select the most convenient interface for that field. The type of interface selected will appear in the left most position of the row of interface icons above the header line.
Field Name: FrameLink supports in-place editing which means that you can edit any field name simply by clicking in the heading of that field. (If you have Designer Permission)
Text - To be used when simple text is needed. (The default interface).
LongText - To be used when multiple text lines are needed. This interface shows the field’s collapsed content when the user hovers over it.
Number - To be used when only numbers should be allowed. The designer can define the decimal part of the number (eventualy none) and the units (any currency or text).
Email - To be used to register email adresses. This interface will make Email services available.
Phone - To be used to register phone numbers. The designer can define the default prefix and country format. This service will make SMS services available.
Date & Time - To be used for dates (only dates or date & time). The designer can choose the date format. This interface allows you to define a date by using a calendar oe editing text.
Image - To be used to collect an image.
Logical - To be used in yes/no situations. This interface will initially show a checkbox with an undefined value (a dash) that the user can enable (a tick will appear) or disable (the checkbox will become empty). Note that checkboxes have 3 possible states: Undetermined, Checked or Unchecked.
URL - To be used to refer to any accessible URL. The designer may use this interface to access a web site, a document, a folder of documents, etc.
Linked Field - This interface builds a bridge between the current field and one or more fields of another table. The designer uses it to define a pulldown, with content from another table. The user may select any record or create content in the table referred by this interface.
Formula - To be used to show the result of a numeric operation with fields from the current table or one or several tables referred by linked Fields. In addition to comprehending numbers, these operations can also consider dates and date periods.
Lookup - This interface shows the content of any field of any of the tables referred by a linked field. Lookup fields are for visual reference only and can only be edited from their source table.