-
If you are just subtracting 9 hours, you could use the addSeconds function - use a negative 32400 as the second argument. Right click the link to the attached file, save locally. Right click the saved file and select Design to open in design mode - I've put this calculation in a calculated value control on this sample.
-
Ok, so you are using a people picker in the form. In your other list with employees and departments, if the Employee field is a person or group column type, then you would be able to match on the account id to get the correct dept. Add a data connection to your list to your form, attach a copy of your form here, and I can help you.
-
I would just use the documents library and open in Word rather than Word Online, if your users don't like Word Online. I don't recall if you are using SharePoint On Prem or Online, but on our SharePoint Online site there is a three dot menu and the option to open in the app (see attached screenshot which is for Excel, but my guess is that ...
-
So, here's what I do, usually. Set the data connection to not run when the form loads (that will be an option in the data connection wizard, I think on the last screen - it is a checkbox). Then, in the form load rules, add a rule to set the archive query field to false, then add another rule to run the query.
-
Glad that did the trick - we all need a second set of eyes some days. :)
-
When you select Full Trust under the versioning settings, you'll see an option to sign with a code signing cert. You can click Create Certificate to generate a temporary certificate. The other option is for the users to install the form, but then each user has to install it, and you have to trust them to re-install it when a new version comes ...
-
Looking at the error, I'd guess that the submit data connection is incorrect. I think the library URL in the form submit connection needs to be just to the library, like this: http://teamsource.lennoxintl.com/proj/SupplyChainLogistics/External MD/
-
Have you seen this webinar video? It might help you, and has a link to a kit you can download that should have some additional materials: https://www.youtube.com/watch?v=Wof2n9RHU5w
-
Yep. You need to add a data connection to the list with employee / dept. How do the users currently enter the employee in the form? Do they select via a people picker or something?
-
So, when you publish your full trust form, you do need to sign it. Have you tried that? InfoPath will let you create a cert that is good for a short time - you could do that to verify that the form then works as anticipated from the published location.... You can use Visual Studio's makecert to create a longer term cert if that solves the ...