Ask the Community

I need to manage multiple deadlines for multiple projects & clients more efficiently. I don’t want to update deadlines in multiple places, but that’s where I am. This isn’t efficient and will not work for the long term. Here is the current setup:I have a Primary Base I use to manage grant research, tasks, and profiles for all of my Clients. This includes 2 key tables: a Research Table and a Task Table. The Research Table is filtered into views that are specific to each client. Each of those views are synced to a Table within a Separate Client Base. That Separate Client Base also includes a second Submissions Table that is manually updated with specific due dates and other requirements that are unique to that Client (although some research may be relevant to multiple Clients, specific details will be unique to each client). This Separate Client Base is shared with each Client. The Task Table (in the Primary Base) is manually updated with a wide range of tasks that is grouped by Clie

Is it possible to add simple text blocks within a form to break the form into multiple named sections?

I’m syncing records from a source base into a separate working table. New records from the source base are showing up on the sync’d base, but updates to the record (e.g. selecting a different single source field entry) are NOT syncing. The base is set up for automatic sync. Is this a bug, normal (i.e. updates to records don’t sync), or is there something I’m missing in setup?

Hi everyone! I’m building an Interface page that will serve as a library of:Each Product my team trains on. From a synced table: Product Database. Each training Resource we have for each Product, which are set up as linked records.  From a synced table: Training Inventory.  I set this up in a Record Review layout (preferred over List View for our use case). When editing the interface (and when “normally” viewing the published interface), everything looks great. The linked records display properly (as a view) within the record details.The problem: In the public share link or when embedding the interface on SharePoint, the linked records do not appear. This happens whether or not a product actually has linked records.Has anyone else run into this limitation with Record Review Interfaces? Is there a known workaround (or an alternative layout/approach) that allows linked record data to remain visible when shared or embedded? Thanks in advance for any insights! See below for examples: The

Hi everyone, I’m teaching a course which requires students to label and recognize certain kinds of sentences. I have a list of sentences for them to practice on in a table and the answers in the next column. I’d like to set up a kind of self-study tool for students. The Flashcard App would work really well for that, can I somehow share that with my students? It’d be even better if I could randomize it. The ideal use scenario would be a multiple choice test that would grab, say, 10 examples and then reveal the correct answers to students when they submit. But I’ll take what I can get! Thanks!

Hi everyone,In our workflow, it’s really important to be able to see multiple dates for the same record, not just a single start/end range. We know the Calendar view allows multiple date fields, but the challenge is that Calendar displays events vertically, while what we need is a continuous, horizontal view like the Timeline.Has anyone found a workaround or creative solution to display multiple dates side by side in Timeline view (similar to how Calendar supports it)? Any tips or best practices would be greatly appreciated!Thanks in advance 🙏

Dear Airtable Community,I’d love to get your support. In our timeline view, I schedule our technicians. Most of these technicians are from the assembly department, but occasionally we also have technicians from the service or maintenance departments helping out.I’d like to visually distinguish the technicians from the other departments in the timeline view, but I can’t seem to find a way to do this.Do you have any ideas on how I could set this up?  

I can't wrap my head around this restriction on interface designs. If you have a linked record picker, but the field has a dynamic filter on it, then Airtable will not allow you to show the list of linked records as “cards.” You can only see them as “pills,” i.e. name only, without any additional context from the records’ fields.  I have a field directly above this one where the user can see cards with additional information when they're trying to select the appropriate record to link. I can't figure out any obvious reason why a dynamic filter should create a situation where you would not be able to access and display the fields for those linked records. If it's just a UX design decision on Airtable's part, I don't understand why they would see limiting a user or builder's access to their own data as a good thing. Has anyone else encountered this? I'll probably file a feature request just to see if I can get an answer, but I wondered if anyone else knew the logic behind this move.

Hello! I wonder if you might give a way of offsetting the “Q1”, “Q2”, etc markers on the Gantt timeline, to support a fiscal year that does not match the calendar year. Or, if not that, to hide the markers altogether. I realize there’s a way to use formulas to have fields reflect an offset fiscal year based on dates, but I don’t believe it’s possible to change this header and it’s very confusing for viewers. Thanks!

Since the latest update, when looking at our Interface the data is getting jumbled.  eg. we allocate workers to projects and they are correct on our Base, however when we look on the Interface on a mobile phone the columns seem to mix up and Workers are appearing against the incorrect projects. Has anyone else experienced this or have a fix for this?

How do you reinstate a deleted record? It’s been 24 hours since we've noticed - is there a way to revert to a previous version?

Hi all, Does anyone have a suggestion on the best way to link tables to automatically create a weekly meeting agenda?I currently use a main table to list a number of construction projects, with each row being a certain project as per the example screenshot below. I would like to create a second table for a meeting agenda which only shows the projects ‘in construction’. A simple agenda would have the columns Item, Lead, Status, and Update/Action Items.I’m leaning towards a second table rather than a filtered view so I can also add other items to the agenda (such as Strategy or General Business).What’s the best way to create this?Thanks in advance,Andrew  

Hi,Please guide me about how we can use scripting automation to run through the records of a specific service provider and update the closing balance (just like it is done in excel). I am providing my script below. The problem is, everytime a new entry is created in service provider ledger, the automation updates the closing balance as 0. I can’t seem to figure out what’s wrong.SCRIPT: let table = base.getTable("Service Provider Ledgers"); // Input from automation (recordId of new record)let inputConfig = input.config();let recordId = inputConfig.recordId; // Fetch the new recordlet query = await table.selectRecordsAsync({    fields: ["Service Provider", "Date", "Cr Dr.", "Amount", "Closing Balance"]});let record = query.getRecord(recordId); if (!record) {    console.log("Record not found.");    return;} let provider = record.getCellValue("Service Provider")?.[0]?.id;if (!provider) {    console.log("No service provider linked.");    return;} // Get all records of this providerlet provi

I am testing an automation setup where a user fills out a form with a multiple select field to indicate the social media platforms and post types they wish to share content on around a singular topic (i.e., they could select Instagram - Story, Facebook - Post and Instagram - Post all at once) and then an automation that creates new records in a separate table for each of the post types selected in that form (so, three entries based on the example I shared above). These created records are also linked to the initial table with a linked records field.The issue I have is figuring out how to update the records in the second table if anything changes in the first table (i.e., the name of the post topic or the social posts desired). I’ve attached my automation setup and am just stuck on how to populate the Platform + Post Type field when the first automation that creates the individual records for each of the multi select options chosen in the initial form.Does anyone know how to remedy this

I’m really struggling with an Australian Mobile Number Formula to automatically reformat with the below behaviour:PLEASE HELP!

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

Hello,I'd like my formula to spit out a paragraph of text. Some of the text within the formula, I'd like to include hyperlinks. Is this possible?Here's an example:If field A = option 1, spit out this text:Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.If field A = option 2, spit out this text:Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Again, my main question is: is it possible to hyperlink a piece of text in a formula?Thank you!

This is what I have tried: "http://nwatagalog.xyz/maps/"&pinColor&"/“number_”&sort&".png" I’m getting this error:: “Sorry, there was a problem saving this column. Invalid formula. Please check your formula text.”

Hey all, I’m experimenting with an idea but am not sure it’s possible (yet) and I would love to hear your input on whether this is doable or not. I have a script that spits out custom reports. Is it possible to insert a button (or link/hyperlink?) into the report, to act as a button which would then run another script? Thank you

Hi all,I am in the process of building an archive base to transfer records to in order to keep our operations base within its record limit. I have set up a basic 1-way sync that does not delete records in the archive base when deleted in the main base.Can I consider record comments to be lost? Or does anyone know a way to copy them to a text field?thx

Hi everyone! Hoping someone here can give me a hand 🙂ContextI’m building an automation with n8n + Airtable to generate training plans and workouts.Airtable structureI have two tables: Training Plans Each record corresponds to one person (with their athletic info). This record is the input for generating workouts. Workouts This is where the sessions created by OpenAI through n8n are stored (workout type, description, etc.). It has a field “Link to another record” pointing to Training Plans, so each workout can be linked back to its plan. Desired relationship: One plan (1) → many workouts (N). Every workout should be linked to the correct training plan for that person. What I needI want the automation in n8n to not only create the workout records in Workouts but also automatically link them to the corresponding Training Plan (via the Link to another record field).Where I’m stuckThe workouts are being created fine (with type, description, etc.), but the link to the

Hi! I work with an appraisal firm. Each appraiser has his own Airtable base to track jobs and expenses and commissions. When a record in their base is invoiced and a checkbox marked, a record of that job is created in my Payroll base so I know to pay them on the next payroll. I have it set so that if changes were made to the record in the Appraisers' base, Make.com would search the Payroll base. If the record already existed in the Payroll base, it would update the record. If it didn't already exist, the record would be created. It all of a sudden stopped working. It isn't recognizing that the record already exists in the Payroll base. I didn't make any changes to the scenario in Make or the bases in Airtable. It just stopped working one day.Ignore the bottom branch, that’s working fine. It’s the top branch (Payroll) that’s giving me problems. I have Watch Records for the Appraiser’s base. Then search records in my Payroll base, looking for a matching job number  A filter saying that i

Is it possible to check how many automations have been executed in a given month?Thanks

I am a manufacturer, and use Airtable in several areas of my business. I have a pro account. I am looking for a way to automate documented employee safety reminders between safety meetings. Initially I planned to have a form with the reminder listed in the form description section. I was informed that some of our employees have learning disabilities, and will require assistance reading the information. Is there a way to have video play after the description of the form? Thank you in advance for your assistance.

Hi All! I am creating a form in Airtable and would love to allow users to see specific text based on their responses. I am familiar with using conditional form fields, but they seem to be limited to fields that require a response. I’d like to do something similar, but just with next that would inform the form user. Does anyone know if this is an existing functionality or if there are plugins to make it possible? Thank you!