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
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
13 years ago
You can't do this with QuickBase formulas because there is no looping or counting construct.

It is simple to do with script. If your multiline text field was fid=6 and the numeric counting field was fid=7 you could use this code with the image onload technique to do the job:

$("#_fid_6").on("change",function(){ $("#_fid_7").val($(this).val().split("\n").length)});