Zoho Creator charting functionality helps you to quickly and easily analyze data in a visual format using a variety of graph types. To create charts with data from multiple ZC forms or to display grouped data, you can use the chart API supported by Zoho Sheet. The  Sample Application named "Student Management" demonstrates this functionality. In this application, we have defined a function called "getChartUrl" (you can see the function used in the application under the Script -> Functions tab in edit mode), using which the required data is dynamically submitted  to Zoho Sheet API, which creates the required chart as an image.


About the application

The Student Management application comprises of the following forms :

  • Student Form to enter the name of the students and the country they belong to.
  • Course Form to enter the name of the courses offered.
  • Student Course Form to enter the course details enrolled by each student. 

The Country Chart view  displays a 3D Bar Chart which depicts the total number of students enrolled in each course for the selected country, as shown in the image below.  The bar chart is created by passing the required data as parameters to the Zoho Sheet chart API.

To learn about the steps in creating a chart in Zoho Creator using the Zoho Sheet API, refer this Wiki Page.
Creating charts using Zoho Sheet API

Editing Records In Zoho Creator

Apr 16 2009 05:52:34 AM Posted By : Latha
Comments (0)
Zoho Creator supports multiple ways of editing your data.  You can,
  • Edit records from GUI
  • Edit records through Deluge script
  • Edit records by passing record id in the URL
  • Edit records through Zoho Creator APIs
Edit Records from GUI

You can edit records directly from the Zoho Creator GUI, by selecting the desired record in the view and using the Edit option, to edit the specific record. You can also edit multiple records at a time, using the Bulk Edit option.

 
 
Edit Records through Deluge Scripting

You can Fetch and Update records dynamically from Zoho Creator Database using Deluge Scripting. The Fetch record and Update record Deluge task
offers the flexibility to fetch records from the ZC database based on a given criteria and update it with the given values or with dynamic values and is triggered by form and field actions.

Edit Records by passing record id in the URL

Zoho Creator generates a unique ID for every record that is added to the database. The ID can be displayed in your view by selecting the "ID" field from the "Column Properties" of the View, in Edit mode. The record-edit feature supports to edit individual records via its record ID, by displaying the form with the record details. This makes it easy for users to edit records without having to display the view, navigate to the desired record and then requesting to Edit it.  Refer Editing Records via Record ID for more information.


Edit Records through Zoho Creator APIs

Zoho Creator APIs allow client applications to programatically edit records in a Zoho Creator application. You can use the following methods to edit your records.

Update Record using Rest API - Post method
Update Record using Rest API - Get method
Update Record using XML RPC
Update Record using CSV RPC