Other Questions

Hi, all. I'm transitioning from Google Sheets and I understand things are different here, so please have patience with me :-). I am basically trying to implement a VLOOKUP functionality.I have the following use case: I have two tables, customers and orders. Their only commonality is the User ID.I am now trying to look up a field in the customer table (name) and display it in the orders table by using Lookup. Each customer has a large number of orders.When linking the two records and creating a lookup field, I can get the name to display on the orders table. But only for that one particular order and only by manually linking a record. My expectation was that Airtable recognizes that each "name" field in the orders table should now be filled the relevant value from the customers table. Like I would do with an arrayformular in Google Sheets. But that's not happening. What am I doing wrong?

I'm trying to share a restricted (not all fields and filtered) area of a base via a shared link. I'd love to give the external users permission to copy content from this base. But as soon as I enable that option, the generated link gives them the option of using the data in a new or existing base, and thus unlocks my whole workspace... a bug ? Or is it behaving like this only because I'm now testing this by sending the link to myself as owner of the base ? 

I currently have made a pretty simple set up with two tables. 1 table has bunch of projects listed and the other one is my clock in and clock out. I’ve then made a form so staff can clock in and clock out via their phone. The form has 2 date fields a ‘clock in’ and ‘clock out’ and a link to the first table. Currently it works by employees clock-in and clock-out all in one go, so each record is one log and can tell me amount of time worked in one log. However I’m wondering if there is a way to have a ‘clock in’ which can be used once a task is started and another clock out which can be used once a task is finished, but still tell me how long each specific logs are?

Hi! Is there any way to remove the airtable add on the page that comes after submitting an airtable form? I've managed to personalize the message that appears (or part of it), but not removing what comes next. Any tips on this would be highly appreciated!Thanks! 

Hi,I'm using attachments in a table and uploading them through the API, running on Glide.My understanding from the small amount of research I've done is that there is no way of scanning attachments for content. We're uploading PDFs into airtable, and would like to scan them for viruses. I'm pretty sure this is not possible right now in Airtable. Can anyone confirm this?Thank you in advance,Evan

I've started considering Interfaces for my team of 5, but I have a question specific to "Assignee".Scenario: We run events. Each event (1 event is 1 airtable record) is led by one of our team members. Ideally, they use an interface to show them which upcoming events have specific action needed. (we currently do this, but via views, and the volume of views has gotten out of control). We didn't previously use the "Assignee" function. Instead, we had a column that we called "owner", which was their first name, so you can filter on what events were yours, and what upcoming actions were needed. The adaption of Assignee seems to work for upcoming events, but I'm more curious about past events. In some instances, the "Owner" of an event no longer works here. So I can't transition all "Owner" to "Assignee", because it's my understanding that assignee c

Hello! When I got to my account page (https://airtable.com/account) I get a blank white page on the overview page. How can I fix this? And why is it doing this? The other links Referrals and credits, Recent activity work fine. Thank you in advance for the help!

Hey Everyone,Happy New Year! I have a Make scenario that is extracting attachments from emails  and saving them to OneDrive. I'm then creating a record in Airtable and trying to add the attachment. It all seems to work OK but the attachments always open with blank pages in Airtable like it doesn't recognize them. If I download then I get the same issue. If I add the link to the file in Airtable it works OK and opens from the link in the record. Any ideas ?     

Hello,Just until yesterday I was able to read calendar months, and days of the week in my local language (Spanish) on the airtable interface for calendar:Green arrows in the attached image show 'Diciembre' and 'Vie' (Viernes) which now shows as December and friday.How can I make airtable to show this info in Spanish language again?

I would like to have visitors to my website signup for mailing list , and submit email address direct to my Airtable from HTML web form. I can successfully do all that now, BUT the same API token can be used to READ the entire table… How can my API token be used to submit data from web, but not allowed to read whole table?

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 t

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 ter

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

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?