How to convert a formula field with a string to a decimal value ?
Hi, i have a formula field with this formula "(Update.getSuffix("toto").getPrefix("titi")).toString()" the result is a string that looks like this "324929.222333" if : - i try to add the ".todecimal()" built in function to the formula the formula field doesn't show anything. - i try to update a decimal field with the result of the formula field (with the todecimal() built in function) it doesn't work also. Is there any one with a solution ? Thank you
Performing CRUD on Salesforce custom object using Zoho
Hi I have a custom object in Salesforce and want my Zoho application to perform CRUD operations on it. Is it possible and if yes, how to go about it? Regards Ankush Kheterpal
Notify a project state
I have a project form wich inlude: - customer (with his email) - account manager (with his email) - start date date of the project - end date of the project I need that in the middle of the project ( date = start date + (end date - start date) /2) or after a number of days after the beginning of the project, customer and account manager receive an email. How can i do this?
How to compare a form's OLD and NEW values of a field?
We want to compare a form field's OLD and NEW values. So that OnValidate or OnSuccess, we can trigger a costly routine *only* if it has changed. But we can't seem to refer to the "old" value. We placed it into a Deluge variable during On Load. But, the var is no longer defined in OnEdit or OnSuccess. Something tells me that I'll need to create a special field for it's old value, and store it there On Load. Then, refer to it for the comparison...? Advice appreciated! Thank you!
Salesforce opportunity update
Hi, I have an application built to create sales quotes on Zoho creator. We use salesforce CRM. Do you have any suggestions on how to export zoho created quotes as Opportunities into salesforce CRM. I understand from the help docs that you cannot call the salesforce function to update opportunities as it is not supported. Is there any way you recommend other than to export data from my zoho app and import it into salesforce using external ETL tools ? thanks Pramod
PostURL - Display result from response
I have a PostURL that is running and I would like to just return responseCode 200 - I attempted to use an executeXPath, but I dont believe the formatting is correct. result = twiliocheckmobile.executeXPath("/:responseCode/text()") {"responseText":{"success":false,"error":{"code":101,"type":"missing_access_key","info":"You have not supplied an API Access Key. [Required format: access_key=YOUR_ACCESS_KEY]"}},"responseCode":200}
Custom action email is not working
Hi all, I want to create a custom action in our team management report where we can send an automated email to selected team records (checkboxes). The addresses in the email value fields are correct but I keep getting this "no valid mail id found in to address Line:(0)" error. I am using the following code for my custom action (where toaddress refers to the correct eMail field): void sendnotification(string toaddress) { sendmail [ from :zoho.adminuserid to :toaddress subject :"Test Mail" message
How to Detect "Other" in Radio Field
I have a Radio Field where an additional option, which Zoho labels "Other" is permitted. I have on-user-input script set to change other fields, but I cannot figure out how to detect when the user picks "Other".
How to easily have an image show in a Notes field from another form
I have a form "Company Names" that contains an image, and I want it to show on load of another form. I have the images for Company Names as an upload as well as a photo. would that be a fetch and then input for the notes field?
Create New CRM Contacts from Creator Form
Forgive me if this is explained somewhere in the documentation, but I can't find it.... I'm creating a Creator application to manage volunteers. When a volunteer registers, I want the person to be added as a CRM contact. How do I do that? Thanks!
Creator not allowing me to create a crm potential
Accounts, Contacts, etc. are all working within my code, but when I try to add potential I get the check required field is entered correctly error. Not sure why Potentials is the only module that is having this issue but it needs to be resolved
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.
Next Page