General

Re: Repeating table question

jkrdoom — Tue, 07 Feb 2006 17:02:29 GMT

Struck by the dreaded extra comma again!!!

Thanks,
Matt

Re: Repeating table question

Matt Faus — Tue, 07 Feb 2006 16:46:16 GMT

You should be able to to just two fields:

concat( field1, field2 )

Maybe you forgot to delete the last comma when you deleted the third field. If the above doesn't work, just make the third field and empty string:

concat( field1, field2, "" )

However, the cool thing about concat is that it accepts (I think) an unlimited number of arguments, so the following will even work:

concat( "1", "2", "3", field75, field80, " Quote of the day", "etc.", "etc." )

Please don't get any brain on the carpet. :)

---------------
Matt Faus
InfoPath Dev Texas

Re: Repeating table question

jkrdoom — Tue, 07 Feb 2006 16:40:17 GMT

Matt,

I tried that and it gives me the option of inputing 3 fields when I just need two. here's what it looks like (concat(double click to insert field, double click to insert field, double click to insert field)

If I just insert two fields it prompts me to enter a third field. If I delete the third "enter field" I get a formula error.

I think my brain is leaking out of my ear!!!

Thanks
Jay

Re: Repeating table question

Matt Faus — Tue, 07 Feb 2006 16:26:10 GMT

To show text from two fields in one, use the concat() function on the one field.

1. Double-click field3
2. Click the function button in the Default Value section
3. Click Insert Function
4. Find the concat function, select, and click OK.
5. double-click to add field1 and field2 appropriately.
6. Click OK.

Good luck!

---------------
Matt Faus
InfoPath Dev Texas

Re: Repeating table question

jkrdoom — Tue, 07 Feb 2006 15:55:00 GMT

Thanks that got me started I think I need to make two new fields though for what I need. I just need to know how to show the text from two separate fields in one field.

Re: Repeating table question

Matt Faus — Tue, 07 Feb 2006 03:49:38 GMT

An easy way to do this would be to add one more field to each row, FieldC, and use a function on this field to calculate the inverse. Then for each FieldA and FieldB on subsequent rows, use a data validation expression like this:

. = preceding::my:FieldC

Check out this post:http://infopathdev.com/forums/topic.asp?TOPIC_ID=1653

You might be able to do this calculation in XPath and get out of having an extra node, but it might be pretty difficult.

I hope this helps you out! If I'm misunderstanding your problem, please tell me where I'm going wrong. :)

---------------
Matt Faus
InfoPath Dev Texas

Repeating table question

jkrdoom — Mon, 06 Feb 2006 18:53:46 GMT

This one is a doozy!

I have a repeating table with 2 fields(fieldA over fieldB)in the same row and column. I want to run data validation on these fields in subsequent rows. The data validation needs to be like this:

the new rows of fieldA and FieldB cannot be equal to the inverse(fieldB over fieldA) of the fields in preceding rows

I'm totally lost on this one!!!