Ask the Community

I have a table in a base, but I want to move this table to a different base.  However, I am using it as a linked table in other tables' fields.   Is it possible to move this table to another base and keep the linked record information on the other tables?  Or it will break the links?Thanks in advance.

Hi there! I use a synched base to manage active studentsIf a student drops out of a course, they are labeled as ex-students, which lead to them being de-synced. They may return a few weeks before, taking another course. Marked as a student again, they are synced again. I realized that Airtable remembers the fields of this record in the synched table and automatically reruns teh automations, resulting in some failures.Can someone tell me how to avoid this airtable function!?I hope I have explained this properly. Sorry for my english!Thanks!David

Problem Explanation:I need help with sharing specific records in an Airtable interface with various teams that I work with, without exposing the underlying data. Here are the details:Objective: Share the interface and only specific records with the team but not the base, ensuring team members see only their team's records.Current Method: Using the interface share button to share the interface, not the base.Challenge: I do not want to add team members as collaborators to the base to filter records based on their email or collaborator column.Limitations: Creating separate interfaces for each team to share with is inefficient and not scalable, especially since team sizes vary from one to twenty members.Question:What is the best way to filter records for each team and its team members when they log into the interface, without allowing them access to the base?Any advice would be greatly appreciated! Thank you!

We've been using Airtable for several years to track our Marketing & Design projects. We have a "Designer" field that is a dropdown menu of Airtable user names to pick from.I am now trying to mimic Airtable's Resource Allocation template to track team resources and team availability. However, I'm running into an issue since our system is based on the Designer filed pulling in Airtable user names, compared to the Resource Allocation template that uses a table of designer names (which would also include # hours a week worked, scheduled time off, etc)How do I create a "bridge" that will look at the Designer field (username drop down) and tie it to the same person's name in the new Designer table so in addition to tracking each person's weekly hours, time off, it also connects to all jobs assigned to them?Here's a video explanation of what I'm trying to accomplish.https://app.screencast.com/kmTOnXsEluj56?tab=Details&conversation=AyA1GmOhWWJyOvctR5LtRj

Hello, a colleague of mine has the option to “allow viewers to edit view” under the “share” button without adding them as a collaborator. My “share” button does not have that option. Thanks!

Hello again, a new puzzle for me.I have a summary report table that uses a view of records filtered by a particular month from another table for data. The summary table uses a linked  field and I want to be able to select all the records in the linked view for the summary. Right now I have to individually select each record. This isn't bad if you have, say, 1 - 10 records. But sometimes I have over 100. That's a lot of clicking.Is there a way to select all the records available in the list that pops up to select from?Thanks, Scott

It is quite disappointing logging into the new interface today. Already it has caused inconvenience to its users and I hope users will get the option to choose the interface that works best for them. One major issue is the inability to sort workspaces in the order you want, which can make it challenging to find specific workspaces quickly, especially if you have many of them. Another issue is the inability to rearrange bases by dragging and dropping, which was a convenient feature that saved users time and effort. Furthermore, when you click on any workspace interface, accessing the home page is not as easy as it used to be. This can be frustrating for users who need to quickly navigate to the home page to access essential features and information.Lastly, some users may feel that the new interface looks outdated compared to the previous version. The visual aspect of an interface can be just as important as its functionality. A modern and visually appealing interface can make

Good morning everyone.I have two different databases because I organize two different companies and sell cars. Both have their own car stock but I would like to create a table with both stocks together (they have the same column format). The IDs of the two tables are AUTONUMBER but I could use the frame as the unique id.I currently did this:1) created a synchronized table from database B to database A2) created record creation automation from database sync table B to table A (works)3) when I try to create the record update automation it always gives me an error, I don't know what to put in the RECORD ID field because it only offers me the data from table B, not AI also tried with Zapier, Make, anyway...How can I solve it? I am going crazy!!

Hello All, I need help with a nested IF statement that references a formula date field. I'm not sure if this is causing my issues, but I can only get my formula to output two of the four values. In the formula below, "Expired" and "Missing" appear, but "Expired" is not accurate when I update the date.What I am trying to accomplish is:- If the date is past today, display 'Expired'.- If it is within six months of the due date, display 'Expiring'.- If it is greater than six months, display 'Active'.- If no date value is in the field, display 'Missing'.If anyone can let me know what I am doing wrong, I would appreciate it. IF( {H.I.P.S - Due Date} < TODAY(), 'Expired', IF( AND( {H.I.P.S - Due Date} >= TODAY(), {H.I.P.S - Due Date} <= DATEADD(TODAY(), 6, 'months') ), 'Expiring', IF( {H.I.P.S - Due Date} > DATEADD(TODAY(), 6, 'months'), 'Active', 'Missing' ) ) ) 

Hi my org does school lessons, we have lessons, teachers (who host the lesson), and our educators (who deliver the lesson). These are spread across 3 tables, with lessons having links to an educator and one or more teachers. I want to calculate the number of unique teachers an educator has reached. So I created a rollup field on the educator that uses COUNTA(ARRAYUNIQUE(values)) on the lesson's teachers. This works great if each lesson only has one teacher. But some lessons have multiple teachers, I tried a workaround using a lookup field and then a formula using ARRAYUNIQUE but that didn't work, as apparently the array formulas are just for rollup operations. Is there a workaround?Here's an airtable base demonstrating the problem: https://airtable.com/shrSGt3bifbnmwnLp

Hi all,Using Make, Airtable and an API, I built an automation that scrapes reviews of a cultural event from Google Maps. On Google, the date on which a user left a review is not given. Instead, Google provides us with a time period that matches the amount of time that elapsed since the user left his/her review (e.g. 'one year ago'). This type of data does not make it easy to sort reviews in a chronological order. Consequently, I went about transforming this type of data into dates.For this data conversion, I created intermediary fields – Time Unit Count, Time Unit Type and Search Date – that I then combine in a formula in the Date field. But I'm unsatisfied with 2 of those intermediary fields' formulas.1. Time Unit Type field: for this field, I used a series of nested IF statements because I didn't manage to use the SWITCH function properly in this use case. This gives me a long and not-very-clear formula.Would any of you guys have a more elegant solution to suggest?2. Time Unit Count

Hello Airtable Community,I have a relatively complex use case.I have a table in which projects are created, a table for tasks and a table for project phases. Then I have a template table with standard tasks and a template table with standard phases. I would now like both the standard phases and the standard tasks to be created by an automation when a button for a project is clicked.I have created two automations for this, one for the tasks and one for the phases. Everything works fine. Both the tasks and the phases are linked to the project. However, the tasks are not automatically linked to the phase. The aim is that, for example, when all tasks in phase 1 are completed, the phase is also completed.Thank you and best regards.Mirko 

I am working on creating a system to track training for my company and am running into an issue I can't figure out. I have built the database and would like my "Ring Central Training" table to be updated once a feedback form is submitted so that way, we have an automated way of checking off when employees have gone through training. The Ring Central Training table will ideally have all of the employee names there now as well as what teams they belong to. The issue I am having is that once I created the automation I have the error that there is invalid inputs. Ideally I would like the "Scheduled" option in the Ring Central table to get change to completed once the form is submitted as well as the Date of Training to change based on when the form is submitted. Below is all relevant screenshots regarding my issue.

I have a table with a list of contracts that has fields for CompanyName (link record to a company table that lists all the companies) and ContractStartDate.How do I filter or find the oldest record for each Company based on ContractStartDate? A company can have 1 or multiple contracts.Thanks!

Hello! I currently am using Make to funnel in data from a webhook and then create a record in airtable. My goal currently is to be able to display Events per hour for each day of the week, I am essentially trying to recreate the table in the screenshot below:I've been playing with it for the last few days but am struggling with the best way to accomplish this. I believe one of my issues is that the "Date-Time" isn't explicitly coming from the webhook and rather just Airtables "Date" data type with the "Use current Date". Just looking for any guidance/nudges in the right direction on how I could accomplish recreating the table below. . 

Hi all!I am currently working on a base in which our staff members will be able to fill out their weekly timesheets. I live in Canada and here the standard hours of work is set to 8 hours in a day and 40 hours in a week.In our company, the standard hours of work for a week is set to 35 hours. Any worked time that goes between 70 and 80 at the end of each Pay Period (2 weeks) is put in a bank. I can't figure out how to properly sum those hours without creating an astronomical amount of fields so I need your help.In my base (which is in French) I have 6 tables :Feuilles de temps (=Timesheets) which is linked to Pay Periods, People, Days and ProjectsPériodes de paie (=Pay Periods) which is linked to Timesheets, People, and WeeksPersonnes (=People) which is linked to Timesheets and Pay PeriodsSemaines (=Weeks) which is linked to Pay Periods and DaysJours de la semaine (=Days) which is linked to Timesheets and WeeksMissions (=Projects) which is linked

Hi,I need some help with an issue I'm facing. I have a formula field called "Order Quantities" and a "Meal Quantities" field (Long Text) that references it. I'm using the Fillout form to gather customer information. However, the quantity field in Fillout is not connected to my Airtable.To address this, I created an automation to pull the quantity details into Airtable (see the attached file).I'm looking for a workaround to sum all the quantities of each meal for all records in the "Order Quantities" field without changing the structure of my table, as I need to launch this system this week.Thank you!Here is the formula I'm using for the Order Quantities: CONCATENATE(  "Lamb Keema: ", IF(    ISERROR(SEARCH("Lamb Keema x ", {Meal Quantities})), 0,    VALUE(MID(      {Meal Quantities},      SEARCH("Lamb Keema x 

Hi! I'm trying to create a formula for the following columns:1: First Name2: Last Name3: Pen Namewhere If "Pen Name" is blank, use "First Name + Last Name". I keep getting stuck somewhere and getting invalid formula errors. 

Is there a way to see/track who has made edits to a formula or field? This feature is very helpful for viewing individual records, but it'd be even better if I could view who is changing formulas.

We are a medical practice and often use fax as a way to communicate securely to our referral network. Is there fax capability built in Airtable? If so, how do I do this? If not, is there a way to setup faxing via a third party application? 

Hello,Everyday I have a script that scrape IG accounts. I want to add "Followers Gain" which is the current number minus the previous number of followers on this account. I've played with automation without success due to the fact that there are different IG accounts. 

Hello everyone,I am modeling a Plastic-Injection Production & Order Management database on Airtable with external Forms for data entry. In plastic injection, each physical Mold has a number of physical Eyelets which produce a digital shape called Pieces (Component). Components, which are respectively, Pieces, Outsources, Workmanship, come up together in a joint table named Product Recipes and make up Products. Each Piece comes up as a Piece Model from the machinery, as it takes a specific Raw Material and a Color.I have managed to work this with CRUD (Create, Read, Update, Delete) operations implemented. Now there comes a difficult task I'm having trouble imagining.As you see, later on, after I implement the Orders & Customers Module, I will move forward to Production Management Module. But there is a missing piece to that. You see, each machine has a different interface physically, and they get parameters to print the molds. So, each machine works differently with ea

Hi Airtable Community,I have two table named "Task Assignment" and "Employees". I have linked the Employees table to the Task Assignment table using a linked record called "Assignee". Now I want to send an email every time I add a task inside the "Task Assignment" table. I have added a lookup field in the "Task Assignment" but is is not available in the automations.Please let me know how to tackle the issue. Thanks

 Is there a way/hack to select the same object multiple times in multiple-select? I'm collecting information about tickets and some individuals' have multiple tickets of the same type. Thanks!

I’ve created a dizzying array of lookups, rollups, and formulas to finally arrive at a result, which is in a formula field. I want to copy this text string result into a text field that can be displayed and edited on a public form (long text or short text). I know how to “pull” results into a new field using formulas, lookups, and rollups. But how do I assign a value to a text field that can be used in a public form? How do I “push” my result into the field? Thanks!