INFOPATH LIMITATIONS

[Adam Harding]

It seems that Infopath cannot cope with more than one field for checking
validation/submission/rules etc. Using only ONE field but many different
values is fine BUT TRYING TO RUN IF TYPE QUERIES ON TWO FIELD IS IMPOSSIBLE.

I have a validation rule stating that if receipt = no the amount cannot be
greater than £5 is receipt = yes then amount cannot be greater than £7. THIS
DOES NOT WORK despite perfect logic it doe not apply any validation at all to
my form.

I have 2 'submit to email' data connections one for authoriser and one for
project team. Setting one button on one form to the authoriser one
automatically changes the other button to submit to authoriser when is should
submit to project team. Changing the other button to project team changes
the first button to project despite the fact it was set as authoriser.

Thirdly if cost centre is X and amount is under Y then email to data
connection 1 if over Y email to data connection 2 DOES NOT WORK if you
ingnore X then it works fine but add the extra field means it does not work
at all.

IS THIS TRUE? IS THERE A WORKAROUND. I have posted 2 questions about this
but have no replys from anyone. PLEASE somone help!!!!

 

[Adam Harding]

You are correct for the validation, my error. My chief problem is with a
rule in that validation case to set the fields value. So if he has a receipt
and value is over 7 i want to reset it to 7. Can this be done?

That works a treat for the submission under rules.

Now my only other problem is conditional formatting a field red if A is Yes
and B is No i cannot seem to get that to work either.

You can do as you are seeking to. Let's look at each of your questions.

1 - VALIDATION
If I have a check box (receipt) and a text box (amount), I can place 2 custom data validation calculations on the text box as follows:
receipt = no and amount > 7 (then display error message A)
receipt = yes and amount > 5 (then display error message B)

This correctly places the correct error message on the text box when the associated calculation evaluates to true.


2 - SUBMIT
There can only be one default submit. When you create a "SUBMIT" button (meaning you've set the action to Submit), then it uses the default submit.... no matter how many submit buttons you place on your view. All of them MUST use the default submit. It's a dumb limitation, but its still a limitation. To get around this, do not set your button to use the submit action. Instead set the action to "Rules And Custom Code"... then set up a submit rule on each button. This will ensure that each button submit to the correct submit adapater.


3 - CONDITIONAL SUMBIT
It sounds like this is a similar problem to #2 above. Only here you have a single submit button. Still use Rules And Custom Code, but in your rules for the button, you can create conditions. Under one condition, Submit A happens, and under the other condition, Submit B happens.


If you aren't familiar with these features, you will likely need to experiment just a little bit to understand what I've described. But it should be pretty straight forward.

Hope this helps!

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



It seems that Infopath cannot cope with more than one field for checking
validation/submission/rules etc. Using only ONE field but many different
values is fine BUT TRYING TO RUN IF TYPE QUERIES ON TWO FIELD IS IMPOSSIBLE.

I have a validation rule stating that if receipt = no the amount cannot be
greater than £5 is receipt = yes then amount cannot be greater than £7. THIS
DOES NOT WORK despite perfect logic it doe not apply any validation at all to
my form.

I have 2 'submit to email' data connections one for authoriser and one for
project team. Setting one button on one form to the authoriser one
automatically changes the other button to submit to authoriser when is should
submit to project team. Changing the other button to project team changes
the first button to project despite the fact it was set as authoriser.

Thirdly if cost centre is X and amount is under Y then email to data
connection 1 if over Y email to data connection 2 DOES NOT WORK if you
ingnore X then it works fine but add the extra field means it does not work
at all.

IS THIS TRUE? IS THERE A WORKAROUND. I have posted 2 questions about this
but have no replys from anyone. PLEASE somone help!!!!