Other Questions

We do a lot of difficult things for clients - from complex integrations to crazy mapping and data visualizations. But a recent project required field-level encryption in the new Google Tables product as well as Airtable. Encryption Scenario: User fills out a form and reveals confidential information in one or more form fields targeted for encryption. The user also enters a “passkey” - think pin-code like “2998” or a password like “good1ucktryingt0geu$$this”. The form is submitted and an action script immediately transforms the entry in many ways. The target encrypted fields are combined into a collection of strings and encrypted using a 256-bit AES algorithm resulting in a single cypher key. Al

Hello, Airtable community. I have a Google Drive synced Airtable base and all Zoom call recordings are stored there. I need to use an app to show the Zoom recordings by clicking on the drive link. Is that possible anyway? Any app for that? All apps I tried, are looking for the attachment field. Thanks in advance. Dave

I’m curious if anyone else has tried pulling data from Airtable into AutoCAD. I understand that AutoCAD can connect to SQL databases or an ODBC source. That makes me wonder if I could connect to Airtable through the ODBC Data Source Administrator in Windows to then connect to AutoCAD. Thoughts or Ideas?

Hi, I am a new Airtable user and I have a problem with the display of data in Calendar view: the date of today is wrong and tasks are scheduled one day before the defined date (see attachment). If I login on the phone the dates in Calendar view are correct. How can I correct the today date in Airtabel on my PC?

I need to upgrade to Teams, but don't have time right now to  re-train myself and others if necessary.  What are the major differences between the two products?  Will the bases look and act the same in Teams as it did in the free product?

Hello,How can I change who receives the notification when a form is submitted. There are other people designated as owner in our workspace. 

I've been trying to find where the configuration settings are for a table with no luck. I'm sure it's obvious but I'm not seeing it anywhere.I'm currently using the grid view, but can't add another row.

Hello, a very simple question … How can i do an ordinary percent-calculation as follows (column “Percentage”): Region +++ Sales +++ Percentage (favored result) North +++ 40000 +++ 20 % East +++ 70000 +++ 35 % South +++ 30000 +++ 15 % West +++ 60000 ++ + 30 % ++ Sum 200000 ++ Sum 100 % How is the formula for the column “Percentage”? I tried it with “Sales/SUM(Sales)” in different ways, but the result is always 1. Shame on me, but I have no idea anymore. Thanks for advice.

Hi,I have added a number of bases to a screen/page on my Samsung A53. Normally, I would just be able to click the icon and this would bring up the base concerned - but this hasn't worked in the last couple of weeks. Instead, all I get is the list of my Airtable bases after a lengthy wait (not at all unusual).Would anyone be able to offer insight?Thanks  

Hi, How do I get currency (ie. $22.00) to display the cents “.00” when exporting? I have an integromat automation that links Airtable to email and when I use mapping for my dollar amount it only shows the whole number (ie. $22.00 shows 22 – $22.50 shows 22.5). Thanks!

I am planning on doing a clean install, totally reinstalling my MAC when Apple releases the next version of the OS this Sept. In preparation I wanted to create an Air Table with the license keys and more importantly the location to the installation files. I would like to be able to click on the field and then open the location of the install files. Thanks in Advance. Steve

I have a table with many fields but only a few records. Horizontally scrolling to see all the fields when there’s a lot of empty vertical space feels weird. Is there a way to flip the display of rows and columns so the screen space is used more efficiently for these kinds of tables? To be clear - I’m not talking about pivoting the data. I just want to see rows vertically to make best use of the space.

Good afternoon, I am very new to Airtable. You will realize it, if you read my post ! :slightly_smiling_face: I have a table with the dates and times of arrivals and departures of guests at the airport. I want to know the number of days I will have to allocate the cars that will transport them. The cars are rented on a full day basis. I am trying to calculate the number of days for the cars, taking into consideration the dates of arrivals and departures of the guests. I am using the formula DATETIME_DIFF({Date departure},{Date arrival},‘d’)+1 The formula is returning the result taking also into account the time of the day of the arrival and departure, and I really want only the full day. I believe that the solution is very simple, but someone can help. For example, one guest arrives on 26/06 at 11:00am and departs on 02/07 at 09:00am. the result that I’m trying to obtain is 7 days, and not 6 days Many thanks in a

Continuing the discussion from Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B: Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B To me this sounds like a job for a rollup. Not knowing the specifics of your base, I’m going to just take a

All, I’m trying to import a file doc file that exists in an airtable attachment field into Google Drive in integromat. So it actually creates a file, by the name that I have assigned. But when you open it, here’s what it looks like: You’ll notice first that it doesn’t open in editor. And what you are able to make out of the text is the address of the file in airtable (according to airtable). As far as the setup in Integromat, here’s what the settings look like:

Hello, I have a base that is currently public and a view that is also in "community" mode with presumably public settings, but logged-out users cannot access the records that I have linked in the Gallery. How can I fix this? Pictures of configuration attached.

I used the Airtable CRM template to build a CRM for my company.I have a Organization table that collects company data - a Contact table that collects individual's data - and a Events/Activity table that tracks what events/activities contacts have participated in.I currently have all of this data tracked in Google sheet.On my Contact table I have the organization table linked to the Contact table so I don't end up with two tables of data on organization.I can't figure out how to upload my contact data into the Contact table so that it uploads the organization data into the Organization table so it will be linked to my Contact table. 

How do I change the name of a table's "noun"; the noun is listed in a row's context menu: In this case, the noun is "vehicle".

Hi Airtable Community, I'm trying to understand the cost structure for Airtable licenses. Specifically, can a "read-only" user still submit product feedback through an integration? For example, a Customer Experience Agent who has a "read-only" set of permissions still submit product feedback through Zendesk to Airtable without being billed?

Hi everyone, I am wondering if it's possible to create radar charts using Airtable Extensions. I would prefer a way that allows me to create one with minimal code, but I am open to other methods as well.Thanks!

Over the past few weeks we made changes to our data. We have a main reference base where we link a number of tables from and after changing and deleting some information from that base, Airtable has been reallocating records (wrong ones) in every single linked table. Can anyone let me know how to resolve this? We have a table that has a list of organisation names that is synced to various tables. After we cleaned out that list, we realised that where Airtable would usually leave a linked record blank when something was deleted in the main reference list, it is replacing the deleted data with its own data (organisation names on the list 

Hi everyone! Just a simple question (so simple that the bot did not manage to answer to it) from a real dummy. I just use Airtable to store personal data (no shared base, no third apps use): will the API keys deprecating affect the availability of my datas? Will it prevent me from sign in into my bases? Thanks a lot to anyone who will solve my douts. 

When I type in the name of a task ticket in the Primary Field, is there a way to quickly confirm the name, exit the cell and make a new record?At the moment to do the behavior I'm asking about:-I make a new record, with the + or shift enter, enter in my name \ string, hit esc, then shift enter to make the next record.The desired behavior would be a hotkey or shortcut that combines the sequence Esc + Shift Enter.  Shift + Enter after string entry --while data entry in the cell is still active-- would be ideal to work with current new record behavior.

Have a base set up to track orders in progress for a commission artist:table 1: order detailstable 2: tasks related to orderPossible to create an interface that looks like an order summary card that includes:order details in left columnlist of all tasks linked to that order in right columnSo tl;dr -- how can you create a listed of tasks - specifically related to one order - in an interface page?

Hello all!  I'm using airtable for my inventory management system.  I'm using a bar code extension, and it needs a field to generate barcodes from that will be either 12 or 13 digits.  I already have a field that has just started from one and numbered each record / item sequentially.  So I'd like to change it to just add enough leading zeros that it will work with the barcode generator.  I don't even know where to start, and everything I tried to google was way more complex than my current understanding of code / scripting.  Would be easier for me to understand if there were a solution with airtable formulas but whatever works.  Thanks!