GEO en App Zoho Creator
Hi, My name is Jesús I have a system developed in Zoho Creator but I need to have a geolocation with google maps or whatever the system is used with the app creator zoho , so like the api should work within the app . Can you help ? Thank you very much and looking forward to your response.
Form fields in url parameter?
I'm creating an application where I need the data from a form field to append to a url parameter. How can I do that? Example: First Name: ____ Last Name: ____ <submit> Go to Next URL: www.domain.com?FirstName=#FirstName#
Using Stateless & Normal forms together
hello I'm trying to build a multi-page form where the first page asks the user for basic textual information. Page 2 has conditional dropdowns to pick products and their respective prices. Page 3 has a file upload field where the user can add in files. All these 3 forms add / update the same record. To get the multi-page form to work, stateless forms seem necessary. However stateless forms don't support file upload. Any alternative ways to accomplish building this 3 -page form in Zoho creator? Thanks
How to disable a row
How to disable a row..
Can't Download Disabled File Upload Record
Hi. I have a form of issues where users can upload a file. When the issue is "Closed", all of the fields are disabled so that the record cannot be changed. When this happens, the uploaded file is no longer accessible. So I leave the fields as enabled and check at verify if the file has been changed: but this is clunky and is more work for the user who goes through the upload process only to be told "no" later.
PHP Curl query to Zoho Creater API
Hi, When I use the following code, I get a new record added to the form, but with empty value. Please help: <?php $auth = "xxxxxxxxxxxxxxxxxxx"; $xml = "<ZohoCreator><applicationlist><application name=\"order-management\"><formlist><form name=\"New_Order\">" $xml .= "<add><field name=\"Track_Number\"><value>100</value></field></add></form></formlist></application></applicationlist></ZohoCreator>"; insert($auth, $xml); function insert($auth, $xml){ $curl_url = "https://creator.zoho.com/api/yoavshachak/xml/order-management/form/New_Order/record/add";
Schooling 5.0 App from template
Hi, I was studying through the Schooling 5.0 App from template applications. Suddenly , one of the module of this app (i.e.) Timetable module is not working properly. I found that there is a problem with append function. You can refer AllocateSession form --> onclick Assign&Next and also refer the function Add Timetable(). These are related code. Its an emergency . Thanks, ITKES Team
function call during onclick of button in page
Hi, <button class="w3-btn w3-round-large w3-black w3-xlarge" style="width:500px;margin:5px 130px 5px 130px;"><a class="zc-formbutton" href=<%=thisapp.sendMailAccept(idnum)%> style="background-color:#000000"><font face="Arial, Helvetica, sans-serif" size="3 px" color="#FFFEFE">I fully understood the terms & conditions.</font></a></button> I am getting an issue while executing the above code. This code instead of executed during onclick of button , it is getting executed during onload of the page.
Large File Upload Workaround - help?
Hello I need users to upload large files into the app created using Zoho creator. Since Zoho has file upload size limitations of 50MB, I'm trying to embed an external widget that can upload files and return a URL to a Zoho URL form field. Here's the code of the upload widget on Codepen using a Cloudinary widget: https://codepen.io/vlvgfx/pen/eejQmx It allows a single file upload and then returns the uploaded file's URL and image preview. How do I integrate this with a Zoho form such that the uploaded
Help fetching data
Hi all, I can't solve the following problem. I have a form "packing list" and "invoice". "Invoice" has a lookup field which is "PL-[packingListNumber]" as you can see in the image. What I need is to propagate an edit from packing list to its related invoice. Thus, at "On Edit - On Success" I wrote: invoice = frmInvoice[Packing_List = input.ID]; // my edit... When I try to edit my packing list, I've got an error which says that is unable to update "invoice". The ID columns of Packing list and Invoice
Scadenzario
Buongiorno, come posso creare uno scadenzario che imposti in automatico un alert? Grazie
Conditional Subform fields
Hello I have a subform inside a normal form. The first dropdown in the subform asks for type of food (options are vegetable, fruit) If vegetables is selected, the next dropdown in the subform should show only vegetables names and not show names of fruits. Similarly, it would do the same with fruits. There are many dozens of vegetables and fruits in a table. How should one go about implementing this?
Hide / Show Fields using URL parameters
Hello Need some help. I'm using a stateless form that is passing data into a normal form. There are some checkboxes being ticked on the stateless form and some fields need to be shown / hidden in the following step on the normal form. Any way to achieve this conditional hide/show of form fields using URL parameters being passed from the stateless form to the normal form?
Creating a record in CRM Pick List
I am trying to create a record form a Drop down form into a pick list, it seems that all the other fields are updating just fine. But not able to put data into a picklist. //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the quotes ). Creator field’s deluge name is used here. myFieldMap = Map(); myFieldMap.put("Guest Name",input.Guest_Name); myFieldMap.put("Guest 2 Name",input.Guest_2_Name);
Publish
I most likely will be the only user of my new app and I am using the free version. I have several related questions. Is it compulsory for a finished app to be published? What is the benefit of publishing? Do I need my own website to publish it to? Does publishing an app protect the integrity of the app and prevent inadvertently editing a form, report or page, whilst obviously allowing changes to be made to the data? Thanks
lookup views
HI All, I have a simple app created for sales I use "email" address as primary for all my sales contacts hence i have used the email as the lookup 3 forms, customers > basic customer details Add sales > form to add sales activity with email as look up Add call logs > form to add call activity with email as look up Im having trouble in creating a report view, where i can have button/ links with in contacts for sales log and call log for that particular customer. please help
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.
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.
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
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-
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
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.
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
Next Page