Other Questions

Hey! I have set up an base to keep track of the location of bikes. The bikes are all the same but have different frame numbers. I have made table of different possible locations that is linked to the “input” table. In this input table I gather the next values: autonumber - Frame number - created time - location (from other table) - status (single select, broken or in use) Every time a bike is moved, a record is made with a frame number and the new location. In this way, it’s possible to have multiple records with the same framenumber, but with a different created time and location. If I want to see the current bikes in a specific location I need to filter out unique frame numbers and their status and location based on the latest entry. How do I do this? Thanks! Jeroen

Hello, I have two tables in single Base containing names of different people. For e.g. in table A, I have a column having names of people (120 entries). I also have another table with column having names of people(50 entries). I want to automatically merge all these 170 entries into another table column and this should keep syncing. Any idea how can I achieve probably using formula or integromat?

I am trying to deploy an Airtable App using a simple CICD build pipeline. I need to set the API key using the block cli. Because this is an automated process I need to be able to set the key without any user input. When I try to pass the key to the command (block set-api-key key***********) it still asks me to manually enter the key which causes the process to fail. Is there a away around this?

Problem: After downloading a view as a .csv, some of the content within a lookup column is being replaced with #name-quiz-app Below is the content as it appears within Airtable. After downloading this view as a .csv, below is how it populates. In column C, the content was replaced by #NAME?. Any idea as to why this is happening? This is a huge dealbreaker for our team affecting our decision to purchase Airtable.

Hello kind forum. I hope someone can advise. I need to generate a tabular report for who is due to be paid per diems for the previous week. The report needs to look something like this: Name____________ Number of Days of PD Due J. Smith_______________________7 J. Doe _______________________6 J. Brown_____________________5 That is to say that I need to show the number of days that per diem is due for each person for the previous week. The base has a table of employees. There is also a “Daily Reports” table that the field manager fills out with a ton of information. This table has one record for each day. I would like to add a link-to-record field that is called “Not Due Per Diem Today”, that links to the Employees table. This will allow the manager to indicate the small number of people on his team who are NOT due per diem, rather than indicate the large number of people who ARE due per diem. So then I need to create the table as described, presumeably from the Employees table, usin

Hi there. I’m using API to upload my photos from google drive to airtable. When they uploaded, after few second, a green frame remove them. How…! What is green frame! why my photos deleted!

Records disappear then reappear when I re-enter the text part of the variable into the filter of a table view. This disappearing can happen when I re-fresh my browser, or when I go to a different table view and then return. I can both replicate as well as “fix” this behavior: There are three different fields that can be called on in my filter for this table view … Project - linked field to Project table Discipline - lookup field (Discipline field from Project table) Name - Formula field (concatenate formula that includes Project field) I can replicate the odd behavior (of records disappearing then reappearing when I re-enter the text part of the variable into the filter) when either: Filter is set to Discipline contains meeting; OR Filter is set to Name contains meeting. I can “fix” the behavior when: Filter is set to Project contains meeting Behavior has been functioning fine for many months with the filter set to ‘Discipline contains meeting’. But today is the first time this

Is anyone experiencing odd problems with view controls (filters, sorting, etc.)? They’re suddenly not working correctly in my bases, and none of my records are appearing at all when any filter is applied. Only if a view is unfiltered can I see any records. I’ve recorded a Loom video and sent it to support, but I’m curious if this is isolated to my account, or if it’s something more widespread.

Hey! I need to make a very simple pie chart from a column in a table with checkboxes: piece of the pie is checked, the other piece is not. I can do this with the airtable app, but I would like to show the percentages tull-time (so not only when hoovering like the airtable app). Can someone help me with code this in the data part of an pie chart? I’m not looking to become an expert, just this would help a lot! Thanks! Jeroen

Hi, I am trying to set up information documents for clients in page designer (Summary sheet with address and standardised info) but when I import from fields in the airtable, some of the standardised fields appear with their coloured background. This looks unprofessional as it is obvious that it is an imported field. I am not able to change it in the formatting. Hopefully I am missing something really obvious! - can anyone help?

The Gantt chart is a great tool but it defaults to consider Sat/Sun as weekend days. In this small yet noisy part of the world we observe Fri/Sat weekends. Anyway I can make the Gantt reflect that?

We have a field for Calendar Date. Is there a way to have the day of the week (Monday, Tuesday, etc.) that corresponds to that calendar date autopopulate in another field?

I need to export a Gantt chart that only looks at the current quarter.

Newbie here. Are attachments/photos linked to the original place when they were attached? i.e. If I have a folder on my hard drive called XXX and that folder contains photos. I attach my photos to my table. Do I need to leave those photos in the folder on my hard drive?

When I apply a filter, it works until I navigate away from the view. Once I come back, the filter has reverted to a messed up version even though my changes to the filter were saved. HELP!

Suddenly this afternoon (Eastern time) the date filtering seems to be malfunctioning. When I remove the filters from my view, i can see my records, but when i try to filter for items dated today or before, it says that all of my records are filtered out of the current view. I have lots of records dated today or before. Anyone else having trouble today who didn’t have trouble yesterday? Anyone at Airtable know when this issue may be fixed?

I pasted several records into a grid, as I have done in the past (nothing has changed that I know of). Now, the grid view no longer shows the text of the Select (dropdown) item for the inserted records (existing records are showing the text). Odd thing is the values are indeed there (and I can see them listed when going into the Customize Field Type option for the Select). The text in the non-Select fields is showing, so it just seems to be something glitchy with the visual for the grid view on Select fields. Again, the text is there (and I can see it if I create formula fields based off those fields). When I try to remove the colors, I just get grey boxes. Any idea why this just started happening? I have tried scrubbing the original data and making sure there is no trailing spaces, etc. and re-pasting it. This is really odd since I have been doing this a lot for several years and have never seen this before. So, any advice on what could be causing it would be greatly appreciated. Tha

Hello, Apologies for the very basic newbie question… Is it possible to convert a list of (geographical) addresses into a list of corresponding longitudes and latitudes? I can see extensions that do it but just wondering if it’s possible within Airtable itself… TIA

Hi! I am wondering if there is an ability to add additional data dimensions to Pivot Tables in AirTable. What I am hoping to accomplish would essentially break down each Rep, and by the dollar amount of potential sales they have in each deal stage, this part of I am able to get set up, however, I would like to show additional data points (such as monthly quota) by each rep. Ideally, the table would show a row for each rep, the amount of money the rep has in each stage, and then an additional column showing their quota for added context. I have been able to do this in Excel and Google sheets but adding in additional columns using a “Value as: Column” type function and selecting additional columns from my table. Any suggestions on how this might equate into AirTable?

I have a table with calendar view that was setup when I had the view account. Now I have the paid version I want set the end time for meetings as well but can’t see how to do this. Please advise.

This started about a week ago. No changes to the computer (no windows update, though there was a chrome update that took place after the issue occurred I am on the latest Chrome 90 update)… I am using a Zebra ZP 450 Label Printer. Wasn’t having any issues (can only use page designer on Chrome). When I go to select the printer it says it’s not available. I can select any other printer, however, I can’t figure out how to export a pdf to the label size we typically print 2.25 x 1.25. PDF only wants to print out letter size. I uninstalled the driver, and reinstalled and it stopped giving me the error message, but now airtable just crashes when I select this printer. We’ve been using this printer for months, and it stopped working last week.

Hi - I set up an automation which triggers append new row in google sheets. It worked for a time but now it seems to have a problem with the connected accounts. I’m logged in with the same e-mails as both the bases (sheets and airtable) have been built with. I have a screenshot of my problem. Can anyone explain to me how to connect the airtable and sheets? Thanks!

I have a process where we have a number of multiselect items (Resources) in one column that indicate the need to score each of them in a different table. Each of those tables has a checkbox when they are done (Completed). I’d like to write an equation that looks for an item in the Resource Column, and then looks at Completed checkbox, and returns a true/false statement on the task. So if an item has three Resources and two checkbox completed, it would return a “Needs to be Done” for the one that is not complete. I would run these sequentially on all five Resources. I think each chunk could look like: IF( SEARCH(‘Riparian’, {Resource Type(s)})>0, AND( SEARCH(‘Riparian’, {Resource Type(s)}>0,{ :heavy_check_mark: RB Score Drafted}), " RB Done", “RB Not Done” ) ) This would search for the resource name in the multi select field, if greater than 0 its there, and therefore needs to return a Completed Checkbox to be true. The IF statement would just keep it from occurring if not r

I am trying to print to a 30"x42" page size from the base itself (not the page designer). I am doing this because I want to print the full table. However, in the print settings, I am limited to these options. Is printing to this larger page size possible?

Hi All . i have i hope a simple question I have a single select where my employees can choose a size of a product . in the next field i have a price field and the next is a amount field and the last is a formular to get the price this works as it should . my question now , is there a way to give discount if we choose more than one in amount for example i want to add a 50 % discount if anyone chooses 2 in amount . is this possible in Airtable ?