This will set an integer value for the Field when a Record is created. As new Records are created the value assigned will increase by 1 starting with the value entered in the value entered for ‘Next Auto Number’.
Presents a tick box that is either ticked or unticked. The value stored for these are ‘true’ and ‘false’ respectively. If a bit Field is created with no default value then the default value for this Field will be set to 'false'.
Date & DateTime
Date Fields presents a date select Field. Depending on the browser, this will either appear as a pop-up calendar or will require text input in a prescribed format. Date Fields are recognised in report and sorting as dates as opposed to alphabetical sorting. DateTime Fields allow the user to also enter hours, minutes, and seconds. Both Field types are stored in the format yyyy-mm-ddThh:mm:ssZ.
Note: The rendering of date Fields as a calendar pop up is entirely browser specific. The browser takes care of how the Field is rendered, so some browsers may not render a calendar, but most do. Google "HTML5 date Field browser support" to see the specific browser and version support.
Presents a Field for storing an email address. The system will validate that it is a valid email format, and when rendered for the user will allow a single click to launch and send an email from the user’s default mail system.
Use this field type to allow a user to specify a video from an external source
e.g. find the video within youtube, click on Share, then Embed, and copy the part of the link that is within the frame, so for the Softools video: https://www.youtube.com/watch?v=CVdYRLU8zZc
The embedded element would be "https://www.youtube.com/embed/CVdYRLU8zZc"
This would then render the video in the record:
A GridField is a matrix of DataSets and Fields. In contrast to a ListField, each cell has a unique ID that can be used in expressions / formula elsewhere in the application. This Field type will NOT follow the principles of
‘responsive design’ but will show a horizontal scroll bar at the bottom of the grid. It is ideal for financial tables.
Presents an uploaded image such as a jpg or png file. The user can upload an image to this Field by dragging a file to the image upload box or choosing a file from their device. This is suited to uploading pictures for profiles. To import the image to the Record drag and drop the image into the image box. The image will be stored as an image Asset. Alternatively, if the image Asset already exists then the image can be assigned to the Field via the Asset ID either by expression or import.
Note: The image Field is available to the user after first save of their Record and when uploading a new image this change is saved at the point of upload.
Below is a post on how to add an image by default on record create:
The ImageList Field presents the User with a series of images representing different values for the Field. The User selects a value by clicking on the images which then cycles through the different values. First you will need to create an Image List. These are similar to Select Lists but will also have a image uploaded against each option. The Image List can then be assigned to the ImageList Field that is being created.
An ImageActionButton will mimic system functionality including navigating to a Child App, adding a Child Record, closing a Record and navigating to a URL in the same or a new browser tab. These buttons are particularly useful when using the App from mobile or tablet when the left pane menu is not always visible.
In App Chart
Presents a graphical Report (chart) within a Record. The Field is simple in that it renders a defined Chart, but the Chart itself needs to be built as a Report within App Studio. The In App Chart requires following a three step process.
Step 1: There needs to be a source for the data that is in the chart. Create a Grid Field with Grid Sub Fields that can become the axes, series and labels for the charts.
Step 2: Create the chart in the Report area of App Studio. When building your chart select the GridField that you have created in Step 1 as the 'In-App Data Source Field'. You will then be able to choose from the Fields in the chosen GridField to build up the configuration on your chart.
Step 3: Render the chart in the Record. Create a new Field and select Field type 'InAppChart'. Then select the Report that you have built in Step 2 and add this new Field to your Template.
Presents a numeric field where the value is formatted to be complete integers (no decimal places).
Presents an expandable table with multiple Sub Field columns. This is ideal where the number of rows in a grid is unclear – such as a list of items. However, in contrast to a defined GridField where each cell is a unique Field in its own right, cells in a ListField cannot be called elsewhere in the App.
List fields are limited in their use as the data within them cannot be referenced from elsewhere, and is difficult to change via import and export.
as of October 2019, the list field will be replaced by an alternative construct offering better options
Displays plain text for the user. This is ideal for giving clear instructions to users of how to complete the record and to explain the process that they are following when entering data. The text to be displayed to the user will need to be entered in the 'Expression' and 'Default Value' field parameters. The text in the 'Expression' parameter will need to be enclosed in single quotes as shown in the following example:
Default Value: Once you have completed filling in this section save the record and your results will be displayed in the Summary Form.
Expression: 'Once you have completed filling in this section save the record and your results will be displayed in the Summary Form.'
Please note: Avoid using single quotes or apostrophes within the text to be displayed as this causes errors on saving when trying to parse the expression.
Presents a numeric Field that is capable of handling very large integer numbers (in excess of 2 Billion).
Presents an expandable / scrollable text Field where the default number of rows on the screen can be defined. The 'Rows' parameter determines the default size of the Text area when a user views a Record.
Presents a Lookup Field where, depending on the value selected, will populate other Fields by mapping data from another App. A Field is determined as the Search Field which will then slide in a pane where an appropriate record can be selected to map data from.
Step 1: Create the Lookup directory. The values in the Lookup are contained in a separate App that has been classified as a Lookup App in the App Configuration screen. Create an App and add the Fields to this App that will contain the Lookup data.
Step 2: Add the same set of Fields to your current App.
Step 3: Create the Lookup Field. Select the App that you created in Step 1 as the 'Lookup Name' and set the 'Lookup Search Field' to be the Field in the Lookup App that you would like to search for data by. Then add the mappings to say which Fields in the Lookup App map data to which Fields in your application.
This is ideal for choosing a Company, and based on the selection, pre-populate the address and telephone number in defined Fields.
Presents a numeric Field that has been formatted to show the value as currency.
Presents a field with optional graphical representation in the form of Red, Amber, Green, Blue, Black or Harvey Balls. The different multistate options range from a two state field up to a six state field.
Presents a text field where only the latest value is visible on the screen. All earlier values are held in the database and are visible when the user clicks on the pencil icon in the right hand side of the the Notes text box.
Presents a number input field not limited by decimal places and is ideal for use in formulas.
Presents a Field in date entry format and depending on the browser used may also include a date picker that brings back just the Month/Year. The value for this field is stored the in the same format as Date and DateTime Fields, yyyy-mm-ddThh:mm:ssZ.
Presents a drop down selection list of all users on the portal. This will bring back the Users name in the UI, but will also store the unique Users ID in the database. It also offers a magnifying glass icon which will slide in a pane to the screen where the appropriate user can be searched for using filters and then selected.
Presents a numeric scale (i.e. from 1 to 5) but displays it graphically as a slider. If no min and max value have been selected for the range then by default the range will be from 0 to 100.
Presents the user with a Field which they can choose one or multiple Field values from a pre-determined finite Select List. Create a Select List and select it as the 'Select List' property for the Field. This list can be created in Settings or via the 'Add/Update' button below the 'Select List' property. A select list will require a unique system ID and a name for the user to find their created list by. To add an item, click on 'Add Item' and set the following three properties:
Text: This is the text that the user will see in the UI when making their selection for the Field
Value: The is the value that will be stored in the database for this field
Display Order: This is the order that the field will appear in the selection options (a numeric value where lowest is first)
There are four different types of Selection Field
Select: This allow the User to make one choice from the list of options in the selection Field. The user will click a drop down that will show all of the available selections and then they will choose one. They can then remove their selection back to 'Select an item..' if they want to.
Radio: This Selection type shows all of the options to the user and then they can make a selection of one option. Choosing another option will remove the previous selected option. Once a value has been selected, the user can only choose a new option. They cannot clear their selection.
Checkbox & Listbox: This presents all options to the User and they can then select or deselect the options as they would like. The only difference is in how the data appears. See the image below for an example. For the checkbox this is by clicking the box to the left of the value. For the List box multi-selection and deselection can be made by holding 'Ctrl' whilst making the selection.
Note: If there are seven or more options for the user then the Radio and Checkbox Fields will change to show the options horizontally across the page instead of vertically.
The selection type can depend on what you want to use the data for. Checkbox and Listbox will store the data as an array of items. This is fine if the Field value is only viewed within the Record but does mean that it cannot be used in Reporting. If the values are need to report against then restricting the User to one selection is advisable.
Note: If the select list values are text then the select list Sub Type will also need to be set to 'Text' or the user selections will not be saved. The 'Numeric' Sub Type should only be used if all select list options have numeric values. This is useful if the value for the Field is needed for expressions.
Presents a text input field for the user. This field is commonly used for data where each entry will be unique so little to no validation on data entry is required.
Presents a text input field which accepts web links. This field will allow the user to click on the live link from within a record.