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...
Forum Discussion
Scott - did you try using a query field to count the number of records that match the estimate number? That way if you have gaps in the version numbers - you'd get the right nr of estimates and you could expand it to look at other thinks like status, etc. Yeah - you're counting in the same table, but that should be just fine.
------------------------------
joe vandervest
------------------------------
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
------------------------------
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
------------------------------
