Base Design

Hey everyone, I’m creating a service where my clients can list three good things everyday and splitting each client by a different subdomain where they can only see their own contributions. I’m doing this using different tables. I want to create one master table, which automatically consolidates all the rows from other tables rather than me copying and pasting. Does anyone know if/how this is possible? Thanks, Gary

Hello, I’m trying to make a formula that automatically copies the first/top option of a multi-select field to the primary field of that record. Is this possible? Any help is much appreciated, Frank

Hi All - I’m looking for recommendations on base designs to track productivity (will use for daily and weekly rollups) and a base to track client deliverables. Any recommendations? Thanks!

Hello I have many projects with several tasks over several days. I can regroup by project and put my tasks on different lines, to be able to assign a specific date to them. Except that when I do that I no longer have the possibility to expand record and see all my tasks for the project. If I group all the tasks on a single line, I can see them when I expand record but I can no longer assign specific dates to the tasks! If you have a solution thank you for your help! I can send pictures to understand if necessary

I want to build a database for a specific purpose and am struggling to think through the theory behind it. I need to record names and contact information for a list of people. Each person will also be assigned to a group, with its own information. Each person will also have a record of activities completed for each month. Later, I would then like to visualize trends and averages for activities completed for a given group or individual. Can anyone tell me hoe they might layout their database to achieve these results?

Hi all. I currently on Pro plan and trying to build an event registration system and can’t seem to achieve what I want in my event registration form. In the event registration form, I can fill in my personal details and register as an individual participant, a group or a company. If I select a group or company, I would like to be able to enter personal details of multiple participants (including myself). What would be the best way to do this? Please do recommend other form-builder tools e.g. jotform, typeform, formstack etc which is able to achieve my use case. The integration I am using is zapier/integromat. Thanks!

How do I reset the data in a template so the story_id starts from zero? When I delete all the records in a template that is provided (after I create a base from a template), the story_id for a new record starts after the last known story_id number. I want to start my new template starting from a record ID of 1 (not 22) The example in question is for the Agile Template.

I constructed a database in FileMaker Pro many years ago to hold information about the many recordings my band has made over the years. I’m looking for an alternative to this platform, and only just now learned of Airtable. There are two features of FileMaker Pro that are used in this database, and I need to know whether Airtable has equivalent features. The first is repeating fields. The record for each song we’ve recorded has a repeating field which lists “who plays what” on the song for all six members of our band. The second feature in question is container fields. In this database, each record has a container field that links to a .wav recording of the song in question. Note that this uses FileMaker’s “store a reference to” feature. That is, the .wav file is not contained within the database; rather, this field links to the recording, which is stored on the hard drive, outside of the database. Does Airtable have the capability of replicating these tw

Hi, i have a few tables that have a basic structure that look something like this: Student Table: Full Name (PK) (Formula type created from First Name and Last Name) First Name Last Name Address Phone Number Email School Name Guardian Name Agreement Document Staff Table: Full Name (PK) (Formula type created from First Name and Last Name) First Name Last Name Address Phone Number Email Trainings Employee Function

Hi folks, Question for you: Can the lock function to used on a column with the “field type” as attachment? What I would like to do is be able to upload the attachment, but not have others be able to download the attachment i have uploaded. Is there a way to do this?

I am new to relational databases in general My goal is comparing reports of what are supposed to be the same items, but will occasionally have small (and sometimes large) errors. Because the reports come from 3 different locations, each one is already slightly different, but they each have a Serial Number field and an Object ID field. Those are what are most important to me What I’m trying to be able to do is have a table where I can plug in my Serial Numbers and see what each report says their Objected ID is, so if they are mismatched, I can see that easily. I know this seems straight forward, but I’ve been trying to use linked records and Lookup…and it keeps messing up.

Hi, I am new to Airtable and am trying to create a form for data entry (for people to sign up to receive information). One of the items that they are agreeing to is that they have read our privacy policy before submitting their information. I would like to provide a link on the words “privacy policy” to our website’s privacy policy page, but I can’t find a way to do that. Is that an option within forms? Thanks, Shannon

I’m trying to create a kanban view, but every time I try to actually use it it keeps asking me for a new grouping field.

Hello, I tried to find the answer on the community forum but couldn’t. My objective is to follow a large number of marketing campaigns. And to create a view comparing which one makes the more money. Some are PPC, some are Email, some are phone campaigns … Each of them has his own KPI PPC : traffic / captures / Sales Emails : send / clic / demo / sales Phone : dial / reach / demo … My idea is to create 1 table per campaign. On the campaign tables, each row is a week… Each field of the campaigns table will be specific to the campaign. And at the end of the raw would be entered the total sale per week. That’s the only field that can be compared in between all tables. I am trying to create a summary table. This would be the synthesis of all sales, to understand which campaigns are performing the most. My idea is to create a field « Sales » in the synth

I have a looong list of clients*. Each client has several unique envelopes. In each envelope there can be multiple unique items. So the only relation I can see is [one envelope] <- [item A] [item B] [item C]. Please advice me what structure should I build to make it compact, and so I don’t have to create new table for each new client. *) it’s not bragging :slightly_smiling_face:

Hello! I’m new to Airtable and I’m still learning it. I manly use it to keep track of my Games Backlog and Collection and Meds Cabinet. :slightly_smiling_face: For the Games Backlog I’m using a template I found in the Universe section and I was wondering how can I get the left navigation menu to show on my Base ? I can’t upload the screenshot here Thank You! Mihai

Hi everyone. I have a huge problem. I made ma data base using multiple options in a list, with a date for the choosen selection in the list. Problem is, I figured out now that I need to have one different record for each option selected in the list. So I have to create as many records that there are options selected in the list. And I have do to so for around 150 records … For exemple : the record 1 | Banana, Apple, Orange, Kiwi | 02/04/2020 have to become 1 | Banana | 02/04/2020 2 | Apple | 02/04/2020 3 | Orange | 02/04/2020 4 | Kiwi | 02/04/2020 Please, tell me there is a solution to my problem …

If you’re not sure how to get started with designing your base, our resident Airtable experts are currently leading 45-minute trainings for the use cases listed below. Each training starts from scratch and walks you through the motions of building a ready-to-use workflow within your base. If you’re interested, just fill out the form and select your preferred time slot — no Airtable experience is required to join! Content Calendar: https://airtable.com/shrzRLYiM2gHcywLr Project Tracker: https://airtable.com/shrtNhDQIG9qiqsqm CRM: https://airtable.com/shrEttalN1vN0FXo4 Product Roadmap: https://airtable.com/shr

I’m new to Airtable – how do I set up/structure my base? You can start with these under-5-minute screencasts on views linked record fields This 7-minute screencast goes over how to structure your base to represent more complex data (the specific example discussed is tracking building inspections by various staff members at various properties, though the base set-up could be applied to any number of use-cases). If this screencast is helpful, I’d also recommend taking a look at our Beginner’s guide to many-to-many relationships. If you’re looking for a step-by-step introduction to Airtable, I’d walk through our

Hi, is there any way for the fields to automatically change (columns) when a specific item is selected in the first field (column A)?

Real simple question: I am building a todo list across multiple areas of my life. Each table/tab is a different area (work, home, school, etc.). Within each area are numerous tasks grouped into various projects. I need one single master view that shows me the latest task (record) from each group across all those tables. That view can be another table itself or a block. Ideally, that view would show the highest-ranked task (record) within that group at that moment until marked complete, then it would be removed from my master view and replaced with the next highest incomplete task.

Hi, I am trying to track the accreditation process and had thought to set each table to include the various components of the levels of accreditation (beginner, intermediate, advanced). However I need the primary field which is the list of personnel names to copy across each table without needing a linked field that would require updating when entering new personnel. Is that possible?

Hi Everyone, I recently started using Airtable and I think the whole tool is great. I am now setting up a Base for planning a private birthday party. Some background information: We are multiple people celebrating together. Everyone can invite people and we want to divide the costs as following: Fix costs (Location, Band, …) are divided equally to all hosts and variable costs (food, drinks,…) are allocated by the number of guests per host. I have a set-up with the tables “Hosts”, “Guests” and “Costs”. The guest table includes all people invited with a link to who invited them. (and vice versa) Important here: Individual people can be invited by multiple persons, so the link is multi-select. The Costs table includes a column “Cost type” which groups them in fix and variable costs. Now I need to calculate the price for each person. I know exactly how to do that in excel: Sum the Fix costs and divide by the number of hosts

Here’s what I want to do (simplified for clarity). I have 5 blogs, and each one has 2 hyperlinks in it, that link out to the others. I want to be able to open one record, and see list of links to Outgoing Blogs, and then click on them, to see the record for those. The info I want to capture for each record in my ‘Blog’ base and are my columns from left to right are: Post URL (locked column), Post Title, Outgoing Links (set to link to another record in the same ‘Blog’ base, aka the Post URL column). The URLs in Outgoing Links are identical to the URLs in Post URL column, but the problem is, when I import my data from a CSV, with multiple Outgoing Links separated by commas, Airtable dosen’t map them to the existing Post URLs that contain all the other meta-data. Instead, it creates new records with just the Outgoing Link url. Does anyone know why this is happening? What am I doing wrong? And is what I want to do even possible in Airtable? Happy to sh

Hi, I want to build a function that duplicates the row for each Weekday IF Weekday is everyday or a checkbox that says “Repeat event”. I am lost on how to achieve this and hope the community a help a poor beginner :slightly_smiling_face: Stay healthy!