Newbie Questions

Re: Case sensitivity

tafavorite — Thu, 08 Sep 2011 11:49:22 GMT

So if I have two fields on the form that are prepopulated by the GetUser service. They are work email and manager name and email (manager name would be a 3 field). The problem is that I want to make sure that if users were to change the manager email address, that they do not put themself there and with the case sensitivity issue in Infopath, the only way to guarantee that it does not happen is to set both fields to be lowercase or uppercase (we chose lowercase). After some user testing, we would like to keep the values of those fields the way they are originally, so ran across this post and tried to duplicate it. But, I am unsure where they are talking about inserting this formula.

Re: Case sensitivity

Jimmy — Wed, 07 Sep 2011 21:59:12 GMT

Could you describe what it is you're trying to accomplish, specifically?

Re: Case sensitivity

tafavorite — Wed, 07 Sep 2011 20:36:27 GMT

Could someone please explain how to enter this into a field? I am a bit lost on how to enter this and where. If I create a new field and do an action rule with

translate(EmployeeEmail, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = translate(ManagerEmail, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

it does not work. If I put this in a validation rule, it does not work. Must be missing something. Please help if you can. thank you.

Re: Case sensitivity

oldradio99 — Tue, 15 Jul 2008 13:08:24 GMT

oops -- never mind - I was wrong

Thanks.

Re: Case sensitivity

splithare — Mon, 14 Jul 2008 21:43:10 GMT

I am using InfoPath 2007.

InfoPath 2007 is case sensitive when comparing text fields.

"A@msn.com" != "a@MSN.com"

To compare these two text values, I used the following expression:

translate("a@MSN.com", "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = translate("A@msn.com", "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

To test this, I used an expression box field on my test form. You should replace the first argument in each translate function with your fields that you want to compare.

Good luck.

Case sensitivity

oldradio99 — Mon, 14 Jul 2008 20:33:36 GMT

Is Infopath, when comparing fields, case sensitive?

In other words is A@msn.com the same as a@MSN.com when doing an = to?

If not, how would you compare for equality?

Thanks