SQL Database Integration

Re: Conditional formatting based on New Record ?

paulsassya — Wed, 17 Mar 2010 09:39:37 GMT

Hi Patrick,

You mentioned: "set that value when the New record button is pressed"

How do you do that?

Paul

Re: Conditional formatting based on New Record ?

Patrick Halstead — Tue, 16 Mar 2010 07:07:08 GMT

Hi Catharine,

You can put the datafields section in an optional section that is hidden based on a field in a secondary data source (you can add a little XML file that has one value in it) and set that value when the New record button is pressed.

Hope that makes sense!

Patrick

Conditional formatting based on New Record ?

Catharine — Tue, 09 Mar 2010 16:31:19 GMT

Hi,

I am using InfoPath 2007.

I have a form with qRules in and working.

I have created the form linked to a database table.

I have the query selection box based on a secondary datatable. When the selection box is updated an appropriate button appears - either get existing records(Run Query), or create a new record (New Record).

I would like the datafields section on the form to be hidden until one of these buttons is pressed. I don't know what condition to use to get the conditional formatting to work.

I can count the number of records - if any exist. So I can cope if there are existing records.

If there are no existing records - what condition can I use to make the section appear - but only after the New record button has been pressed.

I hope this makes sense.

Thank you

Catharine