Other Questions

Just lost 12,678 records. So, um, how many records can Airtable handle? I thought it was 50,000 for my pro plan. But I had 26,000 going and when I added a sixth field for price, 12,678 disappeared. Using the snapshot took me to someplace where my books are suddenly sorted by publisher when I need them kept in the order they were inputted so I can add the book id numbers my dad assigned to each book in what seems to me a random manner. I think I need to just breathe right now and admit to myself that all the frantic proofreading I did on Airtable for a week (on 8,000+ records) is gone. I’ll have to start again. Maybe I’m venting more than I’m asking a question. Can anyone commiserate?

Hi, folks. We’re about to do a big import, and I was wondering what is the maximum character length of a single line text field. Thanks.

Hey good afternoon, I wanted to create a view that gives me all the records from the Current Month and Current Day in history. So today being October 28, 2020, I want to be able to dynamically pull all the previous years for October 28th. I am sure I could add a month field and a day field and manually change them everyday as a filter in my view but wasn’t sure if there was anyway to dynamically pull the current date to get the historical values for the current date. Thanks in advance for any suggestions.

I would like to have a “Summary Table” of the sum info. That is the totals after grouping. How can this be done easily? Thanks in advance! Mark

Hey! We have created a long list of records and manually edited the order. Now it is only showing from First to Last. How can we go back to view the records by the order we gave them instead of the order of creation? Thank you,

I am able to share my base with other members in Airtable just for viewing the base table. Now I need to share this base with a person in China. Can a person in China access airtable? I think not so the question is how to I share a base ( with attachments) to teh person in china most effectively. I can export to xls but does not capture the attachments, so need to download manually. I will keep trying options, any ideas would be appreciated.

are european based non-profits eligible for discount or covid offer?

Hi, I would like that the customer who fills a form, receive a copy of the filled form. How to do that? thanks jou tarrat

I have three fields in a form. The first two hold a number, the last one I want to appear only if the second number is less than x% of the first number. Is there a way for me to use a formula within the display logic to achieve this?

Hi Everyone My question is can you use Page Designer to design different page layouts for Use within the same base? Eg. I want to issue invoices direct from AirTable. I have sorted that ok and everything is going well so far. Is there a way I can use Page Designer to be able to use the same table as I use for my invoice design to print Say a list of clients overdue invoices or something similar while using the same set of data that my invoices page design is based on?

Hello. I need help. Do you know some way to import to import photos in bulk to a specific field in airtable? Thanks

Hello! Here is the current situation: There is a JotForm used to collect submissions. Each submission will generate a PDF of the submission. My JotForm is also integrated with Airtable. Each submission in JotForm will generate a new record in Airtable. I have an integration with JotForm and Google Drive. Each submission made in JotForm will generate a folder in Google Drive which will contain all attachments as well as the PDF. I would like to have the PDF added to an Attachments column in Airtable. Is something like this possible? Or would I have to manually upload the documents myself for each record?

So I’m running for office. I have my voter database in here. I need to weed out all the voters who have already voted via mail/dropbox. I have the unique voter id number of everyone who has voted and have that as a field in my main spreadsheet. How do I weed those out so that I’m left with just the folks who haven’t voted yet?

Hi there - I am using createRecordAsync and am wanting to know how I can obtain the row ID or other identifying info from the new row that was created without needing to use a time stamp and then text match. Thanks in advance!

Hi there - I have a table where users are taking an attempt or two at a form. I am wanting to first have the script ask for the email to look up which works fine. I am then wanting to have the script choose which ‘attempt’ they would like to do the calculations on. I am having trouble filtering so that I can keep the ID and then push that to another ‘results’ table and still be linked. I can add code but it’s a bit messy and filtering based on text and not maintaining the integrity of the id to relink it. Part 2 Bonus points: I am wanting to create a button text or record so that when prompting, the date and /or session is given. Any suggestions are appreciated.

When I pull data fields from Airtable with Zapier for an eSignature application, the number formatting does not stay consistent. I do not have this issue when pulling data from google sheets with Zapier. For Example: “100%” turns into “1”. “3.0%” turns into “0.03” “$147.64” turns into “147.6444372” I may need future assistance with Airtable development for business application. Thank you in advance. Will be grateful for any assistance.

Hi, is there a way to remove an airtable. It was a file of mine that was reuploaded without my permission and I do not want people to view it. Thanks

I’m using AirTable to track participants in a series of trainings. They will write sample test questions (using a template) as part of this training; sample questions are reviewed and feedback provided, then they revise and resubmit. Previously they’ve done this in Word docs with renaming and uploading to an FTP etc. etc. but I am sure there’s an app that could make integrating this with their records in AirTable automatic. My initial searches have come up empty, however. The system has to be more secure than say Google docs. Thanks in advance for any assistance.

I would like to select a message in Slack and turn it into a new record in a table. (1) If the message has a hashtag like #company: IBM, I would like that to get mapped to the company field in the record. and/or (2) Can I get a little pop up next to the selected message where I can populate the record fields and send it to Airtable? Many thanks!

I was contacted this morning by someone who is presenting as a representative of your HR department. I was told to download a messaging app called Telegram. the person’s name is Henry Richie and he’s been asking me a number of questions regarding my qualifications. He has asked me how I would like to be paid and what banking institution I use. I wanted to make sure that I am communicating with a representative of your company.

I’m attempting to embed an Airtable into my Squarespace website. It works and looks great on desktop! However, it doesn’t convert to cards on mobile as it shows on the embed page on the Airtable site. Do I need to do something special to have an Airtable appear as a grid on desktop and as a card on mobile?

I’ve imported some data to a new table - it’s a subset of the data we have already - but with additional information - an ‘hours rounded’ field… I want to add the ‘hours rounded’ to the main table. I’ve created a linked field to the imported table I’ve created a look up field that is pointing to the ‘hours rounded’ I cannot seem to make the lookup retrieve the time data… what do i need to do?

Hello, my name is Federico. Tengo un problema en el cual quiero poder vincular una base de datos nueva con una vieja para poder reemplazar una tabla prexistente en la base vieja. Vincularía la nueva base por medio del Sync Table entre base de datos. Los registros que quiero cambiar estan vinculado con otrra table dentro de la base vieja, si yo cambio la tabla vieja por una tabla nueva en una nueva base de datos, me arruina la sincronización con la base vieja? Ejemplo: Base de datos: Base de datos operativa Pedidos de Clientes Productos Base de datos nueva: Productos Quiero poder reemplazar la base de datos vieja, lista de Productos, por la base de dato nuevas de productos, se pierden las vinculaciones pre existentes?

I use the below script to get a state depending on the zip code from a cell. How can I format it to work in Airtable? function getState(input) { /* Ensure param is a string to prevent unpredictable parsing results */ if (typeof input !== ‘string’) { console.log(‘Must pass the zipcode as a string.’); return; } /* Ensure we have exactly 5 characters to parse */ if (input.length !== 5) { console.log(‘Must pass a 5-digit zipcode.’); return; } /* Ensure we don’t parse strings starting with 0 as octal values */ const zipcode = parseInt(input, 10); let st; let state; /* Code cases alphabetized by state */ if (zipcode >= 35000 && zipcode <= 36999) { st = ‘AL’; state = ‘Alabama’; } else if (zipcode >= 99500 && zipcode <= 99999) { st = ‘AK’; state = ‘Alaska’; } else if (zipcode >= 85000 && zipcode <= 86999) { st = ‘AZ’; state = ‘Arizona’; } else if (zipcode >= 71600 && zipcode <= 72999) { st = ‘AR’;

I need to upgrade myself and one of my base collaborators. This person is not a workspace collaborator, but just needs access to one of my bases. I do not see an option to do this. Any suggestions?