Computed table backgroud - works in client, but designer, not so much

HCL Domino Domino Forum
1

Client only.

I’m using a color swatch as a computed table cell background to indicate ‘required field’; field is blank, table cell is colored; put the data in, cell goes clear/white.

It works great in the client.

MOST of the cells show the background color in the designer - I’m guessing the designer sees the referenced fields as blank so the cell image is displayed in the designer.

Except for one field/cell combination. The field is a date field using a date selector. In the designer client, the cell shows white/clear.

Not a big deal since the cells actually work in the client, but it seems a bit odd and I can’t figure out what’s going on. Anybody know?

Thank in advance.

Doug

Cell formulas are along the lines of @If(MyField = “”;“blue.jpg”;“”)

Blue.jpg is an image resource in the db.

2

Subject: Computed table backgroud - works in client, but designer, not so much

So, what’s the real name of the field in question. Could that make the difference?

3

Subject: RE: Computed table backgroud - works in client, but designer, not so much

DueDate

The background is handled correctly in the client. In Designer, the background is white for this field but blue for all others.

I posted formula info up the thread.

Doug

4

Subject: RE: Computed table backgroud - works in client, but designer, not so much

I noted the additional info, but sort of ran out of ideas, that’s why I kept quiet. :slight_smile:

5

Subject: RE: Computed table backgroud - works in client, but designer, not so much

Hmm, well, looks like Domino Designer is smarter than the Notes Client: Designer knows immediately, that DueDate is a date field, so it’s value can never be the empty string.

Put @Text around DueDate, and it works in Designer as well. Not that this is of any use (as far as I can see), but it comes as as surprise.

6

Subject: RE: Computed table backgroud - works in client, but designer, not so much

Thanks for the reply - very clever detective work!

I’ll add that in so the designer looks like the client.

Doug

7

Subject: Computed table backgroud - works in client, but designer, not so much

Doug,With the one field that is not showing clear/white, is it being computed or have a default field?

8

Subject: RE: Computed table backgroud - works in client, but designer, not so much

The fields are both computed (formula = field name) and open for user entry. In this case, the field name is ‘DueDate’, it’s a date field, calendar control, and the cell image formula is @If(DueDate = “”;“blue”;“”).

Other fields look like:

Text, editable, name “CompanyName” - table image formula: @If(CompanyName = “”;“blue”;“”)

and

Text, computed, name “PartNumber”, value set via a button that looks up a list of Part Numbers and sets the field value once selected. Table image formula: @If(PartNumber = “”;“blue”;“”)

Like I said, all the fields follow the same concept, use pretty much identical formulas structures and all of them work in the client (ie, DueDate is blank, cell image is blue - select a date using the date picker, tab out to another field and the cell image goes clear/white).

It is ONLY in the designer that the cell color is white/clear and just for the DueDate field.

Weird…

Doug

9

Subject: RE: Computed table backgroud - works in client, but designer, not so much

Is there a default value for the DueDate field?

10

Subject: RE: Computed table backgroud - works in client, but designer, not so much

No default value. If there was, then the client would be missing the blue image when a new doc is created and that’s not happening; new doc, blank field, blue image background.

It’s like the designer thinks date fields have some default value but the client knows that’s not the case…