fbpx
    • At the latest Brisbane Salesforce User Group meeting, we presented to the group how to enforce business process and how to keep your critical data clean using validation rules within Salesforce CRM.

      We looked at 6 great rules that we have used for organisations around the world and some especially for Australia including enforcing the Australian States, phone numbers and Postcode ranges.

      Salesforce Help states the following in their help & training:

      “Improve the quality of your data using validation rules. Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A validation rule can contain a formula or expression that evaluates the data in one or more fields and returns a value of “True” or “False.” Validation rules also include an error message to display to the user when the rule returns a value of “True” due to an invalid value. Improve the quality of your data using validation rules. Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A validation rule can contain a formula or expression that evaluates the data in one or more fields and returns a value of “True” or “False.” Validation rules also include an error message to display to the user when the rule returns a value of “True” due to an invalid value.”

      We created the following rules:

      • Order (number) received before Opportunity is closed
      • Prevent an Opportunity from being edited when closed
      • Dates are in sequence
      • Billing Address includes an Australia State
      • Complex Regex validations – Phone Number (Australia)
      • Complex Regex validations – Australian Postcodes

      If you want to create them yourself, you can follow the steps which we have made available via our ScreenstepsLive account.

  • App Deep Dive: Payments2Us

    If you’re a business or organisation that deals with memberships, recurring donations, payments, or events, you’ll know how important having a reliable and easy to use system is. In this blog, we take a deep dive into an app that does exactly this.

    Learn More

  • Passwords – the bane of our existence in this modern technology world

    With so much of our lives tied to technology these days, passwords have become a necessary part of life. Love them or hate them, passwords are here to stay which, depending on your thought process, is either a plus or a pain.

    Our Operations Manager Karen Matheson is the gate-keeper of passwords here at SalesFix. Below she shares some stats and tips on what she’s learnt about passwords over the years.

    Learn More

  • Why Machine Learning Is the Smart Way to Dedupe Salesforce

    Every company’s dataset is unique and has its own challenges when it comes to deduplication. Instead of rule-based applications, which can be very time-consuming and ineffective, machine learning is a new and more efficient way to identify and eliminate duplicates.

    Learn More