Using SubTracker

The SubTracker database relies on LibreOffice (or OpenOffice) for most of its functionality. As noted on the main page, the database is organized in tables (Places, Submissions, Titles, etc.) that are primarily accessed through the forms findSubmissions, newSubmissions, Places, and Titles. Data in the tables can also be consulted using queries.

Users can navigate the Titles and Places forms with the arrow keys on LibreOffice or OpenOffice navigation bar at the bottom fo the window. Here is an example from LibreOffice 6.4:
Note the gray arrows < or > go one record in either direction or the arrows with lines |< or >| go to the last record. The triangle with the plus sign will also take you to the end of the table (past the last record) to add a new record.

LibreOffice 7.1 changed the look of the navigation bar, though it operates the same:

In Open Office the same navigation bar looks similar

Use the floppy disk icon to Save the record and the circular two arrows to Refresh (which also saves). If you know what record you want to go to, you can also type the number, but the better way to do it is to search, using the magnifying glass or binoculars icon. There you can enter the text you want to search for: part of the title or place name.

Click in the field you want to search before you click on the search icon, and it will search in that field by default. Otherwise, be sure to choose the field to search after “Single Field”, because LibreOffice will default to searching the TitleID or PlaceID field. You could also choose to search “All Fields,” though that might make searching take longer.

Both Place and Title forms have a table that lists the submissions for each Title or Place. There you can see the title or place, submission status, the Date Sent, Date Replied, and comment. You can also add or edit any of that information. You should be careful not to change the title, place, or date sent unless you are correcting an error. It may be easiest to edit DateR, Status, and comments on the Places or Titles form.

New submissions can be entered at the place or title or by using the newSubmissions form. On the NewSubmissions form, choose the title and place using the dropdown list menus, enter the Date Sent, and select Out as the status (unless you’re entering your submission history, then you can enter the current status of Returned, Accepted, etc.)

Dropdown list menus display titles or places in alphabetical order, so if you begin typing the name of a title or place, the list will automatically update to the first entry with those letters. You can scroll from there to find the entry you want. Click on a dropdown list menu and then start typing, and you’ll see how it works. (You do need to have data in the tables before it will work, of course — to try it in the Places form, type Ponder or Poetry, and it will select Ponder Review or Poetry South. Click the entry you want to select it. If an empty selection is possible, the first line of the list will be blank.)

You can also search for submissions using the findSubmissions form. There you can choose a place, a title OR a range of dates. If you leave any field blank, it won’t be used when filtering the submissions that appear in the table. That means you could search on a Place to see all submissions to that place, a Title to see all submissions of that title, a range of dates to see all submissions between those dates, or a Title (or Place) and a range of dates to see all submisssions of that title (or to that place) between those dates.

It might be useful to see how many submissions you’ve made in a given year or a given decade, for instance. Or you might want to limit the number of submissions of a title displayed if you have a long submission history. It probably wouldn’t make sense to choose both a Title and a Place, since you’ll likely only have one submission, but you could do that.

All fields on the submission table in the findSubmissions form can be edited. Again, be careful not to change existing information unless you intend to correct an error. You can also enter new submissions in this form.

More help on using LibreOffice or OpenOffice Base can be found on their websites.

%d bloggers like this: