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

Base Design Activity

Convert Single Select to a Table

Hi All!I am trying to change a single select field in my base to a linked field, with all the single select options populated as rows in a new table. I have a long list of single select options that I do not want to have to re-type manually if possib...

  • 15 Views
  • 2 replies
  • 0 kudos

Dynamic Filter on Lookup

 Hi guys, On my [Revenue] table, I'm trying to compute the expected revenue that I'll get from a client. The client processes payments twice a month after the work sessions are completed. We have struck a deal that spans multiple payment periods. To ...

JBJ_0-1733232048212.jpeg
  • 25 Views
  • 1 replies
  • 0 kudos
JBJ by 6 - Interface Innovator

Building multi-company system with Airtable, db design

Hi,So far we've been building a small CRM for internal use. Out of curiosity I started wondering if it would be possible to re-design it to support other companies. I've seen multi-company databases having an owner identifying prefix to fields, e.g.c...

  • 23 Views
  • 0 replies
  • 0 kudos

Best Practices for Structuring Tasks and Issues

Hi Airtable community,I’m seeking advice on the best way to structure a base that involves Tasks and Issues, which have overlapping fields but serve distinct purposes. Here’s the situation:Issues: These require detailed tracking and notes, including ...

  • 27 Views
  • 0 replies
  • 0 kudos

Pros and Cons of a Master Contact List

Right now we have a few different bases where contacts live and we're thinking of restructuring our workspace so there is one master contact list. Within the master contacts table we will have filtered views that can be synced to the relevant bases. ...

  • 53 Views
  • 1 replies
  • 0 kudos
JJJ by 4 - Data Explorer

Not all records have the same fields

Evening All, I'm building a data structure in airtable to represent a rather large tree style database. We're talking about 50k to 100k objects in the tree. I've got the heirachy view working quite nicely by uploading the components using the api, an...

  • 94 Views
  • 1 replies
  • 0 kudos

Employee Hour Reporting

I have a group of freelancer reporting weekly on how many hours they worked on various projects. Im looking for a way (either through a view or interface) to see a report of how many hours are worked, by each employee, on each project, per week. 

  • 87 Views
  • 1 replies
  • 0 kudos