Skip to main content

I want to be able to count the total amount of times all “jobs” has had all “job type”.

 

Example: Job - “Contact Customer” is Job Type - “Enquiring”. If we get a hit the type will change from “enquiring” to “prototype” however I want to log that is was an enquiry permanently and count how many total “enquiring” we have had. Then I will be able to track on a graph how many “enquiring” has converted into sales or failures.

 

​

Here are my two linked tables. I have set up previously a counter to +1 every time the record “enquiring” had updated however my problem lies with when the job changed type it will still +1 on removal also.

 

Basically I want “If records is added, +1 to total”

 

thanks for any help in advance

I think you’re looking to create a “Count” field. This may sound confusing, but I’m not talking about what you name the field… what I’m talking about is that Airtable has an actual field type that is called “Count”.

When you create a new field, you get a list of field types to choose from… you will want to choose the “Count” field type instead of the “Number” field type.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hi ​@ScottWorld, thanks for the reply.

 

I have tried the count field but that is not good. Once something has moved to a different job type then the count lowers again. I only want the number to go up when items are added and as they move on the value stays

That would be trickier, because you would need to create an automation that updates your count field by 1 every time you update the linked record field in your Jobs table.

I’m away from my computer right now and typing this up on my iPhone, so I can’t show you how to set this up right now, but I’m sure that somebody else will post screenshots or a sample base below to show you how to do that.

- ScottWorld, Expert Airtable Consultant 

Hey ​@Mondays,

I would actually suggest having a different schema, by creating a table called Events (junction table) to keep a 1:1 relationship between Job and Job Type.

At a Job level, you could always lookup the Last record from Job Type you have linked through the Events table (to get the exact info you currently have).

Also at a Job level, you can have a count field -more on count fields here. Regardless of Type changing through the Events table, your count field will only go up.

Best thing: You get super precise and granular data on the log of events (changes in type).

-otherwise, you can still achieve what you are looking for. My suggestion would be to have an automation built with a script that will do a +1 to a number type field each time Type gets updated/is not blank.

Hope this helps! Feel free to reach out as needed, I’d be happy to help.

Mike, Consultant @ Automatic Nation

Hm, given that the ‘Statistics’ link only is needed to get you those numbers, what if you just kept adding to that field whenever the Job progressed instead of replacing the previous entry?

 

Terms & ConditionsAccessibility statement