Other Questions

As some of you may know, I’ve spent the past year, at least, battling a debilitating physical condition. For the last few months, this expressed itself as near-disabling reflected pain in my arms and shoulders that made working at a keyboard – or focusing on any task more complicated than rereading genre fiction – virtually impossible. Although the condition was finally diagnosed mid-November, complications (a two-month pause to reschedule surgery with an in-network physician amenable to my insurance provider; the scorched-earth arrival of Covid-19) pushed my surgery back to April 10. (Fortunately [?], the delay meant my situation had deteriorated to the point the procedure was no longer considered elective; otherwise, you’d be reading this in October.) Today, a week out of the hospital and with another month of recovery ahead of me, I already feel better than I have in a couple of years. A whole raft of symptoms my doctors said might be alleviated by the surgery have completely disapp

Is it possible to hide or display certain fields in a table based on the value of another field? Basically, conditionally. For example, let’s say a table has the following: Field A Field B Field C And I want the following display options Field A: Always visible Field B: Visible only when field A is marked “Present” Field C: Visible when field C is marked “Absent” How would one do this?

In airtable, I've programmed a calendar with dates and times for specific events. The formula is as follows: IF({Override horaire cour 1}=0,IF(Ordre="1", DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h1}), DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h2})),DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Override horaire cour 1}))When I install the calendar in my application, all the appointments are 1 hour later. How can I fix this?

Hi, guys!I would like to find out if Airtable is by default downsizing attachments when it comes to images / video / PDF files. Thank you in advance!Razz

Hi everyone,My team and I are trying to create URL previews for AirTable share links. The URL preview extension works for other URL types, such as Google Sheets, but we are seeing "No preview" when we select a cell with AirTable share link. It's the same issue whether the share link is for a base or for a table view.While looking through online documentation, I saw that the format of the link that's generated for us is different from the format I see in the documentation. Ours is in the format "https://airtable.com/app[random-string]/shr[random-string]/tbl[random-string]" or "https://airtable.com/app[random-string]/shr[random-string]",  while the online documentation shows the format "https://airtable.com/shr[random-string]".I'm not sure if that is the cause of the URL preview failing, but was wondering if anyone else encountered a similar issue.Online documentation I was referring to:Screenshot 1Screenshot 2Screenshot 3 

Anyone else having issues logging into Airtable with two-factor authentication? The code that is supposed to be sent via text message to my phone is not going through, so I am unable to login ☹

Hi all, any help appreciated.I'm creating a Matrix and trying to use the bulletpoint "Unordered List" and check box style "Task List" options when creating the content. I am copy/pasting the syntax directly from the Markdown cheat sheet and it is working for *most* cases, but randomly not for others and I have no idea why. I've tried deleting and re-entering, typing out rather than pasting, deleting the record and starting over... There seems to be no reasoning - that I can see - for the random times it goes wonky. I've attached some screenshots of the wonky incidents.Thanks in advance!

I'm not sure if this is possible, but I'm going to try my luck. I have a table with a lot of columns, and lots of records.  Sometimes, I need to find a particular set of records.  Considering I have say 100 columns,  I then need to locate the column. I use the "Find" feature to search for the column name, which locates it.  However, if I then have to move around the dataset to locate certain rows, I might need to move horizontally within the view, to locate certain information. This makes me end up losing the horizontal position of where that column is. Considering that there is no concept of a column index, I cannot say "Column Name" is Column Index 50 in this view, and then I can easily scroll to it.  I need to remember the scrollbar position, which is very vague.I'd appreciate if you have any advice on this matter. I've recorded this video to explain better the issue I face: https://drive.google.com/file/d/18OXTCcNaJG9AnsGCWlEB9-PAeLn2mrH7/view  &n

When I check off some of the tasks in my task list I get "An error has occurred" and I get logged out. This is happening for other users too. I did a hard refresh, cleared cache, tried from an incognito window.... Nothing. It happens in the interface and in the data view too. I think maybe ones linked to automations, altho the automations seem okay. I also tried cloning the base in case it was just corrupted. Same thing.

Is there a way to convert an existing Project to a Task? We are cleaning up/re-organizing our system. There are 4-5 existing active Projects (with notes, dates, details) all for the same client... these should really be Tasks under a single Project. I just can't recreate these as Tasks under a new Project - too many notes and details. Is there a way to move those 4-5 Projects under a new Project, making them tasks? keeping all the existing information?Example: Cat Photos, Cat Bio, Cat News Release, Cat Petting Event have all been entered into our system as Projects. I would like them to be Tasks under a single Project named Cat.Help!

Is there a way to filter a table that has been grouped and totaled (sum) by the group's total? 

Hi,I'm a relatively new Airtable admin. We have a user who can log in using SSO, but when he does he gets an error message saying that his free trial period is almost over. Since we have an enterprise account, I would think he shouldn't see that message.His account looks ok to me in the airtable admin area:(I covered over his real email address for privacy, but it looks like the rest of our users - uniqueid@dartmouth.edu.) I've tried signing him out of all sessions from the button shown, and had him log in with a different browser and a private window. None of those things helped.I opened a ticket with Airtable support, but I thought it was worth posting here as well. Any thoughts on how to fix this?Thanks and have a good day,Joe MontibelloManager of Library IT SystemsDartmouth College

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. All targeted encryption fields are set to null values. The cypher created as a result of step #4 is then transformed into a GUID and placed into a designated field in the record With this process, which occurs in about 800ms, the record entered by the user is now obscured; the sensiti

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 advance…