-
Ok, I'm on Windows 10 and running 64 bit InfoPath and 64 bit Office 2016. I can connect to an Access DB when I try to create a new DB bound form. Are both InfoPath & Office 32 or 64 bit on your machine?
-
If you open up InfoPath Designer and select "New" you can see the options for templates. If your data is flat (no nested repeating data) and your users like the functionality of search / filter / views in SharePoint, a list form is likely best. If you have complex data structures, you can use a form published to a library, but need to ...
-
Interesting! InfoPath stores these in base64, so I would guess the value would be the same for both.... see attached sample. Right click the link, save the file locally, right click the saved file & select design. Then you can preview and try it out.
-
Perfect. Sometimes it is helpful to know that a technique does work, so we know that there is something else causing an issue. Glad you found it!
-
Can you attach a screenshot of the error under the "Options" tab in a reply?
-
So - I'm attaching my test form. It just worked - I submit, set the title field with a concat using the ID, and submit again. The same record stayed open in the form. Attaching my sample - you may want to try a simple sample form with a test list just to narrow down whether the issue is with your site, your specific form or something else all ...
-
Use substring-before. Syntax would be like: substring-before(userName(), "i:0#.f|membership|")
-
I'll set up a test list & form later today to see if I can figure out the right steps for this. :)
-
Thank you so much for posting the resolution! I'm glad you found it. :)
-
So - dumb question - but have you selected "remember me" when logging into SharePoint? Or since you are using SSO, that isn't needed? Is the site in your local intranet in IE?