Newbie Questions

Re: fill in 2 values, receive the third

cyberdhine — Thu, 03 Dec 2009 08:32:00 GMT

Jimmy,

Great, thanks! This works fine!

Re: fill in 2 values, receive the third

Jimmy — Thu, 03 Dec 2009 08:23:38 GMT

Please try using this expression instead (it has an extra "../")

count(../../preceding-sibling::*) = 0

Re: fill in 2 values, receive the third

cyberdhine — Thu, 03 Dec 2009 08:11:38 GMT

Hello Jimmy,

I'm sure it's the right direction! But doing this causes the dropdownbox to only show "25" a lot of times. I tried to change the value "0" in the expression to "1" and this caused the dropdownbox to be filled with alot of "26's".
I'm trying to tweak it a bit, but my knowledge is minimal :)

Thanks!

Re: fill in 2 values, receive the third

Jimmy — Wed, 02 Dec 2009 16:10:33 GMT

In the properties for the a dropdown, click the button in the entries: row, then the Filter data... button, Add.., change the first dropdown to "The expression" and then use the expression:

count(../preceding-sibling::*) = 0

This should cause it to only use the column values from the first row of data in the matrix.

It should also reduce the delay in adding new rows to the repeating table.

Re: fill in 2 values, receive the third

cyberdhine — Wed, 02 Dec 2009 07:32:14 GMT

Hello Hillary,

thanks! This works! I've indeed added the same rule to the alpha box, so if someone makes a mistake i.e. and they correct it, the value will be adjusted as well.
Great.
Now only one thing I'm noticing: the alpha box drop-down is filled with 25-66, but alot of times! It doesn't matter which you choose, so it's no big problem, but it there's something I can do about it?

Thanks!

Re: fill in 2 values, receive the third

Hilary Stoupa — Tue, 01 Dec 2009 23:07:21 GMT

Here is a version of your earlier template. Instead of a default value in the field for the Cb column, I've added a rule to the Beta field to set that column when the Beta value changes. You may also want to add the same rule to the Alpha field...

Re: fill in 2 values, receive the third

cyberdhine — Wed, 25 Nov 2009 08:37:23 GMT

Okay, so this is also possible?

Maybe someone could explain me some more? I have no idea on how to achieve this.
Or maybe it's best for me to upgrade to 2007? Since I'm not that familliar with InfoPath....

Thanks.

Re: fill in 2 values, receive the third

Jimmy — Wed, 25 Nov 2009 08:22:59 GMT

Hilary's suggesting you use a similar (or the same) formula, but use it in rules on dropdown A and B, instead of for the default value of Cb.

Re: fill in 2 values, receive the third

cyberdhine — Wed, 25 Nov 2009 07:56:15 GMT

Hm,
but setting this with rules would mean I would have to set (41*73=) 2993 rules? Or don't I understand?

Re: fill in 2 values, receive the third

Hilary Stoupa — Tue, 24 Nov 2009 20:29:48 GMT

As I recall the current() function behaves differently in 2003 and 2007. I think instead of a default value, you may need to use a rule to set the field.

Re: fill in 2 values, receive the third

cyberdhine — Tue, 24 Nov 2009 07:32:23 GMT

Oh oh.... :)

I'm using 2003. Should I go and talk to the IT-guy? :)

Re: fill in 2 values, receive the third

Hilary Stoupa — Tue, 24 Nov 2009 00:29:54 GMT

What version of InfoPath are you using? 2003 or 2007?

Re: fill in 2 values, receive the third

cyberdhine — Mon, 23 Nov 2009 10:04:08 GMT

Hm, that's strange!
When I do the same, the CB-box stays empty. Just nothing happens...?

Re: fill in 2 values, receive the third

Jimmy — Fri, 20 Nov 2009 15:12:31 GMT

Sorry for not responding sooner. It seems I missed your post. I tried opening the latest form you attached in Preview mode, adding a row to the table, selecting a value for a and b, and Cb is showing the corresponding value just fine. What happens when you try that?

Re: fill in 2 values, receive the third

cyberdhine — Fri, 20 Nov 2009 13:54:46 GMT

No luck on this one yet.

Any ideas? :)