# Glitch: Limit access by email not available Pro app **URL:** \ **Category:** Ask for Help\ **Created:** [April 24, 2021, 11:24pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995 "2021-04-24T23:24:13Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 24, 2021, 11:24pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/1 "2021-04-24T23:24:13Z")
My app is published and I want to limit access by email. But it does not show me any option for private apps. The only options I see are public and public with email . ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 24, 2021, 11:28pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/2 "2021-04-24T23:28:37Z")
Private app is inherently limitedby email. You just need to specify which sheet had the email whitelist. ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 6:23am UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/3 "2021-04-30T06:23:08Z")
Hi Robert, Can you please help me with :- 1. How to make a whitelist so that it whitelists by either phone number or Organisation name (a certain passcode I can share with organisations to be put) 2. What’s the way to connect live tweets around certain hashtags to show up and if they have a phone number that could be call-able? 3. Create a tweet with data from the tab with a line break? 4. How can two pro gildeapps be integrated to show relevant and specific data from each other? For example, in one app I am getting requests and the other one is for resources. I want the specific and relevant category of resources to show in the request app. 5. Share current entry on social media/whatsapp? 6. Trigger message to WhatsApp (not by creating a separate button) with the message button ? This is for India Covid-19. Immediate help would be appreciated. ---
**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:** [April 30, 2021, 7:56am UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/4 "2021-04-30T07:56:48Z")
> [@Chirag\_Mediratta](#): > > How to make a whitelist so that it whitelists by either phone number or Organisation name (a certain passcode I can share with organisations to be put) At the moment I believe we can only whitelist by email, but you can use tab visibility conditions tied to user profiles fields (in this case, phone number and organization code) to show/hide the tabs accordingly. > [@Chirag\_Mediratta](#): > > What’s the way to connect live tweets around certain hashtags to show up and if they have a phone number that could be call-able? This is pretty complex, not sure if you can do a webview of a Twitter page (let’s say a search of certain keywords) or not, I think that’s your best bet. > [@Chirag\_Mediratta](#): > > Create a tweet with data from the tab with a line break? So do you want to create a Tweet from right inside Glide? I believe some Twitter intent format can handle this. > [@Chirag\_Mediratta](#): > > How can two pro gildeapps be integrated to show relevant and specific data from each other? For example, in one app I am getting requests and the other one is for resources. I want the specific and relevant category of resources to show in the request app. Without knowing more about the use case, I think you can just point them to the same underlying Google Sheet/Glide Table, then display them accordingly for each app. > [@Chirag\_Mediratta](#): > > Share current entry on social media/whatsapp? What do you mean by current entry? What types of social media do you want to share them to? > [@Chirag\_Mediratta](#): > > Trigger message to WhatsApp (not by creating a separate button) with the message button ? Like the Twitter part above, I think this can be handled by creating a template column with the right intent format. ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 8:27am UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/5 "2021-04-30T08:27:03Z")
1. Whitelist by email - can you give me an example? 2. Live tweets - (I want to connect specific hashtags/categories) - automate it so that the phone number and specific # are added to my specific columns 3. Create Tweet - I want people to share the entry on a tweet… So probably will use text join and a hyperlink to create new tweet. Open to better solutions! 4.Can show you if you are available for a zoom call? 1. Social media - want people to be able to share a specific entry. For example, if they are looking for oxygen cylinders in a particular city, I want them to be able to share that information as text. (I know the hack is again to use a text join column but looking for something more native other than link to screen/ show sharing options) 2. Have created a template but was wondering if it was possible for phone numbers with the glide native message button ---
**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:** [April 30, 2021, 9:13am UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/6 "2021-04-30T09:13:09Z")
> [@Chirag\_Mediratta](#): > > Whitelist by email - can you give me an example? That option is only for a Private Pro app, you can try some free templates available in your dashboard but it’s only for 14 days. > [@Chirag\_Mediratta](#): > > Live tweets - (I want to connect specific hashtags/categories) - automate it so that > the phone number and specific # are added to my specific columns At the moment I think your best bet here for extracting info from Twitter is use a third-party crawler to update the Sheet. Possibly something like this: > **[Twitter API & Google Sheets API Integration Tutorial \[Step-by-Step\] -...](https://apipheny.io/twitter-api-google-sheets/)** > > How to integrate Twitter with Google Sheets and pull data from Twitter into Google Sheets using the Twitter API and Apipheny. Regarding the sharings, I don’t think there’s any other options other than using a show sharing options action/using a template column to create an intent link, then use open link action. You can try browsing the WhatsApp threads in this forum for more info. Sorry I’m not available for a call. ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 9:21am UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/7 "2021-04-30T09:21:20Z")
Hi Thinh, I appreciate you taking time to help me. 1. Where can I share the app links with you? (not here because it’s still WIP) 2. Whitelist - for a pro app - can I work it around with visibility conditions. For example, I can share a password that people have to add as organisation and limit features by that? 3. I also want to add data with the time difference since it was last verified and now. For example, instead of data showing the time stamp, I want it so **X hours Y mins ago** Is there a work around for this? ---
**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:** [April 30, 2021, 12:30pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/8 "2021-04-30T12:30:00Z")
For the whitelist part, you workaround by showing/hiding tabs based on visibility conditions. For the time difference, you can configure something like this. Days ago: Floor(Now - Timestamp) Hours ago: Floor((Now - Timestamp - Days ago)\*24) Mins ago: Floor((Now - Timestamp - Days ago - Hours ago/24)_24_60) Then replace them in a template column accordingly. ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 1:39pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/9 "2021-04-30T13:39:34Z")
Hi Thinh, I have solved that date time problem but I’m trying to figure out how to use an array formula or auto add current time [=now()] to the new rows that are added? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [April 30, 2021, 1:45pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/10 "2021-04-30T13:45:53Z")
Hola @Chirag_Mediratta, You can create math column and type the word “Now” then choose the option of the current date and time. This will autopopulate for all rows. ![Screen Shot 2021-04-30 at 8.43.15 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8bb899fc2c98233a3300f9bf75dd0deb8d6af0d.png) I hope this helps. ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 1:46pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/11 "2021-04-30T13:46:50Z")
Thank you! “now” automatically started showing up without creating a column. which is weird but works! ---
**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\ **Post date:** [April 30, 2021, 2:06pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/12 "2021-04-30T14:06:35Z")
I’m almost done for the day with all the above doubts. Though **one last thing** that has been making my sheets throw off is **how do I ensure that my textjoin/concatenate work for the new rows**?? Urgent help needed! Thank you all you helpful people 🙂 ---
**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:** [April 30, 2021, 2:11pm UTC](https://community.glideapps.com/t/glitch-limit-access-by-email-not-available-pro-app/25995/13 "2021-04-30T14:11:44Z")
Arrayformulas > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … Or if you want to keep it in the app and not the sheet, then use a Template column to join multiple columns together.