Newbie Questions

Re: Rules with and/or statement combination?

monk_mst — Tue, 17 Sep 2013 06:03:56 GMT

Thanks Jimmy,

I think I understand the logic of what you have designed and it does make a lot of sense. This is my first attempt at a form through trial/error, please bear my ignorance if you can. Also, looking at the rules you have applied I have a lot to learn.

Thanks again,

Monk

Re: Rules with and/or statement combination?

Jimmy — Mon, 16 Sep 2013 18:25:28 GMT

The logic will be a lot cleaner if you use a repeating structure and keep track of the Pass/Fail values for each row. Please have a look at the attached form. I populated the table using the Default Values dialog accessible from the Data tab in InfoPath 2010.

Re: Rules with and/or statement combination?

monk_mst — Mon, 16 Sep 2013 04:43:53 GMT

Hi Patrick,

Thanks for your support in advance.

Regards,

Monk

Re: Rules with and/or statement combination?

Patrick Halstead — Sun, 15 Sep 2013 21:36:01 GMT

Hi Monk_mst and welcome,

I need to look at your form. Can you reply and attach it in the options tab?

Thanks!

Rules with and/or statement combination?

monk_mst — Sun, 15 Sep 2013 11:59:33 GMT

I want to change the formatting of a cell based on the conditions on the table cells that follows.

It goes like this

STATUS CELL

column1 column2

Cell1 Cell2"YES/NO"

Cell3 Cell4"YES/NO"

If a name is entered in column 1 then it checks whether column 3 is YES then changes the status of the cell to green else it stays red.

So I used the following code:

cell1 is blank and cell2 is blank or
cell1 is not blank and cell2 is equal to YES and
cell3 is not blank and cell4 is equal to YES

then status cell is green.

I cant seem to get the above to work and if someone could guide me on where I am wrong I would be really grateful.

Regards,

Monk