InfoPath Dev

I think when you talk about hiding unused sections, you may not be thinking of repeating sections. The only way to have multiple instances of a repeating group (by the way, the data structure for repeating sections & tables is the exact same in IP - both are bound to repeating groups) without using code is to insert the max number of instances ...

Maybe try removing the index ([1]) from the formulas. I just created a test form on one of my SharePoint sites for a list there and this worked as anticipated. It also worked in preview....

Hi Hilary, Good day. Thanks for pointing me to the right direction. I figure out the issue here. Initially I did create a form from scratch. The REST DC is working when I preview on local machine. When publish to sharepoint, it is having 5566 error which I expect because we are on SP2016 which uses claims authentication. Then I convert the REST ...

Hi There, Im new here, new to infopath. My form is almost complete but I main things I would like to figure out still, which seem a bit more complicated. The first one is that I would like infopath to dynamically add repeating sections for different days that the user would add in hours worked information. I figured out how to calculate the ...

I still can't get it to work, tried to play around with the formulas a bit but there's still no result. Thanks a lot for the effort tho - really appreciate it. Until now I didn't know about the functionality to add rules to new sections, so it wasn't for nothing... I learned something new at least :-)

For the People Picker, try the attached (save the file locally, right click, select design to open in design mode, then preview). Instead of using default values, I added rules to the repeating group. However, this is a SharePoint List form, and I recall some issues with setting people pickers via rules in those - If I remember correctly, it ...

Oh my goodness. Glad you solved the mystery! How frustrating. :)

I am going to guess there is an issue with Owssvr.dll. If you take a new form, no qRules or code, and add an owssvr.dll data connection, and publish it to the browser, does the data connection query without error? If there is an error, what's in the SharePoint logs?

 You bet. The default formula for the field bound to the textbox would be: substring-before(fieldwithdate, "-") XML stores dates in yyyy-MM-dd format. The date picker or other control may display the date differently, but if you open an XML file saved from your form and look at the date field, it will be yyyy-MM-dd. If it ...

Hello,    I would like to know,  Is it possible to extact year from date picker into textbox ?  Thank you very much for your help, Adam