Automatic cell numbering included in a pull-down KJL 24.08.2006 12:16:02 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

Re: Automatic cell numbering included in a pull-down "Greg Collins [InfoPath MVP]" <gcollins_AT_msn_DOT_com> 24.08.2006 23:34:38 For the prefixing issue, just use the concat() function: concat('F', count(preceding::my:NodeName) + 1) -- Greg Collins [Microsoft MVP] Visit Brain Trove ( http://www.BrainTrove.com ) Visit InfoPathDev ( http://www.InfoPathDev.com )

Re: Automatic cell numbering included in a pull-down "Greg Collins [InfoPath MVP]" <gcollins_AT_msn_DOT_com> 24.08.2006 23:34:57 For the prefixing issue, just use the concat() function: concat('F', count(preceding::my:NodeName) + 1) -- Greg Collins [Microsoft MVP] Visit Brain Trove ( http://www.BrainTrove.com ) Visit InfoPathDev ( http://www.InfoPathDev.com )

RE: Automatic cell numbering included in a pull-down S.Y.M. Wong-A-Ton 25.08.2006 07:41:01 As to the first part of your question: Did you use an expression box to calculate and show the numbers? --- S.Y.M. Wong-A-Ton "KJL" wrote: [Quoted Text] > 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 >

RE: Automatic cell numbering included in a pull-down KJL 25.08.2006 12:16:01 I didn't use an expression box. Is there a way to "point" to a cell that isn't bound to a data source? Or is there a way to bind an expression box to a data source? "S.Y.M. Wong-A-Ton" wrote: [Quoted Text] > As to the first part of your question: Did you use an expression box to > calculate and show the numbers? > --- > S.Y.M. Wong-A-Ton > > > "KJL" wrote: > > > 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 > >

Re: Automatic cell numbering included in a pull-down KJL 25.08.2006 18:01:02 SWEET!! That does it all!! Thanks "Greg Collins [InfoPath MVP]" wrote: [Quoted Text] > For the prefixing issue, just use the concat() function: > > concat('F', count(preceding::my:NodeName) + 1) > > -- > Greg Collins [Microsoft MVP] > Visit Brain Trove ( http://www.BrainTrove.com ) > Visit InfoPathDev ( http://www.InfoPathDev.com ) > > >

RE: Automatic cell numbering included in a pull-down S.Y.M. Wong-A-Ton 25.08.2006 21:11:01 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... --- S.Y.M. Wong-A-Ton "KJL" wrote: [Quoted Text] > I didn't use an expression box. > Is there a way to "point" to a cell that isn't bound to a data source? Or is > there a way to bind an expression box to a data source? > > "S.Y.M. Wong-A-Ton" wrote: > > > As to the first part of your question: Did you use an expression box to > > calculate and show the numbers? > > --- > > S.Y.M. Wong-A-Ton > > > > > > "KJL" wrote: > > > > > 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 > > >

RE: Automatic cell numbering included in a pull-down KJL 28.08.2006 11:59:01 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! "S.Y.M. Wong-A-Ton" wrote: [Quoted Text] > 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... > --- > S.Y.M. Wong-A-Ton > > > "KJL" wrote: > > > I didn't use an expression box. > > Is there a way to "point" to a cell that isn't bound to a data source? Or is > > there a way to bind an expression box to a data source? > > > > "S.Y.M. Wong-A-Ton" wrote: > > > > > As to the first part of your question: Did you use an expression box to > > > calculate and show the numbers? > > > --- > > > S.Y.M. Wong-A-Ton > > > > > > > > > "KJL" wrote: > > > > > > > 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 > > > >

Re: Automatic cell numbering included in a pull-down "Greg Collins [InfoPath MVP]" <gcollins_AT_msn_DOT_com> 03.09.2006 03:01:33 Great! Glad to help! -- Greg Collins [Microsoft MVP] Visit Brain Trove ( http://www.BrainTrove.com ) Visit InfoPathDev ( http://www.InfoPathDev.com )