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
Help Fetching Records - Dynamic Picklists
Let me first say I am a beginner who has searched forums and video tutorials to piece together Deluge. Just enough to be dangerous! I own a home staging business, and I am very excited to create a tool built exclusively to my business! My first challenge is to create a searchable database of inventory items. I want to be able to easily search for different items, assign them to projects, etc. To be able to sort these items (and modify the sorting structure in the future), I have created 3 different
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?
Allow only 1 entry in Subform
Hello Is there a way to allow a user to pick only one row and not add a new row in a Subform field in Zoho Creator The use case is once the user selects a company name in a subform, they are shown a name of employees in the same subform in a dropdown field adjacent to the company name field from which they can pick only one employee. ex: Subform Column 1: Pick Company Name > Column 2: Pick Employee Name (employee name is shown conditionally as a list of employee of the company selected in Column
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.
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 ?
Next Page