Beacon

Field types reference

Updated 8 days ago

Creating new fields in your Beacon database? Below is a list of all of the different types of fields, and the limits associated with them.

link Short text

A short text string. Good for arbitrary short pieces of text, like job titles or the name of an event.

Maximum 255 characters. If you need any longer than this, please use the long text field type.

link Long text

A longer piece of text. Great for notes and descriptions.

It's not possible to create filters based on long text fields, but you can search across them using the search feature.

There's no limit on the size of the text in this field.

link URL

A web address link. Must be a full and valid URL. Maximum 255 characters.

link Email address

An email address. It's possible to allow multiple email addresses. If you choose to allow this, you'll be able to set a primary email.

link Phone number

A phone number. Like the email field, it's possible to allow phone numbers. If you choose to allow this, you'll be able to set a primary number.

link File upload

Store uploaded files, of any type. It's possible to allow just one file to be uploaded to this field, or multiple.

The maximum file upload size is 50MB.

Screenshot 2020-07-23 at 12.32.44

link Text (encrypted)

All data in Beacon is already encrypted and firewalled, but sometimes you'll want to add an extra layer of security for some text data (e.g. patient notes).

Note that it's not possible to search or filter based on content stored in encrypted fields.

help_outline Encrypted fields are still able to be seen by all users. To restrict particualr fields, use the Roles and Permissions feature.

If you're looking to categorise and filter your records, drop-down lists can be very useful.

You can optionally allow multiple items from the drop-down to be selected, which is useful when a record fits into multiple categories.

Screenshot 2020-07-23 at 11.54.39

link Number

A numeric value, either positive or negative.

You can specify the maximum number of allowed decimal places, if you need more precision.

You can also turn number fields into auto-number fields to create unique number values for every record.

link Currency

A currency value, e.g. "£10". If you're storing monetary values, you should use this field type as opposed to the more basic number type.

You can store values in any currency, although your database will need a single "primary" currency.

link Percent

A percentage value, e.g. 5%. Like number fields, it's possible to set a maximum number of decimal places for percent fields. In Beacon, the percentage is stored as a whole number: "45 = 45%

link Rating

A rating value (e.g. 1-5 stars, 1-10 hearts). Stored as a whole number. Useful for scoring things like propensity and engagement.

Screenshot 2020-07-23 at 11.47.43

link Checkbox

A checkbox. Can be checked or unchecked. In other systems, this may be referred to as a "boolean" field.

Screenshot 2020-07-23 at 11.51.45

help_outline With checkboxes, the following values can be thought of as interchangable. Checked = yes, true or 1. Unchecked = no, false, or 0.

link Date

A specific date, and optionally a time.

Screenshot 2020-07-23 at 11.49.45

help_outline If you have a date & time field, but only enter a date, it will default to 9:00AM

link Location

A place in the world, usually used for addresses. For location fields, the following sub-fields can be entered:

  • Address line one
  • Address line two
  • City
  • Region
  • Country
  • Postal code

Additionally, location fields are automatically "geocoded", so you'll be able to see a map view of the address.

It's possible to have 1 or more locations added in a single location field. You can also set a primary location.

Screenshot 2020-07-23 at 12.20.53

link Point to another record

Unlike spreadsheets, databases are smart enough to create links between recrods. This is very useful for keeping your data clean and up-to-date, and to give you a bigger picture about how things relate to one another.

A good example is a Donation/Payment made by a Person. When stored in Beacon, this means:

A payment record, which has a field that points to a person record - the person who made the donation

Screenshot 2020-07-23 at 12.27.49

If you enable it, it's possible to point to one or more records in a given field (e.g. a Person could work at multiple Organisations). You can also choose which record types the field can point at (e.g. a payment can be made by either a Person or an Organisation).

Multiple organisations

Sometimes you want to assign an internal team member to a record. For example - you way want to set an "Account Manager" specifically for higher value donors (people) in your database.

Similarly to other fields, it's possible to set multiple users in one field, if you enable it.

Screenshot 2020-07-23 at 11.50.31

close

Contact Us

It'd be great to hear from you! To reach out, fill in your details below and we'll get back to you.

close

Register for webinar

To join this webinar, please enter your details below and we'll send you details on how to join.



close