Ask the Community

Hi!I am looking for a workaround, where I can turn a single record with multiple dates into separate records with a single date… new records are created via FillOut.  we’re a charity delivering some programmes over multi week periods. An employee completes the fill out form, puts the dates they’d like us to deliver the programme on, and then submits the form. i can view all these dates via calendar view, but was hoping to view them via list view also but as they’re individual records it won’t work this way. sorry this probably isn’t making much sense but hoping someone will understand where I’m coming from…thanks!

I am trying to create a public interface, where I will allow people to search for submitted serial no.Only if you enter the correct serial number in full (without case sensitivity), a list will be shown for all records that matches the S/N you entered.Is this possible with interface?

I want to use the Record Review template to make a How-to Page for my CRM. Each how to Task is on the left nav bar but I want the user to be able to page through them with Next Page (Record) Previous Page (Record) Buttons at the bottom of each Task page. I know I can use a button to pull a URL from the current record but that reloads the whole page instead of just changing the section as if you used the sidebar nav. Gallery view has a kind of pagination feature but there’s less customizability in the page template then the Record Review module version. Any ideas? I’ve tried Omni prompts with bad results, but if you have one that worked for you I’ll gratefully take that solution.Please don’t respond with 3rd-party integrations as solutions.

I would like to sync a record interface between two interfaces if possible. I have just spent ages nailing down my interface only to not be able to use it on a separate interface. I have found a post from 2 years ago referring to the same issue but wondered if there was a solution around yet? For context i have a project editor view and have managed to sync this to a separate project viewer interface no issue, but i am currently making a task calendar where i want to be able to open the linked project in record view but in the same layout. Is it a case of having to replicate? Its the first limitation ive come across so far! Fingers crossed    

Quran Surah Mulk PDF is a popular search for those who want to read and understand this powerful chapter of the Quran in a simple and accessible format. Surah Mulk highlights the greatness of Allah, the purpose of life, and the reality of the hereafter, making it an important recitation for daily reflection.

I have a table (“Active”) with thousands of records, each with at least one photo, the table is refreshing more slowly everyday (we upload small file images). To help speed things up I have created a copy of the table (without data) and setup an automation to copy any given record to a new table (“Archive”) when two field values are met ( “status”=SOLD, and “Archive” checkbox is ticked). This is working now that I’ve mapped all of the fields from one table to the other. I want to continue the automation to delete the record (from the “Active” table) that has been duplicated from the “Active” table to the “Archive” table. Tutorials say to add an additional action, “Delete Record”, but I find no such choice when adding an additional action. It seems this should be an evident action, but I’m stuck. We have a “Team” level subscription so I’ve read the option should be available. We’re using Safari on Macs. All advice appreciated. 

Hi,It seems that the Google Calendar: Create Event requires a hard coded (chosen) calendar to place an event in. We have used a shared calendar for this, but it gets somewhat messy.Hence, would it somehow be possible to have the event placed in a dynamically chosen calendar? Either <current user> or somehow derived based on a variable (e-mail addresse for example)?Rgds,Björn

Hello,We’re working on an Airtable automation and wanted to sanity‑check whether this setup is supported or if there’s a better approach.We have a table called Research plan with a linked record field (Research study) pointing to another table. In the Research study table, there’s already a Persona field populated.Our goal is: when a new Research plan record is created and a Research study is selected, automatically populate the Persona field on the Research plan with the Persona from the linked Research study.We tried doing this with an automation:Trigger: When a record is created (Research plan) Action: Update record (the same Research plan record)However, the automation fails with the error: “Updating the record failed due to insufficient permissions.”We’ve confirmed:The automation owner has edit access to both tables The Persona field on Research plan is not a formula or rollup

I currently have a table where I compare student scores to the national mean score. For example, I have 40 students and need to calculate the difference between each student's score and the national mean.I would prefer to do this without repeating the national mean 40 times in a separate column. Is there a way to achieve this with a linked, locked reference?In Excel, using the $ symbol locks the reference cell in another table (allowing you to only input it once). I know Airtable doesn't offer that feature, but I'm sure there's a workaround or method. Could someone share it with me and help?Example of what I want to accomplish in Airtable using excel logic:[Table B1: Student Score]-[Table 2: $B$2]  1550 - 1555 1549 - 1555 1540 - 1555 1536 - 1555 Where 1555 is in Table 2: B2, listed only once

Hi everyone,I’m building a List Interface in Airtable and would like to know if it’s possible to freeze (or lock) the first column, similar to how you can freeze columns in grid views.When scrolling horizontally through fields in the List layout, the first column (which usually contains key identifiers like names or IDs) scrolls out of view, making it difficult to track which record I’m looking at.Is there a built-in way to freeze the first column in a List Interface, or any workaround that others have found helpful?Thanks in advance for any insights or suggestions!— Sean

Our team has failed to access Airtable through the app but seems fine through desktop/browser. Has anyone run into the same issue? We are based in London, UK. 

my organization does trainings and after each training, we send participants a post-survey to fill out. each training covers slightly different topics, so the questions we want feedback on change slightly with each training as well. right now, i have one table called post-surveys where each field corresponds to the questions we ask, and the field names are shortened versions of the questions. then we build the form for each post-survey based on which questions we’d like to include. the downside is that it means that table has a huge number of fields and it’s hard to see if the question you want to include already exists as a field or you need to create a new one. (e.g. “S3 FSOW: Challenges” means in session 3, we had a question about challenges that related to the reasons we did the session, you can see how that makes it hard to keep track of the actual question)

Hello, I’ve finished testing my automations in the sandbox and have deployed the changes to production. Everything is working correctly, but I would now like to sync my test data from the sandbox to production. What is the best way to do this?

Hello, I have a workflow which includes repetitive data input. Simple copy-paste have some drawbacks.I have a table called Orders. Each row is one order which includes product, quantity etc. Each order requires multiple tasks to complete and there is a linked table for that called Order tasks. Orders come in patches with different products but every product tasks are very similar. I would like to configure first order tasks and then copy it to the rest of the orders. The problem is that then there are only first few tasks which are linked to ALL of the orders. Each order should have their own set of rows in Order tasks table.I have tried multiple workarounds but I haven’t found working solution. For example, duplicating rows in Order tasks table makes it very tedious to relink to correct row in Order table. I have also configured “allow linking to multiple records” but it seems to have no effect when copying and still links to multiple records even

I’ve tried almost every workaround I can think of. As a temporary solution, I can force “Deep Match” to always return something (a "fallback" record), but I haven’t found a way to trigger an automation after “Deep Match” runs successfully and finds nothing. Does anyone know of a workaround, or can point out what I might be missing?

Hey community! Long-time lurker, first-time builder posting here.Like many of you, I've been frustrated with Page Designer living in base extensions while all my users are interface-only. Every time someone in the community asked "can I use Page Designer in interfaces?" the answer was always not yet. So I decided to just build it myself.What I builtA full drag-and-drop page layout designer that lives directly inside an Interface page as a custom element. It looks and feels like Page Designer, but it's a first-class interface citizen.Here's what it supports so far:📄 Page size presets — A4, Letter, Business Card, custom dimensions 🖱️ Drag-and-drop canvas — absolute positioning, resize handles, rotation, layer ordering (front/back) 🔤

In an automation with multiple logic branches, I like to end the Otherwise step by sending an email to myself with details to be research to find out why things didn’t go as expected. I find that works well most of the time. It also prevents the automation from outright failing.But when things are busy and the automation runs frequently, it is harder to find the exact run that failed. Is there any way to include the automation runtime in that Send an email step? I don’t see any way to get at those details.

When I created my Airtable Community/Academy accounts forever ago, I set them up with my work email because that was my only Airtable login at the time. I’m now leaving this current position and want to transition my logins to an email account that will still be accessible (which is also tied to my personal Airtable account). I can’t seem to find a spot in the Settings or Profile where this can be changed--am I missing something, or do I need to go to Airtable support directly?

Hello,i want to know if is possible to copy automatically fields from a table New Books to anther table Books.They will have the same fields. The table Books contents all the existing books on a library and the table New books, all newly purchased books.  A form in softr will be filled with new books and it will be showed in table Books.   

I’m working with video timecodes using the DURATION field type, and am entering data in an HH.MM.SS.mmm format (H=hours, M=minutes, S=seconds, m=milliseconds). I need the data to reflect the values in the hours and minutes places even if those are zero. Right now, if I type in the data for one minute, three seconds, and 124 milliseconds, that data shows as 01:03:124 , but I need it to display as 00:01:03:124Similarly, if I type in the data as 15 seconds, 654 milliseconds, it shows as 15.654 , but I need it to display as 00:00:15.654 Anyone have a formula or workaround that will facilitate this?

Any plan to launch an Airtable MCP to allow us to manage AirTabLe from CLaude chats as efficiently as we’re currently able to manage Notion from CLaude?

Hello,I am new to junction tables and have pretty much zero scripting experience, so bear with me.I am trying to create a breakdown of call sheets for group shoots and create individual “shifts” in a junction table. The goal is to be able to adjust start and end times for those linked in the shoots and to be able to create a more comprehensive reporting interface to track hours and OT by multiple criteria.I cannot show the actual base, but have created a basic example of the structure and result of Airtable’s junction table extension.Client tab:Franchise: Franchises have assigned POCs for internal notification

Hi there is anyone familiar of a workaround so that the background colour of a record changes on calendar view when a field has been updated, when multiple dates are on one calendar?  using calendar to manage service user caseload - the programme service users enrolled on take part in 6 sessions, we have 6 date fields on the calendar.  when we complete progress notes for a service user on one week we want that record to change green… so we know who has had their progress notes completed. please let me know - thanks so much!

Hello.  From a Jira filter, I was able to sync time fields and then it stopped working yesterday. Anyone have any ideas why?  I have a ticket in with support but have not received a response.

Hello - I have a base with a parent table, Projects, and multiple child tables including a Milestones table. They are separated due to creating levels in a project update interface. When a teammate creates a new milestone, it does not pull into the Project table and when a new project is created, it is not pulling into the Milestone table. How do I correct this?