I have Google Sheets document where each row represents a contact and their schedule.
I want you to add a new sheet that allows me search and then display and edit the data which would then be saved back to the original sheet when the save button is pressed.
It needs to work like this:
Use Google services on a new sheet to allow me to get data from my original sheet:
1. On new sheet, search original sheet by entering a zip code … show names of all entries with this zip code.
2. Allow me to select from the results of the above search …
3. Now display all the fields and the title of said fields from the associated selection that was chosen in step 2. (Create a nice user interface )
4. Allow me edit the fields from step 3.
5. Provide [Cancel] and [Save] buttons. If save button is pressed then write all the new and/or updated data back to the original cells from where it was taken. If cancel is pressed then just clear the data and return to the search.
6 pekerja bebas membida secara purata $153 untuk pekerjaan ini
Dear client I saw your requirements regarding to google sheet app script for manipulation. I can develop this application with in a day maximum. Let share further details. Warm Regards Kannadasan K