Need to create a countif formula to count repeated values in table. Is this possible/how in Quick Base? Been messing with "Summary field options", but can't quite get what I'm after. Could do it in excel and import back in, but want value to update automatically as I add more records to my table.
A field to say the value in the field X appears Y amount of times in the whole table.
I can solve this by exporting the Summary Report to a new Table, but then I lose the ability for it to update automatically.
The button would used the urlroot() & "db/" &[_DBID_MY_TABLE_ID] & "?act=API_RunImport&ID=10" as part of its formula ..
Don't want a report per say, but want to see when I select Customer Number - 1 there's a field (countif formula) that shows the exact same value in [Customer Phone] occurs 4 times in this table (countif in excel). If it was possible for the value in my countif formula once I click it to bring me to a report with all matching numbers, would be ideal. Then I need to apply this logic/formula to many other fields.
Customer Number Customer Name Customer Phone
1 John Smith 123-456-7890
2 Jane Does 123-456-7890
3 Gilbert Grape 123-456-7890
4 John Deere 321-456-7890
5 Darth Vader 123-456-7890
Kaaggle Titanic Problem
Triangulation 57: Jeremy Howard founder of Kaagle
T> Don't want a report ...
By output report I meant output in the most general sense. Here is my view of your question: You are asking for a countif feature similar to what is used in Excel. The bottom line is that there is no analogous native functionality in QuickBase. The countif function in Excel takes a (1) range of cells in an Excel worksheet and (2) a criteria and counts up the number of cells in the range that match the criteria and displays this count in some other cell in the worksheet:
The first step is to obtain the raw data using the API. Unfortunately QuickBase's API returns XML so a short utility function will be used to return JSON from API calls. Next, the JSON representing the raw data is processed is some manner and typically involves counting, indexing, sorting, grouping or performing some arithmetic and concatenation of raw data. This second step is done with script and frequently uses methods in the underscore library. The third step is to apply a template to the processed data to generate some type of HTML output which might be a simple table or results or a complex svg graphic of some sort (for instance a HighChart chart).
Kaaggle Titanic Tasks (click on Summarize By Sex and Embarkation Button)https://haversineconsulting.quickbase.com/db/bkjtq43us?a=td
template.html (Underscore Template) https://haversineconsulting.quickbase.com/db/bkjtbpfei?a=dbpage&pagename=template.html
(1) more to come when I have time ...
- 722 Conversations
- 18 Followers
- 3271 Conversations
- 135 Followers
- 2927 Conversations
- 75 Followers
- 2625 Conversations
- 47 Followers
- 3094 Conversations
- 92 Followers
- 2243 Conversations
- 23 Followers
- 7210 Conversations
- 182 Followers