Ask the Community

Hello. Thanks for any help on this.Can someone point me to a similar procedure that does the following:After a record is updated:User clicks a button to send a text with information from the updated record A SMS text is sent with this information to a constant, static list of telephone numbers.I’ve looked up several things on Youtube related to this, but they always seem to be too simple for what I’m looking for or too complex.I do use Zapier.  I did create a trial Twilio account.  I don’t mind sending with my own phone, this will only be 4-5 texts per week to 2 or 3 people.Just pointing me to a similar process I think I’ll be able to sort it out.Thank you.

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

The Send SMS App only works when I use the primary number under the Twilio Account Info Section But I have a second mobile number in the same Twilio account under my other Active Numbers that I want to send from but When I change the number in Airtable send sms app sending fails. I tried Creating new API Credentials but that didnt work or I dont know what I am doing there - there was no option to select a particular number,  and I cant find Auth Token and SSID for the number I specifically want to send from. Any ideas would be greatly appreciated.  

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

Hello,Is it possible to update multiple records from information in one email?I know I can use the “When email received” trigger to create a record and extract the body of the email into that record. However, I sometimes receive emails with information that belongs to different records in Airtable.Initially, I receive an order confirmation. That contains only information about one order, so I can set Airtable up to create a record from each order confirmation.When the order is ready, I receive another email, and that email often contains information about multiple orders.The data in the body of the second email is structured roughly like this:           The ordered materials have arrived.           Order number: …           [Other details about the materials]           Order number: …           [Other details about the materials]           Order number: …           [Other details about the materials]           You cannot respond to this e-mail…The order number is in the initial order c

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 there — I suspect the answer is ‘you can’t’, but is there any way to restrict a user to only be allowed to upload a single attachment to an attachment field in a Form view?

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