# Ask for Help **URL:** https://community.glideapps.com/c/help-how-to/27.md?page=186 [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) **Page:** 187 --- ## [Arrays in json - how to create them](https://community.glideapps.com/t/arrays-in-json-how-to-create-them/73985)
**Author:** [@Krivo](https://community.glideapps.com/u/Krivo)\ **Replies:** 5\ **Last updated:** [June 9, 2024, 10:07am UTC](https://community.glideapps.com/t/arrays-in-json-how-to-create-them/73985 "2024-06-09T10:07:06Z")
I have a table with order items and a table with orders The order items table have the columns order, name and numbers I need to create a json like below. I find it hard to create the array using JSON columns - but ma… --- ## [How would you hand two contexts for the same view?](https://community.glideapps.com/t/how-would-you-hand-two-contexts-for-the-same-view/73978)
**Author:** [@sumgii](https://community.glideapps.com/u/sumgii)\ **Replies:** 4\ **Last updated:** [June 9, 2024, 9:02am UTC](https://community.glideapps.com/t/how-would-you-hand-two-contexts-for-the-same-view/73978 "2024-06-09T09:02:03Z")
Clients and I both use the glideapp we’ve built. They use it to manage their own involvement in our work. I use it to manage multiple clients. There are often views that we both use. One I am working on at the moment is… --- ## [Help refreshing GOOGLEFINANCE data](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432)
**Author:** [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\ **Replies:** 11\ **Last updated:** [June 9, 2024, 7:09am UTC](https://community.glideapps.com/t/help-refreshing-googlefinance-data/43432 "2024-06-09T07:09:09Z")
I have downgraded from PRO to BASIC as I simply did not need all the features of PRO. However, one feature I overlooked was the auto refresh. Now my GOOGLEFINANCE data no longer flows into the app automatically (i.e. GLI… --- ## [Need UI design inspiration](https://community.glideapps.com/t/need-ui-design-inspiration/73340)
**Author:** [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Replies:** 10\ **Last updated:** [June 9, 2024, 6:04am UTC](https://community.glideapps.com/t/need-ui-design-inspiration/73340 "2024-06-09T06:04:43Z")
Hi Gliders, I’m currently rebuilding an app and would need some UI design inspiration. I’d like to see thoughtful use of components and creative designs. If any of you have screenshots of great looking Glide apps, post … --- ## [I want to automatically enter the date when checking the box](https://community.glideapps.com/t/i-want-to-automatically-enter-the-date-when-checking-the-box/73981)
**Author:** [@abdelfatah\_hussien](https://community.glideapps.com/u/abdelfatah_hussien)\ **Replies:** 2\ **Last updated:** [June 9, 2024, 1:22am UTC](https://community.glideapps.com/t/i-want-to-automatically-enter-the-date-when-checking-the-box/73981 "2024-06-09T01:22:07Z")
Please help I want to automatically enter the date when checking the box I have a cash payment page and I pay using the box sign. I have a date column in the same table. I want to enter the date automatically when I cl… --- ## [Filtering chart](https://community.glideapps.com/t/filtering-chart/73961)
**Author:** [@mgalihm](https://community.glideapps.com/u/mgalihm)\ **Replies:** 5\ **Last updated:** [June 9, 2024, 12:19am UTC](https://community.glideapps.com/t/filtering-chart/73961 "2024-06-09T00:19:20Z")
Hi everyone, I created an application for upstream and downstream transactions, then I want to create a dashboard and filter monthly or weekly data and display it with charts. How can I filter that data and show to the … --- ## [SMS OTP Login](https://community.glideapps.com/t/sms-otp-login/61178)
**Author:** [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Replies:** 7\ **Last updated:** [June 8, 2024, 7:11pm UTC](https://community.glideapps.com/t/sms-otp-login/61178 "2024-06-08T19:11:25Z")
Hi, Is there a work around to add sms otp login ? Instead of email ? --- ## [Google Analytics not tracking pages](https://community.glideapps.com/t/google-analytics-not-tracking-pages/73910)
**Author:** [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\ **Replies:** 4\ **Last updated:** [June 8, 2024, 3:03pm UTC](https://community.glideapps.com/t/google-analytics-not-tracking-pages/73910 "2024-06-08T15:03:30Z")
I just switched over to the new Glide apps and I moved my new info over to GA but it’s not tracking data the same way. On the old app I was able to see all the unique pages via the page path and Row ID. Now, I can see … --- ## [Horizontal Scrolling Choice Chips](https://community.glideapps.com/t/horizontal-scrolling-choice-chips/66106)
**Author:** [@Brandon](https://community.glideapps.com/u/Brandon)\ **Replies:** 26\ **Last updated:** [June 8, 2024, 2:57pm UTC](https://community.glideapps.com/t/horizontal-scrolling-choice-chips/66106 "2024-06-08T14:57:34Z")
How do I make Choice Chips scroll horizontally. I wish for them to be in single file line scroll. I can use css with the business plan. --- ## ['Synced' Google Sheet Not Overwriting Data](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980)
**Author:** [@Shayan](https://community.glideapps.com/u/Shayan)\ **Replies:** 3\ **Last updated:** [June 8, 2024, 2:00pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980 "2024-06-08T14:00:31Z")
I’ve just done this: =IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1K6ep9KgCgaXR3lMckIxB\_sl8MSr1\_dEzd3PWyEJqQ\_8/edit?gid=0#gid=0”, “Outreach!A1:L657”) And the L657 is the point I’ve written up to, but the data d… --- ## [Title: How to Make Fields Required in "Show New Screen"](https://community.glideapps.com/t/title-how-to-make-fields-required-in-show-new-screen/73976)
**Author:** [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Replies:** 7\ **Last updated:** [June 8, 2024, 1:42pm UTC](https://community.glideapps.com/t/title-how-to-make-fields-required-in-show-new-screen/73976 "2024-06-08T13:42:48Z")
I have created this interface on Glide. As you can see, the first column contains the date, and the rest of the columns contain the allowed booking times. These columns are buttons that open a new screen of type “Show … --- ## [Google Sheets Skipping Rows](https://community.glideapps.com/t/google-sheets-skipping-rows/73970)
**Author:** [@Shayan](https://community.glideapps.com/u/Shayan)\ **Replies:** 3\ **Last updated:** [June 8, 2024, 1:40pm UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970 "2024-06-08T13:40:46Z")
Original data: Ok I hope the image appears but I realised this was an issue when i tried importing the data onto another sheet, but it didn’t let me override existing data. Then I realised, all rows I had deleted ap… --- ## [Facing multiple issues with the live Glide app, kindly help!](https://community.glideapps.com/t/facing-multiple-issues-with-the-live-glide-app-kindly-help/73920)
**Author:** [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Replies:** 11\ **Last updated:** [June 8, 2024, 1:36pm UTC](https://community.glideapps.com/t/facing-multiple-issues-with-the-live-glide-app-kindly-help/73920 "2024-06-08T13:36:55Z")
Hi team, We are facing some troubles with our live app which are listed below: Users are complaining that they are unable to receive the PIN when trying to login, they’ve also checked the spam folders but unable to f… --- ## [Highest value in a number column](https://community.glideapps.com/t/highest-value-in-a-number-column/73977)
**Author:** [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\ **Replies:** 2\ **Last updated:** [June 8, 2024, 9:12am UTC](https://community.glideapps.com/t/highest-value-in-a-number-column/73977 "2024-06-08T09:12:14Z")
Hi, i have a rollup column storing the sum of the user’s points how can I create another column that tells me the highest number (in this case 120)? It’s kinda urgent --- ## [Open AI in Glide or AI assistant in GPT account](https://community.glideapps.com/t/open-ai-in-glide-or-ai-assistant-in-gpt-account/70904)
**Author:** [@Alina](https://community.glideapps.com/u/Alina)\ **Replies:** 15\ **Last updated:** [June 8, 2024, 6:02am UTC](https://community.glideapps.com/t/open-ai-in-glide-or-ai-assistant-in-gpt-account/70904 "2024-06-08T06:02:06Z")
Hello dear Gliders! I’m working with a client on a project where user talks with AI to shape certain results which are then stored in a certain format. For this purpose I made a chat (an open AI complete chat with hist… --- ## [How to choose the range of columns based on their own names?](https://community.glideapps.com/t/how-to-choose-the-range-of-columns-based-on-their-own-names/73928)
**Author:** [@ILYA](https://community.glideapps.com/u/ILYA)\ **Replies:** 3\ **Last updated:** [June 8, 2024, 4:42am UTC](https://community.glideapps.com/t/how-to-choose-the-range-of-columns-based-on-their-own-names/73928 "2024-06-08T04:42:13Z")
Sorry for my question cos, I’m very new in GLIDE and would appreciate a quick guideline, if possible, of course. My question is: Whether is possible to make a filter or query to choose the range of columns based on the… --- ## [Profile email address change changes back after refresh](https://community.glideapps.com/t/profile-email-address-change-changes-back-after-refresh/73962)
**Author:** [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Replies:** 7\ **Last updated:** [June 8, 2024, 3:41am UTC](https://community.glideapps.com/t/profile-email-address-change-changes-back-after-refresh/73962 "2024-06-08T03:41:55Z")
Is there restriction on changing the email address in the profile\> I am changing the address, it changes in tables, I can move around, but as soon as I refresh the browser it reverts to what it was. This is not happeni… --- ## [Convert Numbers into fractions](https://community.glideapps.com/t/convert-numbers-into-fractions/73956)
**Author:** [@Denis1](https://community.glideapps.com/u/Denis1)\ **Replies:** 5\ **Last updated:** [June 8, 2024, 3:18am UTC](https://community.glideapps.com/t/convert-numbers-into-fractions/73956 "2024-06-08T03:18:06Z")
Is there a way to convert numbers with decimals into fractions --- ## [Error in table SQLServer](https://community.glideapps.com/t/error-in-table-sqlserver/73964)
**Author:** [@julana](https://community.glideapps.com/u/julana)\ **Replies:** 1\ **Last updated:** [June 8, 2024, 12:16am UTC](https://community.glideapps.com/t/error-in-table-sqlserver/73964 "2024-06-08T00:16:07Z")
Hi. I’m trying to upload my SQLServer database to Glide, but when I enter the password, it says it’s wrong. I tried to open a ticket, but the open button disappeared. What do I do? I need to connect my table… --- ## [Regex](https://community.glideapps.com/t/regex/73958)
**Author:** [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Replies:** 14\ **Last updated:** [June 8, 2024, 12:11am UTC](https://community.glideapps.com/t/regex/73958 "2024-06-08T00:11:46Z")
Having problems. I am upload a file which is being converted to a path https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/hdshfasdSDFVCKfsdoaoD1P1w/pub/798sdsdfSDFSDAl/price\_json.txt When I am displayi… --- ## [Deleting a row from the data editor](https://community.glideapps.com/t/deleting-a-row-from-the-data-editor/73949)
**Author:** [@Amine\_LALLALI](https://community.glideapps.com/u/Amine_LALLALI)\ **Replies:** 3\ **Last updated:** [June 8, 2024, 12:08am UTC](https://community.glideapps.com/t/deleting-a-row-from-the-data-editor/73949 "2024-06-08T00:08:24Z")
Hello ! I want to delete a row from the data editor, but it’s not working. i tried to select a row and tap delete on my keyboard but it doesn’t work. I want to delete a user from de user Data. Anyone has an Idea ? Th… --- ## [AI to generate charts - dall-e-3 alternatives?](https://community.glideapps.com/t/ai-to-generate-charts-dall-e-3-alternatives/73945)
**Author:** [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Replies:** 1\ **Last updated:** [June 7, 2024, 11:37pm UTC](https://community.glideapps.com/t/ai-to-generate-charts-dall-e-3-alternatives/73945 "2024-06-07T23:37:42Z")
Community users will be familiar with the nice set of charts offered by Glide. However, we all know they are really very limited. Quickchart.io is also quite limiting. I wondered if a workaround would be to use an AI int… --- ## [Free-monthly payment tutorial](https://community.glideapps.com/t/free-monthly-payment-tutorial/73946)
**Author:** [@Maria\_Vallone](https://community.glideapps.com/u/Maria_Vallone)\ **Replies:** 2\ **Last updated:** [June 7, 2024, 11:30pm UTC](https://community.glideapps.com/t/free-monthly-payment-tutorial/73946 "2024-06-07T23:30:54Z")
Hi everyone, I have created my own app, where the user initially has to register his profile in order to access, I would now like it to be possible for you to first go through a payment method before accessing the actual… --- ## [Clearing Data in "Note" and "Adjustment" Columns After Button Click](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919)
**Author:** [@smprod](https://community.glideapps.com/u/smprod)\ **Replies:** 7\ **Last updated:** [June 7, 2024, 11:29pm UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919 "2024-06-07T23:29:25Z")
I have a problem with my Glide app that I’m hoping someone can help me with. In my “Staff” table, I have several columns containing employee data, but most importantly, I have two columns named “Note” and “Adjustment”. … --- ## [Excel limit](https://community.glideapps.com/t/excel-limit/73871)
**Author:** [@julana](https://community.glideapps.com/u/julana)\ **Replies:** 7\ **Last updated:** [June 7, 2024, 11:18pm UTC](https://community.glideapps.com/t/excel-limit/73871 "2024-06-07T23:18:34Z")
Hi, good afternoon. Have a limit in import table excel? I’m trying to upload a 30.9MB excel spreadsheet, but it’s throwing an error. I suspect it’s the file size. I didn’t find any topic regarding this, not even in the … --- ## [Migrating from Google Sheets - how to create and sort a unique list in Glide Tables](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877)
**Author:** [@matt45](https://community.glideapps.com/u/matt45)\ **Replies:** 5\ **Last updated:** [June 7, 2024, 11:16pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877 "2024-06-07T23:16:13Z")
I’m wanting to migrate an app from Google Sheets to purely Glide Tables, but I’m not sure how to replicate some features. I have a dashboard that managers are able to click in and view weekly reports submitted by their … --- ## [Issue with Component not loading for specific user and/or device](https://community.glideapps.com/t/issue-with-component-not-loading-for-specific-user-and-or-device/73894)
**Author:** [@chanwise](https://community.glideapps.com/u/chanwise)\ **Replies:** 19\ **Last updated:** [June 7, 2024, 9:20pm UTC](https://community.glideapps.com/t/issue-with-component-not-loading-for-specific-user-and-or-device/73894 "2024-06-07T21:20:26Z")
Has anyone had an issue with a component not loading for a specific user? So I have a custom collection that has open visibility and no row owners or user specific data. If I do a View As (as that user) within Glide, I c… --- ## [Connect to URL and domains](https://community.glideapps.com/t/connect-to-url-and-domains/73950)
**Author:** [@fraser](https://community.glideapps.com/u/fraser)\ **Replies:** 3\ **Last updated:** [June 7, 2024, 6:44pm UTC](https://community.glideapps.com/t/connect-to-url-and-domains/73950 "2024-06-07T18:44:24Z")
Hi all We have an existing website I’m replacing with a glide app and I’ve successfully linked glide to my domain, so my glide app is now at www.mydomain.com rather than the glide url. However I want to create links - … --- ## [Como abrir um ticket? june/24](https://community.glideapps.com/t/como-abrir-um-ticket-june-24/73963)
**Author:** [@julana](https://community.glideapps.com/u/julana)\ **Replies:** 1\ **Last updated:** [June 7, 2024, 6:39pm UTC](https://community.glideapps.com/t/como-abrir-um-ticket-june-24/73963 "2024-06-07T18:39:30Z")
Hi. I need to open a ticket, but don’t see the option. What happened? How do I open a ticket? --- ## [Create one app for several companies](https://community.glideapps.com/t/create-one-app-for-several-companies/73121)
**Author:** [@Michael\_Cjl](https://community.glideapps.com/u/Michael_Cjl)\ **Replies:** 3\ **Last updated:** [June 7, 2024, 6:30pm UTC](https://community.glideapps.com/t/create-one-app-for-several-companies/73121 "2024-06-07T18:30:54Z")
Hi community! I’m interested in Glide. I have created a management application on my free Glide account to test it. However, I would like to know if it is possible to manage several customers with dedicated databases fo… [Previous page](https://community.glideapps.com/c/help-how-to/27.md?page=185) [Next page](https://community.glideapps.com/c/help-how-to/27.md?page=187)