Other Questions

Hello! How to link tables, but to include info in form of linked variants to choose from? Here is the deal. We sell cars. And need Airtable as a database to synch to our website. Our team members add cars to the database. The question is: How to make dropdowns in columns from linked tables, so they would “know” the previous column and provide an option to choose from a specific number of variants? Here is an example: We want to add a car. It has a lot variables, some of which are: “car maker”, “model” and “specification”. I would like to have a columns dedicated to each variable. But so if for example I choose “car maker” Mercedes-Benz, in the next “model” column I would get only Mercedes-Benz’s models, and after I choose, for example “S-class”, in the next column, “specifications” I would only be able to choose from that model’s specifications? How can I achieve that? Spent too much time trying to solve that problem Thank you!

Hi! Mailed support and didnt get a reply. So Im trying here instead. I understand one can have a conditional dropdown that adds all the values from a linked table. But what if I want to select between the values? Lets say I have TABs called “Company” “Office” and “Employee”. Now I would want to add an Office to an employee - but only the offices linked to a specific company. How would one do that? Im guessing using IF statements - but would it work for string values? Regards, Vincent

Helllo, New to the Airtable platform. I am wondering if this is possible. I am developing a manufacturing schedule and in the schedule you have a Phase and multiple (different) steps in each phase. Ideally I would like a (2) drop-downs side by side and the second one becomes dependent on what you chose in the first. So if i Choose Phase 3 the second column would only show steps associated with Phase 3 not all the others. Thanks

Requires Linked SingleSelect/MultiSelect Dropdown, which can be restricted on the basis of any criteria. In particular I need Dropdowns, which offer a subset of choices based on the result of another dropdown/field. For example, I would like to have a drop-down “LAND”, which gets the data from a separate table (LAND, REGION). The table would then look like this: COUNTRY, REGION Switzerland, Aarau Switzerland, Bern Switzerland, Zurich Germany, Baden-Württemberg Germany, Lower Saxony Germany, Saarland France, Aquitaine France, Brittany France, Poitou-Charentes …, … A second dropdown “REGION” should then only show the regions matching the selected country. Then the second dropdown should only show “Aquitaine”, “Bretage” and “Poitou-Charentes” when I select “France” as the LAND. If I look up in the forums, this is probably a very popular wish for a long time. Is something like this available now and if so, how does it work?

Hello Airtable Community.  I've reached my wits end and so has chatGPT 🙂  I am using the following scripting code in an Automation to extract some data from the record that triggered the automation and insert into an external API.  Most of it is working as expected until the very end of the first function where I keep getting   CONSOLE.ERROR "Error processing Airtable update:" "Unexpected end of JSON input"  I've tried lots of logs to understand the input and everything appears in order to me.  JSON is coming back fine in each of the "console.logs" indicated in the code here.  An example here:What could be causing this error?  Source code below:  // Function to escape HTML characters function escapeHtml(input) { return input.replace(/</g, "<").replace(/>/g, ">"); } // Airtable Script to trigger on "Terpene Tags" field update // Airtable Base ID and Table Name const AIRTABLE_BASE_ID =

I am hoping someone can help answer this basic question.We have a survey where our athletes answer using a ranting system. I want to take the rating once in airtable and assign it a number value. 1 star = 1, 2 stars = 2, 3 stars = 3, 4 stars = 4, and 5 stars =5 so I can total.Is this an easy thing to do or do I need to get the data into a number before it hits airtable?

Has anyone succeeded in merging Airtable data with InDesign CC layouts/style-sheets? :nerd_face: We’d love to be able to leverage online datasets to populate nicely designed layouts for PDF export. This export will be done both locally, as final artwork files for professional print; and hopefully… automatically. We’d :sparkling_heart: LURV :sparkling_heart: to be able to generate PDFs, in the cloud, using real-deal layouts, that can then be relayed/ingested via other integrated services like Dropbox, Slack, email, etc. How would you build an Airtable-InDesign CC-Google Cloud Print-Slack/Email stack? THANX YALL! :dancer: A.

I have a form built. Today I was asked to add an option to a multi-select field and published it. I added the option and it is showing in all views and in the preview, but it is not showing on the public-facing version of the form. I am not sure what I am missing that is causing the option to show everywhere except the public-facing side.

I’ve got two tables that I’m embedding in a Sharepoint page, using an iframe window. They work great, except that there’s some kind of splash screen showing the Airtable logo that doesn’t go away until the user mouses over it. Is there a way to disable this and have the tables load automatically without any user interaction? Here’s what it looks like before loading: Thanks for your help!

Hi  I'm familiar with the Maps extension in AT and using it without issue but I'm interested in making the map public and embedding onto a website. I've seen some posts about this coming at some point but they date back a few years and so I suspect that's not happening anytime soon. So my question is, what is the easiest way to do this? I understand there is a Google API (Many Map API's) and also some mention of Mapbox but they both seem over complicated for my usecase. This is a very simple request of maybe 10-15 points on the map that could change every few weeks. Has anyone done this, any pointers on the easiest method ? Much appreciated  Jason 

Hey guys,I am looking for a way to help restrict access to certain bases I have in my workspace. I thought using groups was the answer, but that doesn't seem to be it as the groups still have overall workspace access and I can't seem to remove someone who's in the workspace from a base.We have our workspaces separated by the different companies in our parent company and then within each workspace is a base for the different departments. I have groups for the different departments as well that I was hoping to use to have for example the GFX department have access to only the GFX base.Does anyone know how I should be using workspaces, groups, and bases to restrict access? I feel I am using these wrong.Thanks!

Hello,I manage an Airtable base for a motorsport event management company. Right now, we have to use JOTFORM for the customer registrations, because the company uses Authorize.net, and the client wants the registration form to be submitted with payment in the same step. Upon looking into Zapier, they do not support Authorize.net. (So if you know a workaround for this, we would LOVE to just use Airtable instead of two different platforms for customer registration.)But! That's not the main issue at hand. The main issue is that my client has a list of Instructors for these events that we are currently registering via a form on Airtable. However, the instructors have to fill out the entire form for each event, and this is a bit tedious and redundant, and causes us to have to go in and delete duplicates if the instructor has forgotten if they've registered for the event or not, and fills out another one. I have sifted through the community, and youtube, and still haven't been able to find a

Hi, I’ve created an interface from my base which I’ve tried to share with users who work off iPads. I’ve tested two so far and while the interface works on The iPhone app on the iPad no interface shows up

When I select a lookup field in Airtable, it retrieves all the values within it, but I want to make a selection from within this lookup field, is this possible?

I have a list of records that's something like this. PROJECT NAMEPROJECT VERSIONCONTACTASSIGNEEApples1JoeBobApples 2JoeBobBananas1SallyJimOranges1JoeJudyI receive a .csv report with the most recent information about the first three fields every week. The fourth field (assignee) lives only in Airtable. There are additional fields as well as notes and comments on the records that need to be maintained. The weekly report often includes changes. For example, a new "active project" may be added or something might change about the project, like the CONTACT field. Example .csv report:PROJECT NAMEPROJECT VERSIONCONTACTApples1JoeApples 2JoeBananas1JillOranges1JoePears1JoeWhat I'm trying to do is find a way to import this new .csv report and have Airtable update/merge the existing records that have changed (in this case, the CONTACT on Bananas project is now Jill) and add any records that didn't already exist (Pears project). The CSV Import extension only allows you

The Google Vision API extension offered by Airtable works well enough if one wants to retrieve labels, logos and texts from an image. However, the Google API offers other capabilities, such as tagging offensive images and, what interests me most, calculating the dominant colours of an image or suggesting cropping possibilities. The Airtable extension doesn't seem to give access to any of this.Is there something out there already that might allow me to retrieve those extra features and insert them into a field in my database ?Thanks.  

I am receiving this notice when attempting to upgrade: "We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us."I was charged and my upgrade has not been reflected. I contacted customer service but the 1-2 TAT turned in 6 days -- no response. Any suggestions?I would think a financial ticket would be considered important. 

If I have 5 blank rows, then values 5, 10, 15, and I sort by that column, those blank rows show at the top and I would like them to show at the bottom but the 5, 10 and 15 still sorted showing at the top. Is this possible?

Hi! I am new here.How to link the following text with a URL of the corresponding record when sending html email using sendgrid.<a href="{SM}">link text</a>The above outputs blank, where as just {SM} output the url. I don't know how to hyperlink it to that text. Thank you!--I would also like to know if there is a possibility to have a button on each record when clicked the email for that record is sent to the person on the record. I have an html email that variables from that record will be used in that email. Right now, I am doing the sendgrid extension to send emails to all records in a view with a filter. Thank you!

Hi All I am in early stages of learning formula functions, and focusing on date based formulas. One thing I have noticed is that dates created from formula calculations to not seem to work with the Timeline block. Has anyone found a way to make this work? Very important for me and hoping there is a solution. Thanks, Rob

Hey guys!I am trying to move a base I created to a new workspace I created. We have Enterprise, I am set as an ADMIN, but am not the owner of the base that I made to original base on. Does anyone know if there's a setting somewhere I can change so I can move it or do I need to get the owner to move it?Thanks! 

I have table descriptions that I want to edit. I am able to use the arrows to move around within the description section (including cmd+A on mac to highlight everything) but if I want to get to a specific area by clicking, the box stops responding (and I can no longer use the arrows to move around). I need to close and reopen to be able to use the arrows. Is this the way it is supposed to function? Clicking makes more sense and would be more helpful.

Hi, I install Airtable on my Galaxy Tab S8 the (Android) app display the database list but hang forever trying to load any database (small or large). No info, debug or data ...Any ideas ?It work better on the web version ...

Hi,i connected my Airtable to a Salesforce Report. Now the long text fields are cut and it does not show the entire Text.Is there a Solution to this problem?It is cutted like: Text Text Text...