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.
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
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
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
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.
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
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
Creator IDE documentation or examples?
I'm trying to filter a report based on attributes of the user. So depending on which company the user works for they should see data filtered a certain way. For example, market pricing based on the market of the company. So I'd get the user, figure out which company he/she works for an then add an attribute as a parameter to the report. This seems like something that should be very easy to do in the IDE, but I can't find any documentation on the Creator IDE to even gives you a hint of where to
Is there a function to determine if a user is an app user or profile user?
Anyone know of a way to determine whether a user is an app user or portal user? If it existed, the function would look like this: zoho.loginuser.isAppUser(); My specific use case is that I have a Portal_User form that has a subform which is a cross-reference
The process of Country,State & City as a dropdown
The process of master entry form for list of data like Country, State and City with inter-related connectivity : Simple process structure Firstly, You need to login in your Creator portal with your credentials.After that, You can follow below steps one by one for creating master entry forms for Country, State & City. So please follow below steps... And Entry & Listing Forms...
How to fetch data based on date range
Hi ; I am trying to fetch data from Labor present in site today form based on date ranges using two date fiellds. 1. Start date ,2. End date and Contractor name. If the user selects the contractor name and selects date range using start date and end
How to attach a Creator pdf record template document to Zoho CRM?
Hi there, I have created an app to process work requests. The user inputs data to a Creator form - on submission this is sent for approval and when approved a confirmation email is sent to the submitter along with a pdf template record of the submission
Can't Duplicate Application
I have an application on my dashboard that will not duplicate, the other 2 applications duplicate no problem. is there something special i need to do?
Conditional attachments in sendmail function
I would like to have a hand-full of checkboxes that say "Invoice" , "Contract" , "File 1" , "File 2" etc. And when each of the checkboxes are checked, I would like to add them as Attachments in a sendmail function like so sendmail ( To : input.Client_Name.Email From : zoho.adminuserid Subject : input.Subject_field Message : input.Message Attachments : "all checked boxes" )I tried creating a list with all of the boxes that are checked
Next Page