link does not load and application is restarted
Hi all! I am trying to develop an application for data collection for a master thesis. I have a form where people have to encode some words according to a rule in a certain amount of time. After they submit their answer they press Finish and should get to a form that would show them their score. I built an HTML view that loads 2 Zoho forms, one with the encoding algorithm and one with the exercises. Since I couldn't built a timer in Zoho, I had one built and stored at a certain web address. All Zoho
Please help me solve this GENERATEJS_TASK task error
I am trying to fetch a record and update a stateless form with the results. I have been getting a cascade of errors; Error in executing On Add-On Load script; Error; Error in executing IF rule: Error in executing If block; Error in executing For Each Record task; and finally Error in executing GENERATEJS_TASK task. The section of the script that is causing the error looks like this; if (input.Email1 != null) { for each myPhys in X_Physical_Profile [Email1 == "xyz@gmail.com"] //hardcoded the
Tooltips on buttons in new editor not saving with FF or Chrome
Here's a video demonstrating the problem in Firefox 20.0.1. The same problem exists with Chrome 26.0.1410.64 m Thanks, Jeff
Please help a newbie
Hi, I'm trying to create an extremely simple registration form to embed within my moonfruit created website. I need to capture basic name email which is fine, but I also need to get people to select from a pre populated list of schools. As there are over 16,000 in the UK I need people to be able to to first click on their county. This will then bring up only schools which are within that county. Can someone tell me how to do this?
show action in view header
I recall a discussion of always showing custom actions on top of the view for actions that are not record specific. Currently they only show if the user clicks on a record. Since the action is not record specific the user has no reason to select a record. Is this on the roadmap? Herb Wexler
Has the validation on eMail field Changed ?
My users have been successfully using my applicaiton for over a year, but last week, an error message started to be displayed : Enter a Valid Email address.... The address it doesn't like has an apostorphe in it (example john.o'reilly@domain.co.uk) An apostorphe is a valid character (if it occurs in the name, prior to the '@' symbol) Please advise if the checking routine has changed, as this worked and has worked for one year ! Thanks Neil
URGENT! Filter on lookup field not working!
Hi, I use filters on lookup fields as follows: Lookup A = Company Names Lookup B = Items by Company (filtered by company name) Lookup C = Item type (filtered by selected item) I was able to add the filter to Lookup B without any issues, but no matter what, as soon as I move to another field and come back to Lookup C, the filter I add disappears. Please Help!
Create Formula in Reports other than the Aggregate Formula
Exploring through the Report Tab in Zoho Creator is very easy and convenient, however, I have some problem regarding on producing the right output. I wanted to create summary report where I can collect the sum of the values, identify the highest and lowest value, or the most redundant value within the recordset. Browsing through the sub-form upon clicking "Add Agreggate Formula" in the left panel of the report tab (see image), i found different options from the Click to Insert Functions dropdown.
Using a formula to count non-numeric row
Hi, I am having trouble creating a View I need from a form. I want to count each text input in a row, but am having trouble using this formula: "Lead MP + JGA + TF + PB + JD + JA + CS + CM + MF + KC + AW + SS + MB + DB + MC + DD + AG + CA" Only 4 of these fields will ever be selected at once, so an example of what this returns in the formula field I created is: "NullJGANullNullNullJANullNullNullKCNullNullNullDBNullNullNullNull" What I want it to show is: "4" Is there a formula to do this? Thanks,
Updating record in zoho creator using webhooks in zoho crm.
Hi, Is there any way to update already existing record in zoho creator from zoho crm using webhooks? Thanks Nidhi
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
Multiple Sections in Zoho Creator
Hi All, I need to create one form, using Zoho Creator. Now the problem is, i am not able to find how to create different section in it. I am using 2 sided layout. For example, i want to create expense form, in which below are section and field. User Information - ID - Date - Head Quarter Travel Information - From - To - Mode of Transport - Fare/km - Total KM - Total TA - Daily Allowance - Trip Description Other Expenses - Courier - Courier
Zoho Creator
I would like to use the Creator tool to send a request to a web service which returns a list of records (in XML) and then display those records in a View. I do not see anything in the documentation which lends itself as a good starting point. Can you provide an example application or documentation on how to integrate data from a webservice to a Application View. Thanks!
how get linkSubViewCompId
Hi I want to open a summary view when click Decision box,I saw your system sample code as bellow: https://creator.baihui.com/lg8888b/jk/record-summary/view1/72686000000012866/ZC_REC_ID=72686000000012866&linkSubViewCompId=72686000000081256&linkedViewAppLinkName=jk&linkedViewLinkName=view10&isSubFormLink=false but I don't know how get the "linkSubViewCompId=72686000000081256"? if know can I open the summary view? Hope your help Thanks Stanley Guo
Can I embed a creator report in a crm tab?
I have a daily sales graph that I created in creator, but will not show in crm tab. I can see the database and grid views, but not report views. Is this a limitation or did I do something wrong.
View - Edit, Delete, Search etc. no longer working
During the editing of a newly added record in a veiw, a problem appears to have occurred whilst saving changes, which has resulted in the loss of editing, delting, searching, in fact, I can no longer do anything with the view other than look at the existing records. All other views in the same application are unaffected. Mark
Purposely update only the first in a collection of records
I'm trying to build a simple inventory management of printer resources for my school. One table contains the Inventory of our printer cartridges; each individual cartridge has its own record - so, for example, there are three records, one for each of the three Q1234 cartridges in stock. I want to be able to update only one of those records - when a patron "checks out" one cartridge of that model, the records matching that cartridge number are fetched (multiple records), but only the first of those
How do I check if an input field is visible?
Hi, I'm trying to using Deluge script to evaluate whether a field is visible or not, but not sure of the syntax. Is it something like input.Field.visible = true? I basically want to write, "If field_x is visible, do this; if field_x is invisible, do this." Any help is appreciated. Thanks.
how to show the distinct values from reports database table in a dropdown field of stateless form
how to show the distinct values from reports database table in a dropdown field of stateless form... i was getting error when i used code example as given here https://reports.wiki.zoho.com/Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html#check%20data%20in%20zoho%20reports by prameena>>>
Error while getting values to a dropdown from Reports table through api call.......
Hello I have a problem in fetching data from reports in dropdownfield in a stateless form , i m getting this error ("unable in executing set variable task and error evaluating string expression ,invalid xml/json format") i have attached the same code below <with wrong password and username and api> // Gets the authentication for your account. ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=123456&PASSWORD=abcd")); ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=")
CATASTROPHIC FAILURE - All script dropped from my Form and not present in Version or Trash. It.Just.Disappeared.
Planning to demo to my manager tomorrow as a means to sell the product into the company as a viable enterprise-level product. I am currently on evaluation and have built an app to automate some of my teams more arduous tasks. Making some finishing touches to roughly 2 weeks worth of work, when I access the application and none of the scripting appears to be functioning. Back into Script Builder and Zoho has dropped ALL code from one of my forms. That's several days worth of work in validation and
REST API - List Applications
Hi guys, I tried to follow this: http://www.zoho.com/creator/help/api/rest-api/rest-api-list-applications.html In here: <form method="POST" action="https://creator.zoho.com/api/xml/applications/limit=20"><input type="hidden" name ="authtoken" value="************"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="submit" value="List applications"> </form> How can I make this get/post request? I tried variations of: requestMap = map(); requestMap.put("authtoken", "valid authtoken ************");
As an Admin, How do I upload avatar/pictures for my users?
I am an admin for ZoHo. I have a team of 11 Sales Reps that I want to upload a picture of each of them to their ZoHo account. How is this done as an admin?
Login page for non-zoho account -
We are Pharmaceutical company, started building our CRM application on Zoho. Apart from CRM, we also need to have some forms which can be used by our employees, without having Zoho User account. For example, - Medical Representative would travel City to city for marketing purpose. - We are planning to have an form (expense form), through which they can submit their daily expenses, so that at the end of the month, we can reimburse those expenses - For this purpose, we need to create a form using
Difference between Personal and Workspace app
Can anyone enlighten me as to the difference between the personal apps and workspace apps. If I'm just trying this out to see if it will fit in our organization and want to eventually share the "app" database I am creating with my team, can I use personal for now and still share it with them later? Looking at what we need to do to create a workspace app is more than I really want to tackle at this point.
"Powered by Zoho Creator" logo is not displaying in HTML views
Hi! I notice that Zoho Creator banner in HTML views is not displaying. Powered by https://creator.zoho.com/appcreator/live/01/images/ -> 404 not found Cheers
Unable to save notes field with new App Builder
I switched to the new Creator interface - wow! I really like it! I think I've encountered a bug with notes fields. After I add it to the form, then edit the properties by adding text into the notes area, the "Done" button doesn't do anything. Thanks, Jeff
Auto number generate based on lookup/customer type
I've added an auto number generator to my form based on http://kbase.creator.zoho.com/application/auto-increment-field-values. However I need to go a step further as the job number that will be generated in my app need to be based on which franchise the customer belongs to, so I've renamed and duplicated the 'MaxValueHolder' form/view so that 'fr1valueholder' starts numbering at 1000, 'fr2valueholder' starts number at 2000, etc. My confusion is how to implement changes to the validate script(s) to
Doc link not loading in Creator
Team, This seems to be an ongoing issue. When linking a Zoho Doc link in creator the file does not show. Several blogs over the years attest to that bug. I was hoping that with the new DOCS 3.0 upgrade, this bug was addressed. I'm not an expert in Creator but I can't make a Zoho doc doc file link download. I placed a blog with the DOC team hoping a team approach could fix this bug Team, You have done a great job upgrading this platform. I have been testing for the last few days and most features
How to remove zoho logo from the embeded forms?
The forms created by zoho and embeded into a web page show zoho logo at the bottom right corner of the form? Is there any way to remove this logo and replace with another logo/hyper link? Ansari
sendmail - sending a email coded as HTML
How do I sendmail as HTML code rather than just plain text, I have added my HTML code, script just rejects it DC
Problem with zohocreator.exe import
When using zohocreator.exe to upload csv files into a form, there appears to a file naming convention issue.. For example, the following command picks up all the PS* csv files in the same folder Eg : zohocreator.exe c:\myfolder\PS2.csv john mypassword -e order-management -a Order_form imports PS2.csv as well as PS1.csv There also seem to be some issues when Excel is open, but that might be related to the above. The above error is adding incorrect records to the form - please advise.
Auto update child form when parent form data is update?
Hello guys, I'm really in stuck with this issue. Here is the scenario. App: apparel costing system. Form 1: Material which have Fabric {cotton,silk,fleece..etc} Price {100,200,300,400..etc} **100usd/1kg for example Form 2: Product Costing which have Product Name Norm {0.3,0.4,0.5} **0.3 mean 0.3kg/product Fabric : lookup from Form1 Price: fetch record from Form1 with criteria form2.fabric == form1.fabric Fomula: form2.fabric * norm (product price) Everything quite good when create new product calculation.
Assign Pay Rate to Team members
Hi, I have a workAssingment app that i use to assign tasks to individuals or to Teams. my issue is that not all individuals are paid the same rate and not all teams are comprised of the same people. Also, pay rate per job varies. Thank you.
Can't generate private permalink
Hi support, I haven't use creator for a long time, and I can't generate the private permalink rite now. Suppose the url look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/Q3NK0G00nsTDaxzrZbBCWCdSRprgxQ9aDuq7mRj1m7ObAt1kfymNU4ENKmOprQJEVhgTyXAgPTmW3V but now look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/ZC_PUBLIC_REQUESTED/ how can i find the code? Thanks.
Can I access database information from my website?
Here is what I am trying to do, will this software allow me to do this? I will have a basic database of names and contact information that I would like a page on my website to pull from. For example if I push someone to www.mypage.com/janedoe that page will pull basic data fields from my database and fill them in. It would be different for each page. Will Creator allow me to interface with my website?
Conditional formula not working
Hi I am trying to use conditional formula in my form to calculate a value from 2 other fields in my form I am using if((Chargeable > Weight),Chargeable,Weight) to calculate Price. But it always returns the Weight value instead of the correct one. Chargeable is also a formula that is calculation by multiplying 3 other fields in the formula. Weight is just inputted. Please help. thanks Antonis
Tables in zoho creator forms
Hi, Is it possible to add a table to a zoho creator form? In my case, I need users to enter a balance sheet to a form. The data entered will then be calculated and presented in different formats. Thanks for any help!
Is user activity tracked and how do you report the info? And how to backup application data on daily basis?
If users edit and delete records, is this information tracked? How can it be reported? Do I need to code tracking specifics? Is there a way to automatically backup record data?
User parameters
Good day, I'm waiting with impatience when you will make system table (or Form), where developer can see all users with access to application, and developer can create fields in this form (like in other forms in zoho) to assocoate different parameters with users (and also lookups to existance forms). And very important is to have ability to use this extra user parameters in criteria fields, deluge scripts and so on. So, for example, if I have add "group" field to this Users parameters table, I can
Next Page