Browse By Tags

  • Webservice Object Query

    Hi, im querying an object via webservice but it does not return data on the fields that are not from the main table even though those tables are linked to the object. Is this a limitation or am i doing something wrong ?
  • Selection Field: List a group of non-CRM using employees.

    This is how Cornerstone set this up: "Project Manager" is a user select field. All project managers are disabled/deactivated users, as they do not use CRM. Now I'm trying to integrate a new sales channel with a new operations team (project managers…
  • More thoughts about look up field types

    Some time ago I wrote an article called " Sage CRM EntryTypes used in the COM ASP API " in which I listed the different EntryType codes that can be used to define fields (Entries). I explained that within an existing system you can check which EntryTypes…
  • Changing a Checkbox to a Selection list

    Checkbox fields are brilliant for letting a user quickly collect certain types of data. But they do have their limitations and you may discover that you want to be able to store answers such as 'Y' (Yes), 'N' (No), 'M' (Maybe) rather than a simple 'check…
  • Controlling the Display of Drop Down Options in Team Select Fields

    Many system entities such as Opportunities, Leads and Cases can be assigned to a Team. Custom Entities can also have Teams assigned to them. For historic reasons the Team field in the database is called channelid. user_primarychannelid oppo_channelid…
  • Use Advanced Search Selects to create linked selection lists

    Many teams need to link selection lists so that the contents of one selection list determine the contents of another. For example Support teams love the ability when creating a case, to fill in a value for a type of support issue, and then narrow down…
  • Using an onChange Script on a Selection list to set a value of another field

    This is a simple real world example. There was a customer need to set a field values based on value of another field on the opportunity screen. The screens had been customized. The oppo_forecast and oppo_certainty fields were removed from the opportunitystatusbox…
  • Search Issue on multiple fields within the COmpany entity

    Hi. I'm hoping someone can help me with this search issue. I have created 6 new fields within the Company entity. All fields are created the same except for the column name being different. I also have all fields pointing to the same Lookup Family…
  • Applying a Change to All Fields (selection)

    Hi all, first post and hopefully a simple question. We have recently concluded activities for 2015 and we're now preparing to get an early start on 2016 activities. I want to organize cases by the year where we began activities. Because the calendar dates…
  • Hide fields based off selected from a dropdown. Cases

    Hi I have the need to hide a number of fields based off what is selected from a drop down list on a field in the same screen. i've used a bit of Java that works in the Onchange script: if(Values('case_productarea')=='QC29') { hidden = true;…
  • SEI Year selection

    Hi, After installing template for Sage X3 on SEI, our customer try to select year in popup filter but list is empty. Is there a script or action available on administration to populate this list ? I try to add manually one record on the ZCALENDAR…
  • Ajout sélection multiple ailleurs qu'en requête

    Bonjour, Il pourrait être intéressant d'ajouter la sélection multiple disponible dans les consultations de requêtes dans d'autres fonction d'X3. Comme par exemple dans les fonctions de générations automatiques type FUNAUTALL, FUNAUTDLV. Ou encore dans…