Smart Software For Maverick Entrepreneurs

By: CreatorScripts | January 04, 2016

There are several ways to accomplish this task.

One is to enable the printing settings directly in your html page as its shown on this solution below. The other is to place the URL´s as linked text


a. To print the view, place a linked text in the format given below:

<a href="http://creatorexport.zoho.com/appOwnerName/appLinkName/print/viewLinkName"> Print </a>

b. To export the view in CSV format, place a linked text in the format given below:

<a href="http://creatorexport.zoho.com/appOwnerName/appLinkName/csv/viewLinkName"> CSV Export </a>

Refer to http://help.creator.zoho.com/Functionality-based-URLs.html learn more the URL patterns.


By: FMRR | December 28, 2015

Scheduler is a powerful feature in Zoho Creator that allows the application owner to create timed actions without any user input. These timed actions can be executed periodically based on the date and time values present in your form or on fixed date and time.


Zoho Creator supports three types of schedules. Form, Report & Custom. For birthdate reminders you need to use Form. Form schedules are events that are scheduled based on a date/time field in your form. (i.e) you will be able to specify a field in the form, whose value will be taken as the scheduling due date (or as start date and end date) in case of schedules with repeats like 'monthly' or 'yearly'.


By: FMRR | November 03, 2015

list  LogHistory_Report
{
    displayname = "LogHistory Report"
    show  all  rows  from  LogHistory [(Added_Time < '10-Nov-2015' && Added_Time > '01-Jun-2015')]
    (
        Added_Time as "Added Time"
        Added_User as "Added User"
        Activity
        (
            width = 250px
        )
        Modified_Time as "Modified Time"
        Modified_User as "Modified User"
    )
}

Category: Zoho Creator 

Tags: How To Videos 

By: CreatorScripts | October 26, 2015

Write the following code within the on add -> on validate block of the Script tab. In the following deluge code, the value of the field PatientID is calculated based on the form values specified for the First_Name and Last_Name and the value returned by the variable zoho.currenttime.

on add
{
on validate
{
input.PatientID = input.First_Name + " " + input.Last_Name + " " + zoho.currenttime;
}
}

Write the following code within the on edit -> on validate block of the Script tab. In the following deluge code, the value of the field PatientID is calculated based on the form values specified for the First_Name and Last_Name and the value returned by the variable zoho.currenttime.

on  edit
  {
  on validate
  {
  input.PatientID = inp...

Category: Zoho Creator 

Tags: How To Videos 

By: CreatorScripts | October 09, 2015

You can manipulate a date field by using the + (to add) and - (to subtract) Operators or by using the Built-in date functions. For example, if you would like to add 364 days to a particular date field, say StartDate and display it in another field, define a formula field named ExpiryDate with expression (StartDate + "52W:0D:0H:0M:0S") or by using the addDay built-in date function, 

For example,

form Sample
{

StartDate
(
type = date
)


ExpiryDate
(
type = formula
value = 
(StartDate + "52W:0D:0H:0M:0S")
)
}

Category: Zoho Creator 

Tags: How To Videos 

next>>