General

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Thu, 14 Jul 2011 23:22:44 GMT

Cool!

I am about to get out of here for the weekend and will look at it in more detail next week.

Just the little I have played with it, how do you make a group selection like that? I have been looking in teh controls and can't find the option for that.

Thank you for this:)

Ynygma

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Thu, 14 Jul 2011 20:36:02 GMT

Try this out and see if this fits part of what you are looking for. We can move forward from here.

This test form uses a button group to handle the validation (Easier on the developer) which can then run a rule to setup a text box to say anything.

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Tue, 12 Jul 2011 17:19:05 GMT

Hi there Leooffneym.

Were you able to figure out why it is not working?

Thank you,

Ynygma

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 20:55:28 GMT

This is what I have. Hopefully I got it right because I had to type it out manually from looking at the form rules.

Rule 1: (ActivitySelected = TRUE and checkbox1 is not blank)
Condition: ActivitySelected = TRUE and checkbox1 is not blank
Action: Show dialog message: Only 1 Activity Alarm can be selected at a time!

Rule 2: (ActivitySelected = FALSE and checkbox1 is not blank)
Condition: ActivitySelected = FALSE and checkbox1 is not blank
Action: Show dialog message: Only 1 Activity Alarm can be selected at a time!

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Wed, 06 Jul 2011 20:16:16 GMT

Can you post the rules that you have in the checkbox?

Also, are you selecting a box in column1 and in column2 and not getting the popup, or selecting mulitple boxes in column1 or column2?

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 20:07:59 GMT

The rules being setup won't go into the data validation part of the properties of the field, it will be a regular rule. The reason being is that using regular rules give you more control over certain aspects that data validation cannot.

No, the rules I have set up are in the "Rules" not the Data Validation.

But, no, I am not getting any prompt when I select more than 1 box:(

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Wed, 06 Jul 2011 19:54:57 GMT

I think we may have disconnect here.

Data validation works great to make sure a field is not blank, or is a number, etc., but in this case, you are trying to make sure that only 1 out of the 7 or 9 fields in checked. Data validation would be harder.

Using the rules to do it, is doing a "fake" (not really fake, but we not using the data validation button) kind of data validation while also making sure only one is checked.

You should get some kind of prompt when more than one box is checked from the same column. You can add more rules to check to make sure that only one box is selected from both columns before you push the submit button.

Im curious as to why you didn't use a button group for your columns. A button group would solve the more than one selected in a column problem instantly with no rules. (I should have thought of it earlier)

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 19:40:32 GMT

Hmm,

OK, I got everything setup like you instructed, but I am getting validation errors when trying to submit:

InfoPath cannot submit the form.
The form cannot be submitted because it contains validation errors. Errors are marked with either a red asterisk (required fields) or a red, dashed border (invalid values).

If I go into those boxes and turn of those 2 rules then it works fine.

The other question I have is, should I not have gotten a Prompt as soon as I checked the second box or does this only happen on submit?

Thank you again for all the assistance:)

Ynygma

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Wed, 06 Jul 2011 13:33:10 GMT

Its ok if you can't upload, I am starting to get what you are looking for.

For that, you will have to do a little more work. This is what I would do for this.

Add 2 new Fields, named Column1Selected and Column2Selected (Name as you wish), set as boolean, set to false.

Now for every Checkbox in Column1, add a rule to check if Column1Selected is set to false and if this Checkbox is checked, Add Action to set Column1Selected to true.

Also add a rule to check if Column1Selected is set to true and if this Checkbox is checked, Add action to popup message.

Do the same for Column2Selected. It is more work.

When I said to make sure they are in order, if the are put in, in the wrong order, the rules won't work correctly. (A comes before B kind of thing)

You can probably ignore the previous post since I was still confused on what you needed.

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 13:19:06 GMT

I think I am getting it... So this applies if I have 7 boxes on the first column and lets say 9 on the second. So with multiple boxes in each column, would it be like box1a OR box2a, box1b OR box2b? When you said make sure they are in order that is what throws me. So it looks like this Column 1: Column 2: x checked x x x x x x x x x checked x Any 2 of those boxes 1 in each column can be checked, and they do not have to be on the same row. But what I don't want is for the user to check 2 in the same column. I would send you an example if I could..but I am unable to upload from here.

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Wed, 06 Jul 2011 12:56:07 GMT

Thats not hard then.

Add a new field called Submittable (Name as you like) should be a boolean, set to false.

In the Submit button, setup a new rule that checks to see if either box1 OR box2 is checked, Add Action set Submittable to true.

In the Submit button, setup a new rule that checks to see if each box1 AND box2 are checked, Add Action popup message. and set Submittable to false.

Make sure these are in order, this checks to see that one of the boxes is checked and won't let you email if they both are checked.

In the Submit button, setup new rule to check if Submittable is true, Add Action to email to that datasource.

Test to make sure it works as planned and you should be good.

Hope this helps.

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 12:43:14 GMT

Not exactly. There are 2 columns of checkboxes. Only 1 checkbox per column should be checked. So what I would like is when you hit the submit button, if more that 1 box per column is checked, you get a validation error that won't let you send the email until you only have 1 check per column.

Re: Apend values from multiple checkboxes to email subject line?

leoffneym — Wed, 06 Jul 2011 12:34:43 GMT

I am a little confused on how you want the validation.

Are you trying to to make sure both check boxes are checked before sending the email?

Or, just want to notify the user that one of the boxes has not been checked and it can be emailed as is?

Re: Apend values from multiple checkboxes to email subject line?

ynygma — Wed, 06 Jul 2011 04:17:11 GMT

I am not following. I have an email submit datasource already for rhe form. Can you please elaborate?:) Thank you, Ynygma

Re: Apend values from multiple checkboxes to email subject line?

BlvdWheat — Tue, 05 Jul 2011 19:38:26 GMT

You can make one datasource and tie each checkbox back to that datasource (but keep the value of each checkbox different). Now you should be able to force them to check one box and when it is checked disable the rest?