Base Design

BASE 1Project RecordsPrimary Field is a formula from (2) other fields BASE 2Issues ListEach linked to projects (synced tab into the base) ISSUEWant to see a list of records from Base 2 within Base 1 when looking at the linked recordSynced issues tab is appearing, but linked PROJECT is appearing as single line text no the linked field Question #1:  Would dual-sync solve my problem?Question #2: Any other ideas?  

Hi all,I can't keep my work partner from accidentally adding options to our single select fields. He forgets they are single select fields and just types in his value—often misspelling them. Is there a way to prevent this? One that doesn't depend on me somehow managing to finally get him to remember? I sure hope so. TIA for your thoughts!

Last year I designed a School Newsletter system. One of the columns is the Newsletter Banner which changes for every campaign. It's a png image. I am using Airtable, Softr and MAkeLast school year, I was able to get the image URL. The output from MAke was giving me all I needed including the direct URL. Here the info I got for an image for example:Cover ImageArrayid attRZ6NuuEIBthpMQwidth 1380height 690url https://v5.airtableusercontent.com/v1/20/20/1693879200000/MVzlf5EfMgHm1KCztb4uiA/YQ-c86PccvtHjdv9VUR1v49KxX4BS5xJD4iXuZcVSV25PY2uq3dNQfs0_2sRsLsEQZqZ1r9gbLwfp4lzTPWcE83i19ubgZCM-

Hi all,How can I take the first attachment from a list of attachments and place it in another attachment field? Is there any solution that does not require scripting or integrating Zapier/Make? Cheers

HelloMy company builds complex machines with many parts. A lot of these parts, I need to buy and keep track of delivery dates and whether or not the item has been deliverd.What is the best way to set up an airtable to show all the delivery dates for all items across all my projects?If possible in one interface?Lets say I have three projects running. I need to be able to quickly manually add products to any of these projects and see all delivery dates in one calender so I have an overview. But I also need to see each project seperatly Do I create seperate tables for all these projects? (this may lead to many tables)Best practises here?

As part of my workflow, I have a view in my base where I put in all my tasks for the day, which the populates my calendar. To make this work, I have "Date Start" and a "Date End" fields with the date and the start/end time of the record so that it'll be placed correctly on my calendar. This works great but has caused an issue with creating another view that I need, a daily summary.I want to have a view that groups my records by date so that I can see how much I earned that day, how much I worked, and other stats. I can filter my records to show me this information for a single date without any issue. But I'd like to have a view that shows all my days work grouped together to be able to build a few extensions around the resulting data. The problem is that AT will group based on the entire field information, so including the time, and not just the date (see attached screenshot).The only "workaround" I can think of is to have a third date field with just the date, but thi

I am aware there is no way to "overwrite" data but I'm trying to figure out how else I might accomplish what I need.I have a very basic 2-table base.  Table 1 is "Call Log" and Table 2 is "Users".  I want to set up a default set of fields (location, type, job) that apply to specific people.  For example, "Bob" might default to Ohio, Office, Data Entry, whereas "Linda" might default to Kentucky, Warehouse, Stocking.  But as I do the weekly logs, their job scopes and locations might change.  If everything is added to the Call Log table from lookups (pulling the defaults) I know I can't directly edit them.  What would be a best-approach (I'm not against some scripting or automations either!) on handling when I maybe want to track that Bob is in Indiana and Linda is in Ohio.Thanks!

My end goal is to associate the Slack ID of the user that submitted each record in my primary base.I currently have a 'User' column in my primary base that associates each record with an "owner". I'd like to be able for the record to automatically pull the Slack user ID for each User from a "Team Roster" table that holds the User and Slack information for each team member (or maybe there's a better way).The only way I have found to do it so far is to use a 'Lookup' column in the primary base that references the "Team Roster" instead of using a 'User' column which ties the record to their Airtable account. This is not my preferred method as the lookup column selection is not as clean as a User selection when team members are choosing the owner of a record.Primary Base: Team Roster Base:

Hello,I'm just curious to know if Airtable plans to create a list view for calendars.  We have Lists and we have Calendars but I'm looking for a schedule or list type view within the calendar.  Or maybe there is a way to create such a view? Thanks!

Hi there,To use data for a list Softr you have to have the data in the same column. How would I be able to put two look up fields (one displaying a percentage and the other displaying a $ amount) into the same column while maintaining their exact values (not making them into just normal numbers and keeping 1 as a % and the other as a $).Any help would be greatly appreciated,Bart

I have a fairly complex set up that I may need to hire someone to help us complete, but I'm hoping to answer a few basic questions before putting in all of that time and money.We design and manage renovation projects for 5-15 clients at one time.  We collect records for various products and materials, present them to our clients (option 1, option 2, etc.), get approvals and create a final list of the approved products and materials to accompany our construction documents.  Sometimes we use the same products and materials on several projects, but each project requires different quantities, colors, pricing, tax rates, etc.  I've tried creating one "master catalog" base that has tables for products, vendors, suppliers, manufacturers, categories, etc. and a separate base for each project.  Each project can have a list of 100-400+ required items and we might collect 2-3 options for each item on the list. I've also created a web clipper extension for e

Hi all,We have an AirTable base for our marketing team that has multiple "sub-bases" leading into one "master base". The thought of this is to have everyone keep their work flow in their base and have all the information on the team in one place with the master base. We do have an enterprise account which is why this question pop's up, why can't we edit fields in the master base. At first we were able to but it switched and now the master base has little to no use.  Thanks,Will

Is there a way to create a time slot, similar to when you add a calendar a pop up appears and you can choose a date. I've aded a screenshot of what I've created, which is a single select option, But would like it to be more flexible. So, if you choose 9am it will autofill a a two hour duration, 9-11 or if you chose 8am it will autofill 8-10 am.Thanks. le.

I am attempting to make a database for my social media.  I am having trouble with the best way to organize it.  I struggle with how I can put things in DATE order, We typically do Month and Week # so we don't have to change the date each year, but then it doesn't go in month order.I would like one grid with all our marketing ads, then some sort of way to separate for each type by date (either as a gallery or grid).  My questions are- What is the best way to sort by date?  If I have 1 row listing multiple dates, can I have another grid or form listing each week/date individually?For the image listed, I would like some sort of sorting to separate by date:Example:First week of the month SpecialJune Special

Hi there! I have a bit of a math problem I'm looking to solve:I manage a Department with about 85 Software Designers, which are assembled into 15 Squads, which support 3 different categories of software products. And about 1/3 of the work they do is product-agnostic (like onboarding, up-skilling, tooling maintenance, etc). I'm building of Airtable Interfaces so that Designers, Leads, Managers, and our VP have access to the project information that matters to them. I'm just a little stuck on how best to architect these Tables.Should house alllllll the Projects/Tasks (Epics/Stories) from all 85 Designer practitioners in ONE Table, and then group and parce with other Tables and/or Tags?OR should I create 3 Tables for each of the slightly different product categories (since that kind of makes sense ) and just accept that Practitioners will need to toggle around a bit in the Team's Interface?Also, would se

An existing base tracks students self-enrolling in classes by submitting Airtable forms.Tables:Students (linked to Classes)Classes (linked to Signups)SignupsThe Signups table contains forms to sign up for various classes. There are multiple forms because some require different information than others. What's really messy is that Students has one linked record to Classes for each type of class!When a form submission is received in Signups, an automation is triggered based on the kind of record received. If the class type is "Class A," automation A runs. If the class type is "Class B," automation B runs. The automations update the "Class x" linked record fields in Students.This gets more and more unwieldy since Students has multiple linked records to Classes. The person who created it is no longer with the company, but I was told the Signups table is a helper table. I'm beginning to think it should be red

I am wondering if anyone is able to assist with a couple of questions. 1.  When adding an attachment into the 'attachment' field I am simply adding from files and attaching a word document.  I am then having issues once I send the email with the attachment not coming through in the correct format.  It seems to only be coming through in email as a small photo that is quite blurry.  I am wondering if there is any work around to this and how I can have an email sent with the correct attachments - preferrably the word document.Above is my current airtable.  Each date has 3 specific shifts 0100/0800/1630.  I am wondering what I need to do in order to have 3 emails go out each day with the attachment (from question 1) as well as t

On Table A I have a linked record field that allows multiples. It pulls records from Table B. These records on Table B include a Date field. Records on Table B are not necessarily entered in chronological order. For example:Table B Record 1 - 1/1/2023Table B Record 2 - 3/1/2023Table B Record 3 - 2/1/2023On Table A, I'm trying to pull the most recent record linked using a Lookup field with the "limit the number of items shown" option turned on and set to "last 1" but I believe this is giving me the date of the linked record that was most recently created rather than using the date field of the record to give me the most recent. I believe I could play around with an automation that could accomplish this for me but before diving into that, is there a more simple way to achieve this?

Hello,I have records of 4 thousand rows in Airtable, with around 100 views and about 50 columns. Two of them have attachments fields where we store pictures.Every month, we need to create a new table organized by month, and we want to retain the previous month's views and settings, but the data itself is not required. Currently, I use the duplicate table feature without including records, but it has become quite problematic and slow. I am wondering if the Airtable team is working on improving their servers to address these issues.I need some assistance. Is there any other method or workaround to synchronize all the views and create a new table for this month without including previous records?Thank you.

Hallo community,I have two tables: "Bestellungen", "Bestellung Positionen".Table "Bestellungen" has 3 Lookup fields "Artikelnummern", "Anzahl", "Einzelpreis". So the values will be not correct sorted like in a table "Bestellung Position".I think, it is a big bug in Airtable.P. S. If it is not possible to sort automatically in "Bestellungen" table, how should I sort it in relative table "Bestellung Positionen", which filter should I use. I know how to sort Table "Bestellung Positionen" by a field with a type "Created time", then the result with be ok, but I still need an option to order it how I want... And table "Bestellungen" should automatically bring me the same order.Thanks in advance. 

Hello,We are currently at 38,500 records. I'm curious how others are handling their data once they hit 50,000.Do you duplicate the base, delete all records and continue on (thus leaving all your fields, automations intact)?Looking for suggestions.Thanks!

Hi, I am trying to design two bases on Airtable for my team:Base 1: Instruction ManualInformation: This base should consists of all tasks our team need to do throughout the year, which instruction and attachment.Base 2: To-do tasksInformation: The tasks of this base should be synced from Base 1. In this base, each task will be assigned a collaborator, start and end date, task status, and team's comment. My current questions/roadblocks:1. In my Base 1, ideally, there should be two tables of tasks - "standard" and "intensive". But I still want both tables to be synced directly into one table in my Base 2. 2. In my Base 2, ideally, when I run a script of auto-updating the start and end date of each task, it can create dates of the following year, i.e., my team is currently monitoring the "to-do" and "in-progress" tasks (synced from Base 1) of 2023, but since all our tasks (both standard and intensive) are repetitive

Hello I'm new to airtable, and I recently had a website built using Airtable as a database for a car listing widget. We have a column in our airtable where we input a short and long description for each vehicle we list. Below is a screen shot of what the data looks like once we past it into the cell of the airtable. It looks like one big run-on sentence. Is there any way to format this data to display nicer? Or at least have a line break so that each sentence can be displayed on its own line so its broken up some and easier to read? Thanks!I would prefer it read like the following if possible.... SOLD!USED HEAVY RESCUE PUMPER FOR SALE!8 Man Cab (7 SCBA Seats)Air Conditioned CabDiesel EngineAutomatic TransmissionMileage: 19,074750 GPM Side Mount Pump500 Gallon Poly Water TankFoam TankFoam Pro Foam Sys

So it's obviously quite a shock getting the email yesterday, the 23rd of August with the massive downgrades to the Pro Plan (Team Plan). However, this post is not to nag on the obvious downgrades which are going to affect how some current systems work. How I see it is some clients will have no choice but to upgrade, at a high expense, or stay on the Team Plan and try and work with the downgrades. My first question that I want to have more clarification on what's offered on the new Business Plan that was not available on the Pro Plan. The two main points that really stand out to me are as follows:Two Way Sync 🆕Unlimited Workspaces 🆕Are there any other exciting features I can show my clients that was not available until the new Business Plan features come into affect?  Question 2: Unlimited WorkspacesPrior to this, my understanding on the Pro Plan was that each workspace was billed as an

I am working on a base with one table that has a record of all my fabric purchases, their respective lengths and widths. I want to create a my second table as a list of patterns and the length and width requirements for the fabric necessary to complete the pattern and have it automatically pull what fabrics I have that are eligible for the project based on the length and width criteria of the pattern. Is this possible?