Hello, this is my first post. I am looking for a solution that would allow my company to book rooms in properties that we own. The input for the booking form or sheet would be Employee Name, Company, Job #, Check-in Date , and expected Check-out date. This would allow us to manage what employees, companies, and job #'s are staying at which properties.
Another feature would be allowing for the reservation record to be able to be modified, e.g. the employee check in earlier or later and either did not stay as long as originally anticipated or stayed longer than anticipated.
There are very frequent instances where the employee's stay would span several job #'s, meaning that they could stay in the property for several weeks and they would have multiple job #'s that they would need to book under. Assuming we would have to enter a record for each job#?
For billing, I need to report or view that our AP department could enter a specific date rate, e.g. payroll period, and it would pull all data associated to records that stayed at properties during that time frame, e.g. Employee Name, Company, and Job #.
Thank you all in advance for any and all help. Hopefully this is not too complicated but I am newer to Smartsheet and learning lots.
