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 )
AliciaVeeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Steve KnightConnect With a Mentor IT ConsultancyCommented:
Sounds like you want something like this?

@If(LCDocType="";"-";LCDocType = @LowerCase(DefaultDocType3); ""; @IsNewDoc; OpenTxt;
LCDocType = @LowerCase(DefaultDocType2) ; Stat; RevStat )

What have you got in the view selection formula and do you need help with that?

To pick, say, the DocDate field if the DueDate is not a date value you could incorporate something like:

@If(!@IsTime(DueDate);DocDate;DueDate)

If you show us the specific column / view selection formula already used can help modify it.

Steve
0
 
AliciaVeeAuthor Commented:
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 )
0
 
Sjef BosmanGroupware ConsultantCommented:
Just a *bump* for Steve... I'm still incompatible with TeamRoom ;-)
0
 
Steve KnightIT ConsultancyCommented:
Hmm, thanks Sjef I must have missed that reply comment before.

Will review from pc later or tomorrow.

steve
0
 
Steve KnightIT ConsultancyCommented:
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.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.