Base Design

Hi, I want to build an Incident Table that tracks incidents. The key fields include: “Site” - location of incident “Date” - date of incident “Category” - drop down field that allows the user to chose the type of incident i.e., Property Damage, Near Miss, Lost Time, First Aid, etc. I have a second Person Hour table that includes key fields: “Site” - location of incident “Date” - date of incident Person Hours I need to create a statistical table that pulls and summarizes incidents from the Incident Table by year and category i.e 2020 3 Near Misses, 4 First Aids, 0 Lost Time, 3 Property Damages. Also pull the person hours from Person Hour table and record by year against the “Site” I would then create a formula to create a frequency rate for each category of incident. Example (for near misses) (3*200000)/person hours. I created this perfectly in Quickbase, but I cann

Hi! I’m trying to build a pie chart to displays for each product (identified through its EAN in the screen capture) the number of requests for each category (vegan, cruelty free, score). The only thing I managed to do is display the counts for a single category :frowning: Thanks for your help! /Saïd

Thanks in advance for help with this. I am new to Airtable and hoping there is a template to build on for this. I have a dynamic google sheet with a vertical column of locations and subsequent columns of asset counts. What I would like to accomplish is to copy that sheet in as a record each day and archive it like a file card. I can then reference and trend historic data. Is there a sample base or template that I can start with?

Hey guys, I’m not sure what I am doing wrong in setting up the charts in Dashboard. I see two different Date formatting on the X axis in two different charts: one a line chart and the other, a bar chart. They are configured using the same field! The Line chart shows date as set in the Table Column ‘created on’ while the Bar chart ignores any date formatting and shows YYYY-MM-DD format for dates. Is this a bug or am I missing something here?

Hello, I am trying to setup an airtable database that would help us handle our orders and stock efficiently. We sell furniture on shopify, so from shopify we get a CSV with lineitems sales that looks like this (first column is the order number, 2nd column the item name, 3rd the quantity purchased): 1157 // item #1 // 3 1157 // item#2 // 1 1157 // item#3 // 4 1158 // item#2 // 2 … Now our issue is that each of these items sold are actually composed of several physical “objects”. For example a shelf may come with 4 screws and a torx wrench. And we would like to be able to display for each order, exactly a checklist of all physical objects to be put in the package for the customer. So We created a table product items (what can be purchased on our website) and a table physical objects (what the product items are composed of). one item is generally composed of multiple physical objects, and one physical object can

Hey guys I know how to add the template into my workspace but is it possible to add this data within a base as well? (this base has already been created). For example, what I am doing right now is trying to move a template called: team workload planner into the one my current bases for the team without removing any info in our current base. Is this possible? Thanks so much :slightly_smiling_face:

Hey! New on using Airtable and writing on the community. Nice to meet you. I am builiding a database for a ‘football fantasy’ type game, a game where people can bet on different real games. Right now I am settling my app like this. Players: Name Country Events (list of events attending) — Field linked to Events table Events: Name Date Bet number 1 (checkbox) Bet number 1 name Bet number 1 points Participants of the bet (list of players attending to the event and different options for the bet) — Field linked to Players table Bets ID Record date Bet number 1 options (multiple select field linked to the last field of the Events) — How can I set up this field? I don’t know how can I do it There’s a way to do it? Thanks!

I want to send an email template based on changing an input on the table BUT I want to be able to view the email before send. E.g. Select Email Template 3 > View Email (make edits if need be) > Send Email. I can set it up so the email is sent when selecting Email Template 3 with pre-populated fields but I want to have a quick scan of it before being sent to make sure the correct info is on it and I haven’t made a mistake with this user. Any ideas on how this could be accomplished? Thanks!

Hello I would like to ask how to best setup the airtable base for the following use case: Our business is an evaluation platform, where the client weights the importance of about 100 questions/features, and about 10 vendors would submit their answers based on how their product covers the questions/features. We could therefore have as a result the clients target profiling, and the various vendors available profiling. Each answer would be weighted to points, which then can be scored. I am wondering if those 100 questions should be fields of a same record, or rather 100 seperate records… basically horizontal vs. Vertical design. The important point is that the client and vendors would need to have a form to submit their answers. Best case, we could have 80% of the vendor’s input pre-filled from previous RFP answers, so their input process would be optimized. I intend to have a user interface and port

Hi, I wanted to figure out the best way to tackle my specific situation. I’m pretty sure it’s a fairly commonplace problem, so I’m sure there must be a solution that already exists for it, only I can’t seem to figure out the exact configuration I need. I’m setting up a base for a friend who runs an interior design studio. In this base are the following tables: Clients: All her clients and their info Projects: All the projects the studio takes on. This table contains a linked record to ‘Clients’ so that you can see which project is linked to which client. Vendors: All vendors the studio works with Product Catalogue: This table contains records for every product (furniture, wallpaper, soft furnishings, flooring/tiles, lights, sanitaryware, appliances, etc). This table contains a linked record to ‘Vendors’ so that you can see which product comes from which vendor

Hello there! I have a last modified time column that watches updates over 20 different columns. Is there a way to catch somewhere the name of the column that has last triggered a last modified time update? If any external tool is needed to get this info, I’m in too (I’ve already got subs @ Zapier, Integromat & Mini Extensions). Thanks!

Hey Guys! Is there a way to do a unique setting for linked records. I only see ways to filter by empty/not empty and Contains/does not contain. I want to say, link to this field, unless value is already present. This will avoid duplicates in my linked field.

Hi, I need my customers to view their mobile purchase totals. however the sharing link of the table does not show in a grouped way nor with the totals for mobile view. does anyone have any alternatives for this? I would like to demonstrate by cell phone in the same way that it can be demonstrated on the computer as shown in the image below. note: I’m referring to view via shareable link and not APP :winking_face:

I have a list of product brands that we sell in a single table. Some brands in the table are actually sub-brands of other brands in the same table. I’d like to have two fields liking to this table internally, one where you can select a parent-brand for the record, and the other where you can select a child-brand for the record. How do I make it so that adding a parent to a child record also adds corresponding child to the parent record?

I’ve tried to search this forum for solutions, but I think I need someone to explain it to me like I’m 5. LOL I have a list of PEOPLE that have participated in training COURSES. Each COURSE is grouped by course CATEGORY. I need to know how many UNIQUE PEOPLE have participated in each course CATEGORY. example: Mary attended AM2 course and AM3 course in Absence Category. Need the unique count to return “1” attendee in the Absence Category. I’ve tried the arrayjoin function and I can get the count. Can also get the count by grouping by category. Appreciate your help!!

Hi all, I am building a sort of ‘attendance list’ which is displayed over a calendar, all I want from it is so that people are able to add their name, and a date in which they will be attending. I do however, want to limit the number of records per day. For Example: If there are already 10 people with the date 09/06/2021, I would like to either not allow another person to add an entry with their name and this date. A warning message would also suffice, in the way of having a last column, and once a person tries do add himself to the a date that has reached its max amount, the term “unavailable” would appear in the last column Any idea on how to approach this situation? Thank You!

I have two bases that I am trying to design a relationship between and am feeling puzzled about how to get them to do the things I need. I have been staring at the records for a few days now, so it is time to ask for help– thank you in advance! Base 1: Volunteers– this has our database of volunteers with their info and interests and volunteer notes Base 2: Project Management– this has a Projects table and Tasks table that are linked Objectives: Create a Volunteer Log table for tasks completed (from Tasks table in P.M. base) and amount of time spent volunteering – If possible, I would love for this log to originate in the Volunteers base rather than P.M. base. Task report view (in Tasks table of P.M. base) that shows how much volunteer time was spent on a given task. It seems like this number should come from a rollup from Volunteer Log…

I have created several columns. Of these, also “Long text” with the option “Rich text formatting”. I then entered text in the fields. In the overview, all fields are filled and look fine. If I now open a cell “Expand row” the content is gone. The same happens with all fields of this type when I open the whole record. All contents at at “Long Text” with the option “Rich Text Formatting” are empty. What is the problem ? Can someone help ? Thanks Greetings Uwe Dauer

Hello ! To manage my dev, i search a way to ‘extract’ formulas used in a field . The idea is to have a table regrouping all my differents fields created with formulas. Something like this

Hi! So I have a linked record in my table ‘Communiques’ to a record from (‘Contacts’) and I have a lookup field for that record’s Account field - which is a linked record to the Account table. In the Account table I have a text field for ‘Website’. What I would like to do is show this ‘Website’ record in my ‘Communiques’ table. Hope that makes sense! You can see a video of what I mean below: Thanks a lot!

Hello, My client has a weird problem when using the Long Text field as it deletes each letter after she types it. If she tries to copy/paste from a document, it briefly paste the text and after a second, it all get blank on multiple lines. She has no problem with the other fields. As it works great for me and that I have never encountered the problem, I don’t really know where the problem can come from. Would you have any idea what could be the reason of this strange behaviour ? Thanks Stephanie

For three weeks, I cannot fill cells, but a coworker on his account sharing the same base can fill cells. I created new, personal views in attempt to fix it, but nothing I have tried has resolved this issue.

Aloha, Im new here and this is my first post. Thanks in advance for any guidance. I have been using airtable for a while but in a very basic way. I now need to create a system where a group of people can sign up for their meal choices (lunch and/or dinner) for a period of 6 days. The idea is to have a form that collects: Name of person ordering for their group 10 meal options per day (5 lunch, 5 dinner) The ability to add a quantity per meal The form to display: Meal title, price and short description I have no idea how to setup my base for that… I know I need: Restaurant info (We will try to repeat the restaurant in different days) Meal item that is linked to Restaurant and what type (Lunch or Dinner) The different event dates People’s info (collected from form) Are there any templates that is close to something like this? Bonus if the person could have

Hi, I am tracking social media content ideas in one table and I have another table for the specific post analytics. Right now the analytics table is set up where a row can be linked to a specific row in the idea table and certain info is filled in that table. My question is this: can I auto-populate the analytics table with rows that meet a condition of “Posted” in the idea table?

Hi there! I can’t figure out how to make it right. Any help is welcome! I have set up forms for surveys. The surveys are: What are your 5 best movies of all time? What are your 5 worst movies? What are your 5 best horror movies? And so on Anybody can answer to these surveys by providing up to 5 movies each time. I want to have: Survey1: Movie3 (15 votes) Movie7 (13 votes) Movie4 (10 votes) and so on Survey2: Movie52 (82 votes) Movie2 (54 votes) Movie17 (16 votes) and so on Survey3: Movie26 (53 votes) Movie82 (26 votes) Movie1 (13 votes) and so on I can’t find how to count every given movie grouped by survey (then sorted if possible)… What do you think? Thx for your insight!