Base Design

I run an acting school- and have a google drive folder full of about 1500 scripts. I’ve created an index of those files with links to them (in a google extension), then imported that list into airtable. We then went through and painstakingly added searchable info and a clickable button for each entry. So now we have a sharable view that students can search by age, gender, genre, etc. But we continually have new scripts coming in…and I’d love to skip the step of manually indexing the new scripts and pasting that into the airtable. Using a form is too tedious for each individual script we get in (cause it’s a lot) Is there a way to connect an airtable to Google Drive so that it automatically dynamically INDEXES a google drive folder (with LINKS to each individual file). That way when we get new script we could just drop them in the google folder (and add searchable data down the road into the proper airtable row) OR- is there an easy way to batch import FILES into an airtable (so that ea

I’m new to AirTable, but have been a FileMaker developer for many years, and I’m trying to figure out the AirTable way of doing things. I wrote a simple time tracking application and I would like to create invoice line items from each of the time slips. If I’m creating an invoice for a client, I want to find all of the time slips that haven’t been invoiced previously and create an invoice line item for each one of them. I realize that I could use the time slips table itself, but I might want to combine some, change descriptions or otherwise alter them and I want the invoice to be independent and “locked” after they are sent. I know how I would do this in FileMaker, but what is the best way to do this in AirTable. You can assume that each invoice line item would be filled with the Date Created, Customer, Product, Description and Time Worked.

Hi! I’m new to Airtable and without much programming skills. This is what I need to do: I have a column with company URLs I’d like to automatically fill another column with favicons from those URLs Is there an easy way to do this?

I want to create tables so I can add only text data to the table to query in GraphQL and I will use it as a link like this image below. How can I do that? Thank you in advance!

Is it possible to create multiple links between one table and another? For example, can I link from Table A to Table B on both a Record Number and have a separate link by Company Name? I think the answer is no and that I should use a concatenated field for my primary field if I want to do that, but want to make sure.

What’s the best way to go about designing a table so that my team can duplicate multiple records at a time? For context, we are grant writers, and we want the tasks and subtasks for each grant to be the same. So I created a template that has 8 records. Right now, we have to make a copy of each record of the template and assign it to the correct grant. That of course leaves room for error. How can we duplicate the template Tasks at one time? Thanks in advance.

Hello, i love using emojis in my airtable base/table/view/fields… but i did not find any easy way to get them. emoji shortcut on mac “crlt+cmd+space” works when i use airtable on Chrome But when i use the desktop app (mac version), i have to go to the Notion Desktop App !!! …to get emojis and copypaste them.

I have some experience with relational databases (Access/Quickbase) but was intrigued with airtable capabilities. I am trying to create an inventory management solution to fulfill my orders that come from shipstation. I already know I can import orders from shipstation into airtable by way of zapier. Most of the functionality I need I already know exists in airtable. My javascript skillset is limited. My question is there a way to implement asking somebody to input a list of unique serial numbers(could be hundreds of those at a time) and then associate those serial numbers with either an order or a purchase order? Then mark those serial numbers as either in stock or out depending on whether it is a PO or an Order?

I have two bases in the same workspace. Base A with records 0001 to 4999, and Base B with records 5000 to 9999. I want to combine the two bases into one new Base C with records 0001 to 9999. So I duplicate Base A, rename the duplicate Base C, which at that point contains the records 0001 to 4999. Then I copy records 5000 to 9999 from Base B, and I want to add them to Base C after record 4999. And that’s where it ends, that is not possible, because I can’t find any way to add them. When I click the + for adding a record, then I get the message “Record moved”, and a new record is created at the beginning of the base, so it makes a new record 0001. And if I try to copy multiple records, then I get the message that I’m trying to perform a paste that overwrites all the records in the base. So records 5000 to 9999 are not added to the base, but records 0001 to 4999 will be overwritten. I know I must be doing something wrong, but I haven’t any clue what that could be.

Hi everyone I am new to the amazing world of airtable! I run an interior design practice. Just me at the moment, but want to set things up so I can have a team in future. I sell my time to do design work (hourly or fixed fee), and I sell products (not from stock), so I need airtable for - project mgt - each client house is a project with tasks, probably with sub tasks too time recording - ideally with a timer, but retaining historical time entries product library and creating proposals of items for each room / house I work on So… do I set up one base with lots of tables, or two, or even three (one for time)? Considerations are - I want to get this right from the start! (don’t we all) I may create proposals/invoices which need to include my time, an agreed fixed fee, and/or products. I want to push these through to QB. as I will add attachments to products and projects I am also a bit worried about storage limits per base too, which made me wonder whether more bases is better. Let m

Hello there, I’m building a base to manage activities. Table 1 is a registration form. Table 2 is the listing of activities with a rollup to track the number of person for each activity. I want to add a limit of person for each activity and block the activity in the form when limit is reach. Here’s a view :arrow_down: Anyone can help ?

Hello, filters are no longer displayed in the android app. Previously, everything was fine

Is it possible to use the values in a field to populate a single-select field in a related table? Example: Table A has a field Color with 5 records. The values in the Color field are: red, blue, green, blue and red. This results in a single-select field, also called Color, in Table B with red, blue, and green as the options. The options would update when I add a record in Table A with purple in the Color field - resulting in these options in Table B’s Color field: red, blue, green and purple.

Hi, I have searched around for someone with a similar problem but can’t find exactly my issue, perhaps someone can help. For work projects, we have an Airtable base to track the status and components of our collections (think fashion collection). Now, I want to track how long each collection dwells in each ‘status’ without having to input that information manually. We have a big team working together and each person will likely not remember every time to log how long they were working on their part of the project. We have a status table with a single select field with options like ‘design’, ‘marketing’, ‘graphics’, etc. I have a last modified field that tells us the last time the status field was changed. But I want a log of every time it was changed, and what it was changed to. I know I can look at the expanded record but that’s rather tedious. So I’ve created a linked table called ‘Status Time Log’. I’ve set up an automation that creates a new record in that table when the Status fie

Hi, I’m trying to understand Airtable better, so I’m hoping someone can help me out. I have a table with projects, the month the project has to be finished and a estimation of the revenue. The next step is to create (with a new table, because a new grid view doesn’t do the trick) an overview of the revenue per month and per year in total. I just don’t understand how to create this. Who can help me out? Thanks Jos

Hello, New I’m new to Airtable but I suspect that I can’t be the first person to run into this. My question relates to a base that is being embedded on another website. Is there anyway to lengthen the second record field so that it and the name record are only records that appear in the preview? Or is there some way to force a specific record to only appear when you expand an entry? I have attempted to use a screenshot to show what I mean. (So when you see the preview, the record field called “Suggested…” should be visible but the one called “References” should only be visible when you open a selected row up.) I’m currently playing around on the free version but I’m happy to upgrade if that gets to access to more customization options. Thanks!

Sorry for the very open and vague question guys. I am making my way across from MS Access, so am pretty aware of the structure I need for my setup, but am struggling to implement what I need. Essentially I am running 3 tables in a parent>child setup as follows: “Client>Invoice>components” Obviously the first two are straight forward, the components table holds activity booking information, notes, start times and such. I have tried the idea of grouping based on invoice and client(this would be satisfactory), it works fine with invoice, but can’t filter by client as referencing a client control through the invoice table means that I can not then create new components. I am looking for a way whereby I can have a table view on components somehow controlled by a selection in invoice, and was hoping someone out there may be able to point me in a direction. Maybe auto filling the invoice control on the components table is a possibility? Just throwing a starting block out there. I h

Hello Everyone, I’m running a community and I’m trying to create a social graph to manage introductions and connections. I have a list of Names in a Members tab, and I would like to create the following fields: Connected Not Connected …so that I can figure out who and to whom I need to make introductions. Ideally when I link Member 1 and Member 2, it creates a reciprocal link, and it also removes the Members from each respective “Not Connected” field. Thanks for your help!

Hello, folks. I’d like to make my own Airtable-based interactive tool to provide my organizations’ users recommendations for compatible and appropriate resources available to employees, which would meet their specific needs. For example, we might want a tool that would make recommendations for cloud storage. The user might need to define their needs based on the qualifiers that I pose, like types of data (public, sensitive, medical) and cost (expensive, free, cheap). The user can make selections and the tool will show compatible solutions (Google Shared Drive, Amazon S3 Storage). I would like to weigh the qualifiers for compatibility. For example, if someone chooses says they need a free option, it would gray out or eliminate commercial offerings. Has anyone seen something that looks sorta similar which I could use for inspiration? How could I create compatibility relationships in Airtable?

I have a formula that correctly shows the cost of having 1 child in a class. When the parent has 2 or more children the cost is £5 per extra child per week. They could be in either Weeks FM or WeeksSR. So far I have a column showing “extraChildren” / number of weeks /class fm/ class sr/ but my formula is wrong and I have no idea what it should be. Once I have the correct total I will need to add that to the combined Total Amount The Amount formula is already very complex so how would I add it.IF({No of weeks FM}, VALUE(RIGHT({No of weeks FM}, LEN({No of weeks FM})- FIND(“£”, {No of weeks FM}))), 0)+IF({Zoom}, VALUE(RIGHT({Zoom}, LEN({Zoom})- FIND(“£”, {Zoom}))),0)+IF({Party}, VALUE(RIGHT({Party}, LEN({Party})- FIND(“£”, {Party}))), 0)+IF({No of weeks S&R}, VALUE(RIGHT({No of weeks S&R}, LEN({No of weeks S&R})- FIND(“£”, {No of weeks S&R}))), 0) Any help you can give me on this would be greatly appreciated as no matter what I read about formula, I am afraid I can’t see

I developed a base for a simple one-time community program that is now being expended into multiple cycles. I think I have unnecessary tables and manual tasks, and am missing some elements that would help a lot. Here is the basic info (I am new to this community so not sure what is helpful vs excessive) The base manage volunteer participants in a large community program. People signup on a rolling basis. People sign up and then have options: – Just be on the mailing list – Attend date-specific, one-time events. Goal is to record who registers and who attends (data from Zoom) – Sign up for a training – Sign up to join a group Current design: People table, with form for person-level info (contact, demos, etc). Submit redirects to second form, in… Interest table, with form that asks for what they are signing up for. John Doe signs up in Spring 2020 to attend an event. Then in Fall 2020 he signs up to join a group. This create 2 records in the People table, and 2 in the Interest tabl

I’m working on a new project that has a reasonably simple structure: Organizations table People table where employees and clients are tagged as such Employees: can belong to one organization, can see all of their client records, but not all org level clients Clients: have a one-to-one relationship with an employee and organization Meta Data: 5 or 6 other tables with various data like courses, assessments, task list etc an org admin can see everything about all of their clients an employee can see everything about the clients they’ve been assigned to (and they can add courses, - assessments, tasks etc, to a client profile) a client can see their own stuff only Basically the approach I was thinking of was to create join tables for all of the meta data tables like this: PeopleCourses: PersonID (links to people table) Course ID ( links to courses table) ShowToEmployee (links to people table) ShowInOrganizationDashboard (links to Org table) I’ll be using Stacker for the

Hello Beautiful people, thank you in advance for your patience as this is my first ever posting experience. Is anyone able to help me figure out how to set up a field automation that allows my “Warehouse costs” field to be auto-filled whenever I add a product’s weight to the “Product weight” field? Basically now it is done by hand, whereas I am in search of ways to add a reference price point for product weight and have the field being filled in accordance with it. Thanks again Community people! You are all awesome!

Can you create a Base within a Base?

Hey all! I have a brand new base with some data that I imported in a CSV. It created a table called Classic Rock Songs (which is as awesome as it sounds) and populated records into 3 fields: Song + Artist Song Artist Each artist can have multiple songs (or at least the ones that were’t one-hit-wonders!), and I want to create a second table that: Lists all unique artists from the Classic Rock Songs table into the Artists table Links the records so that all songs for each artists show up in the Artists table I’m basically struggling with the first step above, and how to create a new table with unique artists. Appreciate any ideas… rock on! :guitar: