Hi,
I want to build a feature to create a csv file with data from 3 different tables. How can I do this?
I have Shopify_Orders, Shopify_Ord_LineItems, Shopify_Order_Statuses.
Shopify_Ord_LineItems → Details of different line times in an order
Shopify_Order_Statuses → Delivery Status of the order.
The report I am creating should have fields from all these three table. How can I go about doing this?
You can use the plugin “1T CSV”
You could also create a report table with the fields you need to export, consolidate the columns of data into that table, and export the single table on demand using the Bubble plugins. It might use more WU but gives you a lot of control.
In terms of data modelling, I’d name this kind of table “Report [Something]” to separate it out from the main app data.
Yes that’s a good idea. I have implemented it more than once and it works really fine and as you said it gives more control
