# Regarding Sales app **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2020, 7:18pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600 "2020-05-06T19:18:51Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 6, 2020, 7:18pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/1 "2020-05-06T19:18:51Z")
We are building a sales app and have following topics to understand: 1. How to integrate follow-up reminders notifications in app. 2. Is there a web interface of sheet which is accessible to users for bulk entries. 3. We see phone and text option, is there an option to add whatsapp as well. ---
**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 6, 2020, 7:24pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/2 "2020-05-06T19:24:39Z")
1. Currently Glide does not have push notifications but there are plenty of workarounds for that in the forums. One of the options is shown in link below. 2. No but you could always create a separate sheet for users to bulk add and use importrange to import the data in your app sheet. 3. You can use a button (or a link component) and link it to whatsapp business API to have a WhatsApp option. For WhatsApp notifications check out: [Notifications](https://community.glideapps.com/t/free-push-notifications-solved/6183/28) ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 8, 2020, 7:45am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/3 "2020-05-08T07:45:13Z")
Thanks for the reply Manan. Considering Point Number 3, we are looking is to create url like [https://wa.me/919876543210](https://wa.me/919876543210) and integrate it button. When user enter their phone number, whatsapp link should be generated automatically ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 8, 2020, 8:03am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/4 "2020-05-08T08:03:14Z")
This should be doable using a concat function in Google Sheets or by using the Template feature in Glide. ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 3:37am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/5 "2020-05-09T03:37:04Z")
Thanks Amit. It worked. Is there a way to create current date column? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 9, 2020, 4:13am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/6 "2020-05-09T04:13:03Z")
Hi Adviuz, If you are setting up your app to let people input their number in a form, then catch the current date in that form as well using this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3ff07a4cb837cba4631d5acbcfc5753f0d4691ff.png) ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 4:35am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/7 "2020-05-09T04:35:42Z")
Let me explain the process 1. User visit our website and fill the enquiry form 2. His details captured in google sheet 3. There is a column lead create data in google sheet for lead created date is not captured from enquiry form so we are not able to see lead create date. Goal is to create lead data from fresh leads 1. When Sales rep using glide app is creating a lead, then we can use above option to send lead create data in sheet. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 9, 2020, 6:48pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/8 "2020-05-09T18:48:56Z")
Are you using the Current Date Special Value from @ThinhDinh’s screenshot? You can write the current date to the lead date column in your sheet. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 9, 2020, 10:35pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/9 "2020-05-09T22:35:40Z")
You’ve to create the date timestamp in Zapier. {{zap\_meta\_human\_now}} ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 10:49pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/10 "2020-05-09T22:49:34Z")
Thx problem solved ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 11:00pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/11 "2020-05-09T23:00:16Z")
We use template features with [wa.me/](http://wa.me/) as fixed and then place phone number. Now problem we are facing is some client are submitting phone as 91 9876541230, some submiting as 987456320 ( without 91), we need to create a column to have clean 10 digit numer and then we use [wa.me/91(Phone)](http://wa.me/91(Phone)). Please advice how to do it. Goal is to have 10 digit number with no space in between. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 9, 2020, 11:01pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/12 "2020-05-09T23:01:15Z")
Use the Hint/Placeholder to indicate what format you expect the phone number in. Also use Phone Number Entry input field. ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 11:04pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/13 "2020-05-09T23:04:36Z")
Considering Point -1 About notification Our Goal is to remind sales person about the follow-up date and time. Kindly suggest the best way to do it. We tried connecting it with Google Calendar via zapier and it worked but problem is only added is add to add event in calendar not the sale representatives as only admin account is connect as google calendar account in zapier ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 9, 2020, 11:10pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/14 "2020-05-09T23:10:20Z")
Hint is used but when website visitor filled enquiry form they generally see their number and email in suggestion so rather typing most of people select the suggest due to which number doesn’t come in fix format. Example Format 9876543210 09876543210 919876543210 9198765 43210 ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 9, 2020, 11:10pm UTC](https://community.glideapps.com/t/regarding-sales-app/8600/15 "2020-05-09T23:10:53Z")
You can use formatter in Zapier. ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 10, 2020, 12:39am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/16 "2020-05-10T00:39:28Z")
It worked well. Thanks ---
**Author:** ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)\ **Post date:** [May 10, 2020, 12:42am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/17 "2020-05-10T00:42:18Z")
[quote=“Adviuz, post:13, topic:8600, full:true”] Considering Point -1 About notification Our Goal is to remind sales person about the follow-up date and time. Kindly suggest the best way to do it. ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [May 20, 2020, 7:17am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/18 "2020-05-20T07:17:40Z")
Try with Twilio / SMS ---
**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 20, 2020, 9:39am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/19 "2020-05-20T09:39:52Z")
In the concat option, you could add a formula where you add number. Formula could be =right(,10) This will ensure only last 10 digits are taken in consideration ---
**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 20, 2020, 9:49am UTC](https://community.glideapps.com/t/regarding-sales-app/8600/20 "2020-05-20T09:49:36Z")
For doing this, I have created a column which defines when exactly do I want to send a reminder. This column automatically becomes “Send” in the hour when the reminder is to be sent. In my case I have to send a reminder 24 hours before the deadline. The formula I s=use to generate that is in the picture. Then I use google apps script to send a notification when the column has “Send” in it and I have used an hourly trigger so that only 1 notification is sent in that specific hour. As the hour changes, the “Send” will change to “No” and the script wouldnt return any value. To send notifications you could use mail, text message or whatsapp along with the scripts. Sorry for the late response. ![Reminder](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b4b3541a7b2df9689ce2543a10c4438fd2162147.png)