Base Design

Good Day I am setting up a customer base, Included in the fields is vehicle Information. The Car registration number, Make, Modle, Colour, 1st Contact, 1st Contact Phone, 1st Contact email, 2nd Contact, 2nd Contact Phone and 2nd contact email are all the fields that are for the registered person. The problem I am facing is that a person with more than one car has to register its registration number, make , Modle and colour. However the 1st and 2nd contact details remain the same. Is there a way of doing all of this in the fields without having to add the extra Information already entered

Hello, I am trying to create a table of the hardware and materials we use. What is the best practice to manage varying levels of stepped data. Fasteners > Hex head screws > 8.8 > Partially Threaded > M12x60 Sections > Mild Steel Angle > 30x30x5 All in a single table? Multiple stepped tables? Any advice would be great.

I’m sure there is a simple solution, but I’m kind of stuck thinking through it. We have a membership organization that hosts 3 to 4 workshops each year. Each of these workshops are made up of a team that runs the whole workshop. Each of those members during the workshop has a 3 important pieces of information: The workshop they are working, the role they are serving at the workshop, and if they present at the workshop the presentation they provided. As you can imagine, a member can serve at multiple workshops throughout their years of membership in the organization but will have different roles and different presentations. I want to be able to track at the Member’s record, the workshops they have served, the roles they served at that workshop, and the presentation they provided if they did at that workshop. I’ve played around and have found multiple ways to do it in theory; but I’m concerned that I’m creating a bunch of data links and access data that is not really needed. Any simp

I’d like to have a single select field trigger a date field and am asking the community for help with the formula. My goal is to have a single select field with the following options: now - this month, next month, future, next, etc. My goal is to have a date auto-populate based on the dropdown selection that dates the item at the end of the next month. For instance, if today were January 5, 2050 and I have an item marked as “Now - this month”, I want a date field to auto-populate with January 31, 2050. If I changed the single select to “Next Month”, the date field would automatically update to read February 28, 2050. Does anyone know how I do this? Thank you!

I have a spreadsheet where a track the Broadway & touring shows I’ve seen and the casts I’ve seen in each. I took a long time to create this over on Google Sheets and like the way it works over there, but I think I could make it even more efficient here. I’m especially having a hard time trying to figure out how to create a section for Venue that cross references the other tabs. I feel like I’m trying to make it too complicated since I’m so used to using formulas to cross reference tabs in Google Sheets. Thoughts on the best way to create this? Google Sheets

This might not work, but thought I would ask just in case: I have a base that has all of my clients & projects broken down in and then I have another base that I have all of my promotion broken down in. In my promotion base I want to come up with an ROI that updates automatically. So I was wondering if there is a way to somehow relate the table that have my promotional information in and a table that has my client information in so I can link the ad campaign that got me that client and in turn have the money I make overtime with that client show next to the campaign it’s linked to so I can create a formula field to show an ROI that updates on its own next that specific campaign.

I’m building a marketing base that has 2 different tables: 1. Prospects. These users just signed up and left their email and name, only interested in joining a newsletter and receiving comms from our company. Through emails sent to the prospects, we invite them to fill out a form to fully subscribe to our services by leaving a bunch of data about them. This is when a prospect turns into a Lead. This table would have these fields: email name agreed to join? (checkbox) → when checked, a lead is created. 2. Leads. Prospects that agreed to leave all their data. This table would look like this: email name data point 1 data point 2 data point n Not all prospects turn into leads. Some never agree to join, so I guess it’s ok to keep them as separate tables. My question is, wouldn’t it be a mistake to have 2 tables under the same base, where the main field of each record is the email? Thanks! Gas

Hi, I am designing a content management application that will manage content across a series of platforms. Each platform needs to have its own publication dates (varying from daily, to weekly, monthly and bi-monthly). When users add stories to the platform, I want them to select from the appropriate dates available for that platform (not just the usual calendar). Is there a way to populate a drop-down with these values, say if they were created in a linked table?

Hi Airtable community, We have a business that runs multiple programs and we use Airtable forms for signups. One person can sign up to multiple programs. I have created 2 key tables: Raw forms table: Where all the raw data from the forms is entered. This can have multiple forms per person. CRM: One row per person. Each form from the forms table is linked to a single person. Example that explains the issue: Let’s say in a form people need to enter their ‘Bio’. In the CRM table if I do a basic lookup of bio for a particular person’s forms I will get multiple values if they have filled out multiple forms. I would like a way to just lookup their most recent ‘Bio’ entry. This can be done. However, what if in that person’s most recent form (we have all sorts of forms, not just signup forms) they did not enter a bio and the bio field is blank? So I need a way to return the most recent non-blank entry. I have created a Loom video to demonstrate the issue. Any help would be awesome!

Hey everyone, quick question: I use a table to organize my various types of tasks and I have the records groups by the single select the shows what task type they belong to. It gets annoying getting to the bottom of the list of tasks for a specific task type and the group going away and having to re-add a record and update the single select to open that group again instead of hitting the plus at the bottom of the group to add a new record to the group. Is there any sort of like automation that can detect that a group is out of records and to add in a new one to just keep the group open? If not is there any sort of solution that you guys happen to know for this besides the kanban view? Thank you for any help!

I would like to create a scoring system for climbing competitions using airbase. I’m having a lot of issues with this in general. And I’m sure that I’m not doing it efficiently. Essentially, I want to create a scoring system that can be inputted by multiple judges using one source of competitior names. But the judges won’t be able to put all of the scores of one competitor in at once. One judge will put one score in. And the next judge will put another score in. So I need the ability to update their records. Let’s say there will be 4 climbs. I would like one judge at each of the 4 climbs. The judge will choose the climbers name from a dropdown box and enter the scores (ie, top, zone, attempts to top, attempts to zone) on an airtable form. The judge on the next climb will also have the same form but will score for the next climb. 1.I created 1 table (named Summary) with all of the climbers and columns for the scores of each of the climbs. 2.I created another table (named Update

I have 2 seperate tables in my base, 1 shows job descriptions, drawings, opperatives etc. the 2nd is the finances for that job. Currently i have to type the primary field in both tables (same name), is there a way that if i type the primary field in one it autimatically fills the other tables primary field? According to the help it isnt currently possible to do it that straight forward, does anyone know a work around i could potentially use? Thank you

This is new to me. How to remix the Airtable URL Preview app(block) to show amazon.com URLs? What this app actually do?

I am using a lookup field to pull in values from a single-select field on the linked record and I’m having trouble filtering on the lookup field since it’s displaying the data as plain text. I’m trying to filter to records that contain either of 2 potential values from the original single-select field. If the lookup field were single select, I’d be using a “IS ANY OF” filter, but since it doesn’t come into the view that way the only options I have are “IS” or “CONTAINS”. I can’t use an “or” in my filter set because I need to be able to use other filters also. Any suggestions for workarounds on this? Is there a way to convert the lookup to a field I can actually filter on?

I have linked field which connects two tables. On clicking “+” symbol, I can select records from connected table. There is also option to search “Find an existing record” records to add records. I can only search with primary field value of that table while unable to find anything using any other field vale. It gives empty value. I want to search records using another field value of that table not only primary field value. here is the pic of search option

How can I “Remove” or “Hide” uncategorized column in Kanban View. Can it be merged to another column in Kanban View to solve this problem. Here is the Pic for reference

I am creating an ordering system to help distribute items between multiple stores. I would like to have the option to attach quantities to individual items in the same order. Here is my order form as it stands. You can add multiple items to the record no problem but the way to attach the quantities to the items is not sustainable. Ideally, I want to be able to attach those quantities to the items themselves. Is this possible? Thanks for any and all help.

This is my first post in the community forum, so I hope I chose the right category. I am wondering if I can create a column that shows records that occur in both of two other lookup columns. I’ll describe my use case, and in addition to my specific question, I welcome any feedback on the overall design. I’m very new to all of this. I have a directory of therapists that our business refers clients to, among other attributes we list their specialties and the locations where they practice. Each of these are many to many relationships, where a therapist may have 1-3 specialties and may practice in 1 to many locations. I have two link to records on the therapist table, one for locations and one for specialties. We are creating unique landing pages for each combination of specialties and locations (e.g. Addiction therapists in Phoenix, Addiction therapists in Tucson, Trauma therapists in Phoenix, etc.) Each landing page corresponds to a single location + specialty. So far, I have four tables

Hi! I’ve run into a problem and I can’t find the solution on my own so I really hope someone can help me. I need the ingredients to be in the descending order based on the % they are used in an ingredient list. As you can see I have the ingredients sorted correctly but in the Label of ingredients the information is mixed. is there a way to fix this?

Hello community again :slightly_smiling_face: i just want to ask for suggestion whats the best way to do this: table 1 = products some products are made from other products == spare parts, which can be sold separately. So they are in same table. what i want: if i get product made from spareparts into inventory= show me, that this is made from those spare parts… (because when i send it to customer, i need to know it is made from those parts == dont forget to send other package with this one too. I dont know whats the best solution to do this ? ideas on my mind: create field “from parts” =yes/no and then other one which is linked to those parts numbers… so i can sort them into view when they are in order (so i will see those x are made from y, beware) but… i want to use it in the other way - when i get some parts into stock, i want to know “you should look for those other packages too” i know, this lookslike stupid, but the manufacturer is sometime strange… so i have xxxx on invoice (p

I have multiple users running different test cases and entering test results (pass, fail, incomplete) in a spreadsheet. There are several test categories and numerous test cases under each one. I need to capture pass/fail/incomplete at the test case level. I would also like to capture the user/company conducting the test as well as which device they are testing. Multiple user/companies can test the same device. I would like to capture all of this information into airtable database to aggregate the results and enable consolidated reporting. I would also like to setup notification triggers (email or chat) when a test is completed and data is entered. Is this Possible in Airtable and if yes Please help me.

Hi, I am designing a form that needs to have multiple items listed by the person completing that form. Currently it is set as a long text box but was wondering if this could be set up as a text box with 10 rows 3 columns for example?

Hi there, I am brand-spanking new to Airtable, so break it down for me. I make and sell first aid kits and am looking for help setting up my inventory so that when I sell a kit, the multiple individual items sold in that kit also decrease. Is that possible? I already have my SKUs linked to the individual items it includes, but not the quantity per item. Thanks so much for the help! Megan

I’ve seen some posts similar to this, but I’m not quite sure I follow them with the data I have here. I just need Number of clients trained that week, in this case four. Names of said client’s that trained, as you can see some companies train more than once a week Any pointers? Thanks Sean

Hi, I encountered a problem while filling a table. In my main field I’m trying to reference a date field of my table who is a lookup to a date field in another table. When I try to do this, I have an error stipulating a circular reference. When I try the formula in another column of the table (not the main field) it works fine. Are there limitations on the main fields of a table? Thanks in advance,