EAugum - profile

EAugum · Mar 21, 2022

Hi, I need some help with an automation I’m running. I’ll start with a quick explainer to my base: One record represents one project. Projects are created in the Project-table and then “transferred”/linked to the Equipment-table. Each project has one...

EAugum · Jan 28, 2022

Hi there, I’m facing a challenge with a lookup / rollup field. I will share a link to an example base I quickly threw together, feel free to check it out to better understand my challenge. Keep in mind that this is a very simplified version of my ori...

EAugum · Oct 11, 2021

Hi, I have a table that lists our employees. Among other fields I have a BeganDate and a EndedDate (the EndedDate field would be blank for everyone currently employed). What I want to achieve is a list grouped/sorted by YYYY-MM and how many employees...

EAugum · Aug 11, 2020

Hi, A really long story made short; I’m trying to get Airtable to detect duplicate names in two rollup fields. I have the following tables in my base EquipmentProjecttype AProjecttype BLocation In my Equipment-table I’m keeping track of routers we ow...

EAugum · Jul 10, 2019

Hi, I’m working on automating multiple maintenance tasks in my base, but this one got me stuck … I’ve come to realize I need Zapier and a multi-step Zap (find record, then update record etc.), but I have not been able to figure out how to proceed fro...

EAugum · Feb 12, 2022

Hi, I solved this by creating an IF-formula in the table you’re looking up from, saying IF(DateField=TODAY(),1). Then, rather than using a lookup-field I’d use a rollup-field (rolling up on the DateField) with a COUNTA(values)-formula and setting con...

EAugum · Feb 12, 2022

Create a new checkbox-field (which defaults to ‘unchecked’), then just select the field header, copy and paste on to your original field. You’re only copy/pasting the records filtered in the view.

EAugum · Jul 11, 2019

Thanks @W_Vann_Hall! Setting the “Use a custom value (advanced)” to the record ID made it for me. And regarding zeroing out the first field (DeviceUseNow), I found that writing “” in the field in the Zap cleared it. Case closed!

EAugum · Apr 13, 2019

Thanks both, got it working! Not really a problem, but due to my incompetence on formulas, I think I have created more new fields than I really need. Any way to combine the two fields doing the Substitute-formula for the EmployeeSpecificProjectState...

EAugum · Apr 13, 2019

Hi Jonathan, Thanks for a very in-depth answer! Actually, your first example is somewhat close to what my case looks like. However, while I was making this example base, I realized maybe my challenge is that I have more of the same “state” selected i...

User Statistics

User Activity

Automation runs but partly fails - can it be solved with conditional actions?

Pull out most looked up / rolled up item

How many employed at any given month back in time?

Detect duplicate names in two rollup fields

Cut record from Field A and paste in Field B with Zapier

Re: Count # of Times Current Date Appears in Lookup

Re: Can I mass-uncheck records?

Re: Cut record from Field A and paste in Field B with Zapier

Re: IF formula on Lookup field and Multiple Select

Re: IF formula on Lookup field and Multiple Select