asked on

Need a tweak in Column code (in Notes view)

Experts,

The code below is the defalut in column, in a view, in the TeamRoom database. I want to tweak it to add an additional criteria:

I want to include a document in this view that doesn't have a duedate....so I want to leverage the docdate -- and there should be no value that appears in this "Status" column. I would like it to simply be a null value or a "-"

The criteria would be: @If(DocType="Calendar Only") then add the null value or "-"

I've tried a few tweaks and nothing is working. Thanks!
-----------------------------------------------------------------------

REM {variables to translate};
OpenTxt := "Open";
CompleteTxt:= "Completed";
LCDocType := @LowerCase(DocType);
Stat := @If(DueDateStatus = "0"; OpenTxt; CompleteTxt);
RevStat := @If(ReviewStatus = "1"; CompleteTxt; OpenTxt);

REM {if meeting then blank; if actionitem it depends on the DueDateStatus field; all others depend on the ReviewStatus field};
@If(LCDocType = @LowerCase(DefaultDocType3); ""; @IsNewDoc; OpenTxt;
LCDocType = @LowerCase(DefaultDocType2) ; Stat; RevStat )

ASKER CERTIFIED SOLUTION

Steve Knight

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AliciaVee

ASKER

Strange, I thought I added a reply to this last post -- but its not showing? Darn Wi-Fi...

Okay, so status comlumn has the code I included in my orginal post. I am using the main document in a teamroom and I want to show both action items (that have a due date) and also main document that has a "Calendar Only" doctype assigned in the field (instead of action item). The Calendar Only doc type has a DocDate that will be the DueDate -- and this types of documents will not be actionalbe when the reminder agent runs (a reason we want an info only type of document).

Bottom like, one form, with two different DocTypes, one is Action Item, the other is Calendar Only. No duedate for Calendar only, and so the status column (that is looking at DueDate) is showing OPEN -- and I want it to show "" or "-" (its not open and its not closed)

-------------
REM {variables to translate};
OpenTxt := "Open";
CompleteTxt:= "Completed";
LCDocType := @LowerCase(DocType);
Stat := @If(DueDateStatus = "0"; OpenTxt; CompleteTxt);
RevStat := @If(ReviewStatus = "1"; CompleteTxt; OpenTxt);

REM {if meeting then blank; if actionitem it depends on the DueDateStatus field; all others depend on the ReviewStatus field};
@If(LCDocType = @LowerCase(DefaultDocType3); ""; @IsNewDoc; OpenTxt;
LCDocType = @LowerCase(DefaultDocType2) ; Stat; RevStat )

Sjef Bosman

Just a *bump* for Steve... I'm still incompatible with TeamRoom ;-)

Steve Knight

Hmm, thanks Sjef I must have missed that reply comment before.

Will review from pc later or tomorrow.

steve

Steve Knight

Hmmm that one obviously got missed this end... bit late for me to start replying after 2 years!

AliciaVee - if you are still here, always OK to remind people of your question by posting for feedback.