Other Questions

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’; state = ‘Arkansas’; } else if (zipc

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?

Hi I am trying to iterate between pages of results from Airtable in Integromat. I tried to do this with Search Records but couldn’t work out a way to back and iterate through any bundles above 100 (it was reporting the first 100 bundles, being the default page size in Airtable). So I’m using a custom API call and can pull the first 100 records, with an offset. I can then pass the offset in a second query and get more records. However, I can’t work out a way to repeat the process programatically based on the total number of bundles - I don’t want to include an arbitrary number of calls as that isn’t flexible if the records exceed the number of calls, and in any case using multiple calls (rather than say one call with a repeater) seems tricky. Any input very gratefully received! Thanks Aaron

Hey guys, I saw a few closed posts about this but when I share a grid view as a url (or even an embed) when they filter that view, then attempt to print it, it ignores the filters! IS there maybe any work around for this??

Is there a way to craft a table/view and a Zap to always pull the first row from that view, when there is no known search key for that view? Alternatively, I’d settle for being able to pull any random row from that view. It does not appear that Zapier’s Find Record has the ability, since I won’t know the key in advance (these are rows that need to be pulled into a Zap, worked on, then updated so they disappear from the original view, which means the first row will then become something else). And other recommendations on random finds seem to revolve around knowing autonumber ranges etc, which again, I won’t know, since these numbers will change as records disappear from the view. Anything else anyone can recommend?

Hello, Can anyone give me a solution for transferring my personal credits to my workspace in Airtable? I am the owner, and I have tried to follow the instructions for doing this with no success. Is there only a certain time that this may be done - such as during the billing year? I can’t figure out why I’m not able to do this. Any help you can provide will be greatly appreciated. Thanks! Michael

Hi guys, I have a table with only 2 views. One is “Master” and is a personal view, and the other one is just a duplicate of “Master”, but with hidden columns, and it’s a locked view. The idea was: Managers use the “Master” personal view, with all the information exposed, and our contractors use the duplicated locked view, with hidden columns (naturally they have a different login). Since they can’t unhide the columns, we thought this would prevent them from seeing sensible information. However, when contractors duplicate the “Duplicate” view (as a personal view, or collaborative view), they are able to unhide the columns and see the sensible information. Is this the expected behaviour? If so, what’s the best way to prevent contractors from accessing sensible information? Thanks!

Hi, I am just about to dive into the JIRA app in Airtable and was wondering if it was unidrectional only from JIRA to Airtable. Basically I’m wondering if it’s possible to create JIRA issues from Airtable (without having to go through Zaiper or other automation apps) Thanks!

I would like to copy an existing base designed for a 2020 project to use for 2021 but I do not want all of the data, only the formatting. How do I that? Thank you.

Hi all, I have email automation that I want to use that sends confirmation emails to clients. I already set up a paid pro plan, but I am still within the trial period. Now when I test the automation it says that my plan does not support this. Does this only work on the enterprise plan? Thank you!

Hi! I am using AirTable for creating a case study database, where I’m organising all cases and their information in the Grid view. I will then be using the Gallery view to create an online case database that external viewers can use to browse. Some of my cases have more information than others - meaning that there are empty entries in some areas in my Grid database. These however still show up on the cards when opening a case in the gallery view. Does anyone know if it’s possible to simply not have empty entries show up on the cards? Thanks!!

I have a lot of PDF file attachments in my records, and I would like to directly access and use the thumbnail images that Airtable generates for each PDF. I can manually extract the thumbnail URL by right-click on an image preview image in my attachment field. Is there an Airatble formula function that can expose these URLs so they can then be accessed by Zapier/Integromat or similar tools? - eg something analogous to what RECORD_ID() does to expose the record ID?

Hi, just wondering if we can create custom html base from airtable. I know airtable provided it but i just need simple html so i can place it at my project. sample html : https://www.w3schools.com/howto/tryit.asp?filename=tryhow_js_filter_table Requirement select a few column to html page able to search from one of column and will populate info from relevant row/cell.

Hello, I have a situation where users use a for to create data, then at a later date I want that data presented back to them (in Slack) I have a image / file column in Airtable and I cannot get that to populate in a bot slack message. What would be fantastic is if I could get a pdf of the form of the 1 record and then resend in slack. I can already bring up some of the text strings and send via slack, but cannot find out how to attach images.

So, I have a base I created that I have shared with others to use without my records. Essentially, they are using the formatting I created. I have made some updates to that formatting, and want to share the updated base. Is there a way they could update the formatting of their base with my changes, while keeping any records they have entered since the last share? There are many tables, and automations tied to each table, so as far as I can tell, syncing is not the answer

Page Designer truncates records that are too long to fit in the visible space of a text field, which causes difficulty when records are long or vary in length. Reducing the text size or widening the text field increases line length, making the content difficult to read. Having the ability to display the text in columns or overflow from one text field to another would really help. Is there an existing solution for this?

Hi there I currently use airtable as my delivery fulfillment hub for virtual video game items where i have multiple staff take and fulfill orders via Kaban View. The process is the record comes into a view and the first person who changes that operator name to theirs gets to take that order. The problem comes where there is latency and multiple people click and take that order within the same second, it will override the true initial person to change the field, also its possible for them to change it after the fact (the airtable history does not work well if it all happens within the same second or one staff has higher latency then the other i think) I want to know if this is possible to build then I will look for an app developer to help. The problem comes with latency, the app would need to have some parameters built into it where it will know what the field was changed to FIRST then override and prevent it from being changed again within the next few seconds Would love to hear your