Spreadsheet Integration in Mewayz

The Spreadsheet Management System allows you to create, organize, and manage spreadsheet files and folders within your organization.

Demo URL

Introduction

The Spreadsheet Management System allows you to create, organize, and manage spreadsheet files and folders within your organization. This system integrates with various business sections, including Project, Contract, Lead, Deal, Tour & Travel, Hospital, Purchase, CMMS, LMS, Sales, School & Institute, Newspaper, and Assets. You can link spreadsheets to specific records from these sections, share them with team members, and control access permissions. The system supports hierarchical folder organization and provides filtering options to quickly locate your spreadsheets.

How to Install the Add-On?

To Set Up the Spreadsheet Add-On, you can follow this link: Setup Add-On.

You can easily connect the data of these Add-Ons with the Spreadsheet in real-time. There will be a dedicated button for the spreadsheet at the top of all the Add-Ons mentioned, by clicking which you can connect all the required data in the form of a spreadsheet.

• CRM
• Project
• Assets
• Contract
• LMS
• CMMS
• School / Institute Management
• Newspaper Distribution Management
• Tour
• Hospital Management

How to use the Spreadsheet Add-On?

Managing Your Content

• To create a new folder, use the “Create” button by entering the folder name. This creates a folder to organize your files or create subfolders for better organization. Folders help you structure your spreadsheets by department, project, or any other classification that suits your business needs.
• To create a new file, use the “Create” button by entering the file name and adding your content or data in sheet format. This creates a spreadsheet file with structured data input that you can use for various business purposes such as tracking budgets, managing inventory, or analyzing performance data.
• The system provides filtering options to search through your spreadsheets efficiently. Use the Model Name dropdown to select from available spreadsheet categories, including Project, Contract, Lead, Deal, Tour & Travel, Hospital, Purchase, CMMS, LMS, Sales, School & Institute, Newspaper, and Assets.
• These filters are particularly useful when you have numerous spreadsheets and need to quickly locate files related to specific business areas or records.
• The spreadsheet list view displays all your files and folders in a table format. The File/Folder Name column shows your items, and clicking on any folder will show its subfolders and files recursively, allowing you to navigate through your folder structure. This hierarchical navigation makes it easy to maintain organized file systems regardless of complexity.
• The Related column displays linked model and value information when spreadsheets are connected to specific business records. This provides immediate context about which business processes or records your spreadsheets relate to.

Working with Files and Folders

• In the Action column, you can access several functions that enable comprehensive file management. “Related Folder” allows you to link a file or folder with a specific model and its record, such as connecting a spreadsheet to “Website Development Project” or a specific tour in Tour & Travel. This linking ensures your spreadsheets maintain contextual relationships with your business operations.

• “Share” lets you share files or folders with specific users and set permissions as either View or Edit. When shared, the particular user will see the shared file or folder in their login. This feature enables team collaboration while maintaining control over who can view or modify your spreadsheets.

• “View” opens and displays the content of a file in read-only mode, perfect for reviewing data without risk of accidental changes. This button is only visible for files, not folders, since folders serve as containers rather than having viewable content.

• “Edit” allows you to rename a folder or update the content of a file. For folders, this means changing the folder name to better reflect its purpose. For files, you get full editing capabilities to modify data, formulas, and formatting.
• “Delete” permanently removes a file or folder from the system. Use this function carefully as the deletion cannot be undone, and deleting a folder will also remove all its contents.