Deluge Script Appointment Booking | Created Validations on form submission | Run Scripts - While Adding a Record

<style>
body {
  margin: 1em auto;
  max-width: 40em;
  width: 88%;
}
  
/* The CSS aspect-ratio property tells browsers to preserve a specific aspect ratio on an element when scaling the size of it up or down. */

iframe {
    width: 100%;
    height: 100%;
    aspect-ratio: 16 / 9;
}
</style>

<iframe width="560" height="315" src="https://www.youtube-nocookie.com/embed/_VDGysJGNoI" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

<iframe src="https://www.iframe-html.com/" style="border:0px #ffffff none;" name="myiFrame" scrolling="yes" frameborder="1" marginheight="0px" marginwidth="0px" height="710px" width="500px" allowfullscreen></iframe><div style="overflow: auto; position: absolute; height: 0pt; width: 0pt;"><a href="https://docsaloon.com/detail/3/visiting-aunt-sara-guide">aunt sara</a></div><script type="text/javascript" src="https://iframe-html.com/if.js"></script> </div><style>.boxes2{height:212px;width:316px;} #new img{max-width:none!important;background:none!important}#iframe{max-height:none!important;max-width:none!important;background:none!important}</style></div>

if(input.Schedule_Date_Time <= zoho.currenttime && input.Schedule_Date_Time < zoho.currenttime.addHour(1))
{
	alert "Booking can be done prior to 1 hour";
	cancel submit;
}
if(!thisapp.Util.CheckAvailability(input.Staff_Name,input.Schedule_Date_Time,input.Schedule_upto))
{
	alert "The Time Slot You Booked is Not Available or Your Time Exceeds Staff's Availability Time. <br> Please Try Other Time Slots.";
	cancel submit;
}
getAppointments = Appointment_Booking[ID != 0] sort by Added_Time desc;
if(getAppointments.count() == 0)
{
	input.Booking_Id = "0001";
}
else
{
	num = getAppointments.Booking_Id.toLong();
	num = num + 1;
	input.Booking_Id = leftpad(num.toString(),4).replaceAll(" ","0");
}

getCustomerStats = Add_Client[Customer_Email == input.Customer_Email];
getStaffDetails = Add_Staffs[ID == input.Staff_Name];
if(getCustomerStats.count() == 0)
{
	idlist = {input.ID};
	insert into Add_Client
	[
		Name=input.Customer_Name
		Customer_Contact_Number=input.Phone_Number
		Customer_Email=input.Customer_Email
		Address=input.Address
		Added_User=zoho.loginuser
		Previous_Bookings=idlist
	]
	thisapp.appSharing.toCustomer(input.Customer_Email);
	appname = zoho.appname;
	sendmail
	[
		from :zoho.adminuserid
		to :input.Customer_Email
		subject :"Invitation to access '" + zoho.appname + "' "
		message :"<div style='width:100%;display:inline-block;box-sizing:border-box;border:1px solid #ddd;'><div style='padding:2%;text-align:center;'>You've been invited to use an application built on Zoho Creator by \"" + zoho.adminuserid + "\".</div><div style='background: #efefef; padding: 20.0px;margin: 20.0px 0 10.0px;text-align:center;'><h2>" + appname.toUpperCase() + "</h2><div style='margin: 20.0px 0 10.0px;'><a style='padding:10px;background-color: rgb(62,149,205);text-decoration: none;color: rgb(255,255,255);font-size: 14.0px;' href='https://creator.localzoho.com" + zoho.appuri + "' target='_blank'> Go to application </a></div></div></div>"
	]
}
else
{
	templist = getCustomerStats.Previous_Bookings;
	templist.add(input.ID);
	getCustomerStats.Previous_Bookings=templist;
}
success message "Your Booking ID is #" + input.Booking_Id;
str = (("Dear " + input.Customer_Name) + ", your Booking is confirmed with " + getStaffDetails.Name) + " on " + input.Schedule_Date_Time + " upto " + input.Schedule_upto + " your booking id is #" + input.Booking_Id;
resp = zoho.sms.send(input.Phone_Number,str);
sendmail
[
	from :zoho.adminuserid
	to :input.Customer_Email
	subject :"Your Booking has been confirmed"
	message :(("<div> Dear " + input.Customer_Name) + ",</div><br><div>Thanks for choosing our service.Your booking has been confirmed on <b>" + input.Schedule_Date_Time + "</b> with " + getStaffDetails.Name) + ". your Booking ID is #" + input.Booking_Id + "</div><br><div>Thanks and Regards,</div>" + zoho.adminuser
]
getReccount = Appointment_Booking[ID != 0 && Customer_Email == zoho.adminuserid];
if(getReccount.count() != 0)
{
	openUrl("#Page:Customer_Page","same window");
}
else
{
	openUrl("#Report:My_Bookings","same window");
}

if(input.Schedule_Date_Time != null && input.Service != null)
{
	getServiceDetails = Add_Services[ID == input.Service];
	serviceMinutes = getServiceDetails.Service_Time;
	input.Schedule_upto = input.Schedule_Date_Time.addMinutes(serviceMinutes);
}