?
Solved

Infopath Form, push and Pull list data based on Acc.ID ?

Posted on 2013-11-03
3
Medium Priority
?
818 Views
Last Modified: 2014-01-20
Hi,
Q-1 :From a Infopath Form,
how can I add items(text data) into a list and associate with Account ID of Employee present on the form.
Q-2:On the same form,
how can I display data of same account (whether employee or manager opens, shows employee data only )
 
I am nearby, but when manager opens form,his data is displayed not employees.
Rgds/-
0
Comment
Question by:sharepointDepot
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Clay Fox earned 250 total points
ID: 39621334
For Q1, typically nothing since SharePoint saves the created by field. When IP queries a list it always returns the default list view, so you probably need to customize the default view and add the fields you need.

For Q2, the submitter would need to select the manager or you could use the get user web service in SP and access the AD information. Then save the full name, not the account name in a field in the list. That way your records have both.
You will need another view for managers which only shows records where they are listed as the manager.

you will need some rules on load of the form
when a user opens a blank form you would treat it like a new submission from an employee. If a user opens an existing record, then check if they are listed in the created by, if yes it is a edit, if no then they are the manager.
I always have a status field as well to track the stage and use that to determine logic in the form, which view, what to hide, what to validate, etc.
0
 

Author Comment

by:sharepointDepot
ID: 39660020
Hi,
For Q1, regarding view , let say...there is filter  [Me]  is applied on some field.
Now, the real problem is that, If manager(other than employee) opens the form, he sees all data filtered be [Me],
means,  he is going to see his own data values, not employees data.
i.e.; I don't want [Me] data for Manager1,Manager2, etc .
I want  all of these users Manager1,Manager2,Manager3, everybody should see only employees's data values, not their own data.
Pls suggest.
0
 

Author Comment

by:sharepointDepot
ID: 39796187
Hi,
I was looking for query data for initiator of form, i was able to show this particulat users data on forms previously also.
Now, I used set Field value in the Query part-and this I used for my all Form Load queries.

So at all views,I am able to show the initiators data.
Rgds/-
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

621 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