Is it possible to build an AppSheet app using data from multiple workbooks at the same time. Or does all reference worksheets have to be in the same workbook being used by AppSheet? For example, my primary app will rely on dynamic data created daily, exclusive to that particular date. The app in using this specific data will reference static data, which being static resides in a separate workbook. Customer information and setup information for example. So the dynamic database has an id for a customer, and a permit number for which can be used to reference associated data in the second workbook, to which it will populate form fields based on that query.
Iโd prefer not to have to duplicate the customer and permit tables in every unique daily workbook if I donโt have to.
LinkedIn
Twitter
