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.

  • Life in Actual Lockdown – Reflections from the Philippines

    The word lockdown has been used to describe many of the restrictions that have been put in place due to COVID-19. However, while many Australians say we have been living in lockdown, the reality is we still had a fair bit of freedom, even before restrictions began easing.

    Learn More

  • When it comes to data security – who is responsible for ensuring best practice?

    One of the most important aspects of any implementation is data security. Projects of all sizes should go through this rigor to shield information, although the responsibility for ensuring best practice can fall to different areas depending on the size of the business.

    Learn More

  • Struggling for motivation? You’re not alone!

    It’s fair to say that all of us have struggled with motivation at some stage throughout the current situation. Whether it is on the work front or with exercise, maintaining connections, home schooling, or the multitude of other issues we come across in our day, most of us have had moments of blah. 

    Our Operations Manager Karen, is no different. Despite being one of the ‘lucky ones’, Karen has still witnessed the financial pain of workers and businesses and knows that even those who are still operating face a future in which planning will play a key role.  

    Learn More