Have other Airtable related questions? Post here!
Recently active
I have a 'Learn more' URL link on each card, but when I click on it, it opens up to an expanded intermediary page showing the same link information. I have to click another time to go to the destined URL. Is there anyway I can bypass the intermediary page? Please advise. Thank you.
I got 3 tables: As you can see on table Lectures i started matching Lectures with Trainings one-by-one. But the list is very long. Do you have any idea how to match Lecturers with trainings on one table?
We recently updated to the business plan to take advantage of the two way syncing between bases. However, every time I try and update information in a field from the target base it gives me an error. We are a custom closet company and utilize Air Table as our CRM. Our designers each have their own bases that sync with our main base so they have access to all of their client's information and projects. We saw that the two way syncing feature has been added for Business level plans and were hoping to eliminate alot of work arounds so our designers could update client information, contract totals etc.Can anyone help me or suggest a different way for them to update information? We already utilize forms. Thanks!Amanda
Hello everyone. I am using airtable as a database for participants in programs, and every time a student attends a program, we have to make a new record for them instead of being able to hold all the info in one line. The reason is because if I make the program field a multiple select drop down (which is linked to another sheet with program information), if I group by program, anyone who has multiple programs in their program field will not appear in the group. Is there a smart way around this? At the moment, when students have multiple entries we have a checkbox field for duplicate records. This is inefficient.
Today any script that I was using remoteFetchAsync (to avoid CORS errors) is giving me this error: j: Error: Bad request: <root>.requestJson is missingThis error comes up on a few requests to different unrelated APIs. Additionally, some which work using regular fetch give this error when using remoteFetchAsync.These scripts were working fine until now. Any ideas?
I need to create a yearly calendar that shows each event that happens during the month. The entire year needs to be printed on one page. Each event needs to be color coded to show the person assigned to the project. (There are cases where more than one person is assigned to the project.) We need the months going vertically and the days of the month going horizontally. We’ve tried Gantt Block. The issue is that color does not allow multiple colors. We’ve tried Calendar View. It doesn’t allow you to view an entire year or see multiple colors. Linking to Outlook doesn’t allow the ability to print the entire year. Linking to Google doesn’t allow to the colors to be assigned. The timeline is too large to print and has the same issue with colors. Any thoughts or suggestions would be appreciated. Thanks!! This is the current version we do in excel. We’d like to have this done automatically via the Airtable information.
I would like to embed Airtable views into Dropbox Paper – seemingly simple, however it isn't working.In Dropbox Paper I select "insert media" and select Airtable, where I paste the code. I then get a message that says "You do not have permission to view this content. This view is restricted to a specific email domain.".My colleague has tried and is asked to sign in (but upon signing in the message to sign in remains). We have embedded Airtable content onto our live website using the embed code with no issues and all users in the Dropbox Paper have access to our Airtable so I am unsure what causes the error.Any help is greatly appreciated!
Hi - I have a field labeled "reporter." It allows me to choose and select from a dropdown list of all the reporters that have been entered into our system. Is there any way to manually add someone into a cell in this column who is not on our list of regular reporters (i.e. a one-time freelancer)? Please let me know if you have any insight into this. Thank you!
Hello, I'm trying to link two simple table to learn how to use a lookup field.I have two tables: Company and Contacts Info. I linked the Company Name field to Contacts Info table so I can lookup the contact. However, Airtable created new records in the Contact Info table (attached New Contact Info) . How can I avoid the creation for new records? just to a lookup like in xls...Thanks!
thanks in advance for your answers guys, it is surely quite simple as it’s been communicated 2,5 years ago already, only… now, the function doesnt seem to work any more : Just like @Carly_Taylor wrote here in this URL: Uploading Data via CSV - what is the best way to add images to each record? Importing / Exporting Great question! We provide a few different ways to import data into a base (these options do not import attachments) Import a .csv file into a new table in an existing base Import a .csv file into a new base, as the first table use the csv import block to add data to an existing table (this feature is included in our Pro plan)) use a third party service, like zapier, to integrate data/automate import. To get started with building a Zapier integration for Airtable, I’d recommend tak… I want to import bulk images using the + button and create multiple entries, one for each image. However, doing the exact steps (from a gallery view)
Hello,I have Table of people and for eveybody I have registration month by number. It looks like that: Name:Adam, Registered:9Than I have second table with courses. For each course I have assigned that people. The cource has its own month.For example: Yoga:Adam,Robert, Month:9I would like to have new column, that will include only the people that was registered in the same month as the course.The month is different for each course so I cannot use the filter function in rollup. Please help.
Hello!I'm having an issue where the CSV Import extension doesn't remember the columns I match. I’m skipping the option “First row of CSV file is headers” since I want to use “Column 1”, “Column 2”, etc. function to match them. This is because they’re easier to identify and I can't use headers since some headers of my CSV files are blank (and I need those columns to import), so using "Column 1" and so on is easier to identify.Once I configure this and upload one CSV, it uploads the information just fine. However, upon uploading another CSV, the tool won't remember the matching of the columns. What could be causing this?
So, according to the FAQ about the new pricing, multi-source syncing is no longer included in the Pro Plan (now "Teams").... am I reading that correctly? Does that screw over anyone else or am I alone in being frustrated about this?
I am trying to have Filemaker Pro send all records to a database in one of my Airtable bases, using a rest. Here is my filemaker script, with key/api blanked. Send to Airtable #Send a foundset of records to AirTable Go to Record/Request/Page [ First ] #Walk through the records and create a data package of records Loop Set Variable [ $Names; Value:"$Names & Case( not IsEmpty($Names) ; “,”) & Airtable::cJson" ] Go to Record/Request/Page [ Next; Exit after last ] End Loop #Put the required wrapper around the record data and URL endpoint Set Variable [ $URL; Value:“https://api.airtable.com/v0/______/Filemaker” ] Set Variable [ $Action; Value:"-X Post" ] Set Variable [ $Authenticate; Value:" -H “Authorization: Bearer _______\”] Set Variable [ $ContentType; Value:” -H “Content-Type: application/json”] Set Variable [ $Names; Value:"{“records”: [ " & $Names & " ]}" ] Set Variable [ $Data; Value:" -d @$Names" ] #Send the records to AirTable Insert from URL [ $Response; cURL opt
Hi there - I have the same issue that was posted in March of '21. I have a single Extension set up to import CSV data. This data is coming from an internal database with the exact same formatting, fields, file name - everything. And for some reason, no matter what I try, the mapping gets lost between each import. I’ve even tried to rebuild the Extension in the dashboard. Any thoughts as to what I can do to make the mapping stick? It’s not the end of the world, but we frequently want to sync data, so having to map all the fields each time is a real drag. Thanks
Hi,I saw several similar questions from past years, but nothing that could be the answer. Maybe somebody found the solution for that? I want to get rid of Cyrillic and use English characters and language, to present some data to international teamI have my Windows interface on English, and haven't any russian language there.I've also set it here and tried to re-login, but nothing changedand finally, with no luck, tried to change Location and use VPN with different IP.Is there any other ideas?
Airtable Friends! I have a linked field that is pulling records from our vendor database, which lives in a separate workspace. This database contains a master list of vendors, which admins update when a new vendor enters the game. In our main working base that contains the linked field, daily users can then add vendors to a specific record if they are part of that job. I need to check off that the vendor has been onboarded in a field next to the linked field which contains the vendors name. So I’m wondering if it’s possible to: -when a user adds a vendor name to our linked field, could it populate a multi-select field with the vendors name as an option? even better, a checkbox field.
According to https://support.airtable.com/docs/airtable-sync-integration-zendesk, automatic syncing happens around every 5 mins. But from my experience, it is around 10 mins. Is there anything to do to decrease it to 5 mins?
Sheet here: (can’t post due to new user) Column 1 is “Date” type with the time field disabled. Column 2 is “Formula” type: IF({Due Date} != "", {Due Date}, TODAY()) On row 2, if {Due Date} is empty, it automatically fills today’s date, ie, November 5, 2019. On row 1, {Due Date} if set to April 20, 2019, for some reason reports Due Date? as April 19, 2019. GMT setting is disabled.
hello the Community i am building in stacker link to an airtable base. But when i add a field in airtable and refresh the schema in stacker, the new field do not appear un staker thanks !!!
Hey guys !I'm using Pabbly to automate a process of generating documents with Airtable.Thing is Pabbly is creating PDF using Google docs and transferring them to Airtable, which works really fine.However, in the attachments, while the document has the good title in the viewer, the file name itself is automatically named "UC" without any prefix.So when I send it by mail, it displays errors, because it sould be "formation - Name.pdf"Do you know where does it mess ?Thanks for the help
GoalOur organization is hoping to move our annual application off of a very expensive custom third-party contractor's system (which we have to messily export CSVs from to upload to AirTable, then engage in substantial data cleaning due to issues in how the contractor's system structures data). The goal is to move the application to our org's AirTable Workspace directly. We're exploring ways to handle this smoothly, so I'll talk through the overall workflow/how things work now first and foremost, then talk about some of our initial thoughts about how to achieve this with AT, and then finally I'll talk about the things I'm not sure how to do (or if they can be done at all).Upfront, I am hopeful all this is achievable using AirTable Forms, but some things I've read elsewhere suggest that Interfaces might be a more appropriate tool. I'll use the term Forms from here on out, but answers with instructions for achieving our goals with an Interface or other built-in AT functionality are totall
Hello AT community! I have a table that automatically syncs to a Google Drive folder on regular intervals that was working until a few days ago. Now the automatic sync fails and when I manually kick off a sync with "Sync now" I get an error message saying "Unable to sync new data". If I go to "Update sync configuration", my Google Drive source is inactive and an error message reads "Unable to sync this source. Unable to sync new data"Nothing has changed with the configuration of the Google Drive and I am able to connect to it just fine outside of AT using the same credentials. I have tried connecting to a different Google Drive folder as a test, but I get the same error.Any advice on what else I should check to resolve this problem? The error message doesn't give me a lot of information about what could be going wrong.
Hello. I lead a marketing team that has enabled two-way sync between several team bases and a master base. The issue is that we aren't able to make any edits in the "master" base at all. All changes have to be made in the supporting bases. Now, we know from our Airtable builder session that we can't add rows in the "master", but we should be able to make adjustments to content i.e., status updates, etc. Any suggestions about how to fix this issue?
I have had a personal account for years and use it regularly to catalogue a high quantity highly importnat personal information. I opened the app yesterday and the login details no longer work, suddenlty returning the message that my email isn't associated to an active account. My account has seemingly been de-activated with no warning, no explanation, and seemingly no option to re-activate it. I wrote to airtable support to explain this very clearly and they sent me back a template email saying I should use the help centre (which I'd already tried) and declining to address the issue. I even said I'd be happy to pay to upgrade in order to regain access to my account. What is going on?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.