Concatenating 'not blank' notes fields into a tidy final text box - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Concatenating 'not blank' notes fields into a tidy final text box

Last post 02-06-2015 11:30 AM by donstephen. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-27-2015 07:02 AM

    • BlakeT
    • Not Ranked
      Male
    • Joined on 01-08-2015
    • UK
    • Posts 10

    Concatenating 'not blank' notes fields into a tidy final text box

    Hi all,

    I'm pretty new to InfoPath 2010 and am struggling to concatenate all my 'not blank' text fields into one tidy, readable format.

    I've soted the line break, but I don't want my formula to add the line break when a field is empty.

    I'd quite like them to be presented one line per populated text box.

    i.e.

    text 1

    text 2

    text 3

    etc

    Is this possible?

     

    Thanks

     

    Blake Tague
    Senior Developer
  • 02-06-2015 11:30 AM In reply to

    Re: Concatenating 'not blank' notes fields into a tidy final text box

    Hi Blake,

    I'm not sure how your form is set up so I am unable to provide with a formula (not sure if you are concatenating multiple fields or fields from a repeating table). If you are using multiple fields, I would suggest using a substring logic which only returns data if the field is not blank (field1 != ''). For repeating data, you will need to use a double eval technique and use the same filter where the field is not blank. I hope this makes sense.

    Regards,

    Don Stephen Lambatin / Support Engineer
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.