Use this link to share with your colleagues:
How to Create and Update Custom Fields: https://help.pm.leapevent.tech/a/829691
Fields in PatronManager track all sorts of data. But what if you need to track a custom piece of data?
Enter custom fields. You can create your own custom fields to hold new pieces of data just about anywhere you like! In this article, we'll cover how to:
- Plan a new field
- Create a new field
- Where to edit/update your fields
- Learn more about using and creating custom fields
To help set you up for success, we’ve put guidelines together to help you avoid interfering with PatronManager functionality, corrupting your data, and to prevent negative impacts to your customizations due to PatronManager product upgrades.
1. Plan your new field
Before you create a custom field, make sure you can answer these two questions:
- Where in PatronManager should the field live? That is, what object should the field live on? For instance:
- Do you want to collect data specific to Donations?
- e.g. "Effective Fiscal Year"
- Or, do you want to collect information on individuals (Contact), or for households (Account)?
- e.g. "Pager Number" for Contacts
- e.g. "Shared Estimated Income" for Accounts
- Do you want to collect data specific to Donations?
- What kind of information do you want to capture with this custom field?
To help you answer the second question, here's a rundown of commonly-used field types:
Field Type |
When to use it |
Examples |
Good for reporting? |
Special notes |
Check Box |
There are only two options, e.g. "Yes" or "No", "True" or "False" |
|
Yes |
|
Picklist |
You have a handful of distinct options, and the options are mutually exclusive |
|
Yes |
|
Multi Select Picklist |
You have a handful of distinct options, the options are not mutually exclusive, and you don't plan to use it for reporting |
|
No |
Difficult to use in formulas |
Text |
The data you're storing varies wildly, isn't standardized, and you don't plan to use it for reporting |
|
No |
Difficult to use in formula |
Roll-up Field |
You want to display a summarized dollar amount, record count on a parent object from a child object, and more |
|
Yes |
Limit 25 roll-up fields per Object |
Formula |
You want to display a field from a related object, display field values based on certain criteria, and more | Yes |
2. How to create a new custom field
In this example, we want to track how specific donations are supposed to be used. We have a list of funds donors can donate to, and that option needs to be in PatronManager.
As such, we'll create a picklist field on the Donation object called "GL Code".
3. Go the the Fields & Relationships tab, and click "New"
Make sure the field you want doesn't already exist if you're not sure!
4. Choose your Field Type, and click "Next"
We want to create a drop-down menu that assigns one GL Code per donation, so we'll choose "Picklist".
5. Enter the field details:
- Field Label: Name your field
- Values: Select "Enter values, each separated by a new line"
- Values Box: Input your GL codes here, each separated by a new line
- Check "Restrict picklist to the values defined in the value set"
- Field Name: GL_Code (automatically populates based on the Field Label)
- Description: Let your colleagues know what the field is for - this is helpful for other administrators who might be about to create a similar field
- Help Text: Provide a helpful note about the field for your colleagues to reference when they enter donations
- Click "Next"
8. Organize your new field on Object page layouts (optional)
Head over here to find out how to organize your new field on the page layout.
3. How to update/edit your fields
Editing a field is very similar to creating one. You'll find your custom field in Setup, then make any changes you need.
Need to add, edit, or retire picklist values?
If you want to change the name of a custom field, you can do that from here! Make sure to:
- Only change the Field Label - and never change the API Name
- After changing the Field Label, check your workflows, processes, and flows to make sure to update any references to the field
4. How to learn more
So far, we've introduced you to common field types and provided examples for creating and updating custom fields. The party doesn't end here, though - check out these additional resources to become a pro!
PatronManager Help Tab:
- How to Add, Edit and Retire Picklist (Drop-Down Menu) Values
- All About Roll-Up Fields (and Best Practices)
- About Your "Order Origin" Field
- How to Customize the Values in Your "Order Source" Field
- How to Add Custom Fields to the New PTS (and/or PMBO)
- How to Create Custom Fields for Ticketable Events and Event Instances
- How to Add Custom Fields to Benefits
Trailhead:
- Work with Standard and Custom Fields
- Add Custom Fields
- Make Custom Fields
- Capture Data with Custom Fields
Salesforce articles: