Help with Deluge scripts in Zoho Creator
- or -
Post a project like this1539
£60(approx. $75)
- Posted:
- Proposals: 4
- Remote
- #2689263
- Awarded
Description
Experience Level: Intermediate
I need some help creating Deluge scripts for a course management application I am building for our charitable organisation.
The first task is as follows:
I have several tables/forms. This task involves Courses and a related table for Course Dates. Each course has multiple dates.
I want to be able to set the Status of each course based on current date and the dates set in the array associated with each course as follows
- to check the first date in the array, if first date in the array is greater than current date, set Course Status to Upcoming
- if the current date is between the range of the 1st date and last date in the array, set Status to Active
- if the current date is greater than the last date in the array, Set Status to Completed.
- set this script to run daily in the morning
This script will be scheduled to run daily at 8am.
I already have a basic script running like this
for each rec in Courses
{
if(rec.Date_field >= zoho.currentdate)
{
rec.Active_Not_Active="Active";
}
else
{
rec.Active_Not_Active="Inactive";
}
}
However, this means I have two date fields in the Courses form/table which isn't ideal. I would rather put all the dates into the related dates array/list and use that.
With thanks
Regards
Phil
The first task is as follows:
I have several tables/forms. This task involves Courses and a related table for Course Dates. Each course has multiple dates.
I want to be able to set the Status of each course based on current date and the dates set in the array associated with each course as follows
- to check the first date in the array, if first date in the array is greater than current date, set Course Status to Upcoming
- if the current date is between the range of the 1st date and last date in the array, set Status to Active
- if the current date is greater than the last date in the array, Set Status to Completed.
- set this script to run daily in the morning
This script will be scheduled to run daily at 8am.
I already have a basic script running like this
for each rec in Courses
{
if(rec.Date_field >= zoho.currentdate)
{
rec.Active_Not_Active="Active";
}
else
{
rec.Active_Not_Active="Inactive";
}
}
However, this means I have two date fields in the Courses form/table which isn't ideal. I would rather put all the dates into the related dates array/list and use that.
With thanks
Regards
Phil
Phil E.
100% (12)Projects Completed
15
Freelancers worked with
8
Projects awarded
58%
Last project
29 Apr 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies