Base Design

We use tables to add tasks we’re working on. Since different departments need different information, we use different tables for those departments so they have their own tailored table. One thing they all have in common is a “Time Estimation” field. In my main table, where we gather our projects, we link out to those task tables. Project 1 – Design Department Tasks – Programming Tasks – Animation Tasks In the project table I’d now like to have a summary of all time estimations for a project from all different departments. Currently it’s a bit of a hassle as I have to create a lookup or rollup field for every table and then add another field with a formula to calculate them together. This only clutters my project table. I’d like to skip one step and have a formula field that can directly access the other tables: {design department.time estimation}+{programming department.time estimation} This would de-clutter a lot of tables

I’m new at airtable, but not at PowerBI. I set a request in PBI to get all the data produced by someone in our company. When I download the csv from airtable I got all the lines but when I connect to the API, I can only read 147 line… Someone can explain that ?

I run an creative agency that contracts several freelancers at any given moment. Currently, we have an Airtable base for managing the recruitment and onboarding pipeline for the freelancers. We’d also like to start managing the invoices from the freelancers through Airtable as well. At the moment, it’s a massive headache collecting bank account information and parsing individual invoices as everyone formats their information differently. We’re hoping there’s an opportunity here to use Airtable forms to collect the data, link it to the existing records, and then output neat, consistent looking invoices using the page designer block. Problem is, the primary field in the ‘Freelancer’ base are the names of every freelancer we work with, and that’s sensitive information we can’t show externally. We thought about changing the primary field in the base to a sequential number ID, but that seems like it would create problems of its own. So the question is,

Hi, I have been trying to develop conditional logic on my base. Ex: I have different category and each category have sub category. I want that when I select a category, the net field only shows option in that sub category. Once category 1 is selected in category 1.1, category 1.2… available in the next field. If category 2 is selected in category 2.1, category 2.2… available in the next field. And so on… Please let me know how I could do that. I thought that the conditional lookup, roll up and counts new feature would help but it doesn’t. Looking forward for your support.

I am trying to create a way to tag three different fields to a set of categories. And from one field I want to know the other two fields that relate to it based on the same categories they belong to. For example, the categories are Energy, Water, and Animals. The three fields are videos, projects, and lessons. I tag the videos with the categories (more than one). I also do the same with the projects and lessons - to the same categories. Then for each video, I want to know all the projects and lessons associated with it based on the common categories. Please help.

I am attempting to create multiple organization charts / “relationship maps” for all of my vendors (on a separate table). Right now the way the block is set up, it thinks that all of the rows belong to the same organization. However, as you’ll see I’ve linked the Vendor name to a different tab because there are multiple vendors that will each need their own relationship map. In the example I’ve shown, I’d like to have 1 organizational chart for Example - Dunder Mifflin and another for Wonka’s Chocolates. Is that possible without creating a new tab for each Vendor?

Respected Everyone, I already complete kodular apps,The kodular Apps category was first seen from the airtable, but the category is no longer visible.I have tried a lot but can’t solve this problem… Please anyone help me??

Hi I have been trying to update my recipes into the food costing calculator. so far have done the ingredients list - but i have hit a problem. when i enter more than one recipe that has the same ingredient - eg an onion - it changes the ingredient amount in the ingredients list. that would be fine if i only used onion in one recipe - but it is in many recipes at different quantities. maybe i have not set the ingredients list up correctly? or may be i need to be able to have the recipe card multiply a single unit of the ingredient eg 1 gram or ml so that it works? any hints how to use this food calculator would be greatly appreciated. Judy

Hello, I’m looking to set up a base to keep track of value of some KPIs across multiple offices/locations over time. I would like to have office level indicators table project level indicators table (with multiple projects per office possible) ability to see at a glance the current (latest entered) values for each indicator ability to see how each indicator per office/project evolved over time I am currently achieving this by having a month column in the project table, which one record per office-month. The project level table references the calculated office-month field and has one record per project-office-month. Is there a cleaner, more efficient way of achieving this? Particularly useful would be some way of not requiring to enter all the data each month over again, but only update values that have changed.

I need to create a customer number that includes the year, and an accruing customer number. E.g. 2020-0001, 2020-0002, etc. The thing is, every year, the year has to change in the customer number, and the four numbers after it have to reset. So if the last number of 2020 is 2020-1234, the first number of 2021 will be 2021-0001 again. I can get the year from the Created Time field The problem is the numbers after the year… I figure I can’t use an autonumber because it won’t reset each year. I’m stuck on this part, and would appreciate any direction. Thanks!

I created a scheduling system in airtable where people can sign up for scheduled slots through a form. One table has the slots that are available, call this A. Another slot has the actual schedule where people can sign up for slots, call it B. When a person signs up for a slot, they pick their team which is referenced from another table, call it C. So, table A will link to a schedule entry B which will link to a team C. Is it possible to also link table A, the actual slots directly to the team C once the team has signed up?

I am trying to embed a table on my Wordpress site and have some questions Is it possible to remove the “download csv option”? I don’t want users to be able to download the entire table but I want them to be able to copy and paste information from that table. I have a column of images but it’s just showing a link to that image, I want the actual image to show in the table. Is this possible?

Hi, I have 2 tables connected. Table A : Sales of the day Table B : All my services/products Basically, when a new customer purchase something, I go on Table A, go on the column “product”, and as it’s connected to the list of all my services in Table B, I just select what the customer has purchased. My issue is I can’t select 2 times the same product. If I have added one of my products on Table A, and I want to add it again for the same customer, the product is not on the list anymore. Is there a way to be able to select several times the same product ? Thanks, Sébastien

Why is this this Balance Column not equal to Zero 0.00? My Formula is {Net Bill Amount}-{Total Paid} How can I build the Formula that is should say 0.00 , I need it as a 0.00 !!!

Hello! I would like to use Airtable to keep track of our counter drink sales we have in a cooler. It is not really part of our main business so I want to track it differently. I would prefer using Airtable over Excel. What would you suggest to keep track of the small inventory, cost, list and profit? Will it even calculate profit? Thanks! I’m excel proficient but database dumb but I much prefer to use this. (I use it for our equipment inventory) I have tried using the inventory template but there doesn’t seem to be a way to make a purchase order with multiple products. The template appears to show only one product per purchase order. In my case, we only order through one manufacturer and different products.

Hello, I am trying to show the summary of years members have participated in a non-profit. There are five fields: Name, Active (checkbox), Date Joined, Date Left, Years of Membership The table has both active and inactive members. I am using the time diff formula, however, for the members that are still active, the Date Left category returns NaN value. Is there a way of calculating a Years of Membership for both active and inactive members in the same column? Thank you!

I’m trying to create a database for product specifications for food products. It would basically be an enhanced formula/recipe database for product SKUs.

Hello is it possible to link tables by few condtions? My Example: I have 4 tables: Transactions Budget Reporting period Category I linked Budget and transaction each with both Reporting period and category Now I would like to see summary of transactions against budget per month and category currently both tables contains this two field but I dont really know how to actually link without creating another field and links is it possible at all? Its like I want to link tables based on condition from another link table

Let’s say I have created an “entity” in Airtable called “Status2”: Lightshot

Hi Guys, I am creating a lead funnel Kanban and lead source list Grid View. I would like to be able to add a count from the Kanban to the Gridview. I want to add a field type to the Kanban, lead source, for example, Linkedin or Facebook. I then want to count the total number of these and add them to the gridview relevant location for facebook or Linkedin. Thank yo .

Hello, I’m trying to manage projects within our content calendar. We have multiple departments that we are creating content for and I’m trying to manage the work flow effectively. Thanks! Kristin

I have an airtable base for a volunteer organization, which is organized into project areas (Social Media Posts, Newsletters, Articles). I am trying to create a ‘collaborator summary’ table where I can quickly see what assignments those collaborators have from other tables. Is this possible? For example, if I am assigned to write 2 Social media posts, I want to see the title of those posts in my ‘summary’ table. I also want to see which Newsletters I am assigned to, so maybe that needs to be a different field in the summary table.

Hey there! I’m working to build a base for the following use case (similar to a sales pipeline CRM): I have a list of Vendors, who each have multiple Documents they must fill out / complete in order to move from Phase 1 to Phase 2. While the list of documents to be completed is the same for all vendors, the responses within those documents/forms will be unique. I want to track completion rate of the unique documents for each vendor, and once all documents are completed, have the ability to move them into Phase 2. (Phase 2 will have a different list of documents necessary to be completed before graduating to Phase 3). For instance, I want to show that Miller Manufacturing has 60% of all documents completed, while Rachael LLC might only have 20%. I’d like for there to be a view to show the details for where each Vendor is in the process, while also being able to drill down

Hi, I am getting my table data from Jotforms with an integration. This is working well. I want to then customise my table further and add lots of extra fields in Airtable for workflow, but I kind of want to keep the original import data structure intact and simple. My solution to this is to create a second table which has all the data from the import table linked plus all my extra goodies. I am aware that I can achieve this by creating a new table and manually linking all the fields from the import table, but I wondered if there was a simple solution to creating a complete linked table duplicate in one click? Am I just being lazy? I could have probably done it manually in the time it took to write this but I hate doing stuff the hard way if there is something I am missing. Thanks Pete

Hi! I am new to Airtable. I am currently setting up an Airtable spreadsheet and one field (column) has a date. Is there any way possible to make the column next to it show what date it will be 2 weeks later? Regards, Sam