Help
Base Design
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Design bases all linked to a single key

HiI am a curriculum coordinator in higher education and have multiple bases/tables/forms that contain/gather information about course units in the curriculum. All information always relates to a course unit, e.g. Business Economics. All the informati...

IrisDR by 4 - Data Explorer
  • 24 Views
  • 1 replies
  • 1 kudos

Multiple Row Input

Hi! I'm working with a customer who needs a general warehouse control for his business. I have created the base and all works fine. Here is my problem...When merchandise enters his warehouse, it goes into his inventory. Currently, he adds 1 or 2 prod...

ARiios by 5 - Automation Enthusiast
  • 43 Views
  • 2 replies
  • 0 kudos

Recovering lost data after importing bases

Hi everyone! I was wondering if it's possible to recover lost data after importing bases. When I copied and imported a whole table to a new blank one, some of the data was imported, but some other was lost and I have blank fields now. Namely; the att...

Automatically link to multiple records based on selection

I have a question that I can't seem to find the answer to. I have two tables within a base. One is a list of employees with their names and teams. The other is a list of Scheduled trainings. On the Scheduled table, I have a field that I fill in for p...

pricece by 4 - Data Explorer
  • 42 Views
  • 2 replies
  • 0 kudos

Many Linked tables, too many records - direct sync?

Hey,My main table has a few dozen thousands records. In order to complete the process, I also need data from around 10 different tables, each of them also has a few thousands records. If I want to aggregate data from all of them in the main table, I'...

Tecky_x by 4 - Data Explorer
  • 135 Views
  • 1 replies
  • 0 kudos

Creating a growth measurement over time

Hi there. For a while I have been trying to figure out the following. Maybe you can help.  For our participants we measure there progress over time. We do this by filling in a form about every 2 months.  We have one base with all the participants (pe...

SidStunt by 5 - Automation Enthusiast
  • 95 Views
  • 2 replies
  • 0 kudos

Share and sync data from multiple workspaces into another

Hi, I would like to be able to share and sync data from multiple workspaces of clients to 1 table in my own base/workspace. For example, I have 10 clients with 10 fields in their base and I would like to have 2 of those fields automatically synced an...

Marksteady by 5 - Automation Enthusiast
  • 142 Views
  • 2 replies
  • 1 kudos

Select multiple records at once in a linked records field

I'm working on tracking progress for multiple offices and their checklists. Currently, I have two tables - 1 with the Checklist and 2 with the Progress Report. The Progress Report is setup where the first column is the office name and the linked reco...

melmusic by 4 - Data Explorer
  • 150 Views
  • 2 replies
  • 1 kudos

Sort in Rollup field results

Hey amazing people I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is...

Shannon_Bradley_0-1692677780365.png Shannon_Bradley_1-1692677816434.png

Combine external data source with existing table

Hello, I want to have a merged table consisting of entries I manually created plus entries with the same data structure that i fetch from an external data source via API.The external source could be updated in the future and ideally I'd want the reco...

A/V Rental Company Inventory System

Hello! Who is an export in building short term rental inventory systems in Airtable?I work for a A/V production company that rents out LED Tiles and Audio equipment to trade shows. We'd like to build an inventory system that tracks gear getting rente...

Seanb106 by 4 - Data Explorer
  • 296 Views
  • 3 replies
  • 0 kudos

Resolved! Create a field that is 6 months after the last date entry in that row

Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mi...

Screenshot 2024-02-28 at 15.41.10.png
Nikiska by 6 - Interface Innovator
Solved
  • 258 Views
  • 3 replies
  • 1 kudos

Delete or disable database snapshots from an active base?

Would it be possible to disable database snapshots, delete/clear out database snapshots, or configure snapshots to ignore specific fields?The way database snapshots currently function undermine any meaningful data deletion or redaction strategy for a...

Linked Record - editing the displayed fields

I have a screenshot above where the linked record displays Tags and Employee ONLY. I discovered that they normally pull the displayed fields from the primary view of the table. However, I already checked my Tasks table but I really cant find the view...

mikeeTHINK_0-1708517262737.png
mikeeTHINK by 4 - Data Explorer
  • 151 Views
  • 1 replies
  • 0 kudos

Which is better: Single select vs Linked record?

I usually use linked record for choice option instead of single select, just in case of use with other tables. As my records keep growing, I am worried about the record limit.Does number of choice in single select also count as record limit per table...

Asa_Wu by 4 - Data Explorer
  • 192 Views
  • 2 replies
  • 0 kudos

Resolved! Form View: US State drop down field

I am creating a form for our website that I will need external users to fill out. I want to minimize user input error so I have created a table with state names/abbreviations to link to the form. When they start to fill out the state it populates opt...

lou2 by 4 - Data Explorer
Solved
  • 287 Views
  • 4 replies
  • 1 kudos