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
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
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
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");
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
Creating a Unique ID (GUID) in deluge
Hi, Is there way to create GUID in deluge? I will have to use this Creator. https://en.wikipedia.org/wiki/Universally_unique_identifier Thanks PS
I would like to develop an installment plan
Hello, I'm inexperienced in the field, but I'm trying to develop an expense app and I would like to add the option to pay in installments, so that the expense goes automatically to the following months, if anyone could help me?
focus on form field
when you click the edit button on a record the first field of the form needs to have the focus so i can type or tab to the right field without clicking again... tonythomas
Long multi line field. Page break in template
Hello. When I have a multi line field in my report that occupies more than one page, a previous page break occurs during printing and exporting to PDF. How can it be avoided? I have inserted in the template, the value div, both "page-break-inside: avoid"
Grouping or Summarizing Records
First, I accidentally came across ZOHO the other day. I must say the Creator is VERY impressive. I'm a programmer by trade but have no time use/learn .net or whatever to develop "quickie" type apps that I would use mostly for me. Zoho Creator seems to fit the bill for what I want. Congratulations. I have developed a little small time tracker type application (for me only) that allows me to enter data, hours worked and a category ( and a few other things). It works great. The only question I have
Default audit log on forms/reports/workflows on Zoho Creator
Namaskaram Zoho Creator team, There is no default audit log on forms and reports for finding that who and when the changes were made in a form/report. It is very important feature to track the form and report history.So basically we need to be able to switch on audit logs for any workflow. If I just go and tap on a checkbox, then all the activity happening in that workflow or using that variable should be captured automatically without any extra scripting. Crafted with ❤️ Zoho Gurus | Zoho Creator
Deleting from a Collection Variable
Hi All I have a collection variable, obtained like this course_Options = Schedule_Courses[Start_Date_Time == time]; This give me a collection variable of courses starting at the above time. If I wanted to remove one of the results from that collection
"If data has changed" function ?
Hi Zoho, I have a form with a name, date and type of a certain product. I need Zoho to run a function on "On Success" on Edit mode, ONLY if the date has changed (not if the name of the product has changed). Is there a function that can check "data before edit" or something like this? Thanks Ravid
Open another form as a Pop-Up
Hello, How do i open another form as a Pop-up Dialogue on click of Button which is a custom button in report? Can anyone help me with a code? Thanks
notification(send mail) when users delete record
The system notifies adminusers by email when users change or delete data from a report. It need to include the data in email so that adminusers know what data users have changed or deleted. When users make a change, the data is attached, but when delete
Next Page