# Bolla (delivering documents) **URL:** \ **Category:** Project Showcase\ **Created:** [November 14, 2021, 5:54am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489 "2021-11-14T05:54:57Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 14, 2021, 5:54am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/1 "2021-11-14T05:54:57Z")
Hi Gliders, _before to showup my current application a short introduction of myself, that as far as I remember I never did it._ _I’m an Italian who are currently live & working in Japan. In my past I worked (still working maybe) for several years as a Business Analyst (in the Bank sector especially) and contextually following the development._ Now, I’m currently working to a quite sophisticated application to deliver documents from a Master shop (a Food producer) in Japan to clients (seller Shops). And I’ve designed for this reason 2 application, the central one (Master) and the peripheral ones (clients) that are insisting on the same DB. There are some interesting features that I’ve developed using the Googlescript only (not using the Zapier nor similar), like the automatic update of the DB from the seller shop via Import of GoogleMail into the application triggered once a day from a specific GMail label, and some other in the way to be developed, like the automatic email to send once the manually introduced EVENT is arrived close to his date. **Just le me show you the features:** _1st the Passcode_, a map where the user may access the application without using the email (this is especially good for those clients that doesn’t like to add their email anywhere): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/910468dcebea0eeba2b6fd0d781a8672f54b3079.jpeg) the CSS scripts helps to show it up better, thank to @Lucas_Pires @ThinhDinh and @Uzo . _Then we have the OFFICE menu_, since I like to bring the reality in the virtuality (likewise our reality 🤭) I make it real ![ClickFolder](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83e551d359229a840d8f5e82cfe38026312f91a3.gif) Where every 1/4 of the screen is independent and call a different action, but it is also interactive, since it changes in case of Expiring date for Payment or else The buttons below are helping me to add a menu on the bottom of the screen instead to have it hided. And onestly I like to have nice icons on the screen. All the functionalities are under the check of the user rights, of course. We have statistical data that are quite important to verify the shopping activities: ![Stats](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78348be450bbbc703928b892ca7a17bca0d80114.jpeg) The payments that can be associated to different Bolla (Delivery document) in order to complete the payment information (perhaps sometime the client pay in different ways in different time) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1178f57a431de29877f2ae9742ddaa0a145b0e0.png) The events (that as I wrote before will trigger an email send 2 days before his date). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/72bd3cf3b69d03143a86735f0156a0b15e10ffef.png) and finally the Bolla that as I said the Interactive menu make me easy to understand if there is any expiring for payment: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea6d87ce7d9b1ab489cecb08ffc4dcc71b064014.jpeg) Inside it I can immediatelly been adivesed in case of expiring (before X days) ITEMS on client side so that I know where is my goods and what is their own status. Clicking on it I can have the list of those items with a propers Flag that indicate to me the status ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e4726b8c1c30ce6e39a77b95f0f56baeb4547f8e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/8557e09c503f97e4957917c4a8e5b72b7194e5d8.jpeg) Further on that I can duplicate the Bolla, that’s in order to save time: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/786c310a973659d21f5a2f5a418b3848f43e45cf.png) Or I can have the details of the whole Bolla, with the Gross and Net amount, total items delivered and sold out, percentage to deliver to the clients, the associated payments and the eventual messages (inquiry msg) from the clients to the master shop ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e074ca61aa404c465926868ad080466c6511235c.png) Further on this I’ve created the automatic Import of SOLD Items from the shop using GoogleEmail and Googlescript features, and then i create a log like the following: **(NEW) from 9 to 10 in Bolla(19) day: Tue Nov 09 2021 20:46:19 GMT+0900 (Japan Standard Time)** **(NEW) from 8 to 9 in Bolla(19) day: Tue Nov 09 2021 20:46:06** a similar log is created in case of manual changes for each item, that in order to fix back data in case of manual input mistakes: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/838756627703228c5bd04a0ce1630ea013729c73.png) then I’ve the possibility to print out or visualize on web the Bolla and as well the customer can do it: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec31b239f9d489923b2ab02c43c0a5261eeac956.png) [Click Here](https://vimeo.com/manage/videos/645654544) to see the video with explanations: and here the application (but please, if you go inside do not touch too much, is an alive version), use the Passcode 123456 to access on it: > **[Bolla](https://bolla.glideapp.io/)** > > application to Create and follow the Packing List, the Document of Load/Unload Goods from the Seller to the Buyer and update economic and production statistic, with possible exchange of inquiry, Scan barCode, with a B2B interactive exchange ---
**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\ **Post date:** [November 14, 2021, 6:10am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/2 "2021-11-14T06:10:47Z")
Awesome. This is a clean and inspiring app. Thanks for sharing. ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 14, 2021, 6:18am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/3 "2021-11-14T06:18:52Z")
welcome! ---
**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\ **Post date:** [November 14, 2021, 6:41am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/4 "2021-11-14T06:41:24Z")
I could login without entering the 123456 password. Is it normal? ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [November 14, 2021, 6:50am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/5 "2021-11-14T06:50:57Z")
@MIKAHEL Looks good 🤩 ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 14, 2021, 7:38am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/6 "2021-11-14T07:38:06Z")
Actually yes, because I removed an HIDE action from the Office menu 😅 Now Im fixed it! thanks ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 14, 2021, 7:38am UTC](https://community.glideapps.com/t/bolla-delivering-documents/34489/7 "2021-11-14T07:38:42Z")
Thank you! Obrigado!