COUNTIFS in a different table

Baserow Help
1

Hi All,

Happy Holidays! I was wondering if there’s an easy way I can create a count of variables from one table into another?

Basically I have built an Applicant Tracking Database in Baserow (Hosted) and in my database I have a column which allow us to record how applicants heard about us. Ideally I want to create another table listed by platform and then have a count of each social media site next to the name.

Normally in Excel, I would just run a COUNTIFS on the name of the site and it would report back total for each platform. How would I replicate this in Baserow? Currently, I’ve created a ‘Heard From’ view and then done a ‘Group by’ but due to the records I have to scroll through them to be able to see all of the group by results.

Any ideas?

2

Hi @NicoR93 ,

The easiest way to achieve that would be to create a Table with all the available Platforms, where you link the Applicant to the platform by a link-to-table field:

image
image926×444 37.6 KB

In the linked ‘Platform’ Table you then are able to create a count field, where the amount of linked applicants is returned:

image
image1242×320 20.5 KB

image
image1023×137 11.4 KB

You could also use the filter() formula function combined with the contains() function.

image
image1324×628 45.1 KB

However creating seperate Tables for Applicants and Platorms seems like the best way to do it.

Hope this helps!

1 Like
3

Thanks for this, would this still work with Webhooks? Currently, I pipe data from our Contact Form on our website into Baserow via Microsoft Flow/PowerApps?

1 Like
4

@NicoR93 Sure, this should work fine. Just make sure that each Platform-Row-Id is defined within the Flow/PowerApp and then accordingly linked when the applicant-form-content is being posted to your Applicants-Table via baserow API.

your POST- API Request Body should look something like this:

{
"id": 0, // 0 means that a new row should be created within the Applicants-Table
"nameField": "Applicant 4 (from Google)",
"platformLinkToTableField": [1] // This is the row-identifier of the platform that should be linked to the new Applicant, in this example 1 refers to Google. 
}
1 Like