[SalesForce] Trigger to validate selection of Pick-list values

I got an object called 'Category' which has a master detail relationship with 'Scheme' object, 'category' has a pick list field called 'Type' & it has different values Ex:Cost,Time etc.

I need to write a trigger to validate selection of pick-list values. Once a pick-list value is selected it should not be used in another record and if user tries to select that same pick-list value and try to save in a new record, it should give an error and should not be able to save the record.

I'm bit confused as I have not done such scenario before.

Best Answer

Can you try the following code.It should work.

trigger Triggertovalidate on category__c (BEFORE INSERT,BEFORE UPDATE)
    {
        LIST<category__c> li = [select id,type from category__c where type != null]; 
        for(category__c c :trigger.new)
        {
         if(c.type != null){
          for(category__c existrecord :li)
          {
              if(existrecord.type == c.type){
              c.Type.adderror('Type is already used please select another one.');//If you need specify the SObject field also
              }
          }
         }
        }

    }

Related Solutions

[SalesForce] How to Populate values to textboxes dynamically on Picklist Selection Change in Standard page layout

You cannot easily do this in the standard layout. You could accomplish the same end result, you could use workflows to have the text field values be updated dependent on the picklist value, but this would not happen until the record was saved. It would not dynamically update the text fields on the edit page as you changed the picklist field.

If you needed it to be dynamic and update the text fields on the change of the picklist field, then you would need to use Visualforce.

Here is an example of this

https://stackoverflow.com/questions/10015597/display-fields-based-on-selection-on-a-picklist-selection

[SalesForce] null values of some fields on inserting data in test class

When you issue your insert call from Apex code, the trigger fires (as do field updates) and makes changes to the record that is committed to the database but the local copy (in your apex code) would not be expected to be changed. The only field value in your local copy that is affected by an insert is that the record ID is set.

So if you want to see what the value of srvcRole is after your insertion and the trigger has run and any field updates etc. then you need to query it back.

Service_Role__c srvcRole = new Service_Role__c();
Id accountRecordTypeId = Schema.SObjectType.service_role__c.getRecordTypeInfosByName().get('Payer').getRecordTypeId();
srvcRole.RecordTypeId = accountRecordTypeId;
srvcRole.Person_Account__c = acc1.id;
srvcRole.Service_Agreement__c = sc.id;
insert srvcRole;

// Here you need to query the data back from the database, your local variable has only had ID set (not any triggers etc.)
srvcRole = [select street__c, country__c from service_role__c where id = :srvcRole.id];

System.debug('value of service role ::::: '+srvcRole);
System.debug('value of service role ::::: '+srvcRole.street__c);
System.debug('value of service role ::::: '+srvcRole.Country__c);

Best Answer

Related Solutions

[SalesForce] How to Populate values to textboxes dynamically on Picklist Selection Change in Standard page layout

[SalesForce] null values of some fields on inserting data in test class

Related Topic