thementornetwork
MIS
Goal: trying to write a IF STATEMENT in the Record Selection Formula area to add extra conditions to filter data I am retrieving.
If a Note creator is selected from the parameter list, then filter Notes by the selected Note creator, else return Notes entered by everyone.
My code:
(IF NOT ISNULL({?selected_notecreator}) THEN
table.notecreatorfield = {?selected_notecreator}
ELSE
' ')
I am having trouble getting the right syntax for the second part of my statement. I want something like:
ELSE return ALL
Please help me get the right syntax. Thanks!
If a Note creator is selected from the parameter list, then filter Notes by the selected Note creator, else return Notes entered by everyone.
My code:
(IF NOT ISNULL({?selected_notecreator}) THEN
table.notecreatorfield = {?selected_notecreator}
ELSE
' ')
I am having trouble getting the right syntax for the second part of my statement. I want something like:
ELSE return ALL
Please help me get the right syntax. Thanks!