-
I copied the logic in a date calcualtion routine i found on the net. I substittuded my datasource variables for the one in the sample and I keep getting the above error. I am doing it in vbscript.
Here is my code
Sub CalculateDateDifference()
Dim strStartDate
Dim strEndDate
Dim strDateInterval
Dim dtStart
Dim dtEnd
Dim ...
-
Hey Patrick.
You would just need to backtrack.
If you know the values then just use a filter to get the display field.
concat(txt1, "x", display[value=ddl1], "@", display[value=ddl2])
So you just need to reference your secondary SP lists and look up the display field value where the value fields = what was selected.
Hope ...
-
You need fields to be in the default view to be available but I do not beleive the choice fields are supported. They are kind of a hack and only work for SP.
You would need to use seperate fields to get the data to InfoPath.
-
Check out layout tables.
I think this is what you are looking for.
Also you should create a second view that will be the print view.
That way you can keep the form design for electonic input but also format the data to fit on the page. In view properties you can set the print view to be used when they print the electronic view.
-
Unfortunatley this is how secondary data connections are handled in InfoPath, all data is loaded and then filtered in the form.
I am surprised that the performance was tolerable even in the client.
But their is a solution.
You need a webservice which can query SQL and just return the record or set of records you want, and ...
-
That's what I'm looking for. How do I do that? Resetting my document datasource? (I'm on Infopath 2003 and need to do that in the .js file)
Thanks!
-
Yah there is no popup option in the browser.
What I have done for alerts and messaging like this is to create a hidden section and a message field.
When the field is set with text then it becomes visible and has some coloration to draw attention.
Not quite the same, but effective to place it adjacent to the submit buttons and to post validation ...
-
Sure, that would be best practice.
Create a submit data connection to your SP Library.
Set the file name as concat(first, "-", last) or what ever.
Then set your submit options or add a rule to a button to submit with this DC and close.
-
Hi Bill,
Thanks for contacting us. Your form is quite complex - you have many tables and multiple foreign key relationships. It is difficult to maintain the database mapping for such complex forms and that is a common problem that InfoPath users experience due to limitations in the DB data connection logic. We have developed our Qdabra Database ...
-
I was able to figure out how to delete these 'dangling' form templates. However, I am still not sure whey they are getting stuck in the never ending status. Anyways for those who is looking for a solution to the problem, read this:
Form template’s status never leaves “Upgrading…” or “Removing…” states
These states seem to indicate ...