Base Design

Hi!  I am building a project management tool, and I have difficulty understanding how I can use my Project and Tasks table combined in a way I can get a gantt view of each project, with the tasks and subtasks nested.  When I create a gantt view in the projects table, it shows the projects, not the tasks and subtasks.In my mind, it would be something like opening a task table from each project line, but the system don't work like this.Thanks for anyone that can help. 

Hi, I need an attendance tracker for a nonprofit organization that organizes different activities throughout the year. I first tried doing a form that our coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried doing an interface and it still won't give me the option to add new records in both form or interface. I do have a plus plan (not the free version).Our objective is to be able to have a beneficiary registry or a complete list of beneficiaries to report to our donors every year. We

Hello,I am building a base for a restaurant's catering service. Right now, I have a table with the catering menu with items and prices per item. I have another table for the catering orders. I created a field that links to the catering menu to select the person's order. The issue I encountered was that I cannot select the same record more than once. So if an order includes 2 of more of the same item, I can only mark it once.I know linking to the same record multiple times is not possible. So I am trying to find alternative solutions. Thanks.  

My goal is to calculate the percent of hours per week spent on a type of task. I have managed to calculate the sum of hours spent on each type of task for all entries regardless of the week number, but I can't figure out how to calculate the sum per week.In the table where I calculate the sum of hours, I have three fields: Task, Time (from my Time Track Entries table), and Sum. The Time Track Entries table contains the week number for each timed entry.Any suggestions for how to calculate the sum per week?Thanks,Lene

Hi! Is there any way to enter a start and end date with "no class dates" where it would remove the dates from the calendar view? I would also want the class to reoccur every Monday (sort of like google where you can say you want it to repeat every Mon).For example: I have a class that runs from Monday Sept 11 until December. It reoccurs every Monday except for on 10/9 and 11/6. On the calendar view, I want it to list Chemistry class every Monday from 3:30-4:30pm and want it to remove these two dates from a class date.Thanks!

Alright, let me see if I can spell this out correctly.I have two databases, one of faculty and one of courses.Faculty can be assigned to any and all courses. Courses have different contracts depending on how they're paid -- FT, Adjunct, and NCI, which are three fields in the courses record, populated with the payment amount as appropriate.Let's say instructor A is linked to three different courses, one of each of the above.Currently, my linked column for Faculty A will show all three courses, then there's a Lookup referencing Adjunct, which shows me the correct amount -- but I don't know which of the three courses under the linked column that payment amount belongs to.Is there a way to filter the linked column to only display on the faculty record if the adjunct field is populated? My current work around is to duplicate the table, delete anything where adjunct is empty, and create another link, but that's clumsy when I add more courses or assign more courses at the top level.I hope tha

Here's the situation. I need a base with 4 tables. Each table has inventory for 4 different types of products. Data for each record includes descriptors including single and multi-selects, text and most importantly the # available. The inventory manager would add this data. So far, pretty easy. Next, want to create a form so requestors can order from this inventory. Requestors would need to see the inventory available by type. As requestors fill out the form to place their order, we need to see the inventory amount change in real-time such that if user #one depletes the stock, user #2 will see a notice similar to "currently out of stock, will be ordered."  It would be nice if the inventory manager would be notified that a product would need to be ordered. There would also be the need on the form to order a product that is currently not in inventory. Not sure if the existing data sets would be used or just an open text box.Can Airtable do this?

 ERROR : {"error": {"type": "INVALID_REQUEST_MISSING_FIELDS","message": "Could not find field \\"fields\\" in the request body"},I am attempting to insert data into a simple table : 4 cols called A,B,C,D datatype of cols is the same single string.I compose my JSON body raw as follows : When I execute this via Postman I get the following error : If I execute the CURL command the insert works fine. This is the CURL statement : curl -X POST https://api.airtable.com/v0/apppXXXXXXXXl5tP/nXXXable -H "Authorization: Bearer patBTXXXXXXe71" -H "Content-Type: application/json" --data '{"fields": {"A": "AA","B": "AA","C": "AA","D": "AA"}}'I have been working on this thing for 5hrs solid and cannot figure out where the issue is in regard to the JSON request body format. I am new to Airtable. Any help would be greatly appreciated as I am at a dead end.BestPerry   

I am working on an AirTable base for my warehouse that receives Vehicle Tires. Our Receiving staff runs AirTable on their iOS devices; Currently, they scan the Barcode of the Tires and it automatically goes to the respective article/item on the AirTable Base and then they add the 'Tires Received amount' to the existing Inventory. i.e. If the Existing Inventory was 1000 and a shipment of 50 Tires were received, they change the Inventory number 1000 to 1050 manually. I would like to observe the possibilities of creating a column where the user can input a number every time a consignment of tires are received and that number automatically gets added to the existing Inventory and gets updated on its own.Table in the Base is as follows:-Column A has the Tired Brand and the Model/Size;-Columns B has the Current Stock (Inventory);-Column C has the Supplier name;-Column D has the unique barcode number of each Tire type.Thanks for your time.

Hi Is it possible to show the day of the week along with the date in a field?

Helo there, we have an online Online Language School, we use airtable as our database system.I have Student, Teachers and LessonPlan tables. LessonPlan has Student and Teacher pairs.We pay them for each lesson they taught monthly.  I would like to create a table called TeacherPayments to see Teacher-MonthYear pairs as below.How can I create this table so that I can see "HowManyLessons" calculated automatically each month?  

Hello! Looking for some help organizing a dataset that isn't importing from an Excel file as intended. As you can see in the picture below, the primary fields are spaced out, separated by extra rows made for each "Regulation" data point. For example, all the "Regulation" data points from "FDA Guidance 2001i" to "OECD GLP No. 13iii" should be merged into one multiple select field for the BAV 1.0 record. Similar for BAV 2.0, "21 CFR 320.29" and "FDA Guidance 2001" should not be split into two rows, but merged into the same "Regulation" multiple select field.Looking for a way to automate or at least quickly go through this data set merging these extra records. Thank you!! 

Hi Thanks for taking a look at this. This seems a simple question but I can’t work out the best approach. I want to be able to choose the country where a company is located. More specifically I want a user to be able to choose from a list of companies in a TypeForm and then connect the form to an AT table. Adding 200 countries to a single select field in AT seems not the right way to do it but putting them in a separate table means Typeform will not be able to send the data to AT. [Why do I say this: (1) because I can find no way to copy and paste a list of options into a AT Single Select field (2) the AT-Typeform integration is very pernickety in relation to exact match of options] Thanks

Hello! I am trying to figure out a way to link 1 column of records to multiple tables. For example, I have a master list of students on one table and have additional tables of info that I would like to link to the master list so that when I add or delete a student on the master list, it adds or deletes that record on all of the other tables. Is there a way to do this?

Is it possibel to create automatic base for the user when the new user is added to the table containing user info. Can we create script or any other method which can help us to create automatically based with predefined tables for the new user. 

I am creating a new base by importing an excel sheet. When I select import from the wizard or from table tab carrot menu or from "add or import" button to the right of the table tab, there is no response...ie dialogue box...nothing happens. Thanks all!

Dear AirTable community,I have just been recommended and discovered the amazing Airtable tool. But I am struggling structuring my team individual and transversal To Dos.In my team, each team member has its individual AirTable base "To Do [name]" and each transversal project has its transversal AirTable base "Project [name]". The tasks in individual and transversal tables are structured with similar fields.Let's say I'm Céline : I have my individual base "To Do Céline", in which I have my individual tasks, which are not related to any transversal project and which therefore do not require to involve any other team member. I also have a Kanban view that enable me to visualize my individual tasks by status.I also have the transversal base "Project eCommerce" as I am involved in a few tasks within this transversal project.I would like to find a solution to include these transversal tasks into my Kanban view in my individual base "To Do Celine". Of course, I would need that any ta

I need assistance in setting up a workflow for a non-profit organization where we help people with food, clothing, rent, utilities etc. I'll do my best to explain my needs. I've watched every video I can find and read all kinds of articles, but I've yet to figure out how to make this work. I would appreciate any help....Thank you.I have a database with all of our clients, addresses, emails, and other demographics.I need a database that will help with all the services we provide for our clients.I need this database to update as new records occur.I also need this database to be able to tell me if a client has reached their limit on available services.               Some of these services are only allowed every 6 months, some are allowed every two weeks, some are conditional situations. I need to be able to see what a client has received over the past 6 months. These records need to be able to update as the clients come

FolksI have created a database with several peoples details. On it, I have also created a view which will take a filter text like this:https://airtable.com/VIEWLINK?filter_FIELD=FIRSTNAME%20LASTNAMEand then send it to the specific FIRSTNAME/LASTNAME person, who does not have any airtable account as a normal shareable link, so they can access their data.The problem I am facing with is that as the controls of the view are available, the view can be filtered with different values and people can see each others details.I see that on the EMBED version of the view, I have the option "viewControls", but it does not work if I use it on a normal share view.Is there a way to prevent a view to be re-filtered? Or to prevent the controls to be available?Thanks in advanceAlfredo Rodrigues

We want our guests to ore-order menu choices by selecting one starter, main and desert from three choices in each category that have been picked from an extensive list of menu items.  I have a table with the menu items.  Another table has the meals with the date, venue and three offerings from the three categories.  Now, for each guest (all guests are in another table) I want to select a starter, main and desert from the three that are being offered by the venue.  From this information the venue will get a list of all guests and their menu choices and and each guest will receive  a confirmation of their selections.  So far I have the three choices in the meal table but can't figure out how to select one of each from the choices in each category for each guest.  I hope the attached diagram illustrates the issue.

Hello all, I have created an AirTable base used for tracking insurance documentation for a construction company. I have set up a date column of when the insurance document in question expires. I was wondering if is possible to set up an automation to send an email to a user that this document is expiring? The issue I run into is that all of the dates are different. I see in the automations you can select "when a record matches conditions" then when selecting a condition when 'insert my expiration column in first field". The next step is where I hit the issue because there is no way to select "date that is listed in the column". Hope this makes sense and there is a different way around it I am just not seeing it. Appreciate anyone who can lend their expertise and I can provide more information if needed. Thank you!😊

Take the example below, imagine you have:Category.ProductsProduct.CategoryA product is linked to multiple categories. When you first create the 'Category' field on Product, this creates the other side on Category, lets call it "Products".  If you delete the column "Products" from the Category, is it possible to re-link them later on?Also, if you do not think one will ever need the "many" side of the relationship - does it slow AirTable down if you keep that many-side Field as well? Or it does not make a difference? 

Hi!I'm creating PDFs with Google Docs and DocsAutomator. When I check the field "generate RMA" AirTable create PDF out of Google Doc and save this PDF to the desired attachent field. Of course the data is from AirTable. And this is easy.Then I came across one problem, which I think I handeled it okay. If I have two choices that I have to decide and check in a checkbox) I simply created formula field.So I had two choices "repair" or "servise modification". And I created checkbox field "repair" and "ervise modification". And then formula field for each of these field with IF() function. If the field if checked, it returns checked box, otherwise it returns empty checkbox. And then I connect these two (formula) fields to the PDF. And It worked.But then I came uppon bigger problem.. if I have many choices to check I don't want to create all these fields plus formula fields for all that fields, if you know what I mean. Is there any other way to do that? Maybe with a single- or multisele

Hi. I am using Pro plan, which allows syncing between bases.  I've been structuring a lot of parts of our business in one main base.  There is a significant amount of data which needs to be imported from CSVs, for which it is much easier to give direct access to the base to the users, rather than through interfaces, views, etc.  There will also be some sensitive data in the main base, which I do not want to give even view-access to these users.  If you give access to a Base, they automatically get access to all the tables read-only as a minimum. Because of this, I realised it would be better to have a Main Base, and also a base for the Raw Data/CSVs.  I would give any users who need to import bulk data to the Raw Data/CSVs base, and then sync tables from RawData to the MainBase.The issue is that I already have a lot of automations, fields, configuration, etc in Main Base. For example, I have a table called 'Bookings Data'. I would like to move this to Raw

Hey, can anybody think of a way to create a table that consists of a listing of all the records in several other tables in an index format. Something like this: Primary Field Value | Table Name Bob | First Names Goldthwait | Last Names Comedian | Occupations I want to produce a single table like the one above, dynamically and continuously from live data, from a base that contains the following tables: TABLE: First Names RECORDS: 1 Bob TABLE: Last Names RECORDS: 1 Goldthwait TABLE: Occupations RECORDS: 1 Comedian This is just hypothetical data. I know I could this by exporting to a spreadsheet and reimporting but I want it to be automated and real-time. Any ideas?