Other Questions

I am trying to set up a base to manage workload for 7 project managers, each with 6-10 projects. Design & Construction industry. I want to track the time from “Designer Selection” to “Designer under Contract,” “Schematic Design Start” to “Design Development Start,” “Design Development Start” to Construction Document Start," “Construction Document Start” to “Construction Document Approval,” and “Bid Opening” to “Construction Complete.” Right now I have a table that has each project in a row and columns for each of the dates. When I create the Gantt Chart block, it only gives me one option for a duration for each project. What am I doing wrong?

Hi there, simple question I hope. I have the Maps Block and to use it I have a geocode field which is aligned with my suburbs. There are a significant number of records in it which is taking a long time to load. I have these suburbs linked across many tables in my base. I’m just wondering, because it takes so long to load these codes, can I just have the one table with the geocodes, then for all other linked tables, can I use a lookup for the geocode? Or do I have to leave it blank for it to be auto-populated on all tables? Hope this makes sense!

I have a table of tasks that looks something like this: Task Name Owner Deadline Dependencies Task1 Ashley 3/2/2018 none Task2 Bill 3/4/2018 Task1 Task3 Cody 3/5/2018 Task1 I want to add annother column called ‘Dependency Deadline’. For Task2 and Task3 the Dependency Deadline should be 3/2/2018. The goal here is to flag a task that has a deadline before one of its dependencies. I’ve tried using the lookup feature but it requires a Link to a different table, not the same table. In excel this would do the trick: =VLOOKUP(D1, A:A, 3, FALSE) Any ideas would be appreciated. Thanks!

Hi there, Just wondering if anyone knows how to print a legend of sort when printing the Calendar? I have the events colour-coded but no one knows what the colours represent.

Hi! I’m new to Airtable and conditional formulas in general. I have a an airtable where I want to return a “Not Recently Scheduled” if a customer did not schedule an appointment with my company within the past 2 months, and “Recently scheduled” if they did. Previously scheduled appointments are recorded in another airtable, and I have added a lookup to this new table that pulls the dates of these previous appointments (if any) in a column called “Previous sessions”. Does anyone know how to accomplish this? I have checked out a couple of instructions but I struggle to make it work. I haven’t found a guide where the formula only checks the most recent of several recorded dates, and I also haven’t figured out if I can check the last 2 months from the date in which a person checks the airtable, without having this date stated anywhere. Let me know if it’s unclear what I try to accomplish and I’ll try to describe it in another way. Thank you!

I have a company of about 20 people and we are researching Airtable as a database solution for us. We want to talk to someone on their sales team to better understand certain features. We also have question and want to find out more about Enterprise. I have emailed a request for contact twice in the past week and a half and no responses at all, not even an auto response to say my message was received. How do I reach customer service or sales?

I’m building a public-facing base that will be embedded on a website. I’d like visitors to be able to check individual records and download only the checked items (rather than the whole base). Is this possible?

Question for the moderators here - Why do I have posts awaiting approval? what have I done to offend the Airtable community gods? :confused: (Ironically this post will probably also be awaiting approval :frowning: )

Hi i face a problem i paste a spreadshhet with numbers in it , a create a new base . When i want to change the fromat of the column from single line to currency , it gives back the smae number but divided by 100!

Hi All, I have exported the data from an old FileMaker Pro database that is used to track students earning points in grades 4-8 at a small rural school in Ontario, Canada. Students can earn points in three areas (Academic, Extracurricular, and Citizenship) and these are given out over three terms that coincide with progress report/report card distribution (Term 1, 2, and 3). Teachers give out points on a class list and then I manually enter those points in the FMPro database and print reports etc. I am trying to move to something web-based that allows for input from cell phone or tablet etc. I exported the data (and all of the fields used in the old FMPro database) into Airtable. I used the student’s name as the primary column and all data has transferred over correctly to Airtable. I am trying to make it so homeroom teachers (and say coaches for teams/clubs) can go in, sort the students by grade/homeroom teacher and allot the points they are responsibe for giving in each of the

Anyone succeeded in using the Airtable API from Arduino? I want to create Airtable records from the Arduino,. I do not need to read a table. Not familiar with JSON; I prefer to ask before reinventing the wheel …

I recently requested Enterprise Plan Information from Airtable over a week ago. I have not been sent any information about the costs, how to sign up etc. My company would like to move forward with this plan, however, my team needs to review the plan details and costs. This request is very time-sensitive as this needs to align with our budgeting process. Could someone advise the typical timeline for getting this information and/or more information on how to get in touch with the billing team? Thank you!

In the image you can see it pulling in the whole record (2020 Sweden), But I actually only want to display a single field from that record. Is it possible to do this?

Hello, when I extend a row on the right side is a panel with the revision history and comments. On top of the panel there is a notification that says, that the revision history gets deleted after a time, depending on the subscription plan (2 weeks in free, etc). It is possible to hide the revision history and only show comments. Sometimes the notification is still there when the revision history is hidden and I wonder if the comments will also get deleted after a time. Or do they stay permanently? Regards

Good Morning, I have created a chart block and have stacked my results (see attached image) I am now trying to change the colours of my Legend and order in which they appear Any and all help/guidance/advise welcome. Thanks Ladi

When in the calendar view, monthly view, how do I quickly jump to one particular day in the month, to zoom in on that one day, or start the 3 day view with that day? I can’t find any logic as to how Airtable picks the day, for the one day view? Am I missing something that is obvious?

Hello, I am creating a small database for film crew to subscribe to and become alerted of jobs when they become available. The database is comprised of two tables: Table 1: People Directory, which includes which roles each person wants to be alerted to (for example, camera operator) Table 2: Recruitment Drives, which includes which roles that particular drive is looking for (for example, camera operator) Using the Zapier intergration, I would like to have a system where I can create a recruitment drive (in Table 2) and it automatically emails the people in (Table 1) who are subscribed to whichever roles we are recruiting for. How can I make this work, so that Zapier knows which people to email depending on the roles we are recruting for. I expect it has something to do with view filters but I can’t figure it out. Thank you! PJ

I have created a base that contains all the various details about all my various projects that links to other records that include people involved, places we sell, etc. When our projects reach certain stages, I would like to be able to record the date it reaches that stage, as payments are issued on those dates. Ideally, I would like to be able to check a box that we have reached that stage and in another table a record is made noting the date that box was checked that I could see in a calendar format that includes all of the projects/can be filtered to be just specific projects. I would also like to be able to click a specific record for a project and see what dates we reached that stage/payment was issued. I’m not sure how to do this or if I’m explaining this well.

Hi, I still have trouble to get gif preview working… I tried a lot of different techniques, it seems there is a size restriction, but how much? What about the format? Does it accept any kind of compression? Can you give me instruction to make it work properly as I desperately need it? Thanks! Cheers BC

This beta version of Field and table editing permissions - https://support.airtable.com/hc/en-us/articles/360043139673-Field-and-table-editing-permissions-beta- has bugs… Every time when mouse cursor point to certain row, a check box will appear at its primary field. Users still can click on the check box and hit delete button to delete a / all records after setting nobody can delete records. Please disable the check box if permission is being set. Thanks.

Hello! First time poster. Weird question. I’m wondering if anyone has any ideas as to how one could take a database of names and have it correlate to an image with coloured boxes. An example would be to have a table with a locator rows and a column of names. If there’s nothing written in a name column, its corresponding location on an image or map is green (for available). Once a name is written in, the box/circle on the image changes to red, meaning unavailable. Thank you in advance for any suggestions you may be able to provide. :slightly_smiling_face: Geoff.

I’m trying to help setup a community form for mutual aid and am struggling with how to achieve this with Airtable, or if this is even possible with Airtable. The goal: People can submit a form specifying what services they can offer (e.g.: food, rides) People can submit what services they need Once submitted, people are paired together via zipcode, by which I mean a person can see who else in their zipcode is offering services they need and can get some contact info for those people. Ideally, people should be able to change what they can offer and what they need at any time. Would also be nice to see on a globe how many people are in your zipcode before filling out the form. What I’ve got so far is a form where you input your zipcode and a multi-select field for things you need and can offer. But I’m unable to find a way to link the things you need to the things you can offer, or achieve any of the things I want to above. I’m also able to see zipcodes on a globe using the Blocks but

Is it possible to give someone access to just a base and not the whole workspace?

Hello, I want to implement the automatic invoice generation feature described in this blog post: https://blog.airtable.com/supercharge-your-client-management-with-automatic-invoice-creation/ Can you please advise on which plan I need to have in order to be able to do so?

Hi team, I’m wondering if anyone has come across a template base or knows of a way (in theory) to configure a sort of visual resource calendar? We’re to the point where we have pretty good data surrounding our routine projects that we do for clients in terms of the number of work hours they take, but we want to take a stab at capacity planning at the team level. The vision is a base that would show a sort of calendar view where each day has shows which projects and corresponding hours allocations are assigned to it for the team, and how many hours are left to plan to (so there would need to be a way to assign an hour cap to each day). I’m sure this is possible or has been done - can anyone point me in the right direction or does anyone have a suggestion for where to start?