General

Re: Filtering a repeating section

HelenW — Tue, 01 Oct 2013 13:02:25 GMT

Hi Hilary -

Thanks for your reply; I'm a little slow in responding since I got pulled into other stuff but have finally returned to this.

Unfortunately, this doesn't take into account that we need to restrict it by market... so if i have 4 dates for the US market and 6 for the UK market, I want to show the first three for each. That's what's stumping me. How do I restrict it so that it shows the first three for each market? I have 10 different markets....I suppose I could make 10 rules, one for each market?? Of course, if I add a new market to the form, then I will need to remember to update this rule, which is less than ideal.

If you have any ideas of a more elegant solution, I'd be so grateful.

Thanks again!

Re: Filtering a repeating section

Hilary Stoupa — Wed, 18 Sep 2013 14:49:07 GMT

I'd think that this might work:

count(preceding-sibling::my:gpRepeating) > 2

As a condition for your formatting - I'd add an expression box inside the gpRepeating section and use the formula editor to get the syntax right for this: count(preceding-sibling::my:gpRepeating)

Then for your condition, change the first box to "The expression" and put in the expression when you know you have it right.

Filtering a repeating section

HelenW — Tue, 17 Sep 2013 15:16:44 GMT

Hi,

I have a nested repeating section - my schema looks like this:

myFields

gpBrands
gpBrandDetails (repeating)
gpContainer
gpRepeating (repeating)
Milestone
msMarket
msBrand
rowNum

I want one of my form views to only show the first three milestones for each Market while the entire list appears on another page. When I'm working with a single market, it is no problem, but when I merge my forms and have multiple markets under a single brand, I cannot figure out how to filter so it just shows the first three for each market.

Right now, when I'm in a single market form, I tell it if rowNum > 3, hide the section. Once I merge the forms, I may have up to 10 countries, each with three or more milestones. I want to be able to show the first three milestones per country

Somehow I think I should be able to use a count function or something, but I'm at a loss.

Any ideas?

Thanks,

Helen