Create, update and save new search list...?
My first post. Go easy on me :)
We're a production company and face a new set of criteria for every new job we get. For this we usually create search lists in excel that contain the criteria for a job. For instance somebody is looking for locations for a photoshoot and want to know whether they'd able to blow up an ice-cream van at the location. So we make a list of all locations that are visually exciting and have a column for the pyro specific information. On one job we may need to know which location allows nudity, on the next job we may need to know which allows late night shooting.
We're hoping to move this search process into FM. In the simplest way possible we would have to be able to customize a list view layout to the newest needs. Is there an easy way to similar but new layouts for every new job without creating a new field for every new criteria (some are one off things that we may never need again)? We would also need to be able to archive these searchlists so a year later we can open up to check whether that location allowed stunts or whatever.
All suggestions are greatly appreciated.