Base Design

I'm working on a project wherein I'm trying to display the diversity characteristics of several universities (50+). I have an existing base with a list of all the universities I'm studying with various facets as fields across (location, size, focus, student life comments, admission criteria etc), but I also wanted to include information on the demographic makeup of each school. Ex: X University is 25% White, 15% Black, 10% Latino, and so on. What's the most efficient way to go about this so that this is also able to be displayed as pie chart via the Charts extension? I started by making an additional base, but as a beginner user I stumbled trying to find a usable format that allowed for readability and reporting. 

I have a list of schools and I'm trying to track demographics I have about the schools:raceincome levelsgendersI have reports with the aggregate data, not the individual student records. Therefore I'm not able to do rollups but tracking each demographic for an individual students in a linked table.What would be the best way to store the aggregate values, so that I can generate charts per school or across all schools? These categories have different amounts of choices too.

Hello! I'm having trouble allowing our AirTable users to add a new option to a single-select field. Also, any changes that happen to that field break an interface where that field is included both in a grid and also as a filter option. The field is only letting me add new options -- I am the one who created the field/changed up the format of how it was. Not sure why that's happening, please let me know if you have any ideas on how fix it. 

Hi! I'm working on a project for collating legal contracts and their details. The contract covers different territories, so I need a good way to represent territory data in an airtable column.Our contracts sometimes combine different countries into different groupings such as 'Latin America' or 'Caribbean Islands', etc. While I don't need to get too granular, I would like to at least divide the territories based on Continent for easy data entry. Ideally selecting a continent will select all the countries in that continent as well. What I want essentially looks something like the below screenshot, but I am not sure if this can be implemented on Airtable directly or not.I wonder if I could integrate airtable with some other software? or add some extension? or if there is some creative script or formula that could implement this?Any advice is apprec

Is there a way to identify how a field was created if it was not created by a person? There is a field that was created but can not identify how it was created. Not sure if a person created it or it was created through an automation erroneously. 

Good Morning!I had a question about moving my projects within the table itself.  I have a main "Ready For Install" section and below are two other sections, one for each install team.  What I want to know and if I am able to, is how do I make it so when I want to assign a job from the main "ready to install" section to a team, if that job line will move out of the main section and into the appropriate one.  Also, i want to link install team 1 and install team 2 to separate calendar views, so whatever job is assigned to team 1, only team 1 can see, and same with team 2.  any help is greatly appricated.

I have a table called 'jira tickets' with a single select column called 'status' with options like new, in progress, done, closed etc.The options in the single select are ordered appropriately within the field definition and so if I group by the status field within the jira tickets table, the groups are correctly ordered.But I have another table called 'work items' that links to the 'jira tickets' table and has a lookup field on the 'status' column.  Now when I group by the status lookup (in the context of the 'work items' table), the groups are unsorted by the original configuration.  And you can't override this on the level of the work items table because when you edit the lookup field, you don't see the options to be able to sort them.Is it possible to enforce the original order of the lookup field when grouping from a linked table?  I understand perhaps I could achieve this using a rollup, but it's so much less aesthetically pleasing I'm reall

HiWhen designing Leave Form Request, I have made a new form, however, there is no Submit button as default.  How to input that button in the form with automation that once the button is clicked, it will send notification?The "submit button' is shown in the Form view derived from Grid view, however, this setup wouldn't allow new linked elements right?How to set automation, when a form is submitted, the status field in Grid view is "pending approval".  When it is approved, the status changed to "approved".  I can only do it when I chose pending approval in status field in the form before submission, but it is weird.How to import "Adobe Signature" in the Approved by field?Grateful if anyone can help.  As a beginner, I read many useful solutions however no clues on the above.   

Hi, I'm building out a base to track overlapping magazine production cycles over the course of a year. Each record represents a task, and I'm wanting to duplicate records for tasks that recur each production cycle. I'm wondering how I might duplicate multiple records at a time. It doesn't appear that this is an option, but are there any work arounds? Thank you!

I am perplexed as to why there is a Date field type however it can only be sorted by 1-9 which puts the month of October ahead of January. Or another table of mine, it will sort January first for a few records, then start over. I don't know. Sorting by date seems really basic yet it is not working correctly in any of my tables. These dates sort fine in FileMaker, Excel, and Google Sheets. I'm stumped. Anyone have any suggestions? These tables were imported via CSV.

Hi there,I was wondering how I might be able to separate the calculation field's data depending on the user's email. This is to be displayed in softr. I am unsure how to show only the user's data when this is a combination of lookup and calculation fields.Any help would be greatly appreciated,Bart

I'm working on an employee directory and the context I'm trying to optimize for is when an organization is downscaling.My base has these tablesIn short what I'm trying to achieve is that when an employee is matched with a New Org Role a new record is automatically created in Assessments where I list the employee, the role and the manager that is reponsible for assessing that employee for the role. The plan is to then send a notification to the manager to conduct the assessment. It should look something like this:In this example the main column is a concat, the "Employee" and "Assessment" by column is linked to the Employee Directory and "New Org Role" linked to New Org Roles. The "Assess

Hello all,I have a table with 3 fields (columns). First is for names,Second for passwords,and the 3rd one is a concatenation of the 2 first ones.This table is filled up from a form. (this step is working)On the next table, I have 2 fields, the first one (primary one) is empty, and I want to have in the 2nd field the information from the 3rd field of the FIRST TABLE. (still following? )But no matter if I use 'link to' or 'look up', nothing happen in the 2nd column of the 2nd Table.   

HelloI have a table that is effectively a Risk Register Which has been scored by probability (1-5) and Impact (1-5). What I want to be able to see how many risks score 5 and 5, how many score 4 and 3, show on a typical risk matrix/heatmap like the attached jpg. I'm sure it must be possible but I can't figure a way.Thanks!Andrew

Sorry if this has been previously addressed, but I can’t find the information. Is there a simple way to separate a base into multiple, small bases?Thanks.

I have a zip code field and only want 6 different zip codes from over 20 different ones I have in my data source.I have successfully pulled those with the condition field use 'or'  but I also only want the ones that have an active customer  check marked.  when I place this as the 'or' field it then pulls all the other zip codes I do not want.  I am unable to place an 'and' condition successfullyI have resorted to grouping the active and inactive customers of each selected zip code but I want the inactive and active to be on separate reports (spreed sheet results) not oneWhat am I doing wrong with my condition codes? In this view, show records Where

I'd like to be able to link records together in the same table, and view connections easily!In my test base, I have a table that lists different talks. Some of them reference others, so I made a "Link To Another Table" field called "MENTIONED REFERENCES". This allows for linking a record to any possible children records. But not vice versa.I want to be able to see this link when opening a child record, to check what parents records it may have.e.g. based on the above pic, if I opened Talk E, the new field should say that it is linked to - Talk D- Talk FIdeally it'd be a field that lets you click on any Linked Records too, not just text.I don't know if this is possible in Airtable. Is it possible to use a "LookUp" field? Or resort to Automation or scripting? Haven't had a successful result yet.Her

I have a lookup field that brings a rich text field from other table, but I need to retain the links inside of that original rich text field. Can I do that? A lookup field into a URL field does preserve the link, but a link inside a rich text is not brought across...can I achieve that? Thanks

Hi allI hope I can explain my question clearly enough. I have three tables - Job List, Candidate List, ApplicationsFrom Job List, I want to select a job and create a new Application record which will inherit the selected job title into the job title field on the Application record. This would also be a parent-child relationship.Can anyone tell me if this is possible to do?

HeyI want to build a "lessons" table with all the lessons that I have with my students.I want to recursively schedule an event each week with part of my students (like I can in Google Calendar)Is there any option to do it?thanks

I want to sync PDF files via Google Drive however this method renders a low res PDF and the important copy that I need the reviewer to approve is not readable.Is there a way to stop this or is loading the attachments manually the only option?Thanks!

Hello everyone,I'm trying to use the filterContains URL parameter in a shared view with linked records. The issue I'm encountering is that this parameter only displays records when they exactly match the value provided in the URL, but I'd like it to function more like the filters in Airtable.For example, the Primary Field contains numbers, and I want to use the URL filter to display all the records containing one number (let's say 1...).That's what my URL looks like right now:https://airtable.com/appFS2avSSJRUpu7Z/shryOSrtr0WQfI3FQ/tblhf3jVTnogU7Yyz?filterContains_Table+2=1  

Is there a way to search for records based on historical data, specifically transitional statuses? Say a record was in Status A, went to B, went to C, went to D. Is there a way to see all records that ever entered status B

Hello community,I am using Airtable to process data coming from an architectural model to summarize information about parts.  Currently I am using a base as a template and duplicating this base each time I want to import a new list, as the lists are sometimes up to 10,000 rows long and I feel like it's not workable to just keep importing new lists into the same base.I have found the CSV Import extension to be far superior to the standard csv import functionality, and especially like that for the same csv column heading structure, the extension remembers my field assignments.  However, when I duplicate the base, the CSV extension disappears and along with it, the field assignment memory.  Does someone know if it's possible to somehow duplicate the extension along with the duplication of the base?  My csv has around 300 columns and probably 20 have custom column names that the CSV import extension doesn't automatically recogniz

I get it - really I do, if you want all your records in a table to be referred to as something else.But I want to just fix mine to go back to being 'records' instead of 'events'