Objective⌗

As part of the Elite Tech Park - Zoho Creator Assessment, I developed a Library System application in Zoho Creator. The app features robust validations, workflows, and dynamic reporting to ensure efficient library management.

Below, I explain what the application offers and how it works.

What I Created⌗

The Library System application consists of several modules, each designed to handle specific library operations. Here’s a breakdown of the functionalities: Image Description

Task 1: Create Modules and Forms⌗

1. Books Module⌗

  • Fields:
    • Book ID (Auto-generated)
    • Title (Text - Mandatory)
    • Author (Text - Mandatory)
    • Genre (Dropdown - Predefined values: Fiction, Non-Fiction, Sci-Fi, Biography)
    • Publication Year (Number - Valid years between 1900 and the current year)
    • Available Copies (Number - Minimum value = 0)
    • ISBN Number (Text - Unique validation)
    • Rating (Number - Values between 1 to 5) Image Description

2. Members Module⌗

  • Fields:
    • Member ID (Auto-generated)
    • Name (Text - Mandatory)
    • Email (Email - Validated for proper format)
    • Phone Number (Number - Validated for 10 digits)
    • Membership Start Date (Date - Default to the current date)
    • Membership Type (Dropdown - Values: Basic, Premium, Elite)
    • Max Books Allowed (Number - Auto-filled based on Membership Type: Basic=2, Premium=5, Elite=10) Image Description

3. Transactions Module⌗

  • Fields:
    • Transaction ID (Auto-generated)
    • Member (Lookup to Members)
    • Book (Lookup to Books)
    • Issue Date (Date - Default to the current date)
    • Return Date (Date - Must be later than Issue Date)
    • Status (Dropdown - Values: Issued, Returned, Overdue)
    • Fine Amount (Currency - Auto-calculated for overdue books) Image Description

4. Staff Members Module⌗

  • Fields:
    • Staff ID (Auto-generated)
    • Name (Text - Mandatory)
    • Email (Email - Validated for proper format)
    • Role (Dropdown - Values: Librarian, Assistant)
    • Phone Number (Number - Validated for 10 digits) Image Description

Task 2: Implement Form Validations⌗

  • Books Form:
    • Ensure ISBN Number is unique.
    • Validate Publication Year to accept only years between 1900 and the current year.
  • Members Form:
    • Prevent duplicate entries based on Email.
    • Auto-fill Max Books Allowed based on Membership Type.
  • Transactions Form:
    • Prevent transactions if Available Copies = 0.
    • Validate Return Date to ensure it is later than Issue Date.

Task 3: Create Workflows⌗

  • Books Module:
    • Decrease Available Copies by 1 when a book is issued.
    • Increase Available Copies by 1 when a book is returned.
  • Transactions Module:
    • Auto-calculate Fine Amount for overdue books ($2 per day overdue).
    • Email members about overdue books, including fine details.
  • Members Module:
    • Send a welcome email to new members.
  • Staff Members Module:
    • Role-based permissions:
      • Librarians can issue/return books.
      • Assistants can view books/members but cannot make changes.

Task 4: Generate Reports and Dashboards⌗

  • Reports:
    • Overdue Books Report: List overdue transactions with member and fine details.
    • Top Members Report: Top 10 members who borrowed the most books in a month.
  • Dashboards:
    • Genre Popularity Chart: A pie chart of books borrowed by genre.
    • Staff Activity Log: Track staff actions.

Task 5: Add Custom Features⌗

  • Books Module:
    • Button to mark books as “Featured,” highlighting them in reports.
  • Transactions Module:
    • Custom action “Mark as Lost” to set Available Copies = 0 and log a note in reports.

How It Works⌗

  1. User-Friendly Forms:
    • Each module has dedicated forms for easy data entry and validation.
  2. Dynamic Updates:
    • Fields auto-update based on conditions, reducing manual effort.
  3. Workflows in Action:
    • Automate routine tasks like updating Available Copies, calculating fines, and sending emails.
  4. Role-Based Permissions:
    • Secure access control ensures staff roles are clearly defined.
  5. Insights with Reports:
    • Real-time data visualization through reports and dashboards provides actionable insights.

Submission Requirements⌗

  1. Zoho Creator Application: Exported as a .ds file, Link-> .ds File.
  2. Demo Video: A comprehensive video showcasing:
    • Task completion.
    • Validations, workflows, and reports in action.
    • Role-based permissions. Link–>Click To Watch