Ask the Community

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 . . .

Hello all. I am considering Airtable for a product/portal I need to build. I can't glean from the docs and other info how my setup would be billed or if it is achievable so am looking for some guidance. - I manage a database with data relevant to different clients of mine.- I want to share that data with the different customers I have via an interface for a nice user experience. Each client gets a login, and can see the data/projects relevant to them- Those clients then have customers who need to have access to the specific projects relevant to them. Those clients will need logins also in order to access their specific projects - The only action both my clients and my client's clients need to take is updating the status of a row of data (think a list/queue of items to review and approve)I have attached a crude diagram explaining it. Is this setup achievable? How would it be billed? Thanks,Darrell

Hey. I have a gantt chart that shows when multiple items are hired and dates associated to them. Each record is one item and has fields for 'delivered', 'setup for use', 'deadline to be ready', and then 'collected'. This means each record is one item but has 4 dates / time periods attached to it. I dont want to split this into multiple records with steps for each date, as the overall specification of the hired items is dependent on one record per item (this is shared with the supplier as a list to cost up)However when I pull this into the gantt chart so I can get a full schedule, i can only use of the date two fields (start and end date) so I am not getting what I need from it. Does anyone know a workaround for this?

An automation of mine that usually runs fine started throwing this error and failing sporadically. It's for a webhook automation that brings in orders from Shopify. In my attempt to isolate the issue, I've deleted every field from my "Create Record" action, except for Name (single line text) field where I attempt to enter the Customer First & Last name, but it still fails. 🤔 🤔 There are no roll-ups on the table where I'm trying to create the records. There are some formula fields on the table, but I'm not trying to write to those fields. Any ideas? The other threads related to this error message in the community forum did not contain an answer.  

Hello. I am new to Airtable and have spent a better part of a week trying to figure this out and I'm stuck. I hope the community can help me out.Our Airtable connected to our Shopify store via Airpower, so everything is synced in real time.We have a Table named 'Order Line Items' that displays each Shopify order and each item (SKU) is separated in its own row within the order. What we are trying to achieve is to display the inventory number for each item.Inventory data is stored in another table named 'Variants' and organized by SKU in one field, and the inventory quantity in another field.Does anyone have experience with dealing in anything similar?I'm not sure if this is relevant, but I have gone as far as being able to create a field in the Order Line Items table that links to our Variants table (that contains inventory data). However, I have to manually enter the SKU that was ordered before inventory count can display. The example below where for it to work, I have to type in the S

Hey,Can someone tell me where airtable gets the highlighted names from? I can't find any settings. The table is also named differently.BestMatthias

Hi there, I’m new to airtable! I have a huge list of contacts that I need to categorize. I am using the drop down Multiple Select Field tool to create “Tags.” I have over 2,000 contact and airtable is only allowing me to select one contact at a time. Is there a way to select 100s of contacts and batch them all as the same tag? Thanks! Meredith

I’m managing service requests (tickets) for apartments using Airtable and need help creating a more advanced lookup field. Here’s how my base is set up:Tickets TableEach record represents a service request (ticket).Each ticket is linked to the apartment it is for, using a linked field to the Apartments table.Tickets have a Tags field (multi-select) where multiple tags can be assigned (e.g., Appliances, Plumbing, Internet, HVAC).Apartments TableEach apartment is a record in this table.It is linked to all tickets associated with that apartment.Current SetupIn the Tickets Table, I have a Lookup Field that retrieves all other tickets associated with the same apartment as the current ticket. For example:Apartment A has three tickets:Ticket 1 (Tags: Plumbing, HVAC)Ticket 2 (Tags: HVAC, Internet)Ticket 3 (Tags: Appliances)When viewing Ticket 1, I can see a list of all three tickets because they are all linked to Apartment A.What I Want to DoI want to create a field in the Tickets Table that o

Hi everyone!I am trying to have an automated Slack message sent every Friday to notify about the leaves planned for the coming week.However, my current automation (trigger: at scheduled time + action: find record + Slack: send a message) uses the List of Records which ends up very bulky and unpractical for the team.Ideally, it would create a list like:@Marketing-team: no leave@Hardware-team: Joe (2 days, Mon-Tue, Leni (1 day, Mon)etc...Could anyone provide some ideas on how to make this announcement more digest?Looking forward to your solutions and grateful for anyone's time looking into this! 

Hi!I am looking for a way to connect airtable and slack allow users in my Slack to use forward slash commands to request data from from specific fields in a base in Airtable. The goal is to create a seamless way for teams to retrieve specific information directly in Slack from Airtable. I am the main admin in our Slack and Airtable so permissions arent an issue.Example:Use simple commands like /Airtable to retrieve theinformation.Information I am trying to request would includeRegionLanguageQualityetcBeing able to filter the content would be great too.I have tried Airtable automation but havent been able to figure it out.Thanks for your assistance in advance!

Hi guys,For each of my clients, I create a project management interface where they can keep track of the project's progress. One of the pages on this interface is a list of tasks.As of now, I have to manually link each newly created task to the proper project. So I would like to automate this process.Ideally, I would have liked to set up an automation chose trigger would have been 'when a new record is created on this interface'. But this trigger doesn't exist.So the only workaround I found for now is to create a List view with hierarchy on and to show the Project name on the level above. But I feel it adds unnecessary clutter to the page design since clients of course only want to see the tasks related to their project.I assume I'm not the first one to have this need. So do you guys any other workaround to suggest?Thanks for your help.

Hi All!I am trying to change a single select field in my base to a linked field, with all the single select options populated as rows in a new table. I have a long list of single select options that I do not want to have to re-type manually if possible.I could have sworn this was possible in the past with a right-click action, but I can't find it anymore (or I don't remember right).Thanks,Jaco

Hey guys!I am trying to link a Outlook 365 group calendar thats shared with me to airtable, but airtable only seems to see My Calendars (one's I've created).  Does anyone know of a way to get airtable to see the group calendar? I thought it might have it's own login since it has a email address, but apparently not. Let me know if anyone has run into this or has a solution. Thanks! 

Hi all;On Chrome, when inputting into an interface Long Text field, it resizes to half-width (see image), which is a pain in the butt for editing long copy on the fly. It's only recently started doing this, and it applies to both rich text and non-rich text fields.I'm not sure if it's an Airtable or Chrome problem. Does anyone have any ideas on how to fix this? Thanks!

me: Can it be? … me: Airtable has no “Signature Field”? no… me: realy? noo… me: joke, right? nope… me: WHY!!! … me: crying :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob: :sob:

I have a "master" table containing Clients, and an interface page that presents selected information as a dashboard launching point for each client. I have a separate table where clients can input "evidence" of all kinds, and from that I can filter, sort, whatever until I can work with that information however I like.  I have an interface page for this table as well, where I can manually select which client I want to review the evidence for - and that's where I need help.I want to have a button on the Clients interface page that will take me to the Evidence interface page with data already filtered to match the Client from which the Evidence button was clicked.  I don't know how to grab that information (client name) from the Clients interface and feed it to the Evidence interface filter element before I even land there, as a clearable filter (b/c I might then want to stay in Evidence but move around to a different client without backtracking to the Client interface).Tha