You can export data from a custom view to a formatted text file or a xml file. You can load this file to any spreadsheet application (Excel, Google Sheets, Zoho Sheets, ...).
Execute custom view definition.
Click Export Custom View.
In this case items that were never checked out are displayed.
The exported file is saved in the C:/handy_et/data/db/expimp/ folder.
Questions:
Could you show me where to find information on what and
how the SQL definitions under Custom View Assistant work,
specifically the "items that were not checked out"?
My question is how can I design and run equipment reports and export
results to excel spreadsheet.?
Handy Equipment-Tool Manager uses Firebird SQL language.
Questions:
Could you please let me know how handy equipment system can export the checked out items into an excel file?
In the Custom Views you can define any SQL query and export results to a text formatted file (select TAB as separator) that you you can open in Excel. We provide help with SQL queries for users with valid support.
We offer Handy Library Manager application for libraries that includes the same custom views/statistics functionality. In addition, you can find more how-to and sample topics in the Handy Library-Custom Views-Stats help section.
Latest equipment tracking how to articles:
How to email overdue notices to borrowers?
How to predefine email messages?
How to set automated emails with your Gmail account?
How to set automated emails with your Office365 account?
How to display checked out items in the equipment main inventory?
How to modify due dates for the checked out equipment?
Customized check-out receipt, include all items.
How to send email messages to all equipment users?
How to print group-by reports where each group starts on a new page?
How to export data from a custom view?
How to print, email check-out receipts?
How to modify the grid (number of columns, column size, column position)?
Handy Equipment Management with Check In/Out:
Handy Equipment-Tool Manager
tour
features
try now
cloud
Equpiment, tool tracking software solutions:
- office inventory tracking with check in/out
- equipment tracking, tool crib tracking with check in/out
- av, media equipment with check in/out
- police equipment
- prison, equipment tracking with check in/out
- athletic, sport equipment tracking review
- calibration management software
library software packages (included with handy e-t software):
school library
church library
non-profit org. library
business library
community library
small public library
Copyright © 2024 · All Rights Reserved · PrimaSoft PC