Ask the Community

Hello there, How does it work with the privacy of Airtable? Can I trust that my data is safe at Airtable? With kind regards

Hi all!My team and I are using Airtable to store user research as we build out and iterate on different products within our org. One of our goals is creating a repository to reference research participants we've spoken with in the past to contact them more easily for future research. The goal of this base is two-fold: the first being a structured pool of participants to pull from, and the second is a collision map to make sure we're not pulling the same participant for several different projects and overloading them. Our project teams often aren't aware of who the other team is recruiting for research and this has happened a few times. In the participant repository base, my setup so far is 3 tabs, 1)Ongoing projects and their timelines, 2) Our staff members and 3)The participant database. I have a lookup field in the participant database tab that lists the projects a participant is involved with and another field with the status of those projects, whet

 Hi,I have a problem with the release of my extension.The application works fine in development mode after block run.I wanted to switch to release, but after using block release I get the following errorspatrykjachym@MacBook-Pro-Patryk obliczanie_transportow % block releasebuildingcopying package.json filecopying package-lock.json fileinstalling node modules[npm][npm] added 107 packages, and audited 108 packages in 862ms[npm][npm] 7 packages are looking for funding[npm] run `npm fund` for details[npm][npm] found 0 vulnerabilities[npm] npm warn config production Use `--omit=dev` instead.❌ Error: npm warn config production Use `--omit=dev` instead.Failed to build the block code!patrykjachym@MacBook-Pro-Patryk obliczanie_transportow % My package.json { "dependencies": { "@air

Hi,I have a project management interface where I have a table listing all of my projects and then another table for tasks.  On the task table, there is a link to the project table.  I have created an interface using kanban that shows the tasks by priority (high, medium, low).  In the interface, I allow the linking of the task to the project table.  When I click the plus signal, it only shows me the first three fields from the project table.  Is there a way to modify what fields show on the "linking" screen that pops up?Thanks,Kevin

I store price data in a Products table, and link to it in an InvoiceLines table (Many InvoiceLines from One Product). However, when a price changes (is updated) in Products the original price of that item should not change in those records in InvoiceLines that have already been created. Given the Lookup type doesn’t offer it, can you think of a way to achieve this? At the moment the only way I can think of, is to export data from one table and import to another?

My phone number field has rows with different formatting. e.g. 12824673737 and (510) 890-9699 How can I force all the phone numbers to be of one format: namely, a 10 digit number without any punctuation in between

I am receiving the below error;O: Can't create field: invalid field config. Creating or updating options for longText fields is not supported at this time. at main on line 31Can Airtable not support creating a Long Text Field? I might be missing something;  let table = base.getTable("Report"); // List of fields to duplicate, with their types let fieldsToDuplicate = [ { name: "Act Name - GA 1", type: "singleLineText" }, { name: "Additional Comments - GA 1", type: "longText" }, { name: "Guest Artiste Show - GA 1", type: "multipleRecordLinks" }, { name: "Versatility - GA 1", type: "rating" }, { name: "Guests Socialization - GA 1", type: "rating" }, { name: "Audience Engagement, Adaptability - GA 1", type: "rating" }, { name: "Material Quality, Originality - GA 1", type: "rating" }, { name: "Professionalism and Reliability - GA 1", type: "rating" }, { name: "Adhere to Dress Code - GA 1", ty

I have a table (Table #1) in which we keep upcoming events, along with their dates, topic, marketing content etc. I created a mirror table (Table #2) with the same fields. Table #2 has a form our staff uses when they need to update any of the events that are in Table #1 (existing records). I created an automation that when a form is submitted in table #2, it finds the records in table #1 that match the name of the program and then updates the existing record.Here's where I am stuck and wondering if there are solutions:1) Finding the records: My conditions are the name of the program and the date, but the issue is with the date. I'd like Airtable to only find it if it's the exact date in both tables and not a range of dates. Is there a way to do this?2) Updating the records: when staff submits a form, they may ask for the topic (field) to be updated, but will leave the content (another field) blank because that d

What do I do to solve this problem? I’ve been trying to join in with my new colleagues but can’t accept their invitations. I get this message over and over with no instructions on why it’s happening or what to do next. When I type the Airtable message into the Airtable support searchbar I get over a hundred hits but none of them tell me how to fix the problem. When I go to Google for help the search engine autofills my question right away, which tells me that lots of people are having this problem. I wonder why Airtable does not help people in this situation, but I really need to know what to do next.

Our team has fallen deep into the airtable ocean! We love them and so do our clients...That said, we now have so many bases, tables, interfaces, etc. that it's getting difficult to remember where things are or who created what.I'm hoping that something already exists that will easily allow me to take and catalog all the various workspaces, bases, etc. easily without needing me to go into each one to create a new table(s) that have this information in it.If no extension or tool exists, perhaps someone could share a table structure they already use to maintain order in their chaos? I need to set up something quickly!

I am the owner on a team account. I have 2 creators and 7 editors. The 7 editors are not on the entire workspace, but rather on the bases I want them to have access to. I have one base I'd like to create, but I don't want my other two creators to have access to it (sensitive budget information). But I can't find a way to do that without taking away their creator status and I want them to keep that- they've been instrumental in building bases and will continue to do that. 

Hello,Currently, we use automations integrated with Slack, where we utilize the "actionable message" feature to allow users to approve or decline directly through Slack. We are now transitioning from Slack to Microsoft Teams and would like to know if the same functionality is supported in Teams. Specifically, can we enable actionable messages in Teams using automation?Looking forward to your guidance.Thank you.

I am having trouble understanding the WORKDAY_DIFF and DATETIME_DIFF. Primarily I need it to return hours and minutes within 5 working days. Not just whole days with the WORKDAY_DIFF and not just total hours and minutes including weekends with DATETIME_DIFF. Example: Start a project at 4:25 pm Friday and finish at 9:40 am Monday, I would like my Turn Around column to say 2 hours and 15 minutes (2:15). I do not need it to round up to the nearest whole hour. I would appreciate any help you can give.

I need the dollar amounts on our automated emails to be automatically rounded to the nearest cent. The automated email is pulling these figures from fields in airtable that have formulas associated already, and they are set to round to the nearest cent/hundredth, however when they come through on the automated email suddenly they include an extra place value "thousandth," and do not provide thousands comma markers or dollar signs. I do not know how to combine a ROUND formula on top of the formulas that are already on the fields. Can someone help? 

I have a board for projects and one for tasks. Team members are pretty good about entering their project due dates on the project board, but we need to have due dates on the tasks as well. Id like the task due date to default to the project due date, with the ability for override. Ive created a lookup field on my tasks board to find the project due date (default date), but often the tasks need to be done before the project is due so i would like it if the field could be manually overwritten. I was thinking if i created another column in my task table with a formula that allowed team members to overwrite the lookup field this could work. It would say something like {lookup date} OR manual overrride.Is there a way to create something like this?

DATETIME_DIFF(  TODAY(),  {Fecha de nacimiento},  "years") & " años, " & (DATETIME_DIFF(    TODAY(),    {Fecha de nacimiento},    "months"  ) -   DATETIME_DIFF(    TODAY(),&nb

Hi. Corporately we are starting to use MS Planner, has anyone achieved any level of integration or linking with AT please? Ideally I’d like end users to be logging tasks in planner and they are automatically logged in AT. Regards Rob

I can't figure out why an automation is not performing as expected.You can view the test base here: https://airtable.com/appvus4mpIsM95P1S/shrcfwha5Sx1NEui9Please see the Content, Tasks and Task Templates table.The logic behind the automation is that when the podcast status on the Content Table is updated to "In Progress," the automation will generate a set of tasks for that episode. The automation looks for records in the Task Templates table under the Podcast View and duplicates those records in the Tasks table.The automation is creating extra records in the task table and I can't figure out why. There is no pattern to the extra records created. I've tested and tested and it's not the same duplicate records each time the automation runs. The extra records created in the task table break the date dependencies."Start Date", "Deadline",

In our base, there are about 10 people from 4 different departments. They are all editors, and we're on the business tier. We've started to build quite a lot of interfaces, and it's starting to get a little crowded. I wonder if it's possible to only have certain people able to see and access certain interfaces?The documentation alludes to the possibility of sharing the interface. However, I can't get it to work, as anyone seems to be able to see and access all the build and published interfaces with or without sharing. Is it possible to restrict access to certain interfaces if they are base collaborators? if so how do I do it?

Is this a bug, or am I missing something?My left side axis (first y-axis) uses a formula percent field. But I want the second y-axis (Y-axis (right)) to just be standard numbers in order to show the COUNT. The percents showing up don't make sense there. Is there a way for me to fix something I'm doing?   

Help! I'm trying to get an estimated calorie count using workout time, weight, and intensity. My workout time field is a lookup field formatted as duration. The weight is 160, the duration is 39:00 and it is moderate intensity. The formula is returning 16,770 instead of 279.5.  What am I doing wrong?Original formula:IF({Workout Type} = "Primary", IF({Workout Intensity} = "Low-Intensity", {Primary Workout Duration (Minutes)} * (4 + (({My Current Weight} - 125) / (185 - 125)) * (6 - 4)), IF({Workout Intensity} = "Moderate-Intensity", {Primary Workout Duration (Minutes)} * (6 + (({My Current Weight} - 125) / (185 - 125)) * (8 - 6)), IF({Workout Type} = "High-Intensity", {Primary Workout Duration (Minutes)} * (8 + (({My Current Weight} - 125) / (185 - 125)) * (12 - 8)), 0))), 0)

Our organization is currently on the team plan and as owner of the team plan, I want to grant owner permissions to another user but it seems this is not available on the team plan.  Is that correct?  If so, why not?  Please consider improving user management on the team plan.  It is not very user friendly and limiting.  

I have a field that sometimes has a mentor's name in it, and other times (usually) is empty.I am showing that field in a timeline - which is fine when there's a name, but otherwise it shows up as "(empty)" which is annoyingI want to create a formula field that shows the value when there is a value (a name), but shows something innocuous - like an asterisk - when it's empty.I feel like this is an IF statement - but the value of the field is different all the time - Joe Schmoe, Jane Doe, etc.IF({Mentor (from Link to Forms)}, "", "*") is what I'm trying now, but it's giving me a blank where I want the name. What is formula for "the value of the field

I am trying to get this to change the retention stage to month 2 when then 1st day in the field is one month ago?I have done this and whenever I am testing and changing the 1st day in the field to over a mo nth ago it does not even register the trigger on the automation history? Any ideas what I am doing wrong here?

I have an Airtable base with two tables: “PT” (where students submit a form to reserve a date) and “Available time on Math Classes” (which lists all possible date/time slots as text in the format “M/D/YYYY h:mm A” as a linked record). In PT, after a student picks the first date, I use a formula to calculate three more weekly dates. Then I add a filter to find each date in “Available time on Math Classes” and hide them, so whenever the students are willing to book a date and time the other students can't book the same date/time.Despite having matching text formats (and manual searches confirming these slots exist), the Find records step in the automation always returns “No records found.” I need help pinpointing why the automation won’t recognize an exact text match and ensuring these additional dates are properly found and marked as booked. Or I need a way tha