I
Ingrid
I want to make a query in Infopath used by a specific user. The query shall
show which forms in difference form library on Sharepoint he is assigned to.
The results must be shown in a repeating table or repeating sections. I only
get one line = one form information – how can I get all the other forms? I
have tried to get this using the current() function, it don’t work.
What is wrong?
I hope somebody can help me.
Examples on data in my form libraries:
Fields in forms: assigned to = employee username ex. LBA
Status = planned or started or closed
Number
These forms are in different form libraries on Sharepoint Portal Server
example: Projects, Complaint etc.
My query form includes:
1. A drop down list, where the employee must choose his username
(employee_search)
2. A bottom to click for getting data from the libraries.
3. A repeating table for each form library, where I want to show information
from each form the user are assigned to for example: the status field and the
form number.
At the bottom I have make a rule:
1. Data connection – receive data from a specific form library
2. Place value in a field in my repeating table with filter:
a. Field where I want the value placed = status
b. In the value section I have selected the status field in the secondary
data and placed a filter on this field
c. The filter are set:
i. field from the secondary data employee_assigned are equal with the field
employee_search in my primary data and
ii. field from the secondary data status are equal with “planned†or
iii. field from the secondary data status are equal with “started†and
iv. field from the secondary data employee_assigned are equal with a formula
current()/my:employee_search
show which forms in difference form library on Sharepoint he is assigned to.
The results must be shown in a repeating table or repeating sections. I only
get one line = one form information – how can I get all the other forms? I
have tried to get this using the current() function, it don’t work.
What is wrong?
I hope somebody can help me.
Examples on data in my form libraries:
Fields in forms: assigned to = employee username ex. LBA
Status = planned or started or closed
Number
These forms are in different form libraries on Sharepoint Portal Server
example: Projects, Complaint etc.
My query form includes:
1. A drop down list, where the employee must choose his username
(employee_search)
2. A bottom to click for getting data from the libraries.
3. A repeating table for each form library, where I want to show information
from each form the user are assigned to for example: the status field and the
form number.
At the bottom I have make a rule:
1. Data connection – receive data from a specific form library
2. Place value in a field in my repeating table with filter:
a. Field where I want the value placed = status
b. In the value section I have selected the status field in the secondary
data and placed a filter on this field
c. The filter are set:
i. field from the secondary data employee_assigned are equal with the field
employee_search in my primary data and
ii. field from the secondary data status are equal with “planned†or
iii. field from the secondary data status are equal with “started†and
iv. field from the secondary data employee_assigned are equal with a formula
current()/my:employee_search