-
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 :)
-
I published the form to my SharePoint online tenant - I had to remove the Contacts data connection and all the defaults associated with it - and this seems to work as anticipated. See screenshot. Not terribly helpful, I know....
-
Excellent! So, at the end of the query, you can add a filter, and so forth. Here's an example that will return the first 10 items where the ID field is greater than 1: YourSiteURL/_api/web/lists/GetByTitle('YourListTitle')/items?$filter=ID ge 1&$top=10 For your InfoPath Form, you need to figure out how to get the items that match ...
-
In InfoPath we can create connections to REST services, and then we have the ability to change the REST URL as a rule action. There are sometimes SharePoint settings that need to be modified for these queries to work in the browser. You can work out the correct URL in your browser to make sure you have the right URL before adding the connection. ...
-
I think your best approach may be to use the SharePoint REST API instead, or the list data svc, depending on your SharePoint version. Then you can just get the top 10 most recent rows returned for a given ID. Let me know what version of SharePoint you are using and I can help you with this. :)