I need a calendar report developed in SharePoint 365.
The database is currently in Access 2016 hosted on sharepoint.com, but with the backend SQL database on Azure (ie: *.database.windows.net). I've exposed this to the main Sharepoint site using BCS / ECT.
What we need now is to create a sharepoint page with a calendar web part and detail table that displays a customer's upcoming bookings. We want to give a URL to each customer that allows them to see their upcoming bookings. This URL must contain a unique non-sequential identifier (such as a GUID) that ensures that they cannot see any other customer's information, or any other part of the sharepoint site.
* The page must not require the customer to login.
* There must be no links to any other part of the site.
* They must not be able to see any other data by chopping parts off the end of the URL.
* They must not be able to see any other data by incrementing the identifying number in their URL.
For example, the URL should look roughly like one of these URLs:
(Don't click these links, they're just examples of what the URL should look like)
Another alternative may be to share a page using anonymous guest links:
Because this is a particularly tricky requirement, I am only interested in talking to sharepoint developers who have faced and solved this problem in the past. Ideally, I'd like to see a link such as the above, for a similar project completed already.
In future we will also need a system to send out SMS & email booking reminders and a range of other additions.