Double eval erroring out - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Double eval erroring out

Last post 08-19-2013 06:19 AM by RegolithDev. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 08-13-2013 08:52 AM

    Double eval erroring out

    Reply Contact
    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
    1. 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 select    Results
    Form 1
    Form 20
    Form 23    My 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?

     

  • 08-18-2013 05:35 PM In reply to

    Re: Double eval erroring out

    Mark as Not Answer
    Reply Contact

    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.

    Patrick Halstead
    Project Manager at Qdabra

  • 08-19-2013 06:19 AM In reply to

    Re: Double eval erroring out

    Mark as Answer
    Reply Contact

    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
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.