-
Oh great - so that error - for some reason, InfoPath thinks you've bound that calc'd value to repeating data (even though you have a filter on it and know it will only return one item!). I've generally only had a problem with it if my form has code and is directly published to a form library (sandboxed) or if my form is admin approved ...
-
Do you have code in the form?
-
Yes, it works! Thought that error was a show-stopper - so glad it's safe to ignore. Thanks again!
-
The only way I can do it is to have 2 date controls fake (date), real (date/time) on the fake date control have a rule to set the real date control to the following concat(addDays(., 0), "T17:00:00")
Then you could remove the real date part of the control, to the human eye, it would look like 1 control.
-
Hi Patrick thanks for your reply. Just one question I'm not familiar with this XLS2XML tool. Where do I find it?
-
But when you preview the form, is the count correct? Because your formula looks right to me. Or were you just concerned you'd have issues when you publish? As long as your form doesn't have code, that error can be ignored - here's a blog post about it. ...
-
Fantastic, glad you have it working!
-
Thank you Hilary! I'm stuck, so have attached my form. The Reviewer Dashboard is in the "Assign" view. My calculated value formula is
count(Reviewer1[. = current()/Title]) + count(Reviewer2[. = current()/Title]) + count(Reviewer2[. = current()/Title])
Title is the ReviewerName field in my repeating table. I'm getting ...
-
I'm not sure what causes this...but I've seen InfoPath return the full domain\username in the past with the username() function. now, more commonly, I only see it return the user name.
Is this a switch type setting, or something upstream of InfoPath that has to be adjusted?
thanks
-
I would like to change the default time from 12:00:00 AM on my date picker to 05:00:00 PM. Is there a way to do this?