Help
Base Design
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

linking 3 tables

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...

andyh by 5 - Automation Enthusiast
  • 17 Views
  • 1 replies
  • 0 kudos

Reverse of Linked records?

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...

mku901 by 4 - Data Explorer
  • 43 Views
  • 1 replies
  • 0 kudos

Creating an Address Book / Comm Log without Duplicates

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 ...

Drew_Nemer by 6 - Interface Innovator
  • 35 Views
  • 0 replies
  • 0 kudos

Using QR codes to streamline concert check-in process

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...

AndrewGreen by 5 - Automation Enthusiast
  • 227 Views
  • 5 replies
  • 0 kudos

Resolved! Capturing timezones

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...

jackline by 6 - Interface Innovator
Solved
  • 77 Views
  • 3 replies
  • 0 kudos

Weekly tasks calendar

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...

Matching on an external dataframe

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...

isobel_16 by 4 - Data Explorer
  • 59 Views
  • 0 replies
  • 0 kudos

Setting up a tracker for dates

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 ...

Sean_Lake1 by 8 - Airtable Astronomer
  • 200 Views
  • 4 replies
  • 1 kudos

Creating date range from Google calendar

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...

Resolved! Adding records to a linked table

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...

andyh by 5 - Automation Enthusiast
Solved
  • 173 Views
  • 1 replies
  • 1 kudos