Duplicating tables? Formula?

Hey, I’m super excited to be here and learn coda.
I’m building a inventory management database for a rental activity.
Here’s my issue:

Objects is a table containing all the rentable objects.

Sets are tables containing combinations of Objects + a lot of other data.

Each Booking is associated with a Set.

I’m looking for the best way to format Sets.

  • A table template that is reused for each set/booking?
  • A big unique table containing multi select object rows?

What do you think? What would be the best course?
Thank you
Iko

1 Like

HI Iko

Welcome to Coda! Glad to see that you are enjoying Coda.

I am going to give you a consulting answer… :wink: - It depends.

Do you frequently re-use sets? How big are the number of rentable objects and other data?
What is the relationships between Rentable objects? :
Row 1 Object
Row 2 Object
Row 3 Lot
Row 4 Of
Row 5 Other
Row 6 Data

OR

Row 1 Object, a lot of other data, each in a column
Row 2 Object, a lot of other data, each in a column

Depending on the answers to the above, your design could change tremendously.

In general though, there is now one correct way, the best way, especially so early in learning Coda, is to experiment to see what works best for you.

Regards
Rambling Pete

1 Like

Hey @Piet_Strydom thanks for your feedback

Going for:

First design idea is to have a Sets table, each Row for a unique set, and a column containing references to the objects contained in the set.

I’ll let you know what I come up with.
Iko