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
How can you embed the full gallery view on a Wix Site. I don’t want users to have to click at the bottom of the table for the full view. I just want the full gallery view posted. Can this be done? This seems like it should be a no brainer but my brain can’t figure it out. Thanks for any help.
Hi, I’m new to Airtable scripting and am just learning my way around through hit & trial. I don’t have any javascript experience either, but I’ve used python in the past. I’m trying to write an Airtable script that sends data to my Integromat webhook trigger. So far I’ve been gotten the following: // Webhook URL let webhook = 'https://hook.integromat.com/integromaturl'; // replace with actual integromat URL // Table to send data from let tableName = 'Master Client'; // Fields to bind and send let fieldsToSend = [ 'Client ID', 'Client Name', 'Email', 'Created Time', 'Last Modified' ] I guess I’m stuck with what to do after this. My intent is to use the Airtable automation such that when a new record is created in this table (Master Client), I want this script to run. But what do I need to add to my script so that Airtable sends the information in my ‘fieldsToSend’ variable to my ‘webhook’ variable. All I seem to have done in my script is to create and assign v
When I am downloading a .csv file from my base when opening the file in Microsoft Excel some of the data is missing/changed. The field that is having the issue is a linked field that lists numbers from an autonumber field. It seems that after 5 sets of 3 digit numbers the numbers just change to zeros. I have attached photos of the data from Airtable and what I am seeing in Excel.
I am having an issue where I have a table that calculates a sum Total. I figured I could easily just show a user’s name + total on the interface but it seems very hard for some reason.Right now, I get the sum with a user’s name, but it then adds all of these columns for each unique sum there is within the data set.Example Image: And here is what the data looks likeSo I am just trying to make a table on the interface (as we will share that view) that simply shows Name + Total.I have a bar chart showing this, which kind of works, but just having 2 columns with plain text would be nice too in the interface.Thank you!
Explainer Video: Base: Airtable Same Table Backlinks - Airtable Universe Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir community) Sites: https://openside.com - Openside... Code: gist.github.com https://gist.github.com/on2air/b68450a877ab99fe4a93ef7f9c387568 same-table-backlinks.js /***** * Title: Same Table Backlinks * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community * * Reach out for all your Airtable needs This file has been truncated. show original
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?
YES! Yes, yes, yes! They are finally here!!! Airtable is a relational database. As such, it allows you to link records from one table to record(s) from a different table and keep such relationship on both sides.However, there are interesting use cases in which you’d want to link records from one table to records from the exact same table. For example, you might want to have one unique table for Tasks and handle hierarchy between them (e.g. Parent task, and Sub Task(s)).When creating a linked record field to its own table, you would have seen that only one field was created (the one you did manually). You would call this field Child Tasks for example, and link through it the child tasks to any parent task. However, the inverse relationship (backlink) would not be tracked anyway -meaning which are the parent tasks for each child tasks. To such effect we used to have to create yet an additional linked record field to the same Tasks table, and create all sort of nasty automations and scrip
In my interface I can provide a Pie chart that will show the % of yes and no responses to a survey question.Each response, yes or no, is tied to a month value. I want to see the % over time of the people that reported yes to display a trend chart month over month. Example in Jan 42% reported Yes, in Feb 100% reported yes. This would be similar to my average satisfaction score month over month. How do I take the Yes/No answers and convert them into a % of the population in order to track month over month?
Hi,I have an automation that is triggered when a record is created in Table X, and it then creates a new record in Table Y. This automation has been working well, but recently, I've noticed some failures in the Run History.It's not happening with all cases—only some. The trigger and all other actions work fine; the only issue is with the creation of the new record. The error shown is: “Creating the record failed due to insufficient permissions.”However, when I take the same record that triggered the automation and run a manual test using it, everything works perfectly and the record is created successfully.This is quite confusing—I don’t understand why some records fail while others don’t, and why it works without issues during manual test runs.Could you please help me troubleshoot this?
Is there a way I can share just a single record with an individual, via a customized link? My nonprofit runs a program where people apply and then their application goes through various stages. We have an Airtable form (as the application), which links to a base where each person’s application is displayed as a separate record. We would like a way for people to automatically view the status of their application, so we are trying to see if there is a way to share their own record with them, but only their record-- not anyone else’s records in the base. Obviously, we could copy and paste their record and send it to them, but we often are contacted multiple times by people who are wanting to know about the status of their application as it moves through the phases, so we are curious whether we could create a custom link that we can send to people after they initially submit their application. The idea would be that they can then return to the same link periodically to see updates in t
I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!
I’m trying to display metrics on claims details on a line or bar chart. I would like to be able to insert a “goal” line so we can see easily if we are above or below our goal. Is there a way to do this, or is there anything in the works that could accommodate this request?
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
[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
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?
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.