To fetch employee details
Hi i am developing an application for my company in which i need to access the employee details. I have created a function where the output of that is my employee details but i am not knowing which input field in form design i have to use to get employee
Page with multiple reports with filters from a record's data?
Hi, I'm trying to make a page that will show a single record from my form Designs, and show a report of Components filtered by information in the Designs record. For example, all components rated for 3-5KW, all components for 200V, etc. What is the most
Translation of language on Page Components
Hi, has anyone had experience to translate language on Page Components? I notice that Zoho doesn't support this part of localisation (https://www.zoho.com/creator/newhelp/app-settings/understand-localization.html#language_options). Just wondering if I
Localisation of Page Components
Hi, has anyone had experience to translate language on Page Components? I notice that Zoho doesn't support this part of localisation (https://www.zoho.com/creator/newhelp/app-settings/understand-localization.html#language_options). Just wondering if I
Zoho Creator Page columns
Is it possible to adjust the width of columns on a Page either on the elements (Panel/Button, etc.) or through a ZML snippet? There are a couple of sample applications that seem to should this where there is a 4 column width grid of items but some of
javascript:///alert(9)/
"><img src=x onerror=prompt(9)><" "><img src=x onerror=prompt(9)><"
How to add a Fliter in a report that is called inside HTML page
My Dashboard has a search on top where user can search record by entering ID called as "Request ID". It opens REPORT for the entered ID but there is an ADD record button on bottom-left which I don't want them to see, although records can be added by them.
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Iterating through records and sending email message to distinct email values
Hi, I am trying to iterate through records based on a criteria and that will give me multiple records. However, I only want to send email the the email value once if the email is repeated in the records. This script will email the same user multiple times.
Conference Room Booking App
Hi, I am trying to use the prebuilt Conference Room Booking app in Zoho Creator. However, I realised that the app allows overlapping of booking of the same room at the same time. Please help me with scripting some validation to prevent overlapping of
image gallery
we are building an application for real estate and need the best way possible to display a property's images. what is the closest or best way to replicate an image gallery using zoho creator?
Setting "Remind At" Date in a CRM Task via the Creator CRM API
Hello， From Creator I have satisfactorily been able to create a CRM contact record, and assign a task to that person. However, I would also like to be able to set a 'Remind At' date for 3 days after the contact record has been created, to remind me to contact that person. It's not clear if, or how, this can be done from the Creator API...because within CRM, the 'Remind At' field has, I guess, a number of sub-fields....here is the sample code that I am working with... tomorrowDate = zoho.currentdate.addDay(1);
How To Count Multi Line Entries
Hello, I am trying to creaate a basic application where we will have a single container tracking no and multiple small parcel tracking numbers. To make everything faster I want to scan the tracking numbers to a multi line field but want to know how many
update field of main form from popup window
Hi, I need to submit data from popup window to the parent form. Is it possible in creator?
Key Value Dropdown
Would it be possible to add a key-value dropdown list to creator so that we can do things like populate it with a map that contains human readable text that's linked to an id number. e.g. being able to select the line item that a creator object belongs
Mail merge template on Quote module
Hi! Is there a chance to Zoho offers mail merge templates for Quotes Module in te near future? There isn't on native product.... only on custom module? Will I have to create a "custom quote module" to acess mail merge template? Tks Paulo
Multi-Select Reporting
I'm newer to deluge and I've seen this question mentioned here before but nothing I have tried will work. I have a application that contains two items at the moment. List of Employees List of Training for Employees The form for submitting a training
Customer Portal URL
I added the domain in the Customer Portal URL area. But when accessed by the new domain, the application does not appear.
Change value of a radio button (disabled in the form) based on the values of other radio buttons in the same form.
Hi, I have a form named "MANAGER" inside which I have 5 radio button fields with each 2 values: "OK" & "NO". I would like to configure in the same form another field named "STATUS" (disabled in the form) that would also have 2 values "OK" & "NO". This
Enable field workflow based on formula field not working
I have a formula field with an IF statement that returns either "1" or "2" I need to enable another field based on if the result of the formula field is "2" I have created the workflow, and the field is disabled by default, but when the result of the
Can you put a Currency field's symbol on the left of the field?
My currency fields show the correct symbol (£) but they put it on the right of the field (see screenshot). That's not how we use the currency symbol in this country. Can you change the currency symbol to appear on the left? Many thanks Steve
Export image fields as public accessible link
Hi there! I have a database with product master data and 3 image fields. I need to export/analyze the database through ZOHO Analytics and retrieve a public accessible URL of the product images. Example: Product name: iPhone 8 Plus 64GB Product image 01: https://www. ..... Product image 02: https://www. ..... Product image 03: https://www. ..... Do you guys have an idea how to achieve this? My workaround is to upload the pictures to ZOHO docs and paste the public to a text field, but that is
Importing data into a report
Hi, Im trying to import data into a report. One of the fields in the report is "Users" which in the form is a lookup field (Which looks into another report to pull all the users we have listed in there and displays as a dropdown in the form. However,
Can you add formula fields to a subform?
Is this possible? I have tried the two usual ways but they don't work: I've dragged the formula field from the field-type list on the left of the screen but it disappears when I drop it on the subform. I've clicked on "+Add Field" in the subform itself
Can you completely remove the Submit button?
I am trying to create a calculator app. It doesn't need to store data. And the result fields calculate as you add data into the input fields. There's no need for a Submit button (or a button of any kind). Can I remove all the buttons? Many thanks St
New User - Can I create ledger entries
I am just looking to see if I can use Zoho for my purpose, I want a table to show ledger entires ie opening balance, debits, credits, running total, I would then like the running total field to be shown on another form. Can I do this ?
Creating a customer in zoho subscription using data from a creator form
I am intending to create a customer entry in zoho subscriptions "on success" of submitting a form. I have created the following deluge script values = Map(); values.put("display_name",input.Coach_Name); values.put("email",input.Coach_Email); response
CPQ and product configuration
Hello, is ZOHO creator a good software to development a CPQ or product configurator? Can you please provide your feedback and experience about this? Thanks.
Stateless Form Validation - Cancel Submit
I have a stateless Guest form (which I have embedded in my website). I have logic that the requires the user to enter the guest names based upon their input in a Number of Guests fields. I need to ensure that they have completed the fields before they submit the form. Apparently the cancel submit function does not work for stateless forms. Number of Guests:3 Guest Name 1: John Guest Name 2: Tim Guest Name 3: In the example above, I would like to alert the user that they need to complete all the
Formula field based on 2 lookup fields
I have a form named "Clients" with a "client_name" field and a form named "Carriers" with a "carrier_name" field. In a separate form named "Policies" I have both the above fields as lookup fields. I have a field named "Policy_name" which i would like
Calculations based on fields in another form
I have a form named "Policies" with a radio field named "Commission Type" The 2 options for commission type are Percentage or Graded Commission based on the selection of Commission Type, users will either enter a number in a field named Commission Percent
Auto select Radio Button Option
Hello, Hope someone can help. I would like to know how to auto select a Radio Button option in one field based on the user input of another Radio Button Field. For Example, if the first radio field (colour) had the following options: Red Blue Green and
Attachment from another form into a email.
Hello, I have a Form (registro_ventas) which have 2 attachments in each record. I did a "Successl form submission" script that sends a mail to the advisor (advisorx) to inform that he has a new request, the mail has the formdata an the 2 a attachmente.
How to copy the application to my account?
Hello, I am looking for many solutions to my needs. He often finds prompts to copy the application to his account and use the code. E.g: Did you see http://creator.zoho.com/sampleapps/embed-search# application? You can copy the application to your account
Sending email with attachment "On Success"
Hi Zoho, I have a form that include uploading the file. Under some criteria, I would like to send the file as an attachment in email upon "On Validate" on form submitting. Since there is option to attach file only on schedule, this is my temporary solution, but would really like to be able to make it using the "On Validate" (both to shorten the lag and to be able to use the .old variables). Please let me know when this will be available. Thanks Ravid
Page editor frozen
Hello community, I hope you are very well. I´m having a problem a problem with my apps. I have a form with a few records, and I am trying to make a page with some indicators, so I went to the page editor, i took the "New Employees this month" Panel from
Creator - Integrate with Zoho Subscriptions or direct with payment gateway?
Hi, I'm really interested to hear your experiences of setting up customer monthly billing (i.e. subscriptions) with Creator? As a relatively new user I've looked at 2 options... 1. Integrate Creator directly into a payment gateway. It looks like Creator
Zoho creator users
I have a basic zoho creator account currently with no additional users. I use this admin account to create and edit the app. However, I would also like to be able to use the app myself as a 'user'. Running the app as the admin is clumsy as it shows too
Print template issue with dropdown on form
I am trying to setup a print template based on a form that includes lookups to populate dropdown options in several fields. When I try to add these fields, the text "ID" is added instead of the expected field link. The issue is best explained by referring
Customer Portal New UI URL
I am only now in the process of switching to the new New UI. I have switched to the New Live view for my user, and I see that there is a new url configuration to have other internal users access the New UI in CS5, I am wondering if there is an equivalent
Next Page