Guide to FrameLink

Field Interfaces

Each field of any table can have an interface convenient for its function. Fields can only have one type of interface at a time.

Click the field name and select the most convenient interface for that field. The selected type will appear on the left most position of the row of interface icons above the header line.
Field Name: FrameLink supports in-place editing. With Designer permissions you can click the field heading and edit the field by changing its name, updating its field type, enlarging it, changing its position, defining its sort order, locking it as an always visible leftmost column or removing it.
FrameLink user types FrameLink user types FrameLink user types

Interface Options:

  • Text - To be used when simple text is needed. (The default interface).
  • text user type

  • LongText - To be used when multiple text lines are needed. This interface shows the field’s collapsed content when the user hovers over it.
  • longtext user type

  • 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 (such as currency, any measure or none).
  • numeric user type

  • Email - To be used to register email adresses. This interface will make Email services available.
  • email user type

  • 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.
  • phone user type

  • 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 or editing the date text.
  • date user type

  • Image - To be used to collect an image (such as photo, logo, drawing etc). When the mouse hovers the image it will automatically enlarge.
  • image user type

  • 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.
  • logical user type

  • URL(Universal Resource Locator) - To be used to refer to any internet content such as Youtube Videos, Facebook Pages, LinkedIn Pages, Dropbox Documents, Google Drive Documents etc. You also can link to any application with an accessible URL.
  • url user type

  • 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.
  • linkedfield user type

  • 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.
  • formula user type

  • 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.