Get data from a specific item in Sharepoint list

[Anna]

Hi,
I am very new to Sharepoint and Infopath...

my Sharepoint list has a column of type hyperlink. The link points to an
Infopath template. The idea is that when the link is clicked the Infopath
(2007) form is displayed (in browser). OK, this bit works. Now the problem: I
also need to be able to preload some data from the _selected_ list item into
some text boxes on the form. I created a secondary data connection based on
that list but it retrieves ALL the list items. Since I try to populate the
textboxes and not the dropdowns all my textboxes are getting values from the
first list item by default, irrespective of which item's hyperlink I selected
to click.
Is there ANY way to somehow get the data of only the selected (current?)
item? Also, is that possible to achieve this without any code writing? I
found it a bit difficult to publish and maintain forms with custom "code
behind".

Thank you in advance for your help.

 

[S.Y.M. Wong-A-Ton]

You can add a Rule (Tools > Form Options > Open and Save) that will run when
then the form is loaded or a rule on the drop-down list box (whichever is
best for your situation for pre-loading data). You can then add actions to
this rule to set each one of the text boxes based on the selection in the
drop-down. To get the values for the text boxes, you need to use a filter on
your secondary data source. You can use the same filtering technique as I
used in this article:
http://www.bizsupportonline.net/inf...g-table-data-sharepoint-list-row-inserted.htm

If you have difficulty applying the filtering technique in your situation,
let me know, and I'll extract the bits from the article that you need for
your situation and write a new article specifically to fill fields as in your
situation.

 

[mross01]

We have the same problem. We need to grab an ID from a row that is clicked
on. Right now we have not been able to figure out one, how to click on a row
and it go to an InfoPath form and second we don't know how to pull the data
from that specific row.

Anyone have any ideas?

Mross011

 

[Rodolfo Soares]

Hi guys

I am facing the same problem could anyone let me know how to do it.

Many thanks

rod



mross0 wrote:

We have the same problem. We need to grab an ID from a row that is clicked on.
25-Nov-08

We have the same problem. We need to grab an ID from a row that is clicked
on. Right now we have not been able to figure out one, how to click on a row
and it go to an InfoPath form and second we don't know how to pull the data
from that specific row

Anyone have any ideas

Mross01

:

Previous Posts In This Thread:

Get data from a specific item in Sharepoint list
Hi,
I am very new to Sharepoint and Infopath..

my Sharepoint list has a column of type hyperlink. The link points to an
Infopath template. The idea is that when the link is clicked the Infopath
(2007) form is displayed (in browser). OK, this bit works. Now the problem: I
also need to be able to preload some data from the _selected_ list item into
some text boxes on the form. I created a secondary data connection based on
that list but it retrieves ALL the list items. Since I try to populate the
textboxes and not the dropdowns all my textboxes are getting values from the
first list item by default, irrespective of which item's hyperlink I selected
to click.
Is there ANY way to somehow get the data of only the selected (current?)
item? Also, is that possible to achieve this without any code writing? I
found it a bit difficult to publish and maintain forms with custom "code
behind"

Thank you in advance for your help.

You can add a Rule (Tools > Form Options > Open and Save) that will run when
You can add a Rule (Tools > Form Options > Open and Save) that will run when
then the form is loaded or a rule on the drop-down list box (whichever is
best for your situation for pre-loading data). You can then add actions to
this rule to set each one of the text boxes based on the selection in the
drop-down. To get the values for the text boxes, you need to use a filter on
your secondary data source. You can use the same filtering technique as I
used in this article:
http://www.bizsupportonline.net/inf...ng-table-data-sharepoint-list-row-inserted.ht

If you have difficulty applying the filtering technique in your situation,
let me know, and I'll extract the bits from the article that you need for
your situation and write a new article specifically to fill fields as in your
situation
--
S.Y.M. Wong-A-To

:

We have the same problem. We need to grab an ID from a row that is clicked on.
We have the same problem. We need to grab an ID from a row that is clicked
on. Right now we have not been able to figure out one, how to click on a row
and it go to an InfoPath form and second we don't know how to pull the data
from that specific row

Anyone have any ideas

Mross01

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Full Name of current Thread Principal
http://www.eggheadcafe.com/tutorial...de-b06461d54654/get-full-name-of-current.aspx

 

[Alec Pojidaev]

Here article that shows how to do that
http://alecpojidaev.wordpress.com/2...in-repeating-group-for-browser-enabled-forms/

 

[bug menot]

thanks a lot! - your blog article helped me a lot!



SYMWongATo wrote:

You can add a Rule (Tools > Form Options > Open and Save) that will run when
13-Oct-08

You can add a Rule (Tools > Form Options > Open and Save) that will run when
then the form is loaded or a rule on the drop-down list box (whichever is
best for your situation for pre-loading data). You can then add actions to
this rule to set each one of the text boxes based on the selection in the
drop-down. To get the values for the text boxes, you need to use a filter on
your secondary data source. You can use the same filtering technique as I
used in this article:
http://www.bizsupportonline.net/inf...ng-table-data-sharepoint-list-row-inserted.ht

If you have difficulty applying the filtering technique in your situation,
let me know, and I'll extract the bits from the article that you need for
your situation and write a new article specifically to fill fields as in your
situation
--
S.Y.M. Wong-A-To

:

Previous Posts In This Thread:

Get data from a specific item in Sharepoint list
Hi,
I am very new to Sharepoint and Infopath..

my Sharepoint list has a column of type hyperlink. The link points to an
Infopath template. The idea is that when the link is clicked the Infopath
(2007) form is displayed (in browser). OK, this bit works. Now the problem: I
also need to be able to preload some data from the _selected_ list item into
some text boxes on the form. I created a secondary data connection based on
that list but it retrieves ALL the list items. Since I try to populate the
textboxes and not the dropdowns all my textboxes are getting values from the
first list item by default, irrespective of which item's hyperlink I selected
to click.
Is there ANY way to somehow get the data of only the selected (current?)
item? Also, is that possible to achieve this without any code writing? I
found it a bit difficult to publish and maintain forms with custom "code
behind"

Thank you in advance for your help.

You can add a Rule (Tools > Form Options > Open and Save) that will run when
You can add a Rule (Tools > Form Options > Open and Save) that will run when
then the form is loaded or a rule on the drop-down list box (whichever is
best for your situation for pre-loading data). You can then add actions to
this rule to set each one of the text boxes based on the selection in the
drop-down. To get the values for the text boxes, you need to use a filter on
your secondary data source. You can use the same filtering technique as I
used in this article:
http://www.bizsupportonline.net/inf...ng-table-data-sharepoint-list-row-inserted.ht

If you have difficulty applying the filtering technique in your situation,
let me know, and I'll extract the bits from the article that you need for
your situation and write a new article specifically to fill fields as in your
situation
--
S.Y.M. Wong-A-To

:

We have the same problem. We need to grab an ID from a row that is clicked on.
We have the same problem. We need to grab an ID from a row that is clicked
on. Right now we have not been able to figure out one, how to click on a row
and it go to an InfoPath form and second we don't know how to pull the data
from that specific row

Anyone have any ideas

Mross01

:

We need to grab an ID from a row that is clicked on
Hi guys

I am facing the same problem could anyone let me know how to do it.

Many thanks

rod


Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: C# 4.0 In a Nutshell [O'Reilly]
http://www.eggheadcafe.com/tutorial...-a2da-88dde2e6d891/book-review-c-40-in-a.aspx