Other Questions

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

When I send the record to my colleague’s email, emails with different subjects are merged into one of the recipient’s inbox. How would I resolve this?

How can I export a view in a tab-delimited format? CSV messes with columns that have commas within them, like product titles and product descriptions. I tried searching the forums here and asking about how to make CSV work, but then it occurred to me that a tab-delimited format might be the solution. The online marketplace I work with does accept those. Copy/pasting won’t work because (a) we have to update everyday and (b) some marketplaces [like Amazon] have over 150 fields to fill [setting up formulas to fill many of them].

I have set up a simple applicant tracker template with a form. The form is working, but I cannot find how to view or edit the form. I made a short 2 part video overview. Question Part I: Question Part II:

There is any way to use other languages? I’m trying write in Bengali language but cant. Please help me. Thank you.

Is it possible to make a base in an Enterprise workspace private? I want to create bases that shouldn’t be shared with everyone in the workspace but I want to use the features not available in my free workspaces.

We have a survey done for our subscribers and I just want to tally answers per question. For example, one question has 3 options and I would like to summarize how many answered option 1, option 2 and option 3. Is it possible?

Hi, Is it possible to generate a link to the gantt app? I need to share this view embedded in a channel in MS Teams.