Restriction on entering duplicate data already existing in an excel spreadsheet. ie. checking a spreadsheet for duplicates before accepting a lead.
I need to create a form that, 1. Does not allow a list of numbers to be entered. ('Does not equal' query is not possible since list is very long). 2. Gives a warning message whenever such number (existing in spreadsheet) is filled in a field. 3. Fails submission of form containing such number (existing in spreadsheet). Is it possible to do in zoho forms?
How do I get the developer version?
I already have and account and I've applied for the developer certification program. When I try and sign up for the developer version of creator, i get an error that I already have an account. How can I upgrade to the developer version?
File upload problems with IE10
Within the last 14 days we have started receiving calls from users who say that they can't upload files anymore in Zoho Creator. It gets to the "Please Wait" message and then just hangs. On checking, we have found that each and every person having this problem is using IE10. They're from different companies, with different network setups, but all have the same browser and version. Interestingly, if they use Firefox or Chrome it works. Anyone else finding this, and if so any bright ideas for a work
Can you set up a form to send payments?
Hi, I know it's possible to set up a form to receive payments by going into settings and enabling payments. I also noticed you can have the amount, item, and quantity fields dictated by fields within the form. However, is it possible to have the "Paypal email id" field dictated by a field as well? I want to create a form to be able to send payments to customers rather than receiving them, and to be able to change the paypal email id through the form rather than having to go through the settings for
How to read my full name from the API
I'm using Zoho API in my application. Users are getting access tokens by providing their email and password. Everything works great. I'd like to improve my GUI and display user's full name. Currently, after successful authentication, I'm showing them the email. Is there any method in Creator CRM API or general API to get user's full name?
import links
I know this has been asked before but i wish somebody would explain step by step. When you import data from crm you get form ID which is the unique link back to say and account or customer. In my case service history linked to customers. When i import this data i am stuck with a customer id number. What is the technique to change this to the correct linking info back to the crm. Please could somebody do a video or explain simply for some of us who would like to learn.
Only show records being sought.
I want to know whether a view can make the record only appears if searching for the ID number,but if you do not want any record, appears completely blank list.
Two Field Layout option for Desktop and Mobile. I.E. 2 column layout
For example, If you make an app that has a two column layout used with a PC/MAC and the left column field is relative to right column field. I.E. The Contact and the Event Date and Time. If you view this form in the mobile app version the right column fields are placed below the complete left column data fields. So, the form doesn't make as much sense on the mobile app. Granted If I move this to a one column layout it would fix the issue for mobile but would make this a scrolling nightmare on PC/MAC.
Custom actions on a published report
Hi I have a publicly available table report with a custom action which opens a summary report. The summary report has all navigation and functions turned off. The issue I have is that the summary report only displays the last record, not the summary linked to the record which was selected. I tried using the advice in this discussion thread: https://help.zoho.com/portal/en/community/topic/how-to-define-openurl-function-with-id-of-current-record But the person clicking on the custom action needs to
Limit exceeded
Hi, I'm getting the below error while updating one of my record. Record ID No: 190193000013538102 Form url: https://creator.zoho.com/piju2111/penta-crm-15/#Form:To_Do_Form Error Message: The number of deluge statement execution limit exceeded the maximum limit. Solutions tried: Tried using different variable (input3. ), getting same error. Note: I have given access to support to solve the issue. Thanks
How to Allow user to dynmacly create options in a checkbox field?
I'm using customer portal and have many people log in and access form. I want them to be able to set what the options are for a checkbox field. Then when they come back to that form and use it later it will have their options in the checkbox field. How would I do this? Thanks Scott
Same display of radio buttons for creating and updating a record
I'm new to Zoho. Loving the platform, especially Deluge scripting and HTML. I'm trying to collect responses to a long list of questions from my users, like a survey. The questions (400) come from a table. The answers are all yes/no. The plan is to present the questions in categories. A user will click on a category and see the question from that category. This part seems easy to do using an HTML page. My problem is that I can't find an easy way for users to see checkbox or radio button controls in-line
Does the Ctrl+F not work?
Dear All, Does the Ctrl+F (search) not work inside the editor? Or maybe is my browser issue 2 days now? I tried with IE, Mozilla, Chrome but it does not work. Do you face same issues with me?
Test
@rubenIMC @tpacurtis Hi, We depend on browsers; not OS. Please let me know the browser you use We support Chrome, Safari, IE and FireFox @zohocreator
Im sure this will be simple for most but i just cant work it out. please help
All i want to do is have a form where people fill out, name, age and email address, after that it takes them to pay via paypal and i am notified of payment with their linked information so that i know who has payed and what email address is linked to that payment so that i can then send through the requested info. or even better, is it possible for people to gain access to a page on my site only once they have paid and they can continue to have access for say 24 hours but then thats it? i assume
User defined checkbox choices
I'm using the portal to have individual users fill in the their own forms. How would I allow my users to define the choices in a checkbox field on a form? Thanks, Scott
Problema con los usuario de mi licencia
Buenas, tengo contratado 2 usuario en una licencia standard, pero solo puedo entra con un solo usuario , el segundo usuario no me deja entra. Que debo hacer
How to use mandrill in zoho creator application for sending emails?
How to use mandrill in zoho creator application for sending emails?
How do I add days to a date?
Not sure where to ask this, but I want to add days to a date. So, for example, the users puts in a target date when they want the item to arrive. Now, depending on a few different things, the actual ship date may be a few days different. What I did was create a target date input field and a ship date formula field. In the formula field I tried to do target_date = ship_date + 5d What am I missing here? Thanks
Display subforms like forms
Displaying subform forms as if they are list reports can make data entry unwieldy on smaller devices. I'd like the option to present them in form view (like the forms they belong to). A collapsible list displaying an identifying expression for each row that would expand when selected to display the subform would make it more manageable.
Customize or override CSS in Reports
Is there a way to override the group row color on reports? Currently it's yellow and I'd like to change that. The CSS class is zc-grouprow.
Send email from action
Hi, I am trying to create a simple Stateless form to send email to selected records. the main form: 'Register' includes email field 'Email' the Stateless form: 'Emailtoselection' includes mulltiline field 'RegID', and Email_Subject and Email_Message fields. I basically followed this post where Cyril M explains and my code looks like this: function to open Emailtoselection form and below that the sendmail function for the Send button: void SendEmail_toselection(Register rec) { openUrl("#Form:Emailtoselection&RegID="
Zoho creator api query where field blank or null?
I tried posting a long question related to this but it was marked spam so I'll just have to post multiple smaller questions. I can't seem to figure out how to do an api query where a value is blank or null, not sure how zoho stores it, whether it's blank or null as the underlying value. What's the proper way to query with criteria this way?
Record Audit search by Record ID
Is there a problem with searching the Record Audit by record ID? I tried with Firefox and Chrome and could not limit by the record ID. When searching by the email address sometimes it worked and sometimes it didn't.
Error 500 when selecting settings
Error 500 when selecting settings, I can't select settings. app is shared.
problem in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
Ical feed not working in goole calender
I have problem with ical Feed, When we replace the ical field DTSTART value with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page.
how can i Create a list with uploaded file
Hello, i worked in zoho creator, and need create a page, to show some data from a report (zohocreator). I can show all the information, but when show a upload file, just show me a plaint text with the name, but i want show the link to download the file.. how can i do this? This is the code: htmlpage test(numso) <%{%> <table width="100%" cellspacing="1" cellpadding="1" border="1"> <caption>Facturas</caption> <tbody><%for each r in Ordenes_a_Facturar {%> <tr> <td><%=r.Numero_de_So%> </td>
Combine data in pivot chart
Hello. I have Dropdown field named (Procedure) with options: "Primary implantation 1xICD" "Primary implantation 2xICD" "Primary implantation 3xICD" "Replacement of implantation 1xICD" "Replacement of implantation 2xICD" "Replacement of implantation 3xICD" "Explantation 1xICD" "Explantation 2xICD" "Explantation 3xICD" And i want to create pie pivot chart with two options of data: 1. Primary implantation that contains summary of "Primary implantation 1xICD", "Primary implantation 2xICD", "Primary implantation
Insert record function stopped working and cant access usage limits
Out of no where we are unable to insert records using functions and it seems we cant see our usage limits section any more. It just loads but will not show any date. Im thinking maybe we have gone over our record limit and so we cant insert any more records. I have added another 10k records but still cant insert records or see how many records we have used in the add-ons usage limit section of setup. Please help, the error message i get when inserting records does not say much but here it is...
append data to URL
Hi there, I had a function with an URL in a variable that appended some data to pre-populate fields: link = "https://creator.zoho.com/zoho_mikis/rangitane-beneficiary-database/#Form:Registrant_survey?Registrant_Email=" + recSurv.ID + "&Registered_with=" + recSurv.I_wish_to_register_with; That worked well, however it's Public that needs to access this form, so I published the form, which gives me the URL with the long public code. I added the same fields to it, but that does not seem te be
Creating multiple records
Hello, I have another question. I have the following forms: Form 1: In this form you have to make a rule and fill give them 3 labels: Label_1 Label_2 Label_3 Description Form 2: In this form you have to make a selection based on Label_1, Label_2 and Label_3. After selection the submit button it has to do: Create new records in Form 3 based on all the rules in form 1 from the selected Label_1, Label_2 and Label_3 in Form 2. So all the labels which are equal on the select Labels in Form 2. I have do
Automate time calculations
I have in many of my forms time fields that calculate the difference between currenttime and a set time: ( ((ETB - zoho.currenttime) / (1000 * 60 * 60)).round(1) ) This works fine when updating and editing the record. However I often work in a report overview, and I need to find a way to re-trigger the calculations for all the records in order to get updated time difference on regular intervals i.e. every 2 hrs, I have however not been able to figure out a way to do so yet. Any ideas?
Admin fields visible and editable by user?
I am a little confused how user permissions work. I have several Admin fields, but my users cannot see those. I want to hide certain fields when forms etc are published (as they do now), but my users for this app need to see and edit those fields. Can I give a user permission to see the admin fields?
Zoho Creator Report: large-number formatting
Hi can anyone tell me how to format large numbers, say "3 billion", into comma-separated format like 3,000,000,000, in a report?? Thanks!
Mobile App - Error on loading
Hi, I am having trouble loading the mobile app on one of our user accounts. I have enclosed the error message, and screen shots of the error: ------- Log Details ------- https://creator.zoho.com/api/mobile/xml/orchestra/sections/zc_ownername=johndobble2&scope=creatorapi&isCrm=true&isRules=true org.xml.sax.SAXParseException: Unexpected end of document at org.apache.harmony.xml.parsers.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:125) at com.zoho.creator.jframework.ZOHOCreator.postURLXML(ZOHOCreator.java:2161)
Does not in years work?
Hi, This saves: rec = Form_Name[!Date_Field in last 18 years]; But does not work, I can't find any mention of whether it should work or not, can you clarify? Thanks, Damien Cregan Hire an Expert
proble in ical feed implemetation
I have problem with ical Feed, When we replace the ical field DTSTART with the Actual field value (Deluge field name) then the DTSTART value become 1 and it returns the blank page. This is my ical url ' https://creatorexport.zoho.com/tantawy/pipeline-management-and-metrics-tracking/ical/New_Appointment_Form_View/DTSTART=Appt_Date_Time_Original&DTEND=Appt_Date_Time&ORGANIZER=Practic '.
Conditional formatting on upload field.
This is working just fine for standard fields. How can I test for blank upload fields, ie where a file has not been uploaded I want the report to show "red".
How to Send XML API String to crm
I am trying to convert a lead in zoho crm to a potential from Creator. I have followed the documentation here as best I can: https://www.zoho.com/crm/help/api/convertlead.html I have created the XML String but im not sure I know how to properly post this. I am using POST URL function and hopefully I have it formatted correct. I took all my values and put them into a map variable including my XML string. The process of stringing together values to make the XML string is pretty stupid. Maybe there
Next Page