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 |

Zoho Creator Tutorial – Part 3 ( Design & Share Custom Forms)

What is Zoho Creator | The Basics | Design & Share Custom Forms
Be the real world, or the virtual world, have you ever wondered how prominent forms are? The very act of handing over a form translates into to some kind of “organised” activity. (How organised is it really… is a subject of debate). What is the first thing you do when you get connected to the internet ? … Of Course!, check the mail ( what a dumb question .. isn’t it ?). But hey !, wait there is much more between that. As soon as you connect to the internet, you open your browser ( IE / FF / Safari / Opera). Then you view your signing in page for the mail. Now STOP!. What do you see… A FORM that asks for your UserID and Pwd. It is only after this you get to reach your inbox. So you see, there is no escaping from Forms. If you intend to collect data , then you need an interface to collect them. Forms provide just this. So, gear up to design your custom form.

Designing the form using Zoho Creator :-
Remember :-

  1. Forms accept data & Views display the data
  2. Both above actions happen only in live mode.
  3. Designing Forms takes place in edit mode.



As soon as you login at zoho Creator, you will be greeted by your dashboard which lists all your applications.

Zoho Creator not only allows you to create your custom forms, but also reduces the work load by providing ready-to-use fields for specific data types.

Say, the 123Number field-type will only accept numbers. Any Text will be rejected by the system (without you having to write code to validate.)

Earlier, there was just one field NAME. Now lets customise the guest book form with some basic elements.

Feel free to explore the possibility of using other field types such as Radio – for Male / Female , ADD NOTES – to have a standard piece of text by way of explanation etc etc.

If you wish to edit the existing fields ( Change NAME –> To –> YOUR NAME )
Another EDIT EXERCISE
: – Edit the Blog URL field & Remove the tick mark from “Link name required”.

We have experienced those moments of ” OMG! .. I Forgot to Save”. Not anymore. Coz, zoho creator does it for you without having to click on any “SAVE Button”. ( … actually… you wont find any save button).

Once you are satisfied with you form’s design, fields etc, go to the live mode using the ACCESS THIS APPLICATION link.

  1. Go the form in Live mode
  2. Add few data and submit the form
  3. Locate the view for this form ( don’t remember how, Read again )
  4. Confirm if all the data you have entered are seen

Now that you have designed the form & have tested it, it is time to test it in real time.

How to put Zoho creator form in Webpage / blog ?
Once you are in the live mode of the form, notice the More actions link at the top of the form & follow 1 & 2 as directed below

It is wise to share the forms using the url that is generated after Access form without login. Use the code and paste it in your blog.

You can use the HTML/Javascript element & paste code. If you want the form to appear right inside the post, then write a new post, and paste the code snippet in the EDIT HTML mode of the post.

Invite your friends to sign your guest book. See your form in action.
If you have any problem, drop me a word, I shall be glad to help.Your appreciation is my motivation Thanks in advance for linking to me at your blog.

What is Zoho Creator | The Basics | Design & Share Custom Forms

Zoho Creator Tutorial – Part 2 (The Basics)

What is Zoho Creator | The Basics | Design & Share Custom Forms

Welcome back ! I believe that by now, you would have your zoho creator login so as to proceed further. I will not be surprised if some of you have already started to explore its interface, get to know the workspace etc. Way to go !..

So, lets start from the beginning. As I have mentioned in my previous post, Zoho creator allows you to create forms & store the data obtained via these forms, and also do scores of other things. Before we start on those, it is essential to know the elements associated with zoho creator. This is get used to the terminologies. But before you start, open up Zoho Creator and login with your User ID and Pwd in another tab / window.

Applications :-
It is much easier to realate Zoho Creator Applications as Excel work books. Understand that you are allowed to create only 10 Applications (~workbooks~ notice the red bar on the top that says this) with free membership. However, with paid membership, you can have unlimited applications. From what I have seen, 10 applications are more than sufficient for individuals and small business owners.

Inorder to create an application, use the Create New Application link in your dashboard.

Lets start off by naming it as “My Personal Application”. As we progress with this zoho creator series, we will be using this application to add forms and do other stuff.

Zoho creator allows you to create 10 applications for free. Please lend me one, during the course of this zoho creaor series.

Forms :-
After creating the application , you will be automatically redirected to the My Guest book – form area where you can design your form. Although we will be seeing this in details in the upcoming posts, lets start of with a single field.

Do you notice the INSERT FIELDS in the left & Drag and Drop fields on the right. … So it would be appropriate to say here that You are in the EDIT MODE of the form.

Add a single line field , & give the Label Name as NAME

For the moment, lets have only one field . We will be adding more fields in the upcoming posts.

Live Mode :- (Run the form)

From here, things begin to get technical. There is no need to get perturbed, you will get used to it in course of time.Now, you have your first form ( with a single field NAME).It is time to use this form to gather date.

Use the ACCESS THIS APPLICATION link in the top to go into the LIVE MODE.This will take you to the LIVE MODE where data is entered into the form.

Go ahead, Enter a few names and click submit. AS soon as you Submit the form, you should notice a message that says “Data added successfully”.

Views :- Where does all the data go ?

Zoho creator uses “VIEWS” to strore the data collected via forms. Views are nothing but tables that are automatically populated with data is added to a form.

Every form by default has its view. The name is usually [FORM-NAME] & View. Just as in this case “My Guest book View”. The View displays the data only on Live Mode. In the upcoming posts, we will be learning more about how views behave in the edit mode.

Now, that you have located your form’s View, Go ahead and click it. You should be presented with something that looks like this


Lessons Learnt :-

  1. Create a new application & name it as “My Personal Application”.
  2. Create a new form & name it “My Guest book”.
  3. Add a single line field to above form and name it “NAME” — This happens in the edit mode of the form
  4. Use the ACESS THIS APPLICATION link to go into the LIVE MODE
  5. Add data into the form and click submit… “Data submitted successfully” confirms the submission
  6. Locate the view that is autogenerated for the form , It is named as “[ FORM NAME ] & View”
  7. See the data entered via form in a tabular format.

Things to Remember.

  1. Zoho allows 10 free applications
  2. One application can have any number of forms.
  3. Data can be entered only in Live mode
  4. Entered Data can be seen only Live mode …. Use VIEWs for seeing the data.
  5. You can also Add / edit / delete data from the views directly.

It might take a while for the information here to sink it. If you feel overwhelmed, take a break and come back again. I assure you, once you get the hang of things, it will be next to impossible to let go. Your time will be worth every second while you aclamatise yourself with zoho creator.

Feel free to share your thoughts, I shall be gald to respond.
Your appreciation is my motivation

What is Zoho Creator | The Basics | Design & Share Custom Forms

Zoho Creator Tutoral Series – Coming Up

I hope you remember my earlier post 5 months back, Zoho Creator :- Only intuition, no programming. (You couldn’t have missed it, coz I didn’t really post anything after that). As promised, I am here again with the intention having a zoho creator series for all those who are not afraid to try.

Not all are programming experts and not every one can say the difference between relative fields and relational databases I get confused more than i am credited for .. thats the way it is . So, this is for the common man, who can read write and understand English. You see.. Zoho creator is in english & I am blogging about it in english…Oh!.. btw, they have a Japanese version of the sitetoo.. but “iie – arigato gozaimus” .. I don’t speak anymore than this in Japanese.

The idea is to walk you through the process of building an application using zoho creator from scratch.

Walk with me.. let me know if I can be of assistance.

Zoho Creator – What is that ?

Before I answer this question, tell me how extensively do u use MS Excel?. The reason I ask is, a layman’s concept with zoho creator is somewhat based on based on this. Hmm.. lets see… the rows and columns reduce half the work load. The auto filter in excel allows you to sort / organise your data. Perhaps you are even familiar with using formulas ( basic math – to – advanced formulas). Lets say we have an excel sheet like this & call it Guestbook.

Date Name Email BlogUrl Comments
         
         

But, if you want to gather data using excel, then you would have mail it as an attachment ,OR share it as excel sheet with other users using some file sharing platform. This will work great, if you know who is going to use them. Plus, you have to be sure that the people who are using this excel are within your network and trustworthy… That is to say, the “data is private among trusted users ” & “there is no way to gather data outside this small network of friends”…

So, ….Are you with me so far ????..

Now, think about this. You have a Form & this form reflect the “structure” of the YOUR excel sheet.


This has all the elements that you want the user to add. Yet, none of them can see the actual data. Now, this is your “web form” that you have customised to suit your needs. So what happens next, You can either embed this form within your website As Shown above , or share the permalinks of the form via email. (There is more to sharing.. .lessons follow…)

What zoho creator does is to “allow you to create forms” using their WYSIWYG editor. (.. lessons follow..) And, this also allows you to view / edit the data collected via these forms at Zoho Creator. ( .. lessons follow…)

In short – Zoho creator allows you to build custom database application using WYSIWYG editor.But, inorder to start, you need to Signup with Zoho Creator. So go ahead, Register yourself and get a login, You may also signin wiht your Google Account.

Thats pretty much for the introduction,
See you soon with your login at zoho creator.
Your appreciation is my motivation