Ask the Community

Hi fantastic people, I am struggling with an automation.  I basically have one base that I have synched to my main base, certain rows. I then want these rows from the synched view to populate onto my main table. I have managed to get the event name to populate over but the dates do not. I have screen shots of each step below. Any help would be great.  This screen shot you can see the Main Sub Task populates to the Topic fine. I then want the Main Start Date to populate to the Enter Start Date and the Main End Date to the Enter End Date.  This is the actions part which fails: This is the update record part which is successful

I am using airtable to dynamic my website content and erliear it was working but now because of i have free version and too many request are there in the website so it shows me “429” error code and data doesnot fetched.

I have a `rollup` column, `A` that returns a `date`.  for example, 2024-07-24.I have a `lookup` column, `B`, that returns an array of dates.  For example, 2018-07-31, 2021-07-30, 2024-10-08Is there a way to  determines if any of the dates in column `B` are within 30 days (before or after) of the date in column `A`?  I need the formula to return a boolean.

I have a fairly simple database containing 5 or 6 tables. All of these tables are joined one way or another. I am trying to create a word document using Formstack and to run it via the manual integration which I intend to automate through the use of a button in an Interface when I get this working. I have built my first document and mapped all of the field tokens from my Airbase table into my Formstack document and it works a treat. I have now gone to build my second document which uses some fields from the table which I am in when I select the record in Airtable from the integration but it also references so fields from another table albeit in the same base. These fields do not pull through. I have recreated a link field and chosen to show the “add look ups” fields from the other table in the table where I am running the document form, re-written the placeholder references for Formstack and hey presto, it works! Is there any other way to do it wit

Hi,We run a photo studio CRM with Airtable, and would like to start storing customer end product images there. This would mean some 20-30 images at 2-3 mega each and hundreds of customers annually. We’re on the Team plan so have 20 gigs limitation per base for attachments, so space would end quite soon.The for me easy and obvious solution was to write to Airtable sales to ask if one could just pay for more storage, since we don’t need the Business plan additional features (and eventually that would also hit storage limitations), but they don’t seem to be responding.I know the storage limit is per base so I guess one could somehow create more bases just for adding attachment storage, but I don’t see how to do that. And it seems this would create problems when we need the second, the the third “extra” base.Hence my question here, what would your experiences be with this?Any best practices here?Rgds,Björn

Hi- I want to create a multiple choice quiz of 10-20 questions to help with onboarding. I want the person to see the results as a summary at the end. It would also be nice if they can not complete at once, they can return to it later? Bonus is adding some images of GIFs

I need to center the logo image of my client in the body of an email. How do I do that?  (Don't worry - I'm not using an image in an attachment field. )This is what I currently have, but the image is not actually centered. Can anyone help?<div style="text-align: center;"><img width="400" src="https://static1.squarespace.com/static/myimageurl.jpg"></div>

Hi there! I’m just curious how I enforce unique values in a column or a group of columns – that is, how to enforce a unique constraint. So that I don’t, for example, accidentally enter the same person (combination First Name + Last Name) twice.

I can't find the base and the table I created when I want to link it to Tally. 

Hi there, I’m trying to set up an airtable automation to update an existing record in a table “new members” after that member submits additional information through the airtable form I’ve embedded on my website. The form is set up to automatically add their Memberstack ID to the new submission so I can match it to existing records and use this to update them but I cannot get the automation to work as it seems to be based on the Record ID field, not Memberstack ID. Can anyone help me out Thanks in advance Charlie

Hi there — I suspect the answer is ‘you can’t’, but is there any way to restrict a user to only be allowed to upload a single attachment to an attachment field in a Form view?

I have created a form to create new Project records. Each project requires a unique ID which matches a particular format (XXXX-000).How can I make sure that no-one uses an existing unique ID when filling out the form? I really need to avoid duplicate Projects, as creating a new Project has a lot of downstream actions which can get messed up if an ID already exists.I have another form which can create new versions of an existing Project, which I can use as a redirect URL if necessary.Many thanks in advance!

I'm trying to set up an automation so an email is sent out to a client when their video's status changes to CLIENT REVIEW. Specifying that wasn't a problem. However, when testing it, I keep getting an error message that the To field is empty. I've mapped it to a field containing an email address, and specified the exact record to use set to the correct Status, but keep getting this error. The token is set to pull the Value. I've tried the other options but get the same (non) result.How do I get this to work?Thanks

HelloI can’t access Data/automation/Interface as I got this message. I tried a chrome icognito window to re signing but same issue. Is this widespread or only impacting my account? An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pgl44daDCB1bvrY3S

Today I noticed that the images I add are not showing up in the grid, kanban, Gallery, and Interface view. Some of the pictures will show once you click on them but they wont show as a thumbnail. and when I click to view other images they don't show the thumbnail nor the image, they only show an error message. I started to troubleshoot by trying to attach different image types and sizes but to no avail. I also tried attaching the same exact images from records I made last week but they too are now showing this error image:“Previews for this filetype are not available”File: dsc_6285(2).webp - 10.8 KBThe 3rd image will show when I click on it but it wont show as a thumbnail. The images I attached last week are showing up still, as a thumbnail. look at where the red arrow is pointing.  To clarify, yes, I am only clicking the “Add Attachment” button to upload my images. No automation.  I’d be very grateful if anyone can help. Please let me know

!--startfragment>In  Airtable base, there is a column named Task with a dropdown field containing the following status options:To Do In Progress Paused Completed TRB In Progress TRB Paused TRB CompletedConditional Logic: When the status is changed to In Progress, the user should only be able to select from: Paused Completed TRB In Progress When the status is changed to TRB In Progress, the user should only be able to select from: TRB Paused TRB Completed When the status is changed to TRB Completed, the user should only be able to select from: Paused Completed TRB In Progress FYI already tried On2Air and they are only focusing on back up.

Problem: I have a membership table with members listed by name. I want to keep people from typing their information into the membership form on our website that feeds into the table twice. There is no way that I can see for me to set a field to not allow duplicate entries. I would like to set the phone number as the unique identifier for each member. I see no way to select or set this field to not allow duplicates. I know I could that in Access by setting it as primary, but I can’t do that in Airtable.

Hello! Anyone know how to set or change your name in this new community platform?I signed in with SSO, it just assigned me this name (jon21), and I don’t seem to have any way to change it 🙄. I also never received the ‘Welcome’ badge, in case that impacts how I initialise in the platform.

How do I change my community display name.When I established my community profile a few years ago, I inadvertently picked -airtable- as my display name.I need to change this because community members think I am AirTable when, in fact, I am just a customer. I am getting tagged on all sorts of discussions, and you guys are NOT getting tagged.How can I change this.

I’m trying to create a system that generates simple codes from employees’ SSNs for internal use. The SSN is stored as numbers, e.g., 123-45-6789.I want to create a new formula field that converts each number into a letter using a reverse alphabet mapping:Z = 1, Y = 2, X = 3 … A = 26For example: 1 → Z 2 → Y 0 → J (or another letter of choice) Is there a formula in Airtable that can do this conversion directly?For reference, numberstoletters.com does similar conversions, but I want to implement it directly in Airtable.

Hello Airtable Community,I am currently exploring ways to enhance our workflow by integrating Airtable with Microsoft Copilot. My goal is to be able to ask questions related to our Airtable data directly within Microsoft Copilot, which already has access to our other business files like emails and documents.Use Case: We use Airtable extensively for managing various aspects of our business. Having the ability to query Airtable data directly in Microsoft Copilot would streamline our processes significantly. For example, I would like to be able to ask questions such as "What are the latest updates on table x".Questions:Has anyone successfully integrated Airtable with Microsoft Copilot for similar use cases?What are the best practices or tools (e.g., APIs, automation platforms) to achieve this integration?Are there any specific challenges or limitations I should be aware of when settin

Hey there, so I’m all of a sudden, getting this error when trying to submit this form.  Any ideas what might have happened?

i have a form linked to my website for registration purposes. is there a way to prevent users from using the form after they have already used it for registration?

Hello! I am trying to create a line chart in an interface that shows the number of records (leads in this instance) we received this financial year vs last financial year. I essentially want to see how we are tracking in comparison. What is the best way to go about it? I have created a formula which indicates what FY the record was created in to assist with grouping but I just cant get it to display correctly.Thanks in advance for your help! 😊

I’ve been exploring different ways to structure bases for both small teams and growing organizations. On one hand, you want something simple enough for everyone to understand and use daily. On the other hand, as the team scales, you need more advanced features like automations, interfaces, and integrations.💡 My question to the community:How do you approach building Airtable systems that are simple for new users but also scalable for future growth?Would love to hear your strategies, lessons learned, or even mistakes you’ve made along the way!