-
I know, my brain doesn't work that direction either - the whole "what is the condition to hide" thing always leaves me writing things out (like I did in the post above) so it makes sense to me. Start mixing up not with hide and with and/or and I short circuit.
-
You'll have to use the translate function. See attached sample. Save the file locally, right click & select design. Preview & type some text in the text box & tab out.
-
Oh, I'm sorry, I saw your other post & just didn't have a chance to get back to it yet. So, the thing is - I think you need "or" here. You want to hide the control if AD = No, OR if Email is blank, OR if Access Card is No, etc.... it always seems backwards to me, I always think of it the way you are right now. :)
-
When you add qRules to a form, you are adding code. This then puts the form in the SharePoint Sandbox, which can cause a variety of different behaviors than seen in the same form previously. Are you running the data connection on load? If so, change that (walk through the data connection again, deselect the checkbox that indicates you want the ...
-
Yes, I'd think so, probably need to use a double eval to concat the students together. I've given this a shot in the attached copy of your form....
-
Is this in the browser? Or in preview / filler?
-
Yeah, you'll have to get the first value, then the second value and add them together.
-
Attaching a sample that at least shows an hours calc excluding weekends based on an 8 hour day.... sorry, I didn't have a chance today to do much more than this, but hopefully it gives you a jump start. Save the file locally, right click & select design, from there you can preview & look at the logic.
-
I've attached your form w/ some changes that I think do what you want. I put a second instance of the repeating table from the secondary data source on the form and added a formatting rule and a calculated value w/ the count formula. I also added a form load rule to run the query for that secondary data source again if this is a saved ...
-
I'll try to put together a little sample later today and attach it to a reply. :)