Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip
Admins can prevent many issues by following best practices when initially configuring a rule. Familiarity with best practices makes it easier to spot and diagnose problems with rules.

...

After opening a record, go to the History tab. History Events shows a list of changes that have occurred to a record over time and what caused them, making it an extremely valuable section for testing purposes. The Modified By column tracks who or what made the change, including the names of individual rules that made changes. If the value under Modified By is not a rule, it's still possible a rule is involved. For example, it's possible that a rule ran after the admin someone made an edit. If the Modified Fields value matches the fields that were incorrectly updated in a record, check History Event Details by clicking the magnifying glass icon.

Image RemovedHistory Events list showing an update by a rule that followed an update by the contractmgr userImage Added

History Event Details contains a detailed snapshot of the actions called by a rule for a specific record. If an action looks incorrect, consult the configuration in the rule's Action tab. Although the format of History Event Details varies depending on the type of action the rule called, the nature of the information stays largely consistent. The following image is an example of Consider the History Event Details for a time-based rule that ran an Update Fields action called Update Demo Dates. The the rule modification showed in the History Events example above. The section shows the fields that changed, the before and after values, and the name of the Update Fields action that caused it. The settings of the Update Demo Dates action are described in more detail in the Action Report.

Image Removed

 

Example History Event DetailsImage Added

For another example, see the History Event Details below for a record The next image is an example of History Event Details for a record created by an admin that caused four two event-specific rules to call four two separate If-Then-Else actions. The rules are called Create: Copy state/province to new fields, Create: On Creation Actions, Edit: handle address update if it changes, and Tax Exempt, and they are all These were both triggered because a record was created. Just like in the time-based rule, and for each, History Event Details shows the results of the actions that ran.

Image RemovedHistory Event Details second exampleImage Added

Although the format of these History Event Details is different, the information gathered here is similar. Instead of showing a list of updated fields, this History Event Detail section shows the If-then-else flow (ITEF) under the Action Report to monitor exactly how actions within rules interacted with a system. The ITEF is used to diagnose and then solve issues; it shows which clause was verified in a rule's If-Then-Else action, and what additional actions ran because of the verified clause. This information is recorded in the "search matched" and "action executed" rows of the ITEF, respectively.

...

After a potential culprit rule is identified using the History tab, check the settings of the rule using the Rules table for improper configuration. To access the Rules table, Click click Setup [Table Name]and then go to the Rules tab.



This table makes it easy to skim a rule's settings and quickly identify something that might be causing the problem. The columns have specific uses relative to troubleshooting:

...

Info
titleExample

The All Edit Validations action is an If-Then-Else action. The Action Description begins with an If-statement and then a Validate action before trailing off. The remaining actions are shown in the If-Then-Else editor.

Check Rule Configuration in the Rules Wizard

Review the settings on each tab of the Rules Wizard to make sure they're configured correctly. Many issues with rules come from missing or misinterpreting a single setting. For information on how to diagnose problems with the Rules wizard, compare the rule's settings with the recommendations in the Creating and Editing Rules section of the Rules article, and make modifications. It's likely that the issue can be traced to improper configuration in the Conditions tab, the Schedule tab, or in an action in the Action tab.

...

The following examples demonstrate the end-to-end troubleshooting process laid out in the previous sections of this article. These examples can help you figure out where to begin with issues you find in your own system.

...

Troubleshooting an Event-specific Rule using If-Then-Else Flow

Lei the , an admin, receives a ticket saying that a Location record was created with a US State field of WA, but the Income Tax Status field was set to Non-Exempt. The ticket mentions that the correct behavior should be According to the ticket, when a Location record is created or edited with a US State field value of WA, the Income Tax Status field should automatically be set to Exempt. 

Lei can tell from the ticket that the rule is supposed to occur either run when a record is created or when a specific field is edited, making it an event-specific rule. Here are the steps that Lei should follow to successfully troubleshoot this issue, and other issues like it:

Image RemovedLocation record showing a WA location with tax status of Not ExemptImage Added

  1. Open a newly-created record with the incorrect Income Tax Status value and navigate to the History tab. Lei didn't see an example record included in the ticket, and may have to reach out to the submitter if one can't be identified.
  2. Open the history event with Location Created in the Modified Fields column, since the issue was noticed when a record was created or edited. 
    Image RemovedHistory Events showing Income Tax Status updateImage Added
  3. In History Event Details, identify a potentially misconfigured rule by the name, its actions, or the fields it modifies; use the name, actions, or modified fields to identify which rule is most likely causing the issue. Rule: Tax Exempt is identified as the improperly configured rule by the rule's name, Action Name, and Field Changed.

  4. Confirm the rule is improperly configured by checking the ITEF. The ITEF shows that when this record was created, the system checked it against the clauses in the If-Then-Else statement, and the record matched the clause that runs the Set Tax Exempt Status to Not Exempt action. Because an unexpected action is being called, either the If-statement was improperly configured, the action was improperly configured, or the record was not created with WA in the US State field. Lei hypothesizes that the If-statement must be the issue.
    Image Removedissue.
    History Event Details for Tax Exempt settingImage Added

  5. Open the improperly configured rule.
  6. Navigate to the Action tab and edit Determine Tax Exempt Status, since Lei hypothesized that the issue is an improperly-configured rule.
  7. Click the Details tab. At first glance, the action's configuration seem normal. However, Lei realizes that the State or Province field and the US State Abbreviation field are not the same field. 
    Image RemovedImage Added

  8. Edit the If-statement. 
    Image RemovedImage Added
  9. Click Finish in both screens.
  10. To test, return Lei returns to the table and create creates a new record that should trigger the rule. If the If-statement was the cause of the issue, and it is now configured properly, the record should have the correct values. If the value is still incorrect, double-check the rule's configuration, and repeat the process.
    Image RemovedNew record showing tax status set correctlyImage Added

Troubleshoot a Time-Based Rule

Imagine it's the morning of April December 2nd, 2020. Alex the admin receives a ticket detailing that the system is supposed to update the Date Updated and Date Created fields of each record in the Company table on the first of each month at 9 PM, but the records weren't updated yesterday night. Since this edit is supposed to occur at a specific time interval, it's likely that a time-based rule requires troubleshooting. Here are the steps that Alex should follow to successfully troubleshoot this issue, and other issues like it:

  1. Open a record in the Company table.
  2. Go to the History tab.
  3. Check Date, Modified By, and Modified Fields to determine which history event to investigate. In this example, the top choice has Date Updated and Date Created in the Modified Fields column, and it last occurred close to the first of the previous month. Alex chooses this rule to investigate.
    1. Alex notices that there's also an additional field that was unexpectedly modified by this rule called Original Start Date. Checking History Events and History Event Details thoroughly is a great way to troubleshoot for additional improper configurations that haven't been noticed yet. 
      Image RemovedHistory Events list with most recent change including Original Start Date fieldImage Added
  4. Click the magnifying glass icon to open the relevant event's History Event Details.
    Image RemovedHistory Event DetailsImage Added

  5. Begin to gather information. In the example, the History Event Details show the fields that changed, the before and after values of those fields, and the action that changed them.
    • The only rule listed is "TB: Demo Data Update: Update date fields by one month each months so reports have data." This is the rule that should be investigated back in the People table.
    • The date at the top of the window indicates that the rule caused this event to occur on March 02 2020 22:31. Since this doesn't match the time and date the rule is supposed to run, Alex makes a note to check the Schedule tab of the rule.
    • This rule should only update the Date Updated and Date Created field. However, there is an additional row under the Fields Changed column for Original Start Date.  Update Demo Dates is the action listed as updating this field. Alex makes a note to check the configuration of this action in the Actions tab of the rule.
  6. Click Setup [ Company ] and navigate to the Rules tab.

    Note

    The following steps show how to troubleshoot the example rule based on information gathered in step 5. Every time-based rule is configured differently, but the process is similar.

  7. Open the potentially misconfigured rule.
  8. Go to the Schedule tab of the Rules wizard.  
    1. In the example, the Schedule tab shows the rule was incorrectly configured to run on the 2nd day of the month at 10:30 PM. Alex adjusts these values to reflect the desired outcome.
      Image Removed      Apply Rule setting on Schedule tabImage Added

      Note

      Normally a rule should be tested after each adjustment. However, there is no way to test the correct time interval, besides waiting for that time interval to come and go. Luckily, every other aspect of a time-based rule can be tested as soon as it is configured.

  9. Navigate to the Action tab. Scroll down to the Selected Actions section and edit Update Demo Dates.
  10. Navigate to the Fields tab. Scroll down to Original Start Date and clear the checkbox.
    Image Removed
  11. Navigate to the Values tab and Click Finish. Since a possible cause was found and fixed, Alex decides to test the rule to make sure it no longer updates the Original Start Date field.
  12. Navigate to the General tab. Scroll down and click Save & Run Now to test the rule. Save & Run Now can be stylized as Run the rule now if no recent edits were made to the rule. The functionality remains the same.

  13. Navigate back to the record's History tab to check if the modification worked. 
  14. The Modified Fields column in the image below no longer includes Original Start Date. Since this entry is a result of a test, the date in the date column window correlates to when Save & Run Now was clicked.
    Image RemovedHistory Events with Original Start Date not listedImage Added
  15. Click the magnifying glass. The Original Start Date is no longer included in the Field Changed column here either.
    Image RemovedHistory Event DetailsImage Added

Alex has to wait until next month to ensure the rule runs at the correct time, but was able to diagnose why it had ran at the wrong time and changed it accordingly. However, Alex was able to diagnose and then successfully fix another issue that arose during the troubleshooting process for the first rule. This example shows how to use the History Event Details section to troubleshoot for a specific issue as well as how much additional information you can gather from a pass through this section.

Hide If
displayprintable

Content by Label
showLabelsfalse
max7
showSpacefalse
cqllabel = "rules" and space = currentSpace()