Hi, I have almost completed data viewer part of my app. I have a single G.Sheets document and 8 sheets within the file. The first sheet (sheet1) contains raw data and others contain various filtered/averaged/etc versions of raw data. All works perfectly well. But, this is just for one type of data. Problem is, I want to add 5 or more data types which will be handled exactly the same way (same way of averaging, filtering, viewing… etc), and want to switch between these data types, so user will be able to view/filter one type of data, at a time.
My question is, what will be the best way to handle such scenario? Should I create one Google file for each data type and make a switch button to change everything from one file to other, or should I add all different types of data to same sheet1, add a data_type field, filter according to enum_selected data type and continue from there? (In future, I will add a location variable also, on top of data type, rest will be same). What might be the best approach, considering thousands of records will be created by users for each data type ? TIA, Alper