# Latest **URL:** https://community.glideapps.com/latest.md?page=165 [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) **Page:** 166 --- ## [Pivot Tables](https://community.glideapps.com/t/pivot-tables/78069)
**Author:** [@CDP\_Beer](https://community.glideapps.com/u/CDP_Beer)\ **Replies:** 6\ **Last updated:** [November 21, 2024, 8:18pm UTC](https://community.glideapps.com/t/pivot-tables/78069 "2024-11-21T20:18:56Z")
Can Glide support pivot tables and that functionality in their GlideTables feature, or if I need pivot tables in my spreadsheets would I need to connect my GoogleSpreadsheet to GlideTables and have it be constantly updat… --- ## [Sheduled workflows](https://community.glideapps.com/t/sheduled-workflows/78051)
**Author:** [@SkedsmoRedCross](https://community.glideapps.com/u/SkedsmoRedCross)\ **Replies:** 4\ **Last updated:** [November 21, 2024, 2:38pm UTC](https://community.glideapps.com/t/sheduled-workflows/78051 "2024-11-21T14:38:24Z")
I was excited to see scheduled workflows beeing integrated in Glide, but was quickly disapointed to see it was only for buisness Im a voulenteer for RedCross, and since we are a non-profit organisation, we can’t afford … --- ## [Big Query Set Automatic Refresh Every X Hours/Days](https://community.glideapps.com/t/big-query-set-automatic-refresh-every-x-hours-days/78101)
**Author:** [@Drew1](https://community.glideapps.com/u/Drew1)\ **Replies:** 0\ **Last updated:** [November 21, 2024, 1:51pm UTC](https://community.glideapps.com/t/big-query-set-automatic-refresh-every-x-hours-days/78101 "2024-11-21T13:51:58Z")
Hi, I would like to set up an automatic refresh of a BigQuery every 1, 12, 24, or 48 hours (complete customization is preferred but these are great starting places). We are using a BigQuery Table as a secondary “users”… --- ## [Convert all letters of one to uppercase](https://community.glideapps.com/t/convert-all-letters-of-one-to-uppercase/78100)
**Author:** [@Higor](https://community.glideapps.com/u/Higor)\ **Replies:** 1\ **Last updated:** [November 21, 2024, 1:12pm UTC](https://community.glideapps.com/t/convert-all-letters-of-one-to-uppercase/78100 "2024-11-21T13:12:46Z")
Convert all letters of one to uppercase For example, in the sentence: “Hello everything is fine?” I’m looking for a culona that leaves it like this: “HELLO EVERYTHING IS FINE?” --- ## [Regarding Glide caching with a javascript column](https://community.glideapps.com/t/regarding-glide-caching-with-a-javascript-column/78099)
**Author:** [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Replies:** 4\ **Last updated:** [November 21, 2024, 12:06pm UTC](https://community.glideapps.com/t/regarding-glide-caching-with-a-javascript-column/78099 "2024-11-21T12:06:11Z")
I’ve posted before about caching issues with json objects in columns/querying json in columns and therefore I use these functions in the actual actions(workflows?), I know Glide is aware of this issue. My question is if… --- ## [Migration from Legacy Free Plan to New Glide Features](https://community.glideapps.com/t/migration-from-legacy-free-plan-to-new-glide-features/78057)
**Author:** [@d\_Karl](https://community.glideapps.com/u/d_Karl)\ **Replies:** 2\ **Last updated:** [November 21, 2024, 8:53am UTC](https://community.glideapps.com/t/migration-from-legacy-free-plan-to-new-glide-features/78057 "2024-11-21T08:53:18Z")
Hello, I’ve been using Glide for quite some time with the free version for my association. I’m currently on the Legacy Free Plan. I remember that a while back, when the pricing was updated, Google Sheets sync was no lo… --- ## [Are You Sure? Action](https://community.glideapps.com/t/are-you-sure-action/69057)
**Author:** [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Replies:** 36\ **Last updated:** [November 21, 2024, 3:26am UTC](https://community.glideapps.com/t/are-you-sure-action/69057 "2024-11-21T03:26:33Z")
Is it possible to have when a Delete Button is clicked, a notice “Are You Sure” pops up? Thanks. --- ## [How would you approach building a GitHub contribution chart?](https://community.glideapps.com/t/how-would-you-approach-building-a-github-contribution-chart/78074)
**Author:** [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)\ **Replies:** 2\ **Last updated:** [November 21, 2024, 1:15am UTC](https://community.glideapps.com/t/how-would-you-approach-building-a-github-contribution-chart/78074 "2024-11-21T01:15:39Z")
I have been trying to figure out how one would approach build a contribution chart/heatmap in Glide. You could probably use Glide AI for the visual part but when it comes to how best structure a database around this … --- ## [Multiple businesses in one APP](https://community.glideapps.com/t/multiple-businesses-in-one-app/78075)
**Author:** [@Laurence\_Schuberth](https://community.glideapps.com/u/Laurence_Schuberth)\ **Replies:** 4\ **Last updated:** [November 21, 2024, 1:01am UTC](https://community.glideapps.com/t/multiple-businesses-in-one-app/78075 "2024-11-21T01:01:55Z")
Hi Gliders, I have been using Glide Solid for a year, it’s amazing. I am a very low to No code so it’s given me the opportunity to do what I have been never able to build, but I need your “Guru” advice. I’ve built an App… --- ## [Collection alignment - text wrapping problem](https://community.glideapps.com/t/collection-alignment-text-wrapping-problem/77325)
**Author:** [@Alexey\_Khrolovich](https://community.glideapps.com/u/Alexey_Khrolovich)\ **Replies:** 4\ **Last updated:** [November 21, 2024, 12:15am UTC](https://community.glideapps.com/t/collection-alignment-text-wrapping-problem/77325 "2024-11-21T00:15:51Z")
Normally text in “description” parameter of collection are wrapped. But if i choose in collection options alignment to be center it cuts text to 1 string only. Can you fix that? BR --- ## [Relating F1 Position with Points Gone Wrong](https://community.glideapps.com/t/relating-f1-position-with-points-gone-wrong/77979)
**Author:** [@peterkota](https://community.glideapps.com/u/peterkota)\ **Replies:** 7\ **Last updated:** [November 20, 2024, 11:57pm UTC](https://community.glideapps.com/t/relating-f1-position-with-points-gone-wrong/77979 "2024-11-20T23:57:19Z")
Hi all, Im building a little app for my wife who is having an F1 watch party whereby everyone who attends can add their race predictions in from 1st-10th. Each position they get correct they should receive the certain … --- ## [Layout Editor Separator without affecting the view](https://community.glideapps.com/t/layout-editor-separator-without-affecting-the-view/78073)
**Author:** [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Replies:** 0\ **Last updated:** [November 20, 2024, 8:16pm UTC](https://community.glideapps.com/t/layout-editor-separator-without-affecting-the-view/78073 "2024-11-20T20:16:45Z")
You can set separator in your Components Navigator without affecting the view with spaces or gaps. Add an AI component without configuring anything inside it. Rename it to something like “- - - - - - - - - - - - - - - -… --- ## [Custom Collections on mobile screen](https://community.glideapps.com/t/custom-collections-on-mobile-screen/78065)
**Author:** [@abdo](https://community.glideapps.com/u/abdo)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 8:15pm UTC](https://community.glideapps.com/t/custom-collections-on-mobile-screen/78065 "2024-11-20T20:15:37Z")
Custom Collection Issues on mobile device I have 2 exactly same tabs… based on the same relation. one has a cards collection the other has a custom collection layout grid (with only an image / title) both have the s… --- ## [Please guide for setup Dashboard my App](https://community.glideapps.com/t/please-guide-for-setup-dashboard-my-app/78048)
**Author:** [@pmg\_email](https://community.glideapps.com/u/pmg_email)\ **Replies:** 7\ **Last updated:** [November 20, 2024, 6:17pm UTC](https://community.glideapps.com/t/please-guide-for-setup-dashboard-my-app/78048 "2024-11-20T18:17:56Z")
Please Guide for Setup Dashboard my Application I Have Data to number count --- ## [Issue with Dates ans Hours](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059)
**Author:** [@Paulo\_Novas](https://community.glideapps.com/u/Paulo_Novas)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 4:35pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059 "2024-11-20T16:35:14Z")
Hi! need help, trying set periods of the day in a table like from 8:00 to 12:00 - 12:00 16:00 … Trying to use IF Then, but in the before or afther there is no custom so i can get an hour but not the ones before sorry w… --- ## [Looking for a solution to keep the screen on while using the app](https://community.glideapps.com/t/looking-for-a-solution-to-keep-the-screen-on-while-using-the-app/68436)
**Author:** [@ohad](https://community.glideapps.com/u/ohad)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 4:06pm UTC](https://community.glideapps.com/t/looking-for-a-solution-to-keep-the-screen-on-while-using-the-app/68436 "2024-11-20T16:06:02Z")
Hi, I would like to prevent the screen from sleep while using the app. My users are using a lot with the stopwatch (classic app), The stopwatch runs for few minutes, the problem is that the screen is going black after 1… --- ## [Send email action not working](https://community.glideapps.com/t/send-email-action-not-working/78063)
**Author:** [@Fabio\_Fulci](https://community.glideapps.com/u/Fabio_Fulci)\ **Replies:** 8\ **Last updated:** [November 20, 2024, 3:22pm UTC](https://community.glideapps.com/t/send-email-action-not-working/78063 "2024-11-20T15:22:37Z")
Team ID: In the Glide dashoard URL, e.g. \`https://go.glideapps.com/o/0t33PI3jahuseuNSUi7a App ID: In the Glide builder URL, e.g. \`https://go.glideapps.com/app/oXPPa4g8e8Vg4Vsh2hBa/layout Description Send email … --- ## [Regarding the new tables with workflow beta](https://community.glideapps.com/t/regarding-the-new-tables-with-workflow-beta/78064)
**Author:** [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Replies:** 1\ **Last updated:** [November 20, 2024, 2:46pm UTC](https://community.glideapps.com/t/regarding-the-new-tables-with-workflow-beta/78064 "2024-11-20T14:46:30Z")
Are these tables going to be relevant in the future as well, aka will they always be needed with the workflows or are they a temporary feature for us to assess the flows? Also if anyone has further links to workflo… --- ## [Field Component Display Issue on Mobile: Values Stacking Vertically](https://community.glideapps.com/t/field-component-display-issue-on-mobile-values-stacking-vertically/78020)
**Author:** [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 1:36pm UTC](https://community.glideapps.com/t/field-component-display-issue-on-mobile-values-stacking-vertically/78020 "2024-11-20T13:36:59Z")
Hi everyone, I’m encountering a display issue when using the Fields component on mobile. The rows of data are quite long, and when viewed on a phone, the values on the left appear stacked vertically, with each character… --- ## [Extract Last four digits from a phone no](https://community.glideapps.com/t/extract-last-four-digits-from-a-phone-no/78030)
**Author:** [@Ben164](https://community.glideapps.com/u/Ben164)\ **Replies:** 13\ **Last updated:** [November 20, 2024, 11:20am UTC](https://community.glideapps.com/t/extract-last-four-digits-from-a-phone-no/78030 "2024-11-20T11:20:28Z")
Good evening, Hope you are well. I am looking for some help removing the ‘0.’ from the screenshot please. So it leaves me with just a plain 4 digit number each time. I have tried splitting the text but cannot get it to… --- ## [Displays unique data in another table, from which data is used for calculations](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027)
**Author:** [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 11:05am UTC](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027 "2024-11-20T11:05:02Z")
is there a way to calculate unique dates? I have data entry like this in another sheet I have data that takes the unique date of the data entry, in the spreadsheet I can do it easily, but what about GT? --- ## [Custom Component Disappearing / Not Displaying](https://community.glideapps.com/t/custom-component-disappearing-not-displaying/78021)
**Author:** [@Atom](https://community.glideapps.com/u/Atom)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 11:01am UTC](https://community.glideapps.com/t/custom-component-disappearing-not-displaying/78021 "2024-11-20T11:01:54Z")
First time reporting a bug? Refer to our Start Here post. Team ID: In the Glide dashoard URL, e.g. y60l3n8HkXyhX6yCO7cd App ID: In the Glide builder URL, e.g. qeioGIVnY6YqMqvqWwrQ/layout Description The Custo… --- ## [Query with random sort?](https://community.glideapps.com/t/query-with-random-sort/78032)
**Author:** [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Replies:** 13\ **Last updated:** [November 20, 2024, 5:01am UTC](https://community.glideapps.com/t/query-with-random-sort/78032 "2024-11-20T05:01:06Z")
I’m not sure if I’m missing something but can anyone confirm whether you can run a query and select the sort type as random? I’m not seeing this option. --- ## [Clients data privacy when building apps](https://community.glideapps.com/t/clients-data-privacy-when-building-apps/78045)
**Author:** [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 4:39am UTC](https://community.glideapps.com/t/clients-data-privacy-when-building-apps/78045 "2024-11-20T04:39:46Z")
As a freelancer or agency, how do you manage privacy when building apps for clients? For example: One of my client wants me to link his app to his Quickbooks invoicing. I want to connect it using make.com but I will ne… --- ## [Add Random sort to Query column](https://community.glideapps.com/t/add-random-sort-to-query-column/78047)
**Author:** [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Replies:** 0\ **Last updated:** [November 20, 2024, 4:16am UTC](https://community.glideapps.com/t/add-random-sort-to-query-column/78047 "2024-11-20T04:16:56Z")
Please add the option to sort randomly to the Query column. These are the options provided for collections: Yet in the Query column it is like this: If we want Random sorting, this forces us to first select a so… --- ## [Text justification left AND right in fields component - why?](https://community.glideapps.com/t/text-justification-left-and-right-in-fields-component-why/78036)
**Author:** [@Jessie](https://community.glideapps.com/u/Jessie)\ **Replies:** 1\ **Last updated:** [November 19, 2024, 11:39pm UTC](https://community.glideapps.com/t/text-justification-left-and-right-in-fields-component-why/78036 "2024-11-19T23:39:23Z")
In regards to the basic table, or fields component, it was stated that “everything on the right side is always right aligned” in this post. What is the reasoning for this? I don’t think I’ve ever had a design problem wh… --- ## [One app or multiple apps](https://community.glideapps.com/t/one-app-or-multiple-apps/78043)
**Author:** [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Replies:** 9\ **Last updated:** [November 20, 2024, 3:58am UTC](https://community.glideapps.com/t/one-app-or-multiple-apps/78043 "2024-11-20T03:58:56Z")
I’m currently rebuilding the app that I’ve been using for my personal business for almost two years because it was the first app I created and figured it would be better to rebuild it completely rather than fix the origi… --- ## [Why am i getting this when i try to build an app based on my google sheets](https://community.glideapps.com/t/why-am-i-getting-this-when-i-try-to-build-an-app-based-on-my-google-sheets/78038)
**Author:** [@Macy\_Sterry](https://community.glideapps.com/u/Macy_Sterry)\ **Replies:** 3\ **Last updated:** [November 20, 2024, 3:44am UTC](https://community.glideapps.com/t/why-am-i-getting-this-when-i-try-to-build-an-app-based-on-my-google-sheets/78038 "2024-11-20T03:44:04Z")
why am i getting this when i try to build an app based on my google sheets or connect an existing app to my google sheets? I am logged in with the same email under my google account and glide account. --- ## [Unlimited personal users in business apps](https://community.glideapps.com/t/unlimited-personal-users-in-business-apps/78041)
**Author:** [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 3:16am UTC](https://community.glideapps.com/t/unlimited-personal-users-in-business-apps/78041 "2024-11-20T03:16:29Z")
I’m thinking of switching my legacy business plan for the new business plan to get access to scheduled workflows. As I’m looking at Glide’s pricing page I can see the business plan “Includes everything in Maker”. Does … --- ## [Constant Role Assignment That Works Like a Glide Template Column!](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028)
**Author:** [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Replies:** 4\ **Last updated:** [November 20, 2024, 2:59am UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028 "2024-11-20T02:59:34Z")
Hey Glide enthusiasts! I’ve found a super useful ArrayFormula in Google Sheet that mimics a template column but with a twist. It is stored in a basic column, so it works perfectly with Row Owners! Here is the magic form… [Previous page](https://community.glideapps.com/latest.md?page=164) [Next page](https://community.glideapps.com/latest.md?page=166)