Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 2 (13 items) 1 2 Next > Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Ahh, ok, At least it'll warn them. Thread solved and thanks! Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Ahh, yes I forgot to tell you that small detail. I have the form published to email recipients. They open up the email, fill out the form, type the email address it goes to and hit "Send". Once the "Send" button is hit is when I get the message I stated above. Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Yes yes yes, that worked when the hours equal 40, Thank you! :) Now, when the total hours DON'T equal 40, I get this message ... Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Hours_Total 0 != xdMath:Nz(.) + xdMath:Nz(../my:Absence_Total) and 40 != xdMath:Nz(.) + xdMath:Nz(../my:Absence_Total) ------------------------------------------------------------------------------------- Absence_Total 40 != xdMath:Nz(.) + xdMath:Nz(../my:Hours_Total) and 0 != xdMath:Nz(.) + xdMath:Nz(../my:Hours_Total) Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" One more note: Even when "Hours_Total" and "Absence_Total" combined total DOES equal 40, they still have a red border around each of them with the same error. I'm sure it's something I'm doing I just don't know what it is. Thanks Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" (Sorry for the delay) Sure, here you go...(paths below are from right-clicking on "Absence_Total" and clicking on "Copy XPath". Same with Absence_Total. Hours_Total XPath = /my:myFields/my:Hours/my:Total_Hours/my:Hours_Total Absence_Total XPath = ... Posted to Newbie Questions (Forum) by duugg on 05-31-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Hilary, I tried copying your code (changing "Field 7" to "Hours_Total" and "Field 8" to "Absence_Total" and I'm sure it's my fault, but it didn't work. One quick question though... In field 7 you refer to field 8 and field 8. In field 8 you refer to field 7 and field 8. Is this the way ... Posted to Newbie Questions (Forum) by duugg on 05-30-2012 InfoPath to Outlook When publishing infopath forms to Outlook, all my dates show up in the Outlook fields one day earlier, all at exactly 11PM. To further confuse the issue, the dates in my preview window in Outlook DO show the date correctly. Outlook even exports to Excel all the dates correctly. The only problem is that my dates don't show up ... Posted to Newbie Questions (Forum) by duugg on 05-30-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" WWoWW, I don't know how anyone is supposed to figure that out without the help of people like yourself. I am going to absorb this a bit and see how I do with it. I will do my best to try and keep you posted the second I am either successfull or have another newbie question. There's is NO way I would've been able to do that on my ... Posted to Newbie Questions (Forum) by duugg on 05-30-2012 Re: Data Validation: Do not allow form to publish/send if the sum of two text boxes do not equal "40" Hmmm, Ok, here is what I have in the "Text Box Properties"/"Value"/"Insert Formula" text box of my "Hours_Total" field... Hours_Monday + Hours_Tuesday + Hours_Wednesday + Hours_Thursday + Hours_Friday + Hours_Saturday + Hours_Sunday Would I put the expression after all that? If yes, do I hit ... Posted to Newbie Questions (Forum) by duugg on 05-30-2012 Page 1 of 2 (13 items) 1 2 Next > Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.