Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2008

Tip: Looking for answers? Try searching our database.

dynamically retrieved data and show in InfoPath 2007 web form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
zullu - 16 Jan 2008 19:33 GMT
Hi,
Recently I was jammed with my InfoPath 2007 web based form and thought it
would be a good idea to share my problems here to get any help.
Can anyone help me how to retrieve data from a sharepoint list and displayed
them into different controls (like the textboxes, repeating tables, etc)  
based on a dropdown selection.

There should be some easy way to just retrieve the data and assign it to the
form's data source.

I am in the hunt for it currently but unable to figure out.

Thanks for any help.
Zullu
Clay Fox - 17 Jan 2008 02:39 GMT
You can have multiple controls bound to the same data.

So you could display the data in several different sections or views or
layouts and then use conditional formatting to hide and reveal what you want
by a dropdown menu.
Since this is a web form separate views would be the best options. By the
dropdown you could switch to views with the desired layout.
Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> Hi,
> Recently I was jammed with my InfoPath 2007 web based form and thought it
[quoted text clipped - 10 lines]
> Thanks for any help.
> Zullu
zullu - 17 Jan 2008 19:23 GMT
Thanks for your reply Clay.
I understand when you say about views, sections, conditional formatting, etc.
The point which I am trying to convey is how do I pull a particular row of
data from sharepoint list and then attach them to different controls on my
form.

I'll explain :
-I have a SharePoint Form Library, "Policies".
-I have a InfoPath form with 3 views (v1, v2 and v3).
-On v1, I have 2 option button: "New" and "Existing". New takes the process
to fillout and submit the form. This works fine.
-On v2 and v3, I have all the other controls in different sections.
-"Existing" displays a dropdownwhich is attached to "FormID" column in
"Policies" Form Library and displays all the FormIDs.
-Now, First when I open the InfoPath form all controls are blank except few
which are prepoluated from AD (Name, Phone,etc.)
-Now I select "Existing" option and then a "FormID" from the dropdown.
-Now here is the my question?????
-At this step, I need to fetch the data from SharePoint for the FormID which
I selected in the dropdown. How do I do this?
-Then after fetching the data, how do I display them on the controls in my
form.

just tooo long, I know. But hope it makes sense now.
Any idea how to achieve this. I would accept any suggestions!!!
I am fiddling around with some C# coding but no success.
Thanks,
Zullu.

> You can have multiple controls bound to the same data.
>
[quoted text clipped - 18 lines]
> > Thanks for any help.
> > Zullu
Clay Fox - 17 Jan 2008 19:39 GMT
You just go to tools and then data connections.

In the wizard select receive and SharePoint.

Put in the url to the site with the list and it will display the available
lists and you can select it.
You need to make sure the data you want is in the view in SharePoint.

The form then will load all of the list into your form on load or when you
query it. Then you can use filters to display the data you want in whatever
controls are bound to it.
Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> Thanks for your reply Clay.
> I understand when you say about views, sections, conditional formatting, etc.
[quoted text clipped - 47 lines]
> > > Thanks for any help.
> > > Zullu
zullu - 17 Jan 2008 21:00 GMT
That creates a Secondary Data Source, You are right.
But HOW do I refresh data on each selection changes made in the drop down.
I can see you have said something about query/filters.
Not sure about that.
Can you please elaborate more on that.

I guess, you are trying to say that this functionality can be achieved
without writing any code.
Oh great, if that is possible. I 'll love to go your way.
Thanks again.
Zullu

> You just go to tools and then data connections.
>
[quoted text clipped - 59 lines]
> > > > Thanks for any help.
> > > > Zullu
zullu - 17 Jan 2008 22:16 GMT
Clay !!!
You are my hero!!! Oh Jesus, that was just amazing.
I gave a hit and trial to what you sugessted with those filters and it
works like a charm. :-)
Thank you soooooo much.
Now please don't get hard pressed with my yet another request :-)
I was wondering how do will I do this with the repeating tables.
Do you have a say on that.
I am going to try tonight the same logic in repeating tables too.
Wonder if they too work the same way as the text boxes, as they have
multiple rows
of data.
Not sure....but will give it a shot.
Meanwhile if you have any other solution.....I am desperate to look forward
to that.
Thanks a ton for replies.
Zullu.

> That creates a Secondary Data Source, You are right.
> But HOW do I refresh data on each selection changes made in the drop down.
[quoted text clipped - 71 lines]
> > > > > Thanks for any help.
> > > > > Zullu
zullu - 18 Jan 2008 20:01 GMT
Clay,
I need your expertise !!!
I tried the same logic with the repeating tables but my form has started
giving errors
while loading in the browser.
Also, I could not find the "Default Value" section, where I had placed my
Formulae with the filters, in the Dropdowns and checkboxes.
Is there a different approach to set filters for these controls.
Anticipating your reply soon.
Thanks,
Zullu

> Clay !!!
> You are my hero!!! Oh Jesus, that was just amazing.
[quoted text clipped - 89 lines]
> > > > > > Thanks for any help.
> > > > > > Zullu
zullu - 18 Jan 2008 22:02 GMT
I managed to get the display in the repeating tables.
I guess, I had messed up with my data sources. Had to recreate them again.
And the form is displaying.
But the problem is, the repeating table displays just the first row.
And I have saved 4 rows in it.

Is there a way out to get all the rows in the repeating table.
My earlier question remains the same:
That is, I could not find the "Default Value" section, where I had placed my
Formulae with the filters, in the Dropdowns and checkboxes.
Is there a different approach to set filters for these controls.
Anticipating your reply soon.
Thanks,
Zullu

> Clay,
> I need your expertise !!!
[quoted text clipped - 101 lines]
> > > > > > > Thanks for any help.
> > > > > > > Zullu
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.