# Service Requests: With automatic notifications **URL:** \ **Category:** Project Showcase\ **Created:** [March 24, 2020, 6:02am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753 "2020-03-24T06:02:08Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 24, 2020, 6:02am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/1 "2020-03-24T06:02:08Z")
A little background: This app is created for a customer care team to track all the complaints received from across India for the products they have installed at various places. They have a team of 30 technicians who are spread across 9 zones. Each zone has a zone incharge. First a complaint is received by the customer care team over the phone and is added to the app. The complaint is then listed in the app with various emblems to track its status. ![s2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bcea62d6a6c6fc4cb7c77bd882cc11fd3e7c51f8.png) ![s1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3a4fbdd659369607b9eac10298e891efbbbe02e2.png) Each complain has a choice component for the zone and the complain is forwarded to the specific zone incharge for assignment which can be done by opening the complaint and choosing a technician from a choice component. ![Assignment](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/521d35a36ab5df0823825714c777004d0b60d700.png) Once this is done, Messages are automatically sent to the customer and the technician through the google sheets using google scripts in conjunction with an external API built to automate messages. ![WhatsApp Image 2020-03-24 at 10.55.03 (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ec9a8786ef95f4519f90272b9506dc7793f1a7e4.jpeg) ![WhatsApp Image 2020-03-24 at 10.55.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a4b0048863a169c619d969038039b64cb88598bb.jpeg) The complaint can now be seen on the technician’s app by logging in with their email and they can solve the complaint there by entering relevant details. [Watch video](https://drive.google.com/open?id=1EfDmUou4hzAIXixOQAEZkCls1DeLza_-) Once this is done, another message is sent to the customer as a confirmation along with the expense amounts. ![WhatsApp Image 2020-03-24 at 10.55.03 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1bb3adf7a62e8666ad133811a01d4bdbdac243ea.jpeg) Note: Messages are triggered every 15 minutes (can be triggered every minute) using google scripts.This is an internal application and hence cannot share the app links here. Sorry for that. Using Glide, this was a quick and efficient way to create a complete system to optimize an ongoing process. Thanks for showing interest previously which motivated me to create a post @sardamit @vijay @Hemmings ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [March 24, 2020, 12:33pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/2 "2020-03-24T12:33:22Z")
Thanks, @Manan_Mehta for the description of the app. The app is simple and powerful. I look forward to creating such an app. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 24, 2020, 12:37pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/3 "2020-03-24T12:37:06Z")
Would be happy to help if needed! ---
**Author:** ![MI\_I](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mi_i/32/2794_2.png) [@MI\_I](https://community.glideapps.com/u/MI_I)\ **Post date:** [March 25, 2020, 10:40pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/4 "2020-03-25T22:40:43Z")
You can use formula contrate and cotranate’ on your sheet to whatsapp… … ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2020, 12:38am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/5 "2020-03-26T00:38:53Z")
Hi, Interesting the fact to send messages via Whatsapp from Google Sheets. Any guide or tutorial to know the API and commands in Google Javascript? Thanks for your help! Saludos ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 26, 2020, 4:42am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/6 "2020-03-26T04:42:05Z")
Hi @gvalero! This was something that I found out online to integrate whatsapp > **[WhatsApp Send API or Click To Chat Automation using Selenium & C# -...](https://www.craftedforeveryone.com/whatsapp-send-api-or-click-to-chat-automation-using-selenium-and-c-sharp/)** > > WhatsApp Send API or Click To Chat bot automation using Selenium and C# without saving the user contact or number in phone. But I am not a coder hence I couldn’t create it on my own and had to use some external paid help. I found somebody who could create a tool with a SaaS model and that is what I am currently using. It is a simple API link which needs to have the message to be sent and the mobile number of the receiver and when the link is opened, a whatsapp is automatically sent by a predefined number. Then all I had to do was to embed the link in my google sheets and write a script to open the pending links every 15 minutes to automatically send the messages. I could get you in touch with the coder who has done it for me if you need. Hope I am making sense. Thanks! ---
**Author:** ![Max\_Makhrov](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/max_makhrov/32/2478_2.png) [@Max\_Makhrov](https://community.glideapps.com/u/Max_Makhrov)\ **Post date:** [March 26, 2020, 1:19pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/7 "2020-03-26T13:19:53Z")
> [@Manan\_Mehta](#): > > script to open the pending links every 15 minutes Hi, [Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)! Thank you for the example! Could you please share the Apps-Script code sample for opening URLs. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2020, 3:12pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/8 "2020-03-26T15:12:31Z")
Thanks for the offer @Manan_Mehta! Let me try by myself, now I have “a lot” of free time 🙂 If I find another workaround I will let you know, very interesting and usefull your app. Just to know, if you would sell your App to another customer, how much will it cost? Best regards Gavp ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 27, 2020, 6:24am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/9 "2020-03-27T06:24:01Z")
This is a part of the code to fetch the URL as per some given conditions according to my use case. > if (values[i][0] != ‘’ && values[i][17] == ‘’ ) { > Utilities.sleep(5000); > UrlFetchApp.fetch(data101); > [//s15.getRange](https://s15.getRange)(“A41”).setValue(data101) > var row = +i + 2 > ss.getRange(row, 18).setValue(3); > SpreadsheetApp.flush(); > } > And this is triggered every 15 minutes using the trigger function. > You can connect with me personally to understand better! ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 27, 2020, 6:28am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/10 "2020-03-27T06:28:36Z")
Hey @gvalero! This is indeed a very productive way to use the free time. 😉 When it comes to selling the app I would have to know the exact use case of the customer so that I can customize that accordingly and hence I cannot tell you a cost without knowing more details. We could discuss the use case, the customizations required and the cost on a personal level if you are interested! Best Regards, Manan Mehta ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [March 27, 2020, 11:47am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/11 "2020-03-27T11:47:50Z")
Hi Manan, I have a question. You have kept the customer separate from this app. Meaning you have customer call the customer care team, and then the app is used by the customer care team. Any reason why the customer cannot use the app and fill in the details of the problem right in the app? Have you thought about integrating the customer part into the app as well? Because, I wanted to develop an app that has students and tutors using the same app, and students asking questions to tutors. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 27, 2020, 11:53am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/12 "2020-03-27T11:53:20Z")
Hey Vijay, I could easily give the customer access to the same app in order to add complaints and make them the row owners so that they can see only the complains that they have added. Infact I could allow anybody to add the complain through the same app. But in this case, the company has more than 5000 existing customers who have already been given a customer care phone number and sharing the app with all of them and expecting them to fill in the details wouldn’t be feasible for this specific case. But it can be done. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 30, 2020, 11:38am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/13 "2020-03-30T11:38:43Z")
To get a Quick idea of how it works you can check [wfhome.glideapp.io](http://wfhome.glideapp.io) and assign tasks to your team and get whatsapp notifications when you do that. The new app (Task Assignment) has been created using what I learnt from this one and is a public app which can be used by anybody. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 31, 2020, 7:54pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/14 "2020-03-31T19:54:27Z")
Hi @Manan_Mehta Just to confirm something: does your APP send WA messages without any confirmation? I mean, is there no need to push any “Send” button? Thanks?. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 31, 2020, 9:05pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/15 "2020-03-31T21:05:30Z")
Yes @gvalero it does send it automatically without any confirmation. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [May 26, 2020, 9:05pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/16 "2020-05-26T21:05:49Z")
In detail here: [WhatsApp notifications](https://community.glideapps.com/t/whatsapp-notifications/9803) ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [May 26, 2020, 10:48pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/17 "2020-05-26T22:48:46Z")
Thanks a lot @Manan_Mehta I’m working on it and studying your way. Do you hav an app to test or copy to learn from inside how you didit? ---
**Author:** ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\ **Post date:** [August 7, 2020, 8:26am UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/18 "2020-08-07T08:26:36Z")
Great. Nice Work. What mechanism are you using to autogenerate service request number? Can you share the formula or script? ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [August 7, 2020, 8:32pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/19 "2020-08-07T20:32:43Z")
``` =arrayformula("P-"&DAY(B2:B)&"-"&MONTH(B2:B)&"/"&LEFT(G2:G,1)&countifs(G2:G,G2:G,row(G2:G),"<="&row(G2:G))) ``` B2 has a date column and G2 is the name of the technicians. This ensures unique service request number always and gives information also if I want to open a backdated request. You could tweak this to make it simpler. ---
**Author:** ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\ **Post date:** [August 7, 2020, 8:56pm UTC](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753/20 "2020-08-07T20:56:13Z")
Thanks a lot. [Next page](https://community.glideapps.com/t/service-requests-with-automatic-notifications/5753.md?page=2)