Solved

SharePoint How to retrive info via Infopath

Posted on 2010-11-23
9
415 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
  • 5
  • 4
9 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
 

Author Comment

by:gotti777
Comment Utility
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 28

Expert Comment

by:clayfox
Comment Utility
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
Comment Utility
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
Comment Utility
Try using created by instead.

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

Author Comment

by:gotti777
Comment Utility
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
Comment Utility


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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

743 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now