I am building a new base for my company's Inspectional department to help the coordinators input and track historical, ongoing, and schedule inspections for our housing agency's low-income housing vouchers.We are tracking a combination of inspectiona...
Hi All, We're in the medical field and we are currently setting up airtable to handle our inventories for multiple locations. We have set up our product lists, as well as the inventories for each location and we're currently in the process of utilizi...
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'd like to create a new table by importing from an excel worksheet. There will be 30+ fields and i want the single select options to be True and False.When i've tried to add the single select options manually as answers and then convert the field to...
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 first started by using the org chart base template offered by Airtable to add my employee roster details and it spit out a beautiful org chart (parent relationship being manager to subordinate) - no complaints there.However, I now want to take this...
Hi,Can I import a spreadsheet (via Google Sheets or Excel) that includes "Link to Another Record" fields? When I try using the importer, it says the field type is not supported, but it's an important workflow step for how I'm using Airtable. Thanks!
I'm designing my new base and I want to create unique Task ID's that are prefixed with a letter/number combo that links to the site the task is for so DE2 and HGE. The Task ID will auto-create every time I create a new recordFor example: Create New R...
I am building a CRM to track touches with individual contacts. While I have figured out how to set up a reminder to reach out to contact a certain amount of time after their most recent meeting, I am trying to figure out the best way to track/record ...
I have a table I need to search through and pull records from.That table has a column that is linked to another table. I have that link ID. It's set to a single link (not multiple items).Here's the item from a list that I have retrieved. I have th...
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...
I created a new base in preparation for moving some spreadsheet data. Column 'A' of the sheet is dates.I'm thinking I can set the primary field as a 'date' field and include 'time' in order to make each record unique. After import (copy & paste) I ca...
Today I noticed that when adding records to the the bottom/Level 1 of a List view that is filtered on that bottom level, none of the filtered conditions pre-populate, so the new record is automatically filtered out. I tested this in several Base List...
Hello,I'm wondering if there's a workaround to import data into linked fields. For example, I'm importing monthly salary information to a data table and the employee name corresponds to the primary field of a different table. Airtable only imports th...
Hi All,I have three tables in my base:1) customers 2) venues 3) staff and I want to autogenerate a schedule which matches the customer criteria to the right venue and the right member of staff. Does anyone have any ideas of what I can try to produce ...
Hello Here's a Loom of our vision / needhttps://www.loom.com/share/9aab3ac7462e4340bf67314b63289bd3 If this is a project you'd be interested in, please email go@beyondthepeak.co with the Subject line: I'd like to make your Epic AirTable KPI Dashboar...
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 to hide options for a field? We no longer want users to be able to select these options but still keep the past records intact. For example an the field Responsible Party has as an option Vendor. Our company is not longer using vendors...
Hi all,Wondering if any one has experience of syncing Airtable with JIRA Cloud, I've setup a sysnc'd table in Airtable to pul our service desk data so I can build a dashboard, however some of our custom fields have not been pulled though one example ...
Is there a way I can reorder the view order via Script instead of the manual Drag and Drop?
