Question

I looked over the page for IfStatements but don't see what I was hoping to find.

Is there a way to say

   If (exists SomeTopic) then
     do something, e.g. INCLUDE it or TOC or show a link...
  else
     something else

Environment

-- VickiBrown - 11 Apr 2007

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

It should be possible to do the IfStatements with a VarIF.

Alternatively, use the SpreadSheetPlugin formula. For example:
%CALC{$IF($EXISTS(WeeklyReport), $NOP(%)INCLUDE{WeeklyReport}$NOP(%), Weekly report is currently not available)}%

-- PeterThoeny - 13 Apr 2007

You cannot use IF for this.

-- ArthurClemens - 13 Apr 2007

see bug report 3889

-- VickiBrown - 13 Apr 2007

This is fixed now. Specify a full $EXISTS(Web.Topic), or upgrade to the latest SpreadSheetPlugin.

-- PeterThoeny - 15 Apr 2007