01-08 Formula fields
Things have changed
00:00:04:22 - 00:00:15:47
Ah! Formula fields. The magical calculator in your SwiftFox toolbox. Think of them as your trusty sidekick, ready to crunch numbers while you focus on the important stuff.
00:00:16:01 - 00:00:30:09
These clever fields let you perform calculations using other numeric fields in your profiles. Whether you're adding, subtracting, or doing fancy percentage math. Formula fields have got your back. Let's walk through a real example.
00:00:30:13 - 00:00:53:13
Say you're tracking membership growth at an organisation. We've already got tabs on total employees at the organisation, and current members signed up. With a formula field we can automatically calculate potential growth by finding the difference, showing us exactly how many employees we could still bring on board. So, ready to create one? Here's how.
00:00:53:17 - 00:01:06:44
First, head to Custom Fields in your organisation profile and select Manage. Select Add New Field and choose Formula as your field type. Let's call this one “Growth Potential”. Catchy, right?
00:01:06:47 - 00:01:16:36
Now for the fun part building the formula. Choose total employees, add a minus sign, then select current members.
00:01:16:40 - 00:01:27:38
SwiftFox will work its magic and calculate the result automatically. Select create then done and voila! Your formula field is live.
00:01:27:42 - 00:01:36:26
Your new formula field will appear on the organisation's profile, updating in real time whenever there is an employee or member, numbers change.
00:01:36:30 - 00:01:54:23
Formula fields offer powerful calculation capabilities, allowing you to perform basic arithmetic operations, handle currency values, and create meaningful metrics to track performance, growth, and potential. They’re like having a mini calculator that never sleeps.
00:01:54:27 - 00:02:00:39
Need help setting up your own formula fields? Well, don't ask me because I'm just reading off a script.
00:02:00:43 - 00:02:07:09
Wait, don't tell them that I'm meant to be smart. Gee.
00:02:07:13 - 00:02:14:02
You know who is a wizard at this stuff? Your account manager. And then just a message your way. Ready to give you a hand.
00:02:14:06 - 00:02:19:20
That's all for now. Catch you in the next video where we'll explore more SwiftFox brilliance.
Contacts
lessons
Not what you were looking for?
Get in touch and learn how easy it is to join SwiftFox, our team is available to help you every step of the way.