Insert data into fields based on a condition in another form in Zoho Creator
Hi All I am having problems/issues with the following so hope someone can assist. Here is my scenario: I have 2 forms. Form 1 is called All _Airstrips. Form 2 is called Airstrip_Profile. Both forms have 7 fields which are common or with same structure. The common fields are called Airstrip_Name, Lat_Deg, Lat_Min, Lat_Sec, Long_Deg, Long_Min, Long_Sec. On the form All_Airstrips, there is a dropdown field with 2 options. The 2 options are 'Verified' and 'Unverified'. When a user edits or adds data
Code error 4600 message : You are using unsupported lower version of TLS. Kindly upgrade to TLSv1.2 or above
PDF document emailed via an API is being generated with the following error message: {"response": {"uri": "/ recruit / private / json / Candidates / downloadFile", "error": {"code": 4600, "message": " to TLSv1.2 or above "}}} It has been verified that TLS is updated in version 1.3
I deleted the default Zoho Signature by mistake
Hello, I deleted the default Zoho Signature by mistake and wanted to know how to restore it? Many thanks.
Update Form Entry by a client
Greetings, I created a form that I share with clients. If CLIENT create an entry, he is able to update it. if I create an entry, client is not able to update it. How should I manage, for my client to be able to update the entry, whoever has created it ? Thanks, Claire
Best way to update 26,300 records at once
I've added a new multi-select field to an old form so that I can share one same report with different clients and each of them will only be able to see the records that are relevant to them. The multi-select field is called 'access' and basically it will have the zoho.login email of each user that can view that record, and then the report will have a filter using the zoho.login that will check who is accesing the form and show those records. Since this form has existed long before I needed to add
hiding and showing fields at a subform
Hi! I have a form "orders" and a subform "order details" at "order details", depending on the selected "product type", some fileds should be shown. the subform has all the fields possible for all the products types, wich are all hiden on load of the main form i was thinking to show the necessary fields on user input of the product type field, but it seems like it isn't possible as it gives me the following error: "invalidTaskInSubForm" Any ideas on doing this some other way?
MD5
I'm working with a client to integrate ZC with an api-enabled service. When a user registers with ZOHO, I also need to POST the user's contact data to the api. The api requires a checksum value in the POST request. The checksum is a combination of my admin name, api account name, and user email. However, it's created using the MD5 command. In PHP this is: $test = "buzzap123256joe@gmail.com" ; echo md5($test); Gives a checksum: 9cc309fef02d2dc5e49c612838dbe20b Can we get an MD5 function for strings
Avoid duplicates
Hi, I've got a subform with basic details like Client name, Suburb, Address etc. It appears in two forms. I want there to be a single subform record for each Client name. So if no subform record exists with the entered client name, create it. But, if it does exist, update it without also creating a new subform record. I think this is simple, but i'm having trouble figuring out where to implement this. Thanks Levi
number auto generate
There is a basic need for a function to auto generate numbers. Presently the help pages layout several confusing and non-working ideas. You will not get my subscription without a simple auto number function.
Variable row not defined
For my orders form I am trying to auto populate price field (sourced from product form) in an order details subform based on the selected subform product choice. A very common requirement. I have tried using the code below (found on a zoho blog) but it isn't working for me. I keep getting the error message on the second line of code Variable 'row' is not defined //Fetches the information from the "Products" table selected_Product = Products [Code = row.Order_Items]; //Updates the value of Unit
Cannot make scripts in sub form work
I created a simple sub form with some simple math between fields. When i test it in the Forms area it works perfectly. However, when I try it as a sub form of a master form, the script is ignored. Here is the script attached to the On User Input event of a field: input.HST = (input.Product_total * 0.13).round(2); input.Total = (input.HST + input.Product_total); Any help appreciated. Kerry
AutoSum a field in a subform on the main form
Hello, I have a form called “Projects” which contains a subform called “Invoices”. In the subform I have a field called “Amount”. On the main form I have a field called “Total Cost”. When adding, editing or deleting records in the subform I need the Total Cost to auto sum the “Amount” column in the subform. Could you tell me step by step how to do this? Your help is greatly appreciated :)
EMERGENCY: Customer Portal Reports are Missing Fields in the App's Report
Hi, I urgently need assistance with an Emergency issue concerning our Customer Portal reports. I got a call today from our CEO and he said he was unable to see a variety of fields in reports on the Customer Portal. I was surprised as I had not changed the reports and I am the only user with access to the reports. I checked the App’s report and found them to be configured correctly, the fields missing on the Customer Portal reports ARE in the App’s report. However, when I open the report in the Customer
How to do calculations with value from Formula field? Getting NULL from formula field
I am trying to figure out costs of field which is the price per sqft times the amount of SQFT. I have a length and a width field, create a formula field and then have a cost field which runs a workflow to multiply sqft and price per sqft but I get a null result from the formula field. If I do a workflow that calculates the SQFT, then my form does not work offline.
Lookup a Lookup field
Hi, Is there any solution to make lookup another lookup field? Forms: FormA: Item_master (all the core details for the particular item) FormB: Price_list (lookup the item_number from form A and fetch the details + adding the cost on the form manually) FormC: PO_modul (key field is the Item_number optionA: from formA // optionB: from formB. optionA: if i fetch the field valus from formA with 1 workflow (done), i cannot fetch the cost detail from formB optionB: I cannot make a lookup field on another
I wish to parse the 'Address Composite' field. (Like the name field) in a Zoho Form / Subform
Hello, Similar to parsing the Full Name Composite field, I'd like to parse an address composite that I'm using in a subform in Zoho Creator (maybe this applies elsewhere too). I have managed to guess all of the component names of the address composite apart from 'post code'. Below is what I have guessed thus far, where <record> is just the name of an object I'm using. Can anyone share with me how to retrieve the post code value from the address composite? <record>.address_line_1 <record>.address_line_2
Report row in Pages being covered up by the row count
I have a page that I modified from the Customer Relationship Manager app where I added a report in the a page and the last row or two rows is being covered by the row count. It clears up if I change the view type to something else and then back again. Please fix this as I don't want to have rows not seen due to being obscured by the row count
Download image from the command line
Hello. I wanted to ask you how to download images uploaded to a Zoho Creator form (using an Image field), from command line tools, like wget or curl. The idea is to download them from a script, without manual intervention. I have read that there is a File downloader tool, but it cannot be used from the command line. Thanks in advance. -- Best regards
HTML page - for each record, add a row and populate
Hi, on my HTML page i've got a table. It's populated with enquiry number, name and address, unhiding a row for each record that exists with my criteria. I may need to have 50 rows in each of the 4 tables i'm creating, so i'm wondering what the most efficient way to do this is? I'd rather not have to define 50 hidden styles, 50 if statements and have 50 rows to manage Here's my current code: hidden1 = "class=\"hidden\""; hidden2 = "class=\"hidden\""; hidden3 = "class=\"hidden\""; hidden4 = "class=\"hidden\"";
Transfer of Parameters from a non-zoho URL to a Page or form
Hello, I am trying to find out how to transfer URL parameters from a URL based on mydomain to a Zoho Form embeded on an HTML page Example: URL based on Mydomain.com with parameters (mostly just a clientID) This would point to a HTML page with an embedded ZOHO form (iframe1) and embedded ZOHO Page (iframe2) STEP1 The objective is to have the ClientID parameter, transferred to iframe1 and prepopulate the clientID field in the form in iframe 1 - So that the user can fill in other fields including
Trying to store a reference to a record's ID in another table
Hi all, I'd like to get the ID of a record in one table and store it in another for cross referencing. Trouble is, the ID is a bigint and I can't seem to store this large number in a form field because of size limits. I've tried all sorts of tricks but have run out of ideas. Any suggestions? Steve
Zoho Creator PostURL responseText was cut
Hi everyone, I'm newbie here in zoho creator and deluge script. I'm trying out and testing how to call web API via SOAP. Below is the sample code. url = "http://www.holidaywebservice.com/HolidayService_v2/HolidayService2.asmx?wsdl"; Headers = Map(); response = Map(); Headers.put("Content-Type","text/xml"); body = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:hs=\"http://www.holidaywebservice.com/HolidayService_v2/\"> <soapenv:Body> <hs:GetHolidaysAvailable>
Load Calendar and timeline on date of first record
Hi, We use Calendar and Timeline reports to represent milestones for event planning. We have a Page with param projectID that filters the records based on the project been filtered. Since we manage multiple event, we have set the reports to load on the current dates. But sometime the first record of the current project can be months ahead. Our users have to change the date for the report manually every time they visit the reports. It's even worst for the Timeline report where they also have to scroll
Hide Cancel button and add delete button in form
When editing records using div embed, iframe and edit in popup, with a code similar to this: <div elName='zc-component' formLinkName='...' params='recLinkID=...&viewLinkName=...'></div> 1. the cancel button is useless and misleading, there should be a way to hide it 2. we should be able to add a Delete button to allow the user to delete this record. I know about workarounds (hiding the Cancel button with CSS and adding a Decision field to trigger a delete script) for both those cases, but I am suggesting
Set Reply-to address available in send mail
Hi I want to set reply to address in send mail script is it possible to set? eg from:abc@g.com to:ss@gmail.com reply-to:kk@gmail.com subject:test message:sample Thanks Satya NHM
Portal template
Hi https://www.zoho.com/creator/help/application/customer-portal.html shows a portal template but only for users before March 27, 2018 and versions before Creator 5. I can't find anything similar for today? Thanks Don
Displaying a formula field result as either a currency or to 2 decimal places
I have the following expression in a Formula field which i would like outputting as a Currency or a number to 2 decimal places input.Pound + input.Fifty + input.Twenty + input.Ten + input.Five + 25 i have tried the following but it only outputs to 1 result is 57.0 (input.Pound + input.Fifty + input.Twenty + input.Ten + input.Five + 25).round(2) it is possible to do in the expression or does this have to be a deluge script?
Report Print/PDF Ignores Filters!!!
So I have successfully created my first application and all is running well. The records and their templates are created and also work great. Thanks to the "Filter"-Option under "Field Configurations", I am also able to successfully hide rows with a quantity of "zero" from showing inside the report. But, what is immensely upsetting is that these fields still show inside the PDF! Which makes absolutely no sense... The whole point of a print/pdf function is to get the report printed out the way I
Zoho & AX integration
My managers wants to know how well zoho integrates with Microsoft AX. We have a lot of data in AX but the UI is not friendly. Does anyone have success with integrating AX & Zoho? How does Zoho perform as a UI tool?
Rename System Features Designations
Hello everyone, I would like to know if there is a way to rename things like the "Approval" Section. In my case it Should be renamed in 'Confirmation Requests' or something else for example. Thanks in Advance! Best regards Jan
Check if Item exceeds specified due date
Hey all, I need some help writing a script that checks if the task I've got exceeds the due date i've set. I've attached a photo of what i've got so far. I keep getting this error message when I try and save my function, i'm copying the intro to deluge manual and just changing out the variables and form names for my own.
Write script for form cancel button for both add and edit records
I want to load the edit record using edit url when i click the cancel button i want to redirect some other. is it possible to write code for form cancel action for add / edit record
Zoho Creator Walkthrough Crashes at the same step
Hi.. I am trying to follow the Zoho Creator walkthrough steps for the "Create a Pizza Ordering App" but it always crashes at the same step and I am forced to start all over again. I have not managed to get past that step. It always crashes at step 6 of 16 "Click Create a Workflow" step of the "Setup a Workflow" stage. This is the message that comes up: The walkthrough has closed unexpectedly Please navigate back to the home page and start the walkthrough again Okay
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
yourtime.tostring() format 12hr 24hr share
https://help.zoho.com/portal/en/community is too poor resource for us, but it's the only ! Some function are enable in creator, but many people don't know where to find them. Example, same with me ,try multiple methods to transform 12hr or 24hr, in fact, zoho creator have this function. Suppose now is 2016-04-29 15:30:12 : info zoho.currenttime.tostring("hhmmss") // show 033012 info zoho.currenttime.tostring("HHmmss") // show 153012 If it can help somebody, I should be very
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");
Next Page