Ask the Community

Hi Airtable-Community A record is always automatically created in this table if the kick-off or planned completion date changes. At the top is always the data that was entered when the project was created. Below that, an entry is created every time something changes in the timeline.Now I would like to have an additional field that only shows the changes to the timeline.Example:Initial project timeline at creation: 01.09.24-31.12.24Change of the timeline to: 01.09.24- 30.01.25Displayed date field 01.01.25-30.01.25I would then like to display this in a timeline: At best somehow on top of each other so that you can easily see how the timeline changes.best regardsMirko

I am working on a database for a daycare. I have a table called Time Sheets with fields Arrival (date), Departure (date) and Duration (duration). (There are other fields in this table to link to each child.)I have a second table called Meals with fields Name, Start Time and End Time (currently they are all single line text). This table has 4 records:Breakfast, 7:30am, 8:35amMorning Snack, 10:30am, 11:00amLunch, 12:15pm, 12:45pmAfternoon Snack, 4:00pm, 4:30pmI want to determine if a child qualifies for each meal based on when they arrived and departed. If the child is present when each meal is served, they qualify. What is the best way to do this? I am still in the early building stages for this database, so if I need to reorganize tables and such, now is the time.Thanks in advance,Mr. Brad B.

We have formulas to check character counts and they're returning with "over character count" for long text that is actually not over character count because they're adding characters for line breaks. Is there a way to adjust the formula to not include line breaks as a character?For example, this would return 338:Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ac magna volutpat, pretium arcu non, ullamcorper erat. Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu quam euismod, sed efficitur lorem fermentum. Sed neque metus, dapibus at sapien at, pellentesque placerat ipsum. But the same text with line breaks would return 342 and if the character count formula were set to 340, would show as over cc:Lorem ipsum dolor sit amet, consectetur adipiscing elit.Fusce ac magna volutpat, pretium arcu non, ullamcorper erat.Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu

Hey all, I have a table which is a  synced report from Salesforce that shows me opportunities coming up for renewal. I also created a different table with the same fields but is populated from the Salesforce report "SFDC Renewals Report" via automation: When condition is met (opportunity ID is not empty) - then create record in the second table "AE<>RAE Worksheet". My issue is that we moved accounts around in Salesforce and now some accounts have a different Renewal Account Executive or Sales Person. I cannot figure out how to automate the update of that Renewal Account Executive field in the "AE<>RAE Worksheet" to match the one in the synced salesforce report.  Any help is greatly appreciated

I am trying to write a formula to return the name of the column for each rows highest value. Attached is what my table looks like. So for example the first row should return blue, and the second row should return purple. Thank you!

Greetings Airtable CommunityI have a long text field with RTF formatting enabled. The text includes links to web pages, emails, and phone numbers. The web links are working perfectly, as are the email links (using mailto:)—but the phone numbers are not working.When formatting the phone numbers, I did the following:1) Highlighted the phone number2) Clicked on the link icon3) Entered tel: and the number (+3606500000)But when I click on the link, I see that the system has inserted 'http://' in front of tel: and this takes me to a "can't open the page" error instead of initiating a phone call. The system hasn't inserted 'http://' in front mailto:Thanks in advance for suggesting a solution! 🙏

I can't understand why the dashboard doesn't have a search function.How can we create a filter that includes a search function?

I use a lot of links to aid users in jumping from one interface to another, with the links having the RecordID baked in so that the jump brings you to the same record on that new interface. This allows for workflow specific interfaces and quick navigation. However there is a couple interfaces that are not letting me do so that i am wondering if there is a workaround or feature im missing? Jump to Timeline Interface with sidesheet of selected Record open (OR to timeline with bubble popup of selected record)Standard timeline url's do not contain the recordID when you click open the popup bubble nor the expanded sidesheet. There is a "link to record" button on the sidesheet, but when analyzing the link it generates it does not use RecordID as an identifier either. However there is a small string of characters that is unique but not sure what it ties to.Jump to Grid Interface of Subtasks filtered on selected records subtasks.Standard grids do not contain the recordID(s) in t

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 KMBlackProduct CSBlackI have an email automation that gets triggered when a form is submitted. I somehow want the information in email in following format.Order 001 summary: NameSizeColorProduct XSBlueProduct OXXLRed What I have tried:Add records as List - too long vertically, not useful at all.Add records as Grid - too long horizontally, same issue as above.Try to manually format as table with HTML/Markdown: didn't workCurrent workaround: Add 20 separate grids (attached pic), but if order has only 3 products, 17 empty grids are in the email. Excerpt from automation below.Tried using helper grid views and scripts, but couldn't approach problem in a meaningful way. 

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 create the records I need. Below I’m going to assign companies to Project 5, and then use a script to create the junction records. Ahh, the joy of automation. :massage_woman:t5: Thank you @Stephen_Suen! Script below. Example base here. let projectsTable = base.getTable('Projects'); let projectQuery =

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' )