Base Design

HI, I am new to Airtable. I reached for my query before i am posting this in forum.Let's say I have 2 records.ID, Type, Item,FYxx_Total1, Fixed,A,2001, Fixed,B,1001, Variable,null,0As you see, ID is 1. When the user enters the FYxx_Total, the first and the second row shouldn't be editable. Meaning, user shouldn't have the ability to alter the numbers for the Type = "Fixed". The 3nd row, I want user to enter the data for this ID: 1.is it possible to achieve in Airtable?

Hello all!We are a small company setting up production. I don't need to use AT to track every single part, but we want to use it as an engineering tool to track prototype lots and parts pulled in for inspections, testing, experiments, etc.I have used the API to automate the creation of parts and automated test logging, and have designed some forms for Real Live Humans to update and add comments, requests, etc.The core of what I have built so far is a PARTS table, with one entry per individual part, and then an UPDATES table which has multiple entries for each part, referenced back to the key in the PARTS table.So, for example, when part ABC is tested in the color testing machine, my API will first check for an existing entry in the parts table under it's SN (say, SN=101). If it doesn't exist it's created.Then it will log the test by adding a record to the UPDATES table, with TYPE=TEST (selection) and DESC="COLOR" (text).If we then move it on to the Stiffness test, it will add a record

What could be causing the Pivot Table extension to have a different sum than the grid view the pivot table is pulling from?I have a table with 35K records. Each record is tagged as an expense payment or a revenue collection. I then have a view called "Expenses" that filters for only the expense records (around 25K records). I also have a date associated with each record. I group by category in both the Expenses grid view as well as the pivot table. Since grouping by a date field in a grid view does not allow buckets like pivot table does, I have a formula field that does a grouping date string: DATETIME_FORMAT(Date, 'YYYY-MM (MMM)')If I use the date group in the grid view, my totals for 2023-01 (Jan) in the grid are $-1,751,223.80. However the pivot table (grouped by date and bucketed by month) for 2023-01 shows $-10,121,244.13. Very different numbers.I have found that if I filter for less records, the numbers match between grid and pivot. I also found if I change the pivot table to us

Perhaps this is an introduction/need for pivot tables. I have a form collecting multiple submissions per brewery. I'm trying to create a menu that could draw from a table that shows the summary of those 4 submissions per brewery.If I create pivot table, which I'm not experienced with, it seems to count each column as an extension, so I would need to upgrade to accomplish this. (Which I don't want to do, if I'm not certain it's going to work.)I'm relatively familiar with Airtable, but not in advanced manipulation. I have it setup with breweries as the primary records, because they're using a form to submit multiple beers per entry. However, now I want the beers to be the identifying record, while still maintaining their brewery info (contact, distributor, etc.).Any help will be appreciated and you will be supporting craft beer in the process!Thanks in advance.Cheers.

Hello there community,I have an issue I'm not finding an answer to in this wonderfully useful forum. Perhaps I'm just not searching correctly.I'm using a system of entering Purchase Orders where we have an internal SKU and a supplier SKU. These are one to many. There can be many supplier SKUs for a singular internal SKU. I'm in construction, so for example, the internal SKU is a 16ft 2x4: DL-SPR-#2-2x4-16. An example of a supplier SKU is 20416S.When I'm receiving invoices, I'm entering the supplier SKU which allows my system to link to an existing internal SKU so that Airtable knows everything about that product (width, thickness, length, weight, etc, grade). However the other way around - if I want to generate a purchase order with the supplier's SKU on there (so they know exactly what I'm asking for, no confusion...) I'm having a hard time conceiving how I can look up the supplier SKU when the user might not necessarily know what that SKU is. So, the user might want to, for example,

Hi all, I think I’m getting crazy trying to use the Airtable. I tried it because I wanted some sort of simple database with some simple “app like” interface to submit hours and payment for the hours. I did not wanna overcomplicate and use database and start learning something like wordpress. Currently it does not seems I could avoid that. What am I looking for is to simply create a database with table for hours that can be submitted by the form where table 1 catching Start Date (date/time), End Date (date/time), Number of Hours (end date - start date), Price (Number of Hours * 250), table of payments that I will submit by the form from table 2 catching the Payment Date, Payment Amount. The problem that I’m not able to solve when using the documentation is how to get the Table 1 SUM of Price - Table 2 SUM of Payments. Honestly it is ridiculous that Airtable suppose to be to user friendly way how to create apps or even connect apps. Can somebody give me hand how to do those without pulli

Hi there -I have a base that we use to coordinate our deliveries and our pickups for our drivers. I have a view that is built for our dispatch team to "route" our delivery schedule for the next day that is filtered by all deliveries and pickups that need to made tomorrow.I have a separate view that is for our drivers to show all deliveries and pickups that need to be made Today, so that when they clock-in in the morning, they can see their route and begin going through their schedule. I need the Delivery view to adopt the routing order that was made in the routing view day-prior.How do I make that happen?

I'm super new to Airtable. How do you add a new table to a base? Sorry for the newbie question!

Hi, So I have a table called Daily Hits to which my Touchpoints are linked to - so a day might have 30 touch points as an example - I’ve created another table called Journeys… what i want to do is have a number of columns representing a customer journey - each column would be a step as an example… and I need to make sure that step is done or how many of htose steps are done. So for example my Touchpoints include ‘Booster Shots’ where I send a prospect some information - in the Journeys example if I have 50 rows of prospects I want to have a column for ‘Booster Sent’ and so I could quickly see how many of the prospects got a Booster sent - for that I was thinking I could create a lookup field for Touchpoints… like a Loopup… but have that Lookpu filtered by only those that have a Type of ‘Booster Shot’ don’t know if this makes sense but any input/help would be much appreciated. I should probably make a video one sec share.getcloudapp.com – 27 Nov 22 Screen R

Hi I have a question - Im a neewbie so excuse my ignorance. My primary field consists of 300 sporting fixtures throughout the year which take place at 26 different venues, so the venue is repeated throughout the year meaning the ‘value’ in the primary field is not unique.(one venue could have 20 fixtures) How do I deal with this as I’m worried this will cause a problem down the line.(from my research it states primary cells should be unique) I could merge the date and venue fields to the primary field creating a unique record for each cell? However, I suspect there is a better structure? I have attached a screenshot to illustrate my query. thanks

help me please, I am designing an app that takes photos the idea is to register those photos in airtable, but I have not succeeded, someone to guide me please, the idea is to take the photo fron cellphone and save it in the database

Is it possible to use airtable form (or otherwise) to create a e-shop? I have a WIX website in which I embed my airtable forms and a square and stripe account. I don’t want to pay for any other software How would I do this? thank you for assistance!

Hi Airtable friends, I’m trying to design a calendar & job scheduling functionality into our existing airtable base. Our small company currently uses google calendar to schedule customer installations. I’m not clear on how to set up the functionality we need and hope maybe someone here can steer me in the right direction. Or show me a base that does what I’m looking to do. We have a base with contracts that include a variety of related information, with the unique customer contact information in a related table: Customers and Work Orders When we schedule a work order for installation, there are 3 possibilities: Scheduled for a single day; job is completed same day Scheduled for multiple consecutive days; example: Start work Monday, finish Wednesday - 3 day installation Scheduled for multiple non-consecutive days: Start work Monday, work Tuesday, return to finish following Wednesday. #3 is the scenario where I’m stumped. Each work order is a single record, so a Start Date and an E

I work on an editorial team and we are trying to track links between articles on our site. Right now I am manually adding inbound and outbound links via a “link to another record.” What I’d like to do is only add outbound links and have any article that I link to as an outbound link automatically appear as an inbound link in the appropriate record. For example, I have articles 1, and 2. I want to link to article 2 from article 1. If I add 2 into the outbound link column in article 1’s record, could I have article 1 automatically show up in the “inbound links” record in article 2?

I am trying to write a query of row number function in aws athena with 3 union queries, but my query fails stating “only one select statement allowed”. Any help would be appreciated as I am new to sql eg: ( select id, name, address from table 1 ) UNION ( select id, name, address from table 2 ) UNION ( select * (select id, name, address, row_number() over (partition by id order by id) from table 3 ) as "t" where "t".row_num =1; ) Note: I am doing a row_num on 3rd table here because i want only unique values from 3rd table and distinct doesnt work directly on column using athena

Hey all your Airtable users, I’m trying to use AirTable to do some of my accrual accounting for a small school, we used to do it via Google Sheets in a relatively manual process. I want to recreate something like this, but using a webhook to receive information from stripe, and automatically filling up the amount received, split into the months according. The problem lies therein. The students pay in a lump sum of 8 lessons, and each lesson is, for example every Monday of the month. The students can join at any point of the month. So for example: Student A goes to class on Mondays and joins us on 7 Nov 2022 So on 7 Nov 2022, Student A pays us let’s say $80 This $80 covers the dates 7 Nov 14 Nov 21 Nov 28 Nov 5 Dec 12 Dec 19 Dec 26 Dec So on the accounting, it should show that Student A paid $40 in Nov and $40 in Dec But let’s say Student B joins us in 31 Oct, and pays $80. This $80 should cover: 31 Oct 7 Nov 14 Nov 21 Nov 28 Nov 5 Dec 12 Dec 19 Dec Meaning, Student B’s $80 should be a

I have a base where I have a table that is a list of product names. I have another table in the base which is a synced source of data from emails, where I have the same product names and a few other fields coming in. Basically, the goal of the exercise is to somehow indicate to the person creating a new record that the name they just created already exists in the synced table. Ideally, this would be a signal in another field on the table, such as a flag (already exists). In which direction do I need to do a linked record field? I can’t use the product name as the linked record because they may actually be creating a brand new one that doesn’t exist in the synced table, and that’s fine. How do I pull in other fields from another synced table if the record name matches the other table? I can’t figure out how to arrange my fields. Target table: Product Name Synced Table (the one I want to pull stuff from): Product Name Product Id This feels exceptionally simple and I’m way overcompl

I am new to Airtable and having a hard time finding solutions in other threads, so thank you in advance for any help you can provide! I have two tables: one is “Courses” and one is “Workshop Planning.” I have an automation that creates a new record in Workshop Planning every time a record is added to Courses. I fill the Workshop Planning records with tasks to be completed for each course. The Workshop Planning table is grouped by Course name in order to keep all relevant tasks together. What I would like to do is show the percent of tasks completed in the Workshop Planning table, in the Courses table. So each Course record would have a “% Completed” column that would automatically calculate as tasks are marked Complete in the Workshop Planning record. Is there a way to do this? It would be very helpful for managing our team workflow. Thanks!

Hi This one is driving me nuts. Am sure I am missing something simple. 3 x tables - Objects Crates Trucks Every object has a crate - so that is easy. Some crates contain several objects Crates are loaded onto the truck and I have a view which shows crates that are still to be loaded (If the Truck # field is empty it is not loaded) BUT!!! Some crates, which contain an object, are quite small and get packed in a bigger crate. So on my crates table, I have another linked record field, which links to itself so I can show when a small crate is packed into my big crate. So my “Loaded” view only shows the big crates that are on the truck. The smaller crates packed inside a bigger crate don’t show as being unloaded. Am sure as soon as I post this I will figure it out - but I have spent a good couple of hours so need someone cleverer than me to help! Read only link to a temp base to demonstrate this is here : https://airtable.com/shrK947lGGUOBNOvq Any tips much appreciated! Andrew

Hi! We are a construction company and I need to create a form for what we call ‘Service Ticket’, i.e. the form should include data like job number, job name, email and phone info etc. - all of which is included in a table we named “Jobs”. The purpose of this form is to print it out once filled and hand it to the employee who will do the service work. In AirTable I have only found the form view which creates the form but the form has to be submitted (?) and it cannot be printed? Is there another way in AirTable to create a simple form that can use the data already in AirTable and be printed out? Thank you!

Is there a way to auto-number. it’s like I need GVE001 to VGE250. is there an easy way to do that?

I am not an Airtable expert, so I will explain what I am trying to do, and it may make sense to someone who can help. I am creating a base to track employee training. Monthly, I assign a program to each Employee under a field called “TO DO.” The Employee certifies they completed the program via a form that flows into my table called “Tasks” So, for each Employee, I have a “To Do” field and then a “Completed Certification” field. The form they complete cannot have any prefilled employee information in it but can have a prefilled topic (program) included. In the base, I have three tables. “Tasks” are the certifications employees complete via a form or HR entry. “Programs” are the trainings to assign. And “Employees” are the 400+ employees who need the training. Each Employee has a view (shared URL) in the “Employee” table that shows them what programs they completed and what programs are “To Do.” I have the Employees table linked to the Tasks table. And the task table linked to the P

I have three tables in one base. In each table, there is a Name field and a checkbox field named “Flag”. How do I create one “grid” (or interface or anything else) that lists only the record names from all three tables that have the Flag checkbox checked?

In my training base, my tables are “Tasks,” where I assign their program. The linked field, “Elink” looks at the table “Employees.” The primary field in the employee’s table is the four-digit code. I have their full name listed in a separate field. How can I see the employee’s code & name in the Elink field when I look it up in the “Tasks” table? Wendy

Trying to build a base of questions that we can use to build different questionnaires and then the ability to build a library of linked answers i think i have the schma in mind but the form dont not seem to support what i was thinking of…