Can someone give me some advice on how to update the yellow columns as shown in the example below?I have a fillout form that the approvers can update the approval status of the applicant. On saving and the record gets updated, I'd like the counts upd...
Hi Airtable Community,I’m currently managing a database where payments are recorded in a “Payments” table, attendance is tracked in a “Attendance” table, and student information is kept in a “Students” table, all to maintain good data normalization. ...
i'm trying to make a formula to pull out the last name from a field that sometimes has full names in it & sometimes does not. i found this formula in a very helpful Airtable blog:TRIM(MID(SUBSTITUTE(Employer," ",REPT(" ",LEN(Employer))), (3-1)*LEN(Em...
Hey Airtable community,Been hitting my head against the wall for the last hour with this. I'm trying to write a formula for:If {Donor First Name} is not empty, then the field would read: {Donor First Name}&" "&{Donor Last Name}And if {Donor First Nam...
Hello, I'm creating a fairly simple base to track all of the violations for an HOA board. I'm trying to create a field to calculate the total number of times a house has gotten the same violation in the past year.The Base has 3 tables, "Homes" with a...
Hello, I am trying to just multiply Roll Ft Size x Lin Ft. But I keep getting an error. What am I doing wrong here?Thank you for any help here.
I have multiple tables that deal with budgeting, and in each one I've got a similar setup. I track the total budgeted and then how much we've spent manually, then a formula determines the difference and another formula looks at that difference and de...
Hi,I am trying to extract text and date from subject field in gmail into two seperate fields but I can not get the formula right.The subject will be in this format "16610 6/9"16610 should be extracted as text into seperate field and 6/9 into date fi...
Hi everyone,I’m encountering some challenges with defining a rollup field that combines data from three tables in Airtable. Here’s the setup:Buildings (fields: name, etc.)Employees (fields: name, hourly_rate, etc.)Timesheet (fields: employee_name, bu...
Hi,I am new to Airtable and now very tech savvy in general so I'm sorry if this is an obvious question.I have a table with a list of my discovery calls and then I record when these turn into paying clients. I want to summarise how many sale I make pe...
| User | Count |
|---|---|
| 884 | |
| 832 | |
| 606 | |
| 526 | |
| 341 |
