Base Design

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 tabl

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 giv

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 tha

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

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? 

Hi! I'm doing some work for a nonprofit with a limited budget to set Airtable to help manage their annual event.The event pulls in a variety of pieces of information about each of the following (and this is how I have drafted the workspace):SponsorsSponsorsSponsorship levelsContact logBoard membersTeams participatingTeamsSchool/Company/Org team belongs toContact logYearly baseVolunteers who have signed upVolunteer needsBudget (TBD on tables)Some of this should be carried over YTY so the bases could be re-used with new, yearly tables, and some is unique to the calendar year. I originally planned to have a base for each of these, and sync where needed. However, until they get a paid plan, syncs would have to be manual, which doesn't seem ideal. I'm wondering if it would be better to use a manual s

HiI'm moving my automations from Zapier to Make and I'm struggling to get the airtable automations to work in the same way.Previously, when pulling the automation from Teamwork, the websites field showed a record ID, which then haulted the other linked fields.  I then created the Websites copy column to turn the Record ID into text.  Make does this differently and pulls the tag in as text, so I need to find a way to do the reverse, ie using the text in the Websites Copy column to find the matching record ID on another table, thus allowing the other lookup fields to function.I'm not sure if any of that makes sense, but any help for this rookie is much appreciated.TIA  

I have a database of my softball league and have the table grouped by team, but the count for each team is cutting off the team name, which I'd much rather see. Is there a way to stop the count from displaying? The only way I can see to do it is making the number column very wide, which makes the table look terrible. Is there a way to easily see the full group name?

Greetings Airtable Community,I am looking for someone to hire for Airtable help. The team I am a part of currently has a very base-level database setup but we are in need of some help when it comes to fine-tuning and streamlining capabilities through automation, sheets that correspond properly, quick and easy info/photo upload, etc.This is all property information on the database so someone who has past experience working with Real Estate Databases would be awesome!Please reach out to max@hornigpartners.com if you can help, thanks