Forum Discussion

Qrew Trainee

2 years ago

Counting Instances of a Number in a Table

Hi everyone - I'm hoping someone out there can help me out. I have a table that contains a field, Estimate Number. This Estimate Number repeats but is differentiated by another field, Version Numbe...

MarkShnier__You

Qrew Legend

Scott, try this as a formula numeric field.

var text QUERY =
"{99.EX." & ToText([Estimate #]) & "}";

Size(
GetRecords($QUERY))

// change the 99 to the field ID# of the [Estimate #]

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

ScottCote

Qrew Trainee

2 years ago

Hi Mark - thanks so much, that worked perfectly and solved my problem.

Joe, I didn't know about the query function but now I do and this will be really helpful.

I tried using Chat GPT to solve this before turning to the community. AI couldn't figure it out (yet).

------------------------------
Scott Cote
------------------------------