TrueGivers is a certified Neon partner

Integrating TrueGivers & NeonCRM

About  |  Data  |  Setup  |  Process  |  Support  |  Training  |  Pricing

Register and Setup your Database for the Integration

The registration page will require:

  1. Organization Name
  2. Email Address
  3. Organization ID
  4. API Key

Once you have entered your Organization Name, Email Address, and Organization ID, TrueGivers will validate your information to confirm that you are a NeonCRM user. Then, you will be asked to enter your valid API Key. Next, TrueGivers will validate your API Key. Click Submit and you will receive an email with a temporary password to sign into your TrueGivers account.

Continue reading to view instructions on how to find your Organization ID and API Key. You can also view NeonCRM's full instructions here: NeonCRM Developer Guide: API Keys.

Organization ID

To access your Organization ID, first navigate to Settings > Organization Profile & Billing. The settings button is located at the top right of your NeonCRM homepage.

Next, scroll down until you find the section called Database Information. In this section you will find your Organization ID listed.

API Key

In NeonCRM, API Keys are based on NeonCRM system user accounts. We recommend creating a new user account for each integration you enable. Neon is asking you to create a new user that has API access, so they require an email address that is not already in use. You can use any email address not in use by Neon. This makes it easier to disable a single integration at a later time.

To access your Valid API Key, you will need to create one. You can create an API key in your Settings > User Management. Then click New User.

New User
New User

This will redirect you to a new user form. Fill out all required fields. We recommend naming this user with a name that includes 'TrueGivers API' or another name that will help you identify its use. Additionally, this user should have the User Group set to 'Administrator'. Selecting this type of User Group allows us to continue to process your data with limited interruptions.

New system user form
New system user form

Then, enable the API Access for this user account by clicking the toggle button. Your API key will then be displayed.

 

Finally, click Create User at the top right of the New system user form. Your user will appear in the System Users list. You can always access your API Key by opening this System user. To remove API access for this integration, you can deactivate this user.

Account Last Modified Date check

TrueGivers requires that your accounts have the Account Last Modified Date field populated. This field is used during our download process, and lack of this value could prevent us from downloading ALL of your individual accounts.

Confirm that your accounts have this field populated by running a quick report within Neon.

  1. Click Reports > New Report
  2. Click All Accounts Report
  3. Click Edit Criteria
  4. Enter the following Criteria
    1. Field: Account Last Modified Date
    2. Operator: Blank

      Account Last Modified Date Filter
      Account Last Modified Date Filter
  5. Click Load Criteria
  6. Finally, click Run Report.

If you are receiving results, this means that these accounts do not have the Account Last Modified Date field populated, and TrueGivers will NOT download these accounts.  Continue below to find out how to populate this field: Populating the Account Last Modified Date.

If you are not receiving results, this means that all of your accounts have the Account Last Modified Date field populated. Congrats! You are now ready to register for the TrueGivers & NeonCRM Integration. Register now!

Populating the Account Last Modified Date.

There are a few steps you will need to take in order to populate your accounts that do not have the Account Last Modified Date populated.

  1. Create a new Custom Field (this can be deleted later)
  2. Perform a Bulk Edit Operation on all accounts missing Account Last Modified Date
  3. (optional) Delete Custom Field

 

Create A New Custom Field

In order to edit all accounts with the Account Last Modified Date field, you will need to perform a Bulk Operation on all of these accounts. The easiest way to do this is to create a new custom field.

For this example, we will name the new custom field 'Test'. This custom field name does not matter. Just use a name that is unique and you will remember when you perform the Bulk Edit. This field can also be deleted after you have performed the Bulk Edit.

  1. Navigate to Settings > Global Settings
  2. Click All Accounts under the Accounts> Custom Fields section
  3. Click New Custom Field
    1. Field Name: Test
    2. Display type: one-line text
    3. Data type: text
  4. Then, click Save.

You have now created a custom field. Next, we will perform a bulk edit using this field.

Perform a Bulk Edit

Next, we will perform a Bulk Operation and edit the  new 'Test' custom field. This will automatically populate the 'Account Last Modified Date' field.

To access the Bulk Operations, you'll need to click Setting > Global Settings> 'Bulk Edit or Delete Accounts'.

This will open up the 'All Accounts Report' which will enable you to create a report:

  1. Click Edit Criteria
  2. Enter the following Criteria
    1. Field: Account Last Modified Date
    2. Operator: Blank

      Account Last Modified Date Filter
      Account Last Modified Date Filter
  3. Click Load Criteria
  4. Finally, click Run Report. This should return the same count as the first time you ran the All Accounts report above.
  5. Click Bulk Operation > All Accounts

    Bulk Accounts Operation
    Bulk Accounts Operation
  6. Then, click Confirm Accounts
  7. Make sure the option is Edit Account Data, then click Next

    Select Bulk Operation
    Select Bulk Operation
  8. Scroll down to find that new Custom Field you created and check this field.
  9. Then enter some data; for example: 'Test Field'

    Test Field
    Test Field
  10. At the top of the page, click Next
  11. Finally, this page should have a description like: Test will be changed to Test Field
  12. Click Confirm and Perform Bulk Edit button

Once this has completed, you can confirm the Account Last Modified Date field has been populated by running another report following the instructions above under Account Last Modified Date Check.

If you are not receiving results with that final check, this means that all of your accounts have the Account Last Modified Date field populated.

Congrats! You are now ready to register for the TrueGivers & NeonCRM Integration. Register now!

Registered Users

Once you have completed registration, TrueGivers will continue to automatically process your records on a daily basis. We will also update your Data Stewardship Dashboard when we find new data, which offers insights into the potential impact the data can have on your organization. The report also includes an analysis of cost savings you receive through a TrueGivers integration.

Purchase Credits Dashboard
Purchase Credits Dashboard

Registering for the TrueGivers & NeonCRM Integration does not include automatic synchronization, so you will not see new data in your NeonCRM database until you purchase credits. Additionally, some search features are disabled until you purchase. Continue reading to learn more about the purchasing process.

Purchase Whenever You Are Ready

To have your database automatically synchronized, purchase credits in TrueGivers. Follow these steps.

Purchase Credits

TrueGivers uses credits to streamline the purchasing process. One (1) credit is equal to $0.10. In the blue box on the Data Stewardship Dashboard, you will see a Purchase Credits button.

Purchase Credits

Clicking this button will open a purchase form. Select the pricing tier that corresponds with your credit count total.

NeonCRM Data Hygiene and Enhancement Purchase Form
NeonCRM Data Hygiene and Enhancement Purchase Form

In order for data to synchronize, you must purchase enough credits to cover all of the records in your NeonCRM database. Credits never expire, so you are welcome to purchase additional credits to cover additional months of service. You are always able to purchase credits through the Credits Counter located in the User Menu dropdown. This is located at the top right corner of your screen. Use the drop-down menu to choose the number of credits you would like to purchase.

Credits help us deliver uninterrupted service for our customers. Read more determining the right number of credits to purchase on our pricing page.

Apply Credits

After you purchase credits, we recommend you click the "Apply Credits" button to see your new data immediately. Clicking the Apply Credits button unlocks all TrueGivers features.

Apply Credits
Apply Credits

TrueGivers will ask you to confirm that you want to apply your credits. Click "OK" to do so. If you do not manually apply your credits, don't worry. TrueGivers will automatically apply your credits during nightly synchronization. After you Apply Credits, you will have access to all TrueGivers features and data until your account has insufficient credits.

Add Account Custom Fields and Custom Groups

To read NeonCRM's full instructions on Custom Fields: Configuring Custom Fields.

NeonCRM's Account Custom Fields enable you to collect and track any information not already available as standard account fields. These fields are not created automatically, so you will have to create them yourself. Adding these custom fields and groups to your NeonCRM account is not required. The integration will continue to work without these fields. However, to synchronize the deceased flags and demographic data to your accounts and receive the full experience of the integration, these fields must be present.

Follow these steps to create the account custom fields required for TrueGivers data. Then, continue to create account custom groups.

  1. Login to NeonCRM
  2. Navigate to Settings
  3. Navigate to Global Settings
  4. Click All Accounts, which is nested under the Custom Fields header under Accounts

Add custom field
Add custom field

Next, click New Custom Field.

Add custom field button
Add custom field button

Then fill out the form with the Field Name and Display Type. When you create an Account Custom Field with the display type drop-down, you'll have to fill in the drop-down fields as well. NeonCRM refers to these drop-down fields as Field Options. In this example, we will use Income Decile. Once you have filled in all fields, you can click save.

When creating these custom fields, please make sure the custom field and its values are exactly as they are listed in the table below. Creating fields and values that vary from those listed will prevent those values from being synced. 

Income Decile sample
Income Decile sample

Repeat all fields until they are saved. These will be saved at the bottom of the Account Custom Fields page in a section called Non-Grouped. Once you have created all custom fields listed above, you'll need to add them to their custom group. You will need to create two Custom Groups:

  1. TrueGivers Deceased Flag
  2. TrueGivers Demographics

To create a custom group, scroll to the top of the page and click New Custom Group.

Add custom field button
Add custom field button

 

Next, fill out the form with Display Name.

Add Custom Group
Add Custom Group

Before you click save, click any custom fields located in the Non-Grouped Field and drag it to the Grouped Field.  Then click save. For example: TrueGivers Deceased Flag needs the Deceased Type, Deceased Link, and Deceased Date fields. You should click on each deceased field and drag it to the Grouped Field. The picture above shows how it should look when you click save.

Repeat those steps to create Custom Groups until they are saved with their assigned custom fields. You can view all Fields and their Custom Groups in the table below.

When creating these custom fields, please make sure the custom field and its values are exactly as they are listed in the table below. Creating fields and values that vary from those listed will prevent those values from being synced. 

Group
Field Name
Display Type
Data Type
Field Option
Code
TrueGivers Deceased Flag Deceased Type Drop Down Individual
Household
I
H
TrueGivers Deceased Flag Deceased Date One-Line Text Date
TrueGivers Deceased Flag Deceased Link One-Line Text Text
TrueGivers Demographics Birth Year One-Line Text Text
TrueGivers Demographics Business Owner Drop Down Accountant
Builder
Contractor
Dealer/Retailer/Storekeeper
Distributor/Wholesaler
Funeral Director
Maker/Manufacturer
Owner
Partner
Self-Employed
A
B
C
D
E
F
M
O
P
S
TrueGivers Demographics Home Owner Drop Down Homeowner
Renter
Y
N
TrueGivers Demographics Net Worth Decile Drop Down Less than or equal to $0
$1 - $9,999
$10,000 - $24,999
$25,000 - $49,999
$50,000 - $99,999
$100,000 - $249,999
$250,000 - $499,999
$500,000 - $999,999
$1,000,000 - $1,999,999
$2,000,000 +
1
2
3
4
5
6
7
8
9
10
TrueGivers Demographics Market Value Range Drop Down $0 - $49,999
$50,000 - $99,999
$100,000 - $149,999
$150,000 - $199,999
$200,000 - $249,999
$250,000 - $299,999
$300,000 - $399,999
$400,000 - $499,999
$500,000 - $749,999
$750,000 - $999,999
$1,000,000 Plus
1
2
3
4
5
6
7
8
9
10
11
TrueGivers Demographics Income Decile Drop Down Less than or equal to $39,999
$40,000 - $69,999
$70,000 - $99,999
$100,000 - $129,999
$130,000 - $174,999
$175,000 - $249,999
$250,000 - $399,999
$400,000 - $749,999
$750,000 - $999,999
$1,000,000 +
1
2
3
4
5
6
7
8
9
10
TrueGivers Demographics Religion Drop Down Buddhist
Catholic
Hindu
Muslim
Jewish
Other Asian Religions
Lutheran
Mormon
Eastern Orthodox
Protestant
1
2
3
4
5
6
7
8
9
10
TrueGivers Demographics Heritage Drop Down African American
East Asian
South Asian
Central Asian
Mediterranean
Native American
Polynesian
Middle Eastern
Western European
Eastern European
1
2
3
4
5
6
7
8
9
10

When you are all done your new Custom Fields and Custom Groups should look like this:

Custom Group and Fields
Custom Group and Fields


 

Are you an existing NeonCRM customer?

Register to start your integration between TrueGivers and NeonCRM, and keep your database updated automatically!

Not a NeonCRM User? Sign up today!

Request a Free Trial and Demonstration to try NeonCRM!