Ask the Community

So I'm running into an error that I can't seem to fix. Whenever I try to set a condition based on a linked record or a formula field, I get that an unknown error has occurred.My first table, products, have a linked field to a record inside the main product master where the product's vendor is linked. So I've created a lookup field for the vendor record id and stored it inside my products table. The value for that record is "recSdTazTLqgiGtBb".My second table, Vendor IDs, which contains all of my different Webflow IDs, is also linked to the vendor in the table. Here I get the exact same field value "recSdTazTLqgiGtBb".Now I want to run automation that temporarily puts a webflow ID into my products record that I'm trying to edit. The trigger is an update to the action field, which works fine.The next step is a conditional logic group that asks for the status of my product record, which also works just fine.Next, I'm trying to find the correct record in my Ve

Hello everyone,I come to ask for your help. I created a Google calendar event creation automation from Air Table records. Everything was going very well until recently. Unfortunately for a few days, the automation has stopped working and I end up with the following message: "Unable to parse datetime".I saw on the community that this problem came up often but without a real solution. Could someone tell me how to solve this problem?Thank you so much.

Hello,@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:I used the CSV "create csv advanced" module and it works fine.My problem is that all fields in the exported csv are surrounded by double quotes:Do you know how I can remove them?Thank youPascal

Hola :wave: quisiera saber si alguien puede ayudarme con una capacitación de Artable, para gestionar adecuadamente el seguimiento de los clientes. :pray:

I'm trying to pull data directly from linked record in an Automation by using the Find Records action with a Condition to match the Record ID which i added to the main record via Lookup field. BUT when I try to reference the Rec ID field it says "no valid nested options"?? I am using the gear icon to match and find the recordIs there some way to lookup a linked record and pull data into Automation directly, ie without adding fields manually to the main record?

I am trying to import XML file but keep getting invalid Xpath (I copy it from XML reader or I modify it based on the requirements) or no results (I am sure that file has 200+ opportunities). Any suggestions?<?xml version="1.0" encoding="UTF-8"?><Grants xsi:schemaLocation="http://apply.grants.gov/system/OpportunityDetail-V1.0 https://apply07.grants.gov/apply/system/schemas/OpportunityDetail-V1.0.xsd" xmlns="http://apply.grants.gov/system/OpportunityDetail-V1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><OpportunitySynopsisDetail_1_0><OpportunityID>262148</OpportunityID><OpportunityTitle>Establishment of the Edmund S. Muskie Graduate Internship Program</OpportunityTitle><OpportunityNumber>SCAPPD-14-AW-161-SCA-08152014</OpportunityNumber><OpportunityCategory>D</OpportunityCategory><FundingInstrumentType>CA</FundingInstrumentType><CategoryOfFundingActivity>O</CategoryOfFundingActivity><

Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get result only from the first field

Hello and thank you for everyone I have api documentation from a Delivery Company and I would like to get shipping quote to our airtableThat’s what I got from themhttps://api.aitworldwide.comif anyone have idea I would love to know thank you 🙏

I mistakenly clicked 'unsubscribe', and now I can't receive any emails from Airtable Automation (noreply+automations@airtableemail.com). Since my email provider is not a common one like Outlook or Gmail, I don't have the option to add 'Safe senders' or 'domains'. Is there any solution to my problem? Thanks a lot!

We have an Airtable business account – it's our slow season so we're trying to save some money so I'm working on changing up our base design to be more forms-based.One thing I'm curious about though – say I make an interface with a button that triggers an automatic, then I have a user with read-only access and an unpaid account.  I assume that they would not be able to push that button to run the automation, is that accurate?

Hi, I have a Contest Definition Table  that is capturing specific dates related to a contest.  I have start and stop dates for about 5-7 different stages of a contest, so Nominations Open, Nominations Close, Voting Opens, Voting Closes, etc. I have a record template set to create a set of tasks in a separate Tasks table for each contest based on those dates. The tasks are linked to the Contest Definition Table, All of that works just fine.  Each task has it's own Start and End date. There are actuals tasks for Open Nominations, and Open voting which is set based on dates designated in the Contest Definition Table. What I am having a hard time figuring out is how to update theTask dates when dates change in the Contest Definition Table. Thanks for any help you can provide. 

Hey Airtable community,I've got an automation where I need to create multiple task records when an episode is marked as "received". Here's my setup:Tasks List table: Contains template tasks linked to specific showsEpisodes table: Where I check "received" to trigger automationTasks table: Where new tasks should be createdCurrent automation:Trigger: When "received" is checked in EpisodesFind records: Looks up matching tasks from Tasks List based on showCreate record: Tries to create tasks in Tasks tableProblem: The "Create record" action creates one record with all tasks combined, but I need separate records for each task found. Quick example: The "Tasks list" table has entries for Task List    | Show |Transcode | Show A Show B |Send to A  | Show B |Send to B  | Show B |Send to CShow A : may fit one of those criteria. Show B : fits 3. When run the automation for show B I get this single recordTranscode, Send to A, Send to B |  Show B |Whe

Hi Everyone,I’m experiencing a frustrating issue with a user in my Airtable workspace. I’ve set their seat to Viewer, but I’ve noticed that it occasionally changes to Editor without my intervention. This forces me to periodically check and reset their seat to avoid being charged for an additional Editor seat.This month, I missed checking for a couple of weeks and ended up with a $400 charge due to the seat change. Airtable’s customer support has been great about refunds, but I’d like to find a solution to prevent this from happening altogether.Has anyone else experienced this issue? Are there any known fixes or preventative measures I can take to ensure the seat stays set as Viewer?Thanks for your help!

Please solve for me. If I wanted to control which bases a collaborator (individual) has access to and added the individual to each specific base, am I only charged once, since same user?Example, there are 5 bases in ABC workspace, and Bob needs only access to 3 of them. He’s added to all 3. Since same user/email address, is the charge only for one collaborator?

Hello 👋We are trying to create an automation which allows us to review membership applications before sending invitations or creating membership accounts.We can get the Webflow Form data to Airtable but are struggling with how to get the data into Memberstack 2.0 and have it create membership accounts once approved in Airtable using a status update in the table and then have Memberstack send email invites to approved users.The intended process works as follows:A user fills out a native Webflow Form on the websiteThe form submission triggers a scenario in Make to send the form data to an Airtable BaseAn Airtable Automation triggers an email to notify the team of a new membership applicationThe team review the pending application and approves the submission in Airtable, setting the status to approvedThe newly approved submission is filtered into an approved-only view within the Airtable BaseThis change in status is read by Make and sends the submission data to MemberstackMem

Hello,I am trying to figure out how to create a form to add attachment to an exciting record.I have a form that updates  any field including attachment in exciting record but problem is it doesn't keep attachments that was there prior.My main idea is to share a form with anyone online so that anyone could only upload files to an existing specified record and not be able deleting files that were uploaded by others.  Thank you.

We are setting up a form that will be filled out by campus staff at many different colleges/universities, so there is no one @ domain. We want to ensure that no one submits a non-campus email address, however, so we want to make sure that regardless of the rest of the domain, it ends in .edu. Is there a way to do that ? They won't be logging in or anything, I just need the form to reject anything that ends in .com, etc.

Hello I have a form which accepts email from user. If the entered email is not in master list of emails, then form should highlight this to user and should not proceed with submitting form. Please suggest if there are any direct / workarounds Thanks

Hey everyone! I’ve set up an automation in Zapier that sends signed agreements from our service to Airtable. I’ve gotten everything to work as I want it to, but not all of the PDF:s are attached in airtable. I can’t really see a pattern to why the documents wouldn’t show up. From what I can see in the version history of the rows that aren’t, the PDF has been there but then instantly removed. It seems the problem lies with Airtable as the document shows up, but I can’t figure it out. Here’s what it looks like in version history: Any ideas on why the document gets deleted?

I have an airtable that has the following data: [ { "id": 46, "createdTime": "2024-11-22T06:48:11.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "recFO8uEMB7wZaSYw" ], "External ID": "3914", "Created": "2024-11-22T06:48:11.000Z", "Last Modified": "2024-11-22T19:42:20.000Z" }, { "id": 47, "createdTime": "2024-11-22T06:48:35.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "rec6lTjVaKUR6gSuQ" ], "External ID": "urn:li:share:7265617134745976832", "Created": "2024-11-22T06:48:35.000Z", "Last Modified": "2024-11-22T06:48:35.000Z" }, { "id": 49, "createdTime": "2024-11-22T06:49:14.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "rech7SZ12yAqOSdmS" ], "External ID": "18114831709420263", "Created": "2024-11-22T06:49:14.000Z", "Last Modified

I have a somewhat unique scenario I need help with.  We are using Airtable as management software for a load securement operation we run. We secure loads for a customer at their location. The customer themselves has an older system they use and they don't allow us to directly integrate with their system to get the load information we need. So what we have is a Selenium process that will go to their site every 15 minutes , so we have as close to real-time updates as possible and pull a certain amount of days in the past and future and then export the load information to a CSV file. This then gets dropped on a server where we feed the information from the CSV file to airtable over API to a table. That information then goes from that table to another final one. We did this because, at certain times, users need to manually put a load into Airtable and because of the way we have to get the information into the system, we can't have the setting that would have Airtable delete the record

Is there a way to see which link was used to create a specific record? We use AirTable forms for surveys and have lots of different survey links. I’m looking for a way to see the specific form link that was used to submit that specific survey. Is this possible with a formula?

HI,  I run a real estate agency and woud love an easy way to create a PDF from images in an attachment field.Basically the way we do inventory is by images and it takes agents too long to drag and drop images into a doc file. Woudl be great if they can upload all images to an attachment field and then the PDF is created with the all the images.  Whats the best way to do this? Preferably free or very cheap. We usually need about 60-100 inventory documents per month. Thank you in advance!

Hi all! So, here’s the use case that spurred some thinking… I have a HUGE, monster of a base that is a bit out of control. It contains many intricate rollups that drive some housekeeping/reporting processes. Now that Airtable Sync is available, I’m working on moving those high-overhead processes out to their own bases in the hopes of speeding up the “master” base. One of those processes is a nightly report. The report is driven off of a view in the master base. I synced this view over to a new base, and set up a duplicate of the report. To test it, I’ve been letting it run the past few nights to compare the new version to the current version… and surprise surprise, they are not the same. Current Report: Runs from source/master base, triggered by a zap that runs on a schedule - every night at 8PM a record is added to a table called [Automation Launcher]. This record triggers a script that aggregates the report data, spits out the HTML which is then picked up and emailed by Zapier. New R

Usability problem when linking to a record from the from the ‘one’ end of a many to one relationship.We visit homes to help people reduce carbon footprint and save money by taking energy efficiency measures.On every visit we recommend or take one or more actions, each of which has a specific ‘deliverable’  that holds standard values for savings etc.The entity relationship is:Visit to action = 1 to manyDeliverable to action =  many to 1We have many different deliverables, over 200. When adding a new action, which is usually done using a form that is prefilled with the correct Visit, the Deliverable field presents a long list that is in seemingly random order. I cannot find a way to sort or group the selection of links. Interfaces do not seem to help.Can anyone advise?  This must be a common issue . . .