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.
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
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.
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
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
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...
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.
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
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"; }
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
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
How to fetch a record from a different application?
Hello, I would like to fetch records from a separate application. Here is an example: ApplicationA: "Form1" has fields: Name1, Email1, Department1 ApplicationB: "Form2" has fields: Name2 and Email2 --> Name2 is my lookup field. --> When I lookup a name, I want Email2 to automatically populate from Application A field Email1. How do I do this? Please give me an example. I have gone through the forums and do not understand the explanations. Thank you.
Select Field for Cursor
It would be nice for data entry to be able to set where the cursor is (what field) when the form box opens.
input masks to fields
Is it possible to define input masks to fields ? For example, I have a field in my app that receives data like this: 99/999.999-8. Can I have the characters "/", "." and "-" shown on the field at the moment data will be typed ? Thanks.
Convert number to alphanumeric
Hi, I have written my own custom function to convert a number to an alphanumeric code but am having some difficulty since my brackets keep moving and when I call my function, it does not always produce the intended result but the first time I ran it, it was fine. Does anyone know the best way to convert an number to base 36? eg 1=> 1 11 =>A 2000 => 1JK
Simulate "Convert" option
Greetings, zoho experts, I had automated the "convert to account, contact" option in zoho crm, because i am copying the information in two additional custom modules. The thing is i want to simulate all the actions in the convert button. I am talking about the "convert" button in the Leads module. When you click it it convert it to account and contact but also the lead module is disabled. How can i disabled the Lead module after I had copied the information? It's Urgent please help me! Best Regards,
Data Re-populate on another Form
I am new to deluge script and conditional statements as a whole. I am getting there but seem to be hung up a bit. (I have been working on this for 4+ hours) I want to populate the "client" data from Form_A into Form_B. I have set the "look up field as Client First Name, Client Last Name, Client Middle Initial." (as it relates to Form_A) Once selected I want address, services, and other data from Form_A to be pulled into Form_B. So I am attempting to build this with the scripting portion of Creator.
Returning BIGINTLIST from a function
I have a field in table A that is a multi-select lookup to table Y I want to convert the values in that field to a multi-select lookup to table Z and put them into a field in table B. Because this need happens several times, I'm trying to write a function to do this. I've written the function to return the result of the conversion. The function returns a value of type list. But when I try to assign the value returned by the function to the field in table B, the compiler says I need to have a value
Schedule in the database
Hello, Is it possible to add scheduling or aka email notification in Zoho Creator. Example if I wanted to create a database with action dates. When a date in the database is today send out an email automatically without having to log into zoho creator. Basically I need reminder emails when certain records with certain dates come up. Thanks. Iram
Function not returning correct value
I have a test function not returning the correct value. int temp.temp8(int digits) { powernum = 36.power(input.digits); return powernum; } When I input 4, I get 1679616. When I input 5, I get 6 but am expecting 60466176 When I input 6, I get 4 but am expecting 2176782336 What are the number size limits or is there a problem with the power function?
Shared Apps listing in Home page is not up-to-date.
Even after an application is not shared anymore with a user, the Shared Apps tab on the Home page continues to list it. -Varun Yagain.
Use subforms for multiple entry
I want to add the production tools of our customers to a database. So a database with machines linked to an account in Zoho CRM. I have one form (MachineEntry) where you can describe all the specifics of a machine (name/type/year). From another form (MultipleEntry) I want to add multiple machines at once by using MachineEntry as a subform. Both MachineEntry and MultipleEntry contain a ZohoCRM lookup. When you add a line from MultipleEntry in the MachineEntry subform, it automatically fills the
Marketplace issues
I can't get the demo to run without pre-loading it with records that I don't want to transfer in the install. When shared or made public the app works fine. As a demo it won't work. What exactly is the demo? Is it a copy of the app? Could my problems relate to certain code that doesn't copy well? I can't delete Screenshot images...only upload additional images. Removing the app from Marketplace doesn't clear anything. Any insights are welcome...please help.
Street address
Is there a way to set up a form to accept the following? Address: Apt/suite: City: State: Zip code: I would like to be able to validate that the address is a real address. Currently I'm using a text field but I occasionally get something other than addresses when users input to this field.
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj
Email Data and field deluge name
I am trying to add a record by sending an email to the forms's email address. I am using a specific format to populate the fields. However, not all fields are populating. I have a field in the email called CallNo#. When i enter that into the field deluge Name field the system automatically replace the # with an underscore. I assume that i cannot use a # because on its use in URLs. Can somehow fields be mapped? I cannot change in the email field because they generated by a Commercial Computer Aided
Configure field actions - Zoho quick start guide error
Hi All, I'm new to Zoho and am following the quick start guide to build some sample apps and forms. I'm having trouble with an exercise in the Configure Field actions part (https://www.zoho.com/creator/help/getting-started/quick-start-guide.html#field_actions): While I'm trying to use the fetch deluge task to assign rec variable the value of the record to be fetched from the Product form, I use the expression: rec = Product[Product_Name == Input.Product]; Following all the instructions in the page,
Update records in Zoho forms - bug or error?
Hi, I'm trying to build a simple app that just adds points to students based on the type of networking events they attend. The following are the forms/reports used: 1. Students - list of student records with id, name and e-mail (and points accumulated) 2. Events - list of events with event_id, name and points 3. Event attendance - Form where I will select an event and enter student ID so that student gets the required points In the event attendance form, once I submit the form, I want the students
Subform: On Delete successful
I have a subform and it is very important to know when rows have been deleted from the subform. As a result, I have actions on the On Delete Row in my script There is a bug when user click the "X" to delete a row from the subform but do not click update on the main form because they change their minds. The actions on the "On Delete Row" still get performed even though the row was not successfully deleted. As a result, I am getting unnecessary notifications. If the row does not successfully get
Can This be done?
Hello all, I run a Heating firm in the north and need a database system to suit my needs but struggle to find any software or online databases. The only software i can find that suits my needs is from a company call commusoft. The software looks great but the costs are really to high to merit using it. So the question is can i make a zoho creator database with such fictions as customer details, postcode look up facilitys, Service reminders, appliance database and fault history? The website for
Next Page