Base Design

I have a base with three tables. Each table is a log of different types of incidents that occur at our company. All tables are indexed using the date time the incident occurred, and also includes other accompanying data like staff involved, etc. The accompanying data for the three different incident types is different, otherwise I would put them in a single table. What I would like to do is generate a chart that shows how many of each incident occurred each month. I have found out how to generate this chart for one of the incident types using a block, but the block only allows me to pull data from a single table. I’ve tried creating a fourth table to capture all of the summarized data and then build a chart block there, but I’m stuck trying to find the most efficient way to link all of the data. If I create year and month columns in my summary table, is there a way to automatically link to all of the records in other tables with matching year and month, or is linking i

I am trying to make my Interaction ID change when my Interaction Type has a different select. I am not a coder but sometimes get luck. This is what I think the formula should say but it’s not working. Can anyone help? IF({Interaction Type} = Zoom Meeting, “ :crystal_ball: ”,IF({Interaction Type} = Elevator Pitch/Networking, “ :candle: ”, IF({Interaction Type} = Event “ :bulb: ”, IF({Interaction Type} - Referral “ :handshake: ”, IF({Interaction Type} = Appt “ :date: ”))) Ex1 is the formula I have now Ex2 is the select I have

hello, I’m getting this message when I’m trying to submit a form. here is the full 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." I tried to contact support but no reply. can it be rectified by me or should I wait for official reply. Thanks.

Total noob, but need to know if in long text aka rich text can you insert an image/picture? Just thinking about using airtable for my blogging needs (airtable-zapier-webflow) and would like to be able to use rich text editor but will need the function to be able to insert images and pictures that can be floated, size adjust, captioned etc within the rich text editor field.

I’m trying to replicate this chart Block from this example here I don’t understand how this stock example was made, do they have a table containing all the stock data at different times? What would that table look like? I understand they would have a table for all the listings, but how would those listings all be linked to hundreds of price data points at different times? Does anyone have an example of this?

I have a grid view with a long text column. Is there a way to either have the row expand to show all of the data in the text cell (similar to that done in excel)? Or some visual indicator that there is more text that is not being shown?

I have an Access database that tracks all the various activities of our Volunteer Fire Department. Everything from emergency calls to training to member information to inventory, etc. I am trying to figure out if I can take that database and go to Airtable. We would like to get away from the desktop, one computer centric vision of database designs. Does anyone have any experience with this in Airtable? Would you be willing to share your thoughts on how to go about this? I have a lot of experience in relational databases, but Airtable does not really follow that paradigm. I have trouble getting out of that box. Thanks ,Scott

I have projects that I want to add links to four generic tasks timers (writing, editing, revising, project management). I want to automatically link every project to those four timers. Is there a way to do that?

Hello! I am using Airtable for managing social media for a non-profit. I have two bases - the Digital Asset Manager and the Social Media Calendar. I would like to link the assets in the DAM to my entries in the SMC so I can see from the DAM when that asset has been used and I can have the SMC use an asset that is already in the DAM. It seems really silly to have to load them into both bases and have them not speak to each other. Am I missing a way to do this?

I’m using Caspio now. I need a searchable database on my website that has the capability to print in pdf, excel, csv. Can I do this same thing with AirTable? Thanks much.

I have created a form view for each employee (5) that is personalized to them, with their name and a fun image for them at the top. It is used to track their billable time per client. In the grid view, however, I’d like to see which form (or person) submitted each line so that I know who completed the work. Is this possible? Thanks so much!

Heya ! I’m having trouble with this one ! It is not a problem specific to AirTable : it would be the same with any other relational database, and it is an open one… What I’m aware of : the most consistent solution would be to have a single ‘Ledger’ table containing both income and expenses. Reason why I would prefer separate tables : the ‘Income’ table is deeply related to the already complicated CRM part of my base the ‘Expenses’ table is related to the Providers part of my base there is no correlation between those parts of the base, and I like it that way ! #K.I.S.S. the data in those two tables are of completely different natures My need : I simply want to compute a monthly net revenue bar chart in a block ! (btw, I’m literally loving the power of AirTable blocks :smiling_face_with_three_hearts: ). Obviously, I would like it entirely automated, and as simple as possible My th

I have a table of classes I want to use that almost always start at, say, 10am. I want to be able to add these into the timetable on a semi ad hoc basis as I get a booking without having to change the start time every time. I can’t see a straightforward way of doing it. Can you help?

Hi there AirTable newbie trying to work out how achieve something. Scenario: I have a table of Video Clips from different countries and containing different languages. I have a table of footage Loggers that will review the clips and be assigned based on the languages they speak. In the Video Clip table, I wanted to display a list of Loggers that speak that clips language. To that end I created a Languages table, linked both the Video Clip and Logger tables and using a look up field can now see the names of suitable loggers. I can then just their name into the Logger field in the Video Clip and consider them assigned. Brilliant. EXCEPT If a clip features multiple languages (ie English and Spanish), my lookup field displays all the loggers that speak English or Spanish. NOT loggers that speak English & Spanish (which would be the best solution). Is there a solution to this? I can’t see an obvious way of using the conditional Lookup

Hi there! I am looking for a way to compare two fields and then remove certain parts of one of the strings in those fields if it is already present in the other field. We have customers in the Primary field, then another field that is a rollup aggregation of all of their reviews and then another field that is a rollup aggregation of all the products they are received. I then want to create a formula that means I can have another field where it is just the products they have received but not reviewed yet separated in a similar way. For example Item 15was amazing#Item 23not as good. Item 1#Item 2#Item 3#Item 4#Item 9#Item 2 I have attached a link to a dummy base.

Hi Guys, I am completely new to this type of database, only experience comes from excel/sheets, so forgive me for my basic question but none of the videos shows a true step by step for a simple lookup, and it is quite unclear what to link with what, I do not get results… What I’d like to do is simple: Create a table with dfferent client Types with different unit prices. eg. Small Medium Large and in a parallel column: 5 10 20 for unit prices. Creatw another table where client Types are listed ( not entered, but they are calculated based on an IF formula, that I managed to do based on their employee count) Assign unit prices to those client Types based on the first table. Third one is my problem, no matter how I am trying to link stuff, no results appear, sometimes empty additional columns are added to either of the tables… Quite lost here, thank you for

I need to create a summary table that counts the number of times an individual product shows up in a list of linked records. For example, I have a table called “Assortments” and a table called “Fruits” that are linked. Assortment 1 has 2 apples and 2 pomegranates, while Assortment 2 has 1 apple and 2 pineapples. A third table, “Orders”, lists the assortments ordered. How can I summarize the data from the “Orders” table into how many of each individual fruit has been ordered (X apples, X pomegranates, X pineapples)?

Hi ! What I’m trying to do is a basic relational DB behavior, but I can’t find my way in AirTable. Here is the idea… I have 3 tables interacting for this problem : table “Clients” table “Appointments” table “Invoices” Relationships through “Link to” fields : Appointments <— many-to-one —> Client Appointments <— many-to-one —> Invoice Invoices <— many-to-one —> Client In the Appointments table, when I link to an invoice, I obviously want to see only the invoices linked to the correct client. (The incomplete invoices are created beforehand) Therefore, in the Appointments table, I want to filter the Invoice choices only to the invoices linked to the client of that appointment. As I understand it, a filtering based on a view won’t be of help, since I can’t create a view for every client in my base… Ideas ? Tips ? Help ? Is it even possible in AirTable ?

I am very new to AirTable. Here’s what I would like to accomplish. An email is sent to AirTable, which is then triggered/processed because it contains a specific subject of “Inventory”. AirTable then looks at the body of the email and looks for fields with thier values. For example, the email could look like: Body: Batch = 000012 User = Mary Jane Usage Type = Discarded I would then have a table in my database which contains columns named: “Batch”, “User” and “Usage Type”. I would like the values (after the equal sign) to be added into their matching columns as a new record in the table. I have a method for creating the emails, and I can have them formatted in anyway to get this to work correctly. I looked into Zapier which appeared to be my only solution, but even that I struggled with setting up. Any kind of advice, tips, articles, videos, would be greatly appreciated!

Hello! I’m creating a database, where I’m trying to analyze the results of my advertising campaign. I push the data to my main table via Airtable API. Among other things, my data contains the ad id and user name, who was clicked on this ad. One ad may be clicked by many users, one user may click only one ad (one-to-many relation). How can I automatically create a table, where I will have all unique ids of ads in one field, in the second field - all user names, who clicked on the ad with the number from the first field, in third - number of such users? Also, I have the ad budget and I need to divide it on the number of users who clicked this ad

Hi I’ve experienced trouble receiving forms from others. It’s happened twice - someone submits a form and receives the post-submission message, but then the record doesn’t show up in the base. Nor do I receive an email notification. It doesn’t happen all the time though. Most of the time it’s working alright. I was wondering what went wrong? I’m based in China and I use VPN, but those submitting the forms probably don’t. Don’t know if that’s relevant or not. Thanks in advance for your answer!

often need move record to another base in my record via right mouse click

Hi there! I am a public speaker, and I would like to use Airtable to track my “gigs”, from point of interest until they are complete. This will help me track documents and vital things I forget due to the long time frames this involves. One thing I am struggling with is that Gig start days and times are inconsistent. Meaning, I may do a full-day workshop for an organization, and that’s easy. But sometimes they want me to do two workshops, or smaller trainings split into multiple days but they are all part of a series. Currently, I have to add each day/time in as a separate Gig, which makes me cringe because they are NOT separate, but rather nested as part of the overall gig. I would like to not have to use multiple tables for this–is that even possible? Any ideas on how I can lay this out?

I have a table with a date and numeric field. It tracks a water meter reading. Is there any way that I can calculate usage by taking the current record meter reading and comparing the difference between that and the previous records meter reading then calculating the number of days difference between the current and previous record to come up with a litres usage per day? Thanks in advance.

I tried searching the forum but could not find what I am attempting to do. My objective is to create a Case Study and Employee Resume master database. My goal is to be able to select an employee, select a project that the employee worked on, and then receive an output that shows that employees resume description for that project. I’m stuck on how to achieve this in Airtable. Here are my tables so far: Case Studies Project Name Client Name Role State Employees that Worked on the Project Description of Project Role Firm Played … Clients Client Name Projects (linked) Main Contact Email …. Employees Employee Name Title Projects Employee Worked On (Linked) I’m not certain how to get to the next step. Where should I store the employee’s project description when I have 65 employees? Can I do conditional formatting to be able to