Another Tech Tips
Another Tech Tips
  • 213
  • 392 196
Create a Visitor Management App with AppSheet: Complete Step-by-Step Guide
Welcome to Another Tech Tips channel!
In this comprehensive guide, we’ll walk you through building a Visitor Management App using AppSheet. Whether you’re managing office visitors or securing a residential area, this app will streamline your visitor check-in process, ensure secure access, and maintain accurate visitor logs-all without writing a single line of code!
This video covers the entire process of creating a Visitor Management App, including registering visitors, getting approvals from the visiting person, and maintaining a visitor log book. Perfect for businesses, offices, and gated communities.
Key Features Highlighted:
* Visitor Check-In Workflow: Learn how to design an efficient visitor check-in process.
* OCR for ID Capture: Automatically capture visitor information using OCR technology.
* Visitor Approval: Set up a system for the visiting person to approve or reject visitors.
* Visitor Signing Out: Track when visitors leave the premises for better security.
* Visitor Log Book: Maintain a comprehensive log of all visitors for future reference.
* Staff Registration: Manage in-house staff such as guards and office personnel.
Timestamps:
0:00 Another Tech Tips Channel
0:06 Introduction
6:20 Tutorial 1
14:35 Tutorial 2
26:25 Tutorial 3
If you found this video helpful, don't forget to like, share, and subscribe for more content! Let us know in the comments if you have any questions or need further assistance.
Google Workspace Refferal Link:
referworkspace.app.goo.gl/cyrQ
💬 Questions or suggestions? Leave a comment below!
👍 Enjoyed the video? Give us a super thanks, like, share, and subscribe!
🔔 Join our Membership for Exclusive Access: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin
New Videos Every Friday!
Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html
Share video: czcams.com/video/UQ6-H2glxH4/video.html
Google Sheet Template: shorturl.at/M3202
*TOOL USED*
Doodly - paykstrt.com/2073/58252
Speechelo - jacibb.speechelo.hop.clickbank.net/
Grammarly - app.grammarly.com/
WonderShare Filmora 9- shrsl.com/2g9r1
WonderShare Filmora 9 $5 deal Coupon Code: MEN9CRFD $5 Deal
Screen-O-Matic- screencast-o-matic.com/
*MATERIAL SOURCES*
Canva - canva.7eqqol.net/Qo1OP
Pexels - www.pexels.com/
QR Code - www.qrcode-monkey.com/
Thanks for watching!
#AppSheet #VisitorManagement #NoCodeDevelopment #VisitorCheckIn #OCR #BusinessAutomation #TechTips #2024
zhlédnutí: 100

Video

ATT RealTime Delivery Tracker v1.2: New Dashboard and Enhanced Reporting Features
zhlédnutí 61Před 12 hodinami
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/cO-Hm39FC4U/video.html Discover the new features and enhancements in version 1.2 of the ATT RealTime Delivery Tracker app! This update introduces a comprehensive dashboard with fo...
Master CRM App v1.0 Development with AppSheet: Complete Step-by-Step Guide
zhlédnutí 265Před 19 hodinami
Welcome to Another Tech Tips channel! In this comprehensive guide, learn how to build a custom CRM app with AppSheet in minutes! This video combines an introduction and step-by-step tutorials to help you manage customer relationships, automate tasks, and streamline your business operations without any coding experience. Whether you're a small business owner or part of a larger organization, thi...
ATT RealTime Delivery Tracker v1.1: Enhanced User Management and Access Control
zhlédnutí 76Před dnem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/Xbsw3GtEdHY/video.html Discover the new enhancements in version 1.1 of the ATT RealTime Delivery Tracker app! This update introduces a USER table for better user management, updat...
Ultimate Guide to Healthcare Management with AppSheet: Multi-Clinic & Patient Care Tutorial
zhlédnutí 308Před 14 dny
Welcome to Another Tech Tips channel! Discover the power of AppSheet for managing your Medical Hub Center or clinic efficiently! This comprehensive guide combines an introduction and detailed tutorials, showcasing the diverse features that streamline operations and enhance patient care within healthcare facilities. Overview: In this ultimate guide, we explore the innovative capabilities of AppS...
Step-by-Step Guide: UX and Essential Configurations in ATT Real Time Delivery Tracker 2
zhlédnutí 83Před 14 dny
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Welcome back to our series on building the ATT Real Time Delivery Tracker app! In this video, we'll guide you through setting up the user interface, format rules, app options, and essential automation settings...
Complete Guide: Build Your Own Attendance App with AppSheet - Step-by-Step Tutorial
zhlédnutí 1,6KPřed 21 dnem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/v8XVNOtptD4/video.html In this comprehensive tutorial, learn how to revolutionize your event management with AppSheet! This complete guide takes you through every step of creating...
Step-by-Step Guide: Setting Up Data and Actions in ATT Real Time Delivery Tracker 1
zhlédnutí 121Před 21 dnem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Welcome back to our series on building the ATT Real Time Delivery Tracker app! In this video, we'll guide you through the crucial steps of data setting and action setting in AppSheet. Learn how to set up actio...
Introducing ATT Real Time Delivery Tracker: Streamline Your Delivery Process with AppSheet
zhlédnutí 426Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Welcome to the ATT Real Time Delivery Tracker introduction video! Discover how this powerful app, built with Google AppSheet, can simplify your delivery management. Perfect for businesses with small delivery t...
How to Easily Build a Leave Application App with AppSheet | Tutorial 3
zhlédnutí 250Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/llaNwm96Lu0/video.html Google Sheet: czcams.com/video/c9iv64WoOeM/video.html Google Workspace Refferal Link: referworkspace.app.goo.gl/cyrQ Welcome to our channel! In this video, ...
How to Easily Build a Leave Application App with AppSheet | Tutorial 1.1
zhlédnutí 154Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/GP8iHQSkPXk/video.html Google Sheet: shorturl.at/4ZNyF Google Workspace Refferal Link: referworkspace.app.goo.gl/cyrQ Welcome to our channel! In this video, we introduce our Leave...
How to Easily Build a Leave Application App with AppSheet | Tutorial 2
zhlédnutí 279Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/RSJ4XJ1Rbfc/video.html Google Sheet: shorturl.at/4ZNyF Google Workspace Refferal Link: referworkspace.app.goo.gl/cyrQ Welcome to our channel! In this video, we introduce our Leave...
How to Easily Build a Leave Application App with AppSheet | Tutorial 1
zhlédnutí 445Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/llaNwm96Lu0/video.html Google Sheet: shorturl.at/4ZNyF Google Workspace Refferal Link: referworkspace.app.goo.gl/cyrQ Welcome to our channel! In this video, we introduce our Leave...
How to Easily Build a Leave Application App with AppSheet | Intro
zhlédnutí 594Před měsícem
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/RM5j9YP4djI/video.html Google Sheet: shorturl.at/4ZNyF Google Workspace Refferal Link: referworkspace.app.goo.gl/cyrQ Welcome to our channel! In this video, we introduce our Leave...
Simplify Stock Counting: Build an App with AppSheet Effortlessly Tutorial 2
zhlédnutí 208Před 2 měsíci
Welcome to Another Tech Tips channel! Join this channel to get me some meal: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.htmljoin Subscribe: czcams.com/channels/bSjnNCeneoRRWqetIdkXDw.html Share video: czcams.com/video/xA_rJByntGo/video.html Google Sheet : shorturl.at/a8AM1 ⏰ Timestamps: 0:00 Another Tech Tips Channel 0:55 Intro 2:16 Table Setting 3:33 Ux Setting 6:45 Format Rules Setting In tod...
Simplify Stock Counting: Build an App with AppSheet Effortlessly Tutorial
zhlédnutí 295Před 2 měsíci
Simplify Stock Counting: Build an App with AppSheet Effortlessly Tutorial
Simplify Stock Counting: Build an App with AppSheet Effortlessly
zhlédnutí 332Před 2 měsíci
Simplify Stock Counting: Build an App with AppSheet Effortlessly
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 3
zhlédnutí 149Před 2 měsíci
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 3
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 2
zhlédnutí 252Před 4 měsíci
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 2
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 1
zhlédnutí 301Před 4 měsíci
Revolutionize Event Management: Build Your Own Attendance App with AppSheet! Tutorial 1
Unlock Unlimited Apple TV Streaming with Surfshark VPN! 🌐 | Exclusive Discount Inside!
zhlédnutí 65Před 4 měsíci
Unlock Unlimited Apple TV Streaming with Surfshark VPN! 🌐 | Exclusive Discount Inside!
Revolutionize Event Management: Build Your Own Attendance App with AppSheet!
zhlédnutí 326Před 4 měsíci
Revolutionize Event Management: Build Your Own Attendance App with AppSheet!
Unboxing Magtame Magcable - A Full Magnetism And Super Fast Charging USB C Cable And Lightning Cable
zhlédnutí 66Před 5 měsíci
Unboxing Magtame Magcable - A Full Magnetism And Super Fast Charging USB C Cable And Lightning Cable
Create Your Van Sales App Quickly with Google AppSheet
zhlédnutí 662Před 8 měsíci
Create Your Van Sales App Quickly with Google AppSheet
Build an Inventory System with Google AppSheet & Barcode Integration in 5 Minutes
zhlédnutí 5KPřed 8 měsíci
Build an Inventory System with Google AppSheet & Barcode Integration in 5 Minutes
Tutorial 3: Continue AnotherTechTips MediHub Clinic App with AppSheet
zhlédnutí 369Před 8 měsíci
Tutorial 3: Continue AnotherTechTips MediHub Clinic App with AppSheet
Tutorial 2: Continue AnotherTechTips MediHub Clinic App with AppSheet
zhlédnutí 470Před 8 měsíci
Tutorial 2: Continue AnotherTechTips MediHub Clinic App with AppSheet
Tutorial 1: AnotherTechTips MediHub Clinic App with AppSheet
zhlédnutí 666Před 8 měsíci
Tutorial 1: AnotherTechTips MediHub Clinic App with AppSheet
Revolutionizing Healthcare: AppSheet for Multi-Clinic Management & Patient Care
zhlédnutí 1KPřed 9 měsíci
Revolutionizing Healthcare: AppSheet for Multi-Clinic Management & Patient Care
Seamless Weather API Integration with AppSheet: Your Ultimate Guide for CRM App Enhancement!
zhlédnutí 1,4KPřed 11 měsíci
Seamless Weather API Integration with AppSheet: Your Ultimate Guide for CRM App Enhancement!

Komentáře

  • @joemarebreo4010
    @joemarebreo4010 Před 15 hodinami

    Hi, I'm very much appreciate in helping us build this application. I have learned so much in this video. Hopefully there's another app for document request form with approval

    • @AnotherTechTips
      @AnotherTechTips Před 7 hodinami

      Hi! I’m so happy to hear that you found the CRM app video helpful and that you’ve learned a lot from it! 😊 Your suggestion for a document request form with an approval process is fantastic-I’ll definitely keep it in mind for future tutorials. Creating content takes time and effort, so any support you provide-whether it’s subscribing, sharing, or even joining as a member-really helps keep the channel running smoothly and allows me to continue making valuable tutorials. 🙏 Thank you for watching, and feel free to share more ideas or questions anytime! 🙌

  • @temyraverdana6421
    @temyraverdana6421 Před dnem

    You are like a volcano, another great project. hanks a lot, I hope a day to reach your skills

    • @AnotherTechTips
      @AnotherTechTips Před 7 hodinami

      Thank you so much for your kind words! 😊 I’m really glad you enjoyed the Visitor Management project. It's all about exploring new ideas, concepts, and gaining experience over time, and I'm sure you'll get there too! 🙌 Your support means a lot and helps me continue sharing more projects like this. If you’d like to help keep the channel active, subscribing, sharing, or becoming a member would be greatly appreciated. Thanks again for being part of this journey! 🙏

  • @temyraverdana6421
    @temyraverdana6421 Před 2 dny

    Another great update. Thanks a lot

    • @AnotherTechTips
      @AnotherTechTips Před 2 dny

      Thank you so much for your kind words and support! 😊 I'm glad you enjoyed the update! I'd love to get to know more about you and your experience with the app. If you have any suggestions or feedback, feel free to share! Also, if you find the content helpful, don't forget to like, share, and consider supporting the channel through Super Thanks or joining our membership for exclusive content. Thanks again for being part of the community! 🙌

  • @Ram-r7n
    @Ram-r7n Před 3 dny

    I have used this methods, but I get duplicates when there are concurrent users adding new rows. Do you have good solution for it?

    • @AnotherTechTips
      @AnotherTechTips Před 3 dny

      Thank you for your comment! As I mentioned in the video, using this method for assigning serial numbers can lead to duplicates when multiple users add new rows concurrently. To avoid this, the best practice is to use the UNIQUEID() function for key generation, as it ensures uniqueness. However, if you need to stick to using a sequence number as the key, one way to minimize the risk of duplicates is by adjusting the process to reduce the time that a key is 'held' during creation. You could try generating the key earlier in the process or only assigning the key upon saving the row. This might help reduce the chances of concurrent duplicates. If you found the video helpful, don't forget to like, share, and subscribe! Your support really helps me keep creating more content. And if you'd like to dive deeper into AppSheet, consider giving a Super Thanks or joining the channel membership for exclusive content and early access to new videos!

  • @FoodPeopleOfficialStore-fh1kv

    Hi may i request for the geo script thank you

    • @AnotherTechTips
      @AnotherTechTips Před 7 dny

      Hi! Thanks for watching my video! 😊 I'd be happy to share the geo script with you. Just drop me an email, and I’ll send it over to you. Also, if you’ve been finding my content helpful, it would mean a lot if you could like, share, and subscribe! If you’d like to support the channel further, feel free to explore Super Thanks or even join our membership for more exclusive content. Looking forward to hearing from you!

  • @user-cj7jt3gg9x
    @user-cj7jt3gg9x Před 8 dny

    Great Thanks!

    • @AnotherTechTips
      @AnotherTechTips Před 7 dny

      Thank you so much! 😊 I'm glad you enjoyed the video! If you found it helpful, I’d love it if you could like, share, and subscribe to support the channel. And if you feel like going the extra mile, Super Thanks or joining the membership helps me keep creating content like this! 🙌 Thanks again for your support!

  • @kirayagami9229
    @kirayagami9229 Před 15 dny

    It would be great if you could make a step-by-step tutorial on how to create a Document Tracking System (DTS). Thank you, sir.

    • @AnotherTechTips
      @AnotherTechTips Před 14 dny

      Thank you for the suggestion! A Document Tracking System (DTS) sounds like a great idea, and we’ll definitely add it to our to-do list. We have a few other apps lined up to share first, but it won't take too long. Make sure to subscribe so you’ll get notified as soon as the video is published. Your support is greatly appreciated!

  • @kirayagami9229
    @kirayagami9229 Před 15 dny

    Thank for this wonderful app and tutorial. Kudos sir.

    • @AnotherTechTips
      @AnotherTechTips Před 14 dny

      Thank you so much for your kind words! I'm glad you found the tutorial helpful. If you haven’t already, please consider liking, sharing, and subscribing to the channel. Your support means a lot and helps us create more content like this. Also, consider joining our membership or giving a Super Thanks if you’d like to support us even further. Thank you!

  • @Baala84
    @Baala84 Před 16 dny

    How to check the app?

    • @AnotherTechTips
      @AnotherTechTips Před 16 dny

      Thanks for your comment! If you're asking how to check the app, I recommend watching the full series in this playlist: czcams.com/play/PL6gExtmhEdfC_itXOzEr9pgqmGJ0xkdCb.html This will guide you through all the steps in detail. Don't forget to subscribe to my channel for more tutorials, hit the like button if you found this helpful, and share it with others who might benefit. Your support through Super Thanks and by joining the channel's membership is greatly appreciated! 😊

    • @Baala84
      @Baala84 Před 16 dny

      @@AnotherTechTips thanks

  • @dasiangraagas9619
    @dasiangraagas9619 Před 17 dny

    Is this free

    • @AnotherTechTips
      @AnotherTechTips Před 16 dny

      Great question! 😊 AppSheet offers a free tier that allows you to build and deploy apps, but there are limitations in terms of the number of users and features available. For more advanced functionality and scaling your app within a business environment, a paid plan is typically required. However, if you’re using Google Workspace, there’s a fantastic perk-AppSheet Core licenses are included by default with almost all Google Workspace editions! This means you can use AppSheet to build and manage apps like this attendance tracker without needing to purchase additional licenses, making it a cost-effective solution for businesses of all sizes. I highly recommend subscribing to Google Workspace to take full advantage of this offer. You can get started by using my referral link here: referworkspace.app.goo.gl/cyrQ. Let me know if you have any more questions-happy to help!

  • @temyraverdana6421
    @temyraverdana6421 Před 18 dny

    Wow, it's wonderful! do you think to add a receipt wen delivered to?

    • @AnotherTechTips
      @AnotherTechTips Před 18 dny

      hank you so much for your wonderful comment and for sharing such a great idea! We truly appreciate your input. I'm excited to let you know that we've already implemented a feature where clients receive an email notification once their order is delivered. This is covered in our tutorial for version 1.2. If you’re eager to see it, you can get early access by joining our membership, or you can wait for the public release on August 23, 2024, at 9 PM. Your support means a lot to us, and we encourage you to consider giving a Super Thanks or joining our membership for more exclusive content and early access. Thank you for being part of our community! 🙌

  • @andeoyebrayan8189
    @andeoyebrayan8189 Před 19 dny

    wow i have been looking for this for long thanks

    • @AnotherTechTips
      @AnotherTechTips Před 19 dny

      Thank you so much! I'm glad you found the video helpful. 🙌 If you'd like to support our work, consider giving a Super Thanks or even joining our membership for exclusive benefits and early access to new content. Your support means a lot and helps us keep creating valuable content for the community! 😊

  • @daltonbay6295
    @daltonbay6295 Před 21 dnem

    The wait is no more 😊

    • @AnotherTechTips
      @AnotherTechTips Před 21 dnem

      Thank you for your support! I'm excited to share this video is available for everyone to enjoy right away. 😊 If you’d like to get early access to all our latest tutorials and other exclusive content, consider joining our membership. We release new videos every Friday for everyone, but members can watch them all immediately and enjoy extra perks! Stay tuned for more exciting content coming twice a week now. Cheers! 🎉🚀

  • @administratorasiapools3913

    I'm having problem with Max Days column. The column could not be detected for the Duration.

    • @AnotherTechTips
      @AnotherTechTips Před 21 dnem

      Hi there, please refer to the video below to fix the problem: czcams.com/video/GP8iHQSkPXk/video.html

    • @administratorasiapools3913
      @administratorasiapools3913 Před 20 dny

      @@AnotherTechTips Thanks! For Employee List_Detail (system generated) When I try to do the column order manually. There's no Related Leave Requests by Employee Email. Only have Related Leave Requests By Approver.

  • @administratorasiapools3913

    Hi! First of all, thankss for uplaoding these tutorials. Really really helpful. However, when I'm doing Slice setting for the Slice Action, there's no 'Open Supporting Document' action from the dropdown.

    • @AnotherTechTips
      @AnotherTechTips Před 21 dnem

      First of all, thank you for watching our video and I'm glad to hear that you found it helpful! Regarding your issue with finding the "Open File (Supporting Documents)" action in the slices setting, here are a few things you can check: The "Open File" action is a system-generated action that we did not explicitly create. Ensure that "Supporting Documents" is a column name with the column type set to "File." Go to the Behavior section and select "Show all actions" to review all hidden actions. Check if the "Open File" action is there. I hope this helps resolve your issue. If you have any further questions, feel free to ask! Also, if you find our content useful, please consider supporting us by using the Super Thanks feature or joining our membership for more exclusive content. Thank you again for your support!

  • @Clipsbykim2
    @Clipsbykim2 Před 27 dny

    Hi, at @10:50 , do i need to change the HYPERLINK there right? how can I do or how can I find that in my own app? thank you in advance for your response.

    • @AnotherTechTips
      @AnotherTechTips Před 27 dny

      Hi there! Thanks for watching and for your support! Yes, you need to change the HYPERLINK at @10:50. You can find the link for your app in the AppSheet Share App section, and it's the browser link you need to use. If you have any more questions or need further assistance, feel free to ask. And if you find the tutorial helpful, please consider giving a super thanks or joining our membership for more exclusive content and support!

  • @Clipsbykim2
    @Clipsbykim2 Před měsícem

    how can change or range the day on the Appsheet calendar from Monday to Sunday ?

    • @AnotherTechTips
      @AnotherTechTips Před 29 dny

      Thank you for your question! Could you please provide more details about what you're trying to achieve with the calendar in AppSheet? Your description will help us understand your needs better and provide a more accurate solution. Also, if you find our tutorials helpful, consider supporting us with a Super Thanks or by joining our membership for exclusive content and early access to new tutorials. We appreciate your support!

  • @Luludapunk
    @Luludapunk Před měsícem

    idk why but my keyboard will not show up in bluetooth

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Did you turn on the pairing mode in the keyboard, you may doing so by press and hold the number 1 / 2 / 3

  • @PanhaBonty
    @PanhaBonty Před měsícem

    12:23 After watching full tutorial, i found the duration can not auto calculate

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you for your comment! I'm glad you reached out about the Duration column issue. To set the correct duration in the Leave Request Table, you need to use the following formula in the Initial value (under Auto Compute) for the Duration column: HOUR([End Date] - [Start Date])/24 + 1 This formula calculates the total number of days between the start and end dates, including the start date itself. If you found this helpful, please consider supporting our channel with Super Thanks or by joining our membership. Your support helps us maintain and improve our content. If you have any more questions or need further assistance, feel free to ask. Thanks again for your support!

  • @silverarrows95
    @silverarrows95 Před měsícem

    Love the high detail of sound

  • @touchIdea24
    @touchIdea24 Před měsícem

    Great tutorial

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words and appreciation! We’re thrilled to hear you enjoyed the tutorial. If you found it helpful, consider showing your support with a Super Thanks and joining our membership. This helps us continue creating smooth and informative AppSheet ideas and videos. The video you watched is just a part of a larger series. You can check out the full episodes from this playlist: czcams.com/play/PL6gExtmhEdfCWXXDrWTDG33DMfsYfHo1Z.html Happy learning and thanks for being part of our community!

  • @Clipsbykim2
    @Clipsbykim2 Před měsícem

    How can I filter Employee access so they can only view and update their own information on the Tap of Employee? But the Approver can view and access all Data

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thanks for watching and for your encouraging support! You can filter employee access in your Leave Application app so they can only view and update their own information on the Employee tab while allowing approvers to view and access all data. One effective method is to use the Role in the Employee table combined with Security Filters on the Leave Request table. If you need a detailed step-by-step guide, feel free to ask! And don't forget to join our membership for more in-depth tutorials and support.

    • @Clipsbykim2
      @Clipsbykim2 Před měsícem

      @@AnotherTechTips thank you for your respone I watch your previous Video and It's was fixed now, However I have one more question: How to restrict the Annual leave Form in Appsheet for useremail from the same department and same position? Example: If Users A and B are from the same department and have the same position, they will not be able to fill out the Annual Leave form for the same date. However, User C comes from the same department as A and B but has a different position. So, User C is able to request Annual Leave for the same date as User B or C.

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      @@Clipsbykim2 Thank you for your response! I'm glad to hear the previous video helped you fix the issue. I appreciate your support, and if you really enjoy our content, please consider using Super Thanks or joining our membership. Your support is crucial for maintaining the channel. Regarding your question on restricting the Annual Leave form in AppSheet for users from the same department and position: To achieve this, you can add a validation check during input start date and end date. However, my suggestion is to allow anyone to apply for leave on the any day. The approver can then decide whose leave to approve. You can manage this by tweaking the approval action. For example, if a leave request for the same period, department, and position is already approved, the approval action for new requests can be hidden. This approach gives more flexibility and control to the approvers while simplifying the leave request process for users. Thank you for your continued support, and I hope this helps! If you have any more questions, feel free to ask.

  • @ME_PROFESSOR_20
    @ME_PROFESSOR_20 Před měsícem

    Do videos clearly 😑

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you for your feedback! I appreciate your suggestion and will work on making my future videos clearer. I'm glad that 185 people found the video helpful. If you have any specific questions or need further assistance with transferring WhatsApp Business from Android to iOS, feel free to ask!

  • @linmax7059
    @linmax7059 Před měsícem

    Hi , Sir hope this comment finds you will and im from Taiwan ~ first of all , its very appreciated of making this video , its really helpful ! and i've do all the tutorial step by step , but still can't printing successful i get errors in PrintNode : queued download HTTP response status code 400 ive tried access the printing content directly with browser and it shows: Error retrieving file 'Files/20241515.pdf': URL has an invalid signature. how can i solve this problem thank you!

  • @theTrainMan007
    @theTrainMan007 Před měsícem

    hi there, am i blind as i cannot seem to understand or find setting up your App Sheets, what the headers are etc

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you for your comment! I'm sorry to hear you're having trouble. The headers you're referring to might be the column headers in the Google Sheet used in the AppSheet setup. You can find the Google Sheet link in the video description. If you're having trouble with specific steps, I recommend watching all three parts of the tutorial to ensure you don't miss any important details. I've also included cards in the video to help guide you to the next part. Here’s the link to the full playlist for easier navigation: czcams.com/play/PL6gExtmhEdfDDzkd3QdAKlzPVeqIxUOhW.html. If you enjoyed the video, please like, share, and subscribe to our channel. Consider supporting us with a Super Thanks or joining our membership program for exclusive access to all our videos. Non-members can still watch all our content, as we publish new videos every Friday. If you have any more questions or need further assistance, feel free to ask. I'm here to help!

  • @temyraverdana6421
    @temyraverdana6421 Před měsícem

    Hi, sound like a useful app. Thanks a loto for share it

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Hi there, thank you so much for your kind words! I'm glad you found the app useful. Your support means a lot to us. If you enjoyed the video, please like, share, and subscribe to our channel. If you'd like to see more exclusive content, consider joining our membership program. You'll get early access to all our videos and much more! Thanks again for watching and supporting our channel!

  • @PanhaBonty
    @PanhaBonty Před měsícem

    @AnotherTechTips What's the App formula of "Application List Description Employee"?

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀 Here is the video for the setting of the column: czcams.com/video/GP8iHQSkPXk/video.html

  • @Clipsbykim2
    @Clipsbykim2 Před měsícem

    it can not find "Leave balance" @12:14 please help

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you for your comment and for pointing that out! I appreciate your attention to detail. 😊 The column for Leave Balance is indeed mentioned in the video at the 14:20 mark. I hope this helps clarify any confusion. If you find my videos helpful, please consider supporting the channel by giving a Super Thanks or joining our membership for more exclusive content and early access to tutorials. Thanks again for your support and feedback!

    • @PanhaBonty
      @PanhaBonty Před měsícem

      ​@@AnotherTechTips 12:12 I can't find [Max Day] ?

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀 Here is the video for the setting of the column: czcams.com/video/GP8iHQSkPXk/video.html

  • @vikassmalviya1807
    @vikassmalviya1807 Před měsícem

    Please Share script

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀 Back to your question, drop us an email and we will shared the script with you.

  • @PanhaBonty
    @PanhaBonty Před měsícem

    Could you please share the latest version of the Google Sheet as some headers have been changed

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀 Back to your question, the Google Sheet that shared, is the latest version. Perhaps you may been confused with the Virtual column, those column that with "Blue color Pen", it is a virtual column that we need to manually create in the appsheet.

  • @AslanAll
    @AslanAll Před měsícem

    Thank you! Pressing “Enter” key has helped me

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀

  • @Clipsbykim2
    @Clipsbykim2 Před měsícem

    Thanks for uploaded

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀

    • @Clipsbykim2
      @Clipsbykim2 Před měsícem

      Supper thanks doesn't support my country yet, however any is it possible for you to share as copy of the the Application Appsheet ? I would like to use it. I appreciate you for your response and if it's possible for you to do it

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you for your interest! I understand that Super Thanks might not be available in your country. We've created a detailed tutorial series to guide you through the process. Part 1 is already available to the public, and Part 2 will be released this coming Friday. The final part, Part 3, will be available the following Friday. I encourage you to join our membership to get immediate access to all the videos. If our tutorial videos don't cover everything you need, feel free to reach out, and we'll be happy to help you develop your app. Thank you for your understanding and support!

    • @Clipsbykim2
      @Clipsbykim2 Před měsícem

      @@AnotherTechTips Could you lead a step-by-step guide on how to initially build the application? The video only demonstrates how to configure the settings.

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      @@Clipsbykim2 Hi there, Thank you so much for watching my video! I'm grateful for your interest and support. 🙏 I apologize if the video didn't cover everything you needed in detail. I understand that you're looking for a step-by-step guide starting from the very beginning of building the app. While I do pre-build parts of the app to ensure the video runs smoothly, I aim to cover all the necessary steps in my tutorials. If you'd like to support my channel, please consider giving a Super Thanks or joining our membership for more exclusive content and early access to all parts of the tutorial series. Thank you again for your feedback and support!

  • @Clipsbykim2
    @Clipsbykim2 Před měsícem

    I am awaiting Part 2 on how to build t it; kindly guide me through it, step by step.

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀

  • @user-rp2vz5qp2m
    @user-rp2vz5qp2m Před měsícem

    The videos are very nice but you need to show the overview first that how it works

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thank you so much for your kind words! 😊 I'm thrilled to hear that the tutorial helped you understand AppSheet better. Your support means the world to me! If you'd like to support the channel even more, consider giving a Super Thanks or joining our membership. As a member, you'll get immediate access to all the videos we publish, so you won't have to wait. Non-members can still enjoy all our content, but videos will be released every Friday. Your contributions help us keep creating high-quality content and bring more value to you. Thanks again for watching and supporting the channel! 🙏🚀 Check this playlist, hope this helping you: czcams.com/play/PL6gExtmhEdfAO_IauHkUqTwh1quPoLv9R.html

  • @mikelaraudi1701
    @mikelaraudi1701 Před 2 měsíci

    Hello. Thank you very much for the content. Do you know how to make it work correctly on an iPhone? On iPhone it does not launch the form again when finished and it also performs all the synchronization after taking each photo. Thanks again. Greetings.

    • @AnotherTechTips
      @AnotherTechTips Před měsícem

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Back to your question, as I know this feature doesn't work well in iOS.

  • @IndaloRobotics
    @IndaloRobotics Před 2 měsíci

    You where to quick to end and say bye on this vid

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Dear, anything I can help with?

  • @nadyaazzuka7479
    @nadyaazzuka7479 Před 2 měsíci

    hallo can u send me script for geocode? thx

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Dear, kindly drop us an email, we will email the script to you, thank you.

  • @shazzie4eva
    @shazzie4eva Před 2 měsíci

    It would be great if u could share the database/table

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! The Google Sheet link is shared in the video description.

  • @lolololo-bd6hd
    @lolololo-bd6hd Před 2 měsíci

    Nice video.. Question, where can i find the appsheet template?

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Below as the playlist for the full tutorial, hope it does help, thank you czcams.com/play/PL6gExtmhEdfC_itXOzEr9pgqmGJ0xkdCb.html

  • @victorsamgichuhi2486
    @victorsamgichuhi2486 Před 2 měsíci

    Haha. 1 like = 100 Motivation ; 1 SUB = 3000 Motivation. I like

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel!

  • @DamakFoodSpZoo
    @DamakFoodSpZoo Před 2 měsíci

    Do you have another video for Raw Printing? Is it always required to print a pdf file or within json message we can pass the raw printing commands?

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Back to your question, too bad we didn't have this video, perhaps you may share, how do you want to accomplish ur task?

  • @DEV_LUCAS-iy1rp
    @DEV_LUCAS-iy1rp Před 2 měsíci

    VERY COOL, THANKS FOR SHARING, I FOLLOW YOUR CHANNEL A LOT, COULD YOU MAKE THE GEOCODE SCRIPT AVAILABLE?

    • @AnotherTechTips
      @AnotherTechTips Před 2 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Kindly leave us an email, we will send the script to you.

  • @Tommassso
    @Tommassso Před 3 měsíci

    Can you share the template?

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Hi there, we do share the step by step tutorial to build this app: czcams.com/play/PL6gExtmhEdfAWkuegr3x5-0DHiA33vjJn.html Kindly let us know if anything we can help with. Thank you.

  • @Tommassso
    @Tommassso Před 3 měsíci

    Great Job!

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel!

  • @sergiovictor86
    @sergiovictor86 Před 3 měsíci

    Great job.

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel!

  • @motursudheerkumar7986
    @motursudheerkumar7986 Před 3 měsíci

    1. I am using a bot to instantly retrieve data from a Google Sheet and perform data actions in AppSheet. 2. Additionally, when data is sourced from other platforms such as third-party apps to update certain cells in a row, the Google Sheet gets updated, but the data is not fetched by AppSheet. A disclaimer states that "Third-party interactions (like IFTTT) or scripted interactions will not trigger events." To address this issue, I'm seeking a solution. I attempted to address this by incorporating a formula in the Excel sheet, adding two columns to result in a numerical value. The idea was that whenever there's an update from a third-party source, the formula would yield a new number. However, despite the formula generating a new value, I speculate that it might not be recognized as an update, hence preventing data fetching by AppSheet. Unfortunately, this approach also failed. Could you please suggest a solution for this issue?

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Did you enable the appsheet event in your google sheet?

    • @motursudheerkumar7986
      @motursudheerkumar7986 Před 3 měsíci

      @@AnotherTechTips yes enabled.. It is not triggering..

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      @@motursudheerkumar7986 Hm....this weird, let's check and come back to you. Or if you found the solution, kindly share with us too. Thank you very much.

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Hi there, we just have a quick test: 1) enable the AppSheet Event in the Google Sheet (extensions > AppSheet Events > turn events on/off > select the sheet that would on the AppSheet Event) 2) Then in the Appsheet, we create two bots, 1st: when data added, send an email. 2nd: when data updated, send an email. 3) Then we try to update some record in the google sheet, and also add a new record. 4) Both bot is worked, as we receive the both email. Hope this help.

    • @motursudheerkumar7986
      @motursudheerkumar7986 Před 3 měsíci

      Nice Job.. I am saying that I won't update Google Sheets manually. When you edit, add, or delete, the AppSheet event triggers, but when Google Sheets is updated through a third-party app, Google Script, or any formulas in Google Sheets, it does not trigger. This is my exact question. I have been doing R&D for 3 days and have not found a solution. @@AnotherTechTipsI @@AnotherTechTips

  • @gabystepz
    @gabystepz Před 3 měsíci

    Hi, thanks for sharing, excellent tutorial, I would like to have the geo script. thanks

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Dear, kindly drop us an email, we will email the script to you, thank you.

  • @saravananr-oc3nm
    @saravananr-oc3nm Před 3 měsíci

    can you share this for learning purpose like Copy and Customize. It's very helpful to me.

    • @AnotherTechTips
      @AnotherTechTips Před 3 měsíci

      Thanks for watching our video. If you enjoy my content and would like to support me in creating more of it, you can now use Super Thanks to show your appreciation! Your support means the world to me and helps me to continue creating the content that you love. So if you'd like to support my channel and be a part of this community, please consider using Super Thanks during watching my video, you can find the Super Thanks button under the video. Thank you so much for your support, and I can't wait to see you on my audience support channel! Dear, perhaps you may refer to this playlist: czcams.com/play/PL6gExtmhEdfDkKTnejJFxZgfu1lb_gOVD.html