Base Design

Hello everyone, Can anyone guide me, in how to overcome this obstacle I keep banging my head against? Let me make a very simple example: The Tailor Shop Table 1 - Incoming orders Table 2 - Inventory Table 3 - Material usage Table 1 is integrated with our online store (via Zapier for example), and we are fetching all line items from orders. So, it could look like this: In Table 2, we have our material inventory In Table 3, we are determining how much material each line item needs So far so good, but here comes my problem… I know how to do the calculations, to basically subtract the amo

Hi all Here is the challenge I need to solve - I track some small time investments for an investor club in companies. i.e. records are the company names (Apple, Netflix, etc.) Fields are James $ Invested and Adam $ Invested James invested $100 in Apple Adam invested $50 in Apple and Adam also invested $50 in Netflix I have a formula field that sums up the total amount invested in each company (e.g. Apple is $150 ($100+$50) and Netflix is just $50. What I would also like to do is link this to another table and have James and Adam as the Records and then show the total amount they each invested in aggregate (i.e. fields would be Total Invested, and for James it would be $100 and for Adam it would be $100) I saw this link below but it does not work for me since I have more than one field (James and Adam) linked to the same record (Apple)

Hi, So I’m working on system for a client and could use some help with designing the base required. It turns out that the client’s intake form is a long complicated form and when I counted all the questions in the form, which will eventually need to be fields in Airtable, it turns out to be 530+ fields. Not to mention that even if I could reduce the form fields down to just under 500 to stay within the field limit, I’d still not have enough additional fields to hold calculations, formulas, status tags, etc. It’s unlikely that the form fields can be reduced as these are legal immigration forms and require the submitter to provide a great deal of information. The form however is going to be created using Paperform so we’ll not be using Airtable to build the form itself, but the intent was to use Airtable to store the form data. How would I go about this given the 500 field limit? One thought that came to mind would be to break up the form into multiple forms, so a

Hello Airtable community! I was wondering about the best ways of implementing capacity planning and project planning to a base. I’m looking at trying to track level of effort by month per project. Example: – Jane Doe works 80% on Project 1 and 20% on Project 2 for July 2022 – Bob Smith works 40% on Project 1 and 60% on Project 2 for July 2022 – Jane Doe works 90% on Project 1 and 10% on Project 3 for August 2022 etc An employee can be assigned to multiple projects, and a project can have have multiple employees working on it. Tables I’m currently looking at: Team - contains data on team members Projects - contains data on projects occurring throughout the year(s), can be overlapping Allocations - contains data which details level of effort for a team member for a project for a month I’ve seen a couple questions like this in the community but none have been answered,

Hi everybody! I’m new in Airtable and I really enjoy this tool. I watched some tutorials and read about Airtables functions. I tried things out, and what should I say, it works very well! Now I try to organize my company’s tasks but I don’t get a quite clear idea on how to do it. My problem is the amount of different tasks and things I need to add. I guess it is not very complicated for you guys, therefore I would appreciate some ideas and insights on how to structure my Airtable. I’ll try to explain as clear as possible all the tasks and needs I have. We are a content and marketing agency. That means we have two teams - marketing and content with different projects. What I have already: I have a clients table I have a service table I have a team table with the different team members and their skills and availability The problem comes with the table of the projects: Let’s talk about the content part. We cre

Hello, We are trying to get our inventory to calculate right. I’m new to airtable and can’t seem to figure out what I need to do to get it to work out for me. I have several items that will be used by a couple different customers daily and we want to make sure we know in real time how much stock we have. I have attached my page and highlighted the Items. This is just a few of the similar items we have. thank you for your help

I’m trying to use a single Base to store all my business workflow information. I have the following tables: Employees Clients Jobs I now want to track timesheets which link to these three tables. That is, I want my employees to enter timesheet information into a new Timesheets table where: They select their name from a linked field tied to Employees table They select the relevant client from a linked field tied to the Clients table They select the relevant job from a linked field tied to the Jobs table My issue is that I have 25 employees who are each recording 12+ timesheet entries per day (they work on many jobs for many clients each day). As a result, I quickly approach the record limit for the Pro plan due to the size of the timesheet ledger. I’m puzzled by how to proceed here. Can anyone think of a way to set this up where I don’t run into record limits for at least a few

Hi, I’ve started to build an Airtable base in order to create a matrix that would allow our content team to know exactly what Content (eg. Article, blog post, social media post, …) to create depending on an Event (a new feature is available, there was an issue with the app, …). The relation between Events and Content is not 1 to 1. Therefore we’ve identified a set of 4 criteria (Frequency, target, channel, location) to help us associate each Event to the appropriate Content(s). Here is what I have so far on Airtable Table 1: list of Events associated to the 4 criteria (see screenshot below) Table 2: list of Contents associated to the 4 criterias (see screenshot below) Table 3: list of value associated to criteria target (see screenshot below) Table 4: list of value associated to criteria frequency Table 5: list of

Hi everyone, This has been making my brain ache today. Having an issue with trying to link records conditionally with Webflow and Zapier integrated. If anyone has advice it’d be much appreciated. We have a membership website built in Webflow where members can sign up for classes via a form on each class’s CMS page. Each class is created in Airtable in our “Classes” table and published to our site via Zapier. The member enters their name and email through the form, which is then passed through Zapier and on to a “Class Registrants” table in Airtable. Each form has an html embed that pulls the Class Title from the CMS as a hidden field and passes it to Zapier and Airtable. This Class Title is automatically entered into a Linked Record field in the “Registrants” table that is connected to the “Classes” table, so the class title pulled from the form matches the class title in the “Classes” table and all the relevant information for the class is gathered as lookup fields to

Hello I think there is a bug with how duplicating records works: I have a two tables linked together as many:1 - let’s say an “staff” table and a “role” record - where each staff member can only have one role, but the role can have many staff members assigned I duplicate a role record At this point I would expect the new role record to have no staff assigned as by having staff assigned it would break the rule of the staff record only having a single role Instead what I find is that any staff members assigned to the original role now have two roles assigned - this should not be possible as “allow linking to multiple records” is turned off. I can see why Airtable does it but it is bad and should not happen.

Hi Yall! I have a potentially confusing one… We have a team of people who are continuously onboarding and training on new items/products etc… Today, we utilize a checklist that is effectively in a document, and our teams have to copy their own instance of the checklist, and then work from that. The first problem is: things change. Things like, links to resources & documentation, training modules, etc… are always changing, and when these change in the, let’s call it Source Checklist, these changes are NOT propagated to everyone else’s individual checklist. The second problem is: new items/tasks are added. Every day we think of new things and improvements to help our teams learn, but much like our first problem, when we add new items to the Source Checklist, these of course are NOT reflected in the trainee’s individual checklist. Effectively, what I’m looking to do is utilize Air Table to create a scalable checkl

I have an AirTable setup where I want to be able to assign particular team members a task. I can create a field type where the field type is “User”. I want multiple assignees :white_check_mark: Easy :zap: ! I also have vendors that I want to assign things too, but they won’t have access to the AirTable, it’s just so I know where things are at and I can track clients/vendors/partners. I want to keep things really uncomplicated. Is the best method to create fake users for these null accounts? Otherwise, I’m creating another field for clients/vendors/partners with dropdown options. Ideally everything lives in the same field. Clients/vendors/partners will never have access (by design). Any ideas on how to do this better than this?

Hi There, I am fairly new to Airtable and have adopted a base from someone that i am now trying to set up more efficiently. There is a large list of items in 1 table (400 entries). In the other table i want the user to select one of these items so i have set the field type to “link to another record” which then references the particular column with the 400 codes. i only want one record to be chosen / selected per entry i dont want the user to be able to choose an item which is not on the list and create a new record any assistance would be greatly appreciated. Cheers!

Hi, all! Is there any way to open a specific record in a table by clicking on the value in a single select field? Or is there a way to create a button with the functionality “if {single select field} says “value” open {specific record in another table}?”

Hi there, I have a base with the following tables Issue Log (All incoming issues raised) Issue type (All issues and how many times the can occur before an action is taken) Users (All the users linked to a specific issue) I am trying to do the following. a) User fills out the form logging a specific type of issue for a specific user. b) I am looking at the number of times the specific type of issue can be logged before an action needs to be taken. Where I am having trouble is the following I want to know for that user how many times the specific issue has been linked to them to determine wether to take an action. Ideally I’d like to do thing using something like a COUNTIFS based on the user and the number of times the specific issue being logged has occurred for that user. The two fields I want to conduct the rollup for

Built my base a little wrong I think but I just need this to last a couple months until a permanent solution comes in. In the screen shot I have a few rows that include different quantities of the same part number. I would like to be able to combine the same parts that are separated into a single row for a summary. They are separated like this because we have separate “batches” going out for powder coating. I presume this will be in rollups but I haven’t figured it out yet. I’m trying to spend very little time on building anymore into this as we have a permanent solution being made but it’s a month out yet. I started to play with interfaces but didn’t see an immediate solution there. This summary is to give counts and weights for shipping the products. These ship to powder coated and then come back to us for post process work.

Hi everyone, can you tell me how to convert a checkbox column into numbers? where the cells with the check become 1 and the cells without the check become 0. I tried to do it but it puts all the empty column back, while on the contrary from numbers to checkbox it seems to work

Hi - I’m trying to track spending for various entities by date, to allow the creation of a chart of spending by month. Our database has a list of Advertisers. And each of those Advertisers is linked to many Advertisements. Each Advertisement has already been assigned a dollar value and each record also has a date. How would I create a chart for each advertiser for what they’ve spent in a given date range — ideally by month and/or quarter? I’ve been able to create a cumulative sum of ad spending per Advertiser, but I’m stumped on breaking it down by month. Any help much appreciated! Thanks!

Feel like I’m missing something obvious…Trying to link records and for some reason my linked field is showing unnamed record…

Ho iniziato ad usare Airtable in italiano e senza problemi. Per molto tempo ha funzionato bene. Da pochi giorni ho il problema che quando scrivo mi sostituisce le parole in automatico. Ad es. voglio scrivere “A” e mi esce “UN”. È forse un problema di impostazioni della lingua? Non trovo la sezione impostazioni…

Not sure if this will be possible but figured this is the group to ask. I’m attempting to automate delinquent account reminders for a dental lab. The auto email reminders will ideally have generic friendly text reminding offices of their past due balances along with our credit card authorization form and the invoice in question.

Hey everyone, I’m new to Airtable. I’m looking to create a form for an event. Each customer at the event will be given a unique card ID number. We’d like them to enter in their details (including the ID number) into a form. How do I create a form whereby if someone enters in ID number 0001, no one else can enter in 0001?

Hello all, I am a new user and working on a project to help people find what trees are native to their location. I am building a database to match plants to zipcodes, which are also mapped to growing zones, etc. My question is about working smartly with my zipcode base, which is over the 50,000 record limit for the plan I am on. I realize that I do not need all of these records, but really just the ones that relate to users on my app. Is there a good way for me to create a “just what I need” base on-the-fly as users add their location information? Other smart ideas are very very welcome. The answer can’t simply be to have an enormous database of zipcodes when it turns out I may only need 5 today, and 500 by the end of the year, can it? Again, many thanks for your help. Respectfully, Chris Robinson

Hi! I am totally stuck here, so maybe I can ask you guys where I went wrong. I have the following situation as in this demo base: Airtable

Hey AT peeps! So the image shown is the multi select our attendees are going to select one or many. These represent real data in another “Training Calendar” base and table: So the question is, how can I, possibly an automation, “attach” the actual event from this second pic/table, based on their entry/selection? since the field is a multi select, I’d need to be able to have multiple “events” attached. Ideas?