Base Design

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 two features? Thanks in advance f

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 synthesis table. For each campaign (so each raw) that would automatically be filled in by the total sales of the week (or even better, of

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/shr2ykzvUQX4pceai

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 Getting Started with Airtable Guide. Also, here’s a 45-minute base-build with a few Airtable team-members.

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 Calculate the price per person by dividing the variable costs and

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 share a link to the base in question, bu

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!

I have a column to which records can be added or deleted (Players). In another table I am trying to build a single select type field from which the user can select one option from the Players column. The options for this single select will need to be dynamic, read from the Players column at the time of selection. Is there a way to achieve this?

Hello, my organization collects donated items to sell at market. I have a base with two tabs: A calendar view of events (Collections, Donation Sorting, Selling) and a second tab with a list of donors and volunteers (who are often one and the same). Under the second tab, I have a view form for donors to complete. I would like them to be able to schedule (i.e.select) only future collection dates (we collect every Sunday every week). I need some help… how can I best do this?

Hi First-time Airtable user, I am working to create database for a yearly event. I have the current table of past year attendees and plan to use Zapier during this year’s registration period to send the record when someone registers from the ticketing platform. My question is if the attendee has attended in past years, how to associate that new record with an existing record vs. create a new line? Before the record is added, looking up to see if an attendee with that email is already in the database. If yes, associate that new record with an existing record, if no, create a new line? Thanks! Josh

Hi, what’s an equivalent of each feature of Airtable in Google Sheet?

I have a field set up as a URL. However, the URL does not actually allow click-through in the mobile app, although I am able to use it that way on my desktop. Seems like there is little point in having a URL in the table if it can’t actually function as a hyperlink. Having to copy and paste the link from the mobile app into a browser creates a number of additional steps. What am I missing?