Tracking Play Submissions
October 25th, 2008Note: This entry is for Mac users. In fact, it’s only for users of Leopard (AKA OSx 10.5.x).
I did a little review this week on the submissions I made this year, and in that process revamped my tracking system. It’s not just because I’m a data geek that I feel it’s important to track submissions. Once upon a time, I sent a submission out to a place I’d already sent one to some months before. The theatre had a strict policy of only one submission per twelve-month period. My submission was shredded. No matter how nice they were about it, I was embarrassed by my mistake. What an amateur…
And so, I keep track of the scripts I send out. I used to design databases for a living, and while I enjoyed that for a long time, it was work. There’s nothing fun about creating some complicated system for personal use. Well, sometimes. Except I’m too busy. So, off the shelf software was where I began.
I used to use software called Power Tracker than ran on OS9. I received it as a freebie the first time I bought Screenwriter in a very early iteration of that software. Power Tracker was built to track screenplay submissions, and handled stage play submissions, too. I chugged along with that until Apple abandoned OS9, and I needed some other way to track my submissions. I remembered we had a copy of FileMaker Pro somewhere. The Beloved had won a copy of it in a raffle at MacWorld some time ago.
Bento is a neat, cheap, and unsophisticated data management tool.
With FileMaker I went a little overboard designing reports for myself. I like slicing and dicing information in every which way. The only problem with FP really was it was at least two versions old, and not supported by Leopard. FileMaker 7 crashes in Leopard. Some days, FP7 crashes a lot. Still, I couldn’t bring myself to spend nearly a couple of hundred bucks to upgrade, when I only use FP for my little tracking program.
Excel is a great option. MBH uses Excel, I think, to track his submissions. Very easy to sort, group, see what you’ve done. I thought about that. And then I downloaded the trial version of Bento.
Bento is not FileMaker lite. It’s hardly a database. Yet, I think Bento may be my new solution to my script tracking. If not, I’ll just move over to a spreadsheet, and keep an even simplier list.
Within about an hour, I transferred my data from FileMaker into Bento, and using it in conjunction with Address Book, and iCal, I got back to not thinking about software.
How I set Bento up:
My data is now found in these places…
- Submission places (theatres, grants, festivals, workshops, etc.) are kept in Address Book.
- Submission deadlines (for festivals, workshops, competitions) are kept in iCal
- A list of “projects” or scripts is contained in a Bento table.
- A list of submissions made is contained in a Bento table.
Within my Bento, the primary table and display form, is the list of submissions, or the “what’s been submitted” info. That table is linked to the Address Book, which holds the “submitted to where” info. The submissions table is also linked to the Bento projects/scripts table.
A secondary table, or display form, is a list of upcoming deadlines for things I might want to submit something to. This form contains some Bento fields so that I know if I have made a submission to this.
In an ideal database world, the Deadlines table/form would be able to automatically link data to the Scripts Submitted table/form when I click on “Submission Sent.” Bento doesn’t do this type of task. The deadlines table does not contain the theatre name or the dates associated with it. These two data items exist in iCal alone, and Bento doesn’t allow more sophisticated manipulating among Bento tables or forms. There is no Apple script for Bento, or programming code in Bento. A downside of this psuedo-linking is that I cannot search on the theatre name because the theatre name is stored in iCal, or, for the Scripts Submitted form, stored in Address Book. That’s just silly, and I suspect Bento will add that searching feature along with a few other features in the next version.
Below, are three screen shots that pretty much tell you everything about how I’m looking at the data. That’s it. Not as simple as Excel, but simple nonetheless. No special reports. Just a screen display, arrowing through the records.
- This is the form used to track play submissions.
- This is a Bento data entry form that displays data directly from the Address Book.
- This table displays information from iCal.
The danger in looking at a product like Bento is that if you want a database, Bento is not for you. Even though you can attach Address Book and iCal to Bento, and manipulate these sources, Bento is not a true relational database product. If you need a lot of scripts, data sorts, reports and all that good stuff, again, a word of caution that Bento is not for you. I see a lot of folks trying to make Bento into a kind of cheap FileMaker Pro. That’s a lot like trying to turn a hard boiled egg into an souffle.
Bento currently costs $49. It only runs on Leopard.
Tags: software, Submissions
Posted in Web/Tech, Writing Tools








![Validate my RSS feed [Valid RSS]](http://www.itstheintermission.com/wp-content/themes/itstheintermission/images/valid-rss-rogers.png)