L
Lee Vance
Hi,
I've actually got a couple of questions here that kind of don't relate to
one another, but because much of the background information is the same I'm
putting them in the same posting.
First Issue: Unique Form ID
I've seen this posting before, but the replies didn't seem to answer the
question as far as I could tell. We have an InfoPath 2003 form that stores
all the data in the form itself. We don't want to change the main datasource
to store in a database for this form due to the nature of the volume of
information.
I've pulled in a bunch of secondary datasources that do pull from a SQL
table. I've also changed a lot of rules and field names, etc. The biggest
change I've made to the form is publishing to a SharePoint forms library and
having it submit to the SharePoint forms library rather than passing it
around in e-mails.
The main issue we are having is that when someone goes to fill out this form
that has filled out the other form they get the message about replacing the
local form template on their machine. This is going to confuse a lot of
people that go to fill out this form. I do not want to create this form from
scratch because of the amount of work that would have to go into it. Is
there an easy way to change this form ID so that people will not see that
message?
Second Issue: Data Queries
Because I have so many secondary datasources that pull in external data from
multiple SQL tables, I opted to create query rules based on different events
rather than refreshing the data when the form is opened because it was taking
way too long to open the form, and I didn't want the users to think there is
something wrong.
With publishing the data to the SharePoint forms library, I'm experiencing
an issue when an existing form is opened from the forms library, the
dropdowns and such are no longer populated because the events that query
those datasources aren't firing. Is my only option to go back and have all
these datasources query everytime the form is opened?
I would guess that creating web services would be the optimal way of loading
the data, but the problem is that I don't have direct access to the web
server. So I can't create web services without going through IT, and they
don't have time to work on this.
Thanks, Lee
I've actually got a couple of questions here that kind of don't relate to
one another, but because much of the background information is the same I'm
putting them in the same posting.
First Issue: Unique Form ID
I've seen this posting before, but the replies didn't seem to answer the
question as far as I could tell. We have an InfoPath 2003 form that stores
all the data in the form itself. We don't want to change the main datasource
to store in a database for this form due to the nature of the volume of
information.
I've pulled in a bunch of secondary datasources that do pull from a SQL
table. I've also changed a lot of rules and field names, etc. The biggest
change I've made to the form is publishing to a SharePoint forms library and
having it submit to the SharePoint forms library rather than passing it
around in e-mails.
The main issue we are having is that when someone goes to fill out this form
that has filled out the other form they get the message about replacing the
local form template on their machine. This is going to confuse a lot of
people that go to fill out this form. I do not want to create this form from
scratch because of the amount of work that would have to go into it. Is
there an easy way to change this form ID so that people will not see that
message?
Second Issue: Data Queries
Because I have so many secondary datasources that pull in external data from
multiple SQL tables, I opted to create query rules based on different events
rather than refreshing the data when the form is opened because it was taking
way too long to open the form, and I didn't want the users to think there is
something wrong.
With publishing the data to the SharePoint forms library, I'm experiencing
an issue when an existing form is opened from the forms library, the
dropdowns and such are no longer populated because the events that query
those datasources aren't firing. Is my only option to go back and have all
these datasources query everytime the form is opened?
I would guess that creating web services would be the optimal way of loading
the data, but the problem is that I don't have direct access to the web
server. So I can't create web services without going through IT, and they
don't have time to work on this.
Thanks, Lee