Base Design

I am a manufacturer, and use Airtable in several areas of my business. I have a pro account. I am looking for a way to automate documented employee safety reminders between safety meetings. Initially I planned to have a form with the reminder listed in the form description section. I was informed that some of our employees have learning disabilities, and will require assistance reading the information. Is there a way to have video play after the description of the form? Thank you in advance for your assistance.

I come from MS Access, so I realize I’m in uncharted territory here. I have several instances where I want to create a table that serves as a list for dropdowns to use across multiple other tables, and I’m not sure how to do that without it being really messy. For example, I want to make a list of departments as a table, rather than having a “single select” field type, so that if I add departments or change the name of departments, it will update across all tables that need to reference a department, rather than needing to update a dropdown field in every table that uses Department, every time there is a change in department names or structure. I have one table for order requests - every request needs a department. I have another table for personnel - every person is assigned to a department, etc. I’m finding that if I create a linked record, I’m getting a field added to department that may have thousands of linked records. Every department certainly makes thousands of

I’m trying to build a comprehensive marketing ‘universe’ for a company i’m contracting for. I’ve designed a pretty slick content calendar system, but i am really need a way to interface with other stakeholders without giving them full access to airtable. (think PMs, Creative team for creative review etc.) I want to use portals but is cost prohibitive for me right now. Anyone have any work arounds? where I just want to show them a view without inviting them to the whole base as a contributor?

I will not go into full detail because it is exhausting, but I have run into a situation where data written into my base occasionally has a trailing space character, which caused confusion and havoc between airtable and softr over the past 4+ weeks.The extra [space] character is really just typo. But to the naked eye, it cannot even be seen. How can I prevent any trailing [space] characters being written in the future?? Is there a native trim function?

Dear community,I am currently using several Teams licenses within my organization, and we are considering transitioning to Business licenses to take advantage of the additional features they offer.One of my main concerns is related to workspace management. I understand that Business licenses allow the use of multiple workspaces. If I decide to migrate certain bases from our current workspace (under Teams licenses) to a new one under Business, will I lose the existing connections those bases have with other parts of our system?Additionally, I would appreciate clarification on the following points:Will the URLs of the interfaces linked to those bases change after migration? Will the URLs of the forms also change? Will the BaseID remain the same even if the base is moved to a different workspace?These are critical questions for us, as any disruption could affect the functionality of our system and potentially require us to

When you have multiple independent instances of the same database schema (Base) along with their corresponding user interfaces (UIs) and separate data records, you might be looking for efficient methods to implement changes to the database schema or UI across all these instances. What strategies or solutions are available for applying updates or modifications to the database schema or the UI consistently and effectively to all instances?To provide some illustrative context. I would like to add a Field 3 to the Master-BASE and rollout this change to all instances.MASTER-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)MASTER-UIView 1 Instance1-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)

Hello Community,I’m fairly new to Airtable and relational databases at that, but would like to create an application that helps me distribute allocations to my top accounts for my wine import and distribution business. We receive certain highly sought after wines in small quantity and need to distribute them to top accounts. Most of the time, accounts take the full allocation, but other times they just accept a portion of the offer or none at all. My post here is looking for guidance from experienced designers on the overall base structure and how I should develop and connect things. Here are my thoughts so farTables w/ - wines available / pricing, distribution of wines by account, total quantity of wines still available Table w/ - List of accounts with email information Interface showing each account their allocation **or Automation sending out an email with each account's allocation Maybe there is some way for

I’m setting up a base that is hopefully going to help me organize my finances with my boyfriend. We have a joint bank account, and I need to be able to show how much money is going in and going out. It seems like he is not leaving enough money to pay for his bills. So, I’m wondering if I can calculate who owes what in the account. Like … I import the CSV of the bank account, then create a table for people (which would be just two), then add up the balances of all the expenses that are the responsibility of that person … What about stuff that is both our responsibility … would I create another person and then divide that into two … I’m so confused. :crazy_face: :frowning_with_open_mouth:

So I have a few tables I am trying to figure out the best way to join them in order to create an interface that will display data from multiple tables. For example. I have a table Fund (which has contact information), a table budget (which has budget information for each of the funds.  There is a line item in budget that has each years fund budget. The common thread is there is a dept number for the fund in the fund table and a corresponding dept number in the budgets table.  I am trying to figure out the best way to report on each fund and their budget.  Particularly, their current budget (there is a field in the budget for each budget year), so in a nutshell, I want to see all the information from the fund table and the corresponding current budget for that fund from the budgets table.Its so simple to do this in excel or access but I cannot figure out how to link two tables to display the information in airtable.Any helps is appreciated. 

Hi Dear community Got a challenge when creating recipe management calculator When I need to create a new recipe or sub recipe I have to create the name and go to search for the new recipe and starr filling all the information as the field quantity  of the ingredients is not in the same table Please can somebody help me step by step instructions to solve this issue Tarik Kind regards  

Dear Airtable Community,I would like to know how to transfer a base in my personal Airtable account to a base in another account i.e. a start up’s account.They haven't yet set up the company account in Airtable but will do once we know how this can be achieved smoothly. Also to be considered are that the base in my personal Airtable Account,  has automations native to Airtable, connection to Fillout and automations in Make that are triggered by a Webhook via a script in my Airtable automations. Is there a way to move this ‘lock stock and barrel’, out of my account and into that of the start up?Thank you in advance for your support.Best RegardsLadi 

I have a schema, which I would like to implement for 3 similar businesses.  Is it possible to have the same base template, and have the schema synchronised between ALL 3 bases?  That is, if for example I add a new table, it is also added on the other bases. Same for fields.I would like to segregate the data, and also they do not need to share the data, hence it doesnt make sense to hit the 125k record for Business for example when they are not related data, just related schema. 

Hello there, Does anyone know how to export from base schema? I want a snapshot image thats clear to show elsewhere.  

Hi !Our company is working with Airtable for almost a year now, and I believe it can provide everything we need from a CRM / Dashboarding tool. But as our company grows, our Airtable base also is…  and we’re at the point of needing to evaluate the database structure because I believe it will become a bit of a mess when we grow and continue this way...  So I would like to reorganize the database and also build a lot of interfaces on top of that, so I don’t want to break up the database structure afterwards… 😉 So before changing it all, I’m looking for some advise and best practices on how to design a structured Airtable base which can grow and develop along with our company. More specific: right now I’m looking for some guidelines to when to separate or combine a grid to keep data in a structured way and maintaining flexible as our organization grows and our processes and needs change along. I appreciate some general guid

I do not get Function Field as a choice in customize field selection- I get Number, Date, etc. Thanks.

Hello Airtable Community!I’m designing a system to collect structured KPI data (10 standardized metrics) from independent businesses. Phase 1 (Pilot): 16 businesses entering data via Airtable forms Phase 2: Expand to 60 businesses Phase 3 (Scale): 600+ businesses Goal: Aggregate all submissions into a single dataset for analysis and benchmarking.My core questions: Can Airtable handle this scale of data collection and access control? If so, what architecture would you recommend? One base where businesses submit via forms, with Interfaces restricting visibility to only their data? Or multiple bases that sync into a central analytics base? Thanks in advance for your insights!— Walker

I have 3 tables:Table 1: Work productivity data from our delivery management system. This has the employee’s email and date of shift.Table 2: Employee Data from our HR system. This has the employee’s email address and employee ID.Table 3: Shift data from our clock in/clock out system. This includes the employee ID, hours worked, and date of shift. There is a way to link all three as they share sufficient fields. I would like to match the productivity data for a specific employee on a specific date to the hours work within Table 1. So I have hours worked in there.For example, I’d like in Table 1:Bryan - bryan@hotmac.com - employee ID: 113495 - 34 tasks - 4.73 hours worked. I can link each table, but I’m stuck on how to match the shifts on the correct date between Table 1 and Table 3. Any help is really welcomed. Thank you.

So, we have calendars imbedded in our website and have color-coded different activities to make it easier for the parents to look for certain things.  This is the grid view.And this is the embedded calendar.  But the colors aren’t translating.  Everything on the calendar is the same color unless you open the activity up. 

Currently in airtable we have each project as a line item, and we have multiple columns that note milestone dates:Brief Start DateKick-off DateIn Market DateOut of Market DateIs there a way to create a gantt view (either in the base or in an interface) where each project bar is segments to show the different working phases of the project using the milestone dates above to create the segments?

I created a database but not the way it is suppose to be, so now I created one with the same fields but it is relational now as i did not know how to build one. So, now I need to move all the data into the new one. Can someone tell me how, i saw something about syncing but I cant find a way to do it. thanksRose

Hello,Our team has built out a form for users to sign up for training from a few categories. We do this by using separate fields with different rules to pull data by the training’s specific name. All of the trainings feed in from a Google Calendar, and the form feeds in from a grid of those calendar events.The form works great when used normally! However, we had a user experience frustration when these fields would not allow them to select multiple trainings. We discovered that in incognito mode (only tried in Chrome so far), users could select 1 training per category, but when selecting multiple would recieve a “Cannot see this data” error.Interestingly, users can select the same named training (differing dates) with no issue. As soon as they choose a training with a separtate name, they recieve the same error.

Hi all ​@Mike_AutomaticN ​@ScottWorld ​@TheTimeSavingCoI am looking for advise when to use self linking vs a seperate table.I currently have a one-one relationship with buyer enquiries and seller quotes. However we now want to send the enquiries out to our selected suppliers to provide quotes to us before we approve them which sends the quote to customer with our markup. I was setting up the supplier quotes line items table but now with self linking tables is it best to just self link the line items table? Heres my desired setup for Multiple Supplier Quotes per Customer Enquiry. Customer Enquiry Customer submits one enquiry (master order table linked to line items). Each line item = required product + quantity. Supplier Quotes (Mu

Hello, setting up airtable for the first time.  We are a nonprofit looking to track our funds that support our grants.Currently we are using multiple worksheets in excel.I am trying to figure out where to start. I have imported the Fund names and Contact information(Funds).  The next tabs we have are for our investment returns and fees which contains our fund name, contributions, admin fees, investment returns, disbursement amounts and ending balance. We have a worksheet for each year.The common link is the fund name in Funds.  Should I create a table for each year and link it to the funds table by the fund name?  What would be the best way to view the Funds table and see the budget information for each year.Hoping this makes sense, any helps is appreciated.   

I am using the new form builder and want to filter the values of a dropdown field, Product, based on the value of another field, Designer, on the same form.Although I found the "filter records by a condition" option, I cannot see a way to use the Designer field's value as the condition for the filter. Any help appreciated.

Hello. I’m getting started on a database that should hold an asset registry for properties. I need some help if someone can help me navigate through this. I can start by telling you what database I need, how I want the equipment listed out and ways to automate fields. Please let me know, serious inquires only.