Ask the Community

I know this is impossible as far as basic automation behavior, so I'm mostly looking for ideas on what I could do.I have a form for requesting time slots. Because of the way my department works, only a certain time frame should be open at any given time for these requests, and it's in six month chunks. I'm using the range limit on my Event Start/End fields to do this, and it works as expected.At this present moment, let's say we're only able to select a time slot from January - June. But in June, I'd need to change the range limit for both fields on the form to reflect that selections can be made from July - December. While I could do this manually, I won't be an admin on this once it's live, so I'd like to make the range limit change automatic if possible.Any chance I can alter form configuration on an automatic schedule? Code-heavy solutions are very welcome.

Hello, I am attempting to create a “email merge” document template using Airtable that allows me to: Use rich text formatting (bold, bullets, etc. for email formatting), and Use reference fields in the text (for example “Hello {First Name}, your User Name is {User Name} and your Password is {Password}.” If I try to do this in Page Designer, I can do #2, but not #1 that I know of. If I try to do this in a Long Text Field, I can do #1, but not #2 that I know of. Any ideas? Thanks, ML

I'm wondering if a formula has a way to reference the field name.  For example I want to name a field the number 10 and then use a formula which calculates if {other field} < {thisfield.name}.Is that possible?

When you turn on the Rich Text Formatting option in a Long Text Field, you are limited in the Page Design Block. First of all, it is not possible to change the typefont, neither is it possible to change the font size. It is understandable that you cannot make the text bold, italic and so on, because that is what you do in the field itself. But, the font size and fonttype can not be change in the field itself. So, what is it gonna be: add features in the Long Field, or add them in the Block area? Regards, André

Hello! Ive been looking all over youtube and the forums to find something that matches the automation I have in mind but to no avail unfortunately. Im attempting to create an inventory list that pulls from an item master list.Currently every detail of items being stored on shelves is being manually typed out, I would like to improve the process but typing in the details once into the item master and whenever a part is being put away the PN is typed in, the remaining data would be pulled from a separate table and auto populate in their respective fields. With the possibility in the future integrating into an RFID system

Hi all,I'm new to airtable and I'm trying to take first steps using automations.I'm setting up notifications about a new tasks: an email is sent every time a task with to-do status is assigned to a user. The emails are sent fine, this part works like a charm. But here is the difficult part: I'd like to include in the email the link for the new task and I cannot find the variable I can use in the email text. Like "if task x is assigned to a user send an email to the users email address with the link to x in the email text".I've checked the resources here and couldn't find anything.Can anyone help me with this link/variable?Thank you in advace!

Hi,I’m trying to update our CRM’s product listing with upgradeable pricing. The current structure is simple, one record per product, with price as one of the fields. Customer orders are directly linked to products sold.Now we need to update prices. The challenge becomes that if we just update the existing products’ prices, historical data such as value of sold product would change, and any reports would change totally.I have seen in similar systems that products may have Valid From and Valid To fields for prices. Or perhaps for the whole product record, I’m not sure.Testing this concept I’m able to build a logic that tests if a product price is valid TODAY. I guess I could duplicate the whole price list, and use some “Valid today?” formula to determine which product to link to an order. But this would mean soon having a lot of rows in the table, depending on the frequency of updates.So I tried to place “price validity” in an own linked table, with

Hello, I am looking to get help automatically updating records. I have an airtable setup that pulls in companies that visit our website from a lead tracking system. I manually select an option to tag the company as "Sales Target, Client, Employee". There are instances where the same company/person will come to the website and show up as a new line item in my airtable.Is there an automation that I can setup that will automatically update the record to match the previous line where I tagged them? Said differently, If I manually tag Apple as a "sales target" in row 7, I'd like to have airtag automatically mark them as a "sales target" when they show up again in row 101.Thank you

I'm having trouble getting past the Update record in an automation:I was able to:- get the trigger to catch a new email in a table (pic #1)- filter out the matching email and corresponding row (pic #2)In the Update action, I used the Airtable record ID from the first step (pic #3). The field of interest I want to import from the donor table, for example, is What year and school did you graduate from (pic #4) but it doesn't work (pic #5) and I also dont see where in the receiving table I can choose where the donor information I want to collect to insert. Thanks so much!

I'm trying to set up an Airtable automation that's not working as expected.Here are the details:Current Setup1. Trigger: When a record matches conditions- Quote_Date_String is not empty- Axonaut_Status is "accepted"2. Action: Find records- Where Quote_ID matches Quote_ID from trigger3. Action: Update record (in a "Repeat for each" loop)- Table: Landing_Table- Update Quote_Date_String fieldError:Getting "Received invalid inputs" when testing the automation, even though the test step shows valid data in the trigger record.Screenshots of the automation and test results are attached.Any help identifying why the update action is failing would be greatly appreciated.Regards,Hugo

Hi allDoes anyone have any suggestions for good AI tools that are suitable for extracting data from PDFs?I need to be able to extra data such as packet ID, product SKUs, quantity, price from my suppliers stock lists and invoices and map these against my platforms SKUs.Or if anyone knows someone with experience in this area then keen to get in touch.

Hi all,I'm connecting n8n to Airtable using OAuth. I created an OAuth integration that allows reading and writing the base schema:However, when I authorize n8n to connect to this integration, the authorization page does not list any schema permissions: I've tried recreating the integration and reconnecting n8n. Nothing changes it. What can I do?

I have an automation that is set to run when a record is updated. The problem is that as the user types in one of the fields being monitored, the automation is called with every character entered or deleted. I want it to run when the user is finished editing - maybe when they hit "Enter" or when they click off the field for the record in question. Is there any way to do this? Seems unusable as is?

Sorry for such a basic question but I'm having trouble and getting this figured out. We have an online educational community and I'm hoping Airtable will let me have a better view of our community and allow me to automate certain tasks.I have data in different Bases from different sources:LearnworldsSome automated data that I used a Zap to show new user registrations (New LW Users base)Some static data of enrolled users that I download on occasion (the new user registration Zap does not provide much information, but, gives me an idea of what new registrations there are and what needs to be manually imported) (LW Users Uploads base)StripeAutomated webhook through Make that pulls in new subscribers (Subscriptions (Stripe) base)Google Sheet BaseWe have an onboarding survey that collects information. Compliance with filling out the survey isn't perfect so I'm looking fwd to using an automation with

Hopefully this is an easy ask, but I just can't figure it out.I have my interface as public, showing records in a gallery view. I have automation which emails the user to tell them that their request is live on the dashboard and to provide them a link to it. If I use "Page Record Url" in the email automation, it does create a link, but only for me, ie only logged in people. The only way I can get a public link to that record, is view the record in the interface, open it up, click the chain link to copy the url and use that. That URL is much longer than the other ones and I have no idea how I can pull in that URL in the email automation to give the customer.Here are the links, I've modified them for privacy, but its just to give you a flavour of the difference. These links will not work for you.

Hi all,I have an automations question that I hope someone can help me with.My company provides a programming service for clients. As we process the information received, Airtable sends an automatic email to the client letting them know what information we have and what we still need.When record is updated, send email to client.This is fairly simple and works well, however, we have employees who work at night or over weekends and do not  want emails going out to clients at funny times. Setting up the automation to trigger at a schedule time does not work because then I do not have the option of formatting the email based on specific record conditions. I would love to be able to have something check if it's during regular work hours, if so send the email, and if not, wait until the next regular business day and then send the email.Any advice on how to implement this?

I am trying to print a single record.  Page designer is not being used - I am simply printing the record.  Problem is I am getting inconsistent results:One time most of the content from the record is printedAnother time almost no content form the record is printedAnother time nothing is printingThe problem is within Airtable platform.  It is the same if I print to PDF or to the printer.I have tried in both Edge and Chrome.  I have not had this problem in the past.I am on a PC / Windows 10 pro.Appreciate any guidance here. Sali

I have created an interface with several pages.Each page needs to be filtered by a field (plus the specific filters in that element on that page).Outcome: I want to set the field filter at the interface level, and have each element on each page consider that filter, with the element specific filters.Why:  So that I can duplicate the interface multiple times (e.g. 30 times) and just change the filter 30 times, versus setting the field in each element, in each page, which is at a minimum 15 times per interface.I'm not familiar with Connected elements or Record Picker, but I tried them, but they seem to be filtering just the page, not the Interface.Any suggestions?

Hi all, I have another airtable community account that is tied to a company I no longer work with. I reached out to Airtable support to see if it's possible to consolidate these accounts but have not heard back. Has anyone else encountered this issue?FYI: Here is the 'old me': https://community.airtable.com/t5/user/viewprofilepage/user-id/13840

All this goofy 3rd party stuff to do a front end why doesn’t Airtable just buy Softr and be done with it? A unified cooment view like Slack would be good as well.

AirTable whipped me up an amazingly impressive starter app - tables and forms - from a description of my needs.   (Which blew me away.)  I'm now trying to tweak at it to make it do some basic things.   The application manages the inventory of a seed sharing scheme for a horticultural society.   As you can see, it's done something really sensible as regards the tables needed.  (I added the gallery view of the seed types list.) AirTable has also made a nice little request form. What I'd like to whip up, is a public interface which shows something like the Gallery view, where on each of the cards, there is a link to a request form. When the form pops up, it is autopopulated with details of the seed packet

I would like to update a date field in a record, with the last time the automation executed. Is this possible in an automation, in the Update Record Action?If you choose static, you have to enter the field manually. If you choose a dynamic value, you are only allowed to choose from an existing field or data.  

Hi there,Is there a way for us to use a custom script to trigger the Data Extraction extension? I understand we could utilise .csv export, but this doesn't enable to only export specific information, but the whole table.Many thanks,Thomas

Hi everyone,I've been struggling with counting all records from table A in table, B. I've read multiple forum posts and watched videos, but something is still not working ... so I've come here to ask for any insights. My understanding is that  I need to put all records from Table A into a single linked field in Table B, and then use a Count field to count them.  So I set this up, like in the imageThen, I went to Automations and set up two steps: Step one: look for any records and table that are not empty. (Table A is called "Entries" in my base)Step Two: Add an "update record" where the "Table" is the Table B ("

I'm managing 5 websites, and have created one base with 5 tables - each reflecting the blog planning for one website (syncing with the website-specific bases). I've now created a table that collects all the posts from all the websites, so I can see where everything is at in a blink of an eye. What I can't wrap my head around is the dates: I now have 5 date fields (lookups), but I'd like to be able to sort things by date (or display them in a calendar, etc) - regardless of which website it's for. I created a formula field to merge the dates, but that displays them as "2015-01-01T00:00:00.000Z"... I know there's a DATESTR([date]) formula, but that gets me an error message (am I using it wrong?). Any help would be greatly appreciated!