FedEx web services SOAP integration - how to display XML with markup / tags?
Hi all - having issues with this integration. I'm in contact with FedEx tech support and they need the XML generated by my script, however whenever I email or print xmlString all of the xml markup is removed and only the data contained within the tags is shown. Anyone know how I can do this? I'll be happy to share what I'm doing wrong with FedEx SOAP integration when I figure it out with them. xmlString = ""; xmlString = xmlString + "<soapenv:Envelope "; xmlString = xmlString + "xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"
Problem in attachment in Mail API
Using Mail API I can send a mail but, when I upload a file attachment, it doesn't work. This is the format that I tried, { "fromAddress": "josephabdulla@gmail.com", "toAddress": "skyclub12@zoho.com", "subject": "Email - Always and Forever", "content": "QWERTYUIO", "attachments":[{ "storeName": "646740840", "attachmentName": "Rating of Udhaya kumar.png", "attachmentPath": "/Mail/6467408401512740745391000_642421486-Rating of Udhaya kumar.png" }] } Please,
Zoho creator reports view
I have created a form for example class form and added a subform(eg. subjects) inside the form now when i click on class reports i can see my subjects field with name of the subject and on clicking that name it gives me the full information about that subject i.e fetches the row, is there any button/action so that i can get all the records of subform that are related to my form in a single view. Thanks
Zapier with shared apps
Hi! I'm trying to figure out if Zoho Creator can help me create my app. It is an app for lead management, with a three level user tier. - I am the app owner. - I share the app with my client. - He will use it for followup with his client. - He will need to set up Zapier to transfer the leads into the app he is using. - He can not have access through Zapier to the other apps I have. The question is, is that possible at all? I tried to do it, but it gave some error, specified ownername is not valid,
Subform´s Multi Line fields display issue
Hi, I´ll try my best to explain the problem I need to solve, I have a Form with a Subform as a field, this subform has a Multi Line field inside. when Adding everything works fine, but when I´m in the On Edit view, if that Multi Line field already has 2 or more lines of text, it will display only the 1st line and provide a little icon to drag and expand the field, This little icon is the problem, Its "collision box" or "clickable area" is pretty unintuitive and does not correspont to the icon's area
API call to zoho books from creator problem
Hi, there is a problem with API calls from creator to books that manifested today... did you do any changes/updates? this is causing delays and other issues for me... The code below I have used it for more than a year without any problems. but today it did not behave as expected. The objective is to pull today's invoices from books. Nomally we have 5 to 10 invoices per day, today it returned 200 records! and many of them repeated... then I use these reply to call one by one to create production
Stock Location If Statement
I have two forms, Inventory and Parts Used. In the Inventory form, I have 12 stock location for each Part. That form is updated when Parts are received from Purchase orders. When my Technicians use a part (From the Parts Used Form), the quantity is reduced in the Inventory Form for their location, there for maintaining a stock level. I am trying to create a script, that when they select the part, enter a quantity, their location, it checks to insure they have inventory in their location. I have listed
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?
Next Page