Passing a value to an "+ add new entries" form
I want to pass a value to an "add new entries" form. Take for instance the forms in the Zoho help example app "Dynamically adding items to a picklist" Back when that example was created it wasn't possible but now we can configure a look-up field to allow the addition of new entries. Let's say I didn't find the state I wanted for the selected country and wanted to add it. Since the "State" form in the example has a "Country" field, I wouldn't want to have to select the Country in the State form when
Passing data to a form invoked by clicking the "create new" button in a lookup field.
Here is the scenario... I have a form called "order". In this form I have a lookup field called "ticket" which creates a relationship with a ticket form. In this lookup field I have turned on the ability to add new entries. What I'd like to have happen is that when a user is creating a new order (using the order form) if they click "add new" to create a new related ticket, I'd like to populate some of the fields in the ticket form from data the user has entered in the order form. Is this possible?
Passing parameters to "add new add entries" form
Hello, It will be great to have possibility to have property for each field in form (checkbox) "pass this to add new entries forms". For example: Form "Clients_Requests" Lookup_field: "Client_ID". Checked "Pass this to add new entries" Lookup_field: "Contact_Person" with checked "Show a link to add new entries in Contact_Persons" property. When you click "Add new" for Contact_Person, new form is loaded and Client_ID is setted to "Client_ID" from "Clients_Requests" parent form "Contact_Persons"
Image field pan, zoom and crop feature
It would be nice to let users arrange the images they input in image fields by allowing them to pan, zoom the image. Nowadays this is a standard input method used in most applications, so I think it will be very useful.
Zoho Creator Upcoming Updates - December 2023
Hello all! 2023 proved to be an action-packed year for us at Zoho Creator. Riding that momentum, we're geared up to conclude the year with a bang! Here are this month's top highlights: Zia Assistant powered by OpenAI Custom APIs Support ticket tracker
Zoho Creator New Function "Focus"
Hello Team So, Zoho Creator has launched a new function called 'Focus'. If you have a Zoho Creator form and want to draw the user's attention to a specific field, you can use the 'Focus' function, which only works in Zoho Creator. For more details, please
Check for Duplicate Date Range
I am trying to update my reservation application to check for units already booked. For a specific property, the unit is booked from a start date to an end date. What I am trying to do is to add code to check if some one tries to add another record where the from and to dates overlap. For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Value in a dropdown should give automatic update in date_tim
Hi I would like zoho automatic to update a date_time field to current time, when a value in a dropdown is set to a certain value. How can this be done! BR Skouboe
Update Subform items based on main form status
I am working on a deluge script to update the status of a subform ( "Samples"). The individual items have a "Status" that should be updated when the main form "Status" is updated. I have set up the workflow as a conditional workflow that executes only
Tip #25: How to add background images to forms
Hi everyone, The world is going through a difficult time right now, and we hope you're all staying safe. We're here with another Creator tip—this time on how to add background images to your forms. Sometimes, to add some context or make your forms look a little better, you may want to add a background color or an image to your form. Let's go over the three easy steps it takes to get the job done. Use case In this example, we have a New Order form, and we'd like to add the company's logo to it, to help establish better
Zoho Creator | Introducing Augmented Reality
We're delighted to announce augmented reality (AR) in Zoho Creator! Now, you can set up your own immersive 3D experiences—combining a glimpse of the real world with computer-generated graphics. AR technology augments what you see, by superimposing digital
Problem with Expenses App
The sub-categories are not populating with the Category selection. Meaning once I click the category, the sub category has the full list to choose from which is very annoying instead of just the subcategories that are associated with the particular category I selected.
What is best method to link or lookup tables with encrypted fields.
I am testing out Zoho Creator for making a HIPAA database to keep track of patients and their appointments. I have two tables: Patients and Appointments that I would like to be related as one-to-many (one patient can have many appointments). Per these
Customer portal users and data visibility on reports
Hi, Suppose I have two companies Rocket Science (RS) and Quantum Politics (QP) as my customers. Both companies access the application through the customer portal. When a customer portal user RS A fills data in a form, the user RS A can view the data in the corresponding report. The same is true for a customer portal user RS B. The user RS A can't see RS B's data and the user RS B can't see user RS A's data on the report. If permission set is configured to "View all", then all the users will see
IF-THEN write formula
I am having trouble creating a simple IF-THEN statement that will yield a text description of a number field. This is a common Excel formula and it may be easiest to show how I'd write in it Excel: =IF(Number_Field<100,"Under 100",IF(Number_Field=100,"Equal to 100", IF(Number_Field>100,"Over 100"))) This formula looks up the number in Number_Field and writes, in another column, whether that number is "Under 100," "Equal to 100" etc. Is there a way to do this using the built in formula generator
Creator Page that Has Charts Filtered by CRM Account
We use Zoho CRM. We also have a Creator application called Reports that captures monthly reports with detailed metrics for each CRM Account. We use the Creator integration widget to pull the Account from the CRM and make it part of the Creator record
Subforms added after main records creation have "null" IDs.
Hi Zoho Community, I added a subform (pre-populated) to my main form. I want all existing records to have this pre-filled subform. When I manually edit an existing record, I can see the subform and the pre-filled values. But it does not show in the report
Implement an API call using Oauth 1.0
Hello Everyone; I am trying to communicate with another web application using an app in Zoho Creator, which happens to use Oauth 1.0... The problem is, i am able to test it using Postman successfully, but i can't write the code in deluge to authenticate, specifically to produce the nonce and timestamp needed in Oauth 1.0 protocol... Has anyone successfully wrote a code to authenticate using Oauth 1.0 protocol? Can you share how to make my code succeed? Thanks in Advance
Kanban doesn't trigger workflows
Hello, Im trying to use a Kanban view of my list, but i'm noticing that moving my objects on the kanban doesn''t trigger any workflow, anyone else having this problem? I have a form edited sucess workflow, and it doesn't work if i edit the "deal stage" trought the kanban view, only if i edit it.
Populating a picklist another form
I am creating an App for ATTENDANCE MANAGEMENT for a School. I have the forms: - Students (Form1) - Classes (Form2) - Attendance Management (where I monitor the ATTENDANCE of students PER CLASS) (Form3) In the ATTENDANCE FORM (Form3) I have the fields:
Get the future date a number of days from the date in a column in a Pivot Table
Hello, I hope that someone can help me. I have a pivot table which has a column with dates in it (Date A), I wondered if it is possible to create a new column that shows the date 180 days from Date A. Is this something I can use a formula for? If so how
iframe code: diff between view-embed and report-embed
Using Zoho Creator to enter local nonprofits and sort them, then displaying them on Zoho Sites. A while back a developer helped our sister site get up and running. I noticed that they were not publishing reports and using the iframe code to display them
Inquiry Regarding Accessing Multi-Select Field in Pivot Chart
I'm currently working on a project and would appreciate guidance on accessing and utilizing a multi-select field within a pivot chart in Zoho Creator. Could you provide instructions or resources to help me implement this feature efficiently? Your assistance
Print Option Accessibility Issue in Zoho Creator
I hope this message finds you well. I'm encountering an issue within our Zoho Creator application where I'm unable to access the print option when combining forms and reports into a single page. As printing is vital for our workflow, resolving this matter
Page - Gauge - Target Values
Is there a way to make the Target and Maximum values say a formula or query? For example, total sales for the month = 109 and I want to make my gauge today's percentage.
Zoho Creator how to publish forms specific to each client in the Zoho Creator App.
Hi I see how you can publish a specific form to be able to access it externally. But what if I had a Zoho Creator App that multiple clients on it and I wanted to publlish public forms that are specific to each client? Such that I can embed those forms
Zoho Creator - [Free Webinar] Application Development BootCamp 1.0 - 3 Day Series
Hello Everyone! We are thrilled to announce the addition of another exciting webinar for all of you, titled APPLICATION DEVELOPMENT BOOTCAMP 1.0. About Application Development BootCamp 1.0 Application Development BootCamp is a dynamic three-day webinar
Passing Data about a record through a custom button
I am trying to pass data from the record where the custom button is pressed. Do you pass them through the arguments of the function, but the function is outside and not linked to that particular record. How do you go about doing that? Thank you for your help
How can I get records from zoho people in zoho creator?
I try to get all employees from zoho people in creator using deluge I faced this error
Nesting one searchRecords function inside another
Hi all, I am trying to nest one searchRecords function inside another, but when I attempt to save the Deluge I get the following error: Error at line number: Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Support Inquiry for Website Development Issues
Hello, If I encounter any issues with the website I have developed and launched on the internet, how can I contact you to request a programmer to address a problem I have on the site and receive a prompt response? Do you have a WhatsApp number or customer
How do you add pagination to a Zoho Creator Page with zoho.crm.searchRecords
I have the following Deluge query which is correctly searching my records of up to 20 records per page, up to 5 page: l_Pages = {1,2,3,4,5}; m_SearchParam = Map(); m_SearchParam.put("sort_by","Registration_Date"); m_SearchParam.put("sort_order","desc");
Amount in words in Indian format
Hi, I had coded the following code to convert amount in words. But in the code in the format of US like million. But i need in Lakh and Crore. So pls suggest ideas r post corrected code string Num2Words(int val) { val_s = input.val.toString(); th = {"", "thousand", "million", "billion", "trillion"}; // uncomment this line for English Number System // th = {"","thousand","million", "milliard","billion"}; dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight",
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widgets and extensions in Zoho Creator - Part 3
Hello Everyone! About the Creator Tech Connect series The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while building
Inquiry About Zoho Creator Free Trial and PROFESSIONAL Version
Hello Zoho Creator Team, I'm right now using the free trial of zoho creator and I am interested in upgrading to the PROFESSIONAL version, Will my existing applications receive PROFESSIONAL version advantages upon upgrading? Regarding the "No.of Users"
Best way to add custom CSS to Zoho Creator App
Hello, I'm using Zoho Creator to develop a custom app and I was wondering: what is the best way to add custom CSS? I'd like to use classes and ID's in HTML Snippets so I can control styling from a custom CSS file I'll create. Thank you
How to use deluge scripts to insert rows to subform
I have 2 forms, Box form with Seed_Packs entries that links to another Form Seed_Inventory entries. After I have use the import functions, the entries did not link from Seed_Inventory to Box.Seed_Packs, I want to use scripts to do the linking by creating
Stateless Close Pop-Up Window
Good day, I have a pop-up window with a Stateless form, when I click a button it should close the window, initially it works fine, but now the window stills open, I use the following script openUrl("javascript:window.close ", "Same window"); Best Regards,
How to create grouping a report in scripting ?
Hello Guys, Is there any possibility to group the records in the report by scripting. Scenario : If the user click the panel in the page .the report will shown as popup . I am also set a criteria by using Query parameter. Is there any option to group
Verify user permissions for form or report
I'm trying to write a custom function to determine if the current user has access to a report or form. Something like variable = canAccess(<report_link_name>); Is there a function that returns which roles have permissions to access a particular report
Next Page