Forum Discussion

ElizabethElizab's avatar
ElizabethElizab
Qrew Member
13 years ago

Is there a formula for counting the number of fields entered in a multi-line text box?

I am thinking something like a "count" formula in Excel. For example, I have a field in a table which asks the user to input report names on different lines. I would then like a separate field which w...
Data import and export
Formulas and functions
reports and charts
KenFirchKenFirc's avatar
KenFirchKenFirc
Qrew Trainee
13 years ago
Or if you have a practical limit on the number of reports they enter, you could try something like this which works for up to 10 lines (and could be expanded to more):

var Number linei = ToNumber(Trim(Part([Reports], 1,"\n"))<>"");

var Number lineii = ToNumber(Trim(Part([Reports], 2,"\n"))<>"");

var Number lineiii = ToNumber(Trim(Part([Reports], 3,"\n"))<>"");

var Number lineiv = ToNumber(Trim(Part([Reports], 4,"\n"))<>"");

var Number linev = ToNumber(Trim(Part([Reports], 5,"\n"))<>"");

var Number linevi = ToNumber(Trim(Part([Reports], 6,"\n"))<>"");

var Number linevii = ToNumber(Trim(Part([Reports], 7,"\n"))<>"");

var Number lineviii = ToNumber(Trim(Part([Reports], 8,"\n"))<>"");

var Number lineix = ToNumber(Trim(Part([Reports], 9,"\n"))<>"");

var Number linex = ToNumber(Trim(Part([Reports],10,"\n"))<>"");

$linei + $lineii + $lineiii + $lineiv + $linev + $linevi + $linevii + $lineviii + $lineix + $linex