Other Questions

I have looked at a few of the prefix scripts but cannot find one that fits the bill for us.When a new record is created, our Ref field is manually inputted as:ABC2025-01 (Enquiry identifier - always the same 3 letters, Current Year, sequential number)Occasionally, the Ref field is filled with a subnumber, usually if a project gets split into phases. This is always manually inputted, so in theory the last project could end up being ABC2025-125-01.All we are looking for (hopefully) is once a new record is made, the Ref field is automatically filled with ABC2025-02, next record ABC2025-03 etcAny help appreciated  

We have an Airtable form to submit internal orders, and it would be very helpful for our team to have a field that shows the last record number before filling in a new order. Not to create the order number – we have autonumbers set up – this is because they have to add the current PO to one of the files that gets submitted in the form itself. Right now they’re going and checking the latest order number in the normal Airtable view before submitting the form, but if they can cut that step out it would be helpful! Is there any way to add in a view-only or read-only field? I looked at trying to integrate the interfaces with forms too and that didn’t quite get what I was going for. Thank you!

When we embed forms on our site, we write the title and description on the page for brand consistency across pages. I do not need the form title to be repeated in the embed portion. AT adds the form title by default in any shared view and there seems no way to delete it. Is there a work around?

Hi everyone! Newbie here still getting my head around Airtable. I am creating a form with 14 questions. The answer to each questions is a scale from 1-5, 1 being none of the time 5 being all of the time. When the form is complete I would like to be able to total the 14 answers for each respondent (so if someone answered 1 for each answer their total would be 14). How do I do this?! Many thanks

I am using record templates to create deliverables and tasks. I am setting due dates relative to the "current date".  For example, I want the deliverable to be due "1 day after current date". When the template runs, it adds 3 days to the current date. If the current date is 6/30/23, it will put the due date as 7/3/23 rather than 7/1/23. If I use current date alone, it puts in today's date. Does anyone know why this is happening and how to prevent it? 

Hi,I have a situation where a public user would need to fill out a form, be able to view ONLY that record with their responses (with additional dependent fields displayed), and then print that record in a nice-looking format.  I've explored other integrations, the public interface option, etc. but I can't find something that would work for the entire process.  Does anyone have any suggestions? 

When creating a Form view, it would be helpful to be able to specify a “Read Only” view for a specific field. I am using linked records to display data from other tables but in some cases, only want to display the pertinent data, with no ability to modify it, or to add a new record. Not seeing that this is possible at the moment.

We use WordPress with Elementor and have noticed that the page containing our embedded Calendars and Galleries frequently freezes when viewed in Chrome. Additionally, the Calendar and/or Galleries in most instances do not appear at all. The embedded Calendars and Galleries work as expected in Firefox and Edge, though they can take some time to load. Is anyone else experiencing this issue? We've contacted support, but haven't heard back from them as of yet. 

I have a select drop down  field with number rating from 1 to 10,  1 - 2 - 3 - 4 .. etc...  .   I want to filter all the records that have a rating bigger than, let's say 6, but there's no number operators (">", "<") for the select field.Is there a solution to this?thank you in advance.

Hello everyone! I’m a complete beginner in Airtable and would greatly appreciate your guidance. I’m trying to set up a simple “Lab Reservations” system and have created the following structure:Terminy (Slots)Stores all available lab time slots.Fields include: Date, Start Time, End Time, Researcher, and Status (Available/Reserved).I’ve built a form called “Add New Slot,” where I want to include this instruction for lab assistants:“Here you can add your availability when you can conduct research in the laboratory. Remember that each study lasts a minimum of 30 minutes. Please add slots in 30-minute increments. For example, if you’re available on February 13 from 1:00 PM to 3:30 PM, you should add six separate slots: 1:00–1:30 PM, 1:30–2:00 PM, and so on.”Rezerwacje (Reservations)Allows people to sign up for a specific slot.Fields include: Full Name, Email, and a linked record to the Terminy table.I also have a form, “Registration Form,” which should only display slots with Status = “Avai

Hi all! I am running a T-shirt business and currently am filling orders. I have embedded a form onto my website so that when customers want to place orders, their info goes straight into AirTable. My question is this: is there a way to save this info in a customized PDF or Word doc template, and send this back to my customers? Any help would be awesome! Thanks!

Relative Airtable Rookie (Well, maybe a Sophomore) here… So forgive me if this is obvious or somewhere - but I sure have looked and haven’t been able to find it! I know you can use Airtable forms for other people to input info directly into your spreadsheets. Cool. Got it. But I need the opposite. What if I have all the info, but I want to generate a report or a form to distribute that? (And make it look nice?) Case Study: I produce a television talk show and I want to generate several different “forms” or reports. Examples: a research dossier for the hosts to prepare for their on camera interviews of these subjects with headshots, bios, topic-related background, social media links, etc. on the guest as opposed to a different one for the editor - with much of the same overlapping info but links to where all the A/V assets are (DropBox, whatever) versus one for “transpo” - providing home address and cell phone for the limo driver to pick him/her up, drop them off (but no one else should

Hi, how can I download the submissions to my form? I need to save each form individually as a pdf, word doc or something similar (not in excel format!) so that I can include it in the file for each person that completes the form. I kindly appreciate guidance on how to download each form individually. Thanks,

Hi everyone. I am currently working on a project for my client, to connect his platform dashboard with airtble.I am at the step in my demo test where I call webhook payloads api to get changes that are made in airtable table records. for changing existing record is ok. put for creating new record the payload returns "changedRecordById" instead of "createdRecordById" plus the payload is generated for each change on charate in a field.its important for me so i can lay my backend logic when to call update or create method. anyone has any idea why is stil receive payload this way. Thank you

We’re a film festival looking to pull the titles of our submissions in order to create slugs that can be used to create virtual posts on our WordPress site. I need a way to parse just the text from the submission, with the ability to remove special characters (i.e. " ’ ! ? ; : @ # $ % ^ etc.). I’ve gotten to this point so far: LOWER(SUBSTITUTE({English Title}, " ", "-")) This allows me to hyphenate the titles, but still includes special characters. Is anyone aware of a workaround for this, or do I need to manually create my slugs in this case? Cheers!

Hey there, I’m in need of some advice from the community. We have recently set up Airtable as a CRM and it is working wonderfully with the exception of e-mail tracking. We’re still using Hubspot for e-mail tracking with a button from within Airtable that takes you directly to the deal in Hubspot - so you can see/send comms to a contact. However, we’re really keen to ditch Hubspot but I don’t think it’s possible to solve the e-mail tracking from within Airtable. Does anyone have any experience with any other CRM’s that offer email tracking and offer a clean/straight forward integration with Airtable? Currently, we use integromat to bridge the gap which works well but we cannot use it for contact mapping. Any help would be greatly appreciated.

A bunch of people use a Shared Link that I created. When opened they have the option to filter data in this view, which is really nice. In this view they are allowed to print (or export to csv). Now, I found out that, when filtered, the Print command will still show all records! That’s too bad, because especially with a lot of records, you really don’t want to print all of them. Is it possible to adjust this? Frankly, it feels like this is a bug.

Hi everyone,I'm new to Airtable and really excited about using it! I'm trying to create a simple feedback form with four options, where one option is selected based on a URL parameter. I can get the selection to work when I use the ?prefill_type=xxxx parameter in the URL while logged in. For example:...airtable.com/appZv5lCwXXXXXXX/pagY4IFXXXXXX?prefill_type=xxxxHowever, this link only works for logged-in users. To make the form publicly accessible, I add /form to the URL like this:...airtable.com/appZv5lCwXXXXXXX/pagY4IFXXXXXX/formThis public link works, and anyone can fill out the form. But when I try to add the ?prefill_ parameters, they don't populate the fields. For example:...airtable.com/appZv5lCwXXXXXXX/pagY4IFXXXXXX/form?prefill_type=xxxxThe fields are not prefilled. My issue is that I can't get the prefill function to work in public forms, but it works when I'm logged in. I've searched for information but haven't found a solution. Maybe it's something simple I'm missing.Thank

Hi Good Airtablers:We upgraded to Enterprise in part for the Salesforce and Jira integration, but it seems that all synced bases are read-only. Is there a setting that can enable changes in Airtable to be upserted into Salesforce?I feel like this feature was there when our AE demo-ed it to us.Can anyone from Airtable show me how to edit from Airtable into Salesforce? And what the current limitations are.

I went to get into my airtable this morning, and it told me that I needed to request access. I am the person who set this up, and when it sent me the email to have the owner approve it, when I went to approve it, I got “This access request is no longer valid." I have a lot of data that I need access to. Please advise how I can recover my airtable.

I need to change the name and email for one of our accounts — new employee name, new employee email address. The login is currently "login with Google" — which I don't have a problem with. I have access to that email and I'm logged in (former employee email). Airtable states that in order to update the email address and the name, I first have to "add a password" and that "an email has been sent to [former employee email address] to add a password" — I am logged into this email account, and the email has never been received. I have repeated this step nine or ten times and have never received the email. What are next steps? I've also contacted support, for whatever that is worth.

Hi everyone,I’m currently using Airtable to manage inventory for my small business, but I’m facing some challenges in automating inventory updates and tracking low stock items. My goal is to use Airtable's built-in features, along with custom automation, to streamline the process without relying on third-party tools.The problem is that, when a sale is recorded in the Sales Table, I need to automatically update the quantity in stock for the corresponding product in the Inventory Table. Additionally, I want to trigger an alert when the quantity falls below the reorder threshold so I can restock in time.I’m struggling to figure out how to automatically reduce stock levels in the Inventory table when a sale is made.need suggestion !Thanks in advance,Dona

Hi - please note, I have searched all over support and community pages and cannot get a good answer. I am trying to embed a form on our website, and need to configure what happens “after the form is submitted”. Initially, we had a message, however, in the form itself on our site, that message appears midway down the form box (frame) – and cannot actually be seen. I would like to bring this up to the top of the form. This should be simple, I thought… but no. Then I tried to set a redirect to a “thank you” page on our site. When the form is submitted, a very ugly message pops up that the user will be redirected to said URL - and then it doesn’t and a new blank form appears. Again, this is not seamless. Any help on either above would be terrific. Thank you!

Imagine that we create two records in a table:1. The first is created through a form submission, so many of its fields are filled in at (or near) the instant that the record is created.2. The second is created by using the "+" button on a grid view. The record itself is created, then fields are populated as the user fills them in.Is there a term/pair of terms used to describe the "completeness" of a record upon creation? As in, the record created in scenario 1 is said to be **insert word here**, while the record created in scenario 2 is **insert other word here**.I often find myself asking other users how records are created in their bases in order to determine what types of automations are appropriate (ie. The "When a record is created" trigger can only be relied upon when you know that the necessary fields are populated on the record's creation). What word or phrasing is usually used for this?I'm ideally looking for the academic term but I'd love to hear anything that everyone else u

I received an email from accountsreceivable@airtable.com that our invoice from October is past due. I provided documentation that we submitted payment and have not received a response. Is this a scam?