Smart fields

Updated 6 days ago

Most of the time, you only need to store data that's static - data that doesn't change unless you change it. Sometimes that's not enough though - for example you might want to store a calculated field containing a member's account balance, based on other data you have about them.

Enter smart fields. Intelligent, read-only fields that auto-calculate their values every time you update a record in Beacon.

In Beacon there are two kinds of smart fields:

  • Formulas - what you'd write in Excel (e.g. 1+3, IF() statements)
  • Templates - "mail merge" style substitution

link How to create smart fields

  1. Go to the Record Types page, choose the record type you want, and click Add Field.

  2. Choose the Number type, and click the "Is smart field?" toggle.

Smart Field Screenshot

  1. Create an Excel-like formula, inserting in a numeric field parameter into the template.

Smart Fields Gif

  1. Click "Save". Add the field to the layout, and then navigate to a record of that type. You'll see a smart field value has been automatically set.

help_outline You'll need to refresh the page after you've created it to see the smart field in action.

link Formula smart fields

Formula smart fields are where the real power of smart fields lies. With formula smart fields, you can use many of the functions and operators that you're used to using in Excel, including:

  • Maths: +, -, *, /, ^, %
  • Logic: IF(), AND(), OR(), NOT(), XOR()
  • Comparisons: =, >=, >, <=,<,<>`

With formula fields, you can use all of the above to build out smart fields that automatically update, to calculate things like the balance that a member still owes you, or a flag to determine if a team member should call someone or not.

help_outline To use a formula in a smart field, start the template with an = (like you would in Excel).

Screen Shot 2018-03-18 at 17.36.45

link Template smart fields

Template smart fields are mostly useful for labelling records in Beacon. They're good for setting labels on records like donations, e.g. "£10 from Jess".

To set up a template field, just type the label you'd like to show in the smart field template field, inserting the field(s) that you'd like to show in the label.

Smart field templateSmart field


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.


Register for webinar

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