Hi all;
I am currently in the process of designing an AirBNB-like booking system for a company that leases multiple rental units. I have designed an interface where potential tenants can review the units they can choose from, however I'm running into a snag when it comes to being able to allow them to select their desired move-in and move-out dates (interfaces won't allow for filtering by date fields, apparently) to result in showing them properties that would be available during those times. I have read about using scripting to make this happen but have not been able to develop a script/formula combination that works, and the company doesn't want the responsibility of having to approve booking requests based on a manual check of whether or not that unit is available.
Does anyone have guidance on how I can accomplish this? At this point I don't even know where to start as far as experimenting or testing to see what the best option would be, and most of the solutions I've found here in the community and in the script marketplace will accomplish this but will only do so internally (ie: from the script box) and I need tenants to be able to do so on their end.
Hopefully this makes sense - thanks in advance!