Base Design

For my small business, I have three levels of information I'm trying to manage. I have (a) the human client, (b) their pet, and (c) the services that they want for their pet. Each human can have multiple pets, and each pet can have multiple services. The projects themselves occur at the pet level, since one human might come back multiple times with different pets, and all the services for a pet occur at once. A pet will not come back for more services again in the future, so it makes sense that we could consider "pet" to be the main unit of analysis (sorry, I'm a social scientist by training, forgive my lingo). A big part of my work is thinking about how I complete tasks by what services I need to do in any given day; in other words, Spot might need Service A, Service B, and Service C done, and I care about knowing what services I've already done and what I still need to do for Spot. Although Service A is always "Service A" for every pet, the price for Service A changes depending on th

Hi everyone.I'm helping a teacher to manage student's lessons.Let me tell the need:There are lessons that students have to assimilate.Each student is in a group.Each group has courses.During this course, teachers note progress for in lesson for students (students are following different lessons in the same course).A teacher should be able de note easily the student's progress.It should be possible to check the global progress of each lessons for students.I don't know how to do it, I tried different architecture with no success.Please, could you help me?

Hi everyone, a coworker and I are designing a new AT system to help our communications team manage content production, marketing campaigns, and individual tasks related to both content and campaigns. To solve for multiple needs and use cases, we're thinking of creating a standalone base for each one of those buckets (content, campaigns, tasks) and using two-way syncing to make sure they're all talking to each other. The issue: When our team leaders create a new campaign in base 1, they also want to create new pieces of content (stored in base 2) and assign that content to team members as part of that new campaign. They want to be able to fill all that information out in the same place. Is it possible to design an interface form (or just a form in the data layer) in base 1 that could be used to fill out both campaign info housed in base 1 *and* content info housed in base 2? And if so, could someone show me how? Thanks in advance for any help!

Very new user here.I have a simple base with one table and one form.  It is designed to add new people to a mailing list.  I created a form to add new records, and that seems to work fine.  Now I need to create a navigation.  I would like to see a sidebar which includes 2 items, the table and the form.  Is it possible to have the table and the form in the same sidebar?  I don't really need to see the buttons at the top (data, automations, interfaces).How can I add the 2 items to the sidebar, then reliably cause it to appear?  While playing with this, I saw a sidebar, but once I left it, I can't figure out how to bring it back.  Can anyone help?  Thanks...

Hey all, new at the community. Been using Airtbable since many years and love it. Just have been pushing it further wiht scripts, automations, and integrations. Many springs ago (25) I used to be a developer and the database thinking runs still through my blood. So when I make an base with some use case in mind (probably not wherefore Airtable is intended for) I think of tables that have the flexibility of SQL. Imagine thisBase to keep scores me playing boardgames with friends (because we're nerds and we wnat to know who is the ultimate better player over the years etc.) ps. I actually do also serious things with Airtable but this is simple for people to imagine 😄Table: players (list of people)Table: board games (the actual game, eg. UNO)Table: games (a session until someone wins)Table: rounds (all the rounds played in a game until its over)Table: scores (per round, per player) which links to a round & player, and adds a scoreThen in an interface i want to se

Hey all, new at the community. Been using Airtbable since many years and love it. Just have been pushing it further wiht scripts, automations, and integrations. Many springs ago (25) I used to be a developer and the database thinking runs still through my blood. So when I make an base with some use case in mind (probably not wherefore Airtable is intended for) I think of tables that have the flexibility of SQL. Imagine thisBase to keep scores me playing boardgames with friends (because we're nerds and we wnat to know who is the ultimate better player over the years etc.) ps. I actually do also serious things with Airtable but this is simple for people to imagine 😄Table: players (list of people)Table: board games (the actual game, eg. UNO)Table: games (a session until someone wins)Table: rounds (all the rounds played in a game until its over)Table: scores (per round, per player) which links to a round & player, and adds a scoreThen in an interface i want to select

I have a screenshot above where the linked record displays Tags and Employee ONLY. I discovered that they normally pull the displayed fields from the primary view of the table. However, I already checked my Tasks table but I really cant find the view where this is being pulled from. It's not accurate at all. Can someone please help?

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my data is clean it is a standard 03/05/2023 7:00:00, 10/05/2023 7:00:00, 17/05/2023 7:00:00, etc As you can see, the three rows show up blank after I try to convert to Date (with time) field.This is the original data after importing from Excel sheet. Would appreciate any advise on how I could convert all data successfully. Thanks!  

Hi new here, hopefully this wasn't asked before. Please link me to it if it was.Let's say I am managing a fruit plantation. Each fruit needs to be planted and harvested.I have already a table like so, where the Fruit field is linked to another table (eg. Basic info about the fruit: colour, size, etc)FruitPlanting dateHarvesting dateApple1 Jan2 FebOrange15 Jan1 FebIs it possible to create a table (or a view?) that somehow links to the previous two tables? I saw some previous post on how to make a static table with automation, but I want the information to be dynamic if possible.FruitActionDateApplePlanting1 JanOrangePlanting15 JanOrangeHarvesting1 FebAppleHarvesting2 Feb(Ultimately, I like to see what I need to do each week. So I will be using formulas and Group to create a view for each week. I know how to do it from this newly envisioned table above, but I don't know how to get to it.) Thanks so much in advance!(edits: grammar)

Hi I am combining 2 fields (quantity and materials description) using the formula function (screenshot 1). I am then using the lookup field to display in one cell all the materials and quantities for one job in that one cell (screenshot 2). So far so good. I would like to be able to do a nice print out for the workshop staff but in order for it to look less cluttered, is there any way I could program it to display each (material & qty) to be displayed on a new line (new paragraph) within one cell? e.g. rather than 2 x 22mm MDF, 4 x 18 mm Birch plywood, 6 x inset hinges I would prefer it to look like this: 2 x 22mm MDF, 4 x 18 mm Birch plywood, 6 x inset hinges Any ideas gratefully received!

Is it possible when selecting "Link to another record" to be able to connect to multiple tables? I can only see the option to link to one table (multiple records, yes, but multiple tables, no)? Or any workarounds for this?I'm building out a content model and for some of the content types, the source content fields can come from multiple other locations, so I need to be able to reference this in my data model. Thanks!

Hi- are there any updates about this topic?We want to share only some tabs with different people. Thanks

I have two tables:A. MeetingsB. Representatives'Representative' on table A (Meetings) is a 'Link to another record' leading to the items on table B (Representatives).I have a need to filter the Representatives table so that it'll show stats for a given period only, for example - show only the stats for these periods:The closest I got was filtering each calculation field separately:  But this is not good enough as1. It needs to be applied to each calculation field manually2. The filter cannot be saved to a viewI have also tried filtering the linked record column by using the 'Limit record selection to a view' option, but this doesn't really limit the record selection as expected - a known issue.What can be done to achieve a periodical filter for the Representatives table?

I usually use linked record for choice option instead of single select, just in case of use with other tables. As my records keep growing, I am worried about the record limit.Does number of choice in single select also count as record limit per table?

Hi there! I'm trying to design a base with a public facing form for camp registrations. I was planning to use multiple select as the camp selections field, so folks can sign up for Camp A, Camp C, and Camp D all through one form. Where I'm running into issues is designing an automation that disables selections when they reach a total. For ex. only 12 people can register for Camp A, so when 12 form submissions come in with that selected, it needs to be removed from the list of options. In a different setup, I've used lookups, views, and table links to create this utility, but that was date/time based, so I could use it as the primary field. I can't use multiple select as a primary though, so I'm a bit stuck. 

i want to migrate my data which includes attachment from spreadsheet.com to airtable. Please help..!!!

Hello everyone. I have a link field with a one-to-many relationship. The linked records have over 100 fields. I need to customize the 3 visible fields in the preview Lightshot Screenshot Captured with Lightshot in order to make it usable. By customize, I mean that I want to be able to select which fields to display in the card preview Is this possible at all? If not, this would be a very important new product feature as otherwise, the power of linking records is very much diminished. Thanks for your help!

Hi, My team have being using the Airtable and the Kanban view for almost two years now. We have for a while lacked/cant set up a link between two tickets on the board. Just a simple link, so we don't forget an input or task.Is this possible? and how would i set this up?thanks! BestM 

I am creating a form for our website that I will need external users to fill out. I want to minimize user input error so I have created a table with state names/abbreviations to link to the form. When they start to fill out the state it populates options they can pick, but is there a way to make this look better by eliminaing showing where the data is going (it shows 'Leads' the table where it is going and I don't want customers to see that). Or is there a way to easily upload the state abbreviations that I have in the table without manually entering them all as a single select drop down option?Last question, I love the look of the interface form but from what I can tell this is not something you can share with outside airtable users via our website? Other than having them creative an airtable login, is this correct?

Hi Everyone, Thanks for your help in advance and ill try articulate this as best i can.Im trying to create a junction table from 2 tables.One being a table that contains "new leads" exported from a CRM. It contains a persons name, contact details  product and product reference, etcSecond table is a list of vendors/suppliers that have that particular product with product reference. The data is not entirely clean (structured) on the "new leads" table as the leads contain messages/text containing the reference number within it. First question: Is it possible to group and filter the new lead table with the vendor list in a way that would show the vendors that could supply to the following lead, using the product reference.Example:Lead Column: New Lead - Hi i am interested in "Item 123123-001" Vendor Column: Reference: 123123-001Would and could i need to use a formula to identify the reference within the lead? and then Could i link and group the lead with the vendors who

I have failed at several attempts to create a Standard Operating Procedure(SOP) in Airtable. I am looking to have Various Processes that an employee can choose from to create a series of tasks to complete based on that chosen SOP. I have searched in the templates and it doesn’t look like this has been done before. Any ideas how I could structure this? I would also like the ability to add and alter SOPs once they are created. I envision a main table with each employee and a list of the SOP’s they are in the process of and the tasks they need to do.

Hi there, we’re looking for an alternative solution to Jotform. We are wildlife rangers working in African National Parks. We use a Jotform to complete our ‘Daily Station Report’ which includes daily roll call and station statistics. We use ruggedised iPads, we open the form online, go offline to do roll call, and then go online to sync the form (I believe airtable can do same).Our challenge is the insanely convoluted and over complex back end. It takes an entire (frustrating) day every time we want to add a name to the roll call, because of the calculations which add up how many staff present, away, sick etc.We have 64 staff at this park in Zimbabwe, and the Staff Sgt has to read them out and tick the right box (present, away etc). So he can’t write in the name each day, or he’ll standing in front of the rangers for hours! We need a SIMPLE front end (see iCloud link to screenshot of current Jotform) to this, and the ability to EASILY make changes when need be. Also, the Jotform e

Hi all,We have a marketing calendar table which links a CAMPAIGN to individual DISCOUNT records in another table. Each CAMPAIGN has 4 or 5 DISCOUNTS in successive panels, and so we have 5 linked records from each CAMPAIGN to the DISCOUNT table, labeled Panel 1 - Panel 5. I would like to have ideally one field in the DISCOUNT table corresponding to the date of the associated CAMPAIGN, but I can't figure out how to aggregate the multiple PANEL fields into one single lookup. Is this possible?I've tried Concatenate & run into issues with datetime format, as well as issues concatenating empty records). I'm sure there's a way to set it up with IF functions that might work, but figured I'd see if there's an easier way!For context, I know this might not be the most technically "correct" way to set this up, but I'm trying to convince my team to get on board with Airtable by replicating the functionality of a Google Sheets calendar they were using and adding in some additional bells & wh

Hi. My nonprofit is using an Airtable base to support and manage data from youth teams that are conducting service-learning projects. I have a table called "Teams" that holds all the data about each team. Then I created a form through Fillout.com where they can create new records in a table called "Project Plans." The first thing they do when filling out the form is to select their Team name, i.e. a field in the Project Plan table that links back to the Teams table.The problem is that before I understood how linked records work (creates a field in the table where it's created, but also a corresponding one back on the table that it links to),  I would notice the new field in table it was linking to and thought- what the heck is this extra field here? And then deleted it.I now need to create lookup and rollup fields in the Teams table, but have broken the link by deleting the corresponding field there. The "Teams" field in the "Project Plan" table still shows the team name.Is t

Hi Folks,I was wondering if you know if we can use Airtable to create groups and allow collaborations between participants and allowing chats (something similar to idea of Facebook).  Thank you