Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Hello, my airtable is used within data within a project management platform I built in sotfr. my client portal users enter data via a softr modal which lands into the airtable and a softr table view that displays the entered data. I need each entries of by user to be auto-numbered from 1 to whatever the final entry is.For example if the data represented a christmas wishlist, and little bobby entered a “toy truck”, “building blocks”, and “book”, I need the list to show:toy truck Building blocks bookAnd if little tommy entered “Basketball”, “ipod”, and “ball cap” the list should be basketball ipod ballcapThe number needs to be hard coded to the entry, so that when the list is sorted differently the number follows along, for example, if I sort little tommy’s list within the softr presentation layer alphabetically the list should be:3. Ballcap1. basketball2. Ipod So how do I assure that the user’s entries are getting numbered automatically and the numbering range is limited by the scope of
Hi all, I want to do some fairly complex actions when my users create a new record, and in certain circumstances block them from creating it.Here is the logic that I want to run when I create a new record: If FieldA is not null Look for a record with matching FieldA If such a record is found, do not add this record, stop 🛑 Else: If FieldB is null Fetch BValue from external source with a script that takes FieldA as input If FieldB is now not null: Look for an already existing record with a FieldB value that matches what I found If such a record is found, do not add this record, stop 🛑 Else, update this record with the new FieldB value The first issue is that I have nesting “IF”s here. And I cannot seem to nest IF statements in the automation interface. Is there a way to implement nested-IF logic in an automation other than by creating a custom script? The second issue is how to delete the triggering record. Is there a way to
Hi I would like to automatically open an input form based on a user input.I have a visitor request form(s), First I would like to ask the user to identify the visit type (Form 1), based on a selection of a single drop down. After the submit Form1 I would like to determine which Form to open next for more details based on their selection. How can I accomplish this?
I’m missing which field/value is used with two tables are linked. Can someone point me in the right direction? In particular, I have a master business directory table and I want use automation to push in the linking value to the separate Department table. I would have thought that they are linked on the record id, but when I try to push the Department record ID into the master table, it’s not recognized. It seems to want the department name, which is not always unique. Is there a place to see the linking values between tables?
I can’t be the only one who finds the edit field dialogue box for single and multiple select fields outrageously small, can I? If we have two or three dozen options, or even more, how are we supposed to manage them when we can only see three or four at a time? Is there an extension or something that helps with this?
according to the What's New page found at https://www.airtable.com/whatsnew , it says that Interface Charts now support Multiseries and dual y-axis charts and it includes pictures.I don't see these anywhere in the Interface Charts interfaces? Where are these charts and how do you access them to add to an interface?Much appreciated!
[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields📌 The problemI'm constantly getting this error: pgsqlCopiarEditarRuntimeError [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text. Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.🧩 Airtable Table Details: Table Name: Table 1 Fields: Nome do Cliente (Single line text) Produto Qtd Valor do produto Valor Total Data da Entrega ✅ Confirmed: Date with time format ❌ Formulas tested (all returned 422 errors in Make): plaintextCopiarEditarAND( {Nome do Cliente} != "", IS_AFTER({Data da Entrega}, DATEADD(TODAY(), -5, 'days')) ) Also tried with IS_BEFORE, simplified formulas, and also using "ok" in a formula field with static text — still getting the error.✅ Formula that worked in a previous database: plaintextCopiarEditarAND( {Cliente} != "", IS_AFTER({Entrega}, DATE
Now Available for All Customers who can use ScriptingWe're excited to announce the general availability of Secrets for Automations! You can now securely store and use sensitive information like API keys, passwords, and tokens in your Automation scripts without exposing them in plain text.Why Secrets MatterWhen connecting to external services in Run Script Actions, you may need to include sensitive credentials directly in your script code. This created potential security risks, as anyone with Editor access to your base could view these credentials.With Secrets, you can now:Store sensitive information securely in Builder Hub Share access selectively with specific user groups (for customers on Business and above) Use the same secrets across multiple bases and automations Prevent unauthorized viewing of secrets or editing of scripts containing secretsHow Secrets WorkCreating and Managing Secrets Secrets are stored in your Builder Hub, accessible from your account menu or directly at airtab
I’m creating a WordPress catalog site, of which the products are stored in an Airtable database. This base remains the core of all our products, and with the use of a custom import script I’m pulling in the right data from Airtable to WordPress. Now I’m wondering whether I should also import all images (which are stored in the Airtable product records as well) to the WordPress media library (thus duplicating them), or whether I can just use the Airtable image urls which the api is giving me. An inspection of an Airtable image url (with httpstatus.io/) tells me that Airtable serves them from Amazon S3 via Cloudfront. On one hand I’m thinking it’s a good idea to use the airtable img urls because: They appear to be cdn-served and therefore faster and therefore good seo value it spares me importing hassle and hosting space On the other hand, I also have some concerning thoughts about doing so: dl.airtable.com is nowhere near the domain name of the wp site. Therefore google will punish
Hi,I am reading this article by Airtable https://blog.airtable.com/interface-designer-permissions/ and where it talks about the use case for building a HR base so managers can see their team, people can see their own records etc. I don't know how to make this work in Airtable. Does anyone have any experience of doing this. I am on pro plan."For example, let’s say your HR department wants to create an app for performance reviews and calibrations. Only managers should be able to access their team’s reviews, while individual employees will still need access to their own review. Instead of creating multiple bases, share views, or interfaces, you can create a single interface with a few filters."
Hi Everyone! I have an automation that is set to find records in a certain view and send them an email. I know when in testing Airtable will only show the first 10 records, but it is also completing the automation for the first 10 records as well and right now that view has about 18 records in it. Any advice on whats going on with it?
Dear all, I do have a base with several tables in it of which HCO’s and HCP’s are two. HCO’s are Hospitals where HCP’s (doctors) are employed. I would like to be able to select and/or display hospitals based on whether or not certain HCP’s are available in a hospital (e.g. : display hospitals which do employ orthopaedic surgeons but do not have ophthalmologists available.Tried Airtable support, which came up with scripting. Please feel challenged to propose a non (or very, very, low) code solution for this! Thanks so much,MichielThe Netherlands
RAS Corporate Advisors streamlines and accelerates the GDRFA Golden Visa application process. Our friendly team guides you through the golden visa application to ensure quick approvals for students, investors, and professionals. Our particular awareness of golden visas for students and visa by investment helps us to aid you in quickly acquiring UAE residency.
Hi everyone, I’ve searched the community but only found some older threads on this topic, so I wanted to bring it up again. Are there tricks/workarounds that do not including setting up rules within mail-inboxes to just delete the notifications? Right now, I can follow or unfollow comment threads manually, but it’s tedious to manage this every time. I’d really love the option to set a default notification preference—specifically, to only be notified when I’m mentioned. Having a global setting like “Notify only when mentioned” would make the interface much more manageable, especially in bases with a lot of activity.
Hello, I am using FILLOUT forms in integration with Airtable.I saw something strange, that if I define a filter on records in my database, then in FILLOUT, I can only select the records that are displayed in the database, even though they are in the table, they are just not displayed because of the filter.Does anyone know if there is any way to solve this problem?
I created a hyperlink in a long text type field, with rich text formatting enabled in gallery view. Works good. But when folks click on the link, the whole card opens. Is there a way, in a long text field with hyperlink, to go directly to the linked URL and not open the card.
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.