Loading data from spreadsheet/database into AppSheet application without creating the table

Hi everyone, in my application, I have several tables which are described roughly as following:

 

1. Main tasks (only managers can have access to this table to add any tasks into daily tasks)

2. Daily tasks (managers and employees both have access to this table with different privileges. In this table, employees will be able to insert up to 5 pictures. At the end of the day, the managers will sign off each completed tasks)

3. Location of tasks (I connected this table to the Main tasks table in order to show the location where the task should be handled by the employees)

 

**Main tasks and Daily tasks tables consist of about 42 columns**

 

So I set the action of my application where rows of data in the Main tasks table can be pushed to the Daily tasks table and afterwards delete the particular row of data in the Main tasks after it has been successfully pushed to the other table.

 

In the future, as days go by, the data in the Daily tasks table will increase and I believe the sync time for my application will also take some time due to the amount of pictures and signatures (in the image form) will have to be loaded every time managers/employees load the application. There has been already cases where my application will just close or crash while syncing.

 

I have thought of a way of pushing all the signed off tasks from the Daily tasks table to another table which I may call it as (Verified completed tasks) so as to reduce the loading/syncing time at the Daily tasks table. This particular Verified completed tasks table will only be accessed by managers or clients to see the lists of the signed off completed tasks.  

 

This brought me to think if is it possible to fetch data from a spreadsheet or a database (in my case pulling data from my Verified completed tasks table) without having to load them into AppSheet? I believe with this way, it will not increase the time taken for the app to load all the information properly or I should say overload my application with the amount of data (images especially). Furthermore, my data is approximately about 4000+ rows in my Main tasks table and each item in the future will consist of 1-5 images when employees attach them at the Daily tasks table. 

 

Thank you everyone for reading my long post!

0 4 580
4 REPLIES 4
Top Labels in this Space