Create your Smart Field:
  1. Go to Administration > 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 and 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 and select your source view.
  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.