Base Design

We’re a small charity that has seen an exponential growth in donations over the past 6 months. Our existing donor management system on Airtable isn’t scalable to our current needs. I appreciate this is quite a complex query. So I'm initially looking for a feasibility check and some advice on how to meet our requirements. Main issues4+ disconnected Airtable bases (for different charity initiatives/ programs)No unified customer accounts (bases are siloed, no unified user ID resulting in duplicates on single/ multiple bases, no unified user donation history)RequirementsCreating unified customer accountsMerging existing duplicate accounts across different basesLinking user accounts to different initiative basesTracking multiple donation entries from a single customer across single/multiple initiativesAdding accounts to unified and initiative sp

I want to make a pie chart that i already know the % for. Can I do that?

Hi guys!Is it possible to have URL in primary field? So that the URL is hidden behind some text (rich text formatting). Like you can do in other fields:So now I have this:One field is brand and the other is model (here I added URL). Primary field is brand + model. When I embed this view into my blog post, reader needs to click on the primary field and from that it opens up window where he needs to find it and click on URL one more time. I don't want that additional step (click) and honestly I think that reader won't find it quickly. Or it can be confusing.Is there a way to add rich text formatting in primary field?Thanks!

Hi! I'm a flower farmer, trying to teach myself Airtable.I wanted to keep track of my tulips from year to year and set up a base. I need suggestions on how to organize this better!  Each type of tulip might have a different harvest date from year to year, and its possible I might buy it from a different source from year to year. Maybe I like one company's bulb over another, etc.   I think I'll add a price per bulb as well, which will change from year to year.   Should I set up a new table for every year and then bring that data together? What makes the most sense?  My main goal is to be able to see the big picture of different bulbs to help me decide what to order in the future.  Any advice is super helpful for this newbie!!Thanks!!

Hello, attached is a screenshot.  I am interested in having "time sheets" as a view that is linkable to a project.  I have made this work using lookup fields, but this seems to only display the first 4 columns from "Time Sheets".  I tried creating a separate view and only showing the column want and selecting "Limit record selection to a view", but that does not work how I thought it would, that will only filter out results.  Is there a work around? Basically i am looking for my formula fields that total up hours to appear on the project, which is on the far right side of my time sheets table.  Appreciate your help.

Hi Airtable Community!I've been tasked with creating a CRM for Events invites and attendance tracking and would love any input on best ways to proceed. So far I have a "Contacts" table and an "Events" table, which are linked based on who got an invite to what event. The problem is, for certain events, we also want to track who RSVP'd and who attended the event on a contact by contact basis so we can reach out, follow-up after, etc. We ideally want to keep the base as clean as possible. I see two potential avenues (and am leaning towards the first) but would love other ideas that might be more straightforward/simple for those who aren't familiar with Airtable to navigate.create a new table solely to track RSVPs and attendance. This table would pull in the contact and the specific event they are attending so that every record is "Contact - Event" and tag accordingly with their RSVP status. Views for each event can then be created to summarize attendance.

I have a table of all USPS zip codes and their respective cites and states. It has over 33,000 records. I would like to be able to use it in another base without having to copy it into the other base which causes it to go over its record limit.Is there a way to do this?Thanks, Scott

Hi there ! 👋First of all english is not my mother langage, sorry if my english is not perfect.I'm working on a customer networking project.We have a multitude of tables, but there's no specific naming convention. they're table used by sales people, so not necessarily a tech culture. &#x1f605For example, in one table to determine which sales rep is the owner of a customer, the name is "owner", in another it's "Account Manager".To create a dashboard grouping together a multitude of information, I've decided to create join tables, as the information I group together will inevitably be useful elsewhere.Is it possible to add the "owner" and "Account Manager" information in the same column to this join table?In SQL, it's possible to do this with "virtual columns", but I haven't found anything about this on Airtable.If this doesn't work with Airtable, do any of you have any feedback on data aggregation using Airtable -> Zap

We currently pay about $3-4k/year for a "training platform" which as far as I can tell, is just a file storage front end that you can upload PDFs of certificates to and then launch a couple videos or slide decks from which are followed by short quizzes. When you complete the quiz, the training for those embedded vids/slides is recorded as complete.I have not come up with an approach yet, but is there any decent way to replicate this functionality in airtable? I have an entire training tracking base setup that is working great as a prototype, but the feature that would be great to figure out would be replacing this "built in" online training and tracking function from the other platform (literally the only thing we have going for it, I have no idea why someone selected this product or people got excited about it).Essentially, I have a log of everyone's various trainings. Some are online on 3rd party safety training sites, some are in person practical trainings with a co

I have an org chart that's looking good except for one thing: the lines that connect the name cells are in a faint blue that is all but illegible. The help bot gave me irrelevant advice, so I'm trying here. How can I configure the color of those lines? It's unusable like this.

Can someone tell me if there is a way to select several tables at once to move them? For example, when creating new tables, they are automatically placed at the very end of all existing tables. We have a lot of tables in our base, and I often have to create more, usually many at a time.  If I need them to be located at the beginning, or at the top (of the table list), it can take time I don't have time to move them one by one. It seems like it would be a pretty basic function that you would be able to select more than one table at a time in the table list and drag them up to the top of the table list, or select more than one table's tab and move them over all at one time. I've done searches, but cannot find an answer. What am I missing? Thanks.

Hello Airtable CommunityI have a base with several tables (one for each department) to plan their content. So print, social media organic, PR etc.Each team has 1-3 interfaces. Now I want to synchronize the most important information from all these tables into one table in the same base. I want to have a comprehensive content calendar to see at a quick glance who is working on what. Unfortunately, synchronization only works over different bases. But then I can't display everything in one interface and the employees would always have to switch bases.Does anyone have an idea for this?Best regardsMirko

It’s slightly similar question to the previous poster actually. I have a field which has numbers in it. If I do this (grouped by field), it shows a very neat view which also contains SUM of each group. The question is. How do I get this sum to my other table? In my screenshot, that will be how do I create a record on other table which has my [400x600] text and ‘30’ integer in it? Is there a very easy solution that I miss? Thanks

Hi, My boss has created this sheet. I manage airtable automations and things around it.So whenever he opened the account from his side, the sheet results shows some of the incorrect values. But whenever I open Airtable from myside it always shows me the correct values in the sheet.Attached are two screenshots of same table where you can see it is showing the red I marked showing different values.I asked him to open with different account but still he has issues and I am not having it.Please help, it's been a week we are having these issues. I have turned off all the automations but still this error doesn't resolve.

I've created a base for my softball league and could use a second set of eyes on a problem I can't seem to crack. I want to be able to input the game scores in the "Schedule" tab and then have everything else update accordingly (runs scored, runs allowed, standings, etc.). I'm not sure how to accomplish this. LINK TO THE BASE: https://airtable.com/appyRHUtLhxlpEWFY/shrn9oSvblGrwjaEYI also have this script I could run, but would need to upgrade my plan and I'd rather not have to do that: let gamesTable = base.getTable("Games"); let standingsTable = base.getTable("Standings"); let gamesQuery = await gamesTable.selectRecordsAsync(); let standingsQuery = await standingsTable.selectRecordsAsync(); let standings = {}; standingsQuery.records.forEach(record => { standings[record.getCellValue("Team")] = record; });

I’m trying to make a synced table, but have it synced to another table in the same base. This doesn’t appear to be an option. The use case is having a single base with a table of Posts (by a user), and also having a table of UserProfiles that display those posts. Thought the sync was the perfect answer to this, but for some reason it has to reference an external base. My options seem to be duplicating the data manually (edits to posts will be lost) or making a separate base for just the user profiles. Is there any way to link to a table in the same base?

Hello everyone! I'm sure this solution is something really easy staring me right in the face but I just can't see it. I have a  base with several tables that I am linking to, and trying to set up. To start:The Position Table has a large number of jobs in it. My HR crew list links each crew member with all of the positions that they are qualified for (and I have here the results showing as a Lookup)What I am trying to do is set things up so when choosing an Assignee it will ONLY display the people that are qualified based on who is linked to the Position field. So I can have this:And easily select the people for the Position filtered by qualification. Not sure why I can't think my way through this!

Hello! I'm using the interface to show our metrics, and I'm looking to show both cumulative pipeline numbers and current pipeline numbers. Under our Tasks table, we tag the pipeline status per task, so cumulative recall is straightforward. How would I record the metric for the current pipeline status? Our pipeline is:Qualification, Initial Contact, Significant Engagement, Significant Follow-up, Proposal Submitted, Proposal Awarded, Closed: Project not awarded, Closed: other, Handoff...For example, Within one project (projects are tracked in a different table) I have completed tasks for qualification, one for initial contact and now I have a completed task (with the checked mark) of significant engagement. I only want to count significant engagement to show where I am for this project. Is this possible? Are there other ways people show project progress/ sales pipeline progress? The goal is to see where people are at curren

I have a project and a task table. The tasks are all connected to projects. I'd like to connect the tasks together so when I need to delay (or move up) a project I can move all the tasks together. I thought when they came out with dependencies, that would work. Unfortunately, it doesn't work for what I want to do. First of all, my tasks aren't necessarily dependent upon one another. I don't need to do one before the other. They are simply tasks that need to be done before the project is done. I've tried batch move, but it gets complicated with weekends and holidays. Also, I have a project start date and a due, Plus I have a task start date, a working on date. The working on date just ensures that I'm working on the task before I need Any suggestions? 

I have an airtable base that has a field linked to another record.  I need a way to populate this field with a field in Jotforms WITHOUT using automation (I have tens of thousands of these records so I can't use automation).Is there a field type in Jotforms that will populate this field type?

Hello everybody!I have two tables one that shows products and one that shows orders. What I want to do is inside the table that shows the orders. I want to have a view that shows most recent order that each product is attached too. Is there anyway to do this?

Hey community,I'm fairly new to Airtable and I am faced with a task I myself cannot seem to wrap my head around: I created a single-select field that checks for a condition (e.g. did you have lunch today?). It's currently not being used yet because I want to get the reporting straight first. My problem: I already had records in my base prior to this new select field. What I would like to do is to check from a specific date onward (ie. once the new field is live and ready to use for my base editors) how often this field was selected - meaning how many % of all new records did choose to select this optional field (yes, I had lunch today). Do you have any ideas how I could set this up? Thank you so much!Virginia

I have a user that wants to change the name of the "Duplicate X" where X = Initially selected name when the table is created with the "What should this record be called? question. Is there a way to change this after it is initially selected at table creation?I have not found a method to edit after creation and also didn't find anything in Airtable Help related to this topic. 

I design and produce products which I sell online. I use Airtable for project management. My Airtable base has tables for PROJECTS, TASKS, PRODUCTS and more. Each Task and Each Product is assigned to a Project. I have created an interface where my supplier can get all the data and infos for the upcoming products.In my PRODUCTS table, I use a formula to create a SKU for each product. It is a combination of the project number, the product category and the product number. My Problem: Some Products have variants (e.g. T-Shirt sizes). 5 different sizes of the same T-Shirt should all have the same SKU, just with an addition "-SM", "-MD", "-LG" etc.When I send the info to the print company, the interface should not only show a total amount of units ordered. If there are variants, it should also show the ordered unit for each variant. For example "Small (AR0010101-SM): 11 Units", "Medium (AR0010101-MD): 23 Units".But there are many other potential variants for products

That can be used to generate web pages automatically from a base? I know that Carrd can be connected to Airtable one way (for instance, to fill in data into a base for a form created in Carrd), but I am not sure if it can work the other way around (a row in Airtable becomes a website page in a Carrd site) Are there any other applications besides Pory, Table2Site?