Skip to main content

Base Design

Need help with your Airtable base design? You've arrived at the right place.

  • 3,359 Topics
  • 8,409 Replies
3359 Topics
C
CurrentDigitalNew Participant
posted in Base Design
Is there a way to get more rows without upgrading to Enterprise? Is there an Enterprise Lite?

Hello, Airtable fam!We have reached our 50,000-row max and need 100,000 for our dataset for a grant-funded research project. Is there any way to get more rows without upgrading to the Enterprise plan? We do not need any other features that come with Enterprise, and as a nonprofit, we can not afford the plan. We just need more rows. Is there an "Enterprise Lite" plan?Thanks all!C

41
C
R
R_Dillon_EmericNew Participant
posted in Base Design
Press Multiple Buttons

Hi everyone, I have a table with a button field. Sometimes I need to click the button for one record, and sometimes I need to click it for multiple records. Is there a way to select all the buttons and have them activated. Sorry if my question doesn’t make sense. I’m just trying to save myself from hundreds of clicks.

217
Kamille_Parks11
G
groy8285New Participant
posted in Base Design
Scheduling Employees

I'll give an example to explain what I'm trying to do.  If I have employee x and I have 2 separate tables which schedules employees for a specific day, lets say 6 March 2023.  Is there a way to ensure employee x is not selectable as an employee in table 2 if they are scheduled in table 1 for 6 March 2023 already.  I already have 4 tables separating 4 different sets of instructors, which links to my schedules for my teams of students going through training.  At any given time I have 8 teams of students which all overlap each other on the same day.  So to make life easy for scheduling purposes, I want to ensure if employee x is scheduled on lets say Team 1, can I ensure employee x is not selectable on Team 2 schedule.  I hope I explained this well, and thank you for your time.

181
pressGO_design
A
anonymusNew Participant
posted in Base Design
Use Personal Access Token in Kodular

Pls help help me to get, "How to use personal access key in kodular.".....!!

10
A
J
jacklineKnown Participant
asked in Base Design
Capturing timezones

Hi,I have an airtable database that captures information from a tally form.One of the fields in the database is date created which is a formula and is the date when the form was filled in.Anyone can fill the form and I want to capture the time zone of who is filling in the form.Can airtable capture the time zone (of the person filling the form) together with the date and time of when the form was filled?I want to sent email reminders with automations based on the timezone of the specific user and creating different automations that work well with the different timezones will not work in my case.Thanks  

133
TheTimeSavingCo
A
AdyCLNew Participant
posted in Base Design
Can you format text in Gallery cards globally?

Hello,I am new to AT and am trying to create a Gallery view of my data. I can see how to enable rich text formatting in my long text fields, but I am wondering if there is a way to apply that formatting globally to a field instead of cell-by-cell. For instance, I would like all of the Project Names to be bold and h1 (# in markup), but I can't see how to make that happen. Thank you for your help! 

91
TheTimeSavingCo
L
lindsayadlerNew Participant
posted in Base Design
Linked Records Not Showing In Alternate Views

I have a base set up with a few tabs - one is vendor tracker with 30+ columns and another is a payment tracker for those vendors. I have multiple views set up of the vendor tracker (for ease of viewing and not seeing the 30+ columns) - contracting, payments, etc. and have linked columns so the records pull from the payment tracker. All works fine in the main view, however, when I go into any alternate views I lose the ability for the linked records to auto-populate.Any ideas? 

10
L
C
CatarinaIsabelNew Participant
posted in Base Design
Weekly tasks calendar

Hello.I've been using airtable to create a database for equipment files in a research facility.Now I would like to use it to organize our team weekly tasks calendar. Some of these tasks are performed on equipment that is in my first database.We are a team of 17 co-workers and most of the tasks need to be performed every day of the week in a set of locations (rooms). We always assign each task-location to one or 2 co-workers. There are some tasks performed only in specific days of the week in specific locations. Altough the tasks-location combo for each day of the week repeats between weeks, we keep the assigned co-worked in a rotation basis and this assignement is done on the week befire, to take into account their availability.I need help creating a base were we can have our tasks weekly calendar connected to the equipment database so people can record the maintenance/cleaning procedures performed in each serial number, and at the same time to generate a calendar view for each co-work

253
TheTimeSavingCo
D
DennisyuTSSNew Participant
asked in Base Design
Recurring Task and Sub Task once completed, duplicate with a different due date

I've built a task list table, and have some recurring tasks that comes with sub tasks in another table that are linked.I am hoping that when my Task is completed, airtable will create the exact same task, except to change the dead line based a formula field, and link up to a new set of sub tasks also created once this main task is done.I am doing this because I want to keep record of when the records were completed, using the last modified date field.Is this possible? 

382
D
M
magafrNew Participant
posted in Base Design
struggling with 1-1 table

i am strugling to figureout how to solve a need: i have built a CRM, i have +1000 recordsone table is the company list and one is the people listthen i need to manage different campaigns related to the list of my companies as an example "fundrasising event 1" and "fundraising event 2"for each of this campaigns i need several columns like (owner, status, notes, ...) till now i have managed this need adding same columns on the main company table.. fundrasising event 1 - ownerfundrasising event 1 - statusfundrasising event 1 - notesfundrasising event 1 - ...fundrasising event 2 - ownerfundrasising event 2 - statusfundrasising event 2 - notesfundrasising event 2 - ... but like this is not really scalablei was thinking to mange all campaign in a dedicated table the problem is that it look like there is not a way to make a kind ok join-right having all the company names prelisted i should associate any company record to a specific record of the campaign tab

112
TheTimeSavingCo
O
odbaNew Participant
posted in Base Design
How to build a base for volunteer management without duplicates? (Update record issue)

Hi there! We run various festivals and events, and have a base of around 400-500 volunteers who help us out on these events. For our last event, we moved all volunteer management over to Airtable which worked like a charm. I have all my volunteers in one table (with their personal data such as emails, phone numbers, food allergies etc.), and in another table I have the available time slots from our last event, such as "Ticketing on July 2nd from 0900-1000". I used a form under my Volunteer-table to fill the vacant time slots for our last event.Now, I've set up the time slots for our next event in a third table, and would like to reach out to our volunteers and ask them to sign up. However, I already have most of their data, so ideally, I would enable them to update their records with their chosen new time slots. If not, I would get a lot of duplicate records. Are there any way to do this? Ideally I would also enable the volunteer to update some of their record data.I've seen some

952
O
R
ritzy43New Participant
posted in Base Design
Struggling to build the correct base

I have been using airtable for a few weeks now and I am struggling to build the correct base that allows all of my data to link correctly.I am coach of a sporting team.  There is roughly 50 people on the team.I have created a base for the playersProblem moving forward is they have quarterly KPI's and testing.  So when I have been trying to organise accordingly, I almost feel as if I am inserting the same data againI also want to keep data of each game they play and because an individuals data is different, that is also an issue.  If anyone can help that would be great.Video is belowhttps://www.loom.com/share/bbdf849bbe814c1c864f4c61a070f652

01
Ben_Young1
A
Ar_AdNew Participant
asked in Base Design
Count to create a unique record ID

Hi all...I'm sure this has been asked before so apologies for asking again. I have searched but any article I think might give me the guidance I need ends up getting confusing...possibly due to my lack of understanding but I think at this stage, my best option is to ask myself.I've created a purchase order system and it's all working fine except for one thing. For the purchase order number, I want it to be "Year-Cost Centre-Number" with the number component being a sequential count of previous orders for that same cost centre. That sequential count is where I'm running into bother - so far all I've managed to achieve is a sequential count of all purchase orders which works, but it's not my ideal set up. My base structure is:Purchase Requests table - this is the main table and is meant to manage the whole purchase order processCost Centres - table of all cost centres, linked back to the Purchase Requests tablePurchasers - table of anyone with permission to request purchases (not re

502
A
H
Howard_CohenParticipating Frequently
posted in Base Design
Primary Field

I could not find an answer to this - is a [text] primary field case sensitive?

33
TheTimeSavingCo
E
EqualLegalAidNew Participant
posted in Base Design
In the expanded record form, is it possible to only add a new record (in a linked case field) ?

Hello eveybody, I am wondering if it is possible, when we want to add a new record (in a linked record field) not to have the possibility to select from an existing record but only to add a new one. Indeed, we are using in some cases this functionnality for part of the tram to link some procedure or consultation to a specific case (we go legal work) but the team seem confused when the list of existing consultations appear. We would like to give them only the possibility to create a new entry. Is it a possibility? I am also wondering if the preview of the record can be limited to the name of the record and not to include all those many information (also confusing the team a lot).  Thanks in advance.  

113
E
T
TomgerhardtNew Participant
asked in Base Design
Meta Data on Linked Records

I am building an inventory management base for my business and am running into a design problem:1. I have a table for parts.2. I also have a table for assemblies. Each assembly record has a field that links to multiple records from the parts table.Simple, however, I want to be able to say how many of each part goes into an assembly. Parts go into different assemblies in different quantities, so that data can’t (and shouldn’t) be stored in the part record.How can I say one assembly uses 2 of a part and a different assembly uses 3 of that part. (And I need a table of all the assemblies.) Hope that makes sense! I would appreciate any solutions.

143
T
V
VictorNNew Participant
asked in Base Design
Unrolling "linked" fields (or records (multiple) -> one-per-row conversion)

I have a table with the following infoTable1Candidate1 - role1, role2, role3Candidate2 - role3, role4Candidate3 - role1, role4I want to have a newTable2 that shows the status (this field I want to edit) per candidate per roleRole1 Candidate1 statusXRole1 Candidate3 statusYRole2 Candidate1 statusZRole4 Candidate2 StatusXRole4 Candidate3 StatusY.....Is it possible?I found this question; it is somewhat related, but it looks like it implements one-way syncing from Table1 to Table2 through JS.

122
TheTimeSavingCo
J
JavokhirAtaboevNew Participant
posted in Base Design
Creating a Table

Hi there,Is it possible to create a Table with the help of interface directly?if not, is there any other ways with creating a table using interface. 

01
TheTimeSavingCo
S
seanwhitcombParticipating Frequently
posted in Base Design
How should I change my base and workflow to incorporate expiring attachment URLs?

I have a base that stores plant information, including photos of each plant in an attachment field. I use a formula to put the attachment URL into a field. Here's what I do with that information to create a web map of my plants:1. Download a CSV of a table that contains the relevant data, including the attachment URLs.2. Upload the CSV into ArcGIS Online to serve as the data for a web map.3. Use the Attachment URL field data to display the plant photos in map pop-ups. You can see the result here. My attachment URLs are still working, but I know at some point they will switch to expiring URLs. I need to find an external storage solution that will allow me to do the following:1. Easily (automatically?) upload attachments from Airtable to an external storage location.2. Automatically link the new URL for each image so the Attachment URL field in Airtable now points to the storage location for each image. When I download the CSV from Airtable, I need a URL that points to the corr

30
S
D
DbucksNew Participant
asked in Base Design
Totaling multiple fields based on month

Hey Airtable community,My service business has multiple income streams, ranging from one-time to ongoing projects.I am attempting to create a table that can total both one-time revenue and requiring revenue for the month that income comes in. I am having a hard time getting my head around how to do this.I first have a date column with the date the project started and then a formula column that formates the date to just the month so that I can group by month.Currently, I'm only accounting for one-time revenue. I was thinking I could create another date column with automation to duplicate on the same day every month for recurring payments. From here, I don't know how I would total both one-time and recurring payments in a given month?Any help would be greatly appreciated!

320
D
D
daspruneNew Participant
asked in Base Design
how can I create a database which tells me whether I have enough stock to make a product

I run a small company that makes products using parts from an inventory and sells them to vendors. I'm trying to achieve the following - I receive an order, I enter the order as an invoice which includes all the information about which products are ordered, the database checks the amount of raw parts I have in stock and tells me whether I have enough to make the products in the order. Currently I have few tables with junctions between them - a table with a list of parts, a table with the details of products and what parts are needed to make them, a table with a list of products with each product as a one line entry. Then I have invoices and a junction with invoice detail which use the product information. Currently I am using a one line entry to indicate whether an invoice is yet to be made or completed, I want a system that will tell me which parts I need to complete an invoice and then whether I have enough, which parts of the order can be made ok and which can't. I don't w

93
D
D
David-moojoNew Participant
posted in Base Design
Hello How to retrieve the index of the DTC Brands ?

hello I am looking to get some bits of the base name " the index of the DTC Brands", do ou know how to get it please? 

31
TheTimeSavingCo
C
changireneNew Participant
posted in Base Design
CSV Import: Duplicate data errors

I have a problem with CSV import that is messing up all the data. When I try to import CSV with more than one record with the same Primary field name, it updates another field to be the same. For example: Data 1:  Frederik (Primary Field) | Kiyomizu 1 (Field) Data 2:  Frederik (Primary Field) | Kiyomizu 2 (Field) Data 3:  Frederik (Primary Field) | Kiyomizu 3 (Field) It updates as: Data 1:  Frederik (Primary Field) | Kiyomizu 1 (Field) Data 2:  Frederik (Primary Field) | Kiyomizu 1 (Field)  <--- incorrect data in fieldData 3:  Frederik (Primary Field) | Kiyomizu 1 (Field)  <--- incorrect data in field Is there any way to work around this glitch? Please help! Thank you

1194
C
M
Mae_InfanteNew Participant
posted in Base Design
Extension (page designer) syncing to multiple bases

Hi All,I'm trying to sync an extension (page designer) from my primary base to another base.All of the information are reading from the primary base and been syncing to the 2nd base. I just need to reflect whatever is on the extension to the 2nd base.Is there a way to do this?Thanks in advance!

71
Karlstens
T
tomn68New Participant
posted in Base Design
Lookup Field inserts comma if pulling two records

Please bear with me since I'm new to Airtable and this is hard to explain.  I've inherited a base which contains details on job descriptions which is to be used to merge into a Formstack docs.Main Tab lists the details of each job description in rows. (eg. title, reports to, requirements level, requirements...).  2nd Tab contains job requirement levels in rows.  (eg Level 1, Level 2...)  A column in this second tab contains bulleted lists of the requirements.  The main tab has a column for Requirement Level(s) and a job can have multiple levels linking to the records in the 2nd tab. So this column has links to multiple records/levels. The problem is with a lookup field/column in this main tab. It pulls Levels requirements (pulling from multiple records if more than one Level). So returning and combining bulleted lists from multiple records.However when it does this, it will automatically adds a comma into the lookup field between the bulleted lists from the rec

151
Ben_Young1

Badge winners

Show all badges
Terms & Conditions