Author: Iain 'Cutty' Carlin

Who would have thought InfoPath was so picky…

Posted on by Iain 'Cutty' Carlin

My relationship with InfoPath is love hate. On the one hand it’s so easy to create web forms on the other some of the simplest tasks are incredibly difficult.

Take today’s task – putting a simple URL on a form to open a Nintex workflow page for the form. InfoPath lets you put a URL on a form, but you can only have a static URL or populate it from a data source. The data source must have the full URL.

Easy, make the full URL a calculated field…except that calculated fields can’t user ID as one of the fields. In the end I put a button on the form.…

+

SharePoint filters evaluate criteria in order

Posted on by Iain 'Cutty' Carlin

Users requested that I filter a list of announcements so that the logic would work like:

(Show All Users Notices OR Staff Notices) AND (Posted before today AND expire after today).

The default filtering doesn’t let you put the brackets into the filter query. Turns out that SharePoint runs the query in order and ‘virtually’ puts brackets around things.

So my eventual logic was(((Show all Users Notices Or Staff Notices) AND StartDate before Today) AND Expires After Today).…

+

Learning one new thing a day for a year

Posted on by Iain 'Cutty' Carlin

I thought this was an original idea, but googling it found that there are plenty of others doing the same thing. However, I will press on.

I often marvel at how much I have to look at Google every day in my job as a programmer. When I stop and thing about it, that equates to a lot of stuff that I learn without really knowing it.

S, I thought I would create this blog and keep a record for the next year of everything I learn that is new each day.

If nobody else gets anything out of it, at least I will.…

+

InfoPath – “Schema validation found non-datatype errors.”

Posted on by Iain 'Cutty' Carlin

I have a multi-view form that loads different views depending on the status and user. I can’t test it using preview unless some data is loaded.

I have to upload the new form and try it out on live data. I made a change, uploaded then got the error: “Schema validation found non-datatype errors.”

In mucking about with my form, I changed the order of some fields in the Submit data source. InfoPath doesn’t like this and gives you the cryptic message above.…

+