AnsweredAssumed Answered

Formula in Calculated value

Question asked by aishuiyer on Aug 20, 2018
Latest reply on Aug 26, 2018 by aishuiyer

I have a Form where I generate some short codes using build string function for marketing team.

In the form I have a control called "IO_Number" which  has its master in list "IO_Number_Master".

I also have a control named Category which has its masters in list "Category_Master"

There are  9 Categories where each has its Corresponding IO Number.

Each year IO Number changes for those 9 categories.

now I want the IO_Number control to show only the IO Number option in the drop down corresponding to the year and category selected.

In Sql we can write the query as:

 Select IO_Number from IO_Number_Master

           where year=year && Category==Category.

now which formula to use in calculated field ?