Base Design

I need to create a base that will allow a user to add a new item (a change in operations, ie: we now date all produce boxes upon arrival, or Host to open all doors for guests arriving and leaving)then each item is assign to a department (Kitchen, Host, etc)Then each team member is to sign off on new process I can create the first part, however, how do I build the base to allow for staff to initial/sign any changes for their assigned departments? (without logging into airtable - this would be liked to Glide apps)I need to be able to view the change, department and all signatures (plus who has not signed for that department)  

Question on best practice. As an automation consultant, I'm building a CRM for my client which will integrate with Typeform, Make etc.Eventually I'd like to transfer ownership to the client while keeping enough access for any maintenance, but I am foreshadowing changes to credentials/access tokens etc resulting in broken links on integrated apps.How does everyone else do it with the least amount of moving pieces in the transfer? Do you start a new workspace and get the client to sign up for a paid Airtable account?

I have a fields called Due date and I am looking to highlight/color the value of this field. ( this is a date field not a single select or multiple select)Is there are way to only color the value of that fields ( not the row )

HiThis must be possible!?So I want to populate an Airtable from a Softr.io front end? I want users to be able to create records.As part of the user sign up process, I will capture their address/location.When they create a record, I want airtable to populate a field with location. This location should be pulled from the user record.Does that make sense?

Hello!Have a bit of a challenge and wondering if anyone else has been in a similar situation / need, and how they may have addressed it.Scenario(1) Simplified case: Say I have a Projects table that specifies a StartDate, EndDate, and EstimatedHours. I have one record (Project#1) that starts in JAN and ends in AUG with 800 hours. Assuming a simple linear average, how [would we get Airtable to tell me how] many hours should I expect to spend in MAY?(2) The first complication: There are many projects (of course), each with their own overlapping StartDate, EndDate, and EstimatedHours. How I can get Airtable to report what our total monthly commitment is for MAY? JUN? etc?(3) The second complication: Say there is also a Resources table (i.e. the labour that will be working down the commitments). Each of these records has their own StartDate, EndDate, and AvailableHours (not actually,

I have created a base to track various components of our commercial kitchen operation.I have bases for Menu Items, Prep Items and Ingredients.I have created various columns for the quantity of ingredients for each dish and need to roll them up into the quantity of ingredients in total for a given period, using sales data.Because there may be multiple meats involved in a dish, I have created separate groups of columns with Qty Meat 1, Single Select Meat 1 and a formula column that multiplies Qty by average weekly sales. I need to roll this up into the meat table so that we can calculate the total quantity of each meat we use per week using a formula to sum the four columns for each meat.This all works fine for the first meat, and works fine for the initial calculations for the remaining columns (to Meat 4).However, when I roll up these columns to calculate the total, the second, third and fourth columns are grabbing the Meat single-select from Meat

Hi there,I'm trying to find out if there's a way to share a view link for an entire workspace (i.e., not just a base). Thank you.

As you can see in the attached file, I want to Create a link between anchor campaigns and other campaigns from the same column. Anchor campaigns are the “major” campaigns happening throughout the year and all other campaign types are “subcampaigns”.  I want to link all the subcampaigns according to their start and end date with the Major Anchor campaigns. Please let me know how I can achieve this?

Curious if this has happened to anyone else? ... and why?  In one table, filter options now require that I click apply for them to take effect. See pic below. This is new. This table/view is one of our most regularly viewed tables and never required that. Changes to the sheet would happen live vs requiring clicking a button. The weird thing is too, on other tables, it's not required. We can still edit the filter options and the changes happen live. Curious what might have changed and if I can change it back?  

Hi!I have a system to record the working hours of employees. Through the form in table "timestamp", each employee reports the time of arrival and departure (and lunch break). Each entry is in a new line. Then, in table "Presence at work", I combined these rows for each employee to have all check-ins/check-outs for one day in one row. In this way, I then calculate lunch break and work time. If I group the rows by name and date, I can get a monthly attendance statement.In a completely different table ("holidays leave"), vacation requests are submitted via a form, where vacation days are added up.Now, in the table "Presence at work" (or in some extra table), I would like to have a monthly display for each employee of how many hours he worked, how many hours he used vacation and sick leave, and how many hours of holiday there were.Any ideas on how to make it as easy and automated as possible? So that I don't have to connect the tables manually. 

Hi there Airtable Gurus,We have four bases in our Airtable workspace:Base A: This is a new base connected to our legacy software, which automatically adds order numbers into Base A. We want to link this base to our existing Bases B, C, and D using the primary field (order number) from Base A.We would like the primary field (order number) from Base A to be selectable + within Bases B, C, and D within Airtable and via forms to ensure clear linkage and consistency to orders. These separate bases (B, C, and D) need to connect and relate back to Base A.Currently, I have tried having Base A synced with tabs in Bases B, C, and D. We want the connected information from Bases B, C, and D to be integrated into Base A through linked fields. While I have this information working through my synced table tabs within Base A, these extra linked fields are not appearing in the original Bases B, C, and D.Having this integration will allow our

Hello,We're an edtech startup for high school students.In addition to the in-app exams and quizzes, we also run offline exams in Telegram groups to mimic school exams (around 3 times a week).We send out a pdf to a group chat, and then each student solves the exam by hand, and then takes a picture and sends it back to us. Our teachers then give each student a grade and reply to that student. This is important because we want to see the steps in their solutions.These offline test scores need to saved so we can achieve the following:- Keep track of each student's scores over the school year- We send out report cards based on these scores- Check if a student doesn't have a score recorded, so we can check if they didn't do the assignment (assuming it wasn't an error on our side)- Keep track of when our teachers submit a score (to ensure timely responses)Right now this is all done on sheets.We were thinking of using Air

Hi!I have formula field for duration of a lunch break (datetime difference between lunch strat and lunch end). It gives me duration in minutes. Now I'm wondering if there is a way to sum this time?Thanks

Odd one, but I've noticed it a couple of times in the last week, so I wonder if it's a quirk of a new update.Basically I have a Status dropdown with a default option applied, called PlannedOne view that has some filters, including "If {dropdown} = ARCHIVE: Amendment"There is no grouping for the dropdown options in this view.Yet, when I create a new record it defaults to ARCHIVE: Amendment.This is how the filters are setup. Anyone know why this is? It's very frustrating. Is this a bug?

I want to link specific words (like "Click here") in one of my tables to a cell in another table in the same database. "Copying the Cell URL" does work... for those who have an Airtable account. I need "the public" to be able to follow that link from the webpage where I have this table embedded.I've been researching this for hours and can't find anything. What am I missing? 

Hello all, this may be one of those things where I am trying to think too complicated 😉I have a base for my finances -I just need to list my recurring bills, my paydates, and have an output showing a running total of how much $$ needs to be in my account to cover those things.So Table 1 has the ExpenseTable 2 has Income datesTable 3 Budget then has a record for every payment, linking to the Expense and the PayDate. I manually create each record and link the PayDate to the one most appropriate (so the date of the next PayDate). I then Group based on that next paydate. Once the payment clears my account I check it off as complete.

I have a base set up to log participant feedback after people attend a program. Respondents fill out a form and give ratings to questions related to different dimensions (belongingness, context, etc.); I currently have responses linked to activities and program profiles, which determine the specific dimensions that are presented in the survey.I want to make a Likert chart for each program that shows the distribution of ratings for each dimension. To do that, the response data needs to be arranged as below, where the cells are counts of the number of people giving each response for each dimension:I've played with creating different views, experimented with rollups and formulas, but I haven't found an approach that gives me the output I need without requiring m

Hello all!At the moment we are organizing our purchase orders in Airtable.We do this through two tables. In table 1 we put the separate products, each product has its own row.Then we link each product to a Purchase Order Number, which is portrayed in table 2. So in this table each row is a Purchase Order (containing multiple products).We want to organize this further, which makes it a bit more complicated.Each product in the Purchase Order will need to be split up further for the shipping process. This is because for each product we can use different labels (for different warehouses).So basically in the current situation it looks like table 1 and 2.Table 1:Product 1 (PO-01)Product 2 (PO-01)Product 3 (PO-02)Table 2:PO-01 (containing Product 1, and Product 2)PO-02 (containing Product 3)Do we need to create a third table to split each product into different pro

HiI am busy making an airtable for a logistics business. I think the user interface (with nested lists) and overall simplicity is really great and we can see ourself using this as our primary toolHowever I am worried about the record limits. We estimate to have around 500-1000 orders per month when we are fully up and running. Each order contains several shipments (on average 1,5) and each shipment contains at least 2 shipment jobs (pickup and delivery). So we will have to plan to add around 6000-8000 records per month. After a couple of years we will reach our limits.  My idea to handle this is to mirror the airtable base to an sql database or possibly firebase (but I am not a developer and have no experience with object databases. Have some basic knowledge about SQL though). So then we will have customer portals and an admin for looking long back in history directly linked

Hello,I'm trying to design a database that can accomplish the following:Aggregate data across several different entities (for example, cities).Aggregate data for each entity across different time periods (for example, years).Aggregate data for each entity and time period across multiple metrics (for example, (a) population; (b) property taxes collected; (c) median home value).I want to be able to use the Interface feature to design a table to review city-level metrics (rows = population, taxes, home value, etc., columns = 2020, 2021, 2022, etc.) with a drop-down chooser for selecting the appropriate city (New York, San Francisco, Chicago, etc.)Is this possible with Airtable? It's the time series element that I'm having trouble figuring out when constructing my base. Any help much appreciated.Thanks 

I am designing a base for tracking participation in a weekly Food Box.I am trying to organize the data in such a way that I can track the number of people who've selected a certain type of produce for any given Food Box Day.  Ultimately, I'd like to be able to create a pivot table in my dashboard interface along the following lines:Produce5/1/245/10/24Basil20Cilantro11

I am trying to set up a basic template for managing about 20 small construction projects. I have a table with records for each project and a separate table for all the various tasks that could apply to each project. I can't figure out how to link the various tasks to MULTIPLE projects while also tracking the status of the task within each separate project. Below is a simple example (in reality I have a list of ~50 tasks) of the way I'd like to be able to track tasks in EACH project. Project A tasks:-solicit bids (complete)-draft contract (in process)-hire sub (on hold)Project B tasks: -solicit bids (in process)-draft contract (on hold)-hire sub (on hold)Thanks in advance!

Hello there, I’ve created a pretty nice base that tracks almost everything necessary about thousands of trees planted on a farm. The base has lots of info from the date of acquisition to genus, species, notes, tons of photos, etc. But the one thing I’m stuck on is this: Since they’re 1000s of trees spread across 20 acres, I need to figure out how to Geo locate each tree or auto tag the geolocation of each tree so I know where it is on the farm. I would like this to be automatically created on a map, something like Google maps with a pin drop that shows me where I can find a plant. Spent some time googling and everything seems to be over my head in understanding how to do this. I’ve read many opinions including having to purchase some map tool from Google clouds and I’m just like “I thought this would be simple but maybe it’s not?” And this is a personal project so not any $ to spend. Does anyone have some help where they can guide me just add that one field so we can have it pin dro

i have a linked record field that links to another table. the linked field in Table A does NOT have the "allow linking to multiple records" toggled on. The corresponding field in Table B also does NOT have the "allow linking to multiple records" toggled on. and yet, i can link to multiple records. In Table B, i can select a record in Table A that already has a different record linked from Table B. Then when i go over to Table A, i have two records linked in a field that is clearly not supposed to allow this. is this a known issue? is there a way to prevent it? if it is a known bug/"feature", are there standard suggestions for ways to work around it? i don't want to try and work around it, if i can just prevent it. but if it can't be prevented, what is the point of offering that toggle option at all?!