Other Questions

Hello all. May I check if the following is possible with Airtable and in-built Automation. Trying to use a Main table input to create a new record into a new table. However it will be created in a “selected” existing table base on Input field condition. E.g. IF “Group1” THEN Create at Table1, IF “Group2” THEN Create at Table2 I asked the same question to support and they suggested Script approach as below. " While our create record action is set to a specific table (making what you’re trying to do impossible for a single automation), you might be able to do what you’re looking to by building a rather complex [Run a script Action]. This is an advanced corner of Airtable – you’ll need knowledge of JavaScript to be successful here." If this is true, was wondering what Script resource is needed to accomplish this.

Hello everyone, I have been using airtable for a while now, to collect data about certain objects in a base with grid-view. Each line represents one object and I have different rows, characterizing the objects in different dimensions. Most of the rows are “multiple select” options with a max of 25 options which are freely combinable. So basically I have a base with around 120 instances and each instance is characterized in different dimensions. My interest now is to find clusters in a certain dimension which means I want to learn which options in a dimension have often been selected together. Is there a way of getting this done in airtable? The standard “group by” feature is working for dimensions (rows) where not many options are selectable but for dimension with more options it does not work in a sufficient way. I have difficulties in finding out if there is an app which could support my intentions. Also i have a free plan for now and can not just test

Hello, I have a table containing close to 500 records. I am trying to set up chart apps to analyze various attributes of the data. When I install the app and fill out the settings, nothing displays, just a blank, white screen where the graph should be. I figure this might be due to the volume of records? Do charts or apps in general break when record volume exceeds a certain quantity? Has anyone else ran into this issue? Thanks!

Hi all, New to airtable so need a little bit of advice. I have set up a form on my website to collect data and sent it back to airtable. Issue I am having is that I am trying to work out how to move data based in a row to another record with matching text. So for example if I had a student enquiring about ‘Science for Beginners’ and another for ‘Advanced Maths’ I would like to add them to the relevant sheet under that course group. Is this possible to set up automatically with zapier etc? Look forward to hearing from you. Regards, Mark

When I try to set up a graph with the Charts app, nothing shows up in the graph area. I’ve tried different settings, I’ve turned off my adblock just in case, and still nothing. Does anyone know how to get the charts showing up?

Hi everyone, Airtable is experiencing downtime as of approximately 1:20 pm (PT), and our engineering team is investigating the issue. We will keep you informed as our investigation evolves and we sincerely apologize for the inconvenience this has caused. I will be back in touch soon.

When I’m creating a view and adding existing fields to that view they don’t show up in the order that I’m adding them. Sometimes it will show up in the middle of other fields that I’ve already added. And I can’t figure out the logic behind where it decides to put the field. I’d like the fields to be added in the order I select them.

I have several charts (from my Airtable data) - is there a way to export them onto one pdf/doc?

How do I limit file upload to ONE file? I’m telling people to upload a pdf document, but I want them to upload ONE document if it’s multiple pages, not separate pdfs. If I can limit the file upload to ONE, then I’m hoping that will force people to comply =)

In the pro version, I can choose to have the start time displayed next to the name of my event, but I can’t figure out how to make both the start and end time show up there. In my attached example the session runs from 8:00 - 10:00 but only ‘08’ shows up. I can also choose to have only the end time show up, but I want it to show 8:00 - 10:00. Can someone help me with this? Thanks!! Screenshot 2021-03-12 at 08.24.58|439x300

if i place a order for example 500 and then it is part shipped in 5 deliveries resulting in 5 invoices . can i have all involves values in one cell ( 100+100+100+100 ) this is then sum into new cell giving me a value of 400. i dont want to be creating new columns for every part invoice . as some order may come in anything up to 10 part shipments

I have an airtable base that is approaching the record number limit. The main driver of this growth is a table full of inbound emails that my service categorises, processes, extracts data from and generally munges. I only need to retain some of these emails, not all of them, and it will be fairly straightforward to write a filter to identify the keepers. Is there a best practice method to select the candidate records, back up the data, then delete those rows? I don’t think I’m looking for a normal backup solution for the entire base - at least that is a separate issue for me. What I want is a way to trim down my base by removing superfluous records, but keep the data from those records in case I need to access it in future.

We are a furniture moving company, so we have two date fields for every record: MOVE IN and MOVE OUT. Since Airtable’s mobile app doesn’t yet support a calendar view, I want to sync Airtable to a Google Calendar. But I want the MOVE IN dates to appear in green in Google Calendar and the MOVE OUT dates to appear in red in Google Calendar. I would also like the same color-coding to appear in Airtable. How can I achieve this?

The answer to this question was "no" in March 2021. Now nearly 4 years later, just wanted to check - is it possible? Thanks!Is there a way to put a picture in the question part of an AT form? We can’t have our students refer to an outside picture - many have limited tech literacy, and this needs to be SIMPLE for them. Thanks for your help

Hi there, I’ve build a custom app and used d3 to create a chart. I’d like to link to the “expand record view” from within my app. By “expand record view” I mean the view when you click on the circle next to the record number on every table: I’d have the record id available to pass in…

Hi all, First of all, I’m discovering Vega lite and I have to say that I love it ! I’m trying to do a scatter plot, with (1) the dots being proportional to a value and (2) a text label next to each dot. I’m actually able to do each of these in isolation but when I try to do both at the same time, the labels inherit from the dot size. Is there a way to achieve this ? Here is the configuration I’m using : { “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “title”: “Dashboard”, “width”: “container”, “height”: “container”, “layer”: [ { “mark”: “circle” }, { "mark": { "type": "text", "align": "left", "baseline": "middle", "dx": 3 }, "encoding": { "text": { "field": "text_value", "type": "nominal" } } } ], “encoding”: { “x”: { “field”: “x_value”,

Hey everyone, I’d like to merge some records and retain anything linked. I have a table with companies and a table with agents. Some of the companies have more than one entry due to spelling errors or variances in formatting. I’d like to combine these records but retain the agents that are linked, and any other linked records or information. For example, in my companies table, I have “Clarence” and “Clarance”. They are both the same company and should be one record. A new record was created due to a spelling error. These companies have different agents linked to them, but I’d like them all to fall under the same company name in one record. Is this possible? Any help would be much appreciated. I’ve looking in other threads and online but haven’t been able to find a definitive answer. Thank you

Hi, I’ve been using Airtable for just over a month now. Now, I need to display the corresponding "Product Sell Name " so that it can be used in Page designer to create an invoice. (image attached below) The problem is: "Product Sell Name " is getting displayed against the column “line Items 2” but they are separated by commas. I can’t use them in the “page designer app” to create an invoice. Can you help me show, how to get the products name so that it can be used in creating an invoice? Regards, Chak

Hello, I’m trying to order by Pivot Table columns by months throughout multiple years while displaying just the month and year for example “January 2020, March 2021, April 2023”. The problem is that the only way it’ll sort properly is if I append the year and month to the front of it like “2020-01”, “2021-02”, “2023-04”. It makes it much less nice to read: The part highlighted in red is necessary for the sorting to work properly. The part highlighted in green is ideally the only part I would like to show. Is this at all possible currently?

I’ve got a button that runs a script that send a webhook to integromat and it works great but of course isnt allowed on IOS. Is there a workaround for the people in my group that only use their phones to interact with airtable? I was using a checkbox but that leaves integromat running every 10mins.

I just read this Contacting Airtable Support about bugs Says to use the In-App to contact Support. SO — how do we contact support when we’re getting this

Hello all! I am working out on building a base for my analytical laboratory. I have say, 5 experiments producing 20 samples a day. Each sample might need to be run on many tools. Let’s say a GCMS, a NMR, FTIR (science stuff) I am trying to figure out how to best handle this. If this were a simple “create sample”->“run sample”->“Done” scenario, I wouldn’t be posting here, but it is more complex. I want the machine operator at the GCMS to be able to sit down each day, and see what items are in the to-do list for that tool, and I want that person to be able to mark as in-progress or complete. Same thing for all other operators. I am using a table for tools, and a table for samples. Each sample has a multilinked record to tools for to-do. Then, there is a multi-linked record for in-process, as well as complete. This all works, but it can be a bit clunky. The tool operator has to manually delete the “to-do” tool link, then create the “in progress” t

I’m looking for a way to have the gallery view only show the next 4 events coming up. I know I can filter by limiting the date but the event intervals (#s of days between things) are inconsistent so I am looking for a way to have it only show the next 4 events no matter when they are happening but still be sorted by the date. Then when one event date passes it drops off and the next event shows. Any ideas??

I have had credits through 2 e mail addresses (I changed from a gmail account to a business email) and I want to use them and do more here, but not through 2 separate accounts. Can anybody help or advise please?

I have a base with several tables of school programs that students can sign up for through a Jotform. I do not want to merge these tables into one because each program has various data/fields that are unique to it. However, there are a set of fields that are the same, such as those concerning student personal info (email address, phone number, address, etc.). I would like a single script that can do some processing on such fields that are named the same across multiple tables using buttons. In scripting, typically I set the table explicitly via something like let table = base.getTable(“Table Name”); I am wondering if there is any way I can either: Get the table that a button was pressed in or Get the table that a record exists in I know I can make multiple copies of a script and just change the base.getTable() part, but I’d rather keep this as a single script that works on multiple tables. Any suggestions? Thanks!