Base Design

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 a way to have a field be both a linked

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 people could offer here to help with this. Much appreciated Glen

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} & “”) & “&” &“prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” & “prefill_Adresse%20du%20chantier=” & ENCODE_URL_COMPONENT

Explanation for this challenge as can be seen in this simple table I created: Airtable My challenge - Airtable Explore the "My challenge" base on Airtable. We have a few people who mention their START DATE and END DATE And there’s a table with a daily schedule All I’m trying to achieve is to be able to show me in the Daily Schedule table who are the “PEOPLE” who are available on these days. I need some formula that I’ll be able to keep adding more people to the list, and keep adding more events to the schedule, and always automatically see the people that are available for these events. I did try a few different things. Like, adding ALL people in the PEOPLE list manually by making the “PEOPLE” column a LINK to another field. But that’s a manual work. Utilizing the above method with a ROLLUP field that only brings back the people who match my criteria of start and end date - as an array (comma separated), but again, I must first ADD all th

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.

I imported a large spreadsheet with all the data about customers and their contracts. All the customer data and the related contract data resided in one big spreadsheet, so I have one big table with all the data. I have some customers with more than one contract, so I have duplicate customer info in some rows. I have completed alot of customization on field types already, and now realize I want to break this large master table into a customer table and a contract table so I only have to update customer info in one place. Is there a way to do this so it works - I want to bring over all the customer data to a new table . I have last name, first name, address, town, state, zip, phone fields that would need to be moved to new table for customers. The contract table would remain with contract number, instrument assigned, start date, bill week, status, etc…

Hello all, So I started doing a design for a base that I think will work great with my vision, but I do have a question. I am designing a base which tables will have a series of questions around specific topics. And this is for one to go out to a customer and ask a question, write the answer and mark the organization compliant or not. So I’m figuring that a table for each section (six in total) will be best as, most likely, the schedule of the interviews will follow each section, and at the end everything will be collated. So here’s a couple of questions I had w/r/t the design of this: The questions, and their hierarchy, should be read only. That is, the interviewer only can write to the answer field and upload evidence. So in the form topic → subtopic → sub-subtopic should be read only The base should be clonable. Guessing this is the easy part. :stuck_out_tongue: There is some scoring which I presume could be rolled over maybe into a ‘portal’ table that will give you an at-a-

Hi.In the free version, I have the use of 1200 records. But of which 80% is the product category. Can only get more records when I pay the fee?

Hello I have tables with over 200 fields, and I would like to categorize them, or at least auto sort them. For example, Fields “Length” “Depth” “Height” are all “Dimensions” - Ideally I would like to be able to categorize them so that they are always next to each other. This would also help if some fields are private, and should be kept this way, to categorize them easily and be able to hide them in one streak. Currently, I work around this by adding a set emoji before a field name, so all my “Dimensions” fields for example start with :straight_ruler: , and I then do this manually. Yet, this is not foolproof and not great. Any ideas out there? S.

Hi, Could you help me calculate the average results (ratings) of a student live online evaluation? I am testing 2 tools to collect the feedback of respondents, one is designed with Typeform and the other with Airtable. It is not possible to add a “multiple select” in the primary field with Typeform (“names” of students can only be added in the second column), while name can be put in the primary field with Airtable form. Does it matter to average ratings? The evaluation goes as follows: The respondents select the name of the person to evaluate from a “multiple choice/select” list and rate them using "opinion scales/ratings). The answers are imported to Airtable at the end of the live session as you can see from the screenshots. I would like to calculate the average of ratings for each group of names and use the value in the base. I noticed that the “group functionality” does not help as it is not possible to use/extract the average values in the same or a new table. Do you have any ide

I’m going to try and make this make sense. I’ve built out 12 different formulas/fields to spit out different date results based on a primary date field and some other factors. I now need to be able to either copy horizontally and paste vertically, or somehow bring them all into one new field that can then be copied and pasted into new records. into

I am trying to import about 1000 product photos into the “product” category. The problem here I cannot find the fastest method because the number of each product is not identical. Hope you all help me, I’m a novice user.

Hi Community ! We have a database that count 80 000 records… and counting… (We are limited to 100 000) Could someone hep me on a way to split my database ? For example… I tried to host “cities” table in an other base and sync this one… but if I sync all the rows in my main base, that does’nt make any change ! Sync row are counted in my main database. Any clue, anybody ? Thanks in advance. Alex

Many CRMs that we have used in the past export all data in one row. The issue is we want to take that data that is in the same row and create multiple entries in a new table. Here is an example: Primary Contact, Primary Contact Phone, Relationship, Secondary Contact, Secondary Contact Phone John Doe, 847-555-5555, Spouse, Jane Doe, 708-555-5555 Each one of these is a column header and I would like to be able to easily import them as one line and then have them also available in a new table which separates the contacts. The goal is to end up with a Gallery view so I can see different Cards for Both John & Jane Doe with each of their appropriate contact information and see that the other person is linked to them. I need some level of automation here as I am importing 1000s of records and not all data will have two people associated with it.

Hi, I have a table called ‘Communiques’ which is linked to ‘Contact’ records. I want to be able to - when I create a new task record from Communiques to automatically have the ‘Contact’ filled in from the Contact associated from the Communiques table. Is this possible? I have created a video to show what I mean: Thanks

I am creating a base to track my inventory, I have created 3 locations in 3 seperate tables, with images description etc. I would like to know how to merge all 3 together into one table (master table) Is there any way I can do this with data intact?