Forum Discussion

MattLegowski's avatar
MattLegowski
Qrew Trainee
6 years ago

I need to create a code that counts how many time a particular codes appears in a field

I have the below string of codes in one quickbase field: 80346,80329,80346,80371,80346,80335,80324,80346,80369,80332,80332,80356,80361,80361,80361,80361,80354,80358,80372,80329,80324,80367,80355,80...
Tables and fields
MattLegowski's avatar
MattLegowski
Qrew Trainee
6 years ago
Hi Dan, 

Thank you for you response. 
Unfortunately, I am not familiar with the Var Text Codes. 

I copy and pasted your code and it is throwing an error for me. 

Are you able to diagnose what is wrong with the code?



https://imgur.com/a/uvz3JLD 

It looks like the screenshot didn't upload that well, so a link to the image has also been added. 

Thanks,

  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    6 years ago
    It looks like there are no double quotes at the start and end of the second line of the formula.
  • MattLegowski's avatar
    MattLegowski
    Qrew Trainee
    6 years ago
    Hi Dan, 

    Added the quotes, but it is still having an issue with the period in the "this.outer" portion of the formula

    https://imgur.com/a/pxfKwEw
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    6 years ago
    Now you have two double quotes at the start and end of the second line.