Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 2 of 3 (26 items) < Previous 1 2 3 Next > Re: Formula for Separator in Text Box with Concatenated Fields The unchecked values do not have a space in them. Here's the formula: substring(eval(eval((AirTopicsHide1 | AuditDiscloseHide1 | BBEnvSeminarsHide1 | BankruptcyHide1)[. != ""], 'concat(", ", .)'), ".."), 3, 10000) Posted to General (Forum) by ncarson on 10-03-2010 Re: Formula for Separator in Text Box with Concatenated Fields After I began applying the formula to my real form, I've run into a problem that doesn't make sense. The same formula works just fine on one section of options, but applying it the exact same way on another section gives me different results. I've re-done it several times and even ... Posted to General (Forum) by ncarson on 10-03-2010 Re: Formula for Separator in Text Box with Concatenated Fields Yes! This works! Worked on a practice form and then on a form with more true to life (numerous) selections, so I am sure I can now apply it to the real form. Thank you very very much! Nalani Posted to General (Forum) by ncarson on 10-03-2010 Re: Formula for Separator in Text Box with Concatenated Fields Sorry, thought you wouldn't be able to open it either and it wouldn't do any good to forward. Attached is one of the practice forms with the formula in it. Thanks. Posted to General (Forum) by ncarson on 10-03-2010 Re: Formula for Separator in Text Box with Concatenated Fields You're right that the form I attached didn't have the separator formula in it - it only has the original concat formula that doesn't include separators between the items. I couldn't find a way to send the form with the separator formula because as soon as I save it, the form will not open again. When attempting to open ... Posted to General (Forum) by ncarson on 10-03-2010 Re: Formula for Separator in Text Box with Concatenated Fields I have attached a practice form that has a small section of my very large form which has many similar sections except that there are many more options available for the user to choose from than the number I've carved out for this practice form. When you check the box next to Environmental, some Submatter options will display and ... Posted to General (Forum) by ncarson on 10-02-2010 Re: Formula for Separator in Text Box with Concatenated Fields The form I was using to practice with and had saved with the formula won't open at all now (like it is a corrupted file). I recreated the practice form and saved it again (and hope this one will open after it's closed), but I don't see a way to browse my local files and attach it to this thread. I could ... Posted to General (Forum) by ncarson on 10-01-2010 Re: Formula for Separator in Text Box with Concatenated Fields I must have made a typo when I wrote the post because it isn't like that in the formula. I have removed it and rewritten it several times, even trying to use the Insert buttons in case InfoPath didn't like my own typed entries, and even though it continues to verify that the formula does not have any errors, each time I try to ... Posted to General (Forum) by ncarson on 10-01-2010 Re: Formula for Separator in Text Box with Concatenated Fields Thank you so much for your guidance. I have attempted this on a practice form before adding to my real form (just in case) and I cannot preview to test it because I get a message that "InfoPath cannot open the selected form" - before adding this formula it opened in Preview fine. Here's how my formula ... Posted to General (Forum) by ncarson on 10-01-2010 Re: Formula for Separator in Text Box with Concatenated Fields You are correct that Rules can handle this and I have done that in some of the sections. However, this has grown enormously and now there are other sections that require this same control setup but the conditions possibilities would probably hit 1,000 or more and so this work-around I've been doing for those smaller sections is just not ... Posted to General (Forum) by ncarson on 10-01-2010 Page 2 of 3 (26 items) < Previous 1 2 3 Next > Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.