# Latest **URL:** https://community.glideapps.com/latest.md?page=1126 [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) **Page:** 1127 --- ## [Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432)
**Author:** [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Replies:** 20\ **Last updated:** [June 21, 2020, 11:52pm UTC](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432 "2020-06-21T23:52:25Z")
This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded “The most powerful function in Google Sheets” … --- ## [Date & time column value from a relation](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818)
**Author:** [@mthakershi](https://community.glideapps.com/u/mthakershi)\ **Replies:** 2\ **Last updated:** [June 21, 2020, 7:12pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818 "2020-06-21T19:12:26Z")
Even though I’ve set date format in the editor to human readable format, this shows techy value. When I got into the screen, it does show a proper date value. --- ## [Form Submit Not Triggering Google Scripts](https://community.glideapps.com/t/form-submit-not-triggering-google-scripts/11192)
**Author:** [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Replies:** 14\ **Last updated:** [June 21, 2020, 5:00pm UTC](https://community.glideapps.com/t/form-submit-not-triggering-google-scripts/11192 "2020-06-21T17:00:33Z")
I am trying to get google sheets to trigger a onEdit script when a form is submitted by identifying when a column changes. I can type in the column and it triggers the script but when I have a form submit data to the co… --- ## [How do link to the chat box?](https://community.glideapps.com/t/how-do-link-to-the-chat-box/11206)
**Author:** [@erwblo](https://community.glideapps.com/u/erwblo)\ **Replies:** 1\ **Last updated:** [June 21, 2020, 4:21pm UTC](https://community.glideapps.com/t/how-do-link-to-the-chat-box/11206 "2020-06-21T16:21:23Z")
I don’t want reactions under every post, but want to direct people to the chat-section. How do I do that? Don’t see the option with a button? --- ## [Wiz's Restaurant PRO -Read on](https://community.glideapps.com/t/wizs-restaurant-pro-read-on/10016)
**Author:** [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Replies:** 25\ **Last updated:** [June 21, 2020, 3:09pm UTC](https://community.glideapps.com/t/wizs-restaurant-pro-read-on/10016 "2020-06-21T15:09:05Z")
Gliders, here is a preview of Wiz’s Restaurant PRO -(the standard version is in the template store! If you have any helpful suggestions, please feel at home. (1) - First test as customer- (select menu items - go to car… --- ## [How do I personalize ratings?](https://community.glideapps.com/t/how-do-i-personalize-ratings/11196)
**Author:** [@Jer00n](https://community.glideapps.com/u/Jer00n)\ **Replies:** 11\ **Last updated:** [June 21, 2020, 9:42am UTC](https://community.glideapps.com/t/how-do-i-personalize-ratings/11196 "2020-06-21T09:42:05Z")
I would like to use the rating component to let users personally rate items in my app. When someone selects a number of stars, the component should pass the value to the sheet. This requires User Specific columns, so e… --- ## [Hello my glide is in trouble i can't update the app colors](https://community.glideapps.com/t/hello-my-glide-is-in-trouble-i-cant-update-the-app-colors/11193)
**Author:** [@silvana\_tupi](https://community.glideapps.com/u/silvana_tupi)\ **Replies:** 5\ **Last updated:** [June 21, 2020, 6:42am UTC](https://community.glideapps.com/t/hello-my-glide-is-in-trouble-i-cant-update-the-app-colors/11193 "2020-06-21T06:42:50Z")
hello my glide is in trouble i can’t update the app colors --- ## [Suggestion for creating a post app](https://community.glideapps.com/t/suggestion-for-creating-a-post-app/11191)
**Author:** [@Biboy](https://community.glideapps.com/u/Biboy)\ **Replies:** 0\ **Last updated:** [June 21, 2020, 3:48am UTC](https://community.glideapps.com/t/suggestion-for-creating-a-post-app/11191 "2020-06-21T03:48:15Z")
I am creating an app where users / admin can create a post directly from the app similar with a CMS / blog site. I need suggestions what is the best approach for my scenario. Admins needs to post articles/products - in… --- ## [Create an Add to Home Button](https://community.glideapps.com/t/create-an-add-to-home-button/11179)
**Author:** [@Brian\_Rosenstein](https://community.glideapps.com/u/Brian_Rosenstein)\ **Replies:** 4\ **Last updated:** [June 21, 2020, 2:32am UTC](https://community.glideapps.com/t/create-an-add-to-home-button/11179 "2020-06-21T02:32:25Z")
So I know it pops up by itself, but I also know there are some problems with it depending on the situation. Is there a way to create an add to home screen, or add app button on my menu like a tab? What I would like is … --- ## [Secure Data/BAA](https://community.glideapps.com/t/secure-data-baa/9168)
**Author:** [@Mark\_Shervey](https://community.glideapps.com/u/Mark_Shervey)\ **Replies:** 2\ **Last updated:** [June 20, 2020, 11:07pm UTC](https://community.glideapps.com/t/secure-data-baa/9168 "2020-06-20T23:07:47Z")
Would Glide be open to working with healthcare providers/research on implementing a BAA? example: https://help.surveymonkey.com/articles/en\_US/kb/HIPAA This platform would be such a slam dunk for mobile/digital research… --- ## [Limit number of users](https://community.glideapps.com/t/limit-number-of-users/11152)
**Author:** [@BVanGalder](https://community.glideapps.com/u/BVanGalder)\ **Replies:** 2\ **Last updated:** [June 20, 2020, 10:58pm UTC](https://community.glideapps.com/t/limit-number-of-users/11152 "2020-06-20T22:58:13Z")
Is there anyway to limit the number of users profiles that can be setup in my app? I want to offer a free version that only allows X amount and then offer a paid version with a higher limit/unlimited amount. --- ## [Client can only pay with a purchase order](https://community.glideapps.com/t/client-can-only-pay-with-a-purchase-order/11182)
**Author:** [@Scott\_Hawkins](https://community.glideapps.com/u/Scott_Hawkins)\ **Replies:** 0\ **Last updated:** [June 20, 2020, 9:16pm UTC](https://community.glideapps.com/t/client-can-only-pay-with-a-purchase-order/11182 "2020-06-20T21:16:57Z")
So, I’ve built an app for the county government that I work for and I’m not interested in them paying me for the app I made to help everyone else out. We do want the pro version but the county government can only pay wi… --- ## [Userstatus](https://community.glideapps.com/t/userstatus/11177)
**Author:** [@Glider](https://community.glideapps.com/u/Glider)\ **Replies:** 1\ **Last updated:** [June 20, 2020, 6:13pm UTC](https://community.glideapps.com/t/userstatus/11177 "2020-06-20T18:13:03Z")
It will be great for glide to show users using the app at a time Like when users are online in whatsap Bpt i think @Wiz.Wazeer did something like that Care to share your ideas @Wiz.Wazeer --- ## [Discover air quality in your city with... 🌬 qualitAir!](https://community.glideapps.com/t/discover-air-quality-in-your-city-with-qualitair/10925)
**Author:** [@Vicio\_Sciascia](https://community.glideapps.com/u/Vicio_Sciascia)\ **Replies:** 16\ **Last updated:** [June 20, 2020, 5:43pm UTC](https://community.glideapps.com/t/discover-air-quality-in-your-city-with-qualitair/10925 "2020-06-20T17:43:56Z")
Hi there, I’m excited to show you my new app qualitAir! :rocket: https://r2g6x.glideapp.io/ Helps you checking the air quality in your city :warning: Right now I’m trying to upgrade my buggy Apps Script watcher or r… --- ## [Visibility issue with tabs](https://community.glideapps.com/t/visibility-issue-with-tabs/11147)
**Author:** [@eltintero](https://community.glideapps.com/u/eltintero)\ **Replies:** 3\ **Last updated:** [June 20, 2020, 5:29pm UTC](https://community.glideapps.com/t/visibility-issue-with-tabs/11147 "2020-06-20T17:29:52Z")
I found this little bug. When I choose a tab from the sandwich menu, and then I navigate to another tab I haven’t clicked back yet, when I go to the original tab I started, it still shows the sandwich menu tab. Since I… --- ## [Chat messages are deleted in a certain time](https://community.glideapps.com/t/chat-messages-are-deleted-in-a-certain-time/11162)
**Author:** [@UNIVICTOR](https://community.glideapps.com/u/UNIVICTOR)\ **Replies:** 7\ **Last updated:** [June 20, 2020, 5:07pm UTC](https://community.glideapps.com/t/chat-messages-are-deleted-in-a-certain-time/11162 "2020-06-20T17:07:18Z")
Hello guys, I’m new to Glide but I love it so far. I’ve been working on an app for a few weeks now, experimenting here and there. I was testing the chat and observed that the messages are filling the google spreadsheet. … --- ## [Signing out](https://community.glideapps.com/t/signing-out/11148)
**Author:** [@Glider](https://community.glideapps.com/u/Glider)\ **Replies:** 3\ **Last updated:** [June 20, 2020, 1:23pm UTC](https://community.glideapps.com/t/signing-out/11148 "2020-06-20T13:23:24Z")
Is it possible to manually sign out a user from the --- ## [Complex count if](https://community.glideapps.com/t/complex-count-if/11141)
**Author:** [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Replies:** 7\ **Last updated:** [June 20, 2020, 11:57am UTC](https://community.glideapps.com/t/complex-count-if/11141 "2020-06-20T11:57:32Z")
Hey guys Appreciate any help with a formula. I am looking to get the number of collectibles someone has that match a complete collection. Players are the people playing - where the value should be displayed. Collecti… --- ## [User Profile resets to blank](https://community.glideapps.com/t/user-profile-resets-to-blank/11167)
**Author:** [@JMD](https://community.glideapps.com/u/JMD)\ **Replies:** 8\ **Last updated:** [June 20, 2020, 9:59am UTC](https://community.glideapps.com/t/user-profile-resets-to-blank/11167 "2020-06-20T09:59:27Z")
Hi there My App has ‘Parent Only’ tabs. I created a Users sheet and added 75 email addresses. I then added a column for ‘user specific’ and filled the column with ‘True’. I then made the newsletter component 'visible i… --- ## [Swipe feature please](https://community.glideapps.com/t/swipe-feature-please/144)
**Author:** [@Kevin\_Thibeault](https://community.glideapps.com/u/Kevin_Thibeault)\ **Replies:** 6\ **Last updated:** [June 20, 2020, 8:40am UTC](https://community.glideapps.com/t/swipe-feature-please/144 "2020-06-20T08:40:44Z")
Any chance to get a swipe feature so we can swipe to different tabs, instead of selecting the tabs at the bottom?? --- ## [One random image](https://community.glideapps.com/t/one-random-image/11041)
**Author:** [@Nicola\_Felaco](https://community.glideapps.com/u/Nicola_Felaco)\ **Replies:** 5\ **Last updated:** [June 20, 2020, 6:59am UTC](https://community.glideapps.com/t/one-random-image/11041 "2020-06-20T06:59:10Z")
super noob question, but how can I set up to pick one random image from a column? --- ## [Hello i would like to know how to integrate google calendar directly into glide ... is it possible?](https://community.glideapps.com/t/hello-i-would-like-to-know-how-to-integrate-google-calendar-directly-into-glide-is-it-possible/11161)
**Author:** [@Cristiano\_Cruz](https://community.glideapps.com/u/Cristiano_Cruz)\ **Replies:** 1\ **Last updated:** [June 20, 2020, 5:17am UTC](https://community.glideapps.com/t/hello-i-would-like-to-know-how-to-integrate-google-calendar-directly-into-glide-is-it-possible/11161 "2020-06-20T05:17:02Z")
hello i would like to know how to integrate google calendar directly into glide … is it possible? --- ## [Charts rounding/floating point display problems](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007)
**Author:** [@chrishoward](https://community.glideapps.com/u/chrishoward)\ **Replies:** 6\ **Last updated:** [June 20, 2020, 4:19am UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007 "2020-06-20T04:19:40Z")
Anyone else get problems with pie and donut charts and rounding/floating point displaying wrong in the chart but fine in the legend?? The data source does have round(value,2) applied. And it’s formatted to 2 decimal pla… --- ## [🌈 Reach Out! Talk about anything anonymously with our mental health experts](https://community.glideapps.com/t/reach-out-talk-about-anything-anonymously-with-our-mental-health-experts/11091)
**Author:** [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Replies:** 17\ **Last updated:** [June 20, 2020, 2:20am UTC](https://community.glideapps.com/t/reach-out-talk-about-anything-anonymously-with-our-mental-health-experts/11091 "2020-06-20T02:20:35Z")
Recently in India we witnessed a suicide from a very well known celebrity and it sparked a lot of people coming up with awareness about mental health issues and depression. One of my very dear friends who happens to be … --- ## [Bar chart limit of items](https://community.glideapps.com/t/bar-chart-limit-of-items/11145)
**Author:** [@eltintero](https://community.glideapps.com/u/eltintero)\ **Replies:** 13\ **Last updated:** [June 19, 2020, 11:59pm UTC](https://community.glideapps.com/t/bar-chart-limit-of-items/11145 "2020-06-19T23:59:43Z")
Have any of you found the limit of bars in the bar chart? I’m building an app for a customer that should have a daily bar… I’m worried what will happen in 2 months (60 bars)… @tru @Antonio --- ## [Using the Favourites button and charts to compare options](https://community.glideapps.com/t/using-the-favourites-button-and-charts-to-compare-options/9437)
**Author:** [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Replies:** 11\ **Last updated:** [June 19, 2020, 11:40pm UTC](https://community.glideapps.com/t/using-the-favourites-button-and-charts-to-compare-options/9437 "2020-06-19T23:40:29Z")
Made this app for a used bikes reseller who wanted to list all the options they have on sale along with all details. Also, to create a great UX, a tab where a few shortlisted options could be compared with each other fo… --- ## [Madlib](https://community.glideapps.com/t/madlib/11096)
**Author:** [@Rabbi\_Shlomo\_Slatkin](https://community.glideapps.com/u/Rabbi_Shlomo_Slatkin)\ **Replies:** 4\ **Last updated:** [June 19, 2020, 11:07pm UTC](https://community.glideapps.com/t/madlib/11096 "2020-06-19T23:07:16Z")
I was wondering if it is possible to create a MadLib type of app where users can answer some questions and then the words they used to answer those questions are later placed into a storyline, kind of like a madlib. Can … --- ## [Filter not working on relation/lookup field](https://community.glideapps.com/t/filter-not-working-on-relation-lookup-field/10536)
**Author:** [@jazz78](https://community.glideapps.com/u/jazz78)\ **Replies:** 8\ **Last updated:** [June 19, 2020, 2:33pm UTC](https://community.glideapps.com/t/filter-not-working-on-relation-lookup-field/10536 "2020-06-19T14:33:24Z")
Hi, The in app filter works fine. But when i try to use filter \[ref (2) on the image\] - it only offers me ‘is empty’ or ‘is not empty’. Greatly appreciated if anyone has any ideas here. The ‘Company’ field in my case i… --- ## [Insert image from google drive](https://community.glideapps.com/t/insert-image-from-google-drive/11127)
**Author:** [@Jeanmi](https://community.glideapps.com/u/Jeanmi)\ **Replies:** 15\ **Last updated:** [June 19, 2020, 9:57am UTC](https://community.glideapps.com/t/insert-image-from-google-drive/11127 "2020-06-19T09:57:12Z")
Hi I would like to insert an image from my google drive in a rich text html with this script It works well in my edit app mode on my computer but the same image doesn’t appear on my phone Can you help me plea… --- ## [Ban a user based on email address](https://community.glideapps.com/t/ban-a-user-based-on-email-address/11080)
**Author:** [@Glider](https://community.glideapps.com/u/Glider)\ **Replies:** 8\ **Last updated:** [June 19, 2020, 8:56am UTC](https://community.glideapps.com/t/ban-a-user-based-on-email-address/11080 "2020-06-19T08:56:53Z")
Is it possible to ban a user from the app based on the e-mail address of the user :raised\_back\_of\_hand: [Previous page](https://community.glideapps.com/latest.md?page=1125) [Next page](https://community.glideapps.com/latest.md?page=1127)