URL Validation not working
Hello The URL field in Zoho creator forms is not working. It accepts any alpha-numeric string without validating whether or not the user input is a valid URL or not. Please fix ASAP.
Sending Email attachment - "On Edit"
When i send a Email Attachment with image content the script gets crashed.kindly please help.Is there anyway to send an image in attachment. Thanks
Autofilter based on Added_User == zoho.loginuser
Does anyone know if you can limit autofilters based on the loginuser...so that the filter drop down list only shows the records that match the current zoho.loginuser. The dropdown on the autofilters currently show every record in the form (field is full_name for example) and not just the ones created by the unique user. Thanks in advance. Joel
Pagebreak like Zoho Forms
Looking for a way to mimic the page break function that Zoho Forms has, https://www.zoho.com/forms/help/tools/multi-page-forms.html It seems this should be somewhere in the Creator, but I can't seem to find it.
Showing Custom actions as Dropdown instead of button
Hi there, Let's say there is an approval flow where in the report shows 2 custom actions as Approve & Reject buttons. Picking either will accordingly update the status of a record. Now to avoid a user accidentally clicking on approve / reject and changing the status of an existing entry, is there a way to make the custom buttons for Approve and Reject into a drop down menu instead? So the user sees what the state of the record is based on which option they select. It's possible to create buttons,
Sorting values in multi-select Lookup feild
I'm using a drop down list (country) to select multiple values in a multi-select lookup field (area codes). This works good. I can select united states in the drop down list and all area codes in the multi-select list get selected. Trouble is there are hundreds of area codes added and they are all added in a random order. Is there some way to reorder the selections in the multi-select field? Here is my code: for each state in Add_by_State { if (state = "All of United States") { for each area
Attach specific files to emails.
Hi, I have the following scenario: Need to setup a form that contains a process name and a file associated with the process. This is the reference data. On a particular trigger for a particular process, say X, I want to be able to send the file setup for process X to a specific person. Right now, I am able to get a link to the file and I'm able to send the link in an email. But, when the other person tries to open the file, he cannot as he is logged on as another user and the app prompts him to login.
Iframes and Wordpress
I have a Web Site created with Wordpress. I have embedded a User Input form and an Output Report into a page on the website. Essentially the User of my web site enters data for a query and then clicks the "Submit" button. The Zoho Creator does the various calculations and search functions and should then populate the Output Report. The User Input form is in an IFrame and the Output Report is in it's own IFrame and they are both displayed on the same page of my web site. My problem is that the
Access creator form from CRM
I have created a form through creator and currently trying to give my CRM users access to the form entry screen, but it seems I only am given the ability to link them to the Report part of the form. Is there a setting I am missing to enable this?
How add new values in subform multiselect/checkbox ?
Hello! I have easy question, how i can add new values in subform multiselect or checkbox. I'm created script, but he doesn't working. values = {"option","option 2", "option 4"}; subform.checkbox:ui.add(values); And i tried this values = List:String(); values.addAll({"option","option 2", "option 4"}); subform.checkbox:ui.add(values); And i tried this values = List:String(); values.addAll({"option","option 2", "option 4"}); for each val in values { subform.checkbox:ui.add(val); } What i do wrong?
Calculate field value based on subform entires
So I was wondering if someone could help with this. if we have a form, lets call it orders, and it tracks an oirder for X number of hours work then we have a subform which records the hours e.g. an order for 5 hours comes through and it gets broken up into say a 2 hour block, a 2.5 hour block and a 0.5 hour block, these hours are recorded on the subfoirm. Can I have the subform update the number of hours on the main form, possibly even stop entry of the subform record if it exceeds the value in the
No column and data
Hi why no data and column after i created form and add values.
Set value of lookupfield from a url Get variable
I have a form 'project_form1' that has a unique product_number1. on save it opens a second form 'project_form2_stateless' with openUrl("#Form:project_form2_stateless?project_number2=" + input.project_number1, "same window"); I try now to assign the value in variable project_number2 to a lookup field 'project_number2' connected to project_form1, but is is not working , if I send the variable to a number field it works find? How do I select a certain value in a lookupfield with deluge script on form
Error:The server cannot service the request because the media type is unsupported
Good afternoon everybody, I have the following error which it returns for a soap method: Error:The server cannot service the request because the media type is unsupported I use the function postUrl to execute the method soap I sent the following XML: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:bat="http://fslso.com/BatchFiling"> <soapenv:Header> <bat:AuthenticationHeader> <bat:UserName><username></bat:UserName> <bat:APIKey><password></bat:APIKey>
Two Unrelated Forms in one Chart? (to compare revenue with expenses)
Any suggestions for creating a chart that compares data from two unrelated forms? In this case, I have a form for entering individual expense items and a form for entering individual revenue items, and I'd like to be able to compare total expenses vs. total revenue, month over month. Thanks!:)
Disabled but not Grayed?
Is it possible to have a text field disabled but not grayed-out?
How to update already existing data via import.
HI all Kindly help with below I have a set of data in creator app. for example Name | Email | expiry date. The expiry date changes based sales activity offline, which is reported as CSV with Email and expiry dates. how do i import the offline sales activity report so that it updates the expiry dates for the email address already available in APP.
Count the Value within a Anniversary Period
Hi, I have a table contains the attendance records of all customers, I want to count the no. of times a Customer_ID attended the class (Date) within each Anniversary Period (based on the Join_In_Date), and return the value to another report like below format, is there any way I can do so? Thanks a lot! Customer ID Range Count ================================================================ 8888 Year 1-
Emails from my domain
Can I send emails from Creator that appear to come directly from my domain?
Communicate ZOHO CRM through XML with other Services
Hello, I'm José Daniel, and I'm really new in this platform, I would like to know if there is a way to communicate ZOHO CRM with another platform what uses Web Services. The idea is the we take the some information from the Zoho CRM and with that information we create a XML, then we send that XML to this other platform, we received and use the answers to update the information in Zoho CRM. I don't know if this question should be here or in Zoho CRM. Anyway, I would appreciate all the help. Thank
property management app
I just started using Creator and tried installing the property management application. It has the usual "wait while work our magic" prompt with a ghost image of the application in the background, then it goes to a white screen with a "no usch application exists" message. Can anyone help?
Regarding Xml Response - Execute XML Path
An XML Response which is from another WebServices, need to be fetched and inserted in the creator report. For that i may using the "ExecuteXMLPath" build in script in the creator. Using those Script i need to fetch the XML Response with multiple fields values in a single variable.But using "ExecuteXMLPath" only one field value will fetched. I need to fetch the Data as mentioned below. xml_email&password_response_holder = get_data_from_job_ready.executeXPath("/parties/party/email/text() &&
REST API link is broken
Hi, When using the REST API link :https://creator.zoho.com/api/<user id>/json/<application>/form/<form name>/record/add the web server returns an HTTP error 301 and redirects to https://www.zoho.com/creator. Seems like the REST API link is broken ? Regards Malcolm
Visibility of report content
Hi, Consider i have some 10 employee data which is entered / imported by the admin but if an employee signs in he should see only his record / data. How is this possible? I have also tried by giving view only in customer portal but this works only when user enters data and then he is not able to see others data.I don`t want this as the data is entered admin. I have also tried by adding criteria in the report specifying [Email equals zoho.loginuser] or [Email equals zoho.loginuserid] But nothing is
HTML page doesn't show new line on textarea on content coming from multline fields
I get this code on a HTML page: <textarea readonly="readonly" rows="10" cols="100"><%=form.multiline%></textarea>But it doesn't show line breaks from multiline field content. I already tried to do a replaceAll("\\n", "<br>"), replaceAll("\\n", "\r\n") or replaceAll("\\n", " "), none of them work.
How do I populate radio field choices in code that have a fixed list of options in the field definition,
I'm new to Zoho, only started working on it this week, but not new to application development for business after working for many years in Lotus Domino. Anyway I am developing some new forms and can't find a way to populate the options for radio fields and selection fields in code rather than using a hard coded list. Any help you can give will be greatly appreciated as I can't find examples anywhere so far to show me how to do this.
Wordpress Integration for Current User
Hello We are a small company of 3 managers and 10 technicians. I wanted the ability to automate some of our work and create an app that we can use to organize jobs and vacations. Only one user is actually accessing the Zoho creator system (me), the rest would be using the app only (mebedded in a Wordpress site). Can I embed the app in Wordpress and then use REST API or something to send the WP current user ID so we can track who enters orders etc? Is this possible? Or against the rules? I've been
Fetch Value from dropdown within Subform
Hi, I am new to zoho creator and not sure about how to do the following with deluge script . In the Point of Sale application and I want to auto calculate the "Expiry Date" of each item added within the subform based on the invoice date. Expiry Date = Invoice Date + X months In Add_Product Form, i have added a field called Validity Product Name Validity(Months) 4 Lessons 3 5 Lessons 4 8 Lessons 5 Thank you for your suggestion!
Publishing a Creator Page with an included Form
Hello, i have a published Creator Page with an Included Form like this: htmlpage Anlageverzeichnis(CRMID) content <%{%> <div style="clear:both;" elName='zc-component' formLinkName='FORM_NAME' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&CRM_ID=<%=CRMID%>'>Loading...</div> <%}%> but if i include this via iFrame in an Website i become the error: Can everyone help me with that? Kind Regards Klaus Brandt
Update two forms with same Data
Hie , In Subform i use this code (Code1 pic below) to show every category list depending on Lookup field option and this working well but i want these to update in Two different Forms of Same Application . so what code i have to use there ?
Date Field in Zoho Creator
Hi, I have been using zoho creator for creating many application. I always feel that it is nice to have a field for Time. I dont know why you guys are not allowing the "Time field" alone. It will be helpful you do so. Or provide any options for setting the time format criteria for single line fields.,
Download a CSV file but with semicolon as separator
Zoho offers a built-in CSV Download, but unfortunately it uses only "commas" as separator. Some systems requires a "semicolon ;" as row separator. Does anyone knows a solution for that ? e.g. programming the download based on a list from deluge ? Or does it Zoho has any plans to offer the "semicolon" version of the CSV Download as well? Thanks Alex
bug: matches function is not work in fetch record.
matchedRecords = formName [Single_Line.matches("abc.{4}d")]; matches function is not work in fetch record. abc.{4}d is regular expression can anyone help?
How to calculate business days between two dates ?
Team, I need to calculate working days between two dates for Task management . Two dates : ticketAssignedDate , ticketClosedDate . Need to achieve this without loop and recursive
Ask about records
Hi Team, We purchase EXPRESS account yearly: Unlimited User 100 Apps 250,000 recordsMy question is: If I already have ten thousand data/records and I deleted five thousand of it. Is the five thousand records will going back to 250,000 records? 250,000 expected records 10,000 records of my application 240,000 remaining records 5,000 deleted records Is 5,000 deleted records will add in 240,000 records? like from 240,000 it will going back to 245,000? Hope you get my intention.
keep the active session
I have a question, Could you help me or tell me the best way to connect to a REST API which requires to keep the active session? It means, First I have to call a login method to access other methods in the API. My code is: //CREATE THE HEADER PARAMETERS THE REST METHOD NEEDS mapHeaderParameters = Map(); mapHeaderParameters.put("Content-Type","application/json"); mapHeaderParameters.putAll(mapParametersRestMethod); // //CALL TO METHOD REST // // LOGIN
Need Help Hide / Show based of Checkbox entry
I am trying to shorten a form of unneeded fields by using a check box. On load of the form I am hiding the fields and as the Choices are made the appropriate fields are added, or subtracted if unchecked. I can easily get the first fields to unhide and re-hide based off the checking and unchecking of the "Roof" checkbox in this case, but I run into problems as I add more selected choices. Here is the code that works for the first selected choice: if (input.Exterior_Repairs_Needed.toString() ==
ID Field Required for Showing One Record In Report?
I use a link in an email to notify users that a new record has been added. The link is to the Report and I only want the new record to show. As far as I can tell, this only works if the ID is shown in the Report. Is this so?
Best Way to Filter Records by Field that Corresponds to Users?
So, I am trying to figure out how to filter records in reports based on the current user. I also have a field in these reports that corresponds to the user, but it's the initials and not the Zoho username Basically, I want to be able to filter the records so that only ones where the initials field is the one that corresponds to the current username. I had a bit of difficulty with syntax when I tried to create a formula to do this, so I am not sure how to go about this.
Copy data from one application to another application
Hello, Is there a way to copy data from one application to another application On Edit the record entry? e.g. I have two applications, 1) New Stock. [form name = Invoices] 2) Old Stock [form name = Invoices] Note: All fields are same in both application forms. I am going to edit the record and doing some modifications in "New Stock" app. When click on update button, I want to copy that record to the "Old Stock" application. Is that possible? FYI: In modification process, there may be some conditions,
Next Page