Ask the Community

Hi everyone!I'm looking for a way to automatically set the time to 00:00 for certain entries in Airtable that have a date field. The goal is to allow some entries to have a specific time (like for flight schedules) while others default to 00:00 (such as open train tickets). I’ve tried using forms to set a default time, but the options only allow me to set a specific date and time or use the current date and time, which doesn’t work for my needs. Does anyone know how to achieve this?Thanks!

Hello,I have a Table that captures customer orders information through an Airtable form. Each order can contain anywhere between 1 to 20 products. Gist of problem and my data below with just 2 products: Ref #1: Name1: Size1: Color2: Name2: Size2: ColorOrder 001Product XSBlueProduct OXXLRedOrder 002Product K

Hello, I have a Airtable Table that sorts different records by release date. I want to be able to manually re-order the different records that have the same release date (as many of them do) but for some reason I can't figure out how to do that? I've tried to turn off automatic sorting and then manually re-arrange my records but as soon as I turn automatic sorting back on, it overwrites my changes. Anybody got a fix or insight for this?

I want to add rows in airtable According to Shopify order quantity,for example if quantity is 4 then 4 rows must shown in airtable with random spot numbers but unfortunately Shopify give us just one spot of order is there any automation expert here who can solve this issue

I'm calling in a script more than once input.config, to show input variables, but the error say that I can.. so, how can I display 2 or more variable within a script?  

Hi!Has anyone come across a way to bulk / auto reduce image size for uploaded attachments to Airtable? I also use Zapier and I am looking for a way to do it without taking on another monthly subscription only for this task. Thank you!

I have tried to sign up several times for Academy to get some training and understanding of Airtable. Whether I try to sign in at top of page or register for a course I get the message "Sorry you do not have access to this page".  Any other training courses for Airtable that you would suggest?  thank you

If you have a many-to-many relationship, chances are you have a junction table. And chances are, setting up and maintaining that junction table is probably…not your typical idea of a fun time. Welp, now it can be! Thanks to some serious help from @Stephen_Suen, we figured out how a script could help us automate this process. In the below example I have a list of projects, and for each project I’ve assigned multiple companies to it. I also have another table named “Tracking” where I track all the details related to a specific project-company pair. Previously to create that junction, I had to do a lot of finagling, which took a fair bit of time. However, with a script, I can automatically c

I'd like to add some contextual help, definitions, and things like that for our users. Is something like that doable? I haven't found anything in interface designer to do so.I know on the older pages I can add text elements, but the newer pages don't have any way for me to add freeform text.

Hello! I have had a colleague leave recently who made a form that links to data that gets submitted. However, I cannot locate the workspace the data is pulling into and cannot ask the colleague. Any tips?

Hello, I have a multi select field, with 5 different options that by person you can select 1 to all 5 items for.  I am trying to create a formula where it looks at all the people (say 20 people) and sees out of all of them how many have X as an option selected from this multi select field.  For Example:Person 1: Has XPerson 2: Has X,YPerson 3: Has YSo then If I am trying to show what the percentage is of people who know X, it would output _% Does this make sense?  Is this possible?

Hiya!I'm trying to implement parts of Airtable's Project Management Template into a Project Management system for my organization. In the Getting Started section, it describes the "My Tasks" page as "a summary of the current user's work". I love that my team members will be able to quickly go to that page and see a summary detail of their current tasks. However - I can't figure out how to "auto-filter" the page.In the template it's set up as a page/group filter: Where {Assignee} contains "Malik Johnson". I know this is just an example filter in the template, but if I were to type a specific name in that filter, it would only show that person's tasks, regardless of which person is on the My Tasks page. Am I missing something? Is there a way to set up the filter as "assignee matches current user"?

 I have a problem with related tables.Button 1: When you click the "Add" button, it does not automatically fill out the foreign key. However, you can cancel the form at any time, so it will not be saved in the database.Button 2: This button automatically relates the record to the parent table. However, if you do not fill out the Mailing Address and Source fields, the record is still saved in the database. Therefore, if you accidentally press the "Add Record" button, you will need to delete it manually.Questions:How can I fill out the foreign key in Button #1?If I use Button #2, how can I prevent the app from saving the data in the database if I haven't filled out the Mailing Address and Source fields?

Is there anyone that could assist me for a 5min video call to see why my syncing of pages are not working please or do airtable have a support team that can help?Thanks all

I’m looking to streamline data entry in my Airtable base by implementing real-time auto-suggestions for the 'Company' and 'Company Address' fields within the Interface Designer. Specifically, I want users to be able to start typing a company name or address, and have Airtable suggest existing entries based on what’s already in the table, similar to how Excel auto-suggests based on previous entries.I’ve explored options like linked records and single select fields, but these either require extra steps or don’t provide the seamless experience I’m looking for. Ideally, I’d like this functionality to be constantly available while users are working within the Interface, without needing to run scripts manually.Has anyone successfully implemented something like this, or is there a recommended approach or workaround that could achieve this within Airtable’s current capabilities?Thanks in advance for your help!

Hello community,I have a table called attendance where each record is the date of the event, the participant, the payment.I want to automate the fact that each time a record is created from this table, it updates the list of participant from the table Event.Thanks for your help,Marine

Hi, I'm trying to calculate the number of days until a date, however the result isn't correct.I think using the term TODAY is causing issues due to the difference of my time zone compared to Airtable's. Is there a way to add the time zone into the formula, or can I add/subtract days somehow?Here's the formula I am using;  DATETIME_DIFF( Date, TODAY(), 'days' )   

I have an automation script that searches a table for a matching record. Based on the examples I could find, I wrote it to retrieve that column from all the rows using selectRecordsAsync(), and then loop through all the rows looking for a match. But this sometimes times out after 30 seconds. The table has about 1800 rows.Is there some way from a script to get the lookup done on the server side, e.g. by passing in a formula? I was able to do this easily in make.com using the airtable search action and a formula, but it seems like there should be a way to do this in airtable itself.  

TLDR: is there a standard format that people use to define the application they want to build so companies can bid on it's implementation?When a new person decides to farm out the work to one of the solutions companies that are part of this community, is there a standard specification document that a customer can author that allows solution architects to bid on the implementation?  Or is there another site that people solicit specialists to do the project?  I am sure that the types of customers range from a small retailer to a large company, with each solution provider geared to implement on either small, medium or large solutions.  But there is probably a cap on the "large" before a company just goes full oracle database or the like....TBH, it would probably be an interesting airtable/filltable app to allow people to define their requirements. I wouldn't be surprised if one is out there and I'm just not aware of it. 🙂Thanks.Jeff

I have an automation that uploads attachments to OneDrive, then adds them to Airtable with their publically accessible URL.  This has worked for for well over 2 years, and a few months ago, randomly stopped with no changes on my end.  No errors get thrown anywhere, and we can actually see an attachment pop in for a second in Airtable and then clear out.  The revision log appears to show me adding the attachment, then deleting it. After weeks of forking around and thinking I was going crazy, I stumbled upon another form post and Lo!  'tis apparently a

I have a public readonly table with many links. When I click on any link, a "leave airtable" modal window opens. When I try to click on the "continue" button, the window just closes. Because of this, I can't use my table

Dynamic filters on tables are a much needed addition, but they aren't avialble for an interface. Any idea when and if these will be availble? It is a much needed filter to prevent users from having to scroll through a large number of records and potentially select the wrong record.

Hello,I'm trying to perform duplicate check in a table and have only unique records maintained in the table.For Example: ID Name0000 ABC0000 ABCThis should return one unique row and update the table.Can it be done via automations? Looking for the steps here. Thanks.

Hi guys! I was wondering if you could help me figure out why I get those texts in the progress bar field? How do I get the bar to appear at 0%?

Hey guys!I am looking to see if it's possible to "Enable nested records for this table" if I only have 1 level on a list view as a part of a record review page? I want my team to be able to drag parent and child Jobs into each other to stack them and quickly copy data from parent to child job (I have an automation). Let me know if this is possible or you need more information.Thanks!