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");
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.
Auto Filter does not reflect Set Criteria
Hi, I have a dropdown field "Shopping Centre". This field is linked to another form which contains names of all shopping centres, as well as the owner of the centre. The "Shopping Centre" field has a criterion set "Owner == 'Owner1'", since I only want the dropdown to show names of reviewers who belong to Owner 1. Now when I add this "Shopping Centre" field to the auto filter in a View, when I try to filter while accessing the View, I can see all Shopping Centres, not just those owned by Owner1.
Duplicate a lookup field
Hi, I am trying to duplicate a lookup field. The original lookup field is a string. For duplicating into another field, I have tried the following. But none of it seems to work (I am getting the number instead of the string0. Let me know if there are any other options. 1. Use a simple formula, duplicate = original 2. Add a single line field 'duplicate' and use the deluge script on user input of 'original' A = Form_Name [ID = input.original]; input. duplicate = A.original;
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
Update field B to be 365 days after field A
I know this is supposed to be really easy, but I can't figure it out. I have field A that will be populated with a date. I want/need field B to automatically populate with 365 after the date in field A. I know there is the .addDay() function, but I don't understand how I'm supposed to format my custom function to get it to return 365 days after the date entered in field A. Please help. I know this is supposedly really easy, but I'm having a hard time, so a detailed explanation would be really appreciated.
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
Next Page