Table Group By Function

App Building
1

Is there a way to make the table group by fields that you select in the table footer to be the default settings for the table? I tried doing it in a query and it didn't work.

SELECT *
FROM shipping
  LEFT JOIN pools_built ON shipping.serial_num = pools_built.sequence
WHERE ({{ !date79.value }} OR ship_date = {{ date79.value }})
GROUP BY shipping.load_time, shipping.load_num, shipping.shipping_id, pools_built.id
ORDER BY shipping.ship_date ASC, shipping.load_num, shipping.load_order, shipping.dealer
2

Hey @tomm,

Yes, you can find that option in the table's "advance settings", see below screenshot:

image
image936×366 28 KB

Is this what you're looking for?