# Ask for Help **URL:** https://community.glideapps.com/c/help-how-to/27.md?page=124 [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) **Page:** 125 --- ## [Validate complete and incomplete addresses](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058)
**Author:** [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Replies:** 7\ **Last updated:** [November 22, 2024, 12:22am UTC](https://community.glideapps.com/t/validate-complete-and-incomplete-addresses/78058 "2024-11-22T00:22:48Z")
I need help validating addresses to ensure they are complete. Here’s the concept: A warehouse admin will input the shipping address provided by customer service. If the address is intended for an office location, the… --- ## [Browser caching vs Glide caching](https://community.glideapps.com/t/browser-caching-vs-glide-caching/78113)
**Author:** [@burningmikey](https://community.glideapps.com/u/burningmikey)\ **Replies:** 5\ **Last updated:** [November 21, 2024, 9:30pm UTC](https://community.glideapps.com/t/browser-caching-vs-glide-caching/78113 "2024-11-21T21:30:32Z")
Hi all, I’m pulling some json files via fetch in a javascript column. It seems that the files cache control is implemented outside of the browser for Chrome, but by the browser in Safari. So I’m assuming Glide cache th… --- ## [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 … --- ## [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… --- ## [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 … --- ## [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… --- ## [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? --- ## [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… --- ## [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 … --- ## [URGENT GMail Send Email Action Not Working](https://community.glideapps.com/t/urgent-gmail-send-email-action-not-working/78035)
**Author:** [@Kiwi](https://community.glideapps.com/u/Kiwi)\ **Replies:** 6\ **Last updated:** [November 20, 2024, 2:53am UTC](https://community.glideapps.com/t/urgent-gmail-send-email-action-not-working/78035 "2024-11-20T02:53:08Z")
I have a send email action that I have not changed at all. It was working 2 days ago no issues, logged in today and the exact same action is not working it just comes up with an error saying “\[send email\] could not send … --- ## [Pop up when switching from Data to Layout view](https://community.glideapps.com/t/pop-up-when-switching-from-data-to-layout-view/78034)
**Author:** [@J\_Ceja\_Jr](https://community.glideapps.com/u/J_Ceja_Jr)\ **Replies:** 4\ **Last updated:** [November 20, 2024, 1:10am UTC](https://community.glideapps.com/t/pop-up-when-switching-from-data-to-layout-view/78034 "2024-11-20T01:10:08Z")
I am using safari browser and every time I switch between the data screen to go to the layout screen, a pop up appears that says paste. It’s very annoying when working with Glide and does it even if I use keyboard shortc… --- ## [How to get records from database via API by filtering?](https://community.glideapps.com/t/how-to-get-records-from-database-via-api-by-filtering/78022)
**Author:** [@Jayeshkumar\_Bhatia](https://community.glideapps.com/u/Jayeshkumar_Bhatia)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 12:43am UTC](https://community.glideapps.com/t/how-to-get-records-from-database-via-api-by-filtering/78022 "2024-11-20T00:43:04Z")
Hi, I want to search for records in a table by fitlering. For Eq - columnValue eq “somevalue”. Is this possible via API? I --- ## [I need hands on tutorial videos](https://community.glideapps.com/t/i-need-hands-on-tutorial-videos/78031)
**Author:** [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Replies:** 5\ **Last updated:** [November 19, 2024, 10:32pm UTC](https://community.glideapps.com/t/i-need-hands-on-tutorial-videos/78031 "2024-11-19T22:32:18Z")
I am learning GLIDE and I have noticed that I learn the best when I can follow a tutorial video and build the app with them, from scratch. Can you recommend any such video? My level is somewhere between a beginner and … --- ## [Create a List of all Entries with the Same Name (e.g. non Unique matches)](https://community.glideapps.com/t/create-a-list-of-all-entries-with-the-same-name-e-g-non-unique-matches/78029)
**Author:** [@MattLB](https://community.glideapps.com/u/MattLB)\ **Replies:** 1\ **Last updated:** [November 19, 2024, 8:48pm UTC](https://community.glideapps.com/t/create-a-list-of-all-entries-with-the-same-name-e-g-non-unique-matches/78029 "2024-11-19T20:48:29Z")
I have a Query result that has a rollup count of 1993 count and unique count of 1823. That means there are 170 non-unique entries. Is their a way to create a list of these “non unique” entries? TIA Matt --- ## [Support hasn't responded to my last 3 requests - what's up?](https://community.glideapps.com/t/support-hasnt-responded-to-my-last-3-requests-whats-up/78001)
**Author:** [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Replies:** 10\ **Last updated:** [November 19, 2024, 4:52pm UTC](https://community.glideapps.com/t/support-hasnt-responded-to-my-last-3-requests-whats-up/78001 "2024-11-19T16:52:03Z")
This is what my support feed looks like… I haven’t gotten a single reply on anything I’ve asked about since this one on Oct. 24. :disappointed\_relieved: --- ## [Reference a field in a JSON Query](https://community.glideapps.com/t/reference-a-field-in-a-json-query/77892)
**Author:** [@Craig\_Laird\_Jamieson](https://community.glideapps.com/u/Craig_Laird_Jamieson)\ **Replies:** 5\ **Last updated:** [November 19, 2024, 3:46pm UTC](https://community.glideapps.com/t/reference-a-field-in-a-json-query/77892 "2024-11-19T15:46:22Z")
Hi Looking for some advice, I am trying to filter JSON query with a field from the table, but are unable to get it to work. Where table-field-name is the name of the field in the Glide Table. Would appreciate any assi… [Previous page](https://community.glideapps.com/c/help-how-to/27.md?page=123) [Next page](https://community.glideapps.com/c/help-how-to/27.md?page=125)