-
In this copy I've added the query title field to the form at the bottom and another button to run the query, as well as a few fields from the data field so you can test a bit - just try entering the desired Title in the query title field, and running the query from the button. See if your results are any different....This will at least give ...
-
You aren't disturbing me, no need to apologize. So, in the attached template, on your button, I added a rule to set the query title field in the main DS to the title field in the 2ds. Then the query runs. That way only the items w/ the same title should be returned. Does that make sense?
-
Ok. Does the rule on the button that I modified return the correct items? Is it just an issue when the form first loads?
-
No - I can't preview the form because I don't have access to your SharePoint site. I'm also confused at this point as to what issues you still have - you had one post that indicated you were not able to get the current work items, then the next seemed to indicate you were? Can you clarify for me what you still need help with?
-
Try putting just the display name from the people picker on the form in a calculated value and see if that displays. If so, you might need to use some conditional formatting rules to display the people picker vs the calculated value.... like, if Display Name is not blank, show the calculated value, and if it is, show the people picker. You could ...
-
Well, in the browser, the same formula seems to work ok with a time field.... but I suppose if it is just a time, that is going to be confusing for the user? I mean - if you have selected today for the date, and 8 am for the time, then the time -9 hours would be the day before. Is your end goal to display just time? Or date time?
-
It is so weird. The second I add a time control to my form, the original formula stops working correctly (only subtracts two hours instead of nine) and when I do the same calc on the time field, same thing happens. Are you using this form in the browser or in InfoPath Filler? I'm wondering if it will behave better in the browser....
-
Maybe give this one a try? It looked on your button like you were setting the title query field after you ran the query, but you'll want to do that before. I added a default value to Abteilung Mitarbeiter/Name/Kompetenz - it is making the assumption that the Name 1 field in your other list is going to match the display name from your people ...
-
Well yuck. This sounds like a bunch of really not helpful errors. I think the first thing I would try, if you haven't already, is restarting the machine that I'm working from. I have seen in the past oddball publishing errors that were cleared up by that. Then, I think the next thing I would try is publishing from a different machine - ...
-
So the data type for your field is time only?