?
Solved

SharePoint How to retrive info via Infopath

Posted on 2010-11-23
9
Medium Priority
?
423 Views
Last Modified: 2012-05-10
I am looking to Populate a Field in My form via Sharepoint..  I want to be able to open my form once its been submmited and it populate the name field by the person that submitted it..

So i created this retrival  
Data Connectionthen i added it to submit as a rule.  
Data2the form is created fine but the name field stays blank..  Am i missing a step?
0
Comment
Question by:gotti777
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 34201519
In the last screen shot you want to select the Fx button for value.

There you want to add a field and slect that Modified by field in your secondary data connection.

Then select the filter button.  You would want to match the title or ID of retrieve ID's with modified by.

You probably could do this all with one query and just include multiple fields.

You need a filter or it will just give you the modified by of the first item in the list not the one with the specific ID.
0
 

Author Comment

by:gotti777
ID: 34201657
this is as far as i got.  Why wont this retrive the field for me?  
 d
I dont event get the frist modified by  
0
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 34201673
First i would drag the whole data connection onto your form and verify you are getting data from the query.

Then you can start to troubleshoot what is the issue.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:gotti777
ID: 34201944
Ok not sure what you mean by verify data from query, well i mean i not sure how to go about it.  
If i understand it right the form wont have a modified by until its created.  so not sure how i would test .. can you walk me thru it?
0
 
LVL 28

Expert Comment

by:clayfox
ID: 34202326
Ok, maybe I am understnding better.
Are you trying to identify the current user?

If so you have to submit the form to SP and see the data before you can query.
You still will want a filter so that you identify the correct form.

Make sure you submit a form or have data in sP.
Then create a view and use the data source pane and just drag the repeating groups onto the view.
InfoPath will ask you whether you want a repeating table or section, pick whichever works best for the data.
This way you will see exactly what the form is getting.  I do this always so I can debug.
Then query your data sources and verify the information.
Then you are ready to troubleshoot your formulas and rules once you cansee the data you are trying to match.
0
 

Author Comment

by:gotti777
ID: 34202432
I am still a little lost.  hard to understand.

When I submit form.. I have a data retrive connection that retrives the id and names it by that number +1000 works great...   but i cant see the number till after its submitted after open it up for editing then i see the number populated in the field

I asume it works the same way with the modified by .. but its blank..

I do submit form and i can see the name of Modified by in the view .  but if i open it theres nothing in my field
0
 
LVL 28

Expert Comment

by:clayfox
ID: 34215162
Try using created by instead.

Until it is edited modified by might not get populated.
0
 

Author Comment

by:gotti777
ID: 34232702
hmmm I tried both..

But if you tske a look at my list... I can see the modified by  but when i open the field is blank h
0
 

Author Comment

by:gotti777
ID: 34241114


I used this work perfect .. but thanks for trying


You want to a user file in your InfoPath form to auto populate with the current user who is logged on, follow these steps:

1) Create a new form by Designing a New Form Template

2)Choose blank form

3) Add a text box to the form (Field1)

4) Go to Tools | Form Options

5) Go to the Open Behavior section and click on Rules

6) Add Action to Set a Field’s Value

7) Choose the field you added above as the field to populate

8 ) For the value, click on the Fx button and choose Insert Function

9) View All in the Categories drop down

10) At the bottom you’ll see userName, pick it

11) The formula that gets dropped in is userName()

12) Preview the form, you’ll see your UserName in field1

0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question