Other Questions

Hi Airtable! This is a recent announcement from Integromat regarding the Twitter app. Mary Kay

I am creating a catalog of sheet music for some musical groups I play in. It has a main table with all the usual information to be expected (title, composer, arranger, etc.) plus some additional info, such as alias names and associated works or titles. All the information is either directly stored in the table, or is in a linked table (composers and arrangers, for example). The alias and associated works are useful. Some examples of these associations are: The title, “It’s the Hard Knock Life”, also has an entry in the associated works field indicating that it is associated with “Annie”. The title “Ukrainian Bell Carol” has an alias entry as “Carol of the Bells”. The “Hallelujah Chorus” has an associated entry indicating it is part of the oratorio “Messiah”. The point of all that is to indicate how useful this information could be in searching. For example, when searching for a specific title, I would also like the associated/alias fields to be searched for the same title. Now, I

Hello, I have started using Airtable recently and I find it quite useful. I am trying to create a structure as below: Company [All the companies that I worked/work with] ==> Project [All the projects that I have worked/working] ====> Tasks [All the tasks for different projects] To achieve the relation, I have used ‘Link to another record’ field type. I am able to relate Company table with Project, Project table with Tasks. On the Tasks table I am able to see the Project they are associated with, but on the Tasks table, I am not able to display the Company associated with the project for which the tasks are. Can you please guide me how I can establish this structure?

I’m capturing some insights from a focus group and I have columns representing the participants. I want to add tags for each insight, but I’d like to reduce the number of columns needed to accomplish this. Is there a way I can add the multiple select field type feature to long text fields? Thanks!

Hello! I’m trying to figure out how to get a copy of a user’s (the person filling out the form) submission automatically emailed back to them after they’ve completed a form. IE: when you make a purchase online and your receive notification via email that your order has been placed and it lists the items you’ve purchased. Is thing a thing or some thing airtable doesn’t offer yet? I’ve searched all over the help site and haven’t found anything. Thanks in advance!

Is there some way to create code that is shared between multiple scripting blocks? Either by external import from some source, or a native solution? Example: I have a function addClientToSession(clientRecordId, sessionRecordId) that I want to use in multiple blocks. Right now, I have to copy and paste the function into each scripting block or automation step I want to use it in, and if I want to update it, I have to be sure I edit every instance. I’d much rather be able to do something like import addClientToSession from "shared-block-id". If this is impossible, what solutions have other people in the community used to accomplish something similar?

Someone else on the team created a Dashboard using the Maps blocks. I am a Creator in the AirTable and anytime I go in, I do not get a map or settings. The Owner sees the Settings and map just fine. Any ideas as to what the issue is? Here is what they see: Here is what I see:

I’ve switched around the order of a few columns in grid view but this isn’t reflecting on Kanban. I would have expected the order of questions/columns to sync up no matter what view I’m in but this doesn’t seem to be the case. Help?

Hi guys, I’m in the process of setting up a product hosted on Airtable, selling the product through Gumroad (https://gumroad.com). Now, the idea is that people who purchase my product, automatically get added to the Airtable’s collaborator list using their email. Is there a bright mind who knows if there is a possibility of integrating Gumroad with Airtable (or some other external solution)? Your help is greatly appreciated. Thanks!

Hi all, I’ve been struggling with the SET_TIMEZONE feature for about 20 minutes now and frankly I’m over it, so I’m coming to you all. I’m trying to display the times that some orders were made in the local time zone of the person that made the order. I have three columns: Time Zone (which is the local time zone of the buyer), Order Time & Date (CET) (which is my time zone. all time stamps arrive in CET), and Order Date & Time (Local) (which is the field I am trying to calculate). I have set the following formula in the last column: IF({Time Zone}="Alaska",SET_TIMEZONE({Order Date & Time},'America/Juneau'),IF({Time Zone}="Hawaii",SET_TIMEZONE({Order Date & Time},'Pacific/Honolulu'),IF({Time Zone}="Eastern",SET_TIMEZONE({Order Date & Time},'America/Kentucky/Louisville'),IF({Time Zone}="Pacific",SET_TIMEZONE({Order Date & Time},'America/Los_Angeles'),IF({Time Zone}="Central",SET_TIMEZONE({Order Date & Time},'America/Mexico_City'),IF({Time Zone}="Mountain",SET_

Editors cost me–the owner–money. So how can I stop them from inviting new editors?

Sharing a base between a paid and a free user? on this thread there’s huge positive sentiment for a new permission-level on bases, whereby I as a paid user can invite people to have minor box-checking / status changing, comment adding functionality. In my instance, i’m maintaining a base for a tech business, and I work with developers and other collaborators who I want to give limited access so they can update tasks they’re assigned to etc. I don’t see why this thread was closed automatically, when the last reply from Airtable was years ago, and where there’s message upon message from people echoing the same sentiment with no response?

Hi, I’m creating two forms- one that an interviewer fills out at the start of the day, and one that they fill out at the end of the day. I would like both of those forms to go to ONE record which would be based on the date. This would include all the information from both forms. When I made the two forms and tested they each created their own record and the date is in there twice. Thank you!

I have a simple date in my table and I simply want to have the name of the weekday displayed (e.g. in another column). Does this work with a formula?

Hi there Airtable fam, I’m curious if there is a way to create an Airtable form that acts like a cloud based document? The use case here is I teach an online course and I’d love to have students submit reflections on certain lessons but I’d like them to be able to see and edit their reflections whenever they want to. Effectively allowing them to pull up the form at any time and see what they’ve written previously. Almost alike a way that Airtable can automatically save progress and allow the user to revist their posts? I think I might have to use a Google-doc-like experience but I don’t want to force people to have a gmail account. Thanks in advance :slightly_smiling_face:

I’d like to do a search across tables and download the results as a csv, or at least be able to extract some of the information I find (let’s say, all the email addresses of the contacts that come out of my search using the search block). Is there a way to do that?

I’m trying to find a way make Airtable use the info in one field to add an image to the image field by automatically searching the web for an image and select the first image that comes up. Either by script or some other suggestion. Any direction would help. Thanks.

I have created a PHP website driven by AirTable. I have a test subdomain which is password protected with a .htpasswd file and so this connects directly to AirTable API so users can see the changes they are making. To make the changes go live I created a compile script available on the test subdomain, which queries the API for everything we want, and turns them into json files which I put in the appropriate place so that the live website can just read these files with PHP and create the website. This works well but the website does use the attachment URLs for things like website images and attachments. I am aware of the fact these URLs are not reliable and may be subject to change but for the moment a simple recompile would update and make everything well again. Now though, I have a more high traffic website and I cannot take the risk of attachment URLs changing so I need some sort of solution which lets me download the images and put them somewhere else and then update the URLs in the

Does anyone know how/ if it is possible to highlight multiple fields and move them over together? I know in excel/google sheets this is very simple but I am having trouble with Airtable. The use case is that let’s say I decided to create 3 new fields for a table and accidentally added them on the right and now want to re-order them. To group the 3 together and move all the way to left side it looks like I have to do it 1 by 1 for now. Any ideas?

I want to insert images into automated email. I’ve studied markdown and I can’t do it.

Estimada Comunidad de habla hispana. Los invitamos a inscribirse en un curso básico de Airtable en Español para comenzar a explotar adecuadamente esta maravillosa herramienta, pero en tu propio idioma. Este curso será dictado en español y es completamente gratuito. Será el día jueves 3 de septiembre a as 18 horas (-4 GMT) y los interesados en participar deberán enviarme un mensaje con sus datos para poder inscribirlos. Si conocen gente que podría estar interesada en aprender a usar Airtable y no lo puede hacer por el idioma Inglés, esta es la oportunidad. Los esperamos en COMUNIDAD DE AIRTABLE EN ESPAÑOL.

Dear Community, I am new to Airtable. I am making my first block. I have a table with multiple fields. I want to make a Pie Chart with just two of the fields. I made a pie chart from the table but it includes all the fields in the table. How can I select just two of those fields? Thank you in advance for your help. Rob

HI all, I’m hoping for a little direction here. I have managed to write a script to retrieve a single record from Base B based on a Date/Time field in Base A. My problem is that I can’t figure out how to then extract a value from that response. The response looks like this (I have REMOVED record Specifics). I am trying to extract ‘Height’ 3.49 in this case, which is a number in Base B. I then plan to update the initial record in Base A using that figure (I think I can do that bit once I can get the number out of the response). Sorry if this seems very basic, but learning as I go. {records: Array(1)} :arrow_forward: records: Array(1) :arrow_forward: 0: Object 1. id: "REMOVED" 2. ▶fields: Object 1. Timestamp: "2020-07-28T12:10:00.000Z" 2. Date: "28/07/2020" 3. Time: "12:10" 4. Height: 3.49 3. createdTime: "2020-07-28T09:18:24.000Z" Script so far looks like this let table = base.getTable(“Table A”) let record = await input.recordAsync(’’,table ) var search = record.g

I have copied a template with good data to start. I have my own data in a spreadsheet. If I organize the spreadsheet to match the table will Airtable recognize items with the same first column and offer to NOT import, or merge the data?

I need to populate a field in a table using the latest form entry for a particular record. What is the easiest way to pull the latest information from one table into another table? See screenshots below: Here is one screenshot with information from one table that I want to pull to another table. As you can see, there are TWO entries that are ratings for a certain project. I ONLY want to pull the “Final: Avg. Rating” field for the most recent entry for a particular project into another table. I have a Date Submitted column, as well as an Auto Number column. And in case helpful, here’s the table where I want this information to go: