This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
can you please help in designing a logic for the below requirement?
I have attached document of process flow.
can you please help me in getting this done.
Below are the details:
Application Description:
Doctor Booking - Application to reserve a time slot for consulting with visiting physio-therapist. Consulting with a specialist who specializes for these kinds of the musculoskeletal system can prove very beneficial for the pain relief. Now employees can book your consultation online.
Doctor will be visiting every Wednesday from 4:30pm to 6:30pm. This work flow logic should help you to book the consultation with the doctors with the availability.
NOTE : One employee can book only one slot per week . Each slot is allocated for 20 mins only
Classification:
BU : HR
Login Type : Domain/userID
Host : https://xxx.yy.zz.com
URL : https://xxx.yy.zz.com /cgi-bin/facilities/Doctor_Booking/Login.cgi
Process Owner :
Process Flow description:
There are 2 modules in Doctor Booking:
User Module:
Only Particular GROUP of IDS can log in to book their appointment with Doctor
Doctor Appointment: Select a date and click on the time slot to book appointment
Admin module:
Admin can generate Doctor appointment report and enable Wellness program registration window
Application Tier : 3
Data classification [CIP]: Non-Confidential
Does application contain Intellectual Property Data? No
Is application Critical to financial reporting? No
Is application Critical to Manufacturing/Shipping? No
Is this application a Security/Authentication/Authorization Service? No
Does application retain Personal Data regarding users? No
Does this application contain Legal Data? No
Does this application service TI customers, suppliers or distributors from the internet? No
Is this application subject to SOX audit reviews? No
Data Fields:
DOCTOR VISIT TIME MASTER WELLNESS PROGRAM USER DETAILS
time id book id
time slot booked by
blocked date
DOCTOR VISIT USERBOOK blocked slot
user book id action
user booked by remarks
user blocked date updated on
booked slot consultation type
action
remarks
I have attached flow diagram. Please help.
Process Flow Diagram:
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 7.000000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
User can add event in the calendat list like this.
In list settings-> validation settings, you could set up the limitation with this formula:
=AND(WEEKDAY([Start Time])=4,INT(([End Time]-[Start Time])*1440)=20)
You could enable content approve for the calendar list in list settings-> version settings. So admins could reject the submit from users if they book more than once in a week.
Hi Michael Han,
I don't see "approval status" coloumn in the validation settings. Please help
also before adding event itself by user, do we need to enable content approval from validation settings?
You don't have to use "approval status" coloumn in the validation settings. And the "approve status" column is created after you enable content approval in versioning settings instead of validation settings.
With content approval enabled, Admins could approve/reject users' submit. You could refer to this article for more: require-approval-of-items-in-a-list-or-library
Hi Michael Han,
I tried to create one more event in same week and other week also but not able to create coming up with below TEST message after clicking on save. what could be the problem?
and I am doing as user with contribute access, not using admin account here while submitting the event.
so If I clear error my self I can address the user.
and I have not enabled content approval yet from version settings yet.
and more question here admin is doctor & users are submitters. Am I correct?
This is because the validation:
=AND(WEEKDAY([Start Time])=4,INT(([End Time]-[Start Time])*1440)=20)
This means you must choose a date in Wednesday, and the End time-Start time must equal 20 minutes.
Hi Michael Han,
Thank you.
it worked when I added event as submitter that with less than 20 minutes when chosen Wednesday.
and can you clarify this one also as per my requirement mentioned in first thread
submitter -->all users
Admin-->doctor , am I correct?
and now I have submitted with normal account, how do I approve as admin? where to check?
Hi @sns ,
Admins need to have at least approve permissions to approve/reject the event. You can give doctor approve permission to make him admin.
To approve as admin, you need to enable content approval as I mentioned befoe. Then admin could approve the event in the ribbon, click the event, choose approve/reject. Like this:
Hi Michael Han,
Thank you.
I enabled content approval from version settings. then it is showing approve/reject option on ribbon. that is fine. Thank you.
while submitting the event by user ( who has contribute access) is able to approve/reject option along with admin? how it is possible for end user with contribute access?
we don't want to see approve/reject option on ribbon for users, correct? what we do for that?
and one more question do I need to give doctor full control access to make to as admin?
and once approves how do users know that it is approved?
and apart from this question, I have one more issue, raised a ticket for that, below is the link. Please help on below one also. Thank you.
https://video2.skills-academy.com/en-us/answers/questions/85120/wfissue-on-sp-list.html
Hi @sns ,
I don't think workflow would achieve your requirements. Have you thought of the calendar list in SharePoint? It will be a good choice for you.
Users could add a event in the calendar list to book the appointment. You could use some validations to limit the date can only be selected in Wednesday from 4:30pm to 6:30pm.
For admins, they could click export to Excel to generate the report.
If the response is helpful, please click "Accept Answer" and upvote it.
HI Michael Han,
Thank you for the response.
can you give details with some example on calendar list?
and also how to set up limitations?
How we can set up below note?
NOTE : One employee can book only one slot per week . Each slot is allocated for 20 mins only
and do we have nothing to do with data fields if it is calendar list?
Don't worry, the approve/reject option would be grey out for end user with contribute access. Only admins can click the approve/reject option. We cannot hide it.
Give doctor approve permission level will be enough, you don't have to give doctor full control access.
You could use alert me feature to send email to users. Or you could create a workflow to alert the user.
Hi Michael Han,
Thank you.
yes. users are not able to see.
but with out setting alert are users able to see from event in the calendar it self, whether it is approved or not?
and can you help on below ticket?
https://video2.skills-academy.com/en-us/answers/questions/85120/wfissue-on-sp-list.html
You could click view events, check the approval status column.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Michael Han,
Thank you
.
Yes I have already subscribed for email notifications.
can you please have look in to below one also?
https://video2.skills-academy.com/en-us/answers/questions/85120/wfissue-on-sp-list.html
For your new issue, our engineer will help you later on that.