Diaglog/Editable Field Formula Query

HCL Domino Domino Forum
1

Happy New Year to Everyone.

I have a question about a Diaglog List and Editable Field I have called Status. The Choices is using formula, which is below. It’s not a multi-value field.

If it’s a new document, then Pending and No Bid should be displayed. Once the document is saved, the next value should be Outstanding, depending on certain things. Then the status value should be Awarded or Rejected etc…

I’m finding that the value Outstanding will not display after it’s not a new doc. I have a field called NewDoc which on new bid is “”, then after it’s saved the value is set to “No”.

Can anyone help?

Thanks,

Hayley.

@If(@Contains(DataLib;“Prequalification”:“Formal Tender”) & NewDoc=“” & StatusOld!=“Outstanding” & DueDate!= @Today;

“Pending”:“No Bid”;

@Contains(DataLib;“Data Library”:“Budgetary Quote”) & StatusOld!=“Outstanding” & DueDate!=@Today;“N/A”;

@Contains(DataLib;“Formal Tender”:“Prequalification”:“Data Library”:“Budgetary Quote”) & NewDoc=“No” & StatusOld!=“Outstanding” & DueDate<=@Today;“Outstanding”;

@Contains(DataLib;“Formal Tender”) & StatusOld=“Outstanding”;“Awarded”:“Cancelled”;

@Contains(DataLib;“Prequalification”) & StatusOld=“Outstanding”;“Qualified”:“Not Qualified”:“Cancelled”;

@Contains(DataLib;“Formal Tender”) & StatusOld=“Awarded”;“Completed”;Status)

2

Subject: Diaglog/Editable Field Formula Query

Try this, possibly combined with a uidoc.refresh when stepping off the Status field…@If(@Contains(DataLib;“Prequalification”:“Formal Tender”) & @IsNewDoc & StatusOld!=“Outstanding” & DueDate!= @Today;

“Pending”:“No Bid”;

@If(@Contains(DataLib;“Data Library”:“Budgetary Quote”) & StatusOld!=“Outstanding” & DueDate!=@Today;“N/A”;

@If(@Contains(DataLib;“Formal Tender”:“Prequalification”:“Data Library”:“Budgetary Quote”) & !@IsNewDoc & StatusOld!=“Outstanding”;“Outstanding”;

@If(@Contains(DataLib;“Formal Tender”) & StatusOld=“Outstanding”;“Awarded”:“Cancelled”;

@If(@Contains(DataLib;“Prequalification”) & StatusOld=“Outstanding”;“Qualified”:“Not Qualified”:“Cancelled”;

@If(@Contains(DataLib;“Formal Tender”) & StatusOld=“Awarded”;“Completed”;Status))))))

Question: Is this field supposed to be computed, or completed by the user?

If I find some time to further refine this, I’ll stick a post on here…

Cheers

Generic…

3

Subject: Diaglog/Editable Field Formula Query

Thank you very much. That worked…