Need an App in appsheet which stores data in Google sheets. Appsheet will have UI/UX for one person to input data "Month"(Dropdown), "Year"(Dropdown),Tower(Dropdown options A,B,C), Flat no Dropdown (Dropdown 1..20), and Maintenance Amount (textfield - numeric only).
All data that is entered must also be saved in Google sheet as per year & month.
There is another google sheet where contact details are saved of all flat owners which must be used in the the appshet when Maintenance amount is filled an invoice must be sent to the corresnponding flat no's email id saved in other sheet.
3 freelancers are bidding on average $60 for this job
Hello, I have done lots of work in google app script and google sheet automation. you need a webApp which have some dropdowns and save it in google sheet. and mail invoice to corresponding flat owener. I can do this.