Other Questions

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 ?

Hello! I need help updating my records with automation. There are 2 tables: one is a table that I use to create reports on the status of our Lights: each location has an ID, say 1234 and associated barcodes like a light #, a controller # and a pole # The other is a table of the entries from the tech team doing maintenance in the field. they report what ID they worked on and if there were changes in the light #, controller # and pole # Often the tech crew mistypes stuff and I need to review their submissions before changing our table thus not to corrupt our internal database. So I synch the Tech’s table in my base and added a few columns like Pole # fix which copies their input as a text so I edit it if needed and I can have a comparison between what the tech inputted and what I edited it to. I then made a checkmark which is the trigger of the automation, essentially saying that everything is good and to update the light #, the pole # and controller # in our table of the ID that they w

Is there a way to embed an Airtable into a Mailchimp newsletter? I am trying to get rid of the “click here” in the newsletter and just have the table itself show up in the newsletter. Thanks!

I’m building a simple app for internal use, i.e. not shared. The App calls an external API endpoint which requires an API key. Also there is a staging and a production endpoint. I have read about GobalConfig, but all the docs say do not store sensitive information here. There is no guidance on where to store sensitive data. Please can someone tell me where I store credentials for an external API and also how I can use something like environment variables to swap the stage/prod endpoint and stage/prod API key.

Hi everyone! I am using Airtable to have my applicants fill out their information. Now I am thinking to use it for test (multiple choice question type). Can I set a scoring system in the airtable? That way I don;t have to check the answers manually if they select the correct one?

I am pulling the records from a table, and I am able to loop through all the records, but in the API documentation I can only see examples for pulling specific cell values by directly calling each specific field name. In order to future-proof the script in the event that someone changes field names at some point, I’d like to programmatically loop through all the fields without having to know what all the field names are and hard-coding them in. Anyone know how to do this?

Hi - we have multiple bases in our workspace. Is there a way to give a team member “creator” permission for one base and “read only” for another? The bases are for different departments. Thanks for any ideas! Katherine

I’m trying to filter out dates for records in the past, seems like something silly, that should be built in … how do I do this?

This is for a non-profit that teaches English to immigrants. For this summer, we want students to be able to choose from among classes at their level. On the registration form, I’d like a student to choose their level, then be presented with the available classes at that level. (The available classes at that level could be determined by a filtered view, or some other kind of condition.) Is there a way to do this with AT/addins? I realized that I could create a different form for each of our 7 levels. But we’re having 2 summer sessions, so that would be 14 forms, and we would need to have each form in 6 languages … I found an unresolved question like this from a few years back, am hoping it is now possible. I really appreciate your help!

I’m new to Airtable and would like to hire someone to design a shareable database for our school bus transportation company. I am looking to design a database to record route structures that vary Monday thru Friday. I am currently using an excel spreadsheet and would like to build a shareable Airtable database to record employees assignments. Located in Chicago, but I believe its a very simple process and can be done remotely.

Hello, I’ve been trying to import a csv to one of my tables and I get a “… cells values could not be mapped” error - the error suggest that I should enable the “create missing select options” to fix it but the option disables itself every time I enable it. This leads to some blank cells on my spreadsheet. How can I fix this?