locked
CRM Online 2015 Caclulated Field drop down list truncated RRS feed

  • Question

  • Great article. I hope someone can assist with this question:

    I'm trying to create a calculated field in an Opportunity where a check is made to see if the associated Contact has the Email (emailaddress1) field populated.

    I created a new Opportunity field called "Capture e-mail" which is a two-options data type calculated field type. When I edit the calculated field and try to set the following condition:

    If Contact (Contact) Email contains data then set capture contact e-mail value to completed

    However, when I look at the drop down list for the contact field in the IF condition, the drop down list seems to not have all the fields for contact. In fact, this is an alphabetical list that only goes down to the letter 'D'. The last entry in the list is 'Do not allow phone calls'. It appears that this drop down list is limited to displaying only the first 87 entries in the list. Whereas I need to select option '90' for Email, but cannot access it.

    Looking at the list in DOM explorer:

            <option value="0">Address 1: Address Type</option>
            <option value="1">Address 1: City</option>
            <option value="2">Address 1: Country/Region</option>
            <option value="3">Address 1: County</option>
            <option value="4">Address 1: Fax</option>
            <option value="5">Address 1: Freight Terms</option>
            <option value="6">Address 1: Name</option>
            <option value="7">Address 1: Phone</option>
            <option value="8">Address 1: Post Office Box</option>
            <option value="9">Address 1: Primary Contact Name</option>
            <option value="10">Address 1: Shipping Method</option>
            <option value="11">Address 1: State/Province</option>
            <option value="12">Address 1: Street 1</option>
            <option value="13">Address 1: Street 2</option>
            <option value="14">Address 1: Street 3</option>
            <option value="15">Address 1: Telephone 2</option>
            <option value="16">Address 1: Telephone 3</option>
            <option value="17">Address 1: UPS Zone</option>
            <option value="18">Address 1: ZIP/Postal Code</option>
            <option value="19">Address 2: Address Type</option>
            <option value="20">Address 2: City</option>
            <option value="21">Address 2: Country/Region</option>
            <option value="22">Address 2: County</option>
            <option value="23">Address 2: Fax</option>
            <option value="24">Address 2: Freight Terms</option>
            <option value="25">Address 2: Name</option>
            <option value="26">Address 2: Post Office Box</option>
            <option value="27">Address 2: Primary Contact Name</option>
            <option value="28">Address 2: Shipping Method</option>
            <option value="29">Address 2: State/Province</option>
            <option value="30">Address 2: Street 1</option>
            <option value="31">Address 2: Street 2</option>
            <option value="32">Address 2: Street 3</option>
            <option value="33">Address 2: Telephone 1</option>
            <option value="34">Address 2: Telephone 2</option>
            <option value="35">Address 2: Telephone 3</option>
            <option value="36">Address 2: UPS Zone</option>
            <option value="37">Address 2: ZIP/Postal Code</option>
            <option value="38">Address 3: Address Type</option>
            <option value="39">Address 3: City</option>
            <option value="40">Address 3: County</option>
            <option value="41">Address 3: Fax</option>
            <option value="42">Address 3: Freight Terms</option>
            <option value="43">Address 3: Name</option>
            <option value="44">Address 3: Post Office Box</option>
            <option value="45">Address 3: Primary Contact Name</option>
            <option value="46">Address 3: Shipping Method</option>
            <option value="47">Address 3: Telephone1</option>
            <option value="48">Address 3: Telephone2</option>
            <option value="49">Address 3: Telephone3</option>
            <option value="50">Address 3: UPS Zone</option>
            <option value="51">Address3: Country/Region</option>
            <option value="52">Address3: State/Province</option>
            <option value="53">Address3: Street 1</option>
            <option value="54">Address3: Street 2</option>
            <option value="55">Address3: Street 3</option>
            <option value="56">Address3: ZIP/Postal Code</option>
            <option value="57">Aging 30</option>
            <option value="58">Aging 60</option>
            <option value="59">Aging 90</option>
            <option value="60">Anniversary</option>
            <option value="61">Annual Income</option>
            <option value="62">Assistant Phone</option>
            <option value="63">Assistant</option>
            <option value="64">Back Office Customer</option>
            <option value="65">Birthday</option>
            <option value="66">Business Phone 2</option>
            <option value="67">Business Phone</option>
            <option value="68">Callback Number</option>
            <option value="69">Children's Names</option>
            <option value="70">Company Name</option>
            <option value="71">Company Phone</option>
            <option value="72">Created By (Delegate)</option>
            <option value="73">Created By</option>
            <option value="74">Created On</option>
            <option value="75">Credit Hold</option>
            <option value="76">Credit Limit</option>
            <option value="77">Currency</option>
            <option value="78">Customer Size</option>
            <option value="79">Department</option>
            <option value="80">Division</option>
            <option value="81">Do not allow Bulk Emails</option>
            <option value="82">Do not allow Bulk Mails</option>
            <option value="83">Do not allow Emails</option>
            <option value="84">Do not allow Faxes</option>
            <option value="85">Do not allow Mails</option>
            <option value="86">Do not allow Phone Calls</option>
            <option value="87">Education</option>
            <option value="88">Email Address 2</option>
            <option value="89">Email Address 3</option>
            <option value="90">Email</option>

    Since I cannot scroll down the list past the letter 'D', I cannot choose 'Email' from this list.

    Any ideas on what's going on here?

    Thanks,
    Jason

    BTW - We are using CRM Online 2015 (just upgraded this week)

    Friday, January 23, 2015 6:40 PM