0

I need to create a validation rule to compare the text field value (which is input type) with the Queue list present in my org and if the Text field value is not present the into the Queue List then need to give error message.

Thanks in Advance.

5
  • I don't think it will be possible using validation rule. You need to use Trigger or Hierarchical custom setting approach. May 30, 2016 at 6:45
  • Can we access the queues name in validation rule using Vlookup or anything else?
    – Suyash
    May 30, 2016 at 6:46
  • If you want to use CS then you can directly access them. May 30, 2016 at 7:01
  • Can you share the number of Queues that are present in your system at this point?
    – manjit5190
    May 30, 2016 at 7:08
  • around 15 queues are present in my org as of now.
    – Suyash
    May 30, 2016 at 7:34

1 Answer 1

2

If you strictly want to NOT use code. Then the option I can think of is to have a copy of Queue Names in Custom settings (hierarchical). Your validation rules can access custom settings and hence you can validate.

Just make sure your Queues and Custom settings are always in sync if you prefer this approach.

enter image description here

3
  • So do I need to use VLookup in validation rule for getting the value from Custom settings?
    – Suyash
    May 30, 2016 at 6:58
  • No. You can treat them as normal text fields only. If you click on Insert Field in Validation formula, you can see your custom settings as $Setup.Custom_Settings__c
    – sfdcFanBoy
    May 30, 2016 at 7:07
  • Added image to the answer
    – sfdcFanBoy
    May 30, 2016 at 7:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .