Other Questions

I have a squarespace website which currently interacts with zapier and airtable to create a new record in my airtable base every time I submit a form on my website. That same form submission also causes an acknowledgement email, containing form data, to be sent to an email address inputted by the website user into the form. In general I am trying to find a database solution which will work with my squarespace website, and airtable is one of the candidates. I need my squarespace website java script code (which I am well versed in) to be able to do the following: 1. Search the airtable base for a record; 2. perform an atomic read/update function on the record so that only one website instance at a time can read/update and no other website instance can access the record in between the read and update. I need to find out if this is possible by integrating squarespace and airtable, and if so I need to be pointed in the right direction concerning implementation. I am not certain, but if ther

I would like to reference up-to-date data from an Airtable base in Google Sheets. For example, I’d like to execute a formula in Google Sheets based on live Airtable data, or populate a Google Sheets dropdown menu (via data validation) based on the data in an Airtable field (i.e. column). I know that it’s possible to export data from Airtable, but those data are static (i.e. they won’t update when the data in Airtable changes). Is there a solution within Airtable’s existing features? There appear to be a few third-party solutions. Are there any users of those third-party solutions who can recommend one over another? Thanks a bunch. G

Is there any formula or function available in AirTable that calculates the mode of the values in a series? I can see on a grouped view that I can choose to summarize each group by summary, average, median, min, max but I don’t see mode as an option and can’t find anything on this in support or here in this (wonderful!) community. “Mode” is a calculation that returns the most frequently occurring value in a series. Specifically, I am trying to highlight records with a value not equal to the mode of a series/group. Thank you!

I’m building a little app for fun that helps guitar players discover YouTube tutorials for learning popular songs. Is it possible to embed a YouTube video in a given card in the shared view? Here is a link to my view: Airtable - Songbook (beta) Thanks!

Saw the URL structure for prefilling a form (airtable[dot]com/1234?prefill_Name=Jane for example), but I’m trying to prefill a form with today’s date in one of the date fields. I tried ?prefill_Date=TODAY() and ?prefill_Date=Now() but appears after some experimentation that URL passes the text straight through rather than using the named formula. Is there any way to get a date field on a form to pre-fill / default to today’s date??

Hello, I have observed some performance decrease for the last 10 days, no matter the size of the database I am working with. The message “Loading this view may be slow due to a large number of records or fields” appears very often (it even appears when I call the airtable “What’s new” menu) Calling linked records is slower than it used to be. I am using Airtable every day to consolidate different data sources and my daily work has increased due to this performance breakdown. Am I the only one to observe a performance breakdown and, if not, is there anything to do? Thank you Pascal

Hi there. I’m trying to build a base that summarizes my company’s social media, email, blog, and event activity and puts it all in a shared calendar. Google calendar on steroids, if you will. I currently have sheets for social, email, blog, and events. Each of them have their own calendar views to organize things by date. What’s the best way to link up all of these calendars so that you can see everything at once? I’d like to get this to the point where users can filter to see any combination of the four categories. I don’t want to put everything in the same sheet, because each category is so complex and has a bunch of workflows within its tab. Any suggestions on how to make a big, aggregate calendar? Thank you!

I’ve been reading over the various info on accounts and memberships, and everything else I can find, but I can’t find anything that really distinguishes a “user” vs. “someone I want to interact with my data”. I’m in a class with 80+ people scattered around the globe (mostly USA) and we need to travel to one or two cities a couple of times. We just got back from one of our weekend classes and someone posted a suggestion that we maintain a list of travel arrangements each of us has made, and what options are available. People want to have some insight into sharing resources, like shuttle/Uber/Lyft to and from the airport, room-sharing, if the hotels are booked up, what the rates are for airfares, rooms, and cars, etc. I’d be the person building and maintaining this database, but I want to have forms that other students can use to enter and edit their arrangements and other info, as well as view what others have entered. They’re just “users” in the common sense of the term, not people who

We have an internal custom (based on the print records app example) for printing a list of all records (project items) that are linked to a record in another table (projects). I’m trying to find a way to open that extension from an interface. In the table I added a button to the projects table that opens the extension with the project selected (through the useRecordActionData hook) but that field is not a button when added to an interface. So, I am wondering whether there are other ways to open an extension with dynamic input: Is there another type of component that can be added to an interface similar to the button fields? Extensions can be linked to in order to open them in fullscreen mode. Can additional query parameters be passed to the extension? (Then I could use an interface button with a dynamic link.)

I’ve done something and it might not have been that smart. I’ve built a webapp using Airtable as the backend. It’s a PHP app, using Angular, and so far it has mostly been working. Nothing super complex, just a customer engagement forum with the usual registration, access management, profile, and then some document management stuff (file / image upload), and a little calendar tool. I have limited coding ability, so have been working with a pretty good development shop in Vietnam, who have hacked the app together using the Airtable API. Everything has been working OK, and using Airtable has certainly supported me as a non-technical user in creating the table structure I want, but I’m starting to see some cracks appear. We hit the 100 record API limit last week, which caused some disruption, and I feel performance could be snappier. Currently we only have a few dozen users on the system, but I hope to scale this to a few hundred over time. My question is, will Airtable be able to scale wi

Hi. I am trying to create long-form articles where I manage the in Airtable. However, the long-text format has limitations and is unsuitable for this purpose. So I try the MarkUp plugin or RichText editor but don´t get it all the way.I aim to manage articles (blog) and digital assets (images, files, prez, hidden links) in Airtable and show them all on a web front such as Softr or similar.I see a base with two tables. Articles and Digital Assets.Do you have any suggestions on how this setup could work?

I'm new to Airtable.I'm thinking of creating a journal in Airtable. I currently use One Note. A nice feature of One Note is the drawing tool. I like to annotate text using it. Is there a way to do this with the rich text field type or another field type in Airtable?Thanks

Hello! I have a button which is posting Airtable data into a Data Pipeline via a script with a fetch request which returns a success or error via status codes on the fetch response. This action only needs to happen once so I’d like a way to disable the button when I receive a successful response but I can’t figure out how to do this. Interestingly I found another topic on here where a button is disabled but I can’t figure out how to replicate this for my use case. Here is tat topic - Button disabled when lookup field has value Does anyone know how I might be able to achieve this? Thanks!

Hi, newbie here ...I am building a table of lawsuits.I have a numerical field of $values, but sometimes this field is not a number, but rather an unknown value and it would be most appropriate to state "varies" for some records.What field attributes/other methods can I use to accomplish this?Thanks in advance

I plan all of my content in Airtable with detailed notes but my creative teams prefer Google Docs. Is there a way to automatically populate a multi slide brief in Google Docs?

Is there support for highlight, indent, and text size for the rich text/long text field? If so, how do I use it?

Hello,Previously in Airtable, it was possible to just drag and drop a serie of images on the + icon of a gallery view and all the records was automatically created with the image and his filename. It was great to create story boards or catalogs with a very fast operation. Now, when I try to do that, the + return "choose an attachement image field". But even if I create this field, my images are refused. I can only drag images in one record, but I can't now create automatically one record for each image.Thank you in advance if you know the solution.

Hi, I' new to Airtable. What I'm trying to do is to create a gantt chart with the start and end dates for the phases in a record to follow up the peoples workload which is different for each phase of a project. In one table I have the phases of a project in one record. I want them in a chart like below. I can create this with an automation via a "planning" table but I can't seem to update this table when a date changes in the original table. The link in the original table to the planning table contains the ID of each created record in the planning table (so 4). Can some one help me ?  An alternative is to delete all data in het planning table on a certain time interval and rebuild the entire table but I cant find the way to delete all the records in a table. thanks,  Koen  

Greetings all I recently signed up to Airtable under the free pro trial. After deciding I wanted to continue with this platform I have opted to pay for the Pro Subscription however due to the trial they won’t charge me until it is over. I don’t have access now to Pro capabilities like uploading my own logo to a form and removing the Airtable branding. I hope to present this in an official capacity to my employer on Monday and not having access to Pro capabilities will hinder this presentation. Does anyone have any advice please? I have emailed customer support however not heard back from them as yet (two days ago) Thank you kindly for your assistance :slightly_smiling_face:

I’ve embedded the Gallery view on to my website, but I know that having all filter options available will be confusing and hard to navigate for my users. How can I specify what filter options I want them to be able to choose from (and ensure the other options are not available) in the shared view.

Hey all!So I am having a small issue with a report system I am trying to create. I have created everything but I am just not able to filter by dates. Let me give you some context below:The report layout looks like this, I am dragging information from 1 master database with about 1.3k rows into a report table I want to do. I made it so in the report table would have 1 row per type of report (1st row = annual report, second = Quarterly, etc). In this image you will see how I linked both tables and dragged the records and all of the other data.The data from the master database to my knowledge is being dragged perfectly, except for the dates.I have spent all day trying to figure out how to filter by "This year" or "This Quarter" with no success because when I try to filter by the look up field (the dates) really nothing happens as you can see here.Any thoughts? Thank you in advance!

I have read many responses that said this is a no-no but no one says exactly why. Yes, I know it is the first field - so what? Yes, I know that it is how other linked records get to it , but that doesn’t mean it needs to be visible in all the grids, forms, etc. Most of my primary fields are composed of bits and pieces of the record and are by themselves ugly and not useful to someone looking at a view. I usually shrink them down to the 50+pixels that I’m allowed to. Just, please, tell me why this is the case. Love most everything else in the heavy use I’ve given it during my trial.

I guess this is a dumb question ...If I design a to do list will my tasks sync between the Android app and my Windows app?

Hello, I'm looking for a way to add multiple linked records.Exemple : in the main table, I have a list of photo studios. For each photo studio, I want to save the number and type of electric power sockets available for each photo studio.In another table, I have all the types of sockets. I want to add as much link between a studio and a type of socket as the number of sockets present.Once I link a studio to a socket, this stocket disappears and I cannot link it "twice" or more depending on the number of sockets.Which solution would you suggest in this kind of situation?Basically, I'm looking for a way to store the information "This studio" owns "This Number" of "This Type of Sockets", and "This Other Number" of "This Other Type of Sockets".

Hello,I'm learning to run scripts and have been able to successfully write a couple of scripts for my work as a coach. I already know how to ask for the number of sessions (eg. ¿how many sessions?: 3) and then automatically create 4 records that are as follows: KickOff, Coaching1, Coaching2 and Coaching3. My difficulty is in how can I automatically create dependencies with linked records to the same table. So for example: Coaching1 has KickOff as predecesor, Coaching2 has Coaching1 as predecesor, Coaching3 has Coaching2 as predecesor.Attached you can see a simplified table... The script I have up to now is://Create Table Variablelet TableCreateDependencies = base.getTable('CreateDependencies')//Ask for Number of Sessionslet NumberOfSessions = await input.textAsync('¿How many sessions for this process?');//Create KickOfflet CreateRegister = await TableCreateDependencies.createRecordsAsync([{fields:{"Activity": "KickOff",}}])//Create Selected Number of Sessionsfor (let step=1;