Paint Bible Database

[Brianna Bass]

I’m interested in creating a database for my scene shop of past treatments and recipes for future reference. We just have shelves and shelves of binders collecting dust and taking up space. Ideally I’d love this data base to be organized in a way that someone could search both a specific show  with  dropdown menus for specific units, as well as umbrella categories such as “Wood Grain” with dropdown menus for specific types. Ideally these would include color swatches, recipes, detailed direction for application, process photos and perhaps even tutorial videos for each process. BUUUUUUT I’m a computer granny and haven’t the faintest idea where to begin. Has anyone ever encountered a program like this, or know of any software that we could look into? Or do you have any thoughts/ideas/tips on how to create such a database?

[Amy Avalos]

Hi Brianna,

You might want to take a look at “Smartsheet,” it’s an online program. You can set up and customize a template for what you mentioned that you’re looking to do. It provides drop-down menus, filtering and searches for key words, you can upload and attach photos, add comments/notes or video links. We use this program in the theme park industry to track scenic elements, and for project management or other team needs. The program also lets you download your sheet into a PDF or Excel file if needed, or share it online with others. If you have any questions, I’d be happy to discuss further!

https://www.smartsheet.com/

Hope it helps!
Amy

[Brianna Bass]

Hey Amy,

Thanks sooo much! I’ve got another call with one of their reps scheduled for tomorrow. Would you be comfortable telling me which theme park you used this program with? The Rep wants to research that account and get an idea of how the program was tailored for them so they can best serve us.

 

Kindly,

B

[Author]

Posts