Ask the Community

Hey! Thanks in advance for the helpThis is my problem, and I know how basic it sounds but I haven't been able to get this done! I'm creating an automation and Im setting it up so when a record matches a condition (WPM (numbers column) is not empty AND is less (<) than 35) updates a record (Candidate stage (simple selection) to --> Rejected)But what it does is its sending all numbers (less, equal, higher) to Rejected except when WPM is empty (at least that worked) I've troubleshoot as a maniac and nothing seems to work out - Any idea?

Hello,Referring to this Volunteer Management template:Volunteer Management Template - Free to Use | AirtableHow can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?I understand that there are lookup fields.  But each Volunteer Event has multiple Volunteers.  Each Volunteer can have multiple skills.  So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023.  How would I construct the Master table (or some other method) to run such a query?

I am attempted to pull 1 item of information from a table to use for a formula in another table. The referenced table has 1 field and 1 row only:I want to use this value in another table with a lot of records for a formula. I have attempted to link the 2 tables together: Then created a field for the value:The column has the value of 0. What am I missing here? TIA!

Are there help entries providing best practices for normalizing data?  Typically data comes in somewhat non-normalized, records with duplicate (non-unique) or empty values.  Take as an example, the following table, Grocery_Shopping:DayQtyItemTypeMon4applesfruitMon10snap beansvegetableTues13strawberries Tues6potatoesvegetableTues5kiwifruitThurs23bananasfruitThurs6bananasfruitI can manually create a unique table of Types, then manually change field type in Grocery_Shopping.type so it's linked to Types.type.  Similarly I

I am confused. I set up an UPDATE RECORD AUTOMATION that seems to work in my 2 test tables, but it still creates error messages sent to me by Airtable.I have two tables to test this: The first one is CONTACTS MAIN with the following fields: This is the second table: CONTACTS AUTO with the following linked field and lookup fields. This is an alternate version of CONTACTS MAIN with EMAIL as the primary field, which I need for certain tasks. The second CONTACTS AUTO table links to the primary NAME field of CONTACTS MAIN and pulls in all the other information as lookup fields.I need to keep the two tables in sync. So, I created automation. Whenever I add a record to the main table, it creates the same record in the second one. I also set up an automatio

First of all, I'd like to thank all in the community who helps in advance!I have chosen Base Design for this post's location, though formulae etc will also be appreciated.I'm running a SMMA and am still new to Airtable despite making good progress over the last week and need guidance setting up a base in Airtable to gather metrics via scraping. This base has three main tables, Post View, (Social Media) Account View, and a client View.In Post View, info about each individual post our clients make such as # of views, # of shares etc as well as the time and date of posting is collected. In the Account View, data pertaining to view, shares, data the view, share, like and comment count data for both (Today) and (Yesterday) are displayed. The third table is further aggregation to give a better top-down view.I have two main questions. In the second table and third tables how can I ensure that the data for 'Views T

Hi - There is data in one of my tables that I cannot edit because apparently I need to "Upgrade to Enterprise to edit synced tables". Can you explain what this means, and how was the data able to be entered in the first place if I've never subscribed to Enterprise (someone else actually setup the table so I don't know how it came into being)?  What are synced tables?

Our team's admin had an emergency situation and is going to be unavailable for the foreseeable future. They weren't able to unlock two forms on our website before leaving. Is there anyway we can have permissions assigned to another team member, so we can access and unlock these two forms?

Hi there,I want to create a new field called "Original Start Date" and this will be populated from the "Start Date" field when someone enters in a new project.  Like a lot of projects the Start and End date moves a lot.  We want to reference back to when it was first originally entered in.Where do I start?  Do I create a new field in the "Projects" table called "Original Start Date" and then create an automation the populates this from the "Start Date"?I was referencing this article that mentions creating an automation.But I don't know the steps in connecting the two.Any help is greatly appreciated.Thanks!

Sometimes the Community is helpful in solving a problem, but sometimes we need more support than this. When I first started using Airtable, it was possible to get support  - good support! - from a human being. At this point, I can find no way to do so - the bot just takes me around in circles. (We do have a paid account). Can anyone advise on how to get support from someone at Airtable when necessary? 

Is there a way to automate a New Grid View when there is a new record in view? Here’s the flow: A new record is in view Create a view. Use a field from the new record to create the filter for the view Save the view as the Name. I’ve use web scraping tools and Zapier and have had no luck. The web scraping tool I use does not like Airtable. OR is there another way to share just a record with someone? We use the shared grid view to give our contractions information (what we owe them, their log in to our app, etc.). We automate everything but just this step. Thanks in advance! :slightly_smiling_face: I’m a business owner, not a coder. I feel I’m in over my head on this one. :worried:

Hello! Can you plese help me with automations and billing? I switched to the Pro plan and cannot run the script.

Hello,I am designing a base that needs URLs with markdown in this format:[text to display](https://my.url.com)However, when I try that... that's exactly what it looks like. I'm using long text fields with rich text enabled. I've tried a bunch of variants, including many I've seen in this forum, and it never shows display text -- always just the text exactly as entered. Whether or not the URL is interpreted as a URL is also an issue. It works sometimes, but no others. I'm using google Chrome for what it's worth. Is there an issue with my syntax?Regards,Scott

The record limit will not allow me to see my task. I have the free version so I deleted some completed tasks, so I'm able to see my task list but it still will not let me see because of the limit. Please anything that could help me view this again without upgrading the service. 

Hi, Is there a formula that could handle removing urls from a long text field and keeping the rest of the text?I have been playing around and am not able to achieve this so far. I need to omit any string of text that starts with any of the following 4 but keep the rest of the text in the field:%/IF% %F<https httpsThanks! 

Airtable have recently released a new popout feature for the calendars in interface designer.When clicking on a record in the calendar element, a new popout appears before you can get to the record detail view. To get to the record detail you have to click the expansion arrows in the top right of the popout:How can this popout be disabled and go back to how Airtable used to work where you clicked on a record in the calendar and it would take you straight to the record detail?

Let's say we have a row with a product & prices for that product at four regional stores:Chocolate BarStore A: $1Store B: $3Store C: $2Store 😧 $5I'd like a formula that would look across the store prices, determine the highest price, and then return the name of that field. I want a function that would return "Store D" in the example above.MAX(Store A, Store B, Store C, Store D) will help me identify the highest price, but it returns the $5 value, not the field name Store D. How do I get something like MAX returning the winning field name?Thanks!

I'm building an issue tracker leading up to a one-day event. Issues are reported, and then I need to track how long the issue has been open. Most issues are closed in a few minutes, but others may linger for hours, or even days.I can calculate the number of minutes since the issue was opened, but how do I convert that to a duration-like result that includes days? Sort of like a DD:HH:mm format.This is how I calculate the elapsed minutes:  DATETIME_DIFF({Resolution Time}, {Call Time}, 'minutes') * 60

Currently it seems as if though there’s no way to tag and notify a user who does not have access to your interface; additionally, when a notification is sent, that notification links back to the interface it was sent from. Can it please be adjusted that a notification gets sent regardless of the interface they have access to, and the link that’s sent to them finds the relevant record on whatever interface is currently available to them?

I've got an issue with my account, as Airtable is displaying that I reached my automation limit (50.000 / 50.000)Actually, I only have one active automation in my whole workspace, triggered by the creation of a record, and I only create approximatively a dozen record a day.I dont understand how my limit can be reached that quickly, and apparently this is the case every month, my automation limit is reached after 2 or 3 days.Have you already faced something like that ? I currently have the Pro Plan, and I don't know if this is the good place to reach someone that can fix my problem and more importantly explain to me why this is happening. Thanks you very much !

This might be a super simple one, but I wasn't able to find it in the Keyboard shortcuts and it's been driving me crazy.In excel, when you are entering a sequence of cells in horizontal order (tabbing after each one), if you hit Enter/Return, you return to the place where you clicked, so you can continue entering the same sequence of cells.  In Airtable, you hit enter and it puts your cursor in the cell directly below.  So you have to hit enter again, and shift-tab back, or ctrl-left back to the very start of the row.  Oh how I long for fewer strokes to get back to where I started entering!  Anyone know the trick? Thanks! Craig

Hi, I have 20 records in my Base that were accidentally overridden by an Integromat automation. I need to restore the records to a previous version, but “Undo” will work, and there is no Snapshot for that time period. I can see the previous edits in the Activity Log for each record, but it looks as if I can’t access this data through the API. Is there any way to restore records to a previous version based on edits in the Activity Log of a record, rather than a Snapshot? If there’s not a way to do this within Airtable itself, is there any third party software that you can recommend to extract this data? Thanks for the help!

I know it is possible to create custom Extensions and publish them to the marketplace. I was not able to find any information on developing third-party actions for Automations.For example, there is a list of integrations:Can I develop a new one for a third-party system? I'm looking for a way to develop and publish it globally for other users to consume. I'm a part of a product company and we want to give Airtable users option to integrate through Automations. 

Hello, I am using Automations to keep my Base in sync with a Google Calendar. Specifically, I am importing Google Calendar events into AirTable. For one-off events, it works great! Creations, updates, and deletions get mirrored pretty well. However, when I create a recurring event in Google Calendar, only one row gets created in my base. My automation trigger is set for “when an event is created in Google Calendar” and the action is “create a new row”. If I create an event in Google Calendar that repeats every Monday for one month, I would like 4 rows to be created in AirTable Does anyone know if this is this possible with Automations? Thanks so much!

Hi everybody,I have a question regarding syncing multiple workspaces into one workspace. I then want to merge the data that is synced so that I get one database with experiments. It is constructed as follows:We now have 3 workspaces with experiments, one for email, CRO and socials. Now we want to have an overarching workspace where all experiments come together so that we have one large database. For example, we can collect all experiments from one campaign.Now I succeed in syncing a view, but it then becomes a separate tab in the overarching workspace. Is it possible to import all data into one table. Or should these be 3 tables and is it possible to merge all this data into one table so that we have one library.I'm curious if anyone knows a solution for this.Regards, Martijn