Forum Discussion

ElizabethElizab's avatar
ElizabethElizab
Qrew Member
12 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 will count the number of reports entered.

I may be using the wrong vocabulary here, and the answer could be right under my nose, in which case I apologize for the silly question. Thanks in advance for your help.

10 Replies

  • 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)});
  • 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



  • BasuB's avatar
    BasuB
    Qrew Member
    Has there been any update that will allow the count of multiple lines in a field.