Other Questions

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’m looking for a way to have a calendar view of upcoming birthdays. I can use the formula below to show the CURRENT year’s birthdays but I also want the calendar to show NEXT year’s birthdays so that in December 2020, I could look at the Calendar and see the January 2021 birthdays. I know I need a separate field and have the calendar us both fields but I can’t figure out how to add 1 year to the formula below for the second field., DATETIME_PARSE( DATETIME_FORMAT( BirthDate, ‘MMMM D’ )& ’ '& YEAR( TODAY() ), ‘MMMM D YYYY’ )

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

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?

🚨🚨🚨🚨🚨🚨 SIGN-UP USING THIS LINK 🚨🚨🚨🚨🚨🚨🚨🚨Hey!!For the last few months the idea of running a Community Led Airtable Hackathon has been lingering in my head. When, how, and what is not clear at all to me yet, so I wanted to open up the discussion early on to make sure this is really community led.Brainstorming:Format: Virtual (for sure). Synchronous (everyone builds during a given time frame) or asynchronous (projects submitted over a few weeks). Themes: Specific theme (e.g. procurement, marketing ops, nonprofits, etc.), or leave it totally open to “build whatever you enjoy”? Why I think this could be fun: A chance to show off creativity. A way to learn from each other’s builds. An opportunity to meet new peers. A reason to push Airtable to its limits in unusual or inspiring ways (different to the day-to-day work we do for our clients or within our organizations).  Would love to get some input from the usual suspects here, and from any other Airtable enthusiast!​@Scott

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 if you have a fix or if I should just contact

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.

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 setting up this integration?I would greatly appreciate any insights, experiences, or recommendations from t

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?

Is there a way to prevent duplicate entries in a particular column? Thank you!

My organization seeks ability to create Airtable based apps with a proper user portal for external users to create/register and log into their profiles.  Unfortunately, Airtable portals doesn’t fit our budget for the number of external users we might expect. (Approx 400).  (we have business plan by the way) Even Softr is pretty pricey, but it seems like a halfway decent option.  I have looked into many different options from Pory.io, Zite, Stacker, Noloco, Glide, WeWeb, Bubble.io, Jet admin, etc  even thought of possibly seeing if I could linked Airtable to a supabase and build portal in Bolt.  I am not very technical, but I want to learn how to do this myself and help build a solution or find the right one.   there are so many options, and let’s say the budget is $2000 per year for approx 400 external users.  This is on top of the existing seats paid for the business plan for internal users.  what do people recommend, and why?  Please feel free to DM if you can offer more guidance. 

I am experiencing an issue duplicating one of my bases. The details are: Base ID: appMbMonUXRj3FMXX Base name: QUAN LY TNC Issue: When I attempt to duplicate the base (both with data and with structure-only), the process never completes. The dialog shows “Duplicating your app is taking a bit longer than expected,” but even after more than 12 hours, the duplication does not finish. Troubleshooting attempted: Tried duplicating with full data → stuck. Tried duplicating structure-only (no records/attachments) → stuck. Tried in multiple browsers and workspaces. Waited over 12 hours without completion. Already tried to create a new base from a snapshot → still unsuccessful. Anyone have experiences in this matter?

I need to manage multiple deadlines for multiple projects & clients more efficiently. I don’t want to update deadlines in multiple places, but that’s where I am. This isn’t efficient and will not work for the long term. Here is the current setup:I have a Primary Base I use to manage grant research, tasks, and profiles for all of my Clients. This includes 2 key tables: a Research Table and a Task Table. The Research Table is filtered into views that are specific to each client. Each of those views are synced to a Table within a Separate Client Base. That Separate Client Base also includes a second Submissions Table that is manually updated with specific due dates and other requirements that are unique to that Client (although some research may be relevant to multiple Clients, specific details will be unique to each client). This Separate Client Base is shared with each Client. The Task Table (in the Primary Base) is manually updated with a wide range of tasks that is grouped by Clie

Is it possible to add simple text blocks within a form to break the form into multiple named sections?

I’m syncing records from a source base into a separate working table. New records from the source base are showing up on the sync’d base, but updates to the record (e.g. selecting a different single source field entry) are NOT syncing. The base is set up for automatic sync. Is this a bug, normal (i.e. updates to records don’t sync), or is there something I’m missing in setup?

Hi everyone, I’m teaching a course which requires students to label and recognize certain kinds of sentences. I have a list of sentences for them to practice on in a table and the answers in the next column. I’d like to set up a kind of self-study tool for students. The Flashcard App would work really well for that, can I somehow share that with my students? It’d be even better if I could randomize it. The ideal use scenario would be a multiple choice test that would grab, say, 10 examples and then reveal the correct answers to students when they submit. But I’ll take what I can get! Thanks!

Hello! I wonder if you might give a way of offsetting the “Q1”, “Q2”, etc markers on the Gantt timeline, to support a fiscal year that does not match the calendar year. Or, if not that, to hide the markers altogether. I realize there’s a way to use formulas to have fields reflect an offset fiscal year based on dates, but I don’t believe it’s possible to change this header and it’s very confusing for viewers. Thanks!

How do you reinstate a deleted record? It’s been 24 hours since we've noticed - is there a way to revert to a previous version?

This is what I have tried: "http://nwatagalog.xyz/maps/"&pinColor&"/“number_”&sort&".png" I’m getting this error:: “Sorry, there was a problem saving this column. Invalid formula. Please check your formula text.”

Hey all, I’m experimenting with an idea but am not sure it’s possible (yet) and I would love to hear your input on whether this is doable or not. I have a script that spits out custom reports. Is it possible to insert a button (or link/hyperlink?) into the report, to act as a button which would then run another script? Thank you

Hi All! I am creating a form in Airtable and would love to allow users to see specific text based on their responses. I am familiar with using conditional form fields, but they seem to be limited to fields that require a response. I’d like to do something similar, but just with next that would inform the form user. Does anyone know if this is an existing functionality or if there are plugins to make it possible? Thank you!

Dear community,All the data in my database is formatted as DD/MM/YYYY. This question is about meetings we have. The meetings should be link to other records. But when I want to link the meeting with date format DD/MM/YYYY in another table, the format is MM/DD/YYYY, which is quite confusing. Any idea how I could solve this?There is a screenshot of the situation attached.