Handy Library Manager
 for Windows


Help, how to topics > Library Users > How can you track students' additional information in our library system?


How to customize the Borrowers table?

How can you track students' additional information in our library system?

Schools very often track the student's grade and teacher name information. Unfortunately, our library system does not offer those fields directly. Instead, we include simple explanations and screen snapshots of how you can do that in this topic.

The whole process includes the following steps:

  • review data fields in the borrower add/edit form
  • decide which fields to rename and use for storing extra information
  • rename data fields in Options/Maintenance/Change Field Names
  • review new field names in the borrower add/edit form
  • optional; modify "regular text" to "drop-down box" type

review borrower data fields

Review data fields in the borrower add/edit form; Decide which fields to rename

Open the BORROWERS table and review all data fields. Do you want to store additional information in one of the extra data fields (CUSTOM1-CUSTOM9)? Or, maybe there is a regular data field that you do not plan to use?

For example, there are CUSTOM1 and ADDRESS1 data fields on the first data entry page. Therefore, we will rename them to GRADE and TEACHER in the Options window.


borrower change field names

Rename data fields in Options/Maintenance/Change Field Names

Open the Change Field Names window.


borrower change field names: to teacher

Open the Change Field Names window. Select database. Select CUSTOM1, now enter GRADE, to finish click Update. Next, please do the same modifications with ADDRESS1, and rename it to TEACHER.


borrower form, review changes

Review new field names in the borrower add/edit form

You can review new changes in the borrower Add/Edit data form.

The TEACHER data field is a regular text type. It would be practical to change the field to the drop-down box type. You can do it in the Options window.


modify TEACHER to drop-down list

Modify "regular text" to "drop-down box" type

In the Dropdown Lists window, select BORROWERS; check the box in front of the TEACHER. Next, choose the dropdown type, and Auto-Add. You can enter the whole list of teachers into the Dropdown List text box. Click Close to save changes.

Note: you can review or edit the dropdown list values directly in text files. In this case, the file's name is BORROWER_7.txt (you can find this file in your installation folder; C:/handy_lib/data/db/ folder).


test teacher drop-down list

You can review new changes in the borrower Add/Edit data form.




Question:

Answer:



Copyright © 2023 · All Rights Reserved · PrimaSoft PC