Other Questions

When a base is integrated with google drive, are the data/attachments stored by Airtable, or are they stored by google? I’m making a base that needs to have a good deal of photo and video, and I worry about hitting storage limits (not enough to warrant getting an enterprise plan, currently on pro). If the files are stored on Airtable, does anyone know of an elegant way to do something similar (store base contents externally, but access via airtable)?

Since yesterday's UI update, when selecting a date, "Today" is no longer highlighted. It used to be and this allowed the user to quickly be aware of today's date, instead of having to take the time to check today's date, orient themselves within the calendar and then select their date based on today. There are a TON of use cases where this is important and there is no reason why it shouldn't be there. I hope this was an oversight with the new UI that will be quickly fixed and not an intentional decision. Obviously the highlight should be something less vibrant than the actual selected date (just like before). 

Hi everyone,I would like to be able to find all occurrences of a URL in a base, regardless of its substitution text.Allow me to explain our issue:We use an Airtable base to automatically publish content on a website. This content contains rich text formatting for SEO purposes, including links to pages from and to our website.Frequently, the URL of these links changes. So, we need to find all occurrences of a URL in the base, regardless of its substitution text, in order tu update the URL.We did not find a way to do that. Is there a way to achieve that, or do you have a solution to suggest?Thank you very much,Elisa

Hi,I am new to Airtable, but hopefully it makes sense what I am trying to achieve. I am creating a product database that will include product name and it´s ingredients. I want to be able to tell if a product is vegan friendly, not vegan, or unknown based on the ingredient status.For that, I created a separate table that stores ingredient names as a key and their status (vegan friendly, not vegan, or unknown). Almost each ingredients have synonyms that have to be included, but the synonyms should be treated the same way as the main ingredient (as for the status). So I created another table that stores synonym name as a key and their respective ingredient as a foreign key. Back at the Product table, I want to be able to add product ingredients and for Airtable to check the Ingredient list and Synonym list and assign the status for the product (non vegan - if there is at least one non vegan ingredient, vegan if there are no non vegan or unknown ingredients and unknow - if there

Hi All,I've spent quite a lot of time trawling through the forums trying to find an answer to this questions but can't seem to find anything that can work for me (i've got a horrible feeling that what I'm trying to do is not possible!)So, I currently have two tables.1. Project - This table pulls in from an Outlook calendar when all of our projects are stored. I then use various filters to pull up only the jobs assigned to me.2. Tasks - This table lists 14 todos, which are the same for every project. Each task has a deadline that calculates based upon the date of the project or the date of a site visit (for example, the Risk Assessment is due 2 weeks before the event and each event has a different start date).I'd like to find a way of assigning all of the tasks to each project as they come in, so I can see their workflows on a gantt and then tick them off as their completed. The assignment of tasks doesnt need to be automatic, but quite straightforward (filling the cell with the ids of

Hello Airtable community,I have had a working automation on Make, that started throwing errors:I’m using Make, Airtable and Gmail to send out low volume notifications.In Airtable, the email recipients are stored in a rollup array.I cannot get Make’s Gmail module to send one email to multiple to/recipients.What I tried so far:Turn the To field’s mapping on/offSwitch between array and textUse split/join with comma seperator on MakeHas anyone else struggled with this?

HelloI have a 20Mb attachment (so not huge) which refuses to upload.  It gets to 10Mb and just freezes.Any reason for this?  The attachment opens fine in my Mac and 20Mb is hardly big. Any help much appreciatedAndrew

I have a table with multiple tabs that delineate project categories (I’m in Marketing so eblasts, social, blogs, etc.) and each of the items has an “owner” field with a collaborator assigned. Is there anyway to create a view or additional table where I could log in and see all the projects I’m working across all those tabs? I know within one tab I can filter for things assigned to me but I’d love to see everything I’m working on easily in one place

Hi. I want to use features like record coloring and manage fields, that are in the Pro plan. Others also use my tables, but I'm the one who would use these feature. Can other users see the result of my changes if I'm the only one with Pro plan?

Hi, i have problem with form responses, so i have created form from multiple table but there's no option to get from responses, is there something missing or i need to do something for someone who fill the form can get the form responses?

Hi,Sorry about the newbie question: via scripting, I´m trying to import a csv using .parsedContents however my csv has several spaces and non-AlphaNumeric characters in the headers so when I come to map the fields I don´t know how to specify them, for example line 4 in this snippet there´s a space between LAST and NAME:1 let newRecords = fileRows.map(fileRow => ({ 2 fields: { 3 'Email': fileRow.email 4 'Last Name': fileRow.last name, 5 } 6 }))As I have several files to import several times a month I would not like to have to "cleanup" the csv in some other spreadsheet as it´d defeat the whole purpose of using airtable as I already have (an ugly) way of doing it all in excel.Or is there a way to use the extension CSVImport via scripting using a predefined csv>table field pairing for each table?Also, I´m wondering if it´s possible to run a script any other way apart from the side extensions panel.  Is there any way to have a custom but

Hey there!Started playing with the new "List" view type and noticed that there is no way to reorder "Level 1" records. When I hover on a record, I can see the icon that usually implies ability to drag and drop the record... but when I try to do this - the record just gets selected (check mark on the left) and nothing happens. I know how to reorder records on grids. I made sure the view doesn't have any sorting rules or anything else that could interfere with the drag and drop function (reordering)... and nothing helps. Is this a BUG?p.s. thanks to the Airtable team for the new view type! I'm overall enjoying it so far.

My code is really long so I'm not posting the whole thing, but here's the gist:  let choice = await input.buttonsAsync('Is the stock received from a pending order, transfer or unsure?', ['Pending Order Received', 'Transfer', 'Unsure']); if (choice == 'Pending Order Received') { //code here with no errors } else if (choice == 'Transfer') { //code here with no errors } else if (choice == 'Unsure') { //code here }  I'm getting this error with the last if statement for 'Unsure' and I don't know how to fix it:

I'm attempting to create an invoice and all fields are pulling in except one. No matter what I do, it isn't being imported into the Google Doc. Here's the formula:"$" & {Materials to Plain Text} & ".00"The formula works fine and returns the value I'm looking for in the base, but it won't come into the Google Doc. All other fields are coming in as expected. What might be going on?

I added all my files to my projects a few days ago. After I uploaded them, I realized I was WAY over the limit. (I had misunderstood how that worked). So, I went through and took out all of the photos and voice recordings. It got me back under the limit. I decided to add links to my published articles for each project. As I'm doing so, I realized I was over the limit again.What all goes into the amount of space that causes an account to be over the limit? Right now, upgrading plans isn't something I can really afford but I can't keep going forward in adding things to this chart if I have no idea what the parameters are. By the way, I've looked at the tutorials and either this question isn't answered, or I missed it.Thanks.

I know Airtable was experiencing issues this morning but I continue to have trouble with bases not loading. Anyone else? I have tried all recommended troubleshooting and one base in particular that is showing an issue with records loading is one of my smallest datasets, so I am confused. 

I'm creating a project management platform and need some help in terms of organising tables.I have three different tables:Users - containing private informationProject - containing projects we haveProject participants - containing a row for project name, user id, and custom fields (columns 1,2,3) which contains information about that user for the project only. For example project user id or if they are participating in the project currently.I'm having some hard time as we use Softr for this development, and I would like to be able to allow a manager to add or remove participants to a project via the project participants table. That is at least the workflow I have now, but might be that it needs a full redesign. Anyone who can help on suggestions and best practises?

I have granted external 3rd party apps access to a base for testing purposes. How can I remove this access again?

Hi everyone!I want to get Cell values with ID from multi select field by field id of a table using php.https://prnt.sc/HasxED_1cZTbI have a table named "Cand", and there is Irish_Affinity field in Cand table.I know the field ID of Irish_Affinity.So, I want to get Cell values with IDs based on Irish_Affinity field id using php.I can't find any fomulas in airtable API.Is it possible?Please let me know, thanks!

Maybe someone knows what to do… We use Airtable for order management and are filling in new orders with a form. If a new row is created by form, prefilling cells doesn’t seem to work (we have a column for the approriate amount of VAT which is used to calculate the right invoice amount). The cell is correctly prefilled IF we create new rows straight in Airtable without using the form. This seems to a bug, right? Or does anyone know how to fix this? Thanks!

Hello community, there's an overwhelming number of suggesting apps (eSignatures, Docupilot, SignRequest, PandaDocs, SignNow, PDFFiller, DocAutomater...) to create docs with an e-signature from a template. I'm particularly looking for a recommendation that works with Make/Integromat and supports line items to build dynamic pricing tables. Thanks!PS: Alternatively, what service would you recommend to add e-signatures via Make to unique Google Docs.

Hello,I have been building a database for my small newspaper/publishing company. We want to track accounts information, ad orders and runs. It's important information.It seems to me on the pro plan that anyone can share any table by default is they're able to add data?? How can this be? Is there a workaround? If I hire someone, they could theoretically share the data with someone else or clone the entire database without my knowledge? I've read the other posts and documentation and this seems to be the case...Can anyone enlighten me on this? It's such a glaring issue that it is making me stop the Airtable process. Is this better controlled in Enterprise?

Hello, I’m trying to send a Javascript array with multiple values to my Airtable (multi-select field). Array example: var colors = [ "#4BC2A4-a", "#4BC2A4-b", "#4BC2A4-c", "#4BC2A4-d", "#4BC2A4-e", "#4BC2A4-f", "#4BC2A4-g", "#4BC2A4-h", "#f4a261-j", "#f4a261-10-k", "#EF616C-11-l", "#EF616C-m", "#EF616C-n", "#EF616C-o", "#f4a261-p", "#f4a261-q", "#f4a261-r", "#f4a261-s", "#EF616C-t", "#EF616C-u", "#EF616C-v", "#EF616C-w", "#f4a261-x" ]; But Airtable creates only one unique item with all the values inside: How it should be: How I should format the array to make sure Airtable will separate the items by comma ? Thanks.

I tried to set up a Zap to create detailed events in Google Calendar when new records enter an Airtable view – the Zap will NOT work (error 400 bad request) if I try to update the event's visibility (public/private) through Airtable mapping. So my question is WHAT kind of field in Airtable will cooperate with updating event visibility in Google Calendar? Through Zapier, when mapping Airtable fields, there are options to select the calendar default, public, private, or 'custom' where you can then map the Airtable field. I selected 'custom' and have tried a single select, multi-select, and even (ick) a single-line text field to be able to update event visibility through the integration, but no luck yet.  Any advice?

Hello, I am relatively new to Airtable and I am having difficulty creating a simple clustered bar chart in the chart block. In excel my table and chart looks like this… Any suggestions?