-
Thank you so much for your prompt reply and kind help. I will try to ask.
-
You may want to ask your SharePoint admin for help, see if there is anything in the logs that is of use.
-
Thanks much ... I tried to set postback to always and it works fine until testing and submitting about 3 forms and hung again then.
Sorry, it is not ok to attach the form cause of including the company data.
-
This would be another formatting rule on the table. The condition would have the Associate Full Name in the first drop down, is equal to in the second drop down. For the third, select Use a formula - and the formula is probably something like this:
preceding-sibling::d:SharePointListItem_RW/d:Associate_x0020_Full_x0020_Name
-
I noticed when I put translate for the Associate Full Name field into a separate formula and clicked Edit xPath, there was a "d:" missing - so I entered that and it works now. I'll create a separate rule to hide the results when empty.
Now...ideas on how to eliminate duplicate entries? :o)
-
You'll see the same in the sample form I provided you - I was showing everything by default. You could simply put the repeating table in a section, and hide the section if TB_SearchCriteria is blank.
I'm guessing that Associate_x0020_Full_x0020_Name probably has a namespace prefix that you are missing. In the Fields task ...
-
Here are the xPaths for my 2 fields:
/my:myFields/my:Sect_LegalHolds/my:Sect_NameSearch/my:TB_SearchCriteria
/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Associate_x0020_Full_x0020_Name
I took your translate ...
-
Ah! Awesome, I've never seen that option before. Thanks! I'll look into it more, but this looks like what I'm looking for.
-
Yeah, so in your formula where you selected Answer1, you should be able to click Filter Data and add the same filter you are using in your formatting. If you have trouble, you can attach your form under a reply in the Options tab & I'll try to give you a hand.
-
Is there a way to do that in the value formula? I have the data filtered using a formatting rule "[Date From] [Date]" and the [Average Field] formula is just "avg(Answer1)". Can a filter condition be added to the formula like... avg(Answer1,where([Date From] [Date]))?
(I also just realized that my formatting for my ...