Print and PDF buttons on Page not working
I've created a page and enabled Print and PDF under the Header Option. When I render the page and try to click on either the Print or PDF buttons nothing happens. Is there anything else I need to turn on to make these buttons work? Al
User initiated Sync between Creator and Reports?
Hi, I store my creator data in Creator and then sync a lot of it with Zoho reports. I then display the advanced reporter dashboards i construct back in creator. I often use the sync time of 1 hour due to customer requirements. Some clients want the sync to be almost "realtime". I know i can code a stateless form and store the data directly into reports but i'm trying to avoid that as its just added complexity i have to deal with. So my question is .. is it possible to have a script such that it
Count records and display in html page
Is there a simple way to display the number of records from a certain form/table into a html page? Eg table Contacts: var x = number of records in Contacts <h1>Currently x records in Contacts</h1> Thanks for any tips
Getting started with variables
I have been using a different RAD tool for a few years and am looking to move across to Zoho Creator. Everything is working fine but I just need some help to get me started on variables. I have a report called Assessment_Plans with the headings: ID Assessment Plan Assessment Plan Date I want to be able to add a custom button on the report that when a row is selected the ID of the that row will become a variable. I then the user to be taken to another report where they will see only records relating
Billing History
How do I access my Zoho Services billing history?
Making Groups of 5
Hello folks, I just joined zoho and started a creator app in hopes that it can help my online gaming guild quickly and efficiently create groups for certain events we have. I created a form and report already. The report has 13 columns. The first 3 are just text fields that will rarely ever change once entered. Columns 4 through 12 are number fields. Column 13 is a total of 4-12. This total represents the total number of an in game item that the player has in their possession. The next part of
Zoho creator is fantastic, Zoho Support sucks. (took 20 days to fix a report data issue causing by wrong email format)
Although I appreciate zoho creator product very much and have been used it for years. I have to say I had terrible experience with Zoho support for this ticket 11000574. There was the data issue in the report causing my major reports not working. The issue was created May 15, it was not solved until June 3 when I bring it up to the Live Chat Support and asking for an update. The cause of the problem is simple, in one specific record: Email was entered as : xxxxhotmail@.com, which caused report
iFrame Embed Show/Hide Not Working
Hi all. I am embedding one of my Zoho Creator App forms into my GoodBarber App. I have published the app and when I embed the iFrame code, the fields that I had set to "Hide On Load" all show up. Any help figuring this out would be greatly appreciated.
how to add 2 form data in another form or pages?
I want to add the Lead and Account Data into Another form or Pages in ZOHO Creator. can anyone guide me how to achieve this.
Change Customer Portal URL
I cannot change my Customer Portal URL? Can someone help me?
Failed to add data
I am entering data via my forms and am getting a failed to add data error Application: https://creator.zoho.com/essistmgmt/assets When I close the form and resubmit the same information, sometimes it saves successfully after 3 attempts. Other times it works straight away. The forms are not behaving consistently. Forms where I have seen the error https://creator.zoho.com/essistmgmt/assets/#Form:TELCO_SERVICE_ORDER https://creator.zoho.com/essistmgmt/assets/#Form:CONTACTS https://creator.zoho.com/essistmgmt/assets/#Form:ASSET
Is Zoho compatible with windows 10 and firefox 46.0.1?
I have been developing website software in zoho which worked on everything. Then upgraded it to windows 10 - explorer works but when on fire fox (46.0.1)when I sign on to the web site. no response. What can I do? Is there a compatibility issue? What should I do? My client is really upset. Thanks, Regards, Geeta
Trying to follow a tutorial
I'm a raw newbie and am trying to follow the tutorial, https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#create-app-using-subforms When I get to entering the scripts in Workflow, the Tut doesn't specify whether its the Order Form or the Products Form. I assumed order and it gives the error "Value 'Product' is not defined". If I enter the script the Product form it gives the error "Vale 'row' not defined". It's frustrating because I just can't seem to get past this. Any help would
Combining multiple reports into 1
Is there a way to combine multiple reports into 1 that will maintain the information per form?
Pivot Table & Chart Problem
why the Report always need to regenerated ? Before regenerated always provide the wrong data. We are corporate user, the report accurate is very important for us. can you please solve the problem?
Error 500 every time
Hi, I was trying to get access to Creator and test it in conjunction with Zoho CRM, while I have trial access. But every time I get to the Creator's home page, Error 500 pops up. Please find the screenshot attached. I would appreciate if you let me know how to solve the problem.
Calculating weight loss/gain
Hi Zoho, We have two forms, a Members form with the members details which includes a field with their starting weight and a Class Register form where we select a member from the Members form and add their current weight. I want to add a field to the Class Register form that will give me the difference (loss/gain) from the starting weight on the Members form to the current weight on the Class Register form, for that particular member. Can't seem to get my head around how to do this... is it possible?
Customer Portal Invite Email lowercase name?
When signing up on our new customer portal all goes well. The issue we are experiencing is if I sign up as Firstname Lastname the invite emails sends Hello firstnamelastname, how would we modify this behavior to read Hello Firstname Lastname this is the editable line. Hello ${User.FULL_NAME}, Thanks
Form generating out of order?
Hi All, So I've got a form that, even though it is lined up how it needs to be while editing it in the form builder, it tends to be vastly mixed up once I actually go to view the application. It's done this a few times now, and I've tried cutting down on the amount of fields as well as moving the order around. It's also randomly shifting around the fields occasionally in the field builder. Any idea how to get around this/ what could be causing it?
openurl command should url encode passed url content ...
Hi: I have this command in the on Click section of my (test) Form ... thisURL = "#View:Test_HTML_View?name=" + input.Name + "&time=" + input.Time; openUrl(thisURL, "same window");When I run it with alphanumeric values entered in the Name and Time fields, everything goes according to plan ... the (test) HTML View is displayed ... and the correct values are passed to it. It even works when I enter a number of special characters ... like spaces < > ? . * @ ! " ; { } [ ] = ^ / ~ However, ZOHO Creator
Feedback regardin fixing a user account glitch
Hello everyone, Just wanted to share the experience I had (and still have as there is no immediate fix) with Zoho Creator. I've trial the platform for about a year just to see in what way I can integrate it into our business. It was a long process and finally found some areas where this platform is more than the perfect fit. Everything worked fine and have completed an application demo to present to the business. Everything worked fine. Management was impressed on how fast the development was done
Adding a Radio button, not loading in Creator
It just keeps states Adding..... and nothing happens
Form Schedule Script Issue
I have set up a Form Scheule with the following script. x = Daily_Test_Weight[Date_field == zoho.currentdate].count(); y = Daily_Test_Weight[Location == "DFW"].count(); if((x != 1) && (y != 1)) { sendmail [ from:zoho.loginuserid to:"xxxxxx@xxxxx.com" subject:"Daily Test Weight DUE!" message:"Daily Test Weight due for today." content type:HTML ] } It is set up so once a form is submitted the next day at 7am it will check to see if there is a record for the current date at Location."DFW" If there
Changing the Reference for a Lookup Field
Hi. I am new to Zoho Creator and taking over an existing project. I noticed that a page is not working correctly due to a Lookup Field pointing to the wrong page. For instance, it is currently pointing: Projects db → Project Data Distributor ID and I need it to point to Projects db → Distributor Distributor ID I know this because a similar page works correctly point to this address. I can't delete the current lookup and replace it because it is referenced in a lot of other pages. Is
Lookup a Zoho Books contact
Is it possible to have a field in Creator that enables the user to lookup/search for a contact in Zoho Books?
Conditional If Statement handling "null"
Hi, If I try to use a conditional if statement it will not let me use "null", like: input.Date_Field = if(input.Other_Date_Field != null, input.Other_Date_Field.addday(2),null); I get "Both the argument should be same type for 'IF' task. Expecting 'IF' expression found 'TIMESTAMP' expression" But I can write a normal if statement like: if input.Other_Date_Field != null { input.Date_Field = input.Other_Date_Field.addday(2); } else { input.Date_Field = null; } Please allow for "null" in
Merge two applications
I have two creator applications that i would simply like to merge or combine into just one application - ie. can this be done? i was hoping you could just export one and then import into the preferred application but i can't see how to achieve this. thanks Tony
Lookup using Fetch
Hi, I'mm trying to get a lookup field to populate a field from another form but I can't seen to get it to work... even after looking at your examples. This is the Members form and the field I need on the other form is Starting Weight (st & lbs). This is the Class Register form and I need the field Starting Weight (st & lbs) automatically populated when I select a member from the Members form using a lookup field. Any help would be greatly appreciated. Many Thanks Ian
Running Totals: Help
Hi, I'm struggling to get something to work: I have a report in Zoho Creator with the following Columns: Property Date Category Credit Debit Delta The first five columns are from data entered into the DB, the sixth column, "Delta" is from an aggregate formula where I effectively minus Debit from Credit: sum("Autoview_1445830633762_Morse_General_Ledger Table"."Debit")-Sum("Autoview_1445830633762_Morse_General_Ledger Table"."Credit") What I want is for the Balance Column
Maximum published components limit?
I have been testing publishing databases and just received this message: Maximum number of components allowed to publish for your account has been exceeded. Although I have generated several test databases and published them, I have deleted all but one of them at the moment, and it is the only published component. As far as I can tell this means that I currently have just one published component. Is there something I am missing? Do I need to de-authorize or unselect published components somewhere?
Variable Not Defined
I copied the code exactly as it was stated in your help link: https://www.zoho.com/creator/help/script/fetch-records.html#Fetch_Related I updated it for the forms and fields in my application and I'm getting a Variable not defined error. What am I doing wrong if (Wanderist_Details[ID == input.Name].count() > 0) { x = Wanderist_Details [ID == input.Name]; //input. refers to fields in current form input.Wanderist_Number = x.Wanderist_Number; input.Passport_Issued_by_US = x.Passport_Issued_by_US;
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
Record summary templates
It would be nice if we had the ability to save a record summary template and reuse it across the platform. Of course the fields will change in each form, but the general design and layout can save lots of time. Currently within one form you can copy templates, but what I'm suggesting is universal template design that can be used for any form. Maybe there is a possibility of doing this in Zoho to which I'm not aware?
developing a timesheet application
I looking at creating a timesheet application for my business, i need to be able to record hours each day and then get the timesheet to add up the hours and days for the week. Then against days when people are sick or on training i want to record a code against that day, i also then want to print the timesheet out for signature by the client i need the timesheet to calculate the hours and days, for example hours less than 4 equal 1/2 a day and then over 4 equal 1 day Any helps would be greatly received
Disabling a column in BulkEdit
I want to disable only 1 column from the list of BulkEdit. Perhaps it's a very simple to do but I don't find how! Is it possible to do? If yes, How can I do it?
Creator App Custom Domain SSL
Hi there, I'm just wondering how we can use our own custom domain to access a creator app whilst avoiding SSL certificate errors? Can we use our own certificate? The example below shows the custom domain used to access the app gets a certificate error.
System down?
I can't get to my apps
Records not automatically updating
Hi, I am currently using the JavaScript code as I cannot utilise the iframe code due to the hard-coded height. When I add a record it is not automatically updated in the results section that is embedded in my website. I have to manually refresh the webpage. When I tried to add the Next URL capability to it (that should provide a similar result to a page refresh) I received a 404 error. The target URL has a Zoho doman prefix for some reason. Is there a way to refresh the results page 'On Success'
Help with Creator
Does Creator have capability to be viewed as a database? I cannot figure out how to link applications to form the database. Nor can I find an option to view my records already entered. Please help! RHouse
Zoho Creator Customer Portal - App access
Good day Zoho, I've read through the Customer Portal section - but I cannot seem to get a confirmation on whether customer portal is accessible via the Zoho Creator App or not?
Next Page