Hi guys!
I'm working on creating an order form and I'm struggling to find any information on how I could achieve some of the dynamic features I envisioned 🙂 I was hoping you could advise on some creative ways to do it.
The main challenge is that there will be different kinds of products and I'm creating separate sub-forms to guide users on the attributes they need to provide (e.g. a brand for a car or a quantity for crayons). I'm storing my data on a SharePoint list and want to have one record per order (not split them into rows). I was thinking about storing collections or html tables in cells to save that but didn't come up with the best solution yet.
Another functionality will be a gallery showing all products within an order. The challenge here is that galleries are pretty static when it comes to what they show (i.e. the same label applies to all items in a gallery). So, my questions are:
1) How would you save the data on a SharePoint list (or maybe an alternative?) in a way that's efficient and easy to read fro the app?
2) How would you show the details of the order to end-users?
I'm attaching screenshots to show an example of an order and how I would show that to the end-user. It's probably impossible to create, but maybe you've seen a similar idea in the past and had an alternative solution?