thank you for your comment
The user will select:
- from and to dates
- how many adults
- if there is children
after clicking search. the result will appear in neat way (if possible like showing the hotel name, pic, prices, ...) and user select the item s/he find suitable. after that, a request with data selected is sent to related department to proceed.
I have a ready list with all cities and hotels room and prices.
For a project where the user would like to select a previous document and copy its metadata into the new document, I used something similar:
An other option to consider is to create a web part page with filters connected to a Content Query/Content Search Web Part.
but that makes it quite complex, since no nintex control supports filtering by multiple criteria.
but it will need little redesign of your Hotels list - each filtering criteria must be lookup field.
so you will need to create following lists
- list of cities
- list of proper/suitable date categories/ranges, like winter season, summer season, etc
- list of possible adult options (1..N)
- list of children options (eg. yes/no or number of children)
then as I said you need to make City column in Hotels list to be lookup to list of Cities, date from/to lookup to list of date categories, adult lookup to adult options, etc.
finally, you have to build a cascade in form so the user step by step select single criterias (city, date category, adults...). at the you will list of hotels that meets selected criterias and which user can choose from.
unfortunatelly, you will not be able to get some pretty formatted table of all the possible hotels with thier descriptions, pictures...
the most you can achieve I can think of is that you define some URL for each hotel in Hotels list and once an user chooses some hotels show it on the form.