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

Base Design Activity

Resolved! Import with linked data

HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import...

  • 246 Views
  • 3 replies
  • 0 kudos

Resolved! Get latest order for a customer

HiI have two tables Customers and Orders.  They are linked on CustIDI want to be able to find the latest order date (Order Date) for each customerAny ideasThanksMike

  • 123 Views
  • 3 replies
  • 0 kudos

Resolved! Data estructure

Hi there: There are two records with to dates, I need to use the DATETIME_DIFF function, but it only works If I have the fields side by side, not in two diferent records. How can I work this out?

Captura de Pantalla 2024-02-22 a la(s) 19.07.38.png
  • 594 Views
  • 4 replies
  • 0 kudos

Resolved! Three-level nested tables for small business

For my small business, I have three levels of information I'm trying to manage. I have (a) the human client, (b) their pet, and (c) the services that they want for their pet. Each human can have multiple pets, and each pet can have multiple services....

  • 138 Views
  • 1 replies
  • 0 kudos
ahj by 4 - Data Explorer
Solved

Resolved! Can a form be used to enter new info for two different bases?

Hi everyone, a coworker and I are designing a new AT system to help our communications team manage content production, marketing campaigns, and individual tasks related to both content and campaigns. To solve for multiple needs and use cases, we're t...

  • 125 Views
  • 5 replies
  • 0 kudos

Preserving existing record values while updating a pay rate

I have a payroll base that tracks timesheets and commissionable transactions for our employees. It includes the following linked tables:EmployeesTimesheetsThe Employees table includes information for name, address, email, etc. Additionally, there is ...

  • 82 Views
  • 4 replies
  • 0 kudos

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
  • 70 Views
  • 1 replies
  • 0 kudos

Navigation in New Base

Very new user here.I have a simple base with one table and one form.  It is designed to add new people to a mailing list.  I created a form to add new records, and that seems to work fine.  Now I need to create a navigation.  I would like to see a si...

  • 132 Views
  • 6 replies
  • 0 kudos

Connect to multiple tables for "link to another record"

Is it possible when selecting "Link to another record" to be able to connect to multiple tables? I can only see the option to link to one table (multiple records, yes, but multiple tables, no)? Or any workarounds for this?I'm building out a content m...

  • 82 Views
  • 1 replies
  • 0 kudos

Resolved! Why can't I convert text to date when importing excel sheet?

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my ...

jaymees_2-1708335245151.png jaymees_0-1708335124579.png jaymees_1-1708335204122.png
  • 90 Views
  • 2 replies
  • 0 kudos

How to filter linked records?

I have two tables:A. MeetingsB. Representatives'Representative' on table A (Meetings) is a 'Link to another record' leading to the items on table B (Representatives).I have a need to filter the Representatives table so that it'll show stats for a giv...

Roy_Golan_0-1708330168131.png Roy_Golan_1-1708330196160.png Roy_Golan_2-1708330689151.png Roy_Golan_4-1708330926704.png
  • 94 Views
  • 2 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...

  • 89 Views
  • 2 replies
  • 0 kudos

Don't know how to make this architecture

Hi everyone.I'm helping a teacher to manage student's lessons.Let me tell the need:There are lessons that students have to assimilate.Each student is in a group.Each group has courses.During this course, teachers note progress for in lesson for stude...

  • 92 Views
  • 2 replies
  • 0 kudos

Limit Multiple Selection total

Hi there! I'm trying to design a base with a public facing form for camp registrations. I was planning to use multiple select as the camp selections field, so folks can sign up for Camp A, Camp C, and Camp D all through one form. Where I'm running in...

  • 145 Views
  • 6 replies
  • 0 kudos

Link tasks in Kanban board

Hi, My team have being using the Airtable and the Kanban view for almost two years now. We have for a while lacked/cant set up a link between two tickets on the board. Just a simple link, so we don't forget an input or task.Is this possible? and how ...

  • 52 Views
  • 0 replies
  • 0 kudos

Creating Junction Table

Hi Everyone, Thanks for your help in advance and ill try articulate this as best i can.Im trying to create a junction table from 2 tables.One being a table that contains "new leads" exported from a CRM. It contains a persons name, contact details  pr...

  • 77 Views
  • 1 replies
  • 0 kudos