Other Questions

Hey community! So i want to add recurrent tasks for every record, the tasks are the same for every record. I tried doing a separate table named tasks with a subtask column and i link it to my primary table. THE PROBLEM is that when lets say record one fill his tasks, the tasks keep filled for ALL the records, i want to fill them individually for each record. Any suggestions?

How to call a particular row, for instance, i want all column data from row 3, how I do it with python?

So having built a base to the point where I would like people to see it, I went to create a “shared base link”. From what I’ve read this also the kind of link you might include in a website. It’s marked as a “Private read-only link”. Well it’s not that private from what I can see on the preview, because on 2 views that I’ve created (one Gallery, one Grid) it seems to happily offer to tell who created those views - my name and my email address appear when I hover over the view. There surely MUST be some setting to fix this, otherwise sharing Airtable material on a general website is not viable. The alternative is that I’m creating the wrong kind of link, but I don’t think so.

Is it possible to display all the data in the card view? Right now it will only display a maximum of three fields. Also, can you permanently hide fields in the gallery view, even when expanded? I need some data to display in the expanded view (but not all of it such as record ID) as opposed to the preview.

how can i create and launch procedure which process records from one table and creates records in another table?

Hey all, I’m struggling to create a view… For context… the table in the screenshot below is an integration that copies every email from my gmail account into AT. I’ve grouped this particular view by “subject line” for the purpose of “batching together” subject lines that have been sent twice or more. My Q is - how do I create a filter that ONLY shows the groups that have 2 or more of the same within them? In other words, how can I create a filter that shows only the emails (subject lines) that have been sent two times or more? Thanks! Christopher

I tagged this as kanban view, but what I’m referring to is a fully expanded record accessed via kanban view. For example, when I expand a record, I see a list of 40-50 fields and I only need to see 20 of them. Having to scroll through a bunch of fields that are not relevant to me is a great inconvenience and makes it more difficult to locate the fields I actually need to see. I’d like to be able to hide or remove fields that I do not need to see, but without impacting or affecting anything else in the system or any other users who share the same system. I am not an admin user so I don’t have any special permissions. I’m hoping this is something that I can do within my personal view.

I am about to ask the impossible. I am looking to sync from Google Sheets to Airtable. I have a free Airtable plan. I am not looking to upgrade. I cannot use apps, I have a free plan. I am not part of some large company. I am an individual person, trying to share my hobby stuff using Airtable. I am looking for free solutions. I tried using IFTTT (I have a Pro account), but the Airtable record creation will not work for some reason. I looked up Coupler.io, but you cannot sync from Google Sheets to Airtable (at least on a free plan). I could only select Google Sheets or Excel to sync to. I could use and Airtable automation, but I only get 100 per month and I need those for another community database project. I do not know how to write or run code. The only languages I know are HTML and CSS. There is a need to make a database of free resources. :frowning:

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!