Resumes on Zoho Writer

Posted by Posted on by
0

If you noticed, we have had a few sample docs in our Zoho Writer home page for the last few days now. A sample resume is there too. It is nice seeing users using Zoho Writer to post their resumes. Two such instances we found recently – Craig, who takes care of SDN,  the SAP Developer Network and who is a passionate Zoho user & Balaji Jayaraman, an AdventNet employee.

Craig’s Resume
Balaji’s Sample Resume

Have a resume to upload onto the web? Try doing it on Zoho Writer.

In-cell graphing

Posted by Posted on by
0

Recently read about in-cell graphing in Excel from the Juice Analytics blog. It is a very neat way to draw bar graphs inside cells immediately next to your data. It uses the REPT function to repeat the “|” character n number of times, proportionate to the data. For example:
=REPT(“|”;30)

Here is a sample public sheet in Zoho (click on image to go to the public sheet):

In-cell Graphs

Thank you Juice Analytics for the tip.

Zoho Wins Audience Choice Award at Under the Radar – Office 2.0 Event

Posted by Posted on by
0

We are excited to announce that Zoho wins the audience choice award at the Under the Radar-Office 2.0 event yesterday at Palo Alto, California. A total of 4 companies presented. The Judges Chioce award went to EchoSign – a really useful service, takes the pain out of managing the document signature process. Other presenters included CollectiveX and WetPaint and both of them have really good sites as well. We learned from each of these companies – thank you, guys.

I would like to thank all our world-wide audience of users for the constant feedback and support. I would personally like to dedicate this to our hard-working, passionate engineering team, which has built a wonderful suite of services in record time, and keeps improving it constantly. I didn’t do full justice to the product as a presenter (that was one useful feedback I received – improve the presentation skills!) but the product shone through.

Insert Stylesheets in Zoho Writer

Posted by Posted on by
2

Zoho Writer had an update a few minutes before. Another most wanted feature made it to the list – that of inserting CSS. The below image shows this feature in detail.

zoho-writer-css-insertion

What’s more, as the above image depicts you can insert other standard styles like Title Heading, Quote, setting a background color for the document etc. The feature currently works by giving the URL of a stylesheet on the web. This will be enhanced further.

Many of you had this suggestion of not moving the editor pane down while clicking on Share, Email Out etc. We have made these a div bubble pop-up. This methodology will soon be extended to Options, Tell a Friend & Feedback links too.

zoho-writer-share-bubble

Accessing the Print function has been made easier. Clicking on the ‘Print Preview’ link (present just above the Zoho Writer toolbar) will open up a preview window & you can  use the print from the browser there.

Do test the new features in Zoho Writer & let us know your feedback.

ZohoCreator : Custom formula

Posted by Posted on by
0

Creating custom formula is a powerful feature and it is a beginning to providing excel-like functions in Zoho Creator. Even the simplest of applications like a student marks database( given below as an example) or an expense tracker (to calculate the total expenses) requires custom fields that are calculated based on the values of other fields. They have to be created while defining the form and could be numeric, text, date or boolean.

* You can create calculated fields by selecting the field type as formula.

* All the types of form fields except multiple select fields can be used in formulas.
* The operators / functions that can be used in formulas can be found in the Deluge docs.
* The formulas will get recalculated when
  a. the formula is modified
  b. the values of the fields participating in the formula gets modified (when a record is updated).

Given below is a sample marks database application. The fields TotalMarks and AverageMarks are of type formula.


  application Student_marks_database
  {
     page Enter_marks
    {
      form Students_Mark_Sheet

      {
        Student_Name
        (
          type = text
        )
        English
        (
          type = number
          decimalplace = 2
        )
        Arts
        (
          type = number
          decimalplace = 2
        )
        TotalMarks
        (
          type = formula
          value = English + Arts
        )
         AverageMarks
        (
          type = formula
          value = (English + Arts) / 2
        )
      }
      list View_student_marks
      {
        Students_Mark_Sheet
      }
    }
  }

Please follow the following steps to create the sample application

* Login to Zoho Creator
* Click on Create Application
* Select Deluge script tab
* Copy & paste the code given below and save.

Your have now created a students marks database. You can now add some data and see the formula fields getting updated in the view.

Do send your comments / suggestions on this feature.

ZohoCreator – Tip of the Day #2

Posted by Posted on by
0

#2 How do I keep few tabs private and others public?

Follow “Manage Users” link and select “Sharing”. In the “User/Group list”, select “Public Visitors”. Expand your application and remove the selection for the tabs you want to make private. Tabs selected under “Public Visitors” will be public and tabs that are not selected will be private.