How to overcome ZohoCreator’s record count limitation?


More and more businesses are warming up to Zoho Creator, and developing apps in all sizes. These apps could be as small with only 3 forms and 5 reports, or as large with 20+ forms and 60+ reports, as the business demands.
Thanks to subforms, we are able to create related lists against the parent record with just a few drag and drops. This gives a unified approach to collect and see the data, without having to switch through multiple screens and reports.
However, subforms tend to pose a different set of problem. At the cost of easing data management, it adds total to the record count on your zoho creator user account. Let me exemplify.

Use Case : Candidate Details, with supporting documents for the following

  • Collect Basic Details ( Name | Phone| Email)
  • Collect Address Details (Present address | Permanent address)
  • Collect Education Details (Degree | Course | Year)
  • Collect Employment Details (Employer | Designation | Duration)

That said, the simplest of ZCreator data form will most likely look like this

(Click to zoom in the picture) I know, it is hazy, but then.. you get the idea..don’t you?

Let us talk “Record count”

Main Form : Candidate ( Counts as 1 record)
Subforms : Address , Education, Employment
Assuming there are 3 rows of data, for each subform, we end up with a total of 9 + 1 = 10 records for each Candidiate entered into the system
Makes sense ??… Well, let us see some sample records

One candidate accounts for 10-15 records on an average.

How does Record count matter ?

Each Zoho Creator subscription is entitled to a certain volume of records.

For business that deal with 100’s of records (candidates) on a daily basis, the total record count could rise exponentially within matter of hours. And, hit the record-limitation resulting in business operations to a grinding halt, until you purchase additional records as add-ons, or switch to premium version that allows unlimited records – Price and Feature comparision sheet here
Another option would be to delete past records, to allow space for new incoming records. But not all businesses can afford to purge “past data”. Eg, Legal firms tend to keep past data as late as 5-7 years.

How to overcome ZCreator’s record count limitation? Collate and export

Let us use a combination of services. Demo here illustrates the final outcome

Click here to view the Screencast
(Merge and tuck away)

  
Unable to display content. Adobe Flash is required.

Objective :

  1. To archive Form data (Main form and Subforms ) into a standard format ( Eg : Word / Excel) .. in our case we will use Excel.
  2. To move all supporting documents (All File_upload_fields in Zcreator forms) into a document repository, for keep-safe-for-later
  3. Delete records from our ZCreator application

This will not only free up record count, but will also move redundant data out of the system.

Prerequisites :

  1. Zoho Creator – Deluge script level – Advanced
  2. Valid Webmerge Account
    1. API key and secret
    2. Valid Excel template to merge form data
    3. Know-how of Webmerge API
  3. Valid ZohoDocs Account
    1. Zohodocs authtoken
    2. Know-how of Zohodocs API

The Workflow

  • All form data (Fields) are passed on to the Webmerge template to create a merged document
  • This merged document is manually downloaded ( for verification)
  • Archiving ZCreator record is initated
  • Archiving of data and attachment is reconfirmed, along with uploading the merged document.
  • Data and attachments are archived into designated folder at ZohoDocs

To those who matter :

Each file archived into ZDocs involves 2 ZohoDocAPI calls.

User Request : Doing a Self-Lookup, that references record from the same form

James wanted to know:
How do I add a look-up field on a form that references records from the same form (i.e., in the same table).E.g., I have a form called Case and I wish to relate a specific Case to another Case in the same table so that I know they are related.Another example is that I have a People form and I wish to show that a person is related to another Person with a parent/child relationship.
So, here we go ……
Response:

  • We cannot use Lookup-field to reference data on the same form.

There is a workaround, and we will be using that instead.
Working DEMO here.

THE FORM

  1. Instead of a “Lookup field”, we will be using s a regular “Drop down field”
  2. Leave the default list-options as they are, we will not be using them
  3. Instead, we will be adding the “self-lookup-values” at run-time

THE CODE

  1. Using the “Aggregate Records” function, we will collect distinct values into a “list-variable”
  2. We now add these to the drop-down field


Hope this clarifies. Do let me know if you require additional assistance.

Zoho Creator User Request: Filter list values, based on user selection @ web form

ZohoCreatorAnurag has requested the following

I need a form to fetch filter data from spreadsheet
as per web user options
entered in that form embedded in website.
That’s if he chooses sex: female, experience: 2 years,
then he should get names of those person accordingly from Google/zoho spreadsheet/view.
I have no technical experience, so kindly show by giving simple example.

Response:

This is very similar to Unique list values, dynamic pick lists & dependent list values.

However, here is a working demo for the regular people (read:non-geeky people)

The SELECT CANDIDATES form shows the list of candidates based on Experience & Sex prefrence of the user, at the form.

Logic :

  1. CANDIDATES FORM (associated data: CANDIDATE VIEW)
    1. Collects details for new candidates
    2. The data collected using this form, is used to filter and display the records
    3. Data can be added directly added (Bulk upload) to the view , via, Import Data option
    4. SELECT CANDIDATES FORM (associated data: SELECT CANDIDATE VIEW)
      1. We will use this form, to selectively display the candidate names
      2. This can be a regular / stateless form

Study the code at : SELECT CANDIDATE FORM

  1. Male / Female preference is set by default, to avoid null error.
  2. Experience list > Hardcoded to the form
    • Coz, the candidates form uses multiselect list
    • If your parent form uses a single line / single select list, you can pupulate this link dynamically too.
  3. Experience > User input > populates candidates list
  4. Candidates > user Input > dynamically writes and displays the skills of chosen candidate.

Hope this answers your query,
Please feel to let me know if anything is amiss.

Recognition from Zoho Creator Team – Thank you!

Let me thank my stars! Things cannot get any better than this.

Following oDesk’s provider spotlight, Zoho Creator has extended their regards and best wishes. Here is a short transcript of my interview with the zoho creator team.

Why did you choose to use Zoho Creator?

The drag and drop interface at form-design and at Deluge script won me hands-down. Additionally, the logic command blocks at Deluge Script , along with the help documents were very helpful in the initial stages. I sort of kicked-the-tires by developing some applications for personal use. ….

How do you pitch Zoho Creator to your customers? Has it been an easy sell?

In fact, I didn’t have to pitch it at all. Zoho Creator already did it for me! Anyone who has spent at least 30 minutes with Zoho Creator forms & the basic ‘Send Mail ‘ script will be able to comprehend what this could do to their business. So I was fortunate to have well informed clients who had tested Zoho Creator hands on. It has been my observation that, out of every 10 casual signups, at least 8 are willing to harness the developer pool for a decent remuneration. That’s 80% conversion rate, guys!

For Full transcript – See here

Zoho Creator Tutorial – Remove Special Characters from String (Validation)

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms | Unique values in List | HTML views |
We all know that Telephone / Zip codes are NUMBERS isnt it (Genius eh!). But, when we typically use the Number-field type in the Zoho form, the end user tends to enter something like this

But, as the Form Field is of Number type, the system fails to recognize the special characters ( parenthesis (), – hyphen etc) and understands the value to be Null
ie, According to the system, an number field which does not exclusively contain numerals are invalid — Well, thats how its supposed to be isnt it?. okay, the what happens with INVALID DATA ? .. ofcourse it gets rejected ( Again, a No Brainer.. isnt it?)
Well then, how to make sure irrespective of whatever format the user enters, the data gets added on to the system in the right format? For this, we can use a combination of field types & Custom Actions.
SCENARIO :- ALLOW USER TO ENTER THE TELEPHONE NUMBER IN WHATEVER FORMAT HE WISHES TO ENTER
GOAL :- CONVERT THE ENTERED TEXT INTO AN ALL NUMERALS ONLY FORMAT
Demo Here

Lets design the Form ( 2.jpeg)


Lets write a custom action to get this going

Now, lets call this function inside the form
For me, this is the sequence

Once, this is done,
Go to the Live Mode & Validate
Your appreciation is my motivation
What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms | Unique values in List | HTML views |

Zoho Creator Tutorial – Custom Dashboard using HTML views

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms | Unique values in List |

We have been experimenting with forms & views in zoho creator. Now you must have quite a few forms & views which when put together make a fine application. Did you know that you can create custom dashboards using HTML views in Zoho Creator?

HTML views are nothing but blank HTML pages into which you can insert your form’s field variables. So they make excellent dashboards, presenting dynamic reports based on user selected criteria, so on and so forth.

To give you a peek into which what HTML views are capable of doing, take a look at the demo. Eg:- you will be greeted with your username at zoho. This is achieved by using the <%zohologinuser%> tag. If you explore the fetch records & collection variables, you will be able to see the dynamic nature of these Html views.

View Demo here


The application, displays the dashboard by default. This is done by using the various options under the customise menu. Create a hidden section and place master views to hide them from display.

HTML views support all HTML tags. In the dashboard I have inserted images, and also included the HTML view from my private application. You can also insert forms / views directly using the Form- View snippet, or use the IFrame to embed permalink of your forms & views. I have a zoho creator form embedded in another html view called Request a Tutorial. ( Home tab – drop down)

The above form is located within my private application. I am using the “Embed without login” iframe snippet code to display in the html page. So, the data submitted will go to my private application & will not be available for all to see.

Next Week’s post – How to set up your custom bulk mail options using zoho creator Your appreciation is my motivation

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms | Unique values in List |

Zoho Creator Tutorial – Unique list values, dynamic pick lists & dependent list values

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms |
Now that you are exploring zoho creator yourself, you might have grasped more than what you bargained for. During this learning curve you may come across certain use-case scenarios & would like to see them work. Here is a working copy of one such request that visited my inbox.
UPDATE: Oct 2011
After the introduction of Aggregate Records, by ZC displaying unique list got even simpler.
Using the same example as below, lets display distinct list of countries using this option.

  1. Use a Dropdown field element in your form and name it – Distinct Country list
  2. In the Script section > Form > On Add > On Load
  3. Under Data Access> Aggregate Records > Drag and drop into the code builder
  4. Drag and drop “Add item” element into the code builder
  5. Select the drop down list element “Distinct Country list” — From Step 1
  6. Select the Countrylist-variable — from Step 4 (Aggregate record screenshot)
  7. Save script, and check in live mode if the distinct list is displayed in your form

The Assignment :-

  1. Registration form has Country & State fields.
  2. Both have to be pre-populated drop down fields ( ie… zero manual entry. User has to pick from list.
  3. >Based on the Country name, (Pre-populated list), the State Names ( of respective country) should be displayed in the second drop down.

Click here to View the Working demo ( Tab Name – LIST ACTIONS)

Forms & views Used –
Counry_states Form ( & view) – Single line field
Registration Form ( & view) – Single Line & Drop down

Registration Form Country – Sates (add new country & state list here)

Use Single line fields and Drop down fields to design the forms. Leave the default “Option1, Option2, Option3” in the drop down fields. We will be dealing with them shortly at Deluge script.
Donot use pick list/ lookup field
Question:-
What happens when you use a look-up field?
Answer:- It will show the country names as “n” occurances. Eg:- India, India, India, India, USA ,USA, USA, USA.
We don’t want that.. all we want the list to show is – “India”& “USA”
In other words, we want to avoid any duplicate entries in the drop down list.
Form:- Country_States
This form is used to “collect” the country name & state name. So there is absolutely no scripting involved. Do take a look at the Country States View in the DEMO link
Form:- Registration Form
You can have as many fields as you want. Since this is a tutorial post, I am limiting the fields to Name, Country & State
In the demo, you will notice that, “Country” does not have duplicates & “State” list changes dynamically based on the country name.
The Deluge Script involved.

On Registration Form — > > on Load.
//——–THIS POPULATES THE COUNTRY LIST WITH UNIQUE VALUES——–
Country_list = List();
Cntry = Country_states [(Country is not null)];
Country_list.addall(Cntry.Country.getall());
Country_unique = List();
for each country in Country_list
{
if (!Country_unique.contains(country))
{
Country_unique.add(country);
}
}
for each Ctry in Country_unique
{
County:ui.add(Ctry); //USE CLIENT FUNCTION — ADD ITEM
}
CODE YOU CAN FIND THIS AT THIS LINE OF CODE MEANS
Country_list = List(); LIST MANIPULATION (LM) – CREATE LIST
Cntry = Country_states [(Country is not null)]; DATA ACCESS – FETCH RECORDS collect the rows where state is not null in Country_States_view
Country_list.addall(Cntry.Country.getall()); LM- ADD ALL
Country_list=List(); LM – CREATE LIST
for each country in Country_list LM – FOR EACH ELEMENT
<expression> = country
if (!Country_unique.contains(country)) IF CONDITION You can otherwise Type —> country_unique.contains ( country) is false
Checks if the <expression> value is present ( true) or not ( false)
Country_unique.add(country); LM – ADD ITEM If false, then the value is added to the list — now, you have a unique list
for each Ctry in Country_unique LM – FOR EACH ELEMENT
<expression> = ctry
County:ui.add(Ctry); CLIENT FUNCTION – ADD ITEM Now, each list item is added to your drop down box
On Registration form – > Country Drop down – > User Input
//——THIS POPULATES THE ~~STATES~~ OF THE SELECTED COUNTRY———–
States_list = List();
States_rec = Country_states [Country == input.County];
States_list.addall(States_rec.State.getall());
for each State in States_list
{
State:ui.add(input.State);
}
CODE YOU CAN FIND THIS AT THIS LINE OF CODE MEANS
States_list = List(); LM – CREATE LIST
States_rec = Country_states [Country == input.County]; DATA ACCESS – FETCH RECORDS
States_list.addall(States_rec.State.getall()); LM – ADD ALL Exactly similar to Above pic – Enlarge and see. Be sure to get the state names & check the box for return field values as list
for each State in States_list LM – FOR EACH ELEMENT
<expression> = State
State:ui.add(input.State); CLIENT FUNCTION – ADD ITEM Select the state-drop down list — You will see this list getting popupated based on country name

UPDATE: Oct 2011
After the introduction of Aggregate Records, by ZC displaying unique list got even simpler.
If you found this post to be of some use, please spare a moment to drop a comment.
Your appreciation is my motivation
What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms |

Zoho Creator Tutorial – Stateless Forms ( Use multiple forms to update a single table)

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms |

With the basics in place, I guess, now its time for us to look into some of the advanced features that you can implement within Zoho Creator application.i.e you can come up with more customizations based on your requirements. This will be a combination of form’s design & a little more Deluge script that usual.

The Assignment :-
Application Name :- Event Management
Forms used :

  1. Master Form _Event Management (Stores data in Master View)
  2. Event Details Form (Stateless Form)
  3. Contact Details Form (Stateless Form)

Click to View Demo

This Event Management Application has the details of a particular event & the contact info of the person who is responsible for this event. I hope you would remember me saying in my earlier posts that, by default, Zoho Creator stores the data entered into the forms in tables, called as Views.

However, Zoho Creator has another set of forms called the Stateless Forms. i.e. the data entered within these forms, will not be saved. ( — what the heck! , what is the purpose of having a form that does not save data — , Hey! Friend, hold your horses. You will soon find out.)

As the name suggests, anything entered into the master form will be stored in its View. Stateless forms merely pulls the data from the master form & displays it for you to edit & confirm the edits. After doing the edits, when you go back to the main form’s View, you will notice that the edits have been implemented in the master-view as well. Sample Application here

The fields we will be using will be as follows
Master Form’s details
This is a regular form, Created the normal way. Forgot,see here

Event_Contact_ID*
Contact_Name – This is a required field
Contact_email
Contact_Phone
Event_Name – This is a required field
Event_Venue
Event_Date

Stateless Form (Stateless forms are those, whose data are not stored in Zoho Creator.)

It is a single choice that eventually decides if a form is stateless or not.

Form Fields :-

Event Details Form (Stateless Form)

Event_Contact_ID* — > This will be a look-up field.
Event_Name
Event_Venue
Event_Date

Contact Form (Stateless Form)

Event_Contact_ID –> This will be a look up field
Contact_Name
Contact_email
Contact_Phone

Using the look up field to “show data from other forms”

Remember to include the “SUBMIT” button in your stateless forms

The Tricky part – Deluge Scripting
Master form :-

The EventContact_ID* is the most important field, because, this links all the 3 forms in this application. Hence this has to be unique. We will be generating this UniqueID using deluge script.That means, the user is not allowed to enter anything in this field. Which in turn means, go back to your Master form – Edit the field for Event Contact ID , and say – Hide this field to others. ( of course, “you” will still see it).

Deluge Script to generate the Event Contact ID.

Master Details Form –> On Add –> On Success –> Set Variable

Don’t forget to save the script.

Now run your application & enter some data into the master form.
Go to Master view and cross verify if the data is getting saved along with the auto-generated “Event Contact ID”

Verify your “Lookup field” in “Event details form” & “Contact details form”.
If you had set up the look up field for “Event Contact ID” correctly (in the stateless forms), you should be able to see all od the Event Contact ID’s in this drop down list. Nothing will happen yet, just run both forms & see if the values are shown in live mode.

Deluge script to “Call the data” from the master view.

Up until now, you had been using the “Set Variable” in the script. Now, in order to “call the data”, we will be using “Fetch Records” feature. So what happens with this option. . .

You “Fetch Record – data “ from a certain View & Store it in a variable. This variable is now becomes a “Collection-variable” , (User Defined collection, to be more precise) ie .. Collection of data from field 1, field 2, field 3.. So on and so forth.


Question:- when to fetch the record – data ?
Answer :- After the user selects the value from the “look up field”
Stateless Form (Event Details / Contact Details forms ) —> EventContactID (Lookup field)– >On User Input –>Drag drop “Fetch Records”—>Edit



Now that you have “Fetched the record data”, its time to show them in the form. Use Set variable to achieve this.

input.EventName = RecData.EventName;
input.EventVenue = RecData.EventVenue;
input.EventDate = RecData.EventDate;

Repeat the same exersise at Contact Details form

Contact Details Form –> Event Contact ID (Lookup field)–>User input–>
RecData = MasterDetails_EventManagement [EventContact_ID == input.EventContact_ID];

input.ContactName = RecData.ContactName;
input.ContactPhone = RecData.ContactPhone;
input.Contactemail = RecData.Contactemail;

Deluge script to rewrite the entry in the master view ( table)

Now, you should be able to see relevant records in the stateless form based on the value from the Event Contact ID list. Next step would be to edit other details & Submit the (Stateless) form. This should inturn update the details in the master view.

Question:- when to update the record in master view
Answer :- After the submit button is clicked.

Deluge Script code will be :-

Stateless Form ( Event details / Contact details)–> Submit Button –> On Click

RecData = MasterDetails_EventManagement [EventContact_ID == input.EventContact_ID]; //Use Fetch Records , to call the record data

RecData.ContactName = input.ContactName; //For these, use Update Records
RecData.ContactPhone = input.ContactPhone;
RecData.Contactemail = input.Contactemail;
Reload;

Repeat the same excersie in Contact Details Form ( Stateless Form)

Submit Button –> OnClick

RecData = MasterDetails_EventManagement [EventContact_ID == input.EventContact_ID]; //Use Fetch Records , to call the record data
RecData.ContactName = input.ContactName; // use Update Records
RecData.ContactPhone = input.ContactPhone;
RecData.Contactemail = input.Contactemail;
Reload;

Run the application & let me know if you are able to update the master field from the stateless forms. Not happening.. Feel free to drop a word to me. We will figure it out together. Chao =;
Your appreciation is my motivation

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | Statless Forms |

Zoho Creator Tutorial – Part 5 Introducing Deluge Script

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | | Deluge Script – Basics

Now that you are familiar with the basics of zoho creator, lets dig our hands into their deluge scripting. During the time when we were working on my Visual Basic application & Java applets, each one of us would have our own way of locating a specific piece of code that we might want to use in our application.

However, with zoho creator’s deluge script, it doesn’t mater a even haven’t programmed anything beyond your TV for the various channels. Because, they have made programming as simple as drag and drop. How,..?. Read along.

Know where to write the code.

As of now, lets concentrate on the SCRIPT –> FORMS
As we move on to views & Functions, we will be looking at other tabs
You can use the drop down arrow to choose any form within your application.

As we developing our guest book, we will open the Guest Bool – FORM in the script tab. After this you should be seeing this

Here, the script does what it exactly says just there. For our application’s sake, let us Add code to AUTOMATICALLY ADD THE DATE within the date field , so that the users dont have to type / select the date. Further, it would also help to know who visited when.I have already added the code in FORM –> LOAD , which is why you see a green dot ín the above pic.

What to write / How to write ‘code’ ?
(A) You might want to say “When the form loads”

— Translated, you will have to write the code on Form –> On Add –> On Load.
— If you clicked in the same order, you should be seeing this. Use the prev image and the one below to locate

(B) You might want to say “ Add todays date automatically ”
— Translating , this would mean something like this
i.Set the Date-Field
ii.To Todays Date

— So you should be doing this

  1. Scroll down a bit and locate the SET VARIABLE. ( Use the image below for guidance
  2. Drag and drop it on to the coding area.
  3. As soon as you drop it, & if you hover the mouse, you should be seeing an EDIT &
  4. DELETE button.

(C).How to set the value for the date field. ?
As soon as you click on Edit, you will be presented with a dialog box
Notice that the declare variable is a drop down variable. – From this select the Date field

As for the actual value , we will be using a variable called the ZOHO – currentdate It is as simple as saying x = 5. You will be telling your application that every time the form loads, just give the current date’s value to my date field. For this, you will have to
1. Select the ZOHO VARIABLES ( Tab)
2. Scroll down a bit .. until you locate the zoho.current date.
3. Click DONE – & you will see this

Wait !!! — The code is not saved yet, It is only generated – So you will have to scroll down and click SAVE SCRIPT at the right bottom corner You will see a green band that says, Script modified.
Now you are ready to go.

Access your application – psst !! … Use the Acess thisApplication Link at the top.
Do you see the date automatically coming up in the date field … ? Great .. You have successfully Coded your application

Now, I have a practice assignment for you. After the form loads & zoho’s current date is performed, disable the date field.
Now that every step has been demonstrated with screen shots, I shall be providing only guidelines. You will have to look for them in the order specified. It is just that…I am feeling lazy to do the screen shots again ..

How to do this ?: –
Form –> On Load –> Drag and drop –> Disable field –> Select Disable – option –> select date field –> Done
Save Script

How to check this ? –> Acess the application — > You should not be able to change the date manually.

Your appreciation is my motivation

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields | | Deluge Script – Basics

Zoho Creator Tutorial – Part 4 ( premade Form Fields , Zoho Creator does the validation for you)

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields |

If you had been following this tutorial closely, you should be able to perform the following based on last week’s post,

  1. Create a new form
  2. You should be able to design your form.
  3. Add fields that are relevant to you.
  4. Rename the fields for display and scripting
  5. Embed the form within the blog website ( Hint : -Form’s Live mode – More ction – Embed in website – Access without login – Get code – paste in your blog )

I guess you would also remember me telling that Zoho Creator has provided with ready to use fields based on their data types.

Field types Can be used for They are all so self explanatory, I am just listing them here.
Single line Names , one liners up to around 300 characters.
Multiline As the name suggests, can be used to get “paragraph” type info from your readers / clients.
Email Eveything is automatically validated. Incorrect entries will not be accepted by the system. Take it from me, this kind of validation used to be a grind, but not

anymore

Url
123 Number
0.1 Decimal
% Percent
$ Currency Set the currency type ( USD / INR / YEN.. etc. Pick the one that suits you)
Drop Down Here you can give a custom set of values of your choice.
Radio / Option buttons You can provide any number of options, but only one will be selectable by the user
Eg: Male / Female
Check box This comes handy when you have multiple options & the use also need to select more than one from what you have provided
EG : A Person can like Red , Blue & Green
Multi Select This is more like a list box, from where the person can click and select
You can choose to display the list sorted out in alphabetical order
Date
Date – Time Gives you a timestap along with the date
Look up ( also called as Pick List) This allows you to call data from one form into another form. (We will be dealing with this shortly.)
Formula This computes values for you based on the values on other fields.
Eg: Formula will do MathScore + ScienceScore , where in MathScore & ScienceScore are numeric fields .
All you have to do is give the fieldnames & + operator Advaced computations are made easy by the formula fields
Image You can actually collect images without the fear of overloading your inbox. You can as for the URL / Alternate Text / Source etc all using the zoho creator form.

Plus you also know who submitted what and when .. if you would add the date & Name field to such a form

File Upload This can be used to gather any file type. Automatically gives the browse button so that reader can upload from their system.
Add Notes Use this as sticky notes, something that you want your viewers to know. ( notice the welcome text in the form below)
Decision Box This can have only one answer YES / NO Most commonly used as disclaimers.

I have modified the guest book forms and placed the code here. You might notice that some fields have a * attached to them. This means these are mandatory or compulsory fields. If you try to submit the form using blank data for these fields, then the submission will be not processed. This is catch those wary visitors who are not attentive enough

How to Set up compulsory fields

  1. As soon as you place a field by click and Drag ( or) Edit a certain field
  2. Click on Options
  3. Notice the check box that says “This is a required field” – Click it
    The field becomes compulsory.

Similarly you can set up if you want to have a Hidden field / Disallow duplicate enties. I have embedded my guest book form above. Feel free to come up with your own version of your guest book & give me your link. I shall surely drop by and will be glad to see your progress Your appreciation is my motivation

What is Zoho Creator | The Basics| Design & Share Custom Forms |Using prevalidated Form Fields |