Skip to main content
Question

Base design ideas

  • February 23, 2026
  • 2 replies
  • 92 views
Barry_Seidensta
Forum|alt.badge.img+8

Attached is a screen shot of a small part of a schedule of conference that a large number of rooms (80) across 4 hotels

that has numerous sessions per day over a week. I’ve used AT for many years, but I’m struggling as to the best way to design this base to get the most benefit from AT. I want to move out of the g-sheet to unable sort, group and filtering by different staff at different properties with different roles. Any suggestions would be appreciated. I did contribute a base, but it is for a different style event. I want to be careful to not create additional complexity in the base design. https://www.airtable.com/universe/expc6PovQs6jz2O4C/master-plan-for-a-massive-corporate-event

    2 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hm, off the top of my head I would have:

    1. Rooms
    2. Sessions

    And I’d have an automation that would help me automatically create the ‘Session’s records for every room, and then I’d fill those out

    e.g. the ‘Carnation’ room would have an AM and PM record created from April 25 - 30

    I’m not familiar with the full extent of the business logic though and assume that that doesn’t work for you?  If you could talk a bit about what other functionality you may need I’ll see what I can do to help!

    Adam, Airtable Consultant - thetimesaving.company
    Barry_Seidensta
    Forum|alt.badge.img+8
    • Barry_Seidensta
    • Author
    • Participating Frequently
    • February 26, 2026

    Thanks Adam. I did create three tables - Venues, Rooms and Sessions. In the fourth table I want to create the agenda. In the first column I want to create a formula that concatenates Room plus Venue by linking to the their tables. I tried using the AI tool, It gave me something that did not work. Any suggestions?https://airtable.com/appu4PR7Xu3raOYdj/shrfzIf6X7FMzSKJ4

    Terms & ConditionsAccessibility statement