Skip to main content

Field Types in Table Form Controls

Updated

All FireStart Business Entity field types are supported in both the Editable Tables and the Selection Tables. Every column of the Table can be bound to a Business Entity field and be of one of these types, should be edited by type and/or can be sorted accordingly:

  • Booleans
  • Passwords
  • Numbers
  • Dated
  • Times
  • Attachment Fields
  • Formulas

Text, Passwords and Booleans

Passwords can not be sorted due to security reasons. In editable tables, all three types can be edited inline without opening the full row editing popup form.

Field Types in Table Form Controls 1

Numbers

Numbers can be sorted by their internal value. They can be displayed in their localized version and can be entered in their localized form in editable tables (decimal point (English) vs. decimal comma (other languages)):

Field Types in Table Form Controls 3

The value of a number field is validated during input. An invalid entry will be framed in a colored border and clicking out of the control during this state resets the content to its previous value.

Field Types in Table Form Controls 4

Dates, Times and DateTimes

The various dates and times and their combinations are all displayed in a localized form, can be edited inline in the editable tables and are sorted by their internal ISO string.

In full row editing mode from the editable tables, each of the types gets a specialized control that is also available in inline editing mode.

Field Types in Table Form Controls 5



Date

Display and Sort

unsorted, sorted EN, sorted DE

Field Types in Table Form Controls 6

Edit in inline mode

Field Types in Table Form Controls 7

Time

Can now also be edited in inline mode in editable tables and is sorted by the internal value and shown localized (English with AM/PM).

Field Types in Table Form Controls 8
DateTime

Combination of Date and Time can also be edited in inline mode and is displayed localized and sorted by the internal invariant value.

Field Types in Table Form Controls 9

Attachments

Binding a column to an attachment field shows a list of all the attachments available in this field with an icon, filename and file size for each of them. This feature also carries over to the old selection table control.

The filename is clickable and opens the attachment in the browser (if supported) or starts a download of the file.

Field Types in Table Form Controls 10

Opening a table row with an attachment column in full row editing mode in the editable table control gives users a popup form. This form displays a file input control like the ones that are already available in existing FireStart forms.

The file input control gives users the ability to download, upload and remove files from the bound attachment field.

Field Types in Table Form Controls 11

If the attachments are stored in a third party system like SharePoint instead of directly in the FireStart File DB, loading all the meta information can be really slow for longer lists. So in these cases, the attachment information is only loaded on demand.

Field Types in Table Form Controls 12

Users have to click in the table cell they want to reveal so that a loading mechanism starts that gets all the information needed from the third-party system to show a list of all the files in this attachment field. During the loading process a loading animation is shown in the cell and when finished the files are revealed.

Field Types in Table Form Controls 13

This process does not take long for a single row but can be very slow if it would be done for all rows at the start, depending on the system it is bound to. In full row editing mode, the file input control shows the content of the attachment field from the start.

 

Formulas

Add an additional column and click on the Edit formula button.

overview-2021-06-24-1
This brings you to the “Formulas” tab of the property panel, where you can edit and create formulas that can be used in table controls to make calculated field columns. These columns display values are calculated based on other columns of the same business entity or the value of other controls, during runtime.

 

Related to