Im trying to set up a BOM (Bill Of Materials), but i have thousands ind different categories and subcategories. I though it could use the use the new dynamic filtering in the the link fields, but as there a many seperate sub categories depending on t...
Hello everyone,I'm a beginner on Airtable, I don't really know where to post this message, so sorry in advance if it's in the wrong place, I have some ideas for resolution but it could be in automation, base design or then formulas, I chose to post i...
Hello - I am new here and trying to create a base for following cash flows in my various accounts, cash or petty cash.Thanks to sources I found here, I succeeded to create deposit and withdrawal through two tables, one for accounts and one for transa...
Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields: Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, ...
Hello! Use Case: New Employees start at our company and we input a load of default events/meetings into their calendarsI manually input Start Dateand I want an automation/formula to inputDay 1 Start Start Date (ADD TIME 9am)Day 1 End Start Date(ADD T...
Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done A...
I am trying to create a scheduling tool in Airtable to book appointments with outside clients. I created a form that is linked to schedule availability and includes name, role, email, etc. At the bottom of the form, they can choose a date/time. Is th...
Hi! I'm trying to make it easier to check which cell phone carrier a person uses based on their phone number. Right now I have a formula I use, but formulas can't appear in formsThis is the formula I use: IF({Phone Number} = BLANK(), '', CONCATENATE(...
Hello, I am using the Airtable API in javascript. Currently I am using the select method based on the documentation, and I am trying to make use of the returned data outside of the method.For example this is my code: base('TestData').select({ vi...
My Table A is a list of Staff members, and is linked to Table B. Table B are records of Agreements, with one of the fields being Company (the company name of that Agreement. We have several companies). A record in Table A (Staff) has multiple Agre...
