I am creating an app that will be used by 2 groups of users, from separate clients. Each clients needs to see data that is exported from their legacy system. The legacy systems create scheduled csv files automatically to dropbox.
Client 1 has theirs in a folder shared between me and their server. Client 2 a similar folder. This means that neither client can see the others data. How do I structure AppSheet so that it can pick up the relevant CSV based on the current user? All other tables are static exports and have been combined into a single table with a Client Column and filters to segregate the data.