Base Design

Hi Novice Airtable user question - advice gratefully received. I want to create a master ‘to do list’ - which I will primarily view as Kanban - which I can both add new ‘tasks’ and also pull in items from other tables; using the status field in the other tables to then organise the master to do list. The Airtable is helping me with my professional development covering working on a new business idea, networking, job hunting, writing etc. What is the cleanest way to create a grid that has ‘new items’ and linked records? How can I pull records in from multiple other tables into my master plan and create a status field in the master document that pulls from the status fields in the separate tables? So I might have some networking activities to do, some writing to finish, a job to apply for etc - each of these are currently in separate tables? I hope that makes sense. As a note, the sub tables (job hunting, writing etc.) aren’t j

Hello, I would like to create a new base with data extracted from other bases. Do you know if it is possible ? Thank you for your answers ! Marisa

Hello everyone i am new to air table and i would like to know what is the best possible way to integrate lead routing into the system!

Hey all, I have been using Airtable for a few years now and I’ve got quite a few complex tables happening these days. Which is fun. But can also be frustrating. I am wondering whether there is any table or function that will allow me to view all of my fields in the one place, along with their linkages, their field types, descriptions, and their options (eg if it’s a single select, the options to select). Does such a thing exist? A particular use case outside the general described above would be when we are planning to build a new website. What I like to do is create different tables in Airtable to wrap my head around how the new website’s database would look. But I’d be able to better plan this if I could see an overview of field links with their respective options. Basically adding in another SUPER table showing this. Any help would be greatly appreciated!

I am trying to post a gallery link to Facebook and the link posts but only with an Airtable pic? Is there a way to do this? I am interested in my Notes information as part of the post.

I have published a gallery view to my wix page and thought everything was great. Question. Why when someone clicks on View larger version does it take them to an airtable.com site? 2nd question. If I like the larger view that seems to be appropriate how can I duplicate that view? Thanks for your help charley

I am moving along quite well. Quick question about embedding on a six page. I can easily change my page size to see more, but I don’t see an option to show more of the gallery. I know folks can scroll, but my current provider allows adjustable sizes of the embedded window within the Wix window if that makes sense. Thanks for any help. charley

Hello all! I am trying dynamically update my available inventory based on dates. For example: July 22, 2020 Event 1 Gear assigned A01, A02 July 22, 2020 Event 2 // When I go to select inventory I want to assign to this event, I want to make sure that A01 and A02 are omitted from the list since they are already being used on the same date for Event 1. July 23, 2020 Event 1 // All inventory will show as available now since it’s different date. Thanks so much in advance! Joanna

Hey everyone, In table #1, I need to create a field that calculates a SUM(values) rollup of the costs associated to records in another table (let’s call it table #2). I created a linked field that links table #1 to table #2, but is there a way to link to all the records in table #2? Let’s say the records in table #2 are labeled “A” “B” “C” etc… I would like a field in table #1 to link to all the records in table #2 that are labeled “A.” But there could be hundreds of them theoretically, so manually linking them isn’t feasible. I’ve tried copying the values into the linked field, but it only returns one link in each field instead of all the records that match. So instead of summing the values in all the records labeled A in table

Hi, Question about linking records between tables. I want to create a dynamic conditions linking in Airtable. Is this possible? I only see the option for static conditions. Here is a example to explain what I want Table 1 Firstname - gender - hair color Joost - men - yellow Ria - female - brown Robert - men - brown Table 2 Groupname - criteria - names(table1field1 where condition of table2field2 = table1field2) Mengroup - men - Joost, Robert Femalegroup - female - Ria Thanks in advance, Robert

We are a charity amateur brass band in the UK which plays music at charity events and teaches music to members of the community of all ages. We have approximately 100 members and will probably not grow very much bigger. I have designed our membership and stock database on Airtable. We will have about 10 collaborators, so would never be able to spend $50 a month to install blocks. However, we are looking for a solution to be able to send group emails to the membership from the database, so that leaders are compliant with GDPR and don’t have personal lists on their computer. Do you have any ideas that might help us?

I’m new and trying to figure this out but can’t find instructions if this action is possible or how to if it is. I am currently evaluating the product for use. Thanks for any help

Hello there, I am wondering how to create a new page for air table survey forms. Thank you

Can you please help me think though how I should design this base? I want to list classes and instructors, but I’m having trouble figuring out how to group by instructor since I’m using the same table for Instructor 1 and Instructor 2 Tables: Instructors: Name, Email, etc. Class: Class Name, etc. Offerings: Class Name (linked), Instructor 1 (linked), Instructor 2 (linked), Date Sample Data Instructors: Aminta, Iman, Catherine, Franklin Class: Waltz, Tango Offerings: Waltz (linked), Aminta (linked), Franklin (linked), 8/31/20 Waltz, Franklin (linked), Iman (linked), 9/17/20 Tango, Franklin (linked), Catherine (linked), 9/24/20 The question is this: Is there a structure that would allow me to pull instructor 1 and instructor 2 from the same table (like I’m doing) where I could also group them and get all the classes taught by each leader? For example, in this data set, if I group by instructor 1, I miss the waltz class ta

I have 2 tables: Customers Workouts When I create a new workout I want to auto-link it to every customer in the customers table. Is there a way to do this? I found a ‘hack’ of sorts on the forum - grouping workouts by linked customers and then adding rows from below the group that contains all customers. But the problem with this is that I need it to automatically include any additional customers when they get added to the customer table. Any suggestions?

I created a form with airtable because I wanted my users to be able to submit their own posts which include a title, description, and an image and I wanted it stored in the spreadsheet I made with airtable. Is there a way for me to connect my form with Thunkable so my users can submit their posts through my app?

Hi, Here’s what I’d like to do. On my website, I’d like one form (Table 1) to have two fields. Twitter Handle Writing Prompt On my website, a user fills in both fields then the data gets added to Table 1 (in airtable). When Table 1 fields are filled, another table (Table 2) on the same web page will display the Twitter Handle and Writing Prompt. However, Table 2 will only show the LAST record (Twitter Handle and Writing Prompt) input from Table 1. I found this page that I thought would be helfpul: View last record only but I’m unable to make it work. P.S. I want to prevent users from adding duplicate data. I’ve added a picture to make things more clear, this is the kind of page I’d like to build. @Jacks data was input earliest. It vanishes once the next user (

Hi, let’s see if I can explain this so it makes sense! I am the executive editor of a news website. I have a content calendar table set up in Airtable, but I’d also like to use another table in the same base to keep track of my newsletters. My main content calendar table has a field called “newsletter” that is a date, which represents the day on which the newsletter that will contain this story will be sent. It also has a URL field for published stories. I would love for the URL field for the story in the content calendar table to auto-populate in the corresponding record in the newsletter table. For example, if the story “5 Things You Didn’t Know About Back Pain” had “7/27/2020” in the “Newsletter” field on the content calendar table, that story’s URL would appear in the “7/27/2020” record in the newsletter table. My questions: Is the above description clear about what I’m trying to do? Can it be done? Assuming it can be done, how

There is a currently built airtable with a field project name and information on the project. I want to make a new tab that can be used as a form. This form will allow the user to select a project name that has already been inputed and upload a picture. The picture will then link in according to project name, to a new column in the original project info tab.

I am working on a research project and trying to find a better way to view my data as I’m entering it. It will be done in stages so it’s not really like a form, I need to view all the previously entered data as I am researching and entering the new findings. Entering it into the spreadsheet table is not really working well, I am hoping to avoid scrolling around trying to see all the data.Any help or suggestions would be appreciated…

The credit balance should be over 10K in ‘Rangduju’ but now it is 120?? Please help me check if there is any weird manual operation or the system’s bug made this.

Hi, I have single select that contains several names similar to some of the names of the tables. I have linked them to the page with single select. I want it to automatically add the fields in the main page record to the page that has the name that they have chosen. How is that? I hope you can help me as soon as possible, please :smiling_face_with_three_hearts: :smiling_face_with_halo: :smiling_face_with_three_hearts:

Hello all, I’m new to the community and have been finding so many valuable resources here - thank you! I did some research on this question but wasn’t able to quite find the solution. Here is the basic layout of the two tables in question: RIGS table // Shows all our available inventory Rig 01 Rig 02 Rig 03 etc EVENTS table // Shows event details including which pieces of Inventory are assigned to which Event Event 1 - Rig 01 Event 2 - Rig 02, Rig 03 etc Objective: As Inventory is assigned in the EVENTS table, I want to remove the assigned Inventory from the RIGS table dynamically. I can make this happen per field, however it doesn’t translate to all records globally. Thank you so much for your help in advance! Joanna

Hi Community, as a brand new user of Airtable, my question is more general in nature and related to how to set up a project. I am creating a startup accelerator program and would like to use Airtable to manage the process of creating application forms, and evaluating candidates (with the help of a number of evaluators/judges). This is where I am so far: I have created a new base called Startups I have created an application form with all the relevant fields for the information I need from startups. The next steps are where I have some doubts Should I create fields for the evaluators within the same form as the startup application or create a new separate evaluation form and link it to the startup? Ideally, I would like the evaluator to score applicants within the same form but allow for each evaluator to start with a blank field (ie not see the other evaluators answers, to avoid bias). Is this possible? The end game

Hi Community. So far i have Set up an Item List where i can seach the sku number and another where i can search by name, thats fine. So when i enter via form the data for the costumer where it should be send i have just 1 problem, what can i do when i have 1 of these items twice or more ? How can i add quantities to these without letting the sku’s explode ? Thanks in Advance Edit1: Line Item’s won’t work in that case