SQL is fairly new to me and I am struggling to flag a field as "required" if another field has a certain value.

For example, if a certain field is set to Yes, then this field has to be set to "required" before saving the ticket.

I hope my question make sense. :)


Answer Summary:
0 Comments   [ + ] Show Comments


Please log in to comment

Answer Chosen by the Author

You can't mark fields as required based on other fields, unfortunately. The best solution in this case is to create a rule that if fieldA has a certain value and fieldB is blank then email the user to ask them to fill out fieldB. In our case I have this rule set to email the submitter every 15 minutes (that's how often the rule runs). This has the effect of making them fill out the field regularly.

Answered 05/20/2015 by: chucksteel
Red Belt

  • Thanks chucksteel !
Please log in to comment


Answer this question or Comment on this question for clarity