Base Design

Hello! I’m fairly new to Airtable and was trying to create a form. When I click on the shared link, I get this message: Warning: potentially risky form The user-created form you are attempting to access has been flagged as a potential risk. If you wish to proceed and view the form anyways, please remember to never submit your passwords through Airtable forms. Any advice on why?

I need help with the 500 column limit. We use our base for estimating but with multi options and pricing we are reaching our max limit. Example: We have a window estimate - which consist of 16 windows (and every window is different and needs different information: 16 - Window Styles 16 - vlookup for window style pricing 16 - Length Measurements 16 - Width Measurements 1 - Formula for measurement pricing 16 - Zippers Sizes 16- vlookup for zipper pricing ect… This is only part of the estimate. Currently we are right around 430. Please let me know if you have any suggestions to help.

I’m trying to find a way to manually sort rows in my main Grid view and once manually sorted, updates the order of the additional views in the base. We are trying to import a tool that we have in Google Sheets to Airtable. It has hundreds of rows. Sometimes a new row is added, but needs to be near an older row further up the list. Instead of using Google Filter views, we want to use the Airtable Views to replace them, but we need to see those row updates that are made to the main one in them. There are about 20 non-main views that we’ll be making. Any thoughts?

Hello, I’m using Airtable to organize a catalog. I’m not enjoying the drop-down option and don’t recall this from past use. Is there a way to remove?

Who knows how I can organize this? I have two tables: Groups, with each 10 columns for the names of their members Members, with the data of all members of all groups Now i want to automatically add the name of a new member to the first open spot of the particular group. For example, if Joe is the 5th member signing up for Group X, then his name should automatically appear in column five of that group. Is this possible?

Hey, just have a quick question that I have not been able to solve otherwise So we have a pretty complete base with the following flow : 1.Client fills an Airtable form to book a service; 2. Internal team of operators have different views related to the state of the bookings ( in transit, current, done) 3. Each major client would have a filtered shared view of their bookings, grouped by status Here is a quick idea of how the base is setup : Booking Customer / Client Customer table having the customer ID as their main identifier (primary key of the Customer table), Full company name being the second column, to make sure in the Airtable Form that the customers cannot see the other customer other than their randomized Customer IDs. We communicate with each client their Customer ID and with a prefilled URL we prefill the form shared with the customer. So the current problem is that if the operator needs to fill manuall

We have a submittal (construction company) log setup in airtable that overall we have working quite well. Submittals as one line per submittal, and each revision is it’s own line. The key field in the table is a formula that takes the submittal # + the revision # to make a unique ID. For example, we may submit Submittal 07 Rev0 for approval and it is rejected, so then we re-submit and have a new line that is Submittal 07 Rev1. This would look like this Submittal ID Submittal No. Rev No. SUB_007_00 007 00 SUB_007_01 007 01 Each submittal gets an “open” status when it gets sent to the client and then when it is returned, it gets updated as either “Approved”, “Revise and Resubmit”, “Approved As Noted”, etc. What I am trying to do is create a view to only see “Revise and Resubmit” status for example, BUT I want to exclude all the lines that were superseded by a revision so that I don’t have a cluttere

Hi, First issue I have linked a ‘products’ table and an ‘orders’ table. The products table lists the items but some of the items have multiple choices (such as colours, sizes and finishes). When the product is selected in the orders table, the options are grouped together and not selectable (i.e. it is a mirror of the original contents rather than a dropdown which is unique to the entry on the orders table and doesn’t change the main products data). I want to be able to select the specific options for each product on the orders table without having to create multiple products based on colours, sizes and finishes. I suspect it’s a formula or other method rather than just linking but I haven’t been able to find an answer online (as there are too many solutions for linking and I’m probably using the wrong terminology for my issue). Any ideas how to resolve? Second issue This is not as urgent but it would be really handy if certain

Hello, do you think being 15 users on 3 accounts can slow down airtable our bases or there is no link between number of connexions on an account and speed ? the question is… if we buy 1 or 2 more accounts, will it fix this issue ?

I have a base set up for the families that we support through our feeding programme. There is a tab for individuals, giving details about each person, and a tab for families, where the info common to each family is held. On the families tab, I also have a “link to individuals” column, where the base automatically lists the names of all the individuals in the household. As we are updating our database we have found that some individuals have left the household. I would ideally like to keep their information on record, rather than deleting them. So I have created a “active/inactive” single select column for each person, under the individuals tab. However these individuals are still reflecting under the “linked to individuals” column. Is there a way to configure it to show only the current individuals?

Hi folks. I am trying to create a Kanban view of a table that has x1 single select field and x1 collaborator field. I want to make the Kanban on the collaborator field but when I create it, it only finds the single select field and ask me if I want to create a new single select or collaborator field. Any thoughts welcome! Thanks.

Is there a way to achieve the following? I have a table called people and a table called families. In the families table, I want three columns: mother, father, and children which are all linked to objects in the people table. In the people table i want just a single column which represents which family that person is in. It seems like this should be pretty simple to do, but i can’t figure out how to get it to work without having multiple columns in the people table or splitting the people table into three separate tables. Any help would be appreciated.

All I want is to show the selected records by clicking the boxes on the left side of the primary field. It lets me check but then what? I cannot find the way to do it.

Necesito crear un formulario dónde al buscar el ID del empleado me muestre la información, esto desde un link para que pueda el usuario final ingresar su ID y descargar y revisar su información.

Hey everyone Seen a lot of posts requesting ability to show/hide tables. I would LOVE this to be a thing! Seems there are a bunch of posts about this, people requesting it and then no replies on where the dev is on this, IF there is any intention to develop for this… Has this ever been actually addressed? Anyone have any insight? Anyone want this as much as me lolz? Thanks

Hi, My daughter started her own home business to sell things that she makes. I’m looking for a free and simple system that I can use to track her sales and expenses. All I’m envisioning are ‘tables’ for Customers and Products and then a way to input orders (who ordered what) and do simple reports to pull a list of all the orders within a timeframe or something like that. And also a place to record purchase for supplies to eventually do a cash flow type report to show profits. Since Airtable is designed to be used in lots of different ways, I’m completely lost as to the best way to use it in this way or if maybe there’s a better solution out there to fit my needs. I’m open to all advice. Thanks.

Hello, We are looking for a solution to convert a single image (company logo) to get a url. We import the CSV to Webflow but we can only import an image with a url. The ultimate goal is to automatize with Integromat so when clients fill the form and upload their logo, the table is updated and all the info are sent to Webflow. I have the feeling that I’m missing something very simple but I don’t see where. Thanks in advance for your help!

I keep getting closer to remembering the difference between a spreadsheet and AirTable, but I have a Base design that is just eluding me. Initially I have a 2 table Base that need to be linked. Table 1 has a list of people in my organization along with critical information. The primary field will obviously be the members name (we are small enough that I am not concerned with duplicates, or can handle them if necessary). Table 2 will be continuously built through form input by the organization members. Primary field will be a date/time stamp as that is really the only unique identifier on this Table. I want to link the two tables through the name field, but I am not sure the best way to do it, particularly since there may be some mismatch between the name in Table 1, and the name entered on the form for Table 2. I was originally considering having people entering First Name and Last Name, and then using concatenate to join them, but I couldn’t find

Hi All, I am working on a work report / timesheet integration in Airtable. I currently have multiple tables Tasks Projects Workers Clients In the tasks table I will write in different columns the following: Task description Type of task Project Number (from the projet table) Date regular time Overtime Employee (from the workers table) I would like to be able to group the tasks by employees. There will be multiple employees working on the same task and currently the grouping will group all the employees together instead of individually. Is it possible to get the grouping to group each employees individually regardless of who worked with them on each of the tasks?

Hi everyone, I have 2 tables one for People and one for Businesses The 2 tables are linked so a Person can be linked to multiple Businesses and vice versa. I am trying to figure out if there is a better way to store the kind of relationship a Person has with a Business. For example a person could be volunteer for a business or an owner etc. At the moment in the People table I have multiple columns that are all linked to the business table with each column expressing the relationship ship to the business. I am finding the number of columns I need to show the relationships is becoming a burden and would love a way to describe/store the relationship (volunteer, owner etc) in a better way. If a person could be linked to only one other business it seems quite easy but I cant think of another way to handle this with multiple business relationships. I’d really appreciate any words of wisdom pe

I want to track Companies, People, and date each person is hired. In a relational database I would use a “join table” to handle the many-to-many relationship and would include a “HiredDate” field in this join table. AirTable makes many-to-many relationships easy, but then no easy way to track hire date for each person at each company. This seems like such a common use case (companies/people, products/customers, students/classes). What am I missing? Thanks!

Hello all, I am new on airtable but i did my homeworks before coming here to share my with the community… I am trying to prefill a form in a table (table 2) with data from an other table (table 1 = “DATA table” which is filled with some data previously given via tchatbot conversation and functions which process some data into new results). Here is my formula below (which is now in a formula column in my first table DATA where all my data is automaticaly collected from the tchatbot): "PROPOSITION D'ENVOI D'APPEL D'OFFRE AUX ARTISANS DE LA TEAM URENOV & “prefill_Date=” & ENCODE_URL_COMPONENT({Date} & “”) & “&” & “prefill_N°%20de%20pr%C3%A9devis=” & ENCODE_URL_COMPONENT({N° de prédevis} & “”) & “&” & “prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” &“pre

Explanation for this challenge as can be seen in this simple table I created: Airtable

Hello everyone, I’m looking with “unique” keyword to find how to make unique raw not based on primary key.and do not find help. The case : I have some schedule based on 5 day week with hours for each day. I have formula that give me a rapid view on the schedule and I want that rapid view be unique to not duplicate the same schedule. It seems not possible with airtable could you confirm taht ? Thank you very much for your help Charles note: here my formula to print rapid view schedule: Lundi & “-” & Mardi &"-"& Mercredi &"-"& Jeudi &"-"& Vendredi

Hi all - I’m looking for a way to capture reasons for status changes on my records and capture some more relevant information. For Example: Moving a Card from LIVE to Pause in a Kanban view triggers a form to capture Pause Reason + any additional questions.