I have a calendar view where I have to display meeting documents created using 5 different forms. I have used the following View Selection formula:
SELECT Form=“FormA” | “FormB” | “FormC” |“FormD” | “FormE”
Should I use “&” instead of “|” (that is “and” instead of “or”)
And in the first column of the calendar view, I have used the following formula:
@If(Form = “FormA”; FormADateField; Form = “FormB”; FormBDateField; Form = “FormC”; FormCDateField; Form = “FormD”; FormDDateField; Form = “FormE”; FormEDateField; “”)
But in spite of all this, its not working. The documents are not getting displayed properly in the calendar view. Only the documents created using the first form, “FormA” are getting displayed properly on the correct respective date (“FormADateField”)
Please help me with this.
Thanks in advance.
Regards,
Madhunandan