Other Questions

Hello Is there a way to replace all spaces with “-” in a cell? I synced a cell with my website and what ever I put in to the cell in airtable becomes the webpage slug. So I can’t put a space in a slug. Any solutions for this?

Hello! I am wondering if anybody can help me troubleshoot why a script stops working when there are records in my base? The script in question is the “Creating Projects/Tasks From Templates” script (which I found here). I am also including share links to 2 test bases for reference on my problem (those are located here and here). The Sandbox for Question (1) table is copied from my company’s Workspace, and includes confidential information that I’ve renamed to “Redact” - very sorry if this makes addressing this issue more complicated or confusing! I use this script to batch create tasks (in the Tasks table) from a template (defined in the Asset Templates table and Task Templates table) that are parented to a specific asset. I recently started to encounter this error when trying to run the script: > TypeError: Cannot read properties of null (reading '0') at main on line 87 For context, this is line 87 in the script: let p_id = r.getCellValue(project_template_link_field_name)[0].id

I am trying to figure out how to get my script to run under the 30 second limit. The Find Records automation doesn’t handle a list and I am trying to loop through a short list of Google Event attendees to see if they exist in a Contacts table. If they exist, I want to add the Contact name to an array. If they don’t, I want to create a new record and then add them to the array by Name. Then I want to create a Meeting record that adds the Attendees by name to the Meeting record. let attendees = input.config(); let customers = new Array(); let contacts = base.getTable("Contacts"); let contactRecords = await contacts.selectRecordsAsync({fields: ['Email']}); for (let i = 0; i < attendees.attendees.length; i++){ var attendee = attendees.attendees[i] if (attendee.includes("@tray.io") === false){ for (let record of contactRecords.records){ if (attendee === record.getCellValue("Email")){ customers.push(record) }

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).