Using zoho.loginuser in view does not work with API
I have a view that shows 16 records in it, 1 added by another user and 15 added by me. I have a view that limits what is shown by zoho.loginuser criteria, this is done in the view definition. If I embed the view in an HTML file and look at it locally the widget shows the correct number of rows depending on who is logged in, however if I retrieve data using an API call (to export the data). It always returns my data (15 rows) no matter who is logged in. If I use the export function of the view rather
How can I integrate a Creator app with Zoho CRM?
I'm working on an application with approximately 10 forms. So, I can't link them all to the Contact module as I would like as it limits you to 3 Related Lists. Is there a way I can link to the entire application from the Contacts Module, or the CRM module itself? Any suggestions or info would be really appreciated Steve Henry 310-850-2426
Formulas not appearing in reports
I have created a simple invisible formula in a form First_Name + " " + Last_Name When I output this in a report it is blank even though the first and last names are populates Any ideas ? Thanks
Why isn't re-branding allowed on Express plans?
I can't find the documentation that compares features across editions. And I would expect that re-branding is available on Express plans what with them being paid accounts. Varun.
Backup issue
I am trying to make a backup of my app (on new interface) or save it as deluge script (on old interface), but it never works. I made the app with the old interface. Somebody knows the problem??? Thank you.
Setting a start page
I have created a form (called: login) for my users that logs what day and time they check into the app. When they press submit they are then directed to a dashboard page that shows all of the links to the various forms and reports in the app. Is there a way that I can force that login form to always be the first page they are taken to when they login? Currently I am finding they are redirected to the last page they left off on when they were using the app. Thanks, Aaron
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!!!!!!!!!!!
Next Page