Automatic cell numbering included in a pull-down

K

KJL

I figured out how to get the auto numbering expression to work and have the
cell bound to a data source. The expression should read;
count(preceding::my:NodeName) + 1

NOW I would like to use those values in another pull down but when I use
"look up values in forms data source" all I get are blank spaces.

Also - Is there any way to add a prefix to the auto numbering so I can
create an alpha-numeric designator? i.e. - F1, F2, F3
 
G

Greg Collins [InfoPath MVP]

For the prefixing issue, just use the concat() function:

concat('F', count(preceding::my:NodeName) + 1)
 
G

Greg Collins [InfoPath MVP]

For the prefixing issue, just use the concat() function:

concat('F', count(preceding::my:NodeName) + 1)
 
S

S.Y.M. Wong-A-Ton

As to the first part of your question: Did you use an expression box to
calculate and show the numbers?
 
S

S.Y.M. Wong-A-Ton

You should be fine NOT using an expression box, but a normal text box
instead. I suspect that the calculation is dynamic and that the values are
not present at the time when you want to use them. Will ponder over that
one...
 
K

KJL

Everything is working the way I wanted it to since I added the 'concat'
function to the expression as suggested by Greg. I don't know what the
difference is but when I would use just the auto-numbering I would get
blanks in my pull-down.

Thanks for your help!
 
Top