Other Questions

I am new to Airtable and would like to know the best way to build the architecture around data and tables from you people who are more experienced Airtable users.More specifically I am building a Supplier database of approx. 100 suppliers. Each supplier have a unique ID as identifier. I would like to share this ID across tables, so that the records are linked to each other based on the ID.When creating a new record (supplier) in the main table, then I would like this record to be auto-created/displayed in the other tables (or than one can only add data for records that exists in the main table)My idea is that the main table is for the key supplier information and other tables are for grouping of data.Like tables for:Main tableContact informationPrice informationIntegration informationlogistics informationetc.What data architecture do you recommend or do you have a better proposal for how to build an intern

Hi there. Does any know how to prevent my csv data from breaking when I transfer it from a csv export to my spreadsheet?Problem (CSV Export Bug): When I export the data, a piece of the notes column rolls over into a new row, resulting in additional rows that are unrelated to any record.Thank you in advance! 

Greetings All,I have recently created a base paired with an interface that I believe could serve as a beneficial template for users seeking similar functionalities. It's important to emphasize that the key functionalities and features of this proposed template are primarily housed within the interface designers, relegating the base to a backend role.I am keen on making this template publicly accessible, and I wish to accentuate its interface-centric features prominently. Although I am considering the Airtable Universe as a potential platform to share this template since it seem the only spot for sharing "base" templates, I am uncertain if it is the ideal place given the significant interface-related features of my template.Could anyone suggest the optimal method to share this base and interface as a cohesive unit?Appreciate your insights!

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?

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 Va

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 funct