Ask the Community

Hi all,We've been using a Page Designer invoice setup for a few years without issue, but we're now running into a problem where the Address field isn’t displaying properly.Originally, the Address was pulled in via a lookup field. The field shows the correct data in the row, but Page Designer is displaying a “0” instead of the address.As a troubleshooting step, I also tried using a plain long text field with the address manually entered—but in Page Designer, it just shows a blank square. It’s like the field isn’t registering at all.Is anyone else running into this? Or does anyone have suggestions on how to resolve it?

Hi There!I'm developing a resource allocation base for my team, where tasks may involve multiple collaborators, each with distinct daily availability and varying percentages of time commitment. While assigning resources at the project level is an option, it doesn't accommodate the differing daily time percentages required by each collaborator. How can I structure the template to effectively account for these variables?

In our base, we have a field where users can select a project from a linked table. However, we want users to only select from existing projects, not create new ones. Currently, the small "+" button still appears next to the field, allowing users to add new projects—something we want to prevent.Is there an easy way to disable or hide the "+" button in a linked record field without locking or restricting the entire field or table for the user? We're looking for a solution that allows selection from existing records but completely disables the creation of new ones via this interface.Screenshot to show that often projects are added by incident - which we would like to prevent 

Hi Team, I would like to understand, how to automatically reset the form sub-field values, when user change the parent input field. Here is a simple example,Form has two fields, Country and State which is dynamically populated using Linked record feature State field will be shown displayed, only when Country field is not-empty (ie, only when user selects the country, state field will be enabled for selection) Once user selects the Country and State, and when we clear the country selection, then automatically state field is getting disappeared as per the condition mentioned in step-2 When user selects the country again, State field is shown, but with previously selected value We do not want this field to show the users previous selection, because user has changed the country , hence we want user to reselect the state freshly and not showing the previous selected value 

Have automation to run when record is created, When record is created, It will set added_date, add_by(person email) and set record as active. It does 2 of 3… It doesnt add person email address. What could I be doing wrong?   

Hi all,I'm trying to create a gantt where I could provide a start date for the first task and from there the start dates and end dates of all other tasks would be calculated automatically (the start date of a task is the MAX of the end dates of all its predecessors).I have a the predecessors as self Links to the same table. I have their max as a Rollup.I have the end date being the Start Date + Duration, using this formula:DATEADD({Start date},Duration/60,'minutes')and I have another field called "Actual Start Date" in which I intend to provide the start date of the first task manually.When I try to add the formula for the Start Date I hit the circular reference error: I saw this post from 2018 describing the same need, but was hoping that since then it became possible.Anyone knows if this can be done? 

Scheduled trigger not working as expected 

OK someone please help! About 2 months ago the automation I had set up from Airtable to Google sheets simply stopped working. I have reconnected everything but get the follwing error message.Error message "This automation is no longer authorized to use the configured Google Sheets account. Please select a new Google Sheets account for this step. Please select a new Google Sheets account for this step."I have a similar automation working fine. Why not this one?

Hey all,I would like to update the access for some base collaborators who currently have full access to base & Interface to Interface-only access (these users were already shared as collaborators before it was possible to share an Interface without giving access to the base).In this case, does anyone know if I have to entirely delete these users from the base and then re-share them as Interface-only contributors (with the 'Allow access to data in the base' unchecked upon share)?Thanks in advance!

I have a use case for airtable product and want to see if its possible already or if its planned or suggested. Or maybe its outside of the scope of what airtables invisions to do with its product.In a nutshell it would make airtable act like a platform, where relatively complex soft and apps are developed and sold out as a product on its own to other businesses and customers. Use case description:1. I create a workflow with automations, syncs and all that airtable has to offer in one workspace, with multiple bases synced between them in one workspace. So it becomse like a app or a soft in itself.2. Then this workspace is like the "Admin or Blueprint Workspace", that can be replicated multiple times (100ds, and 1000ds of times), that creates "child workspaces" of this workspace.3. The main challenge is: when you make a change in the "BluePrint or Admin Worspace" (like formulas, fields and so on), this change syncs across all of its "child workspaces".

Hi There!I am trying to build a resource allocation base for one of my teams. The ask is that a task may have multiple collaborators with varying % daily time required AND availability. How do I account for this in the template?I could theoretically do this on the project level BUT that does not take % daily time required into account. Any thoughts?

I want to sync my Airtable View with Google Sheets. Is there any option without using third party tools? I tried automation but it is creating a new row even when the entry is updated instead of updating the entry in Google Sheets. I extensively use Airtable for my work but Airtable has limitations in data visualization. For data visualization, I also tried the data studio connector, but unfortunately it is failing frequently. Any related help is appreciated. Thanks in advance.

Hi, Is there a way to connect airtable to google sheets such that it syncs completely? So every time any change is made to my airtable the corresponding google sheets file will also be updated? Thanks, Chris

I need to rig up a button that can export a row of data and download it as en Excel file to a local computer.I assume I'll be able to use Make and Webhook for this. However, the Excel file should have a certain layout. Fx an image placed in a certain place as an image, and certain fields should be placed in different places in the Excel file. So a bit like the page designer, but instead of a printout or .pdf it should be an Excel file.Is this at all possible, and/or has anyone experience with something similar?

Is there a way to export an interface, configured as a "List" view to an excel file?  I understand this gets complicated as many users have groups set within their list view.  I'd imagine that this would work though, if groups are placed into different tabs/pages on the excel file.   Unfortunately, "Print this Page" isn't a great solution to export data.  Additionally, i've noticed that it formats very strange and is rendered useless.  I'd like to also note, that the interface is the only employee facing option.  Employees don't have access to the base.  Only the interface.  Thanks!

I started my WooCommerce store already before I heard about airtable have can I collect the product information already published to create a base and add new products to this base to publish on wordpress store regards Linda 

i want to share 2 interfaces with one person, as a commenter, will i pay for him twice?

I have created an App for myself but would like to understand what would be involved in productising including enablingSecure and data isolated CRUD access to most tables through the Interfaces (Portal?) Common Read only access to some tables Multi level subscriptions Automatic monthly paymentsThanks for any assistance with this matter.

I'm working on a small Airtable automation to track monthly utility expenses by pulling data from a regional electricity provider’s site — the fesco online bill system. The challenge is that the site often loads slowly or becomes unresponsive, especially in the evenings.Has anyone dealt with similar issues when pulling data from sites that don’t have public APIs and aren't always stable? I’ve tried simple fetch scripts and automation tools, but they tend to fail unpredictably.Would appreciate suggestions on how to handle unreliable external sources in automations, or even alternative approaches like manual syncing that aren’t too time-consuming.Thanks in advance!

Hi! I wanted to ask, if there is an automation for following up on unanswered e-mails? We are tracking our leads with airtable, and if someone doesn’t respond to our first mail, that we send out an automatic follow up E-Mail? Looking forward to your help!

Hello, I would like to know if there is any option to schedule email in the Automations area. My idea is to schedule a follow up for a lead 2 days after I change it’s status to “In Negotiations”.

 Hi guys,Our company is looking to provide tools to our clients and own their data, so that we can analyse it and see what marketing outreach methods work in the market. We currently give our clients a gsheet to track their outreach data, such as sales calls booked, scripts, follow ups, niche.1 client = 1 gsheet with multiple tabs(every client has their private gsheet, but we store it on our gdrive. Now, I know that Airtable could be way more powerful, but wondering what could be the way to go about it? Would it even work? What other alternatives would there be for us?

I am trying to run a script through a button triggered automation, but I am running into an error for exceeding the time limit of 30 seconds for execution. Is there a way that I can get around this so I can run the script?I have heard that people have been running the scripts in batches, however, I am not too sure how people are doing this as I cannot find an tutorials on how to work it into the automation. Any ideas?

Hello Community,since this morning our teammembers, who only have access to our interfaces, are not able to run Airtable automations through buttons anymore. The buttons are greyed out and they get a warning saying "Not connected to an automation".However, when logged in through our administrator account (with full data access) the buttons and Airtable automations work as intended.We did not make any changes to the interface, database structure or fields, automations, or the users permissions and capabilities. No changes to anything recently. Overnight things just stopped working.Yesterday everything was working fine, today no automation can be triggered through a button unless it is the administrator account with full access to the data. What happened? What could that be?We need URGENT help here. 🙄

I’m trying to identify where a record has an expiration date and send an email identifying that record.I can automate an email that recognizes the expired date but can’t find a way to attach/send the identity of that record. I have a log (record from a table) and the entries have a field “expiration date”.  My automation finds that record and sends an email that a record has expired.  I need a way for it to not only do that but identify what record that expired (separate field).  Is there a way to do that?