Creator to CRM integration
I have a script creating a record in the Contacts module in CRM from my Creator app form on submit. Works fine. I've just tried to add a similar conditional script to create a record in the Accounts module on edit and it does not work? The sendmail script on edit works fine. New script: on edit { update ( type = submit displayname = "Update" on success { if (input.Send_Confirmation.toString()
auto populate syntax question
my apologies if this has already been explained. I have two forms and would like to auto populate data from one form to the other but can't figure it out. What I am trying to achieve is have an office address information (input.Street, input.City, input.State) from "FORM A" auto-populate onto FORM B after the Office Location (input.office) is chosen from a lookup (drop down menu). I have gotten very confused as to the best way to achieve this. I could use some help - I am interested in some tutorials
Error occurred while executing the workflow. Please contact support@zohocreator.com
My user was using the following https://creator.zoho.com/essistmgmt/assets/#Page:SEARCH_ME Page. She reported seeing the following error 3 times this morning Error occurred while executing the workflow. Please contact support@zohocreator.com. My system admin thinks the zoho application may be corrupt since we have been seeing errors regularly. The error log shows the multiple errors. Sl.No. Time Message Details 1 23-Sep-2013 11:00:34 AET Error : Error Executing the workflow GLOBAL_SEARCH view script.
Need Some help!
Hello, The attached plot show a graph on some of available data for one well. The data is mostly coming from samples analyzed water samples acquired from wells at different timing. On this graph one parameter showing concentration of inhibitor (red line) is plotted. I want to make an overview showing all wells last sampled inhibitor concentration. In some wells the most recent data point may be 7 days old, on another well t might be 27, but I want to have them into an overview. As it is now I need
Setting date field to null
I've checked various forum posts about this, but not found a definite answer... How do you set a date field to null? I've tried datefield = null.toDate(); as suggested in one post, but that doesn't work in the new Builder. Thanks Alex
Allow edit access to support & Privacy.
Dear Zoho Team, What exactly can the Zoho personnel see when I allow edit access to support? I would like to understand any data privacy implications here. If Zoho has any stated policy in this regard, please point that out to me. Thanks. -Varun.
detect developer email
Is there a way to detect the developers email address? Under certain conditions I want to email the application developer. This may be the application owner but maybe not. It would be nice to have a Zoho variable zoho.developeruserid.
Total number of records entered in Zoho database?
My enterprise account allows up to 100K records. I have 3 databases hosted on Zoho. How can I determine the total number of records used? I can't find any place on Zoho that tells me the total number of records used. I can see how many users I have authorized, but not the number of records created. Please advise, thanks.
How to give a unique ID number incrementing by one?
Hi, I have a form for my users and I want to have a hidden field where the form will automatically assign a unique ID number to each user that fills the form. The ID number shall start with 1 and increment by 1 in each form submit. How can I do it? Many thanks, Vera
auto increment not working
I have an application with a master form and two linked sub-forms, one of which is for support tickets. I would like to have Zoho automatically assign a unique ID number for each ticket when it is entered. I tried following the instructions here: http://kbase.creator.zoho.com/application/auto-increment-field-values. However, there are two issues: 1. This only works when adding the ticket directly in the sub-form, but not when adding it in the master form. However, users will only ever enter support
if .... then .... image
hi is it possible that one field (image) is dependent on the second one? Image should be put automaticly (just like formula) depending to the value of the field Decimal e.g. DECIMAL | IMAGE 10 | image1 20 | image2
checkboxes in deluge ... how to access their lables and values ... I need help
My form looks like this : The list is dynamic (a lookup field with filter) I need to do something like this for each checkbox if (checkbox is checked) date = checkbox.label do stuff please help me with the script for this
Filter not working correctly
Application: https://creator.zoho.com/essistmgmt/assets/#Form:SITES Note, it is shared for support editing When I select CHINA from the COUNTRY * field, and select CHINA, then select the SUBURB, POSTCODE, STATE * drop down, I do not see any results I am expecting to see the one entry in the dropdown under https://creator.zoho.com/essistmgmt/assets/#View:POSTCODE_EXCHANGE_View?COUNTRY_CODE=CHN The behaviour is odd, since when I select AUSTRALIA or NEW ZEALAND from the country list, I always get results.
Recommended size of screenshot in publishing app to marketplace is too small...
When you add screenshot to your app you are going to publish, you will see this “165 x 145 px, optional”. The 165 x 145 px, is to small. It is just like a 2 x 2 ID picture and useless to present the highlight of the app pages. Putting optional mislead developers, other had attached images bigger than the snapshot viewer and still useless to present the highlight of the app pages. I recommend changing it to 640 x 480 pixels, it is equivalent to web image-large, enough to fit the snapshot viewer...
New App Builder : Field Size 'Custon' or 'Mediun' lazy coding or new words ?
In the new App builder, the drop-down box for 'Field Size' is not wide enough for the content, so Custom displays as Custon and Medium displays as Mediun (Google Chrome Version 29.0.1547.66 m) Whilst this is purely cosmetic/aesthetics, I would never release a piece of commercial software that has visible errors, which is why I continue to use 'Old Builder' only venturing into the New Version if I need a new feature......can't say I'm looking forward to the day it gets switched off !
Cannot find "Duplicate this View" in the new design interface.
I cannot find the "Duplicate this view" option in the new interface of Creator. In the old version, it was found in "Edit this application" -> More Actions -> Duplicate this View. I cannot seem to find how to duplicate an existing view in the new design. Please help.
Can't find Upgraded Creator
I was using the free Creator to make apps for our business Zoho CRM account. It was nicely integrated with the CRM. Now I need to move past the free account. Our account owner/administrator just upgraded to the Zoho Creator to the Standard paid version. I was added to this creator account as a developer. I was added using the same email I've used in Zoho CRM and the free Creator. However, I am unable to access any of the new features and Creator is still listed as a free account when I log in. How
Add Record to Form using another Stateless Form
I am trying to add a record to my form entitled Task, using a stateless form entitle Web Task. I understand I need to use a deluge script. I have found the script builder and the add record function, but I don't know what the next step is. The fields that I want to populate from Web Task to Task are Task name, Property, Location, Suite, Type of Problem and Notes. All of those fields are lookups to other their own forms, except Task Name and Notes. I have found various examples and such, but
created a new view from a view, but it shows in the Forms tab
I was displaying a view and created a new one, but it turned up in the Forms tab along with all the forms I have. I suppose it should have turned up in the Views tab. Can anyone help ? Thanks
Once Form has been completed...send to printer?
For the current application when a Form A is completed, I need an option to send to Print, and/or PDF, or a Que?Any ideas on how to accomplish this? Thanks in Advance! Paul
Is it just me or does the images not match the tutorial on this doc?
I have read and re read this tutorial.... ....For example, we add the Deluge statement Info to display a given number. Select Save Script to save the function.... Yet the image says---> Info "hello" + input.name; (Not to mention you have to zoom 4 times just to see the image) This is very frustrating when self teaching... https://www.zoho.com/creator/newhelp/script/defining-a-function.html
statement if else not working
I´ve done some tests, but couldn´t find out why, in the if-else statement below, the contents "123456789" get stuck in the field "MatrAgente" and cannot be changed on the form. Follows the code (it is on the "on user input" action for the "MatrAgente" field) if ( ((input.MatrAgente != "") && input.MatrAgente.matches("[0-9]{9}")) ) { MatrAgente = "123456789" ; } else { alert "else"; }
Limit access top view
I have a view/report that I would like either the Added_User to have access to it OR a special group of users (they can be developers) to have access to it. In the criteria I'm able to set the first condition (Added_User = zoho.loginuser), but how can I include the second "OR" condition? Any ideas? is there a way to do it without creating two different views and use the Share method. Thank you
Tasks List Table with Link to Forms and Records
I am trying out Creator and I want to create a task list for employees that has a field which links to a form and pulls up a specific record for the employee to update. How can I do that? Example Table: Project Step Task Name Form Link (with new record or dynamic new record) Status Next Step Approved Next Step Rejected Thanks in advance for your help. Employee
how to move cursor after Alert message is displayed
I thought, after an Alert message was displayed, that the cursor would stay in the field associated with the Alert. However, it doesn´t seem to go anywhere. My question is: Is it possible to control the cursor´s position on the screen on a form ? Thanks
Error occured please contact application owner
Hi Zoho, When I submit request to my form and show me this error ; "Error occured please contact application owner" Actually, click submit request then mail come to us, but this error not coming mail to us. I try to new user form sharing. But, doesn't help me. What we can do about it? Regards, Utku.
Error in execution
Dear all, Can anybody help me what is the meaning of this error? Error in executing For Each Record task Error in executing Set Variable task. Unable to update template variable total1 Error Evaluating NUMERIC expression: unable to perform the operation + over the operand 14,865,500 and null. the code worked before, and now it is not working. Please help. thank you. michael
Only the OLDEST record is being updated.
All, When running the script below the only record that is updated is the oldest record in the DB.What have I done wrong? if(input.Returned_to_ATC == "YES") { list = MWD_Eye_Calibration_Testing[Serial_Number == input.Serial_Number]; list.Returned_to_ATC="YES"; } Screen cap of unchanged data. Jason Rapp
Can I Duplicate a Project Complete With Milestones, Tasks etc. in Project Manager PLUS?
Hi everyone. Let's say I sell real estate properties and I want to use Project Manager PLUS to create a project for each property I'm selling. Can I create a sort of template or use an existing project as a template rather than having to create a project from scratch and manually adding all of the milestones, tasks and tasklists each time I'm selling a new property? I see the 'duplicate' and 'clone' functions inside of the program but neither seems to allow me to duplicate an existing project with
Reports: how to get rows for a multi-select field?
How may I get my Pivot report to accept my "Checkbox (multi-value)" field? The Report editor omits this field from the choices. I need the report to show a row for each of the values checked in this field. Thanks.
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
java.net.ConnectException: Connection refused error
This error is occurring after the creator cloud went offline. You can't given log a support call through the website because the same error occurs!!!!!!!!!!!
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Problem with updating records in zoho creator
Hi We are experiencing problems with updating our records through either our scripts or manually editing the form. Whenever we do that, we an error message saying java.net.ConnectException:Connection refused It appears to be a server problem on your side. Please advise asap when this is fixed as updating our records are critical REgards Umar
Create pivot table report based on two different forms .
Ok I have one app my employees work out of . They have a punch clock that they use to punch in and out of daily inside this app . I create a report daily showing the number of hours they worked . Time clock is based on "zoho.loginuserid" which is stored in All Employees View - Each employee add records daily to a different application - every time they add a new record there name is added via of lookup field related to same lookup as the time clock - I would like to create a single report that combines
links to demo don't work, and seems this help file is outdated
https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html when trying to report that its not helpful, the form itself cannot be submitted
Can not change the order of the form
I move the order in Edit Application but when I go input data the form is in a different order that I am unable to change
Next Page