Base Design

We are trying to determine if we can use Airtable to help with our perfume formula creations. Right now, we use one spreadsheet for each formula experiment. As we look at how to structure it in Airtable, we have thought that each experiment would be a new table, which would allow us to change and adjust the records for the parts per thousand [Inital Amount] for each ingredient. We are including an image of the table to help illustrate the idea. My question is whether this makes sense as a way of working with Airtable. Should each experiment be its own table or can this be done with each experiment being one field? Any insights you may have will be much appreciated. 

I am building a new base for my company's Inspectional department to help the coordinators input and track historical, ongoing, and schedule inspections for our housing agency's low-income housing vouchers.We are tracking a combination of inspectional protocols: Move-In - When a person moves into a new unitAnnual - The yearly inspection for an ongoing participantSpecial inspections. I broke it down into five components (tables) to reflect the relational data that I want to connect with bullets that represent the fieldsParticipant (Voucher holder):  Last NameFirst NameHousehold IDLanguage PreferencePhone Number EmailProperty Owner

Hello,I am new!  Been watching and reading lots of tutorials but I just can't wrap my head around this one... I am a flower farmer and I deliver to a set of customers twice a month.  They are not always the same day.  Last year, I looked at everyone's requests for the month, manually put it into a google calendar and manually emailed each customer each month.I have all my customers in a table, then I tried building out a 'tasks' table and using calendar view.  I see that each record is considered a 'task' and can have one date on the calendar.  If I enter each customer and give it a label of what delivery they are on, I can create one task per delivery, but that means I am entering each customer twice a month (see screen shot)- this seems like a lot of redundancy (and room for human error). There must be a better way to set this up!  I would love the help!!Once I get it set up, I'll automate it to email the customers the

Is there a way to completely lock a tab so certain people can't access it?  Example: I have 2 tabs for 2 separate clients. I need these 2 clients not to be able to access all tabs.

We're using a base to track actual work done on multi-project invoices, but the invoices from different vendors format the info differently - some tell us a percentage of the time worked spent on each project, while others tell us $ amount subtotals by project. I have a table recording the actuals from each invoice, which includes a "Project Percent" field and a "Project amount" field, and I can enter the info on each invoice in either field and leave the other blank, but is there any way to have the populated field do the math against the invoice total to automatically fill in the other field that's left blank? I can't see any way around the problem that having the fields update one another reflexively would cause a circular logic error. Anyone have any ideas on how I can automate filling in percentage when I have $ amount, and fill in $ amount when I have percentage? 

Hi All,I am hoping there is a way to get some custom code written that can be inserted into Airtable to do the following.In grid view, the rows would be tasks, the columns would be clients. The cells would have a stop/play button and show how much time is recorded against that task/client.I have looked at the time tracker extension but I don't think it can do this.Is it possible to get someone to program this for me? Or is this too crazy of a request!?Thank you!

TL;DR: I've come up with a Rube Goldberg machine of a base. Is there a better way to organise this?  I'm managing a small school. I'm using Airtable for organisation, Mailerlite for emailing, Zapier to connect the two, and Fillout for sign-up forms. Probably this doesn't count as complex for most of you wizards, but I'm having a hard time finding an efficient workflow!Currently, I've got this going:A form table (Fillout integrates with Airtable and links to this table). Each record is a form submission, so some records may reflect the same student, perhaps returning for an advanced course. An Airtable automation checks if the course a student wants to join is full, and if it is full, updates the record to join a waiting list instead. Zapier checks a view here to add or remove students from the corresponding group on Mailerlite.A courses table, and a Mailerlite group table

Is it possible to export a multiple select list in one field into a separate table? For example, I have a field in one table that is a Multiple Select field of Categories. I want take that list of Category options and export that list (i.e. each option as its own record) into a separate Table so I can further work with that data. Is this possible? Thank you in advance for any ideas!

Hi all,For a table as shown above, where only field "item nu" and "Scale" have distinct values for each row while other fields share the same information, how can I automatically fill in the other fields with the common information as shown below? I understand that I can select and drag, but when it's a large table imported from google sheet, is there anyway to automate this?Another question is, if I want to keep one row for each SKU which will put multiple item nu/Scale in one cell, is there anyway to still keep the one-to-one connection between item nu and Scale?Thank you all in advance!  

Hi all, I'm creating a form for volunteers to submit hours. I'd like to build a form that asks if they are new:if no find their information already submitted (name, email) and then let them submit hoursif yes enter in their information and then let them submit hoursI know how to do #1, how could I do #2 allowing them to enter their new information?Thanks!

I am trying to get a sum total of all the hours, demos... Where they can be displayed in an isolated field or additional table. I have tried roll-up and look-up fields into another table with no luck.  

Hi there community,I've been using Airtable for 6-8 months now, mainly as a way to keep track of material prices for a prefabricated home manufacturing operation.  Purchase orders and requests for quotes are entered into the system and a cascading set of tables with increasing levels of specificity allow me to view material prices by something as refined as a supplier SKU and something as broad as "dimensional lumber" - by ft2, bd ft, ln ft, or whatever other metric I want to have.  All that to say that the structure is pretty well built out and working quite well for me, but the more I build it out the more I am intimated by changes like the one I want to make (though I do know that I can duplicate a base to play around there and not risk losing key relationships in the data).We're looking at more heavily integrating this directly with the design software we use (Cadwork), and I've realized that the mechanism by which I've developed my Product IDs - a formul

Hey,I have a video uploading bug since some days.To be clear, we created an editorial calendar at work and when we try to upload videos, it takes soooooo long to be done until it finally does not work.Is it possible that we uploaded to many videos ?Do you ever met this problem ?Thank you for your awnser. 

Hello AllI have a question trying to make sure I am thinking correctly about my data. I have drivers that complete stops every day for almost all the same stores. So in a week, they can visit the same store 2 a week. I want to use airtable to organize the data and do formulas so that I will calculate the Gross, and Net for each route.So here is my question:I am thinking about having a table that is for Stores (customers), Then having a table is for deliveries.The store's table will have the following columnsStore namezip codeThen the Delivery table will have the following Column

Hi. I'm trying to figure out how to use a Lookup Field to update another record in the same table. This is a simplified version of the workflow to illustrate what I'm trying to do:I've got a number of records, called "Sequences." I need to define the relationship between them, and track which one comes next and which one comes before. In the image above, those relationship are defined manually. In the below image, I've replaced the manual versions with Lookups:What I'm seeking to do is this: when I specify the record for the Next Sequence, have that Sequence's record automatically update it's Previous Sequence field with the corresponding record. For example in the below image, in record Sequence 4, when setting Next Sequence to 5 - I'

I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. where the race date matches the date of their training score), I want to add the training score (from 3) into their race record (2)Is this possible with lookups? Or would it need to be an automation? I've tried both but can't quite get to the answer.Thanks in advance!

I'm designing my new base and I want to create unique Task ID's that are prefixed with a letter/number combo that links to the site the task is for so DE2 and HGE. The Task ID will auto-create every time I create a new recordFor example: Create New Record > Task ID is generated (DE2_000001)Can anyone help out? When I done this at a previous company it seems that there was a Field called Site Code that looked up to somewhere then the ID was generated u sing a formula

Hi All,I have three tables in my base:1) customers 2) venues 3) staff and I want to autogenerate a schedule which matches the customer criteria to the right venue and the right member of staff. Does anyone have any ideas of what I can try to produce this? Bit of a noob when it comes to airtable but some experience of databases and a fundamental understanding of tables and forms etc. 

Hi All, We're in the medical field and we are currently setting up airtable to handle our inventories for multiple locations. We have set up our product lists, as well as the inventories for each location and we're currently in the process of utilizing the purchase order option.We can add from each manufacturer, and item, but we're currently stuck on being able to add a quantity for each item-for example, let's say we need a quantity of 100 for one item, and 500 for another, at this time we can only add a quantity for one item. I've added a screenshot to explain what I'm talking about.  Much appreciated!  

Hello, I'm working on a new database and one of my tables includes various types of barcoding equipment.  Each record should have its own unique Serial Number, so I made Serial Number my Primary Field for that table.  I thought that, by default, the Primary Field always required unique values but I've just tried entering a duplicate S/N and it allowed the entry. How can I make sure my Primary Field doesn't allow for the same value to be entered more than once?

Whenever I change the order of fields in one view, I then have to change the sane view in other views one at a time.  (I know I don't have to, but I want to!). Is there a way to change the order of all fields in all views automatically?tia

I'd like to create a new table by importing from an excel worksheet. There will be 30+ fields and i want the single select options to be True and False.When i've tried to add the single select options manually as answers and then convert the field to be single select, it reverses the order. on my survey, i do not want the answers to be False and True, but True and False. Is there a way to do this without going through and manually changing every single field to single select and re-ordering the options for each one? thanks!

Dear Helpful People, I have one base ("Base A") set up to sync to a second base ("Base B") and it was working fine until about 20 hours ago. Base A has a multiselect field that isn't syncing properly to Base B. In Base A, the multiselect field is 100% filled, but Base B the field is only 44.44% filled. In Base A there are 9 options to choose from and it seems like Base B isn't displaying the data for the cells that only have one option selected...I'm truly at a loss for why this is happening and I'd greatly appreciate any insight. Thanks!Erica 

Hi,Can I import a spreadsheet (via Google Sheets or Excel) that includes "Link to Another Record" fields? When I try using the importer, it says the field type is not supported, but it's an important workflow step for how I'm using Airtable. Thanks!

I first started by using the org chart base template offered by Airtable to add my employee roster details and it spit out a beautiful org chart (parent relationship being manager to subordinate) - no complaints there.However, I now want to take this to the next level.I create a new tab on this base, where I listed events. On this tab, I linked employee names to specific events.I now want a separate org chart extension to populate with specifically the events they are assigned to. Parent relationship being Employee to Show Name.When I tried this myself, nothing populated. What am I doing wrong?Is anyone able to hop on a zoom with me and help me out?