I'm trying to set up a reservation for cars in my agency. I would like to try to auto-assign these cars based on what is entered from another screen. Once I find an available car, based on that criteria, I want to mark it as reserved (will be based on date needed). Is there a way to auto assign from one SharePoint list to another? I'm still pretty new to SharePoint and I'm thinking that this might be above and beyond the scope of this application. Any help would be greatly appreciated. Thanks!
Here's how I envision what you're talking about: Two lists - one for the cars, the other for the calendar. CarAssign (or whatever variable you've got for the field in the CARS list) is a drop down choice field (yes/no). Each criteria is also a drop down list with the choice options located therein. The calendar (list) refers to the car list. The workflow would be set up along the lines of "If Criteria A = Whatever, and Criteria B = Whatever (...etc), set CarAssign = YES." Setting workflow conditions may be tedious here, depending on how many variables you're working with, but if you "map out" everything right, you should be successful. Have the workflow activate each time a new record is created (in the calendar list...that's where the reservations are, right?) Another thing to consider here is using views to your advantage. Mind you, it may feel a bit "clunky", but if it works for you, then it's a plus. You could set custom views for each of the vehicle types (set view filters based on each car type's variable definitions). Perhaps using this in tandem with a good workflow will get you where you want to go.