Base Design

Hi. This seems like something trivial, but I can't seem to find any way to do this. I had synced two tables from a base to another.  During that time, various fields were renamed in Base A (the source table).  I noticed that the fields in Base B do not seem to get renamed as well, yet the sync remains active.  How can I know which is the fieldB name in Base B, which maps to fieldA in BaseA, without having to resort to guessing? 

I have a target base in a Workspace that is synced to several other bases all in one separate workspace. If I move this target base into the same workspace as the others, will this cause any issues with syncing or interface design?

Created a basic table in Grid View. Shared and embedded the List and was able to select multiple records, then select Download CSV and export the selected records. Nothing changed in the table, share, etc but now when selecting download CSV the selected rows are unselected. Even if all Rows are selected as soon as Download CSV is clicked the selection clears. In have searched the community and entered a support ticket and it does not seem like anyone has an answer here- I can download my entire table as a csv but that is not what I want- just want to choose the selected rows

First post here- I know I can easily build a form and connect results to Airtable- but can I connect a Form to an existing table for the user to select data from it? I have a table of workers by department with email address- I want the user to be able see and search this table (no problem) and then select users by email address from the table entries that will be submitted with the form.

Hi! So here's my problem: I manage an intranet platform for a very large company and I use Airtable for our editorial calendar. There is a special section on my platform of regularly scheduled content that is user-generated. There are four business areas (mine makes five) and together we are responsible for providing this user-generated content on a rotation each week. So each week there are four slots available but five business areas. So how do I create a scheduled rotation so that each business area gets a regular number of slots and that the total number of slots for each business area is more or less equal at the end of the year? Super basic example below:Week 1: 1, 2, 3, 4Week 2: 5, 1, 2, 3Week 3: 4, 5, 1, 2Week 4: 3, 4, 5, 1

I have created two forms within my base. As of last week, the fields for both form, #1 and form #2 were visible in my base and form #1, however, this week I noticed that many of the fields from my form #1 were missing from both the form and the base. I assume another editor went in there and messed around. I was able to recover form #1 based off a previous version of form #1  and was able to recover the base that showed fields from both form #1 and form #2, but I was wondering if there was any way to restore the previous version of the base and form #1 without having to rebuild form #1 completely and lose all the information that has already been submitted to the form.Thanks in advance for your help! 

Hi all!Here's a question... I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.Values in {Due Date} look like this '2/14/2024 5:00 pm'. I have another column {Date} with a simple formula DATETIME_FORMAT({Due Date}, 'MM/DD/YYYY') so I can get the date alone without the time.Heres the problem... Everytime I schedule a task pass 6:00 pm in the {Due Date} field, the {Date} value changes 1 day. Example:{Due Date} 2/14/2024 5:00 pm{Date} 2/14/2024{Due Date} 2/14/2024 6:00 pm{Date} 2/15/2024Help!

I am trying to build a B2B application and I want to keep the logical separation of data between the two customers. Let's say I want to give the ability to my user from Business X customer to choose an employee name from drop down that should be relative to their business. When a user from Business Y clicks the drop down, he should only see the employee names from their own business and not for both Business X and Business Y (which seems to be the current case). It is a privacy issue. I can manage this manually by creating visibility filters on softr.io or having a separate view on airtable for each customer, but it is not scalable. Is there an easy way to manage that?

I have a table of feedback for two cafes in a base. Each bit of feedback has an assigned category. I have another base that is linked to the category so that I can view aggregated data such as average feedback score by category. This data is then visualized outside of Airtable. The problem is that in Airtable as category is the primary, it lumps the cafes together in each row, so from this table I can't distinguish one from another. I need an output where I can see organisation as a breakdown of the  category. Something like this (almost like a pivot table structure):How would I go about designing my base in order to achieve that?

We review a variety of documents for client. Such as bylaws, legal governance documents, and financial statements. Currently I have a base and a form set up. The form allows a client to submit the documents they would like to have reviewed and provide their client information. Once that is submitted the base is populated with the documents broken down by category, the clients name and contact, and a unique ID for the batch of documents. At this point we vet the documents to confirm they are the right ones start to extract the information that we need. Data can be in the form of select phrases within a set of bylaws, critical dates of documents expiring or when they were registered, and the financial details of a document. Once this is done we create a summary of our findings and present it back to the client. This is largely done manually at this point with a few automations. We want to start fully automating this process and use Airtable to store our data. B

Does anyone have any suggestions or input they would like to offer to help me decide the best way to organize my companies new lobby base? The project is tied to a sign in form (AirTable Form) for anyone coming into our lobby to sign in to.This includes people coming in for appointments, dropping off documents, picking up documents, questions, status inquiries, speaking to a manager (escalated needs), and all the above.We have multiple different departments in our company, so I have been thinking that we have two multi-select fields.1. PURPOSE OF VISIT:- Dropping off documents- Picking up documents- status inquiry- OTHER- scheduled meeting1. REASON(S):  why the person is here today.  And that can be a long list. Even though we have different departments in our company, there is a lot of overlap in terms of the services we provide and often there is a necessary need for mult

hi all,I am new in Airtable, and cannot find an ideal solution after searching for few hours.-------------My Question-------------- I have a table[Clients] with field[Email]. And another 2 tables are described below:- Table [Sales] : Sales list indicates which sales is responsible for which clients. The common field between [Sales] and [Clients] is [Email]- Table [Table Number]: to indicate which table those clients are assigned to sit in dinner time. The common field between [Table Number] and [Clients] is [Email]I want to add lookup fields from [Sales] and [T

Background:I work for a training provider, offering courses online and in-person. We work with ~50 (and counting...) independent instructors to deliver our live Zoom and field sessions.When scheduling our course deliveries, our Program Managers reach out to instructors with the correct skillset and book according to availability (they're mostly self-employed so have commitments that we don't have visibility of). Once booked, PM allocates the instructor to that specific delivery. In Airtable, that's currently a link between our Instructor table and [Year] Deliveries table.Many of our deliveries are multi-week courses that involve instructors teaching different weeks/modules. One 10 week delivery often has 20 instructors allocated to it.We can have multiple deliveries running at any one time, with different instructor skillsets required.

I have a column with linked records and I do not want the column to have more than 6 records. I do allow multiple linking but is it possible to put a restriction on how many records can be entered? [I want more than 1 but less than equal to 6]. ThanksChandrika

I have a primary field which is an autonumber and I want to change it to a formula (pad the number with zeros, concatenate with another field etc.). My plan is to keep the autonumber, create a formula field, and then change the primary field to be the formula field.Is there any risk with that? can such action break any dependencies? scripts?

Hello. I have a form in one table called "Creative Requests" that has a column to assign it to a project once the form is submitted. In a separate table called tasks, I have a list of what everyone is responsible for. The tasks in the form responses aren't pulling into the tasks even when they're under a project. I am thinking it's because the fields aren't the same, but is there any workaround for this or any suggestions of how to get these tasks all in one location without moving the forms to the same table as tasks? 

I have an issue with tasks and dependencies I could use some help see the video for details.https://www.loom.com/share/7bb070b9fa7043908695d33392036b6d?sid=369d8430-64f0-4117-bcea-85c76a5f1a39

Imagine that I have three different fields.Disboard URLTop.gg URLOfficial invite URLHow do I make it so if a field isn't found in the formula, it'll fallback to the next one of lower priority.For now I would like my formula to lookup three fields.Here's what I've got so far but it only works with two fields.IF({Disboard URL} + {Top.gg URL}='' ,BLANK(), {Disboard URL}) 

Hello everyone. I intend to connect interviews (synced to Airtable from a Google Calendar account) to different records, each one of which represent a single deliverable. The constraint that I face is that if I connect more than one interview to the same deliverable, only the first one appears in the Calendar View of the same table. Can someone help me resolve this?Thank you in advance!

Hi again,I'm facing an issue in base designing and I can't find the answer myself or in this forum, so I'm trying here,I have this field in the table named "Actions", linked to another table named "Inventory", every time I add an action, I can choose to add every item I have in my "Inventory" table.I want to keep my inventory up to date, so every time I add a row in the "Action" table, I want to -1 of the specific item in my Inventory section.Can you help me find a way to do it? I tried automations, but didn't really understand how that works, I tried formulas too, but I'm unsure of the results, given the fact that I can put various items in the Action table.Thank you,Elie 

Hi all,I want to build a base for tracking the onboarding and ongoing training of employees at our company. We have a list of “SOPs” standards and guides. I’ll just call them SOPs here. There are actually several lists (one for engineering, one for accounting, one for HR stuff, etc). These lists currently reside in a series of google sheets that have columns to describe what the SOP is for, who “owns” it, what the status of it is and its priority for training purposes and a link to it (in google drive). Then there is a master list that links out to the other lists. The challenge is that I want to track how well each employee on the team knows a particular standard, and if it is a priority for them to learn it. And it doesn’t make sense to do that in the spreadsheet format. I want to transition this to an Airtable base that relates a table with our employees (a row/record for each employee) to a table with the SOPs. So for each employee there would be a few fields that define:

Hello. I have a base that has the following tables in it: Projects, Tasks, Communications Form, Web Form, Creative Request Form and Photo/Video Request Form. Under the Tasks table, we have a view that shows what everyone is working on. Each Table that has a Form also has a grid to collect responses and assign a user to the task. Is there a way to pull the tasks from the form tables to the "What are people working on" view in the task table? If not, is there a good workaround that might help people not have to check multiple tables?Thanks!

Hello!This is my first post, so I hope I'm posting in the right place.I am trying to use Airtable as a production board for my company. When an order comes through Shopify, I have Zapier tell it to upload the information with Line Items, but my team doesn't always know how many items may be in one order to complete it, so I started showing "1 of x" for my guys to know when they view the interface.Is there a way for Airtable to automatically mark a job with the same "Order Number" (as it is grouped right now) to autopopulate the numbers of the line items in a column, even if it just auto-numbers with 1, or 1, 2, 3 etc. then I can reformat the way it looks?Or is there a better way to go about what I'm trying to accomplish? I feel like I'm overcomplicating it.Thank you so much!

Hello, I am a newbie to building out AirTable bases and am mainly working off of AirTable's Marketing Campaign Tracker base to make my life easier as my new team gets more and more campaigns in various stages.AirTable's Gantt view with field dependencies is what made me move my tracking efforts over from Trello, but I am realizing the campaign management base may not exactly be what I had in mind for tracking how long the campaign is in each stage. I was curious if there is a newbie-friendly way (I AM willing to put time into it, but my skills are not good) to build a base to track the duration in days from the automatic single-select field value (such as not started) to the last field value (usually completed or approved). Because some campaign steps can be done together, or need to be done before another, I would also need a start date to reference. Ideally, I would love to reference the Marketing Campaign Tracker fields to get this duration and date started.

So I am looking to utilise this, the base I am looking for is I enter a property address and it will create a task list of items such as photography, entering data into our system, safety checks all these to be either as Not started, in progress or completed. Of which the role for certain tasks will never change simply I would like for 1 name/property to be entered and it just creates all the tasks automatically.