InfoPath Dev

Perfect, glad you figured it out. Thanks for posting to help others. :-)

 I think I've figured out what I need.  I can use the barcode font.

Yes, I believe you are correct. I have been trying to get my customer to see that InfoPath is just not the tool for this and this information definitely helps me get that message across. We need to use Power Apps and I have told them this a few times over the course of the development of this form. Thanks for all the help!

You need to query for all the data for the location. Then, in the form, use logic, like rules, to determine whether there is any entry in the returned data that matches or overlaps the date range in the form. If you use a REST query for your list data, you would be able to query for a range, but a built-in InfoPath List data connection will only ...

I got the query working and it does bring back all data in the list. I can query dates and it filters by date through the query with no issues. I just cannot get it to validate or find dates between two dates like January 5th through January 10th as not being valid for scheduling so its one range of dates and not just two days start and end date. ...

 Hi Hilary - Happy New Year to you !!  Thank you for pointing me in the correct direction.  I have fixed the SAD/SAD error (duh sorry about that finger/eye error - you look at something numerous times and see what you expect to see.) Now I am only getting the   "Unable to connect to the remote server ...

I query the name of the location, start date and end date to get the exact dates to make sure if they are available or not available. I get a red mark across each section for the specific location that are not available based on those dates. This is done from the fields start date and end date on top of the screen. This will make the location ...

I'm seeing errors for RiskAssessmentsRole and RiskAssessmentCountries. Search for GetMetadataForUrl in the attached log file and you'll see that the form is trying to access a relative URL like: /SAD/SAD/Lists/RiskAssessmentCountries. To me, it looks like the Site portion of the URL is duplicated. I'm guessing you don't have a site ...

Hi, Our environment has gone through radical changes.  Our company has been sold and we have new domains/tenants/SharePoint Farms. I have moved a form to the new farm, updated the data connections and re-published it is opening with correlation errors. The error is "You do not have permissions to access a SharePoint list that ...

You mention querying the name, then start date, then end date - can you tell me more about this? Query fields for SharePoint lists only are for equivalence, so that could be part of the issue here. You can set the Name query field and run the query, that way all the data returned is just for the specific location. Then you should be able to date ...