Base Design

It has been solved, this topic can be closed.

Each time I type date into one of the boxes and then either tab to a new box or click it any data I input is now gone. I get this message Record filtered: no longer visible on this views filter and willl be hidden when you select another record???

I have inherited a project and have been working on the API side of things but am now getting into the table structure and have a question. Structure: ’Employees’ Table. All employees in the company. Includes Email, Specialties (Link to Specialties), and Coverages (Link to Coverages). ’Specialties’ Table. All specialties provided by the company. Includes ‘Name’, and ’ Link to Employees’ ’Coverages’ Table. All coverages provided by the company. Includes ‘Name’, and ‘Link to Employees’ The idea is that I can access the Employees table via the API and get all the specialties and coverages an employee offers. In the linked Specialties column of Employees I can add Specialties just fine and the data finds it way back and forth. Delete an Employee from ‘Link to Employees’ from Specialties and it is great. The group added this Coverages table and has added all the Employees to the ‘Link to Employees’. They sit there just great. I am now trying to get them to back populate to the Employees tab

I setup one base a while back…and entered a few records in it, but didn’t keep using it. Since then, I created a new base that now has over 1300 records in it. Can I move the records from the original base into the new base? or somehow merge the bases together?

Hi Airtablelers! I’m struggling with a logic problem here and would really appreciate some insights. I have a Spaces table that lists the shelf spaces I have in a store. Each space is defined by its column number and a letter specifying its row. Each column is different so not every column has every letter. Then I have a Brands table where I need to assigns these shelf spaces to different brands. For the brands table I want to create a Linked Record or Dropdown that lists every space available. basically listing all the combinations from my Spaces table. In this example the list would be like: 1A 1C 2A 2D 3C Is this achievable at all? What’s the best way to achieve this? Thank you so much!

When I try to use the fill handle it doesn’t do anything. I have tried with text and number cells. I select the cell, get the blue outline with the white box in the bottom right corner, hover over it and get the cross hairs, then when I click and drag nothing moves but the cross hairs.

For the sake of example, let’s say that I train dogs, mostly one on one. Before each dog can “graduate”, there are several tricks that they must master at different skill levels. It’s helpful to group them by skill level, but they don’t all happen in a strict sequence. Sometimes, one of their humans may need to be assigned to work with them on mastering a particular skill, though I can probably do without that information. At this point, I’ve definitely got a table for dogs and a table for their humans. But should I have a table for tasks, or should all of the tasks just be fields in the dog table, since a task can only be completed for each dog, rather than on its own? I’d like to be able to look at all the dogs that still haven’t learned how to fetch, for example, to maybe plan a time to work with them together. I generally care more about seeing the tasks that a dog hasn’t yet completed, rather than what they’ve mastered. I looked through a lot of example bases to find examples, but

Hi there, I’m very new to Airtable, so apologies if my terminology is off here! I want to know if I can bulk-add labels in a field to a portion of my records. To illustrate, say I have a table full of details about an array of organisations. I want to record which of these orgs take part in a variety of different activities (each of which are detailed on another table). The best way I can see to do it is to create a field in the orgs table that links to multiple records in the appeals table. We can then, one by one, choose which activities each org took part in. But must I then go down the list of hundreds of orgs and choose individually which activities they took part in (hence giving each of them a “label” for that activity on the orgs table)? Or, for each activity in the activities table, go in and choose from hundreds of orgs and add them all individually? Or is there a way to add a specific activity to a bunch of orgs at once? I notice that you can drag a populated cell down a

Is there a way to pay JUST for the gnatt functionality or link airtable with another outside program? the free airtable functionality suits my needs except for wanting to try out Gnatt - but it would cost thousands of dollars for the experiment to upgrade the whole workspace. Is there a more cost effective solution for this functionality?

Hi all, I have built a base to track all the data related to my sales. I have the following tables, all connected with each others: Orders (linked to Customers and Products) Customers (linked to Orders) Products (linked to Inventory) Inventory (linked to Orders) 90% of my orders are including only one product. The rest of the time, clients buy more than one product, either the same product or mixed products. And here comes the troubles… I don’t know how to affect the suitable quantity per product on each order I create. For now, I am only able to tell Airtable that the order X is including product A and product B but I can say for each product the quantity that is included in the order. I assume this issue has been met and solved already since it’s pretty basic but I can’t find a decent solution to implement. So I ask you guys :winking_face:

I need to link two tables with moving targets… I have a Project task table (Tasks) that is utilized to usher a client through our entire process. This table has multiple tasks that are duplicated for each client. There is a step/task in the TASK table that dictates that the project has a certain number of items updated (varies by project). These Item Updates are in a separate table (UPC TASKS). I want to join the UPC TASKS table to the corresponding task step in the primary project TASK table. How would one go about doing that? And, because that isn’t complex enough - every month, we repeat the same group of tasks for each project, to also include another round of updates to the UPC Tasks. So. How does one proceed? My desired outcomes would be: Linking between the two tables/data sets: TASK table record “Keyword Insertions Complete” for Client A linked to all of the corresponding UPC TASKS for that particular month/round In the TASKS table, for the task “Keyword Insertions Complete”

Hello, I would like to get in contact with someone who I can discuss my current base design. I think it can be improved - by using specific formulas - but not sure how.

Here’s what I’m trying to do: I have a CRM base. One table has records that include prospects’ names, contact info, etc. Another table has my prospect funnel (contacted, meeting scheduled, sold, etc). I need a way to see the contact’s status in the funnel in the contact table (as a grid), and be able to move them through the funnel on the funnel table (in a kanban board). I just can’t figure out what to connect and how to connect it. I’m very much an AirTable beginner. Thanks in advance!

Hello, I’m an Airtable noob and have worked through the tutorials and have started building a database made up of 3 tables, Area, Compound and Assets and Structures. I have managed to make compounds link to the Area table, i.e. the parent, and Assets and Structures to the Compound table, their parent. I can’t seem to link the Assets and Structures to the Area ultimate parent table, which shows the headline information; think linear infrastructure project. Whenever I add a link, it always ends up with two fields being added, where I only ended up with the single field for the Area/Compound and Compound/Asset relationship. I know I’m doing something obviously wrong, but I’m burning a lot of time going round in circles and need to add other tables which need to link through at respective levels back to the main Area table. AAAAAAARRRRRRGGGGGHHHHHH!!! Area to Compound link working: Compound to Area (CFA) and Asset working: Asset to Compounds working: Assets to Area (main table) not work

All tables appear to have the same color of lines separating records and fields. Is there a way to format tables so the lines appear darker? They are hard to see.

Is there a way to zoom in and out so more records and fields can be seen at once?

Hi - Still new to Airtable and navigating the options it provides when wanting to better organize our small company. I would really like to know if it is a viable CRM tool based on the following: We have various types of contacts. They could be classified as “investor”, “mentor”, “alumni”, etc and, in some cases, may be assigned more than one category. We hold events and I would like to be able to indicate participation for each contact. Again, in some cases, they will have attended multiple events or at different roles at various events. When we send large emails, I would like to be able to select recipients based on various filters on the above two items. When we conduct classes, we would love to publish a gallery showing those who attended that specific event. I currently have one gallery created but it was done specifically for a cohort and not from our larger list of contacts. Can you create multiple galleries from one large base? My head is spinning trying to determine the

Dear All, A new slightly intimidated user here! My team has a to-do list of running action items as one table, linked to a project areas table. I want, when an action item gets marked as “done,” to be able to have that task disappear from linked tables. How do I do this? Thanks!

I am struggling to see how to start designing my first airtable and I am hoping people will have some solid suggestions for me, this would be used to distribute working shift information to people - I would need - List of people with personal information and “shift pattern” List of locations, with 1 - 3 rooms able to accommodate 1 person per room People would get “assigned” to locations that they are able to work at Shift pattern - i need a way to add a set of shifts for 3 weeks (based on day of the week) which will then repeat - what is the best way to implement this? Calendar of shifts viewable by location with the shift patterns added automatically I hope this makes some sense to anyone reading, many thanks in advance to anyone’s helpful replies!

So this system will replace an Access/SQL Server system which has long passed it’s sell-by date :grimacing: Applicants complete a form (Jotform) with just over 100 fields (many conditional), which populates a table in Airtable through Jotform/Airtable integration. Admin then conduct an initial review, referring to some of the application data. For each criteria Admin record: pass, partial, or fail, (new Single Select field) and also any comments relating to that specific criteria in a comments field (commenting is not used as a) it must be preserved, and b) it relates to a field not the entire application). This means that most fields become 3 in order to record the admin review. If the application passes the intial review stage, Admin send automated emails to application contacts (from the form data). Views are used to create a process to move applications through the different stages of initial review. Responses from the application contacts determine whether the application is re

Hi just wondering how to change the data being shown in the preview for example I want to remove the NEW item and move the SKU information shown in this photo

Hi, How can I color individual cells in a table? Thanks in advance!

i have a multi select field in one table of my base (Grants). i need to get that information into the Organizations table of my base. i have used a Lookup field to get the data into the other table. however, in the Lookup field, the data is converted to text. is there a formula that i can use to convert the information in the Lookup field to a new multi select field in Organizations? (i know i can just convert the field type from Lookup to multi select, but i want this to happen whenever new data is entered into Grants, not have it be a manual process of converting the field.) thank you for any insight!

Hi, I am trying to set up a base to track asset/inventory quantities, costs, assigned employees, and locations, but am fairly new to databases and couldn’t find anything in existing topics that helped me beyond probably needing a junction table? I currently have three tables: one showing the item, type, total quantity, and cost per item one showing the employees that currently has a column showing links to the items one showing the locations I want to be able to designate how many of each item each employee has been assigned, and where the item currently is. For example say there are 5 laptops worth $500 each, John has 2 (1 at home and 1 at Office 1), Mary has 2 (1 at home and 1 at Office 2), and the last is currently unassigned but is at Office 1. This situation is then repeated with various other items with varying values. From that, I want to be able to see at a glance that John has $2,500 worth of items and a breakdown of what those items are, while having some kind of limit that

A group of us (“auditors”) are conducting an audit of the features of 100 virtual events. The responses were gathered in a spreadsheet and I’m moving to AT. I’ve created my main table. The anchor column lists the individual event names (domopoluzza, Zoomtopia, AWS, etc.). A series of columns of checkboxes and multi or single selects and others accounts for the various event attributes (date, free/paid pay model, live/recorded, networking, number of sessions, and other virtual event features). Then, for each event, we also have 10 qualitative questions that require written answers. In the current spreadsheet, each event has a separate tab. Column A lists the auditor’s name. The columns are the 10 questions. Each auditor then adds their responses to each of the questions. This current spreadsheet has 101 tabs - the summary of data on tab 1 and each of the individual events/qualitative questions on the remaining 100. Here’s my question - how do I handle the 100 qualitative tabs? The sa