Field values

Field values are the contents of Fields. If you imagine that each field is a box with a label, the value is what is inside the box. An entry in an application has one or more fields, depending on the category the entry belongs to. Each of those fields contains a particular value, often unique to that entry.

On a person entry, a field labelled “First name” might contain the value “Jane”. On an inventory item entry, a field labelled “Cost” might contain the value “$19.99”.

The simplest type of value is a text value which contains a piece of text. This is the default type of field in Dabble, but there are other types. Each type limits what sort of data a field can contain but provides some additional tools. For example, if you use Number values, Dabble can show subtotals and allow you to create mathematical Formulas. You can change a field to be a certain type at any time using the Field configuration.

These are the types of field values you can have in Dabble DB:

• Text values
• Web link values
• Email address values
• Phone number values
• Location values: the value is geographic, such as an address or a country name
• Number values: the value can only be numeric
• Money values: the value can only be numeric but will include a currency symbol
• Duration values: the value is numeric and measures a period of time
• Date and time values: the value is formatted to be a calendar date or range of dates, with an optional time
• Choice values: the value is restricted to one of a list of choices
• Checkbox values: the value is binary, e.g. yes/no, true/false, on/off
• Dabble user values: the value is the name of a Dabble DB user
• Attachments: the field contains an uploaded file
• Link to entry: the value points to one entry in the application from a specific category
• List of entries: the value points to many entries from a specific category

Click on a type to find out how it affects your application and what options are available.