That was a tortuous post title! Another post to help me remember.
I created an InfoPath 2013 form to add a new list item. One of the fields was a lookup field using a column from another list.
The lookup field was a Person field, which in InfoPath looks like repeating data.
I needed the dropdown list to show values where there was nothing in this Person field. It took me a bit of messing about to get it right.
Filtering with repeating data
The trick is to filter on the group. In my instance, I needed to show all entries where there was nothing in the User field for that list item.
The logic required was “All occurrences of Person are blank”, on the List Item row.
Hope this helps someone…
Another gotcha found today.
I’ve created my ASP:Hyperlink field in the aspx page, with runat=”server” (oh yes, that one ain’t catching me out anymore).
In the C# code behind file, I set the URL to be one thing or another, depending on some other logic. It’s MyHyperlink.NavigateUrl = “blah.aspx”.
I run the thing, and I get “Object reference not set to an instance of an object”. Dammit!
Have I forgotten how to instantiate the field properly? It’s not in a grid view, or anything fancy like that.
A random Google result gave me the answer, phew! .NET3.5 and above requires the Hyperlink to have its NavigateUrl property set to something when created. So on the page I set it to “#” on creation and then set it dynamically as necessary.
Another one not to forget!
Another thing to pop here so I don’t have to Google it over and over.
I’m also not adding my email address to a list so I can download a PDF of it, just to be spammed. 😠 No Sir.
I really hate throwing out food that’s gone bad. I try very hard to menu plan, etc. I also use veg in sauces and soups which is a little off its best. These links are really useful for me:
Fresh produce shelf life
Mix and match slow cooker food
Make pesto with any herby leaves
How long can you store stuff in your freezer?