Base Design

I have a base to coordinate internally the progress of construction projects within our company, Here is how i have it set up My base consists of multiple tables, here’s a few of them Table 1 is a list of projects Table 2 is part 1 of the construction process which has multiple phases Table 3 is part 2 of the process Table 4 Track the bidding process Table 5 Tracks the billing progress in Table 2,3,4,5 the main column is a formula which copies the date from column 2 which is a linked column to the projects table Every time a new project gets added to the Project list, i need to create a new record in the other tables so our team can start adding data and track the project, so far i’m doing this manually and i’m looking for a way to automate the process.

I have been massaging data in one base. I thought I had done it right, but now find that I missed something. I want to compare the original base version with the bad one to identify my errors.

Hi! I’m trying to set up a base to collect information from students from my online course. For this I’m doing various Tables with different questions that need to be answered in different moments of the course (I’m using the form feature). For this matter I need to connect the answers they give to their respective personal information, which I ask for in the first Table. The problem I have is that I cannot ask them for their names in every form because it would be annoying, so I decided to generate a token with autonumber which I’ll ask at the beginning of each form, hoping to use this as the indicator of who’s anwering the form. I want the table to read the token and connect it with the student’s name in the first table automatically. I’m not sure it is the best way to do it neither but it’s the best one I could come up with. Extra: It would be amazing if I could make Airtable autopopulate a text document (maybe word or google docs) collecting all the answers

I work for a scene shop and we build for big clients: cruise ships, museums, theaters etc. Goal: I want to be able to view every job that’s in a department at any given time. I want to know everything that’s in the paint shop, from the fake brick panels for the cruise ship to the statue pedestal for the museum. Problem: I’ve got each client set up with their own tab. From what I’ve read this is an undesireable form of physical data organization rather than logic organization, why not have a column with a single select ‘client’ option, and create a view from that, right? My problem with that is that I have one tab with about 5000 records and about 100 different views that i’ll have to scroll through to find the data I need. ‘Client A, Show 2, Drawings In Progress’ ‘Client A, Show 2, Drawings Approved’, ‘Client X, Welding’ ‘Client X, Paint’. Tabs are an amazing way to break this down into multiple chunks of info, but I want to be able to click the “Everythin

Hi, I’m looking for someone to help me think through and offer input on my base design. In exchange, I’d be happy to do the same with yours. Mutual help. Alternatively, this is what you do for a living and you’re interested in taking on this project, please send me a PM with your fee and your experience and I’ll see if I can make that happen. I’ve drawn up some diagrams of my base design, both how my base is currently configured and also how the information is actually organized IR, to facilitate this process. :pray:

Hi! I’m currently adapting Airtable to be used as a project management and self-evaluation base for the team in my office. We’re also looking for apps to make meetings more productive (showing important talking points, register tasks for later) what do you recommend for a design like this on Airtable?

Is it possible to present the number formatted by grouping the thousand, like “100,000”. It just displays “100000”. Excel gives an option: “Use 1000 Separator (,)” This is found in cell format, under # format.

I’m attempting to use the Rollup feature for the first time, and it isn’t working as expected. I have a very simple design – A campaign table that will display rolled-up data from an Invoice table. Campaign Table: Here are the settings for one of my Rollup fields: Invoice Table: I want the rows of the Invoice table to aggregate based on Campaign ID/Record ID. Unfortunately, you can see that it is only linking one of the invoice rows – not both of the qualifying Campaign IDs. What am I doing wrong?

I assume this question will be too dumb but just out of curiosity I am interested in knowing what changes this toggling will make to Zapier while sending data to Airtable? I have 3 values to be sent to airtable via zapier If i insert them as 123,456,789 in zap field, will this all be added into one record if we toggle this on? And if we toggle this off will the data will be sent to three different records? Is that what is intended with this? Thanks in advance🙏

Hi everyone! I’ve already created a couple of Airtable bases for client & inventory management, but I’ve been grappling with a specific use case that I’m struggling to figure out the best setup for. I’d like a base that is primarily for keeping a list of a writer’s scripts on offer. Within the scripts table, we’ll have fields to categorize by script type, audience, content tags, etc. Another table will have a list of performers, and (I think??) the 3rd table would have a list of performances (or script fills). Where I’m getting caught up is on the simplest way to display all performances of a particular script, and a link to each performance. So, each script can be filled by multiple performers. Each performer can also have filled multiple scripts / created performances. I’ve set up the 3 tables; the Performers table contains all the performers and then links to the Performances/Fills table. Then I have a lookup field in the “Scripts”

Hello Community! My name is Federico. I have this issue: I am using Airtable as the Sales CRM of my company. I have 2 tables: Products Sales Orders I have the link from sales orders to Products so i can calculate to all the Sales Orders the price of that order. I am facing the problem that i live in Argentina and now we have to change prices like 1 time a month and all the previous Sales Order within this link with the products update the value of that Sales Order. How can I isolate that price so when i change the product price, that sales order price is not modified? I will be waiting for help! Thank you!

Hi Everyone, Is there a way that I can have multiple select checkboxes, I read through the community and I guess there is isn’t and people are using a formula as a workaround. However, I can’t figure a formula works on my case: I have 1 table with 3 different views, let’s say View1 “Stage1”, View2 “Stage2” , View 3 “Stage3” View 1 has a multi check field “Move to Stage2”, by defaults records in stage 1 is considered “Stage1” View 2 has 2 multi check field “Move to stage 3” and “Back to stage 1” and View 3 has “Move to stage 2” So they are Stage1 “Default” Move to stage2 Move to Stage 3 Back to stage 1 So, I want when the checkbox “Move to stage 2 “, “Back to stage2” ticked and Not Back to stage1 , nor default stage1 nor move to stage 3 gives me “Stage2” The checkbox “Move to stage 3” ticked gives me “Stage 3” not ticked Stage1 nor move to stage 2 nor the default stage 1 The checkbox " Back to Stage 1”

I am sure this is easy, but I can’t figure it out on my own. I’d very much appreciate if some could point me in the right direction. I have 3 fields: {WRITER 1} {WRITER 2} {WRITER 3} I am looking for a formula to combine them into one field. The names should be separated by commas in the new combined field. I can do the above easily, BUT: The fields are not always filled. Sometimes only one of them is filled, sometimes all 3. So I need IF statments in combination with =BLANK() I can do it for WRITER 1 and 2, but I can’t get the 3rd one in… Thank you in advance! I am lost.

Hello! I’m new to Airtable but not databases overall so I have a little bit of knowledge in how to write a formula. I can’t seem to work through this one though. I have the need to be able to recall certain clients for scheduled services. I cannot for the life of me figure out how to write this formula. I need the formula to calculate off the “Scheduled Date” forward 275 days but only when the “status” is not marked as “complete”. I have no earthly idea how to make this work. Thank you all very much for your help on this - I’m sure it’s pretty basic and I am overthinking but…I’ll learn it all someday!

Hi there, Myself and @shravan_chandrashekh are working on logging AWS data for our clients and inferring some insights. We are currently adding one row for each log. We are using EC2 to parse and add the data. Almost immediately we have maxed out the row limits though. There’s very little data per row, just product links, date and time. We want to be able to show usage over time for our clients for multiple items so we are curious how to efficiently design our table in order to do so. We could add one row per day, but then I’m unsure how to populate each item with the date and time in which it was accessed? This will eventually end up in a private page/link for the clients to view so ideally they can filter by date, product, category etc. Any help is much appreciated, Allen

It is valid just for me or the server is down?

I manage an online game company and players submit bookings through an Acuity widget on our website. Zapier monitors those Acuity event creations and pushes the records into an AirTable database. Players have a window of time in which they can reschedule their session (or I can reschedule their game upon request), but I’m having a problem getting Zapier’s feature to “Find Record” in Acuity Scheduling to find the old record and update AirTable accordingly. AirTable has the following fields (all populated by Zapier): “Game Date/Time” (formatted as Date) Not unique because I have several staff who can run games simultaneously. “Date Booked” (formatted as Date, populated by Acuity’s “Datetime Created:” field in YYYY-MM-DDTHH:mm:ss-0000 format) Not truly unique, but it will be very rare to have two game bookings come in at the same second, and even more rare to have two rebookings come in at the same second. I’m willing to use this as a unique record

I have a column of IDs stored as numbers, which I can filter for one at a time using the standard operators. Is it possible to filter for a list of multiple IDs in one go? For example, select every record where the ID is in 1234,4567,8910… etc similar to how in SQL you can do : “SELECT * FROM TABLE WHERE ID IN (1234,4567,8910)”

Hi Airtable World! This is something simple, but I can’t find the answer. When I opened a new Project Tracker template, it had a Project Lead column with individual names and headshots, for lack of a better name. I can’t figure out how to recreate the names or the images. They’re actually greyed out and I can’t edit them. In a previous account, I had to create a separate table for just team names and link to that sheet. I can’t get that to work, either. Suggestions? Thanks!!

I am looking for a function that : there are two table1 and table 2, and if I update or add data on table1, it automatically syncs to table 2. and on table 2, I wanna make a column that doesn’t relate with table 1. it should be isolated.

Hello, Long story short: How to automaticaly copy/paste a text from a cell to another where it will apear as an editable text as well? I’m developing a CRM. I Use a first table “PRODUCTS” as a product list. A second one “OFFERS” as an offers editing list. and a third one “PRODUCTS LINE” to edit products lines in each offers (quantities, discounts, comments etc) On my “Product line” sheet, I would like when I call a product from the “product” sheet, that its standard descrition (a text, in the product sheet) appears as a text as well im my “product line” sheet where I’ll be able to edit it for this offer only. thanks in advance

How to put the picture of the URL directly in Attachments

Hello. Use method of Airtable is asked. Is the mounting of the following contents possible? (1) A developer attaches a picture to a form screen. (2) A query isn’t shown to a form screen and only a text is indicated. Answer, please.

Hi, i have a form with “country” field and want to download list of coountries as dropdown list in that field. How do i do that?

This is mostly feedback for Airtable on why, having been very excited, I’m now disappointed by it after only fifteen or so minutes… tl;dr at the bottom. I was just introduced to Airtable via the Wintergarten / Marble Machine X Youtube channel (and I commend you for giving them a licence!!). I thought someone had finally built the hybrid database/spreadsheet I’ve been craving for probably 20 years. But, from what I can tell, there is NO WAY to constrain fields with custom validations, such as e.g. min-max length, permitted characters, etc. This means that using Airtable for structured data capture, with a view to future data import, is STILL going to require data cleanup that otherwise could be enforced at the time the data is entered. I can see this issue is bought up repeatedly in the forum here, but generally, the answer seems to be ‘no you can’t do that, try this clunky formula-driven-status-twin-field solution’ on an auto-closed thread, with no mention o