Other Questions

I’m trying to have a central calendar of sorts fed from a few different sources, and while I’ve used sync to great effect to make that calendar, my one hangup is in entering new events/dates into that calendar. To illustrate, let’s say I have an “Events” calendar and a few other misc calendars. For example a “Holiday” calendar. They are all synced into a “Master” calendar. What I would ultimately like to be able to do is add a new event while referencing the “Master” view. Say, for example, I am looking to schedule an event but want to make sure it isn’t going to fall on a holiday. I’d ideally like to be able to schedule right on the “Master” calendar. But it seems like that isn’t possible, and instead what I would have to do is go back to the “Events” calendar and add the event after referencing the “Master” calendar. Am I missing anything?

I would like to make it so members filling in a form can select their name or their organization’s name from a list in the database using “+add”. But I only want them to see an alphabetical list of member names and not information in any of the other columns. So I created a “member name only alphabetical” view in the database. Then on the form, I selected ‘limit record selection to a view’ and chose “member name only alphabetical”. But all the hidden fields are still showing up. I only wanted the alphabetical names to show. What am I doing wrong?

Hello, We received a “Maximum Credits Exceeded” error on a SendGrid app block and after upgrading SendGrid we are still receiving this error. We have tried: refreshing app blocks creating a new API creating a new block with new API duplicating base to start fresh again Nothing seems to work, it’s as though Airtable won’t recognize that we upgraded our account. We were able to do upgrade our SendGrid account without an issue last year when we had an increase in messages to send via Airtable. A support request has also been made. In the meanwhile, any other ideas to try, please share!

Considering the profound success of the Vega Lite app, could we please get a proper app for Vega (non Lite version)? Ref: A Visualization Grammar | Vega There are so many other visualizations I’d like to use with Airtable data, for example, Radar (Spider) Graphs: vega.github.io Editor/IDE for Vega and Vega-Lite The Vega editor is a web application for authoring and testing Vega and Vega-Lite visualizations. It includes a number of example specifications that showcase both the visual encodings and interaction techniques.

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?