InfoPath Dev

Hi - your suggested filter should be fine - it isn't clear to me if you are using a double-eval (outside a repeating element) or just eval (in a field inside) - attaching a sample with both. Right click the link and save the file locally, right click the saved file and select design, then preview.

Hi - it is most likely workflow. To check for code, you can save a form as source files and look for a .DLL file in the source files. But feel free to send me a copy of the form if you'd like me to take a look? Obviously, I can't hep check the workflows - there isn't a way to send those. :)

Wonderful, I'm happy I could help you. :)

One issue I have had with multiple selects is that a calculated default relying on them won't always update correctly. In this sample, I've added a button to set a field's value with another field from the secondary data source - right click the linked file, save locally. Right click the saved file, and select Design. From there you ...

See attached. Instead of a default on Day, there are rules on Auto-date. Save the attached file locally. Right click and select design. Then you can preview and try it out.

What part of my response above did you not understand?

Thank you for reminding me! I have verified it is the default value on the "Day" field that causes this. When I deselect the checkbox that says "Refresh value when formula is recalculated" on the default value for this field, the issue doesn't reproduce. I would suggest instead of using a default value on Day, you use a ...

You could add a field to the data source for the user name. In InfoPath, the default for that field could be the account Id from the people picker. I am guessing this is a list form - you will probably need to select "advanced view" for the data source in InfoPath to see the account id field inside the person / group field.

So - this is a query to the same list, and you want to know who is in the list most often? Unfortunately, the REST API doesn't offer any aggregation, so that isn't helpful...Off-hand, I can't think of a way to do this. But it is the end of the day on Friday and my brain is empty. If I think of anything I'll let you know! :)

Weird - I wonder if the calculated value on Day is causing the rule there to re-fire when a filled out form is re-opened. I'll see if I can repro this - sorry, but it will be next week :)