After clicking on the +column button, a new column screen will open.
From here, you can enter a column name and select a column type from a drop-down.
Below is a detailed breakdown of the different types of columns within DataGrows, displayed alphabetically:
Checkbox
Checkboxes can be checked or unchecked
Clock
Clocks can display time in 24-hour or 12-hour views.
These can be selected from the format drop-down.
Display formats
12-hour clock
eg. 10:34 AM or 10:34 PM
24-hour clock
eg. 10:34 or 22:34
Currency
Used for monetary values
Currency columns contain two characters after a decimal point.
Eg. 438.00
Date
Under the date column type, there is another drop-down for various date formatting options.
There is also a checkbox where you can set the column to default to the current day.
These options are:
dd-mm-yyyy
eg. 21-05-2020
mm-dd-yyyy
eg. 05-21-2020
yyyy-mm-dd
eg. 2020-05-21
yyyy-dd-mm
eg. 2020-21-05
date month year
eg. 21 May 2020
month date year
eg. May 21 2020
year date month
eg. 2020 21 May
year month date
eg. 2020 May 21
day, date, month year
eg. Thursday, 21 May 2020
Date Time
Date & time in one column
Format: The options are the same as discussed in the date and clock section above.
Dropdown
This will give a list of choices to pick from every time a record is added. To set up a drop-down, list your items, separated by a comma. Each item can contain up to 255 characters.
Embedded
Attach authorized sites and pages to be viewed within DataGrows.
From table
Link a column from another table to this table. Data will be displayed as a drop-down when adding or editing a record. Eg. Include a client list drop down on an Orders table.
Hyperlink
A hyperlink will have an icon attached, taking users to an external page.
Longtext
Up to 8000 characters
Phone number
May contain +, -, (), x and numbers
Eg. (+27) 072 546 1263
Cannot contain letters
Number
Whole numbers up to 25 digits, of which 5 can be after a decimal. These can be positive or negative. Eg. – 2147483.648 or 214748.3648
Text
Up to 255 characters
Timer
Hours, minutes, and seconds
Display formats
Hours:Minutes (hh:mm) or Hours:Minutes:Seconds (hh:mm:ss)
Eg. 12:55 or 04:34:07
Read these posts to find out more about default values or calculated columns.
Comments