I have a form created for individual freelance employees with a related form tracking their availabilities. For example, the employee might not be available for a certain date range, and then be available for another date range. In addition, the employee has certain software skills that I've got in a Multi-select field.
What I'm trying to do is to create a simpler way to get employees matching certain criteria including the software multi-select and the availability.
I have another form that allows one to select some required criteria - required dates the employee be available and required software skills and I want it to have a custom action that opens a report with the records that have the criteria fulfilled.
My problems occur because the URL functionality of Multi-select doesn't allow me to have "CONTAINS" with multiple selections. For example, if I require that the employee know Excel and Word, setting up the URL with Software=Excel&Software=Word&Software_op=26 doesn't work, nor does any other combination I can figure out.
I've also tried filtering the records into a list within a function, but then I don't know how to just show those list items in a report. Any ideas?