Other Questions

I am looking for a formula that can be used to determine the time worked. I have a table that is a “Check In / Out” which includes two fields in of Check in and Check out. Is there a formula that can be set in another field that will give the total time? Bonus, is there a way to add ALL of the times from that table?

It seems that I can only click out of the field to close it - hitting return/enter just adds a new line, and non of the cmd/ctrl/alt-enter keys work for this

Hello everybody! I’m creating a database to track all cash activities (inputs and outputs) from a cash box at the office. I’d like to have a column where we keep track of the total remaining balance after each transaction, whether it was an input or output, on the same base. A formula that I’d like to replicate is Remaining Balance = Previous Balance - Debit + Credit. How would you do that in Airtable? Here’s a look at the base in question: Airtable - Grid view. Thanks!

Hello community, I’m creating a video edit delivery schedule based on a start date. I was able to create everything with this formula WORKDAY({Start Edit},7) , the “start edit” day was the known and we added 7 days to when we needed to have RC1 due. Then the next formula was WORKDAY({RC1 Due},2)) and so on for 2 rounds of reviews and notes. NOW, I’m trying to predict lateness. I read that an override column should be made and if client doesn’t hit the RC1 due date I would then have a cell that is titled OVERRIDE RC1 Received to make changes. The formula I used was IF({OVERRIDE RC1 Received},{OVERRIDE RC1 Received},WORKDAY({RC1 Due},2)) The formula, unfortunately, won’t add the right amount of days to the new override date. Hopefully my explanation makes sense and someone can explain what I’m doing wrong to create a post timeline based on rounds of revisions.

Hello, I do not understand. In My “contact and prospects” database, everything seems to have been deleted except for one line … BUT When I expand records I can see everything with crossed out line. Help me restore this pleaaaase base

I am using page designer and linking to a currency field (called “Rate”). The rate is 86.56, and all of that is showing up correctly in Airtable. However, the document Page Designer creates is displaying the “Rate” field as “87”. How can I fix this???

Hello, I am the owner of pro account for our association. We have 3 collaborators. I am now trying to work with closed views and personal views. How is it possible to check the changes I make to their account? Met vriendelijke groeten, Geert Dornez

Hi everyone! I’m working in the page designer app and have two problems I don’t seem to be able to fix. Is there a way to resize the width of the columns? I see settings for rows, but not columns. One column is too wide and others too narrow and I cant seem to edit these. Is there a way to “overflow” onto a second page. I have more data than one page and it just runs out. Any help is greatly appreciated!

I need a formula that allows that indicates"if this column has data populated then this column = this" Is anyone aware of a formula?

Already I can see that this platform is made to be far more complicated and confusing to use than it needs to be; I understand that there are reasons for this, mainly for the company to separate us from our money- I just now paid for a Premium Plan- My question is simple: Why is there still AirTable brand on my forms AND tables? I will NOT pay to promote AirTable; In addition, it makes us look cheap and unprofessional- This is the EXACT same issue we had with JotForm and we cancelled them altogether…

Hello, I’m going to get the hook of the problem addressed here, referring to the out-of-order result. I completed a KODULAR project two months ago, specifically a quizz, but whenever I read it in the airtable, the fields return out of order. I just can’t find a way to solve this problem as it’s not up to me. And to make things more difficult, return positions always vary and are not constant. Can someone help me? From the image you can see the fields out of order.

Hey I just created a dashboard using my data on airtable. It looks great on website but when I downloaded the app, I cant find how i can see my dashboard. Can someone help?

I am using Metadata API to get table, field and view names. But I have over 130 fields for a table and the grid view ‘View1’ uses only 30 columns. So is there anyway i can get the field names per view (View1)? Currently I have only have one option: Get one random record from the view “View1” and fetch field names. But this way doesn’t show the field names with empty values. So i am looking for Schema for View including field names and field types. MetadataAPI is only exposing view id, view name but not field names belongs to that view. I have followed this link API behavior for empty fields / null values - #4 by Bill.French and found the hack is create hidden row. If i create a hidden dummy row, it will be visible in the normal grid view and for other users. I don’t want to create a filters for every user (almost 20 users). What is the best option to achieve this?

Hi! Im kind of new here in the community, never used it before. Hope that i can find some answers here. I have an enrollment table that joins a student with 1 to 8 classes and im hoping to do it individually in order to be able to control each class´ status for each student. That said, i have 1 to 8 columns that link a class record to classes table. My current challenge is to merge those linked records into 1 column. Is it possible to do it? any ideas? I´m posting an image to show some perspective. Tks in advance.

Hello! I am working for an Independent cinema and I am writing down each film ever shown. I have looked on other treads and tried stuff out myself, but I can’t seem to find a solution to my problem. As I write the Film Title in my main field, I would LOVE to have a chechbox field(or something like that) that automaticly checks if the film has been shown before. And I would also love to have a field that counts how many times it has been shown. Is this possible? All the best Andreas

I’m trying to import a large spreadsheet to a new table. The spreadsheet has about 8.5k rows and about 30+ columns. I’ve tried to import it via both the Google Sheets and Excel importer and in both occasions (on several attempts) it shows the correct data/sheet to import but on clicking ‘Import’, it just hangs on ‘Importing your data…’ with a spinning circle (and a greyed out background). I’ve even left it for 24hrs and it’s still on the same page. I’ve cancelled and started again several times and the same thing keeps happening and there’s never any evidence of even a partial import (it never even creates the new table). Can someone please advise only I’m not a enterprise client (I’m a Pro Client) so they’ve advised I contact the forum. Thank you Stephen PS I’m importing in from the Mac Desktop Client not via the Web Client.

Hi, I am trying to embed an Airtable view onto my website but it seems only four categories are displaying. I found this previous post but there was no answer to it, but it’s the same problem I am having. Anyone have any tips? Additionally, I want to know if there are any tips for messing with the CSS design for the card layouts. I can’t seem to find id’s in the inspect pop-up. I’ve seen websites that uses Airtable and I want to know how to design the layouts Thanks!

Hello. At this moment I’m using Airtable to keep track of my clients. We are a boiler service company. I ahve a main database and an appointments data base. Right now it works like this: when I eneter a new appointment it generates a new record in the main database, also generates an event in the google calendar and a new row in an excel spreadsheet. The problem is that if I modify something in the appointment database it won’t modify also in the main database. How can I do that?

Hi All, We are a group of engineers interested in building custom apps that can be integrated inside Airtable as we think Airtable has everything in it. According to us, it’s one application that fits everything. We as a group want to understand if there are any use cases on which we can build an app and place it on the airtable marketplace as a free open source app. All suggestions, ideas and use cases are welcome. Thanks

Trying to move records to another record by cut and paste. I use command X. It says its cutting. I paste into a 2nd base but those records are still in the original base. Am I missing something? Why cant I cut records out of one base? TIA

Hello, Is there any way to allow only some fields to be editable in a view ? Through sync’ed bases / views / anything? Regards, Ruchika

Greetings, I would like to know if this is possible in Airtable. I am looking to have a form. In one of the blank fields, the user will be able to select a date from a (Selection Options). Once the form is submitted by the user, I would like to hide or delete the option the USER selected from the (Selection Options) for the next person who will use it. I would like to know if this is possible or where can I find more information about it? The purpose of this is for me to schedule a meeting with the user and the next user would not have access to the scheduled meeting the user before already did. Thanks in advance!

Hi all, I’m trying to create a formula that helps me trim a product specific link to its root website link. For example, I have: https://freestar.co/products/12-x-bottles And want to get: https://freestar.co In some cases, the links are https://www. and sometimes they are are above (without the www). Could you help me out?

Hi guys, I’m looking for a way to build and implement a messaging app. This app should take the conversation log from a webpage and to allow the user to respond from Airtable, while sending his response back to the same webpage. Can anyone please guide me about the best way to execute this process? I thought of building a composer with React, but I didn’t got to the bottom of it. If needed, I’m willing to pay for consultation. Thanks so much for your help.

Hello Airtable community! I have been playing around with Airtable trying to send an automated slack message with either a list or a grid (grid preferred) where I can place different information from my table. This can be done when I am emailing, but for some reason on Airtable I receive a weird code. If there is no solution, is there at least a way where I can format my message to go out as a list? Please help me solve this! Best, Ines