-
Hi,
I don't believe that the qRules command (SaveToSharePoint) will allow setting other columns in the document library. However, the command does include a parameter that allows you to set the name of the uploaded document (so you don't have the string of numbers before the document name), so at least that solves one issue. Can you give ...
-
Hi,
Certain math, string and financial functions that are available in Excel are unfortunately not available in InfoPath. We resort to qRules when calculating date differences such as the one in your example above. Of course, custom code could also be used.
Good luck!
-
Hi Hilary,
We can't change those fields to date data type because we are using this Muhimbi software (http://blog.muhimbi.com/2012/02/convert-infopath-to-ms-word-excel-xps.html) to convert the InfoPath forms to Word documents and they have an issue with date picker fields, I listed the reason below. I suppose I could make a text field ...
-
Hi Hilary,
How did you open the infopath form to view the xml like that? That's what I wanted to look at because I knew InfoPath was stubbornly putting an unwanted date format on that field even though I told it not to.
-
Hello Hilary--
I was hoping you can assist me with building this process.. I have 2 parts built: todays date and date initiated: I am at a loss for part 3, the retunr value: Total number of days (number format)
I think I may be having similar issues pertaining to 'date difference' requirements.
I'm trying to have a field ...
-
I can build this argument in excel: Column A = (C-B) 10 = (7/20/2012 - 7/10/2012)
Column A is: Number of days
Column B is: Date Initiated
Column C is: Todays Date
Can you please assist me with building this function in infopath
thank you
-
I'd suggest adding a validation rule:
Condition: ApproverValue > RequesterValue * 1.2
-
I created a form library on SharePoint 2007 using InfoPath 2007 with Full Trust option. The IP form is opening for all the users except one,
The following is the error message received
Error : The form template cannot be opened, because the system administrator has disabled opening form templates that require full trust.
Client ...
-
Hello Forum,
We are testing the RefreshSharePointListItems and SubmitToSharepointList.
It works great but I have one issue:
It seems the deletion of sharepoint list items only works when we put the RefreshSharePointListItems after the finishloading (when the form opens)
And not before the SubmitToSharepointList.
(We tested it also ...
-
Am thinking this is not good as they all display false. It has automatically pulled all the details through so Initials, Surname and Forename are there but the validation field states False. Not what I was hoping for but I think that's what you expected.
Does this help establish the problem?
Thanks