Create your Smart Field:
  1. Navigate to Administration, then click on Smart Fields.
    • Note: If you do not see smart fields on the Administration tab, please contact your system role administrator to have the Smart Fields system role assigned to your user
  2. Click Add.
  3. Select Constituent revenue application counts.  Click Ok.
  4. Name the smart field.
  5. Go to the Parameters tab.
  6. Select the value to return as Consecutive giving years.
  7. Mark the revenue types and applications/transaction types that should be included.
  8. Enter a date range, if needed, or leave the dates blank to look at all years.
  9. Click Save.
  10. Click on Start Process to run the smart field.
Output this Smart Field value in a Query:
  1. Navigate to Analysis, then click on Information library.
  2. Click drop down next to your query and select Edit. If your query is not created yet, select Add ad-hoc query, select your source view, then click OK.
  3. In the left column, expand Smart Fields and select your Smart field created above. From the middle, drag Value from the middle to Results Fields to Display.
    • Note: Smart fields do not process or update automatically.  Go to the Job Schedules tab, and add a job schedule to process the smart field on a regular basis.