Ask the Community

Hi. I’m not a coder and I’ve only been using Airtable for a few months. I’ve mostly used chatgpt when I’ve come up against something I can’t figure out on my own (which is mostly anything that requires coding) and it’s mostly done OK with a little back and forth. For my current problem it keeps giving me bad info so I’m turning to you all. I’m building a database for my company to track various data points about the projects we manage. I have a table called ProjectsList for this. For each project, we get many associated elements and I try to capture various data points on each element. This is done in ElementLog table. When we receive a schedule for a project, I log ScheduleStart and ScheduleEnd. In a normal world, every schedule would be a 5-day workweek and have the same holiday days off, etc. and it would be easy to set up fields that count work days/weeks between schedules, can do countdowns from today to start date, or tally days remaining in the schedule if we’re within the sched

Hello everyone,I'm experiencing an issue with one of my Airtable bases and a Google Drive synchronization. For the past few days, a specific table that is linked to a Google Drive folder has stopped syncing. I haven't made any changes to the base, the Google Drive folder, or the synchronization settings.The error message I'm receiving is: "Unable to sync new data."I've already tried checking the connection to Google Drive and restarting Airtable, but the issue persists. Has anyone encountered this error before or have any suggestions on how to resolve it? Any help would be greatly appreciated!Thanks in advance."

I’d like to use AT to create a Directory of our 400+ members.  I’ve set up the fields + form for Members to submit their details. I would like to also use this for our internal team - so they can record notes of all calls with each member and other details.  I understand how to create hidden fields that the members don’t see, however I’m unclear on the best way to create the “member notes” piece -- should I link to a Member Notes document on our Google Drive or can I do this all inside of AT?   We will be asking Members to complete the profiles and for those members who do not, we will add them but keep their profile private.  I’m unclear how to do this also. I’m also unsure how to set up my team members to be able to access the directory backend to add notes.  I’m on the free version and hoping to not require an upgrade.  Any help is welcome!  I am not a ‘techy” but feel confident it should be relatively easy to do.  Thank you.

pro back up vs on2air. Which is the best and safest way to back up airtable data

Hi all - I am looking to see if anyone has information on the safety of using Pro Backup as their main backup program for Airtable. Our company is needing a backup for our system and this seems to be the best one we've landed on, but we can't get a straight forward answer from Airtable on if they feel like it is a secure company to work with. If you or your team uses Pro Backup, I'd love to hear about your experience and if you feel like your data has stayed safe. If you don't have experience with Pro Backup but have another backup program/system you recommend, that would be helpful as well. Thank you!

Hi,I have made a mistake in one of my automation, and what was supposed to run 1-2 times per week ran over 20 thousand times overnight. Luckily this happened on May 31st, so I did not need to wait for my quota to reset. However this made me wonder if there is some kind of safeguard feature in Airtable that would, for example, maximise the number of daily runs for each automation?

Tengo  una duda pudo con alguna automatización llevarme datos de una base a otra ?

I made an excel sheet a few years ago to help with generating a prefill form link.I hope it helps you! https://www.dropbox.com/scl/fi/gfzbhrx7fwns17kpxq7gb/Airtable-Prefill-Link-Generator.xlsx?rlkey=6sa39tyrcjd49senl02n7jbl4&st=fyoer74g&dl=0

I am newish to AT so maybe I am missing something.  I have read a few, slightly older, threads where users are looking for a two way sync solution and there have been many third party for a few solutions to their connection needs.  I don't need a two way sync, looking for one way from Sheets to AT.I am working on a project to link multiple content calendars and projects. Some of those calendars live in Google sheets, in the future we may be able to lure those teams over to using AT but that is not in the cards at the moment.What I am looking for is a solution that does not require us to have a subscription to yet another service.  I mistakenly thought that AT would have been the solution for these calendars that live in different systems.Is there a way currently to one way sync a Google sheet to AT?  I want AT to be the source of truth but the teams will be working out of sheets to make updates, so would just need those updates to be reflected in AT.  Updates c

Hi I receive email orders and would like to add the received emails to the order record in my Airtable. Tried a drag and drop but this transfers the message from Outlook as a .msg, which can’t be read. Occasionally there are multiple emails, and I would like to have them all in the same place, with the particular order. Any help appreciated!

Hi all 🙂 Please, is there any way so I can convert emails to PDF?I have a TaskRobin integration, and would like to save my incoming emails in PDF format.Thank you 🙂

I created an interface designer page of the type “list” and it show perfectly  on the desktop client. In this list there is only 1 field (= primary key field), about 30 characters wide. But on my iPhone, the field gets truncated, showing only the first 25 of it, following by 3 little points (...), although there is a lot more space ( I estimate around twice as much). Is there something I can do to prevent this truncation  ? Or is this a standard behavior of the mobile interface designer ?

Hi everyone, I’ve searched the community but only found some older threads on this topic, so I wanted to bring it up again. Are there tricks/workarounds that do not including setting up rules within mail-inboxes to just delete the notifications? Right now, I can follow or unfollow comment threads manually, but it’s tedious to manage this every time. I’d really love the option to set a default notification preference—specifically, to only be notified when I’m mentioned. Having a global setting like “Notify only when mentioned” would make the interface much more manageable, especially in bases with a lot of activity.

I have discovered airtable in the last few days, so very amateur! I have created my first couple of automations to send an alert to managers e-mail when specific actions need to take place. The trigger e-mails include complete an absence review meeting if a staff member exceeds Bradford score of 150, and another is complete punctuality investigation meeting if employee is late more than 3 times in a month for example. The information like absences, probation due dates, lateness are stored in different bases. I would like to know whether it is possible to use these alerts to create a task list from all bases so I don't have to go into multiple bases and tables to find outstanding tasks. I would then like to be able to upload an attachment of say a performance review and this to automatically update to a completed task. Thanks in Advance!

I need please a automation with the following logic:I have the table 1 with the name: “table_data” and a table 2 with the name “table_email”.I need please the following logic.Step 1:If in table “table_data” all existing entries with same “email” and same “finish_date” has the “status” = “Fotografiert” we must do a entrie in table “table_email”.In table “table_email” we write the following fields from table “table_data”:salutation (in table_email = email_salutation) firstname (in table_email = email_firstname) lastname (in table_email = email_lastname) order_id (in table_email = email_order_id) finish_date (in table_email = email_finish_date) number_records (in table_email = email_number_records) email (in table_email = email_email) Step 2:Each 2 minutes we proof if we have a entry in table “table_email” without value in field “email_send_date”. In this case we send a email (lets say the one with template name = “email_done”) to the email address from from field “email_email”.Thanks ver

Hi Dear community I'm building an app for kitchen management specially recipe costing Need somebody to guide me for developing the apps introducing interface and adding tables for inventory management I'm  new and passionate to aittable  Please give me advice without costing a fortune .…Kind regards 

I’ve seen a lot of requests for specifying Today() as a prefill option for a date field, but I haven’t been able to find any asking whether you can pass Airtable a specific date as a prefill option. Is this a thing?

Hello All,In one of the columns in my Airtable, I would like add my Amazon affiliate link to the Amazon Product URLs so when the product is integrated to my website, selection of this product will have my Amazon tag in the URL. I am having trouble with a formula to create the new URL. Any suggestions? Thank you!

I have a table, Calls, that will soon have lots of records and lots of data.  I would like to provide the user with a simple interface to add a new call.  Each call contains linked records to other tables -- e.g. “Liturgical Date,” “Prelude,” etc.I would like the user to be able to select from a list of existing linked records , or to enter information for a new record for that field if it doesn’t already exist.It’s very straightforward how to allow the user to select an existing linked record.  However, I can’t figure out if there’s a way to let them add a new one on the fly. Does this exist?  I’m really hoping so, since if not, the data entry will be very tedious at first, if the user has to go to one interface to input all the liturgical dates and music, and then to another one to select them.Thank you!

I have a dropdown menu in a form that is linking to another table. The other table has dates and a label for each date. I need the dropdown menu to show both the date and the label for the user. It currently only shows the date in the preview.

Hi,I have set up an email automation using Outlook. Is it possible to add my email signature to this email and also change the from name to the business name instead of my personal name?

I’m attempting to set up air table to distribute parents possessions between 10 siblings Scenario:  If there are 100 items and 10 lots of 10 items each.  Each sibling wishes to receive a certain decoy, a certain lamp, and a certain painting. Sibling one rates, only three items, the decoy, the lamp and the painting. Sibling 2 enters a rating for virtually every item on the lists Sibling three enters a rating for 30 different items on various lists that she desires, leaving the rest blank.  Under this scenario, my understanding of the program is that sibling one is almost certain to receive at least one of the three items she covets.  Sibling 2 is highly unlikely to receive any of the three items. Sibling 3 has a middling chance of receiving one of those three items. Am I correct?   

I’m trying to troubleshoot an error that’s coming up on a Zap of mine with little luck. Everything works except the last step, which involves updating a field in Airtable with a ticket ID retrieved from Freshdesk. I receive the following error: Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct. I’m not having much luck with this one because I have the exact same zap set up for another table in the same base, exactly the same way, and that one returns no such error and runs successfully. Just to go through each part on this step:The airtable account and action (Update record) are correct, same as the zap that is working properly The configure step connects to the correct base, the right table, and references the record from previous steps and the retrieved freshdesk ticket ID, same as the properly working zapBut for some reason, this one gives the error when a

I found a similar thread from four years ago but was unable to reply. I use Airtable personally, for freelance work, and for my 9-5 all with different emails/log in credentials. I would love a way to easily toggle between these things without having to log in and out every time and to avoid getting access error messages when following a link. Canva and Google both do this very easily. It would be great to be able to do so in the desktop and mobile app. 

I'm setting up an automation to find records from webhook data. The field I need to match appears grayed out by Airtable with an error, "No valid nested options". Please see image.I've never seen this error message before, and a google search was of little help.Can you help explain what this error message means and how to resolve it?Thanks!