Other Questions

How would you go about configuring a field so that you can create a dropdown list of years inside of a form? Is it possible for it to dynamically update with the {current year} + {10 subsequent years}? For example, the form field might read something like: 2021 2022 2023 2024 2025 etc…

Hi! I have two bases in the same workspace and I am trying to synch one view to another base. On top of it, I use the synced view as a linked field. However, as soon as I use filtering on the view (the one I use to sync), I loose all data on another table. Is there any way to avoid it?

Hi Airtable Community! Hulu’s Strategy & Ops Team is seeking an Airtable Platform Specialist who will be responsible for creating platform roadmaps & improvement plans and implementing them in support of the operating goals of the Marketing team at Hulu. This hire is an Airtable pro and loves all things No Code. They will be responsible for the platform discovery, design, implementation, and subsequent optimization. The Platform Specialist will work cross-functionally with Content, Finance, Product, & IT teams to ensure business fit and functional elements of platform implementation are effective. This person will also be responsible for training Marketers and developing Airtable proficiency (platform super users) within Marketing. If you’re interested in applying, the full JD & application can be found HERE.

Hello! I’m new to Airtable and have been struggling with how to build a pricing sheet that lists multiple vendors, products, pricing and quantities. We want the pricing sheet to be easily filtered and sorted by price, vendor, etc. And then we want to convert this sheet into a customer calculator to get pricing for products based on vendor, quantity, etc. Any help would be MUCH appreciated!

Is there a way for me to setup a trigger for when a database record matches a specific condition programmatically for my users who are using my application Example: User X wants to be notified when a new database record created contains a column with a specific value In my application they would select the value they want, and using the airtable SDK i would create a trigger to send them an email Is this possible using airtable.

Hi When a new comment is added to a record, there’s an indicator on the table view which shows the number of comments… Very handy. But it’s not obvious whether there are new comment since the last time the record was viewed. Is it possible to have a “resolve” button against comments (similar to on Google Docs) to close these… Or a “mark as read” function or something similar. It would be great if there’s a way of seeing what comments are new or need to be looked at, Tom

I’m helping a friend create a base to be used for tracking scores at local dance competitions but have trouble figuring out how to get a proper average for each record. Each line will have a different dance, and each one will have anywhere from 3-5 scores entered, so what we need is the Average Score column to average the input records. Anyone have suggestions on the best way to do this? Keep in mind, in this instance there are only 4 judges, other competitions might have 5 and might have 3, so if possible it’d be nice to only average input values, not all 5 columns divided by 5. The correct average here would be 98 but the average of 5 scores (with the 5th empty) would be 78.4 and that would skew the info heavily. Thanks!

Hey! I know you can rearrange the options in the multiple select FIELD. But I need to somehow organize the actual records with selected options. Take a look at the example: You see, it’s a mess! And my actual table has even more different options - it’s not feasible to do this by hand. I would love to find a way to have them all in order. Thanks!

Hi everyone, I wanted to know if any of you have tried -or know of- a way to sync the data on air table with a website. The ideal scenario would be that if “press sync” the website would be updated with the changes I made on airtable. I have heard of air press but the app hasn’t been updated for a while. Is there any other alternative or this could be easily done by an air table expert? Cheers. Seb

Hi, I’m having some trouble integrating Airtable with Quickbooks Online. I am trying to create a purchase request approval base, where a form is filled by users and then submitted as a record in AT. Now two users would have to review the request,i.e. check the budget balance, check the necessity of the request, etc. before both approving or rejecting the request (rejection can be done at any stage). Also, 1st approval has to be given before the second. If both approve, a bill should be created in Quickbooks Online for payment. If rejected, an email should be sent back to the requester informing of the decision. I am trying to use Zapier to integrate but I’m stuck with the filtering aspect. Any help is greatly appreciated.

I use to receive many email applications with resume attachments. I’ve been using Trello and asana to create records directly from my Gmail inbox mails as there are excellent extensions available. I’ve not been able to figure out any extension or tool yet to achieve this in Airtable. My requirement is to add a record to Airtable including the attachment from the inbox mail. Please suggest if anybody have figured out an easy solution to achieve this.

On Android mobile app, when someone @mention me, I received a notification and from notification I could open a dialogue, from where I could give comments on record’s activity. However, I could not find feature (on Android app) that allow me to directly open the activity’s comments feature. Do we have this function on mobile app, if yes, please point me to it. Thanks Viet Anh

This is so dumb but driving me crazy-- how do I just grab and drop a section to move it??? It doesn’t seem to work like in excel. Thank you!

I’m using one of my bases to schedule social media posts. I’m wanting to be able to see the image I have uploaded in the attachments in my calendar view. I believe this used to be a feature but when searching found that AirTable removed this functionality back in like 2017 and mentioned maybe bringing it back. Is it back yet and I’m just missing how to enable it? If not, can we please get it back? This is a feature I’ve wanted to have for years and am shocked it doesn’t exist.

Hi community, I noticed toward the end of last week that some of my go-to apps aren’t working within my Airtable bases. I recognize today that the issue is related to using the Firefox browser, which has never been a problem before. (Using Chrome, all is well.) Anyone else experiencing this? My browser is updated and I hope this is a temporary bug. Ex1) I can submit text in the search app, but no results are generated. I have the ability to change the view being searched, but it makes no difference. Ex2) The map app is nearly unresponsive. When I expand to full screen I can see the settings, but it doesn’t make any difference if I modify the fields. In each case, the formatting within the app is wonky, too. I’ve included two screenshots to demonstrate. Anyone have any thoughts?? Leads? --Thanks for any insights!

Hello, Not sure how to phrase this-How do I lock across several fields then sort alphabetically by the first field? I want all the information organized by name in the first column but don’t want to lose all the websites in other columns. Thank you!

I have my own personal Airtable account, plus the account from my employer. As such, I have two profiles in the Community. I’d like to merge the two profiles so I have a single account to track all my engagements. Is this possible, or at least setup an alias with each other so the engagements are sync’d with others? Thanks !

Hi, I have a table with around 100 rows of Animals (Duck, Dog, Lizard, Shark…) . Now I like to crowdsource people adding images to those Animals rows. I like people to go to a form, pick a Category (Birds, Mammals, Reptiles, Fish) first then, depending of what Category they pick (e.g. Mammals), they see a list of available Animals (Dog, Cat, Monkey, ) for which users can add pictures. Is that possible in Airtable with Airtable forms? Note: At the Category > Animal relationship is 1-to-1. I.e. each Animal only belongs to one Category. Thanks! :slightly_smiling_face:

Hi there, I am looking to use the Button run script field in Airtable to send specific data from my table into Zapier. Does anyone have a template script they can share? This is what I have so far. let url = "https://hooks.zapier.com/hooks/catch/TKID?recordID=?name=?"; let table = base.getTable("Table 1"); let view = table.getView("Grid view"); let record = await input.recordAsync("Pick a record", view); let name = record.getCellValueAsString("Name") let email = record.getCellValueAsString ("Email") await fetch(url + record.id + "%name=" + name + "%email=" + email); My understanding is the steps are: Create Button field Add in script that posts to Zapier webhook Catch data from Airtable Run rest of the Zap Just looking for help on the Airtable script side. Thank you.

Hello all - I’ve been looking around the forum, and can’t find an answer for this. Does anyone know of a way to export the cards in the gallery view as individual image files? This might be as a direct export from airtable, or even using Airtable as a source for running it through another application. A comparison would be, for instance, how you might use excel as the source for a data merge in Adobe Indesign. The end goal is to try and do two things. Firstly, export a set of image cards from Airtable that could be dragged onto an online whiteboard like Miro or Mural. Secondly, export the information into Indesign (or similar) so that it could generate a set of printable cards as a PDF file.

Hello. How can I display a different field in calendar? I don’t want to see the duplicate date like in the screenshot. I want to see the name of another field, not the primary field because is redundant. Thanks.

Hi, All i have created a multiselect option field in airtable and in that field new options is created via integromat,but now i am facing the issue, Cannot create more select options for new select option xyz, due to this i cant able to add records in air table, i tried to direct add options in that field but cant able to do that, please let me know how to fix it . Thanks

Hello! Need some help again😅 and you all were super helpful last time so here we go again! I have this formula: DATEADD(DATETIME_PARSE({Meeting End Time},'HH:mm'),{Meeting Length}+15,'minute') And what I am trying to do is have an email sent out in 15 mins after the meeting has ended. I tried: IF(NOW()=DATEADD(DATETIME_PARSE({Meeting End Time},‘HH:mm’),{Meeting Length}+15,‘minute’),“YES”,“NO”) Thus making the cell say yes and automation that reads that cell so if it sees “YES” to send out an email. But the if statement I realize doesn’t constantly check the agreement only when a cell is updated. Does anyone have any ideas on what I should do?

Hello all! I’m new to Airtable and need your help. I’m using two tables with responses from Typeform. Both tables have similar fields, the difference being only the language. So I have Table 1 [english] and Table 2 [Portuguese] populate with similar information. My problem is: I need to populate a third table with both Table 1 and Table 2 data combined. I’m using Zapier to combine the responses for Typefome and send it to Airtable, but Zapier seems pretty unstable, so I’m looking for a way to populate directly from Typerform. Someone know if it’s possible?

Hi, is it possible to place an empty field on a page, in Page Designer App, that another user can then complete, like on a Form. If not, is there any other way to present a single record to another user, and have the fill in missing data.