Google drive - building a database

I'm collating a directory of all my production contacts across all of my recent shows from call sheets etc.
Process to date is plug into google-sheets and set a formula for finding people / roles etc
Does anyone have a cheat or other method using google drive / free apps or free online databases?
Thanks kindly.


  • Hi Mich! Are you looking for a cheat to create the database / plug in the info, or for a formula to find people etc? For the latter, the easiest would be to clean your data and ensure the roles etc are uniform (spelling, description) and then just using a simple filter. Really depends on how many contacts you have, if it's worthwhile going for anything more complicated. In general, I stick with the 'Keep it simple' rule though ;)
    Hope this helps and a very merry Xmas!

You must sign up or log in before you 
add a comment.

Post reply