LinkedIn
Twitter
Hi,
i am working on an app that works as a data record of our customers , our maintenance team visit their sites and use the app to calculate the exact amount of chemical needs to be dozed for their industrial plants.
our team member can first select the client in app then in another tab all the available plants of that client is displayed he then select the relevant plant after that in next field all the towers related to that plant is displayed , he then select the relevant tower after that he starts inputting the data and save.
he repeats the above process for all the plants and all the towers and record their data in app.
till hear everything works fine and data is recorded but this data will be viewed by relevant client so that he knows what's going on .
to display the data i used detail view where client first select the plant then select the tower then some action buttons are visible to him and upon clicking on each buttons relevant reports are displayed.
now the problem is i have used quick edit so that he can select plant and quick edit for tower , the problem i am facing is when he selects plant or tower through quick edit the data in the google sheets also edited and i have also created a reset action button which resets the fields of plant or tower but when he clicks on that reset button the row also remove the data of plant & tower in google sheet.
i have tried this with form view but in form view action buttons can't be displayed.
i have also did another thing , i have created another sheet in google sheet with the name Filter and put plant & Tower as to columns and use it for quick edit in detail view so that the actual data cannot be edited but hear i face another problem if the filter sheet is empty it canot display anything.
please guide me how i can preform the above mentioned task , should i use dashboard view or something else.
i am attaching 2 screen shots in one screen shot action buttons are displayed and in second plant and tower selection are displayed
Thanks in advance
