Qdabra qRules

Re: Repeating Tables and Look-Up Fields

Hilary Stoupa — Fri, 01 May 2015 16:37:25 GMT

Good job!

Re: Repeating Tables and Look-Up Fields

klink — Fri, 01 May 2015 16:17:20 GMT

AWESOME! I got it to work!

Re: Repeating Tables and Look-Up Fields

Hilary Stoupa — Fri, 01 May 2015 15:13:59 GMT

You can use conditional formatting that hides something if a preceding-sibling has the same value - Here are preceding-sibling samples: http://www.infopathdev.com/files/folders/examples/tags/preceding-sibling/default.aspx

Re: Repeating Tables and Look-Up Fields

klink — Fri, 01 May 2015 15:08:23 GMT

How about this?

I can get the information in the columns the way I want using the first scenario I gave you. What I don't like is showing the same Goal twice.

Is there a way to have the Goal field show "blank" if the item above has the same goal?

Re: Repeating Tables and Look-Up Fields

klink — Fri, 01 May 2015 15:03:00 GMT

Well, fudge. Looks like it might be time to schedule my free hour of qRules support! =)

Re: Repeating Tables and Look-Up Fields

Hilary Stoupa — Fri, 01 May 2015 14:57:41 GMT

They will not magically tie together nicely.

If you need to see all the List 2 details for each List 1 item at the same time, I think you'll have to create another 2ds using an XML file with the structure you need, then use qRules and a transform to populate it - you could probably also do something with other qRules commands, like Insert and maybe CopyTable - but it will likely take some experimentation.

Re: Repeating Tables and Look-Up Fields

klink — Fri, 01 May 2015 14:46:44 GMT

Okay, I swear I tried what you said in #1 and it didn't work, but I redid it today and wa-la, it did!

As for Item 2, this is for a report and the user wants to see everything, and be able to print it. =( Some more details:

List 1: This is a list of "Goals."

List 2: This is a list of "Objectives" that tie to a "Goal."

And, to make this even more difficult...

List 3: This is a list of "Departments" that tie to an "Objective."

Report Columns:

Goal
Objectives
Departments

There are more columns that are part of the "Objectives" list.

Maybe I'm thinking through this wrong. I just want them to magically tie together nicely. =) Any suggestions on alternatives?

THANKS!

Re: Repeating Tables and Look-Up Fields

Hilary Stoupa — Fri, 01 May 2015 14:20:09 GMT

Item 1 is pretty easy - just use a calculated value in the column where the lookup value should go, and select the field in list one where the id matches the value of the id in list 2.

Item 2 is pretty hard. Usually what I do is add a section that I can "show / hide" and then when the user "shows" the section, I query list 2 for just the items related to the item I'm currently showing. I may have time later today to put together a sample of this using XML data sources if that would be helpful?

Re: Repeating Tables and Look-Up Fields

klink — Fri, 01 May 2015 13:22:31 GMT

Anyone?

Repeating Tables and Look-Up Fields

klink — Wed, 29 Apr 2015 20:51:52 GMT

InfoPath 2010
SharePoint 2010 Lists
No qRules yet, but will have

Scenario:

Two Lists, where List 2 has a lookup field from List 1.

What I WANT to do, but can't figure out:

Repeating table of List 2 that will show the value of the lookup from List 1 in a field instead of the ID.
Repeating table of List 2 inside a repeating table of List 1, where it will show an entry of List 1 and then the entries from List 2 that tie (by the lookup) to List 1.

Clear as mud? I figure I might need to use some XPathy thing, but I can't for the life of me figure it out! =/

Any help would be GREATLY appreciated!