Base Design

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?!

Primary field 'Total' pick list choices at the bottom is blocked by the '+' sign for add records.When I hover over the area to the right of the total 312 records number in this base an area behind the '+' sign is also displayed or highlighted, but I can't see what is there. Any suggestions?Thank you. 

Hi there, We have a questionnaire for our clients to fill out where they deposit links to their corporate materials (decks, etc). These are hyperlinks in the table where we collect them, but we would like to be able to reference these on another table (via a linked record). Problem is... when we link those records, they appear on the second table as plain text, without hyperlinks. Am I screwed? Or is there a workaround that someone knows and can share? 

I have a tasks table with a self-linking field that I use to define task predecessors. Is there a way when adding a predecessor to filter the options to show only those that relate to the relevant project/grouping?The problem I am trying to solve is that there may be many tasks with the same name so sorting through them to find the correct one takes time. For example, in my task table I may have the following:Project 1:Task 1Task 2Project 2:Task 1Task 2When selecting a predecessor for task 2 I have to wade through and find which Task 1 is the correct one for the project. May be helpful to know: my tasks table has another linked record field that links to a projects table, therefore each task is tied to a project. 

Hi there!As I am fine tuning the AT bases for our team, I seem to be missing something rather important here and thought I would ask the community about it as it seems to be rather significant.As we create tasks and assign to our team members, we would like the team members to login to AT and view those tasks. They can go into the various views but here they see all the tasks. This is fine as an overall project log. But if they then filter this list to show only those assigned to themselves, it seems to run the filter across ALL OTHER USERS viewing this page!If that's the normal behaviour, how does an editor/team member see only their assigned tasks without impacting the rest of the teams' views? Almost all other PM tools I have tested with (Monday, Asana etc.) have a dashboard page of sorts that shows their open items etc. But a personalization filter on the existing views may be enough for our needs.Please let me know as this is a rather important funct

Was there an overnight update that make the group headers gradient? Is there a way to turn it off? It is giving me a headache!

Hello everyone,I want to create a linked table that shows columns in one table as rows in another table.I looked at Pivot functionality, but it seems to be designed for Interfaces. (I didn't try it yet, so I could be wrong here)What I'm looking to do should be fairly simple: check the screenshots.Dates in Table 4  should be automatically transposed to how they look in Table 5.In the screenshot I did it manually for demonstration purposes.Thanks!Jan