Other Questions

Hi, I’m trying to find a way of calculating the difference between two values within the same field but in different records within the same table as per the image below. I have read many similar questions and answers but they always appear to be over complicated, although most have been from a few years ago. I am hoping therefore, Airtable might have introduce a simple way of carrying out this calculation and hope someone might be able to point me in the right direction.Just to clarify what I’m trying to achieve, I am tracking the weight (plus lots of other info) of our new puppy and want the ‘difference’ field to calculate the difference between his current weight versus his previous weight.

The timelines in airtable are not overly functional for what I need. I need to view up to 50 timelines on the same screen, each with multiple records. As you can see, I am only able to view a few things at once.Partially there is a base design issue here, but for other reasons I don't really want to redesign the whole base to make viewing easier.So the UI doesn't quite work for me here. I need something that can condense the vertical height these take. E.g. thinner lines, or being able to overlap them, or being able to "summarise" the total time frames on the sub-grouping.Does anyone have any suggestions for a better app that plays with airtable?  

Is there any way to give base user permissions to access only selected tables in a base, not the the whole base?

I would like to set a checkbox to checked based on if another field has a number in it. Here is the Function I have in a Field called CheckChain. IF({Chain Amount} = BLANK(), Chain = 0,Chain = 1) The field Chain is a checkbox, and the field Chain Amount is how many times tire chains are applied. I am using this as a check to be sure the Chain checkbox is checked, if someone forgot to check it and entered an amount.

I'm looking to create a form with fields for a project lead like name, title, affiliation, and email. What's the best way to allow for multiple project leads? Ideally, a user could click a checkbox to 'Add Additional Project Lead'. There's no limit on the number of leads. Any advice on using repeating fields for this? Basically, trying to determine if I can somehow not have to replicate each field an ungodly amount of times with a checkbox between each conditionally showing the next bunch of project lead fields conditionally based on the particular checkbox (nightmare).

I am trying to build an order system with several tabs: Orders at vendor (I buy from 1 vendor) Orders from customers Customers Products An order from a customer has several products and might have more than 1 from each item. And that is where I get stuck. How can I add more than 1 of an item when there are multiple items? If it was just 1 item more times the colums would be product & amount, but that wont work. I feel like I am missing something obvious…

I have a string of text that I want to break into two separate strings of text. Here’s an example: This is an example string of text / I want to break it into two separate strings of text I want all of the words that precede the “/” to be one string of text. And then I want all of the words that come after the “/” to be a separate string of text. I want to completely eliminate the “/”. So, to recap, we start with this: This is an example string of text / I want to break it into two separate parts And then we end-up with this: This is an example string of text I want to break it into two separate parts

I have emailed and used the contact support feature and have not gotten a response. I need to have tax removed from an invoice before my institution can pay the balance. Has anyone else dealt with this? Why is there not a phone number where we can reach a support person?

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 surg

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

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: 

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 MontibelloMana

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?