Hi I have a Inspection (Audit) app consisting of 120 questions. Questions are grouped together in categories. Each categoryโs questions are in a different Table structure. I now what to generate a view that will give a user a overview of a number of issues, Number of audit failures, scores etc. This however needs to be in a single view based on all the Tables. Is there any way of doing this? I was adviced to create an additional Table and then to use Virtual columns to create summaries. Canโt see how this will work to get data in the right order (store name, date, category, score)
LinkedIn
Twitter
