Get API Response to the zoho creator form fields.
Guys i manage to get the response from another 3rd party apps. but the return value is as below {"result":1000,"wallet":[{"balance":1000,"currency_code":"MYR"},{"balance":0,"currency_code":"SGD"}],"error_remark":"","currency":"MYR","api_status":"Success","error_code":"0"} how do massage the details within and put it into zoho creator form? thanks in advance, Jeff
Filter in report by field in form
how can I filter a report or page to show only data that is equal to a field in a form? Example: I have a form that has the following fields. Form: FilterForm dates: name, emailfilter. Have a report Customers and I want you to show me all the clients that in the field filter = emailfilter. (from the FilterForm form) How can I do it in a filter? and on a page?
Fetching fields from a Form and placing them in a Subform
I Have a form called Employees where their Name, Role and Rate is specified. I have another form called Project Details with a Subform in it called Project Workers where we specify the workers working on the project. The Project Workers subform has a lookup (drop down) field called Employees, when you click on it and pick an employee from the drop down list, the Rate of this worker is pulled from the Employees form and displayed in a single line field called Rate. I have written a script to do this
How to compute net total from a total
Please give me the correct syntax. See attached snap shot. As you can see it does not give the correct Net Total.
Addresses not showing up in address or map search
I have a couple forms with the address field and try to use the search and map feature of the address field and type in addresses I have lived at before for testing and it is not able to find them. They only way they show up, is if I also enter the county or township that the address is in. I have NEVER had to do that on a map look up field before. The address field will be filled out with information that is quickly obtained such as street number, street name, city (state is always the state that
convert message content to plaintext before sending/forwarding via script
I have a custom function that forwards specific e-mails to my todo list application. Unfortunately, the e-mail message content (which shows up as the todo's note text) is forwarded as raw html, making it near impossible to read. I'd like to convert the message content as plaintext (stripping out / removing all the html) before sending. Here's my current function: messageDetails = zoho.mail.getMessage(mail_messageId); mailContent = messageDetails.get("CONTENT"); mailSubject = messageDetails.get("SUBJECT");
Go back to previous from link to view in Details Pane
Is there a setting, configuration or something that can be done to allow a user to open up the Details Pane of a record in a report and when they click on a field that has a "LInk to View" setting to it and it slides over to the related item and when done, be able to go back to the initial Details pane that they were at previously, like a Go Back? Thank you for any help with this.
SOAP XML API call
Hi to start off i am extremely green with regard to programming. In one of my views i need to create a custom action what will do a bank account validation based on information in that view specific to that entry (custom action, show action for each record). Below is the information i have received from the company providing the validation service. I have been looking though every possible knowledge base entry and I have no clue as to how to set this up. I do understand that this is a SOAP action
Accepting payments and payment workflow issues
Hi Zoho, Here are some of the issues and concerns I’m facing while attempting to create payment workflows in Zoho creator. 1. Creating a payment workflow for a stateless form doesn’t seem possible. Can a stateless form trigger a payment workflow on insert records to main form? 2. Once a payment is made there is no connection between the payment (Checkout) record and the Creator record. There is no value that I can find to display payment status or transaction ID. 3. Enabling the payment creates
Extract State from Address Field for Calculation
I am using the address field and need to be able to use the state information in a formula field. How can I pull just the state?
upgrade on the 11th?
Excitment has been building as the banner has told us of the upgrade. The 11th came and went and nothing?
Snapshot of data
I use Zoho Analytics and Zoho Desk. I have my data fro Zoho Desk refresh into Analytics daily. I wanted to be able to produce some reports that will show me the backlog of tickets per month historically. So i can see on the last day of the month, per month what the backlog was at. e.g. Jan 100 Feb 200 March 300 Apr 300 May 200 June 250 Any one know how you can do this?
Linking Fields for dropdown
Dear Friends, I'm no zoho creator expert but i managed to create my first app. if i select organizations i want only the devices added to the selected organizations to show in the add new device. i need help with filtering a drop-down list according to a specific field.
Recieved error - Invalid JSON payload received, when trying to integrate creator-form-data to google sheet
Objective: I am trying to integrate creator-form-data with google-sheet using google-sheet-api-v4. I am able to create an empty sheet(data params being empty ) at google spreadsheets. but i don't know ,how to create sheet with data-params , to either- (1) assign title ,to spreadsheet , or (2) write any data, to spreadsheet error received : using deluge to perform task no. ( 1 ), the error thrown is : Invalid JSON payload received. Unexpected token Note: (1)Oauth credentials are checked and correct,
Dismissing a stateless form
Hi all, I wonder if anyone has had / solved this situation: I have a stateless form I'm using to show an email (from a selectable template). The user is presented with the form (with various fields filled in depending on context), then can edit the body text, and send. Ideally, I'd have it fire the script, then simultaneously close the form and report a success message (preferably one I specify) like a normal form. Working out the type of button to use / which to use to fire the sendmail script is
Sort Picklist based on Parent record field
Hello, I am working on an inventory app and I need to be able to to sort items based on their expiration date in the subform pick list. Also, when I add the item on one line item of the subform - is it possible to exclude that item from selection in subsequent line items. Thank you so much for ideas in advance! Raidas
Form theming
Hi, We created some form in Creator. Howevere, the look an feel is not what we like. How is possible / How far can we go to theme a form ? ie Change colour, add CSS styling, or font, etc... Alternative: do we need to to another Zoho app (for example Sites) to make the form design we want and push the data to Creator ? Regards
Field Action On User Input - requirement for field
Is there a way to check the user's input for a certain field critera? Field value needs to be at least 12 characters long and has to be in alphanumeric format. It can contain special characters. I've been at this for a couple days now. Thank you in advance for any help ... Cheers! Here's what I have so far ... if(input.field.length() <= 11) { alert "Field Entry MUST be at least 12 characters and alphanumeric."; } else { Field_Formatted = input.field; }
Maximum file size can be imported
Hi Good Day, Just like to know the maximum file size in .xls can be imported in in zoho project Best Regards, Harvey Mar Panes
Submit button pinned to screen
It would be nice to have the "Submit" and "Reset" button pinned on the form (i.e. always visible regardless where the user is within the form). Currently I have some forms that are fairly long, and it can be very irritating to have to scroll all the way down to the bottom of them form to click submit, especially when doing a quick edit at the top-most part of the form.
Zoho creator integration with another webservice
Hi guys, i would like to put my app to integrate with one of the delivery service provider. without much knowledge on the API , i am here to seek for help as i cant find much information online. what i want to do is to pump data from Zoho Creator to another webservice called Easyparcel. and i have got the required documentation and API key generated by the Easyparcel. one of the action sample as below <?php $domain = "http://demo.connect.easyparcel.my/?ac="; $action = "EPRateCheckingBulk"; $postparam
Dependant drop down
Hello evryone I have a vehicle data base with year,make and model column approx 7000 vehicles. I would like to set up a form to filter through year make and model. When I select year I only want to see all of the makes available in that year. When I select model I only want to see the vehicle year and make that I specify. I want each drop down to be depenant.
Strange error updating register (problems with map)
Hi All! I'm starting with Zoho creator and handling an strange error here.... Can anyone tell me what i'm doing wrong? >.< Function Parameters : accountId, accountType PORTAL_NAME = "xxxx"; AUTHTOKEN = "xxxxxx"; DEPARTMENT = "xxxxx"; SLA_MAP = Map:String(); SLA_MAP.put("CLIENTE","88184000000020031"); SLA_MAP.put("IMPORTANTE","88184000000020029"); SLA_MAP.put("CLAVE","88184000234882025"); SLA_ID = SLA_MAP.get(accountType); if(!SLA_ID == null) { REQUEST_MAP = Map:String(); REQUEST_MAP.put("associatedSLAIds":
I can't see relationship diagram
I can't see relationship diagram I follow the instructions that appear on: Help > HomeApplication > SettingsManage > developer tools > Relationship diagram > View relationship diagram But I don't find that option, it's much more to make deep basques of data without this tool. This feature is broken ?
Pivot Table Report
Hello, I need to generate a Time Table report as per attached format where the data is lying in Form and Subform. The header information will come from the main form and details will come from the subform. I tried using a Pivot Table but the cell values are count and not the actual entries such as Faculty Name and Subject / Course name. Is there a way to get the actual cell entries rather than some aggregate function. The record summary helps but I am not able to get it in the format I want. Thanks
Using data from different forms to calculate profitability
Dear Zoho Community, I'm really new to Zoho but I'm excited about the world of endless possibilities that it gives me! I will really appreciate any help to guide me! I have Heating and Air Conditioning business and I created an app to get more in control in my business. One thing that I need to accomplish right now is creating a report that would show me profitability of my jobs. To count that I need to pull data from the Job Form which has the price of the job, then deduct the materials logged
CORREOS DESDE CRM A SPAM
Buenas tardes, quisiera preguntar el por que al enviar correos masivos desde ZOHO CRM a contactos estos se marcan como spam? por lo anterior los clientes a los que se les envía el correo electrónico masivo no tienen forma de visualizarlo a menos que se dirijan a la carpeta de spam directamente. de antemano muchas gracias. Quedo atento.
Parsing JSON format responseText - not as easy/clearcut as XML. Does it even work?
The usefulness of JSON is clear in that you can you use key-value pair 'get()' method to retrieve the value of a key...which in theory is a lot easier than used Xpath and XML...but I have found this to be difficult to resolve when using getURL or postURL and I need to parse the responseText that gets sent back. In the case of the example I have dealt with the JSON format data, I think it is sending back a multi-dimensional array of data...and my assumptions about using get(keyname) seem to break
Creating record in Zoho CRM and upload file
Hi, I'm stuck on this issue, and I don't find the problem. i have a Zoho creator form with several fields : This application is linked to Zoho CRM, it creating a ticket in Zoho CRM. Everything works fine, but I can't upload document to Zoho CRM. Here my code : //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();
Not Able To Find the "replaceAll" Function
I have a function where I am trying to replace a series of "tags" with values from various forms to create a status string. However, when I attempt to call the <string>.replaceAll() function, I get an error message that says "Not able to find "replaceAll" function". I've tried this with a couple of other methods, such as replace() and replaceFirst() and ge tthe same error. Additionally, I've tried calling it like this: <mainstring>.replaceAll("tag", "value", false); As well as like this:
Timeline
Hello, Is it possible to hook into the Timeline report and change how the properties of the default date? I have a field that holds the day of the week but only need the timeline to show a 7 day period. I have also got a date field which i need to set the initial 7 day forcast of timeline by. So an example would be to set the date field in the form and when the report is generated it only shows 7 days from that date relative to the date field. Thanks
Online payments through web forms
I would like to be able to accept online payments through my website. It is my understanding that I cannot implement that with the CRM Webforms but there is a way to do that using creator. If someone has already written the code for this in creator, is there a way I could pay for it? I am not a developer and do not want to have to start from scratch when I 'm sure it exists in this community somewhere. Any thoughts?
Cannot Add Subform to Form Section
It appears that we are now unable to add a new subform to the main "Section" of my existing forms - it needs to be below the main section. This is a new situation - we have many forms with subforms inside the main section, and we can add other components to the main section, but not subforms. Has anyone else seen this behavior? Is there a way to allow this? It is required for us to be able to add subforms wherever on a form we need.
Drop down Problem
I have created a sub form, in that sub form there is a drop down field in which data is being fetched from another main form, but I have a problem that in drop down the selected data doesn't get hide after clicking on add new row in drop down field, so can you please help me how to hide(similarly like multi-select field) the selected field when I click on add new row.
Issue with mobile notifications? Anyone else having problems on IOS
Hi all, Has anyone been experiencing mobile notifications on iOS over the last couple of days. I've started using them in an app im building and cannot get them to work at all. I've dived through the documentation and followed the basic instructions of enabling notifcations on the app its self. I've setup a workflow to send one when a record is created, but i get nothing at all. I've also created a fresh app in case it was an issue with the one i was working on, but still no joy
switch inferface language
Hi, does anybody know how to switch the ZOHO Creator Inferface language? i have a german Windwos and Chrome Browser, but i would like to develop with English ZOHO UI - is this possible? kind regards Lambert
Master - Detail relationship in record templates
Hi, We need to make a record template to create a form similar to an invoice o estimate, where we have a master form and a detail form that are linked by a field, that is: Master Form: Prebill Detail Form: Time Entry The Time Entry form contains a field called Prebill which contains the ID of the Prebill form record . How do I establish the relation and filter the registers of the Time Entry form by means of the Prebill field associated with the Prebill form, in such a way that for each Prebill the
How to Add Row to subform via script?
Hi all. i am Developer, and i need add row in a subform Creator automatically with a trigger. exist a method for do it? thank you
Can note(plain) field's value be used in action?
I know the note(plain) field's content can be written in, but can it be get out and be used by other fields?
From Creator get a record from ZOHO Crm by using the Lead ID
Hi, I know the lead ID of a record created in my ZOHO CRM My Zoho CRM and Zoho Creator accounts are linked I tried this crmResp = zoho.crm.searchRecords("Leads", "(LEADID|=|520729000000065376)"); but get an error {"4832":"Invalid parameter value"} Any advice on how to achieve this ..
Next Page