Hi. I'm trying to figure out how to use a Lookup Field to update another record in the same table. This is a simplified version of the workflow to illustrate what I'm trying to do:I've got a number of records, called "Sequences." I need to define the...
I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. whe...
I have a CAMPAIGN tab where each record is a Campaign. For Example: May, June, July. Each record has a Channel field. that i populate from a linked tab called Channel Type)For example one record is: May marketing campaign and the channel field then l...
Hello AT Community, I'm a "newbie" and have really appreciated all the ideas and suggestions I have found here. I have been trying to do something that I think should be pretty straightforward because I know how to do it in Google Spreadsheets easily...
My company has thousands of different contacts that we want to make a communication log for. The idea is two linked tables, an address book and a communication log. The issue is I don’t know a smooth and quick method to add new communications to the ...
Is there a way I can reorder the view order via Script instead of the manual Drag and Drop?
Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attend...
Hi,I have an airtable database that captures information from a tally form.One of the fields in the database is date created which is a formula and is the date when the form was filled in.Anyone can fill the form and I want to capture the time zone o...
Hello.I've been using airtable to create a database for equipment files in a research facility.Now I would like to use it to organize our team weekly tasks calendar. Some of these tasks are performed on equipment that is in my first database.We are a...
I've built a task list table, and have some recurring tasks that comes with sub tasks in another table that are linked.I am hoping that when my Task is completed, airtable will create the exact same task, except to change the dead line based a formul...
Hi there! We run various festivals and events, and have a base of around 400-500 volunteers who help us out on these events. For our last event, we moved all volunteer management over to Airtable which worked like a charm. I have all my volunteers in...
Hello! I am currently at a standstill. To make my long story short... I have a database that keeps track of vehicles and equipment. This included Maintenace records, mileage, locations, etc. (Keep in mind I am not the only one who uses it) Because I...
Hi there,I am hoping to get some advice on what to do in the following scenario:I have a base created from form entries. I want to add a column to this base to reflect a 'customer_id' that I have separately in an external csv. I cannot import this da...
Good day all!Currently we schedule training that has been nicely integrated with GCal. Recently, we decided to track rescheduled training for better communication and reporting. I've added a "RESCHEDULED" check box to be marked when a training has ...
Hello there,I have a base where we are taking job hours and rolling up all the hours into monthly payroll. I attached screenshots of the sample base.Basically, I am trying to create an animation where if {Payroll Link} is empty, then copy and paste ...
Hi everyone,I am trying to insert in a single select field which has options "true" and "false" (without quotes) a data coming from an application through a webhook which is either "true" or "false" (also without quotes).Unfortunately, when trying to...
Hi,I've built a team utilisation and created a timeline that allows me to see how I have committed my resources across different projects. As part of this utilisation, I have a table where I can log days off for each team member. Currently, I enter t...
New'ish to Airtable and feel like I'm running into a super'noob question and just missing something. The point of my base is to share resources across a team, though not every resource to every user.In my base I have a Resources table, and a Users ta...
I have a customer (athlete) table that is one row per customer. And a comms table, that logs when each customer posts something in our community (circle) via Zapier.Then, in the customer table I use a rollup to display the date of each customer's las...
