# How to create an app for taking Sales Orders **URL:** \ **Category:** Ask for Help\ **Created:** [April 14, 2020, 2:55pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048 "2020-04-14T14:55:07Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 5, 2020, 4:54am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/43 "2020-05-05T04:54:10Z")
tes…,I want to keep [https://taadz.com](https://taadz.com) not [https://glidetaadz.com](https://glidetaadz.com) , I think I am not need subdomain so it doesn’t change address … I want to keep [https://taadz.com](https://taadz.com) instead of [https://glidetaadz.com](https://glidetaadz.com) . Thank… ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 5, 2020, 1:06pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/44 "2020-05-05T13:06:14Z")
@Jeff_Hager need your help! I’ve done as you said here. But now I wanna disable the buttons from the other companies while I have some items from one business in my cart shop I’ve tried using in the Products sheet Template ID+Business and a Relation to get if that business has already gotten, but I think I’m getting lost somewhere about the visibility It’s the only detail it’s missing ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [May 5, 2020, 10:28pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/45 "2020-05-05T22:28:37Z")
Then configure your app IN GLIDE using your [taadz.com](http://taadz.com) domain. You don’t need the other one. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 5, 2020, 10:38pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/46 "2020-05-05T22:38:53Z")
I’ll probably need a better visual, since I don’t know how exactly your app is set up, but I imagine you would need some sort of relation on the product sheet to the order sheet. I would create a template joining the signed in user’s email, and a boolean value of false. Use that to link to the order sheet where you will have a template of the signed in user’s email and the confirmed order boolean value (true/false). Next do the same template/relation setup again, but this time include business name on both templates. Now you will have 2 relations that you can use for your visibility. Set the visiblility to show the button if no unfulfilled order exists for that user (first relation is empty) OR an unfulfiled order exists for that business only (second relation is not empty). ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 6, 2020, 2:46am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/47 "2020-05-06T02:46:28Z")
Yes! That’s what i missed. The confirmed option. Instead of Boolean in my order sheet, I used If then to bring the number 1 when the Relation to confirmed orders is empty. Thank you so much! It works perfectly as usual > **[Forker](https://forker.glideapp.io/)** > > Cada garfada conta! Mas para isso você precisa escolher os melhores pratos. ---
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 6, 2020, 3:03am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/48 "2020-05-06T03:03:24Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/862129895189669560e2c19ab42ab00cd7a305fa.jpeg) please observe the picture above, the screen appears a lot of service seller profile pictures appear, the longer will be more and more lists are becoming sellers. I want to limit the display that appears, for example only 20 people who appear on the screen other than that must go through the search field, is it possible ?? ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 6, 2020, 3:20am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/49 "2020-05-06T03:20:38Z")
Yes it’s possible. There is actually template available that you can copy and use.if not, I’ll explain how to achieve it. Let me check if template is still available on the glide App Store. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 6, 2020, 3:28am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/50 "2020-05-06T03:28:33Z")
[myradio.glideapp.io](http://myradio.glideapp.io) ---
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 6, 2020, 3:51am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/51 "2020-05-06T03:51:14Z")
You are only put 4 radio and are different wirh 12 popular tab. I thnik for app [https://resipi.glideapp.io/](https://resipi.glideapp.io/) is good enough. I came up with inspiration from your app, my idea is that anyone can make a radio station or TV station in the Glide app, is it possible ?? ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 6, 2020, 11:50am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/52 "2020-05-06T11:50:43Z")
Hi, this is not my app. Sorry. A generous person made it available for others to copy and learn from his app. Thank him, not me 🙂 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 6, 2020, 11:52am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/53 "2020-05-06T11:52:32Z")
Tv? hmmm well yes and no. You can livestream say from YouTube. ---
**Author:** ![Erni\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erni_d/32/9023_2.png) [@Erni\_D](https://community.glideapps.com/u/Erni_D)\ **Post date:** [May 8, 2020, 8:16pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/54 "2020-05-08T20:16:00Z")
I’m trying to get this. Wiz made available their template but I deleted by error. Can you share yours. I’m trying to replicate the multi restauran order feature! Thanks in advance and awesome work! ---
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 13, 2020, 12:52am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/55 "2020-05-13T00:52:25Z")
I can’t find the template in the glide app store ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 13, 2020, 2:44am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/56 "2020-05-13T02:44:38Z")
Sorry, which one ? ---
**Author:** ![Diklat\_MII](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diklat_mii/32/1047_2.png) [@Diklat\_MII](https://community.glideapps.com/u/Diklat_MII)\ **Post date:** [May 14, 2020, 2:26am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/57 "2020-05-14T02:26:30Z")
I want to limit the display that appears, for example only 20 people who appear on the screen other than that must go through the search field, is it possible ?? [/quote] ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 14, 2020, 4:04am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/58 "2020-05-14T04:04:05Z")
Sorry 5 am where i am. Yes you can sort the data.and show 1st 20 items only. I’ll post the formula later in the day for you. Tx. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 14, 2020, 9:10pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/59 "2020-05-14T21:10:55Z")
Hi sorry for the delay. my network down and still is. I’m using mob data. Here we go: 1. Create a hot topics or most popular tab in you spreadsheet (let’s call it BreakingNews). Then decide how many Breaking news items you want from your main sheet (let’s call it the AllHeqdlines sheet) displayed as BREAKING NEWS. Say its 10 for now. 2. Use this formula to pull the first 10 items from your AllHeadlines sheet into your BreakingNews sheet. =Query(AllHeadlines!A:C,”select \* limit 10”) A:C is the range. I’ve assumed you have 3 columns only. You can change it. 1. Create details display tab in app Then use two inline lists. 2. For first inline list use the BreakingNews tab, and choose between cards or boxes. Display them how you like. Then tick search box to activate it. 3. For 2nd inline list, which you will display under first inline lis, pull the AllHeadlines tab and choose the compact list. Then turn on search bar. That’s first option. Second option. On one tab of your app display only the first 10 items. Create a 2nd tab to display AllHeadlines. Third option. One one tab of your app display only the first 10 items. Make sure it’s a details display. Om this page create a button called say “for more headlines tap button”. When the button opens pull the “AllHeadlines” sheet. This has limitations by the way. Try all of them out for yourself. The following link has detailed info on how you can use SortN to pretty much achieve the same. > **[Extract Top N Number of Items From a Data Range in Google Sheets](https://www.google.co.uk/amp/s/infoinspired.com/google-docs/spreadsheet/extract-top-n-number-of-items-from-a-data-range-in-google-sheets/amp/)** > > I have a sales report in Google Sheets where I want to extract only the top 5 items based on sales volume. Is it possible, and if possible, how to do that? Yup! It's possible in Google Sheets. Let's see how to extract top N number of items from a... ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 14, 2020, 9:20pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/60 "2020-05-14T21:20:33Z")
There are other options. But those involve creating relations between items/categories. Check out the Glide Documentation. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 14, 2020, 11:57pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/61 "2020-05-14T23:57:19Z")
> [@Wiz.Wazeer](#): > > =Query(AllHeadlines!A:C,”select \* limit 10”) Excellent recommendations by Wiz, but I would like to add something about this here. There’s a possibility that some people’s sheet are configured so that their latest items are added to the last rows. In that case, assuming column A contains the date of the item. You can do a query like: ``` =QUERY(AllHeadlines!A:C, "SELECT * ORDER BY A DESC LIMIT 10") ``` Or this would have the same effect, albeit you have to do it in separate columns. ``` =QUERY(SORT(News!A2:A,ROW(News!A2:A),TRUE),"limit 10 offset "&(COUNTA(News!A2:A)-10)) ``` ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [May 15, 2020, 12:12am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/62 "2020-05-15T00:12:56Z")
I better save this 😇 [Previous page](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048.md?page=2) [Next page](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048.md?page=4)