Anyone know the Zoho Invoice Status Codes?
If I do a call to Zoho invoice and want to return the status of a particular invoice, all I get is a string number as opposed to the actual written value of it (i.e. "5" for "Void" etc) I've been searching far and wide, but have yet to find a resource that contains the translations for these... so far I've been able to extrapolate two and script them like so: i = Invoices [ID == c.Select_Invoice]; s = zoho.invoice.getInvoiceInfo(i.Inv_IDN); st = s.get("Status"); if (st
Print PDF
Hi, I want to capture some details in Zoho Creator form and on submit, it should print 2 copies of data, 1 of the printer can be Google Printer. How is it possible? Any Ideas?
Subform and Mainform relationship when using creator remote api
I have a main form and subform with subtotals the subform. If I want the main form to be updated when saving a record to the subform, where do I attach the script? I realize 'On user input' when I'm using the web interface, but where do I place the script when I'm adding records through the API?
Adding the totals from two reports
Hello, Does anyone know if it's possible to add (and subtract) the grand totals from two reports? I have two reports, each showing totals of the figures for a list of stock items. Both reports show totals of the same items... one is stock in and one is stock out. What I'd like to do is deduct stock out from stock in to give me a running total in a new report or page. Any help on how I might set this up would be appreciated. Many thanks.
Need to pull data from multiple tables into an HTML Page
I have a database containing student data. Within this, I have an html page to display (and allow staff to print) data from 15 tables. These tables are linked via a FullName lookup field. There are multiple I have created an html page and now need to: 1) Insert the zoho creator field names into relevant sections 2) Create new rows where needed to display multiple records in sections (eg My Family Contacts, My Daily Requirements, etc). 3) Enable users to be able to filter the Student
creator auto backup?
Hi how can i turn creator app to regular auto-backup ? for example 1 time every week
Possible bug with drop-down field (picklist) created with UI:ADD when editing an db entry?
I created a form with a drop-down (picklist) generated from a call to a Zoho Invoice account. I run the form, add a few entries. (see image below the Client drop-down is generated using an Zoho invoice API call on Contacts and populated using the deluge UI:ADD() ). The bug is when I edit an entry, the drop-down value is not selected. The form show the drop-down and below an input box with the value. If I edit any field other than the drop down and want to save I will get an error message (Invalid
Wrong criteria search on system fields for today ?
hi just make new view for working app there is about 26 today entries but with criteria "Added_Time == today" system finds 12 entries and with criteria "Modified_Time == today" system finds 0 entries in all entries report for today (for example) are 26 entries how can i make criteria field to view current today's entries?
Private URL Link and Application Portability
My client's application has a mixture of public and private sections. Some of the forms will be placed in iframes on hml pages shared using the private url option (share without a login). When I finally export this app and hand it over to my client, all the private url links will break. It would be nice to have a deluge function that takes care of this like: https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/form-perma/user_form/<%=zoho.privatekey%> Is this even possible? Cheers, John
Convert Zoho Creator App Into Smart Phone App
Can a Zoho Creator App be converted into a smartphone app?
Paypal - cancel payment
Hi - I have a form linked to paypal and everything works if you go through with the paypal process. But if you submit the form, and at the paypal screen change your mind and cancel - I get a "Payment has been cancelled" in a little zoho status window, and then at the main creator.zoho.com page - it doesn't go back to my site. Any ideas how to handle cancelled payments? This is not a subscription - just cancelling a one-time payment before it's submitted. Thanks,
Will Payment form (Paypal) preserve lookup parameter?
I have a customerID being passed to a payment form. On submit, the page is redirected to Paypal; once payment is posted the Paypal page is supposed to return to Creator. Will that customerID be preserved upon the page-return, or will the lookup value be empty?
Make OutBound Call to Google calender so need IP address of ZOHO
am making an small application called as event scheduling. For that i am using zoho pages. and from this zoho page i am making call to Google Calendar, but after getting Access Token, and Refresh Token from Google i want to use API Call for that Google Needs IP Address of ZOHO Creator Server. i.e. Actually i want to make outbound call from zoho to Google Calendar so for that i need IP Address of ZOHO Creator Server. if any one know this please share it with me, Thanks in Advance
My attempt at a Audit Trail Log. Fully Working + a Few Question for ZOHO Employees.
First part of the post is a script for an Audit Trail, feel free to copy it if you want. Second part, are questions i have for some advanced user or employee, please help me. I wrote an Audit Trail Log for my application, i needed a simple approach, and a function that i only need to write once and copy/paste it without changes to my forms. This is what i did. I used the function getFieldNames() and getFieldValue() to get all the fields and values in any given form without having to specify each
Error occured please contact application owner.
The attached is an error msg if one of my user has an input on one of the field of a form. I guess it should be because of a script on user input for that field but I cannot see the error. With my admin access the form works perfectly! Form: Tower_planning Field: Quantity - On Add - On user input
Google Ical Feeds Not Working
All of sudden, my Ical feeds to Google Calendar are not updating. I have been using the same ical feeds for several years and they have been fine. The same feeds to a Zoho Calendar are updating correctly. Has anyone else seen this issue
Fetch records from Zoho CRM to HTML View
I have a report (image1) with employee details. Also I created an html view (a table image2) which fetches the employee's data and show them in each cell. My question is, if I have all the employees details in my contacts (Zoho CRM) how can I do the same? How can I add in the E-mail cell the employee's email from the CRM? I understood the tutorial https://www.zoho.com/creator/help/fields/access-crm-fields-in-zoho-creator.html but what is the deluge code to get the email and put it in a cell in my
How to add existing CRM object with the new application
Hi, I am creating a new application in Zoho creator. I want to pull the accounts tab to be displayed along with the other objects/Forms in the new application. How can I achieve that?
Submit to Url
Our services follow RESTful standards fairly strictly. A successful api call is indicated by a http response code in the range: >= 200 and <= 299. Any other http response code is a failure. Our services respect common http headers if you need to customize the response to a specific encoding or format. If you run into a problem, be sure to look at the http response code and headers as they usually provide specific information about the problem. When posting data upon transferring a prospect to us,
Getting Error Message while creating new Form Action for On Click
While i ma creating new Action On Click button i am getting following error:- Error at line number : 1 at column 2 In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator != is not valid
Branding
Hello, I looked all around the many pages of ZOHO information but I do not find information that advises if I can develop applications and have it branded with my own company logo. exclusively. Any advice appreciated
Prevent users from users viewing same page via back button
I have some pages that perform certain actions on load. If a user visits them, moves on, then passes through them again using their back button, the load action is performed again. How can I prevent users from using their back button? Or display a different page when the page is visited from the back button? Or prevent actions from being carried out on load when visited from the back button? I was wondering about a solution using a unique ID generated per page view - but that would create a crazy
Having issues with script builder in Windows 8.1
I wondered if anyone else has had any issues when working on longer script sections in script builder on a pc running Windows 8.1? I don't get the issue with my Windows 7 or XP machines, just with the 8.1 machine.
All images in Zoho not showing
Hi We can't see any images in Zoho including the Zoho Logo - is this a sitewide issue or specific to our user login ??
Upload using formula or barcode
Hi all, What I'm trying to do in total is create a barcode (image) in the view using input.feild... i have used this script in a formula to generate image (barcode) <img src="http://chart.apis.google.com/chart?cht=qr&chs=200x200&chld=L |1&chl=" + input.feild +" alt=""> it works quite well however i need it to display the generated image in the views... is there a way to get this done? I'm thinking of creating another formula to upload the image then render it using a "add
Duplicate application not happening
I see other postings on this issue, but they are all some time ago. I am trying to duplicate an app but it does nothing. It's a reasonably large and complex app, but I don't see why that should make any difference. I have tried exporting it, then creating a new app by importing the exported DS file, but that gives another error. Is anyone else having trouble duplicating an app please? Thanks!
Fetch data in html view table
If I have a form called Details with three single fields (Name, Surname, Fathername) and in an html view I have a table <table style="width: 90%" border="1"> <tr> <td>Name:</td> <td></td> <td>Surname:</td> <td></td> <td>Name of Father:</td> <td></td> </tr> </table> how can I fill the tds with the Name, Surname and Fathername from the form (report)? I mean <td>Name:</td> <td><%what I have to write here?%></td> <td>Surname:</td> <td><%what I have to write here?%></td>
I need to send email when when editing a record.
I'm new to Zoho and I'm trying to figure this one out. My application has a form and then a view. What I need to happen is when someone edit one of the entries and check a (yes or no) box. I want it to send a email. But the email is sent only when the box is checked 'Yes" and then saved. I went into the workflow and played around with the "IF" statements under "On Edit/Validation" but its not changing anything" Please see my screenshots.
Duplicate Application and automatically update it
Well, my question is quite general concerning the duplication of an application. My question is, if I have a huge application and I duplicate it, is there any way when I change something in the 'parent' application then automatically to make this change in the duplicated application? In other words, to update automatically the second application. For example, if I add a new form in the 'parent' application then to automatically create this form in the second application. Or I have to do it manually
How to track running totals (e.g. inventory)?
Newbie here. I trying to accomplish something that seems like a simple task, but can't quite figure it out. I am trying to track product inventory at stores as follows: 1) I set up a form that adds a store to the database (add_store). 2) I set up a form that adds product to the database (add_product). 3) I set up a form that adds a product to a store (add_product_to_store). I used look-up fields to choose store name and product name. There is a also a numeric field to specify how many units of
Unable to duplicate an application
Hi I am trying to duplicate an application. nothing happens. What should i do? Thanks
Look up function, just add new entries OR Subform size definition
Hey there, I just want to use my original inquiry form with a look up field to my address database, to send it to my contacts, that they could type in there inquiries by there own. Why ever there isn't such a function in Zoho Creator, where you could set up a adjusted kind of your original form for the public use. Of cause you could create a second adjusted form, but then it‘s very annoying to add this selected data to your old main view.... So I scripted a little code, which indicates if a stranger
Can I use RegExp to split a string into an array?
Hi Cecil Adrian Can I use a RegExp to split a string into an array, if so, how do that could you please help me. like this string ="12345678" split into array = [1,2,3,4,5,6,7,8] by RegExp Thanks! Stanley Guo 2011-11-5
Customer Email ID in Customer Portal
Hi, Is there a way to get the Customer Email ID of of customer in Customer Portal ? It's not working with zoho.loginuserid... it's null. Thanks, Pascal
Populate more data into subform
Is it possible to populate some inputs into a subfrom by scripting from a main form? I'd like to create a kind of dynamic subform which could shown up based on a dropdown list and would be populated by data from other forms. With other words it would be a pre-filled subform by 4-8 rows in that. See below the sub-form. Only the quantity would be optionally editable by the user, other field should be pre-filled based on a previous choice from the main form. I was able to add data from a form but only
Not Contains Criteria
Hi There, I have put together a demo application to demonstrate this problem at the following link https://creator.zoho.com/zoho_beth3/contains-criteria-example# I want to be able to select all records where option 2 has not been selected in the multi select box. When I manually search for records in the view "Add Option Record Report" and set the criteria "Not Contains" Option 2. I get the correct results. When I save this as a new view, the results are no longer correct. See the view "Without Option
Request fails to enroll in a particular profile.
Request fails to enroll in a particular profile, except where the record the following message appears, and nothing happens: java.sql.SQLException: java.sql.SQLException: java.lang.Exception: cannot getConnection when the Txn Status is STATUS_MARKED_ROLLBACK Exception occurred during get connection from datasource Thank You!
Resize reports in html views
If a have two or three embedded reports in a html view, is there any way to change the width, the height and the positions of each report in the html page? If yes can you please tell me an example? Because as you can see in the attached image4 the html page is not well designed. Or if there is any way to decrease the width between the roomtype and low season which is quite huge. I went to column properties of the report, I decreased the Column Width but nothing happens.
Grandparent records
I can handle parent-child relationships readily, but what about grandparent-parent-child relationships? For example, how can I put fields from those three levels into a report?
Query related records
Hi: I am trying to figure out if I can query related records on the save of a record with a look up field. I created an app in Creator called Work Order. Work Order has a look up to Products. In Products I have a lookup to Products for Parent Products. When a user saves a Work Order with a Product filled out, I would like to query on all the Child product records and created Work Order Lines. Is this possible? Thanks
Next Page