Other Questions

Hello all, I am trying to put together a customer base that pulls in information from multiple bases. I have several archived sales data bases, so a base for 2020 sales data, 2021 sales data, etc. Let’s say I have a customer “John Doe” that has multiple orders in each base. I’ve got a CUSTOMERS table in each base that summarizes number of orders, total revenue, etc. Can I create a “Master” customer base so that when I sync from multiple sources it tries to find an existing record with that primary key before creating a new record? When I try it is creating a new record for “John Doe” for each source instead of placing each sources information into the existing record. So if I’m sycing three years of customer information, I have three John Doe records instead of all of that info in one record.

Hi everyone! We’re excited to announce a new beta feature that allows you to specify a display time zone of your choice on date fields that include time and formula fields that output a datetime value. Once you specify a time zone for a field, this time zone will be visible and used for all collaborators. We’ve heard your feedback that time and time zones can be tricky to manage, and we hope that being able to choose from a broader list of global time zones can make collaborating across time zones much easier and clearer for you and your teams. You’ll only be able to use these field-level time zone settings in your base if you’ve signed up for the beta and you can sign up for the beta via this form. As you’re trying out the feature, please submit any feedback/issues here. Read on for more information! For datetime fields, you can access this feature by going to the field configuration menu and toggling on both “Include time” and “Use the same time zone for all collaborators”. Setting

We have an Enterprise level account and are trying to implement a date field which will track the date that a status is changed in another field. This is all good on a move-forward basis, but we would also like to update it historically, which is proving to be trickier. With our enterprise account, we have 3 years of revision history, but it seems like the only way to access what we need is to open up every single record, scroll through until we find the action we’re wanting to track, and then approximate based off of Airtable’s generic date timeframes when that action was performed. Once we’re out of the 1 month timeframe, this goes to month by month and then year by year approximations, when what we’re really looking for is exact dates. Is there a better way to do this? I don’t see an access point in the scripting API to see record history. Our Enterprise audit logs only go back 6 months, and don’t offer this level of granularity. We know the data is there but are at a loss as to how

Right now I have some interfaces on a base. 1st on is a form that will only be available to certain users (senders). Depending of 1 of the decisions that this sender made, the answers of this form should be only available to a specific user (accepters) to deny or approve it. 2nd one is a interface that will only be available to a certain accepter depending on a dropdown answer that the sender filled. My question is if there is a way to give permission to certain airtable users to use an interface. I’ve been trying to find a way of doing this but can’t find any way. Another solution I explored is to create different bases and give the correct collaborator permission to the people whose work correspond to the one assigned to the base. But I would need to send data from a base to another. I don’t know if this is possible but I can’t find any solution to this either.

I was tring to modify a formula DATEADD({Start Date},13,‘days’) to find the end of the month but since months have differing amounts of days I wasn’t sure how I could do that. Bascially, I want the formula look at the start date and then output the last date in that month. So a start of 9/1/22 would equal 9/31/22, etc. Thanks in advance!

I have two different tables with information that needs to be synced to an existing Google Docs file. Anyone knows how to make it? Thanks in advance!

Hello! Recently one of our bases started sending out emails to everyone when I change something (add a new view, change a automation etc). I would like to stop this because most of the people inside of the base don’t understand most of airtables more “advanced” systems, which causes them to get confused about it. How might I disable this?

Hi all, I have inventory for our plant shop already in Airtable. From a Gallery view of this inventory, I would like to use the url of each individual card to generate a QR code for our pricing labels that customers can scan and get just that specific card view without having to sign up or log into Airtable. I don’t want them to be able to edit anything, just view the specific card. (These cards have plant care instructions for each plant.) Is this possible?

Hey All, I’m curious how often Airtable actually rolls out updates? I know it’s a smaller company, but it seems like several of the “product requests” that have been posted many times, are now several years stale. Anyone have any insight if we’re likely to see these features added? How often are they adding features & rolling out updates? The specific features that are bugging me today are: Multi-page Page Designer Customization of forms (section headers, better layout options, etc) Obviously everyone has different needs, and I’m sure the AT team is doing what they can. I’m just curious about their process. I ask for two reasons: I really like the basic product here, but if it doesn’t continue to grow, I can do all of these things in other, cheaper products. I see a lot of pushing towards outside developers to use the API to build additional features. That’s cool and all, but I’d like to think that Airtable would be incorporating the best features into its core services, rather

Hi! Please I need help understanding how to filter linked records when populating a record in a table. I have a table with some groups of professionals, like Group 1, Group 2 and so on. In another table, I have some themes, which will be the subject of some classes. In the class table, I would like to allocate at a specific date and time, a group and specify the topic that will be presented to them. I would like to present as options only the groups that have not yet had all the themes. And, after choosing the group, present only the themes that the chosen group has not yet had. How can I provide this kind of filter using linked records? Thank you very much in advance.

Hey I’m coming from spreadsheets and wanted to start using Airtable, but the first thing I noticed was that I couldn’t use shift+scroll to navigate horizontally. My friend doesn’t have this issue on his Mac, but I’ve found dozens of other people with the same issue as far back as 2017 but no one has shared a solution. Any insight on the cause of this bug/how to fix it? I can’t use this if basic navigation is broken. (Using Chrome on Windows 10)

Hi, I use a script to update a field {TypeForm} by concatenating 4 fields {Rang},{TypeQuestion},{Question},{Option}. {Rang} is Single line text / {TypeQuestion} is Single select / {Question},{Option} are Rich text When i execute the following script: with these data: I get the following result: Why first column values {Rang} like 1., 2., 3. etc.are not properly transferred in {TypeForm} as we see 1. , 1., 1, Thanks a lot for your help. F.

Hi everyone, I am using the Web Clipper to get some information about restaurants in my area. I managed to automatically get the name, website, ratings, etc. The only element I do not manage to get is the phone number. From what I found on Google, it seems possible (some tools offer that), but hard to do (people mention they needed to a xpath). Has anyone managed to get the phone number on Google Maps? If yes, can I know what CSS selector you selected? Thanks in advance!

Hey there ! I would like to bulk delete records that match a certain criteria in the app Front. I will link Front and Airtable via webhook but I wonder how to write a script to delete only the right records. Thank you !

Hi! I run a recruitment business and I currently have a table for ‘Jobseeker sign ups’ and ‘Open Projects’. When I get a new ‘Open Project’, I send an HTML email to notify jobseekers about the project. Apart from referencing the jobseeker’s Name and Surname in the HTML code, the rest of the information about the ‘Open Project’ is hard coded. I wanted to know whether there is a way to include data about the ‘Open Project’ in the email HTML even though the Sendgrid block is set to send emails to a view in the ‘Jobseeker sign ups’ table. Ideally when I get an open project, I would like to generate an email template containing the information from the fields that exist in the Open Project table, so I can notify the jobseekers about the details of this Open Project. Any assistance is greatly appreciated. Thank you!

Hi there, I want to keep different people and their statements/quotes on different topics. My idea was to create a table with all the people and their general data and then for each topic open a separate table with all the people and their quotes and statements. I was looking for a way to synchronize the first column of one table with the first column of another table, but I only found ways to link other columns. I also want that if I have 100 people in my first table and I open a table for a new topic, that I have the possibility to automatically add all 100 records with all people (just their names). I hope you understand what I mean. Feel free to ask me if you have a question. I am grateful for any answer. Have a good day. Janek

Hi guys, I created a list of ‘user IDs’ on airtable. Using Telegram bot I would like that when a person types /takeID the bot searches through Search Record in my list and issues a negative or positive response. Can you tell me where I have gone wrong? I seem to have put in the right filters, perhaps I am missing the formula…

Question if anyone received the following error with a form submission. This error has not occurred with this form for a few weeks until the last few days. The data is still processed though into AirTable however, because of this error the end user doesn’t know if it is processing correctly or not. Only changes that were made since in the last week was AirTable API connection through FiveTran to BigQuery.

I’m facing this issue all the time. In browser console, I can see this error: POST https://airtable.com/v0.3/notifications/fetchRecentThenMarkAllAsSeen 500 (Internal Server Error) Any advice?

Hi - I recently noticed that the URLs for attachments in my base are ‘sometimes’ exported with additional parameters that looks something like this: &userId=usrRGFsp5k3BVKxoz&cs=5df56hubdtrt3673b79d I’d prefer just the basic URL, and am also concerned that exposing the UserID is a security flaw - since I’ve shared these asset links, usually images, on a public platform without inspecting the URL closely. I am using the API (via pyairtable) to get these URLs. Sometimes the extra parameters are included, and sometimes they’re not. I haven’t been able to ascertain what is causing the different outcomes. Has anyone experienced this, or had similar issues? Thanks!

Hi team, Here’s the context 2 fields: Scheduled date: A Date field with ISO format, 24h format, it includes Time and uses GMT for all collaborators Date validation: A formula field that runs the following code: IF( AND( {Scheduled date}, NOW() >= {Scheduled date} ), "Ready", "In Review" ) Problem: When Scheduled date = Today, the formula returns Ready, ignoring the time. For instance: Case A Scheduled date = 2022-08-23 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns Ready :x: Case B Scheduled date = 2022-08-24 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns In Review :white_check_mark: Could it be that NOW() doesn’t care about time? or is it using a different Time Zone?

Unfortunately input.textAsync does not allow a default value. Anyone have a workaround for this? E.g., You can code a default value if user enters nothing, BUT…there’s no way to enter nothing (i.e., requires user to enter a value before proceeding).

I would like to ask the community about advanced linked records & extracting information for each specific record. Data Overview Table 1 ↓ I have a Zapier set up that creates a record each day into a table using a European date field type. Then I have created a linked field to Table 2 & 3. i.e. 16/8/2022 17/8/2022 18/8/2022 Table 2 This is a shared table synced to another base. This table includes projects, staff members & invoice amount. It’s based on the same European date field. This table has a linked field with Table 1. Table 3 This is a shared table synced to another base separate from Table 1 or 2. This table includes projects, raw materials & quantity used. It’s based on the same European date field. This table has a linked field with Table 1. I have set up an automation in Table 2 & 3 that when a record enters a view, it automatically adds the date to the linked field (Table 1). Issue As Table 1 is the main source of information, I want to be able to access

Hi people. Please is there any other way to make payment for plan upgrade(maybe bank transfer)? Our card limit doesn’t allow us to make such payment at once for the cost of the upgrade to the plus plan. Thanks

I would like to share multiple filtered views of a table on different pages. Would it be possible to create multiple shared views with each of them fixed on its specific filter? Thanks in advance.