Newbie Questions

Re: Expression Box Help

JRodimus — Sat, 05 Sep 2009 15:49:29 GMT

Thanks Jimmy, that worked perfectly.

Re: Expression Box Help

Jimmy — Fri, 04 Sep 2009 23:15:05 GMT

The simplest thing to do would be to use conditional formatting hide the expression box if the fields are blank, or if they're not always blank at the same time, split it into three expression boxes: [field1][, ][field2] and hide the middle one when field1 or field2 is blank.

Similarly, the easiest thing for your second scenario would be to have five expression boxes side-by-side: [morning][, ][afternoon][, ][evening], and show or hide them appropriately based on the state of the checkboxes.

Re: Expression Box Help

JRodimus — Fri, 04 Sep 2009 20:52:07 GMT

So I thought I had this all figured out, but then I notice that a comma is inserted even if nothing is listed in one of these fields. So I get (field 1, ) or ( ,field 2). Any idea how to make the comma dependent on having content listed?

Also, can you use the concat function with a check box? Meaning if I have 3 check boxes that say morning, afternoon and evening.. and 2 are checked, InfoPath automatically fills a text box that reads morning, evening

Re: Expression Box Help

JRodimus — Fri, 04 Sep 2009 14:43:35 GMT

Perfect, thanks guys!!

Re: Expression Box Help

Qazi Anis — Fri, 04 Sep 2009 06:36:43 GMT

you can just use go to the field in which you want the value and set its value to concat(field1,",",field2), that will be easier than using expression box, you will also have to check the box that say "Update this value when the value of the formula is recalculated.

Re: Expression Box Help

princevis — Fri, 04 Sep 2009 06:26:52 GMT

do this concat(field 1,",",field2)

Re: Expression Box Help

JRodimus — Fri, 04 Sep 2009 06:19:58 GMT

Oh wow, thanks! I thought I needed to use the expression box... I guess that explains why I kept getting errors.

Btw, do you know how to automatically add a comma and space in between these entries? When I do concast(field 1, field2) it comes out as field 1field2.

Sorry if this is a stupid question:(

Re: Expression Box Help

princevis — Fri, 04 Sep 2009 05:21:04 GMT

Why u want to do that using expression box,when u can do that easily using Concat function in string. Is there any specific purpose for doing that using expression box..

Expression Box Help

JRodimus — Fri, 04 Sep 2009 04:55:52 GMT

Hi All,

I was wondering if there was anyway to use an expression box to automatically combine the content of two text boxes.

For example, I have one box for first name and another for last name. Can I get an expression box (or something else) to automatically join this content for another section of the form? Also, can I get it to automatically insert a comma in between these?

Sorry if this has been posted elsewhere... I have done several searches but haven't had any luck tracking this down. Thanks for any help!