Base Design

Thank you in advance for any help! I should mention it is an extensive library (over 1000 pieces).

ex: I have multiple tables that will have URLs I’d like to link each table :People, Org, etc to the URL table. And when I’m adding a person, I want to add URLs but they should be inserted into the URL table Another example might be a shared “Tags” table. ORGS and People can have the same tags I don’t want to have to create the tag first, just during editing an Org record, start typing a tag and if it exists use it else add it. Is this possible?

Hi! I’m building out a product catalogue within AirTable and am stuck on the best way to manage updating prices for lots of similar products at once. Our company manufactures similar products but with variations of shapes and colours (23 colours for about 90 different shapes). There are just two Retail prices for the colours: “Standard” & “Premium”. And each shape is priced differently. The premium colours are 20% more expensive than the standard colours; so, only one price ever needs to be input for each shape and formulas can calculate the premium price (add 20%) and then other formulas work out all the different pricing tiers: retail is 2x wholesale + tax, trade is retail -10%, etc. In a spreadsheet this is pretty straightforward using lookups and IF statements that reference the base price and then a table that checks if the colour for X shape is considered “premium” or “standard”. But I cannot figure out how I’d achieve similar in AirTable without a convoluted repetition of fi

We have a database with clients and I would like to give casemanagers access to their own clients only. I van make a filtered view for every casemanager, but any other casemanager can still open that view. Is there any way to get this done?

I have used Airtable a couple of times pretty much as a spreadsheet. I want to do something that is still probably simple, but I still can’t figure it out even with the videos. I am just trying to organize all of my home media (see flow chart) into a searchable database . Can you point me to a video or example already out there?

I am trying to figure out how to have two columns in some sort of table or report where one is drawn from one table and another is matched according to an aggregate on another table. In SQL, this would roughly look like SELECT a.name, a.target, sum(b.value) FROM TAB1 a, TAB2 b WHERE a.name = b.name GROUP BY a.name Here, unique names occur once in a but many times in b so that many rows of b match to each row of a. TAB1 Name. Target A 1 B 2 C 3 TAB2 Name Value A. 5 A 3 B 2 C 3 B 6 C 4

Hi guys! I have trouble with the roll-up fields. Currently, almost nothing seems to work – even fields that worked before. As an example, I’ve created a roll-up field to count the linked records (see attached). Let me know if you need anything else! Martin

I’m combining the data from a number of tables in a new table. I’m grouping my view by project each project has some costs I wish to display. I also have staff members that work for a particular project they have costs I also wish to display(yellow). The problem is I see the project costs repeated for each staff member attached to the project(red) I would like to keep the summary. Is there a way to hide them or a different structure to overcome this issue?

Hi, I’m working on setting up a paper revision process. I have a Paper Submission table, a Reviewers table and a Review Form Data with the review itself. So once authors submit papers, they get 2 reviewers assigned in the Paper Submission table. Once that happens, an automatic email is sent to the reviewer with the paper, the Review Form that they need to fill out, and the due date. If they submit a review, a record is created in the Review Form Data table. So the outcome would be to have 2 review records for paper. So what I’m struggling is with setting up reminder for reviewers when they have 3 days left to submit the review. I created a Send Reminder view in the paper Submission table, but I’m struggling with the coditions since I don’t want reviewers to get reminders if they already submitted the review form. So let’s say that Reviewer 2 submits the review, so I get a record in my table, but I’m still waiting on Reviewer 1 and it’s 3 days before the due date therefore, I want to

Whenever I open an existing record, or start a new record, or when taking a picture, in all these cases Airtable causes the device to hang for 2-3 seconds a d the screen goes completely black and unresponsive. After that the app goes back to normal except when taking picture. When taking picture … specifically after the picture is taken the screen also goes black and when it emerges back the record shows the picture is being uploaded. However the next second the Android system message pops up telling me airtable is not responding and asking me if I want to wait for the application “get back to life or something like that”. However even before I can press wait, there is another message over that popping up saying Airtable was terminated. Once I restart the app again, the picture is sometimes uploaded but half of the time it wasn’t uploaded. Anybody noticed similar issue? I don’t have issues taking pictures for other apps. It seems Airtable related. By the way, i wonder why isn’t ther

We’ve built out an epic donor CRM base with the help of a developer, but we’re struggling to figure out the best way to approach spouses and families. Sometimes a person donates as an individual, and sometimes they donate as a married couple. I think it’s just what they think about doing that day, there is no other significance. We also want to track who a donor’s spouse is so that we can improve our relationships with the couple/family. My question is how to best handle the relationship to avoid double-sending information, honor individual relationships when necessary, and make the automation process when a new donation hits to go to the appropriate person or couple. These are my ideas, anyone have guidance on how to best approach between these ideas, or have a better one? Option 1 - Any time spouses give together, we split them up manually so there are two people, instead of 1, connect them as spouses, and mark the second spouse in the spouse as the Spouse/Secondary record so that w

I’m a pastor who uses Airtable to organize our church’s worship services. It’s become absolutely indispensable, an every day part of my workflow. Currently my Worship base has four tables: Services Songs Sermons Readings The Services table has a one to one relationship with Sermons, and a many to many relationship with the rest. Now in real life, every Service contains a mixture of these elements, in a particular order. For example… Song Song Reading Song Sermon Song Reading What I need is the equivalent of a multiple linked record field, but one that would allows for different record types. Other than storing JSON in a plain text field, I haven’t been able to come up with a good solution for this problem. Would much appreciate any ideas!

I am new and wanting to build the Base(s) and Tables correct the 1st time. The business will have nearly 60 columns of data that I can break into different tables. The challenge is in using a contracted out Data entry team that I want to populate all the fields on each job but once complete and after I have approved the work I want the data to become removed from their view and/or control.

In one base I have three tables. One is for Manufacturers and another is for Products. Manufacturers records have a field that can link to multiple products from the Products table. A third table is for special offers. The data is imported here from a separate list and it includes linked fields for both the Manufacturer and the Product. When a record is added here it will add the Manufacturer and Product to their respective tables, if they don’t already exist. But it doesn’t automatically link the Product to the Manufacturer. Is there any way to make that happen?!

Hi all! I have a form in Thought Journal Entries Table, which includes a client’s journal entry and their email address. You’ll notice that the “Clients” field is a linked record, to the Clients Table, where I have a list of clients and their email addresses. Is there a good way to have the Thought Journal entry automatically link the record back to the corresponding client so we wouldn’t have to do this manually every time someone makes an entry? It doesn’t look like it happens automatically when the email is the same, and I haven’t been able to successfully get an Airtable Automation to have it do the following yet: lookup the submitted email address from form in the Clients Table, Find which client submitted it, then Link the original submission to the original client record Thanks a bunch for reading this! Sorry if this has been successfully answered before, I haven’t been able to find a good answer yet. Evan

I have 2 tables on one base that are linked together by one column of product names. When I click the product name on one table I would like to automatically jump to that row on the other table, but it opens up a popup box with details about the record. Is there a way to just hop over to the other table instead? Even in the popup box I don’t see anything to click to take me to the other table.

Can someone tell me whether attachments in Airtable/uploaded to an Airtable form are given a URL that allows anyone with the link to access the attachment without any sort of authentication please? I couldn’t find anything about this in the official documentation, but threads like this one say that this is how things work: Attachment URLs are public? I’m asking because I’ve been asked to upload an attachment containing tax information to an Airtable form and obviously I have concerns about this if Airtable will generate a URL that allows access to anyone who has the link. Thanks in advance for your help!

Hello all, I dont know if I am in the right group here. I would like to ask a very simple question: Is it possible to create an application which would show a simple table on the left side of the screen (in table/ grid view) and simultaneously the corresponding memo field (in form view) for one row which is selected at one point ? Thank you

I need to track a set of items that are received in one location and then moved to other locations. Each location receives from the main and/or each other. Each location decrements as well. I need to keep track of the quantity that is moved from the main location to all of the others, decremented from those locations and keep overall total quantity updated. Can anyone help?

Hello! I’m fairly new to Airtable and was trying to create a form. When I click on the shared link, I get this message: Warning: potentially risky form The user-created form you are attempting to access has been flagged as a potential risk. If you wish to proceed and view the form anyways, please remember to never submit your passwords through Airtable forms. Any advice on why?

I need help with the 500 column limit. We use our base for estimating but with multi options and pricing we are reaching our max limit. Example: We have a window estimate - which consist of 16 windows (and every window is different and needs different information: 16 - Window Styles 16 - vlookup for window style pricing 16 - Length Measurements 16 - Width Measurements 1 - Formula for measurement pricing 16 - Zippers Sizes 16- vlookup for zipper pricing ect… This is only part of the estimate. Currently we are right around 430. Please let me know if you have any suggestions to help.

I’m trying to find a way to manually sort rows in my main Grid view and once manually sorted, updates the order of the additional views in the base. We are trying to import a tool that we have in Google Sheets to Airtable. It has hundreds of rows. Sometimes a new row is added, but needs to be near an older row further up the list. Instead of using Google Filter views, we want to use the Airtable Views to replace them, but we need to see those row updates that are made to the main one in them. There are about 20 non-main views that we’ll be making. Any thoughts?

Hello, I’m using Airtable to organize a catalog. I’m not enjoying the drop-down option and don’t recall this from past use. Is there a way to remove?

Who knows how I can organize this? I have two tables: Groups, with each 10 columns for the names of their members Members, with the data of all members of all groups Now i want to automatically add the name of a new member to the first open spot of the particular group. For example, if Joe is the 5th member signing up for Group X, then his name should automatically appear in column five of that group. Is this possible?

Hey, just have a quick question that I have not been able to solve otherwise So we have a pretty complete base with the following flow : 1.Client fills an Airtable form to book a service; 2. Internal team of operators have different views related to the state of the bookings ( in transit, current, done) 3. Each major client would have a filtered shared view of their bookings, grouped by status Here is a quick idea of how the base is setup : Booking Customer / Client Customer table having the customer ID as their main identifier (primary key of the Customer table), Full company name being the second column, to make sure in the Airtable Form that the customers cannot see the other customer other than their randomized Customer IDs. We communicate with each client their Customer ID and with a prefilled URL we prefill the form shared with the customer. So the current problem is that if the operator needs to fill manually a new booking, they need to search the client by Customer ID (primar