Help needed in displaying many forms at a time and also in including dates from these different forms in the first column in a calendar view

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

Subject: Help needed in displaying many forms at a time and also in including dates from these different forms in the first column in a calendar view

  1. SELECT Form=“FormA” | “FormB” | “FormC” |“FormD” | “FormE” it is wrong.

instead of it use next

SELECT Form=“FormA” : “FormB” : “FormC” : “FormD” : “FormE”

or

SELECT Form=“FormA” | Form=“FormB” | Form=“FormC” | Form=“FormD” | Form=“FormE”