Re: Double eval erroring out

RegolithDev — Mon, 19 Aug 2013 13:19:34 GMT

Thanks Patrick,

That did the trick, I also noted that it did not like having the full address in the inner concat. I had to drop it down to just the object name. Also thanks for your fast response.

Chris
Regolith Inc.
www.regolithinc.com

Re: Double eval erroring out

Patrick Halstead — Mon, 19 Aug 2013 00:35:17 GMT

We see this a lot. You can't use the field picker for the Checkbox in the inner concat. You have to use an xpath to it. Check the show xpath details box in the Fx lower right hand corner. Now, insert the Checkbox somewhere and copy it's xpath into the inner concat as just text. Don't resolve it. That's the issue.

Double eval erroring out

RegolithDev — Tue, 13 Aug 2013 15:52:49 GMT

Hello all,I'm having trouble implementing a double eval function for a repeating section. In essence, what I'm trying to do is to combine all checkbox values from a repeating section into a single field for search purposes. This will probably be a long post as the requirement is a little complex, so I apologize up front if I get a little wordy. below is my form layout, but I cannot give field names due to the nature of my customer, again I apologize but will try to describe the situation so there is a chance someone might be able to help. Form structure

Main DS

a. Container Group checkbox rollup (text)b. Container group 1 i. Repeating section checkbox rollup field (text) ii. Repeating section 1st1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text) iii. Repeating section 2nd1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text) iv. Repeating section 3rd1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text)c. Container group 2 i. Repeating section checkbox rollup field (text) ii. Repeating section 1st1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text) iii. Repeating section 2nd1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text) iv. Repeating section 3rd1. Checkbox field 1 (Checkbox)2. Checkbox field 2 (Checkbox)3. Checkbox field 3 (Checkbox)4. Checkbox concat field (text)My current plan is to first take all values from checkboxes within their repeating section and concatenate the results into a single field (4.Checkbox concat field). Then using the double eval function roll the concat fields up to a single field within its respective container group (Repeating section checkbox rollup field). Finally I will concatenate the repeating section checkbox rollup fields into a single field for the whole form (Container group checkbox rollup).I know it sounds a little redundant on the form, but I don’t know of any other way to pull all the checkbox results out of the repeating sections any other way in a format that will make searching them possible once they are dumped into a SharePoint column. The end goal is to create a form view that will be used to search for all forms that have specific values that relate to the checkboxes that are selected, then provide a list of the results on a page for selection. Something like below:Search
Checkbox 1 select
Checkbox 2 select
Checkbox 3 selectResults
Form 1
Form 20
Form 23My current eval looks like this:eval(eval(Repeating Section group, 'concat(Checkbox concat[Checkbox concat != ""],"; ")'), "..")But IP keeps throwing errors stating I am not pointing to a valid location, even though I set the location via inserting field. Can anyone help iron out this issue?Also for extra credit anyone know how to remove the duplicate values from the finished product?

Code

Re: Double eval erroring out

Re: Double eval erroring out

Double eval erroring out