# Ask for Help **URL:** https://community.glideapps.com/c/help-how-to/27.md?page=851 [Latest](https://community.glideapps.com/latest.md) · [Categories](https://community.glideapps.com/categories.md) · [Tags](https://community.glideapps.com/tags.md) **Page:** 852 --- ## [Prevent duplicate entries](https://community.glideapps.com/t/prevent-duplicate-entries/13146)
**Author:** [@Annie](https://community.glideapps.com/u/Annie)\ **Replies:** 7\ **Last updated:** [July 27, 2020, 10:02am UTC](https://community.glideapps.com/t/prevent-duplicate-entries/13146 "2020-07-27T10:02:30Z")
I have created a small app for marking students attendance in a physical class. This is to be used by a teacher teaching in a slum cluster. I am able to select the date and mark bunch of students as present or absent. H… --- ## [Integromat vs. Zapier](https://community.glideapps.com/t/integromat-vs-zapier/13136)
**Author:** [@Alexdz](https://community.glideapps.com/u/Alexdz)\ **Replies:** 3\ **Last updated:** [July 27, 2020, 9:09am UTC](https://community.glideapps.com/t/integromat-vs-zapier/13136 "2020-07-27T09:09:29Z")
Hello, just stumbled upon this - a competitor of Zapier. It seems to be way more affordable, https://www.integromat.com/en/ Is anyone using it with Glide? --- ## [Trigger Function](https://community.glideapps.com/t/trigger-function/12981)
**Author:** [@Khushi\_Puri](https://community.glideapps.com/u/Khushi_Puri)\ **Replies:** 12\ **Last updated:** [July 27, 2020, 3:54am UTC](https://community.glideapps.com/t/trigger-function/12981 "2020-07-27T03:54:46Z")
Please guys I need some help. I am new here. I have created a COVID 19 Tracker app https://letstrackcorona.glideapp.io/. I have to edit it everyday, please can anyone tell me about trigger function so that my sheet is… --- ## [Drop down menu in form or during feedback submission](https://community.glideapps.com/t/drop-down-menu-in-form-or-during-feedback-submission/13133)
**Author:** [@S\_C](https://community.glideapps.com/u/S_C)\ **Replies:** 4\ **Last updated:** [July 27, 2020, 3:50am UTC](https://community.glideapps.com/t/drop-down-menu-in-form-or-during-feedback-submission/13133 "2020-07-27T03:50:40Z")
Hello, I want to be able to allow users to submit product information. One component is ingredients. As this is a tedious process with possibility of typographical errors, I was wondering if it possible to create a drop… --- ## [Reading parts of string with 20 numbers](https://community.glideapps.com/t/reading-parts-of-string-with-20-numbers/12989)
**Author:** [@Alexandre\_Caruso](https://community.glideapps.com/u/Alexandre_Caruso)\ **Replies:** 15\ **Last updated:** [July 27, 2020, 2:56am UTC](https://community.glideapps.com/t/reading-parts-of-string-with-20-numbers/12989 "2020-07-27T02:56:18Z")
Hi, my user add a string of 47 numbers reading from codebar. I have to follow a layout and take parts of this string to get the type of information, for instance, the first 3 numbers. From the 4th to 10th get the amount… --- ## [Help With Deleting a Row with a Certain Cell Value](https://community.glideapps.com/t/help-with-deleting-a-row-with-a-certain-cell-value/13106)
**Author:** [@Paris\_Smith](https://community.glideapps.com/u/Paris_Smith)\ **Replies:** 3\ **Last updated:** [July 27, 2020, 2:48am UTC](https://community.glideapps.com/t/help-with-deleting-a-row-with-a-certain-cell-value/13106 "2020-07-27T02:48:38Z")
Hi, I am playing around with scripts with the intent to delete a row on my sheet with a user action (click a toggle making a cell go from False to True). Can anyone assist? Thanks in advance for any help!! Also, I’m cu… --- ## [Create an account for each customer?](https://community.glideapps.com/t/create-an-account-for-each-customer/13103)
**Author:** [@laDakh](https://community.glideapps.com/u/laDakh)\ **Replies:** 5\ **Last updated:** [July 26, 2020, 11:14pm UTC](https://community.glideapps.com/t/create-an-account-for-each-customer/13103 "2020-07-26T23:14:38Z")
Hi Gliders If i have a lot of clients do i need to create an account on glide platform for each one? Thanks --- ## [Limits of Google Drive videos in Glide?](https://community.glideapps.com/t/limits-of-google-drive-videos-in-glide/12994)
**Author:** [@ray\_d](https://community.glideapps.com/u/ray_d)\ **Replies:** 1\ **Last updated:** [July 26, 2020, 9:19pm UTC](https://community.glideapps.com/t/limits-of-google-drive-videos-in-glide/12994 "2020-07-26T21:19:15Z")
I’m creating an app that will feature a lot of short videos (each 2-5mb) that will be streaming from Google Drive. Before I dig too deep into this project, is anyone aware of streaming limits for videos stored on Google… --- ## [Sort an array by the original column order](https://community.glideapps.com/t/sort-an-array-by-the-original-column-order/13025)
**Author:** [@bruce](https://community.glideapps.com/u/bruce)\ **Replies:** 4\ **Last updated:** [July 26, 2020, 9:07pm UTC](https://community.glideapps.com/t/sort-an-array-by-the-original-column-order/13025 "2020-07-26T21:07:47Z")
I’ve created an array column to contain a series of other columns. meaning, I have columns for song 1, song 2, song 3, etc., and a Glide column that brings them all together in one column (“song 1 song 2 song 3…”). I’d… --- ## [Out of interest: Where is the data pulled from](https://community.glideapps.com/t/out-of-interest-where-is-the-data-pulled-from/13079)
**Author:** [@Stellasphere](https://community.glideapps.com/u/Stellasphere)\ **Replies:** 1\ **Last updated:** [July 26, 2020, 7:26pm UTC](https://community.glideapps.com/t/out-of-interest-where-is-the-data-pulled-from/13079 "2020-07-26T19:26:40Z")
Hello, I was wondering if every time the app loads, does it pull in data directly from Google Sheets (like sending an API request each time), or is it pulled from Glide’s servers? (Like a middleman, of sorts) --- ## [In staging: Replace the sheet that powers the app!](https://community.glideapps.com/t/in-staging-replace-the-sheet-that-powers-the-app/13073)
**Author:** [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Replies:** 23\ **Last updated:** [July 26, 2020, 7:04pm UTC](https://community.glideapps.com/t/in-staging-replace-the-sheet-that-powers-the-app/13073 "2020-07-26T19:04:27Z")
:star\_struck: Okay…discuss. --- ## [Adding Images](https://community.glideapps.com/t/adding-images/13108)
**Author:** [@Khushi\_Puri](https://community.glideapps.com/u/Khushi_Puri)\ **Replies:** 3\ **Last updated:** [July 26, 2020, 3:03pm UTC](https://community.glideapps.com/t/adding-images/13108 "2020-07-26T15:03:05Z")
I really don’t understand what’s the easiest way to add images in glide? If someone can probably make a video or something, it will be so so helpful. Though I have added earlier but I get confused whenever I have to add… --- ## [Public app with dynamic filters?](https://community.glideapps.com/t/public-app-with-dynamic-filters/13085)
**Author:** [@Younes](https://community.glideapps.com/u/Younes)\ **Replies:** 6\ **Last updated:** [July 26, 2020, 11:00am UTC](https://community.glideapps.com/t/public-app-with-dynamic-filters/13085 "2020-07-26T11:00:21Z")
Hi guys! So i switched my app to Public and i still want to keep the dynamic filters. I wanted to know if it’s still possible to filter content without having a user-specific column. I noticed now that when i access t… --- ## [I am creating a voting app i need help](https://community.glideapps.com/t/i-am-creating-a-voting-app-i-need-help/13061)
**Author:** [@Glider](https://community.glideapps.com/u/Glider)\ **Replies:** 23\ **Last updated:** [July 26, 2020, 1:51am UTC](https://community.glideapps.com/t/i-am-creating-a-voting-app-i-need-help/13061 "2020-07-26T01:51:17Z")
i am creating a voting app which users submit a form to my vote sheet(they find the form button on my candidate sheet) how do i stop multiple voting --- ## [Lookups from multiple realations](https://community.glideapps.com/t/lookups-from-multiple-realations/13087)
**Author:** [@Glider](https://community.glideapps.com/u/Glider)\ **Replies:** 9\ **Last updated:** [July 25, 2020, 11:44pm UTC](https://community.glideapps.com/t/lookups-from-multiple-realations/13087 "2020-07-25T23:44:45Z")
i have lookups from multiple relations how do i display them in the app --- ## [Duplicating sheet which option is best?](https://community.glideapps.com/t/duplicating-sheet-which-option-is-best/13095)
**Author:** [@Angelia\_Baxter](https://community.glideapps.com/u/Angelia_Baxter)\ **Replies:** 5\ **Last updated:** [July 25, 2020, 11:22pm UTC](https://community.glideapps.com/t/duplicating-sheet-which-option-is-best/13095 "2020-07-25T23:22:17Z")
Which option is best to choose if I want to create a backup and save a version of my app in time? If I make edits to the spreadsheet, I am ok with them not going to this backup app. I want it frozen in time. Keep same… --- ## [Acceso a ciertos usuarios al app (NO público)](https://community.glideapps.com/t/acceso-a-ciertos-usuarios-al-app-no-publico/12346)
**Author:** [@JillSaavedra](https://community.glideapps.com/u/JillSaavedra)\ **Replies:** 4\ **Last updated:** [July 25, 2020, 9:52pm UTC](https://community.glideapps.com/t/acceso-a-ciertos-usuarios-al-app-no-publico/12346 "2020-07-25T21:52:52Z")
Buen día, Estoy construyendo un app free donde en el modelo de negocio que tengo son 3 actores el que actuarán con el app: 1. Usuarios (clientes), 2. Prestadores de Servicio, y 3. Administrador. Para el punto 2 son aque… --- ## [New Visablity Tab Per Client](https://community.glideapps.com/t/new-visablity-tab-per-client/13092)
**Author:** [@Izzy](https://community.glideapps.com/u/Izzy)\ **Replies:** 3\ **Last updated:** [July 25, 2020, 5:20pm UTC](https://community.glideapps.com/t/new-visablity-tab-per-client/13092 "2020-07-25T17:20:32Z")
I’ve tested the Visibility Tab using visible by email, I’m wondering if this is the best way to set up an app, I’m wanting to use 1 tab per client - each client would have its own googlesheet page and data. Example: one… --- ## [Contact](https://community.glideapps.com/t/contact/13093)
**Author:** [@Nathalie\_Simons](https://community.glideapps.com/u/Nathalie_Simons)\ **Replies:** 0\ **Last updated:** [July 25, 2020, 4:28pm UTC](https://community.glideapps.com/t/contact/13093 "2020-07-25T16:28:13Z")
y a t-il quelqu’un qui vit en Belgique qui pourrait m’expliquer par téléphonne comment fonctionne le bouton relation ? J’ai beau regarder les vidéos et lire les traductions en français, pour moi ça ne veut pas dire grand… --- ## [Inventory by location](https://community.glideapps.com/t/inventory-by-location/12985)
**Author:** [@Marc\_Lanson](https://community.glideapps.com/u/Marc_Lanson)\ **Replies:** 7\ **Last updated:** [July 25, 2020, 10:38am UTC](https://community.glideapps.com/t/inventory-by-location/12985 "2020-07-25T10:38:13Z")
So would really like to be able to do this on one sheet if its possible. I have a list of inventory across multiple locations, for example: Location Item Amount London Peaches 4 Paris Melons 3 Lon… --- ## [ArrayFormula to apply checklist cell](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797)
**Author:** [@FeAle](https://community.glideapps.com/u/FeAle)\ **Replies:** 7\ **Last updated:** [July 25, 2020, 7:31am UTC](https://community.glideapps.com/t/arrayformula-to-apply-checklist-cell/12797 "2020-07-25T07:31:14Z")
Hi, Please I would like to apply a checklits cell data always I create a new data in column A. I have tried this formula - =ARRAYFORMULA(if(A2:A\<\>“”;B2:B=FALSE;)), but without success. Any tip? See attached the image … --- ## [Generating a Complex schedule tab](https://community.glideapps.com/t/generating-a-complex-schedule-tab/13072)
**Author:** [@R0GUEEE](https://community.glideapps.com/u/R0GUEEE)\ **Replies:** 0\ **Last updated:** [July 25, 2020, 1:36am UTC](https://community.glideapps.com/t/generating-a-complex-schedule-tab/13072 "2020-07-25T01:36:48Z")
Thinking of something along the lines of using a details page and loading in an inline list of either individual “by day” schedules, or by person with click to view to show a full summary including start/stop times, hour… --- ## [Rollup sum from If, then, else source column](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093)
**Author:** [@Ed\_V](https://community.glideapps.com/u/Ed_V)\ **Replies:** 7\ **Last updated:** [July 24, 2020, 10:09pm UTC](https://community.glideapps.com/t/rollup-sum-from-if-then-else-source-column/11093 "2020-07-24T22:09:35Z")
Hey Gliders, Just a quick one: I’m trying to sum the values from a multiple relation column using the rollup function however I can only see count and count unique, not a sum option. I assume this is because the source… --- ## [Addition of two Relations (match simple)](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052)
**Author:** [@noneight](https://community.glideapps.com/u/noneight)\ **Replies:** 22\ **Last updated:** [July 24, 2020, 5:00pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052 "2020-07-24T17:00:25Z")
Hello Guyz :grinning:, Do you know if there is anyway to additionate two relation like : In order to have something like : --- ## [On-boarding](https://community.glideapps.com/t/on-boarding/10377)
**Author:** [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Replies:** 32\ **Last updated:** [July 24, 2020, 2:20pm UTC](https://community.glideapps.com/t/on-boarding/10377 "2020-07-24T14:20:46Z")
Good evening, My webapp aims at facilitating school homework for families via “fun - micro challenge” . For 1 given family, there can have several kids in different classes at school; therefore, in step 1, the Family-A… --- ## [Title on multiple row](https://community.glideapps.com/t/title-on-multiple-row/13049)
**Author:** [@Frglb](https://community.glideapps.com/u/Frglb)\ **Replies:** 3\ **Last updated:** [July 24, 2020, 2:01pm UTC](https://community.glideapps.com/t/title-on-multiple-row/13049 "2020-07-24T14:01:50Z")
by default, Titles are cropped and appear in one single row. How to show titles in full length? --- ## [Importjson script multiple imports](https://community.glideapps.com/t/importjson-script-multiple-imports/13032)
**Author:** [@Krivo](https://community.glideapps.com/u/Krivo)\ **Replies:** 6\ **Last updated:** [July 24, 2020, 12:17pm UTC](https://community.glideapps.com/t/importjson-script-multiple-imports/13032 "2020-07-24T12:17:50Z")
How to do? Case: Import data from external source where response data is delivered in Json. Dataset is large and will be delivered in chunks A chunk is 500 objects and part of the response of the first chunk will be … --- ## [Close app and print](https://community.glideapps.com/t/close-app-and-print/13043)
**Author:** [@Lomanto](https://community.glideapps.com/u/Lomanto)\ **Replies:** 2\ **Last updated:** [July 24, 2020, 11:26am UTC](https://community.glideapps.com/t/close-app-and-print/13043 "2020-07-24T11:26:44Z")
Good Morning Can someone help me create or use some command to close the application without having to use the glide menu. I would also like to know if it is possible to print directly from the application. Thank you B… --- ## [Is it possible to modify a Theme?](https://community.glideapps.com/t/is-it-possible-to-modify-a-theme/13039)
**Author:** [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\ **Replies:** 3\ **Last updated:** [July 24, 2020, 10:04am UTC](https://community.glideapps.com/t/is-it-possible-to-modify-a-theme/13039 "2020-07-24T10:04:46Z")
Folks, I am using Bold(Dark) Theme. I like the theme and looks good. I want to know is it possible to modify Theme like Dark Theme where the Header sticks inline with Menu Icon as given in screenshot. I want 2nd screen … --- ## [Super Admin](https://community.glideapps.com/t/super-admin/12952)
**Author:** [@Ian\_Wells](https://community.glideapps.com/u/Ian_Wells)\ **Replies:** 9\ **Last updated:** [July 24, 2020, 9:01am UTC](https://community.glideapps.com/t/super-admin/12952 "2020-07-24T09:01:21Z")
Not sure if I am missing something here, bit is it possible to set one user to be a super admin who can edit across all users row in a spreadsheet ? . [Previous page](https://community.glideapps.com/c/help-how-to/27.md?page=850) [Next page](https://community.glideapps.com/c/help-how-to/27.md?page=852)