Base Design

Happy New Year,I am brainstorming how to setup a national nonprofit with several locations around the country.  The national headquarters will need 10-15 chapters to report data such as client enrollment, services, and program indicators met on a monthly bases.Option 1:  Setup a base for each chapter (Decentralized) and then create interfaces for a person at HQ to pull reports.Option 2: Setup one HQ base (Centralized) and then several tables for each chapter for data reporting.  Admins at each chapter will have update permission for their tables in the base.Option 3:  Setup HQ base and then automate process that will import excel or csv files from local chapters into HQ base for tracking/reporting.If anyone has experience in this area , I would greatly appreciate any feedback as to which process could provide the least friction.  Also if there is a better option, please feel free to make a recommendation.Thanks a million!

Hello,I have 2 tables that I need to relate. These is regarding components in the field that are declared not working.The Tables:Ticket table: End User tickets about stuff not workingField deployedThe tickets have 2 statuses either "Open" or "Closed". I created a view for open tickets and one for closedI created a linked field in the Field deployed table to pull the info from the ticket field with a "Limit selection to a view" to the Open ticket viewFor some reason the column populates with all linkable items disregarding the "Limit Section View"any reason for this?

Hello, I am looking a way to group by dateFor each Job I have a CabQty, DoorQty and DrawerQty to do. The doors must be manufactured 2 weeks before Cab and drawers 1 week before Cab (see attached 1.png).My goal is to have a view by ProdDate (see attached 2.png).I used colors to show what is make when.See attached 3.png that resume the summationI hope I am clear enough, it's not easy to explain.Thanks

I have a Table with organizations. Each org has people attached to them via a People Table. Each organization has a status. One of them can be 'Contact The Organization'. How/where do I create a View to show me all the people I should contact, for all orgs. I want a grid view with columns to display Contact details such as Name, Email, Phone plus the org name they are associated with plus a few other org columns such as Status and Country.Insights are much appreciated. 

Looking to see if we can find out the history of how many times a single select option has been chosen by any of our team members in the past. I have something set up that I started in October to help with this but wondering if there is any way to see the usage for each option from April to October. 

HiIn my base I keep the record of members who have one or more cars in a base. There are two separate fields for the make and the model for car one and the make and model of car two.When filling in the form they select from a drop-down menu the make and model in each field of the car.Then if they have a second car in separate fields, they select the make and models.Now in the first cars make and model fields I have populated the drop-down menus as we have gone along, I added the second cars make and model fields later and as a result have not populated these with the relevant information.Is there away of copying the information across to populate the fields for the drop down menu in the second cars fields or a formula that I can put so when the information in the first field is entered it will automatically enter it in the second field.Many thanksRod

Hey friendsI have automation that transfers leads from an Elementor form to Airtable, but for some reason when someone writes down their number in a normal way (ie: 0526324302, an Israeli number) it changes the structure of the number in the system (adds a picture)How can you change the structure to be the same as how the lead wrote his number in the form?Thank you! 

I would like to group to 4 fields but the AT limit is 3. What is reason for that?

I am trying to track work done in a software program that has different Workspaces and within each Workspace there are Apps, that are different depending on the Workspace. I’d like to create a column with a drop down where you can pick the Workspace from a list . Then once the Workspace is choosen, in the next column, I’d like a drop down of options for the Apps related to that Workspace. I can figure out the Workspaces drop down but not then how to create different drop down options based on which Workspace was chosen. Is this possible?? Can I set up a different table of Workspaces and their Apps and link them somehow?

Basicly, i have a Job Creation Request PDF Form we use for customers to fill out and submit to us and digitally sign too. I was hoping it can be used to fill in data as they submit it. Then our tech can access it and add to it hopefully. Otherwise at least letting the customer fill out the pdf and letting us keep a copy of the submitted file, while filling out a table in our base would be great.

Base SituationI got a table a containing a list of visits.Date, Location, add. InformationWithin another table b I am tracking daily statsDate, sum of hours invested, count of visitsChallengeHow to generate "count of visits" in table b, counting up all the entries of table a, that have the same CREATED AT as the date in table b?Thank you all upfront.

Hi All,I would like to embed a gallery view of my database, but I want it to be a slideshow. So rotating itself.Any help would be so greatly appreciated! Thanks

My sister is on a free account and she noticed her home screen changed. Please, please tell me this isn’t going to happon the Pro account. It’s so much less user-friendly. The icons are micro sized (which wastes a massive amount of space) and the icons don’t move in the order you want them (has to be alphebetically, etc). I absolutely LOVE Airtable and it makes work so much better but this is not an improvement. Can someone let me know if this is happening across all accounts? Thank you!!

Dear Community,I am expecting this is more or less obvious, but I can't figure out how to solve it at the moment.Mission StatementA list full of contacts to be called and asked for an informationI now want someone to use a form to enter information he found out by contacting theseWithin the form, the user should be able to select one of the locations from the list, add the information and store the entry.How I built it so farTable A for the base dataTable B for the entered form dataThe lookup field referencing to table a becomes the dropdown.User enters additional information and stores it's data.My challengesWas the setup reasonable for the challenge?How to work with these tables / re-connect them? For example - how can I find out, which locations were not visited by now? Can I create a new table that adds the added information from table b to the entries fo table a? What is the best practice?

Just as the title says.  I have a form that looks like thisCompany NameCompany Size Contact NameContact EmailContact Phone  How can I have it set so that my form finds the single foreign key then passes those fields to create those records?

My base should only be Eastern Standard Time, but it keeps defaulting to GMT.   The devices I use it on are all EST.   What would cause this issue?   - Wendy

Hi community,I have this problem : In a grid view, a table is sorted manually. After each opening, the order is kept.A script fetches the records of the table, and delivers them in alphabetical order, not in the manual order.I don't add any sort param - like 'sorts: [ {field: "someField"} ]' - I cannot figure out a 'handy' workaround... The option to read on a sorted priority field quickly becomes tedious, time consuming, and requiers a lot of energy...Thanks in advance if you can let me know how i can workaround this behavior.

Hi everyone! I've been working on Airtable for a while now but I'm by no means an expert so I'm pretty confused about how to set this up for my boss 😞What I'm trying to do:Each client goes through an onboarding process that contains the same steps/tasks. These tasks have durations and overlap, in total can take up to 90 days.I'm trying to use a Gantt or Timeline view where I can set the start date for a client's onboarding process and then the tasks will auto-populate with the correct deadlines based on the start date. The tasks can be completed earlier or later than the deadline depending on the client's situation, and the subsequent tasks should adjust accordingly.I'm trying to view multiple clients' progress at the same time, which is why I was hoping to use a Gantt or Timeline view. This would let me see which task we're at for onboarding for each client at any given time.I'm also trying to set up automated alerts so that once a task is completed, the next person is no

Hello All,I have two base design options that I and coworkers are trying to agree on. I will like to make a comparison between the twoBase Design #1 Idea: Have one big base with all the data and third-party automations, then create views for different teams with specific permissions. If someone wants to collaborate, special permissions can be made and then deactivated after a set time.  Base Design #2 Idea: Have different bases for different teams. This is not currently working, but there is a fear that having one big base will not suffice for everyone's needs.  Can anyone provide pros or cons for both options?

Hello Airtablians,Have you ever thought about an elegant solution to manage a multilingual interface?Currently, I have created a ticket management solution via the Interface Designer, but soon users speaking another language will use it. If the interface will be cloned and translated, how to manage the text of the status for example?Thanks for your help ❤️

Hi! I have a "Projects" table with 2 columns of the professional specialties that need those projects to be executed.Both columns are Linked Records to a master table of "Specialities.The specialties can be repeated in the 2 columns, because each column means a group of specialties, and the project could be executed if the assigned professional meets one group or another.For example: "PROJECT 1"- can have in the column "SPECIALITIES_1", the specialties: "specialty_1, specialty_2"- and in the column "SPECIALITIES_2" the specialties: "specialty_2, specialty_3"- being "specialty_2" common in both groups.The Projects have an associated price.I need to know the % of income per specialty.Each specialty is weighted equally in the project price, if a project has 3 specialties, then each one takes ~33% of the price.The problem I don't know how to solve is the following.As I have 2 columns with groups of specialties that can be repeated, I do not know how to make a list that groups both columns

Hello! I'm new to Airtable, so I apologize if this is a very basic question.I have a bunch of different contractors. I'd like to use Airtable for each of them to record their progress on the various projects that I assign them. However, I don't want them to have access to each other's records, and ideally they wouldn't even know who each other are. I'd be grateful for any suggestions on how to set this up.My first thought was to create a single workspace with multiple bases, and then invite each contractor as a collaborator (with editor permissions) on one specific base. Each contractor's base would just contain a subset of my master "projects" base, filtered according to a "contractor" field -- and perhaps with certain other fields omitted, such as my own private notes on their performance.But I'm guessing that then each contractor would still be able to see who all the collaborators are in the workspace? If so, I'm thinking that I might actually want to create separate workspace

Does anyone know if it's possible to create a new entry within form view when selecting an option from a Linked field?For example, I'd like to use a form view to enter information about a new proposed project.  One of my fields there is a linked field with every record in a separate tab of companies we have worked with.  Ideally, I'd like to create a new company directly from the form view of creating the new project proposal if required.  But I'm imagining perhaps I can't.

An entry in a text or number field in a base needs to be able to take the user to the linked page on an external site. Is this possible?

My team manages YouTube channels and have a content calendar that shows what stage each video is at & when it's coming out.In the new year we are moving from Google Sheets to Airtable so external stakeholders have better visibility.On our current Sheet we have it set up so that the cell with today's date is coloured bright pink so we can easily scroll to 'today'.Is there a way to replicate this in Airtable?