Evaluating Form Fields

I have created a contact us form.  I want to evaluate if this Contact assigned_user_name has an assignment.  Most will but if it is a new user, they likely will not have a user assigned yet.  If there is an assigned user, I will just simply send an Alert.  For the ones that do not have an assigned user, I want to send an Alert to a Sales Branch representative. We have about 30 branches.  Is there a way to create branch assignments based on zip code?

Parents
  • Hi Brad, 

    It sounds like you'll want to create your geos and territories in Sugar Market to accomplish this. 

    Geos and Territories are defined regions typically by country, state, or postal code. These lists allow Sugar Market to intelligently route new leads based on your settings. For example, you can create a 'Southeastern States' Geo of all states in the southeast, a 'West Coast' geo broken down by all states down the west coast, or an 'EMEA' geo with all countries in Europe, the Middle East, and Asia. Sugar Market makes it easy to import lists of countries, states, and zip codes into your Geo for quick and easy setup.

    1. Click on Account Configuration from the User menu
    2. Navigate to Administrator > User Administration > Geos and Lists.
    3. Click "New".
    4. Choose the type of Geo you will create:
      • General Geos
      • Country Geos
      • State Geos
      • Postal Codes Geos
    5. At the Attributes screen you can add new items that will be part of this Geo:
      • Add - Add a single item to the list
      • Import CSV - Browse for a previously created file and import it
      • Quick Add - Add a series of values separated by semi-colons
      • Save and Return to finish

    I hope this helps!

  • Hi Morgan,

    Thanks for the reply. 

    1. I saw that but what are my fields in the CSV?  Do I just need Zip Code and User?
    2. Can I have multiple users for a single zip code? 
    3. How do I evaluate where an assigned user name is a null value?
  • Hi Brad,

    If you are working in Form Builder, routing using the Geos functionality is not currently available. This is a known enhancement request. You would have to build conditions in the form actions, but given that you are utilizing zip codes, this may not be an option depending on the number of zip codes your territories cover. This would, however, allow you to alert more than one person per zip code (question 2). In answer to Question 3, if you use the "Alert Owner" option in the alerting, then anyone who already has a known owner would have their current owner alerted vs. someone new. 

    If you are using Legacy Pages the Geo option is available. To answer your first question, you would only need the column you are are importing. For example, if you were creating Sales Branch X, which has the zip codes of 30125, 30126, 30127, then you would put the zip codes in column A and import. You would then assign the Sales Branch X geo to it's owner under that User's profile. 

    Please let us know if there are any other questions.

    Thanks!

    Jana

    Director, Customer Enablement | SugarCRM

Reply
  • Hi Brad,

    If you are working in Form Builder, routing using the Geos functionality is not currently available. This is a known enhancement request. You would have to build conditions in the form actions, but given that you are utilizing zip codes, this may not be an option depending on the number of zip codes your territories cover. This would, however, allow you to alert more than one person per zip code (question 2). In answer to Question 3, if you use the "Alert Owner" option in the alerting, then anyone who already has a known owner would have their current owner alerted vs. someone new. 

    If you are using Legacy Pages the Geo option is available. To answer your first question, you would only need the column you are are importing. For example, if you were creating Sales Branch X, which has the zip codes of 30125, 30126, 30127, then you would put the zip codes in column A and import. You would then assign the Sales Branch X geo to it's owner under that User's profile. 

    Please let us know if there are any other questions.

    Thanks!

    Jana

    Director, Customer Enablement | SugarCRM

Children