Newbie Questions

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Tue, 24 Jan 2012 00:46:09 GMT

count(xdXDocument:GetDOM("CIS Modernization Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:WO_x0020_Actual[../d:Project_x0020_Name = current()/d:Project_x0020_Name2]) >= 0

Re: A repeating table that shows data from 2 other repeating tables

infopain — Mon, 23 Jan 2012 20:14:58 GMT

I have a calculated value field and this is it's xpath:

xdXDocument:GetDOM("My Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:WO_x0020_Actual[../d:Project_x0020_Name = current()/d:Project_x0020_Name2]

It is formatted as a Whole Number.

I would like to hide another calculated value field (just concat text field) based on whether or not this field has data in it. I create a new format rule and select Expression in the expression field I have basically the same xpath as above but I need to add something to the end of it to make it be true if that field has data in it.

xdXDocument:GetDOM("My Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:WO_x0020_Actual[../d:Project_x0020_Name = current()/d:Project_x0020_Name2] >= 0

Re: A repeating table that shows data from 2 other repeating tables

infopain — Mon, 23 Jan 2012 20:08:40 GMT

Yes but I can't save it in those formats without losing alot of form functionality.

Re: A repeating table that shows data from 2 other repeating tables

Jo-Anne Alfafara — Mon, 23 Jan 2012 14:42:29 GMT

InfoPath 2010 allows you to save the form template as InfoPath 2007 Web Browser Form Template or InfoPath 2007 Filler Form Template. Have you tried that yet?

Re: A repeating table that shows data from 2 other repeating tables

infopain — Mon, 23 Jan 2012 14:13:49 GMT

Is there anyway to get a 2010 infopath form to run on 2007?

Thanks

Re: A repeating table that shows data from 2 other repeating tables

infopain — Fri, 20 Jan 2012 14:12:50 GMT

Kind of figured out another way around item 2. Thanks for all your help!!!!

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Thu, 19 Jan 2012 16:19:46 GMT

I'd use two expression boxes (calculated values IP 2010) for item 1. One has text saying Yes. The other has text saying No. You can use your XPath above to conditionally format them - hide if the Yes box if the field = false, the No box if the field = true.

Can you add a screenshot of item 2?

Re: A repeating table that shows data from 2 other repeating tables

infopain — Thu, 19 Jan 2012 14:45:57 GMT

1. Do you know how I can make this checkbox value display as Yes, No instead of True, False on my form??? Here is the xpath.

xdXDocument:GetDOM("Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:SCE_x0026_G[../d:Project_x0020_Name = current()/d:Project_x0020_Name2]

2. Do you know how I can make a Person/Group Picker that allows multiple selections display correctly on my form??? Currently if more than one person it shows display name, ID, email address all jumbled, I only wish to see display name.

xdXDocument:GetDOM("Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Project_x0020_Manager/pc:Person/pc:DisplayName[../../../d:Project_x0020_Name = current()/d:Project_x0020_Name2]

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Tue, 17 Jan 2012 19:00:49 GMT

I can't preview to check what I'm doing, of course, but in the print view of the attached, you'll find a repeating section bound to the status list. It has calculated values in it. The first row of calculated values come from the Project list and are filtered based on Project Name. Hopefully that is the field across the two lists that matches. If not, you'll need to change the filters on the field selections in the formula editor.

Re: A repeating table that shows data from 2 other repeating tables

infopain — Tue, 17 Jan 2012 18:43:14 GMT

Yes the issue is with the print view. I need to show project data AND status data on the print view. I want the user to be able to pick selection criteria on view 1 and then see it on the print view.

Ignore the preview area I need to delete that.

My problem is that I can't get the print view to display project data AND status data TOGETHER at the same time using the selection criteria. I can't get a project data row to equal a project status row. For example it shows Project XYZ's project data but with Project ABC's status information. I need Project XYZ data and status to display on the same row.

Please help!!!

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Tue, 17 Jan 2012 18:08:43 GMT

So, the user fills out the fields in the "Report Selection Criteria" area, and it looks like you already have rules to only return Project Status info based on those - I'm guessing that the Preview Area does what you want? It has only fields from the Status data source - was there info you want from the Project data source there?

I'm guessing that the issue is with the print view? You'd like to see the Project data with the status? Right now it would show all projects, then all statuses, instead of showing them together?

Re: A repeating table that shows data from 2 other repeating tables

infopain — Tue, 17 Jan 2012 13:53:43 GMT

Here is the xsn file. if you could show me how to link the two data sources by implementing it in a few examples and reposting it, I would be in debt to you!!!

View 1 is where I want the user to select what projects to display (filters) and then Print view is the view of the user's selection so they can print and save.

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Sat, 14 Jan 2012 00:21:46 GMT

I know I keep asking the same thing - but what is your repeating section bound to? Projects? Or Project Status? If Projects, you'll need to use expression boxes (calculated values in IP 2010) to display the item you want from the project status data source. Do feel free to attach a copy of your template to the Options tab and I can try to help you with it.

Re: A repeating table that shows data from 2 other repeating tables

infopain — Fri, 13 Jan 2012 14:20:10 GMT

Getting closer. Here's where I am now. 2 questions. I can't get the project status information to be synch'ed with the project information. 1) How can I do this? I think it is by filtering project name from project information data source1 equals project name from project status data source2. 2) Also do I have the data source 2 fields correctly added to the repeating table layout?

Re: A repeating table that shows data from 2 other repeating tables

Hilary Stoupa — Thu, 12 Jan 2012 19:33:54 GMT

In general - you fill out a query field then re-execute the query to return only the data that meets the criteria. Have you tried that?