Better usability on mobile
So I've created a form. When I go to the URL on iPhone in portrait orientation, I cannot see the entry fields to the right. I only see the field descriptions, and it isn't clear that the boxes are over there. Pinching and stretching doesn't seem to do anything. Changing the orientation to landscape, I can then see that there are boxes over to the right that need to be filled in. This is confusing. On a Galaxy, I can at least scroll to the right when in portrait orientation. But how would I know
HTML View
Is it possible to send HTML view as an attached report on a daily basis? Please let me know. Thanks! Vishal
Creator removing "/" from URL
Hi, we are using a Creator contact form extensively through out our web site. Example: http://2base.com/en/contact/ The contact form is catching the URL of the site where the form is used. (This is hidden for the users). But for some reason it also removes one of the "/" in http://.... So for the above mentioned site the URL shows as http:/2base.com/en/contact This causes problems in CRM, since Zoho CRM does not recognize http:/ as an valid URL, but only http:// Why is one of the "/" being removed
Can Creator be used to create a web form for CRM?
We have done some customizations within Zoho CRM and want to create a form for our website that allows for the creation of an account, associated contacts, and an invoice for an annual payment. Then we would also like the form to allow for returning members (accounts) to look up their account and renew without having to re-enter all their contact information. So does Zoho Creator allow me to create web forms based off of the information and structure within our Zoho CRM? Is this all available within
execute events
Hi, What changes should I make to the following script in order to execute an event only on weekdays and not daily? ---------------------------------------------- Reports { execute event on '2012-06-11' at '05:00' daily } ---------------------------------------------- Please help. Thanks! Vishal
Link with zoho CRM
hello, is it possible to display in zoho creator the attachment witch are in Zoho CRM Case ? The attachement are PDF, image... thnaks
Date & time picker
I think it will e great if we can simply date and time picker , may be we can have some thing like this for date-time field Date-Time: MM/DD/YYY HH/MM Where separate box is given for date & time thanks
String to hyperlink
How to convert a sting entered by a user and convert it to a hyperlink?
How to round the decimal number to last two digits.
How to round the decimal number to last two digits. Example: decimalnum=66.88888888888888 Result should be 66.88
Documents management
I sometimes attached multiple documents to a main record. Can Zoho develop a way for me to download multiple attachments in a single package, like a Zipped file, like Gmail is doing? Thanks.
Send email to everyone minus name on single text field or in subform field
Hi, I have a single text field "Name" and a subform with another single text field "Name", I send emails warning with data, but how can I change this so that 1. if(input.Dept11.contains("Qualidade")&& input.Nome !=) { sendmail [ from:zoho.adminuserid to:zoho.adminuserid,"john@xxx.com" subject:"Lembrete Portal Inovação - " + input.ideia + "" message:"Ideia - " + input.ideia + " colocada por " + input.Nome + "para avaliação na área de Qualidade" content
Need Help for PHP Return Page
Hi I have creator application stateless form, and if i submit the button in my form , then it will goes to my PHP page which was in my server, then if i enter the data in my PHP form , then the page will return back to my Creator application form. I have the below error when i redirecting the page. " An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home " Let me know How to solve this issue.
Record deletion time stamp
Good afternoon, I am familiar with both the "Added Time" and "Last Modified Time" time stamps. On my form, the "Added Time" works wonderfully. The "Last Modified Time" is not working as wonderfully. Problem: On delete, the "Last Modified Time" is displaying what appears to be random dates and times. Example: These are all reports of records deleted from my form at approximately the same time on Saturday, 3 November. Please observe the time stamp placed by the "Last Modified Time": was removed
Set Default Text Font, Size, color etc in RTF field
Is it possible to set a default font/size for rich text fields in ZoHo creator?
Analyze previous row on Add Row
Hi, I want to do an if condition when I add a new row, but this IF condition is applied for the previous row Like on Add Row Add Row - 1 if( fiedl name = Jon) { formfield.deselect("Jons name"); } Much appreciated
Print and PDF problem
Hi, I have built a HTML view that has embedded a form and a view. I have problems to Print or to export to PDF. Let me detail the problem. https://creatorexport.zoho.com/fidelmartin/multiservicios/view-perma/Liquidacion/ID_Liquidacion=18 1) Problem with Print When I click the Print button the HTML view is loaded in other window but not all the contents. At first download the head of the html page and the view, then it opens the printer window selection to select the printer. At this stage the HTML
Error with for each record- update records script
Hi, I've entered this script into the form "Orders" for each z in Clients { z.Monthly_Spend = Orders[((z.Client_ID in Clients && Month == zoho.currentdate.getMonth()) && Year == zoho.currentdate.getYear())].sum(Order_Cost) ; z.Year_to_Date_Spend = Orders[(z.Client_ID in Clients && Year == zoho.currentdate.getYear())].sum(Order_Cost) ; } and I get Error at line:3 Field Monthly_Spend does not exist in the form Orders This is true- Monthly_Spend is not in the form Orders- but it's supposed
plz answer me
how to insert the online weather report value into zoho database? please help me
Edit form with subform (window size change) causes button issue
When u edit a form with subform if you have a subform field such as notes which expands the edit window vertically it seems the submit / update buttons lose their position. The result is you click update nothing happens (the edit box changes size) and you have to click update again for the change to take affect
Simple formula results in error message
Hi there, I am trying to insert a formula field into a form and it keeps giving me the following error message when I click on "done" in the Adding Formula window: Exception occured while publishing message to the topic :: [DataModelTopic] I am not a programmer, and cannot comprehend deluge suggestions. I just want to multiple one number field by another number field! thanks! Jenny
View problem in Windows Internet Explorer
Dear Sir / Madam Good Morning We have created a HOME page in HTML view for our application. When we open the application in "Mozilla Firefox", home page open perfectly i.e as per our design. where as if we open application in "Windows Internet Explorer" , home page content's alignments get disturb, and complete home page get disorder. Snapshot of both views are attached for your reference with Red color circle. Please check and help us to get resolve the same.
Combining objects on the same page
Hello, How do you combine a chart and a view (as a list/table) on the same page/window? I tried to look at a way to manipulate the template of a page to be able to insert the two objects in the same area. Any ideas?? Thanks - Antoine
Custom Button
Hello, Does Zoho Creator supports the creation of a custom button in a form?
Select all items of checkbox
Hello I want to on Edit-Load to be possible to ckech all the items of a checkbox, is it possible?
Relationship between Date Entries
I looked around the forums for an answer to my issue and couldn't find any, I would like to link two date fields. One for when guests arrive, and one for when guests depart. I am wondering if there was a way to link the two in such a way that i can create a third field that shows the dates they will be attending. It need to include the date they arrive, and the date they depart. Example: They arrive on November 1st. They depart on November 6th They are attending the 1st - the 6th. The Question.
Custom Button
Does anyone know whether we camn create a custom button that can execute a script (i.i., call another form)?
Simple Formula Not Working (Error Message)...
Hi, I am trying to create a very simple formula but am getting an error message each time. Basically I have 2 drop down fields called Hours_Worked and Basic_Pay and I am trying use a formula to calculate the 'Amount Due'. So...as far as I can tell it should be (Hours_Worked * Basic_Pay). Eg: If Hours_Worked = 10 and Basic_Pay = 2 the formula should be: (Hours_Worked * Basic_Pay) - (10 * 2) - So the Amount Due should = 20. However, every time I try this formula I get the following error message:
ZOHO Sign-in for Embeded Forms/Pages/Views
I thought this deserved an all new post since the topic changed a bit from http://help.zoho.com/portal/en/community/topic/bugs-with-functionality-based-login-form Using the code below on a form, you can determine if a user is registered with ZOHO. if (zoho.loginuser == "Public") { //do something }What I want to do is present the user with a ZOHO sign-in form, if not already signed-in. This is simple in the application context for the form, but fails in the embedded context. It seems logical
How to use the "toDate"?
Hi , I used "toDate", but without lucky. It displays that "1970-01-01". Why did it display error date ? And how to get the date from zoho.currenttime, the easiest way. date Time_to_Date() { aa = (zoho.currenttime.toString("yyyy-MM-dd HH:mm:ss","Asia/Shanghai")).getAlphaNumeric(); bb = aa.substring(0,8); cc = bb.toLong(); dd = cc.toDate("yyyy-MM-dd"); return dd; }
Iframe width and height not working
Hi, When inserting my i frame in another webpage, the width and height values are not accepted. Please advise. This is only happening for one of my applications, the others are fine.
Simple Formulas
Since setting up this account everything seems to be great. That is until I try to do a �formula� in the �forms� field. It seems like it should be fairly easy. The instruction area for this seems to be very vague, or I�m real slow. Don�t know which. I�m trying to get two simple fields to do a simple math calculation and not getting anything to work. My fields are �Size� and �Entry Price� This is what I have tried in the formula field: ( type = formula value = Size * Entry Price ) Help with the basics.
zoho creator funnctions stop to work on edit mode
Hi evreybody, i've this problem. I was changing deluge scripting when i discovered that if i open the main form in edit mode, some functions about the relative sub-form stopped to work...but i can't understand why! As you can see in the attach, i try, just for example, to get an alert from the subform, when entering a new description...if i'm in "on Add" situation, i got the alert correctly, If in "on Edit" situation, it doesn't work...could you help me!?!?!? Thank you
Charge the list values from a another form
I have one aplication with 2 form. One it's a table for machines and the another one it's a table for fundraisers. I want create one list field that it can update automatically when the user selected the camp of centers. In another words, when the user select the comercial center, the camp of the machines can update automatically filtred by the comercial center. And the definition of the machines al centers it's in the table of machines. Someone can help me please?
Function to add a file to "Docs"
Hi, I would like to add a button to transfer a downloaded file in a custom application directly in the "Zoho Docs"application, as always for the attachments of an email, for example. Does anyone have an idea? Thank's David
Domain vs Personal Accounts
I have observed when the domain account is on, the home screen menu looks like this: But when it's off, the home screen looks like this: There should be a way to access workspace and shared apps when the domain account is on. Cheers, John Whitney ZOHO Creator Developer
Radio Frequency and Google Earth in Forms
Is it possible to add a field (can be hidden, only to appear on reports) for Radio Frequency Tagging and Google Earth, so that admins can view where a person was when he/she completed the form? Thanks!
Updating Customer in Zoho Invoice
I am trying to understand how to update a customers information in Zoho Invoice from Zoho Creator. I am successful at using the geturl and posturl for most API functions. However when I need to update a customer the required I am required to pass and XMLString as one of the paramaters. I am unclear what this would even look like. If someone could give me an example. I am familar and successful with XPath Builder and have several scripts running that integrate with Zoho Invoice, but this is the
Bulk edit issue with 0.00
This was working fine until 2 months ago or so. I was using bulk edit to add in multiple fields this value 0.00 When I now try bulk edit and enter 0.00 in field, I got value 0 (just zero, without decimal dot and double zero after). This is making me problem because the formula field is not working anymore. I did have this formula working previously ((Total_Payroll + 1.8 + Payroll_Fee) * Exchange) when I put 0.00 via bulk edit in fields Total_Payroll, Payroll_Fee and Exchange the formula was
Auto fill Form and then auto populate other forms
Hi I have form where for the first call company name and other details are entered. How ever for a follow-up call I want the company field to auto fill and on selection auto populate all the data in rest of the fields and remarks to be appended only. Can any one please help me with this? I have been trying to do it since past week.I have the screen shot attached of the form for ready reference.
*Urgent* Print/PDF options no longer functioning in IE
A recent update to the zoho system has broken the Header Options for the PRINT and PDF buttons for HTML view pages in Internet Explorer. This feature still works properly using Firefox. Are there changes I need to implement to correct this or is this an issue being worked on? Corey
Next Page