I am trying to come up with a calculation of the parts I need to batch-produce a product.I currently Have tables for: Products, Product Variations, Parts, and Production Plan.For example, If I need to make the product "Tea Light", this comes in small...
I am new to airtable. I used this Standard Deviation STDEV - Quick Reference - Airtable Community to calculated the standard deviation. However I have 5 fields in this table and sometimes only 3 or 4 values are entered. I would like to only consider...
Hey everyone!I’m running into a challenge while using Airtable in conjunction with Fillout forms. When using the duration field in Fillout, it only provides the exact times (start and end) rather than a length of time in between. To simplify things, ...
I am wondering what Record comments can be used for. It looks like Record comments aren't accessible by formulas, automations interfaces, etc. That is, I can't create a formula that tells me if there are comments, that returns, the comments, etc. I c...
Hey everybody,I am trying to match 2 columns to see if a name from column 2 appears in column 1 (list of names). The answer I need is simply true or false.Column 1 is a lookup field with a name.Example: “Smith, Jack”.And column 2 is a list of names. ...
Hello, I am stuck on something that seems simple, and I've tried navigating the answer here, but still can't get my formula to work.I have two fields I'm working with, a check-in field, which is a dd/mm/yyyy field, and a check-out which is also a dd/...
I have a table with all our fiscal weeks, and their corresponding start and end dates. ("Fiscal Weeks")I have another table with projects, and the start date of each project. ("Projects")I need to add a column to the Projects table that tells me whi...
Hello,I have created a check Request form in my system. For some of our transactions we will deal with multiple transactions but I only want to have one button. I have created multiple fields (Fee #1, Fee #2, Fee #3, Fee #4, Fee #5). I am trying to...
Hello,I have a table that is synced with transactions from my bank account, but I need help with extracting data from a JSON string stored in the Notes (Long text) field.An example of the JSON looks like this: { "transactionId": "2022142460021", "end...
Hi, I have a table that contains the first and last names of people and what I’d like to do is to have a field beside this that counts the number of times a first name + last name shows up in the table. This is because it is possible that I can have ...
