Ask the Community

In my data I have two fields, name of a program and hours. In the screen grab I’d like to move the hours in front of the program name. Is there a way to do this? This view exists in my interface. 

I’m trying to create an automation that sends an email to a table user when a “due date” field is tomorrow.  The trigger and action tests both get green check marks but when I turn on the automation, it shows a fail in the history because there’s nothing in the “To” field. It all looks like it should work so I’m not sure where I’m going wrong. Has anyone been able to make something like this work?   

I see a new layout option is available on the interface designer. Selecting this option just populates an empty page with a drop-down field off all my tables. I cannot for the life of me find anything anywhere in Airtable that might allow me to add an interface extension. Having the Base extensions in the interface would be SO amazing. 

Does anyone know if there is a special developer account or registration method that allows us to use the features of Enterprise as developers so we can showcase things for our clients? For example, I am currently hitting the 125k record limit in a mission critical base located in our primary Business tier workspace. I have no business upgrade path as I am not on Enterprise myself and yet I need to be able to support our client at the Enterprise level without joining their organization.

I am adding descriptions to records and they are showing up in Grid View but not in Calendar View. How do I get descriptions to show on Calendar View on the AirTable calendar imbedded on my website.

Hi all,We're working with a List view interface where users use the relatively new manual sorting feature to create a list of approx. 30 materials that make 1 product. I've added an automation to copy these materials over to another product, which works fine except for the sorting.When running test runs with the automation, I noticed that the automation's 'Sort list' step, when set to sort by the 'Manual sort' field, gives a different result than the List view (or data view).In data view, I've copied the 'Manual sort' values into a single line text field and applied the same sorting to that field instead of the 'Manual sort' field. This results in yet another different sorting (which seems most logical to me, placing 'bXa' above 'bXWV' in an ascending list).I've attached images of the automation setup and the different results in data view. I hope this helps clarify the issue. Any help would be greatly appreciated!

​ I have followed this to a tee but I am missing something here! I have a table called Certified Partner Data (CPD). It is essentially my Main table from the exercise above. I have a field called TRIs in that CPD Table. I need to rollup the sum of that column. I have created a Calc table and made it Link to CPD. I see all of records of CPD in one row of Calc. I go back to CPD and create a Lookup field going back to the rollup in Calc of the TRIs.Below is what I see when I when I view CPD. I have it filtered to a single month and you can see the TRIs column = 15 (column total at bottom) yes my Total TRIs is showing 554. That is the total NON FILTERED. The filtering on CPD has no effect on the Calc results. I am SO close but can’t seem to get this part to wor

in airtable interface we created an interface that can create a treatment plan automatically by using scripting but now our client are having difficulty creating the treatment plan automatically as it continue to show timeout. Don't know why is like that? 

Hope I’m putting this in the right forum. I could swear that, a long time ago, I saw Gareth Pronovost demonstrate how you can generate a URL that will load an existing record into a form so a user can edit it. All I recall really recall is that it involves getting the record ID into the URL. But I’ve been searching for how to do this and can’t find it. I’m talking about a technique that does not require anything outside Airtable. I already know how to do this using miniAutomations (and that works great). But I’m trying to do it without miniAutomations or any other helper service. Anybody able to throw me a clue? Added a minute later: To be clear, I’m NOT talking about prepopulating fields in the form. I know how to do that, too, using ‘prefill_’ and encoding the URL. When you do that it simply prepopulates certain fields with values, but when user hits Submit it creates a new record. I want to edit an existing record and then save the changes to the same record.

Hi all, I’m trying to setup a project management database with a grouped timeline view in an interface. I’ve worked out how to colour my individual ‘phases’ but it appears there is no way to recolour the overview lines that show the overview timelines of each group. See screenshot below The default colour is very hard to see on white (Shown in the green box below) , and the overview line on the top-most group (shown in the red box) is essentially invisible… Is there any way to change these default colour schemes? currently this limitation is standing in the way of Airtable being a usable timeline management tool for us. 

Hello Airtablists! 👋🏻I am trying to improve our documentation and I’d like to keep running lists of active interface pages. I don’t see any extensions like Field List or Base Schema for the interfaces. Does anyone have a solution for getting a quick list of all of your pages? Ideally currently published, but getting all would also be ok.Thanks for your thoughts!

Hey everyone,In my databases interface section I have two interfaces containing several list views, that are of course referring to the same data. The first interface is ment to be for typing in data in our planning process and mostly used from desktop devices. The second interface is for executing purposes and is mostly used on mobile devices on location. This interface should be read only.Summarized:When we are in the office, we are planning and typing in data in the first interface. When we are out of office, executing jobs, we log in to our accounts an our mobile devices to read the condensed and important data.BUT:What we are faceing is, that it seems, that within the interface section of our data base alle lists behave the same in terms of a field being read only or being editable.In easy words: When I change the status of a field from read only to editable in one list in the interface section it does this not only

Hello,we have a ticket/appointment form, where we add all relevant team members to the appointment. Now I would like to create a page in timeline form, where I group by single team members and see all the appointments that are assigned to this person.Currently this is the case: I add an appointment through the form and select multiple team members. Then, in the view, if grouped by the Team Members, it shows me for each combination of team members the appointment.  How do I change this, that I see for each team member the appointments?Do I need to create additional fields in the base? Thank you so much for your support!Best,Phil

So a big reason I chose airtable was that it had an app, so that myself and my other user could input data in the field. Except now that I've spent dozens and dozens of hours building something with forms etc, I see that forms don't actually work on the android app...!What's the work around for quick in-field form submission? That's a surprising oversight, and I see people have been complaining about this for years..

Good morning everyone,In my company, I manage the content of all our Airtable bases. We’re on the Team plan, and the 10+ other members have Read-Only access.Interfaces : We provide multiple Read-Only interfaces to make the data easier to view.Scripting Extensions : We use scripting extensions that can manipulate table data (for example, to get the published versions history from one of our tools).Forms : I plan to add forms so team members can interact with some of our base content (for example, to submit development tickets).My questions :Interfaces : If I add an editable field in 1 of my interface to make the large text areas easier to manage, will Read-Only users be able to edit content ? If they do, will these actions incur charges ? Is the logic applicable if i make the entire interface editab

It looks like the forms in AirTable have recently gotten a bit of a revamp. Is there a way to add blocks that just contain helper text? I essentially want to include text giving directions and reminders to the form taker as they are going through the form. I know a field can have helper text added, but for the form I'm creating, there are certain pieces of info/reminders that aren't necessarily directly related to a specific form field question, but it's info that I still want to remind the form taker about. I can add it as helper text, but it won't flow as well.

Hey everyone,I think I’ve raised this before, but unsure if there’s a workaround …It seems from a record template, you can’t add an assignee to a task, who doesn’t have base access permissions? I guess the logic is that they won’t be able to view the task in the base?Similarly, if you have 2 views, eg) Admin and Tasks, with views of the same list of tasks, you can’t assign a task to someone in the Admin view, that only has access to the tasks view, even though they’re the same tasks?Any thoughts / experience with this? The main pain point is the Record Templates assignee field, as we can’t fully automate assignees in recurring project tasks, so they need to be manually added / an automation created.

I know a few years ago it was not possible, but I'm curious to know if anything has changed. I have a long form that I'd like to split into multiple pages. Is this still impossible to do in Airtable? Is my only solution to use an external service like JotForm?

Hi, I have connected Jotform with my Airtable. Everything works perfectly fine. Information was able to save on Airtable appropriate. I chose the E-signature widget on Jotform, is there any way I can save it on Airtable as an image? or what should I do with it? Any suggestion？

I see there have been a handful of posts pertaining to e-signatures in AT forms, but I decided to add another one since the most recent seems to be from 2021 and we know how fast things change in this space. My specific use case revolves around credit card authorization forms. As we rebuild our company website, one request from the CEO is to add an embedded form to our site. As it stands we use Adobe to create an editable PDF however I don’t currently have access to our login to explore what a logged-in admin sees when receiving a completed form. Currently we send the editable PDF form to clients via email. Most clients…it’s an old school industry, then print it, fill it out, scan it, then email it back. We then scan and file the hardcopy away. In my mind the ideal flow would be to embed on our site, allow user to fill it out with esign, and have submissions stored in a table somewhere (either adobe or AT) Any advice is appreciated.

Hi Airtable Community!I’m trying to set up a formula that will convert a printed price to its digital price equivalent, but the rules for those calculations are wonky. I was able to successfully tell the formula that for items under 10.99, it should subtract 1 or 2 from the printed price (depending on the original format), but my attempts to code a SWITCH clause for any titles over $10.99 (and thus subject to a specific price grid) are just returning empty values.I’m trying to argue that if a book is hardcover and greater than 10.99, then the digital price from a grid should be swapped in based on the print price. Same for if the book is a paperback, but the grid values are different, so it requires its own clauses.Here’s what I’ve got so far: IF({US Price (Printed)}=

 Working on row status for projects based on conditional fields pulled from external sources but am bad at formulas. I think I am close. Any help on this? . Issues with greater than zero and start dates in the pastIF( {Effort Current Total Estimate}=BLANK(), 'Scoping'IF( AND( {Effort Current Total Estimate} > '0', {Is Approved} = "checked" ), "Dev Pending"IF( AND( NOW()>{Target Start Date}, {Has Human Interface Impact}= "checked" ), "In Design"IF( {Substate}='Nominate','Intake',IF( {Substate}='Investigate','Engage',IF( {Substate}='Fix','In Dev',IF( {State}='Integrate','Feature Complete',IF( {Substate}='Review','Feature Complete',IF( {State}='Verify','With QA',IF( {State}='Closed','Closed',IF( {Substate}='Review','Feature Complete',

Hi Community, I would like to create a new record that is automatically linked to a parent record when I click "+ Add record" in the interface detail view of my parent record in Airtable Interface.To try to explain clearly, my database is comprised of two hierarchies in two different tables.Table 1 is "Communications" and contains the parent records.Table 2 is "Web Articles" and contains the child records that are linked to a "communication" record in table 1.When I am in the interface list view of the "communications" table, and click on the details of the "communication" record, I can see my linked web articles (see screenshot 1).The only way to add a new record from here is to create one with a form. If I then try to add a new record (+ Add article), it opens a form to create a new record in the child "web articles" table, but there does not seem to be any way to link this new record directly to the parent record through whic

Hi Everyone Does any one know of a formula that could deduce the Week Number in the Year from a given date field? Any help would be greatly appreciated. Stephen

Background: We're a Danish furniture manufacturer using Business Central and need to automate our supplier PO confirmation process. Currently, suppliers confirm via email/phone which creates data entry errors and delays.What We Want to Build:Automatic Link Generation:When new PO is created in Business Central, trigger creates unique Airtable form link Each link is PO-specific and pre-filled with PO data (item numbers, quantities, dates) from Business Central Link expires after confirmation or set timeframeSupplier Experience:Supplier receives email with unique link (no login required) Clicks link and sees only their specific PO details Can confirm quantities, update delivery dates, request changes, or split PO lines across containers Submits form which updates our Airtable baseSecurity Requirements: