Solved

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

Posted on 2013-11-03
3
789 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
[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
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 125 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

739 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