Ask the Community

Hi! I have a grid view with two columns, Start Date and End Date, that I have been manually updating to curate a calendar. I have started tying some of these line items together through the new Predecessor features, and since then have encountered a major issue where Airtable will automatically update dates to 0000 and 4049 in my Start Date and End Date columns. Help!

Looking for someone who can support me with a quick consult for my non profit, Modern States Education Alliance.My imported data table has over 9000 institutions ("School Name") with their CLEP Score and Credit Information By Exam. I was able to create an interface to filter by School Name and then display all of the Scores and Credit by Exam in two columns. I also created a Form to understand If a schoolAccepts CLEP credit,How much they charge to transcript the credit,How many credits they accepted,How simple this process was.Our goal at Modern States is to make college more affordable and accessible to everyone. This interface will serve as a space for our learners to share their journey and provide an updated CLEP by credit search. At the moment the College Board and individual schools do not maintain current records of the college credit b

I have a date+time and a duration (days: hours: minutes). I want to add a day:hour:minute duration to the date+time and output a new date+time. Issues I've encountered:1. I can only set a duration field to be day OR hours/minutes/seconds. 2. When attempting to create a formula to add a "Day" duration field to a "Hour" duration field the output is incorrect. For example I have a Day Duration field with "1" and in the Hour duration field I have 00:05. I triedDATEADD({Next Output Days},{Next Output HH:SS},'seconds')   Results in #ERROR!SUM({Next Output Days}+{Next Output HH:SS})   Results in 301?I'd be fine with a result of the total seconds of the day + hours/minutes to use for my final for

Hey guys!! So I am doing a project, and a need an airtable with the name of a restaurant and the position of it (in coordinates), I will use an API to extract my data from my airtable, but I need it to be in GEOJSON. Do I use the map app? How can I do this? Thank you guys!!

Is there any way to display the Button field only if the URL field it references has data? So if {resource link} is null, don't display anything. We have some users who are confused when the button doesn't work (not all the records will have a resource link). These are views which are shared publicly and not Airtable users. Thanks!

Following is the error I encounter :  npm warn deprecated source-map-url@0.4.1: See https://github.com/lydell/source-map-url#deprecatednpm warn deprecated urix@0.1.0: Please see https://github.com/lydell/urix#deprecatednpm warn deprecated resolve-url@0.2.1: https://github.com/lydell/resolve-url#deprecatednpm warn deprecated source-map-resolve@0.5.3: See https://github.com/lydell/source-map-resolve#deprecatednpm warn deprecated osenv@0.1.5: This package is no longer supported.npm warn deprecated inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and te

Hello: Can you move a table to a different base? Thanks Julie

I am currently on the team free trial plan do I need the business plan to email non-collabaorators? I am trying to email every person I have on a table with the same email is there a way to bypass this through other services?

When applying this formula "{Pago a realizar}-{Pago efectuado}"  to the selected fields, as you can see in the 4 file, the result is not 0 but 1. How could I fix this error?

I have an Interface Detail Page that has a list of records.When i open a record it shows me a sort of modal column on the right and the url changes but it doesn't show an ID. Instead it gives me the "detail" parameter with a ver long string like this one "detail=eyJwYWdlSWQiOiJwYWdCeXBjZW9saHVvNXI2aiIsInJvd0lkIjoicmVjcXZseGk5SkJtcHluVXMiLCJzaG93Q29tbWVudHMiOmZhbHNlLCJxdWVyeU9yaWdpbkhpbnQiOm51bGf8".The question is where can i retrieve this long string?I'm working with Make so i want to change this parameter dynamically.I don't know if someone already asked this question, i didn't find any discussion with this problem so i made a new one.

Hello, We have a problem with our automation (see attached). Our client works with her clients with points. We already have an automation that is working > when an entry is updated in table X, create a new enter in table Y.Now, we'd like to automatically, when an entry is updated in table X (points available), that is automatically updated in table Y (for the corresponding line). We tried to change ID, fields, everything and we always have the same error. If someone can help !Thanks 🙂

Hello,I have three columns with multiple select options: Lecture (Mandatory), Lecture (Required), and Lecture (Optional). I want to automate the process so that if I add a new value to Lecture (Mandatory), it automatically gets added to the other two columns.For example, if "English Lecture" is added manually to Lecture (Mandatory), then "English Lecture" should also be added to the multiple select options of Lecture (Required) and Lecture (Optional). How can i do that using automation I have make some small automation but it is not workingSet the Trigger:Choose the trigger "When record matches conditions."Set the condition to monitor the "Lecture (Mandatory)" field for updates.       let table = base.getTable("Your Table Name"); let recordId = input.config().recordId; // Fetch the record that triggered the automation let record = a

In a gallery view interface, each record has one pdf file attachment hosted in Airtable. Airtable has two "stock" buttons for downloading the file.1. How can I track how many times each file is downloaded using the "stock" download buttons?2. Can I see which users are downloading which files? 3. Can I track which gallery tiles are being clicked on?4. Can I track what the most popular search terms are?5. If Airtable cannot provide the tracking, can GA4?

Hi! I am trying to create an attendance form that is able to create multiple records from a single form submission. What will be most convenient for our users will be a batch attendance as they login and log out at the same time.Im currently attempting this by using fillout forms. Im willing to try any options to achieve this result.Image 1:  Rows 1 to 5 is the output that i want. Row 6 is what i get.Image 2: What my form has to look like Appreciate all the help I can get! 

Hi everybody.My issue is the following: I have a make.com workflow in which I search for airtable records with which to perform certain actions, but it's not returning the expected result. Here's the formula I added to the airtable module in make.com:AND(DATETIME_FORMAT({var1} , "DD.MM.YYYY") <= DATETIME_FORMAT(NOW(),"DD.MM.YYYY"), {var2}, DATETIME_FORMAT({var2} , "DD.MM.YYYY") <= DATETIME_FORMAT(NOW(),"DD.MM.YYYY"), {var3}, {var3} != "N/A", {var4} != "Text", {var5}, {var6} = 0, {var7} = 0, {var8} = 0, {var9} = 1)I narrowed it down to var2 not returning the result I expect. So if var2 is "31.07.2024" and today is "01.08.2024", I get a 0, meaning Airtable is not the same opinion that yesterday is "smaller" than today. The strangest behavior. Does anyone have some advice?

I hope I'm not missing something but I'm trying to create a manual table to pull certain database numbers concisely. Basically mimic a grid of 7X4 but the numbers are huge making for unnecessary scrolling. Any advice would be appreciated or just a general sizing/formatting option beyond just colors.

Table A (Names) has a lookup field in Table B (Clubs).  I would like a field in Table B that lists all records from Table A that  looked up that particular record (club) in Table B.   In other words, I would like a field in Table B that shows all the names for a particular club.  How do I do this?

I am trying to group line items based on the below conditions, but for some reason it's not working for all the "Done" ones. It does work for the 2023 items that are marked Done in the status column, but the one 2024 item that is marked Done in the status column still returns the 2024Q3. I really hope this makes sense. IF(REGEX_MATCH({Labels},"(2024Q4_\\w)"),"Unscheduled",IF(REGEX_MATCH({Labels},"(2024Q4)"),"2024Q4",IF(REGEX_MATCH({Labels},"(2024Q3)"),"2024Q3",IF(REGEX_MATCH

I am building a table that creates a record for monthly billing. The billing happens on the same day each month. I have a Date Paid field and a Next Date Paid formula field, and an automation that triggers after the bill gets paid to create a new record with the Next Date Paid from the old record populating into the Date Paid field of the new record.The problem I'm having is with the DateAdd() function. My current formula is: DATEADD({Date Paid},1,'month')  I thought this would just add one to the month, but it actually just adds 30 days which means that my dates won't match up. I tried adding a field with a static number(MonthDay Paid) and doing something like: DATETIME_FORMAT(DATEADD

HelloHow to Condense record view so more values are visible in the popup window (less scrolling down)? 

Hi All,I'm trying to set up a resource tracker using the summarise function within the timeline view.In short, I want to be able take the days associated with a task and spread these across the length of the task. So if a task takes 20 hours and the task length is a week, then the summarise function would say 4 hours for each day and would group accordingly dependent on the scale we were looking at. I'll be grouping by individual, so want to be able to get this value summed across multiple tasks. This must be what the system is doing under the utilisation function, as it'll this to compare the available days to create the percentage, but I don't seem to be able to get it to work. When I go to summarise, and go to sum, it just shows me the total number of hours and doesn't spread the amount across the days. Crucially I don't want the percentage of available time used, I just want the number of hours themselves. Thanks in advance!

Hi,I have a table for faults and a table for handymen. Each fault can have multiple handymen assigned to it, and each handyman may receive a different payment—for example, one might charge $50 while another charges $100.Is it possible to create the same fault twice in the fault table to associate the fault with each handyman and thus set a different payment for each one?I tried creating another table that connects the faults table and the handymen table, and it worked wonderfully. This allowed me to associate all the handymen with the same fault and add a "payment" column so each handyman could receive a different payment. However, when using the INTERFACER, I faced a problem: I had to fill out a form in the faults table and then another form in the table that connects the faults to the handymen.How would you solve this problem? I want to fill out just one form. Is it acceptable to create the same fault twice in the faults table to associate i

I have a table which has the entire organization list of Key results. It does identify each Business Unit. I have another table where I have a list of projects (in the same base). I want to have a field with the projects where the person entering the data can a select the key result this project is associated with but I do not want the entire list of key results to show up, only the key results from that business unit. Is that possible?   

Hi,In Airtable, I have a table of faults, a table of handymen, and a table that combines faults and handymen.I want to set it up so that through the INTERFACE, I can create a new RECORD in the table of faults. Using the LINK TO ANOTHER RECORD field, if the desired value doesn't exist, I want to be able to create the new value through the form in the table of faults.Is this possible?

Hello all. I'm new to Airtable and I have been charged with setting up project and task management for our team. We have a team of about 10 with multiple projects and tasks that are randomly assigned based on availability and skill level. Each project has a timeline with tasks, start and end date, status and assignee. The assignee can have multiple tasks on multiple projects at any given time. My question is, do I create one base with each project as the master table or do I create a separate base for each project and sync the tasks, assignee and status. I need to have a calendar view for each assignee with all of their upcoming task due dates and ideally an overall calendar view for the team director who can see all upcoming tasks, due dates, etc. We also want to share the status with groups outside our team for each project, so the outside team can see the status of tasks and overall project status.There is another wrinkle in that help desk tickets also create t