Other Questions

Hi there! I’d appreciate any ideas about how to handle this data entry need: I have a form (external users) where one of the fields needs to collect assessor’s parcel numbers. Users tend to input this in very inconsistent formats, so I wanted to make this a multi-select or use a linked record from another table to force consistent formatting. However, there are about 29k potential parcel numbers to select from, and Airtable is not handling a CSV upload of these numbers into a new table (it crashes out even though the CSV is <2MB). I’d take all kinds of solutions, including: A way to add 29k options to a multi-select A better way to upload a single-column, 29k row table to use for linked records A way to force a 000-000-000 format for a text entry field (however, I’d need a way to have multiple parcel numbers entered with this format in this field, as each record could have multiple parcels listed) Or any other clever ideas about how to handle this to cut down on post-entry data cl

I need to build an event registration system. Only I and a colleague will be able to get into the base and view all the data. But we need to put a form online that people who want to register can go to and complete. I’ve tested this already and it works great — with one problem. Our forms may become long enough that they can’t always be completed in a single session. We’ve done this in the past with the PHP powered site that we’re trying to replace. When users first come to the site, they get a token that allows them to come back later, find the record that they started, and complete the form. Is something like this possible in Airtable? This seems to be the only thing that might keep us from doing this project in Airtable very successfully… Will

I am uploading my images to AWS S3 for the product images. Products will have multiple images so how can I get multiple URLs in the same field?

Afternoon,I am trying to find a way to create a series of symbols (see attached) that I can use in my base. Unfortunately, these are not standard symbols that one could get as an emoji for example. These are all cricket scoring symbols that I am trying to use in the cricket scoring base that I am creating. Any help would be welcome.Thanks in advance 

I decided at one point to create an extra table to keep some additional records related to another table. What I did is to create a new table and add a column linking to the original table. So there is supposed to be a 1-1 relationship between the rows. Unfortunately, this has not worked out because when I update the main table, the linked table does not get updated. So I want to merge the data from the extra table back into the main table. That is easy to do outside of airtable because it is a simple table join. I did it in R in a few minutes. However, I am not sure about loading the merged table back into airtable as I think it will lose all the links to other table I setup.The main table looks like:ID (a formula), Year, Semester, Course, ...The extra table looks the same but beyond the first few columns (which together uniquely determine the row), it contains different data, e.g., enrollments, etc.Is there a way inside of airtable to merge the columns from the second table into the

Hello everyone,I’m here to ask you about a specific use case for which my searches didn’t get me any good results.I have a table of video documents where there is a duration field, with length written in the format hh:mm:ss.I have a second field called duration format, in which I wish for 3 options to be available: under 30 min, between 30 min and 1h, over 1h.Is there a way to fill this second field (duration format) automatically based on the value of the first field (duration)?Thank you in advance for your help and answers!Best regards to everyone!Charlie

Hello community,I'd like to track extension errors in Sentry. The default setup (below) that works for a sample react project doesn't work in an Airtable extension -- the events don't get captured in Sentry.import * as Sentry from '@sentry/react'; Sentry.init({ dsn: DSN_STRING, environment: process.env.NODE_ENV, tracesSampleRate: 1.0, });Is there something else to be configured for the extension since the code is remotely deployed in Airtable server?

Hi everybody I have tried the iCal connector to Google Calendar. It is a very useful feature and I was very happy when I saw it but, unfortunately, it looks like Google is not properly updating the information. The first time you make the connection it works fine but afterwards, if you make changes in the database, these changes are not reflected in Google Calendar. If you try to connect it again you must introduce something new in the URL provided by Airtable so that Google Calendar understand it is a new Calendar and does not use the cache. So, the calendar is out of sync as soon as you change any information in the database. Althouhg I think this is a Google problem (there are some forum about it https://productforums.google.com/forum/#!topic/calendar/ixQnzHmWDSk), it would be fantastic if you could do something about it because this feature is something we have been looking for. Thank you!

 Hi! Is it possible to list values in a numerical order from a Rollup field? We want to view this field attached in numerical order. Any solutions to this? Thank you! 

Hi,I have been waiting for 3 days for an explanation why I still work in the Free plan although I have made a payment for Plus plan.I had a Workspace Michel which I deleted because I thought that was the problem.Maybe it's just me but I'd like someone to look into this.Please answer.RegardsMichel

I need to change the text of the "Submit another response" button of the form.I also need to remove the text "Report malicious form".Please help.

Hi, I am trying to upgrade to the plus plan. But everytime I try to pay I keep getting a error that we are unable to upgrade you at this time. Pls help me solve this  

When two-way sync was originally announced, the message was that it was being beta tested with Enterprise accounts but that it would eventually launch for Pro accounts as well. With the release today and a quick look at the pricing page and help articles, it seems like this was walked back and two-way sync is no longer coming to Pro accounts. Is this true?Even the marketing copy from the email says that this will help teams of all sizes:It's highly unlikely that independently funded / small orgs can afford the price of an enterprise account. Will we get two-way sync for Pro accounts? Would love some clarification on this. Thank you!

Is there a way to have a default field that notes the date/time when someone submits a form, without adding it as a field that a person manually fills out?

HiI am scheduling a festvial, and I need to create a way to "unshare" past events, so the beginning of the week doesn’t pop up on the last day.Is this possible?All the best, Uffe from KlaDa

Hi, any idea why this issue is happening?If this helps anyone: I encountered a similar problem in the past while running "add Image from Google Maps" extension. The Airtable team initially suggested that one possible reason for this error is when a table already has 500 fields and you attempt to add another field to it. However, in my case, I only have around 10 fields. Eventually, they discovered that the error occurred because the extension was using the Google Maps URL as a filename, which sometimes exceeded the 255 character limit. They recommended editing line 116 in the script as follows: urls.push({ url: staticmapUrl});

This is probably pretty simple for someone out there. I’m not really a database guy, just hacking my way through creating a product information system for thousands of styles to make catalog production easier. I need to do a find and replace using the Substitute formula string but can’t get it working. In one field I have a bunch of product names. An example would be something like “LS Shirt” but I need to change it to “Long Sleeve Shirt”. How do I go about it? The tips don’t go into much detail about how to identify how to reference a specific column/table and then have it changed. Open to any help or tips… Thanks, Matt

Hello! I just joined my company and I am entirely new to Airtable. I’m a project manager and I’m looking to use dependencies in my grid to automatically update my project schedule that I’ve created. For example, I’d like to make task B dependent on the conclusion of task A (finish-to-start relationship) AND, if I update the end date of Task A, the start date of task B should update based on the new end date of task A, as well as any other tasks on my schedule that are dependent on B and so on. I’ve figured out how to create dependencies but it doesn’t auto-update any of my dependent tasks when I update dates which is VERY manual and time consuming as a project manager. I’ve also noticed that Airtable only accommodates finish-to-start relationships and I often time need start-to-start relationships. Does anyone know if this functionality exists or if there are work-arounds? I’m coming from a company that used Smartsheet for project management and I’m really struggling to equate the func

Hey everyone,I have a temporary accommodation that people apply to.All of my applicants are stored on my Airtable in tab #1 (Applications) once they apply with form #1, which I use as my CRM.Once an applicant is accepted, I send this person form #2 asking for the exact move in/out dates and other valuable information using another form.Currently, I'm using tab #2 (Residents) within the same base to store that info and I'm wondering whether:there's a way to put all of the info from form #2 into the existing row that was created with row #1 orI should use another alternative, such as using a List view to combine both of these areasThank you very much for your help!Cheers,Marc from Barcelona

Is there any way to create Airtable sharing groups based on records in an Airtable base?Context: We have around 70 employees belonging to different teams. Team members in each team keep on either changing the team or new members are added to the teams. I regularly update the details relate change of team or new member addition regularly in the master base containing all employee details. Ask: I want the sharing groups to be automatically updated when a particular persons team name has been updated. Is there any way to achieve this? 

Does anyone know how to fix images being cutoff in gallery view? I'd like to do this without selecting "crop" because this makes the image very small - Is there a certain size or?  Attached are two images - one line of images in gallery view where images are cutoff ➕ then how image should appear.

 Hello,I'm trying to connect Airtable to make.com and gets records to fill document with Microsoft Word Templates.The problem is returned data by Make.com. I'm getting something like this "recn3V..." instead of value from Airtable that should be a name of company. Thanks in advance 🙂

I have a whole base set up for our youth wrestling program, and the only thing I cannot figure out is how to set up repeating practices. For example - one group practices Tues, Wed and Thurs every week - so I really need 36+ columns for that group to put one date in each for 3 months? There has to be an easier way to set up events that repeat on a regular basis, right? I have searched the Community and found some references in the past to this issue, but nothig that shows that it has been answered.

Hi there I would like to be able to know how many hours a tasks takes a member on my team so I can be alerted if over 4 hours. The catch is that I want to calculate only business day hours not just straight hours. Example would be if the tasks is started at 4 pm, and the WorkDay ends at 5, then only one hour. Then the clock would start again at 8 AM. until the 4 hours accumulated. I’m thinking it’s not possible but wanted to see if anyone in the community had any ideas. Thanks!

Was just wondering if there was a way to see how many records each base is using? For example to check if you are near your limit of 1,200 / 5,000 / 50,000 records? Thanks.