Can one of my field types be a list of things from a different data type? For example, if I was talking about ice cream flavors (data type) and ice cream orders (data type) but one of my fields under ice cream orders was a list of flavors… Can I use lists this way? Is it allowed? Also, how could I tell the database which flavors are on the order in this example?
What I recommend doing is building a 3rd data type to join tables, called ‘OrderFlavors’ (or similar). The table is comprised of type Flavor and type Order. When you create an order, the order is the Order #, and it has a field of OrderFlavors. When you add flavors to an order, it both creates a new OrderFlavor, and adds that OrderFlavor to the new order. This is also helpful as each flavor on each order will most likely have customizations (such as 1 scoop vs 2 scoop, waffle cone vs cup, etc) that you can just include on the OrderFlavor data as well. It will allow you to keep your data much more organized .
Your page build would be type ‘Order’, and then within that group your repeating group would be type ‘OrderFlavor’ and the data source ‘Parents Group Order’s OrderFlavors’.
1 Like