Creating URL in deluge/HTML
Having difficulty adding target=“_BLANK” to a URL I’m creating. I have dispLnk = "<a href='" + i.URL + "'>" + i.Title_Name + "</a>" + " - " + i.Description; where i.URL is a companies site, i.Title_Name is the company name and i.Description is their tagPassing 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.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.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 onlyProblem 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 theseCustomer 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 seeCreator 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 recordSubforms 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 reportImplement 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 AdvancePopulating 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 howPrint 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 matterZoho 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 formsZoho 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 webinarHow 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 errorNesting 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 expressionSupport 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 customerHow 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 buildingBest 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 youHow 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 creatingStateless 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 groupVerify 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 reportCreating 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 PSLong 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"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 CreatorDeleting 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 Ravidnotification(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[Free Webinar] Learning Table Series - Creator for the Real Estate Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experiencereload the parent page
Hi, I am trying to reload the parent page with On Add -- On Success Action.I was trying to with below code that closes the popup window but not reload the parent page. Could anyone please help me ? openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:page.close", "same window"); openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:page.parent.refresh ", "same window"); Below is the screenshot: Thanks ArfaterCannot Publish Application Due to a Problem
Hi guys, Just stumbled upon a confusing error when trying to publish an update for our existing application. We stumbled upon this error: "An error occurred while fetching the Form Field Order that belongs to the 'Biaya Promosi' subform of the 'LaporanMultiple user viewing permission
Hello! I'm building and app for users that will connect with the customer portal. Many companies with many users will use this app. For obvious privacy purposes, I need to have a filter for the users of the same company to see only their records. For example, company "A" has 3 users, U1, U2, U3. U1 must see and edit U2 and U3 record...an so on. Is there a way to do that with Deluge? As a admin, I will manage the users in each company in a form. Thank you very muchAutopopulating lookup fields from multiple forms
Hi all, Been struggling with this issue for a bit and I feel like it is pretty simple, but I am just missing something obvious in the workflow script so any help for a beginner would be greatly appreciated. My goal is to have different forms auto populateZoho Creator to CRM Subform issue
I'm trying to move entries from creator to CRM. In this case, the entries create a new account on CRM and transfer the information in the subform as well. Deluge is saying that there is an error in line 5. The sub form in creator is called SubForm and the one in Accounts is called Products Requested. Please help me out with this accountInfo=Map(); accountInfo.put("Account_Name",input.Name); accountInfo.put("Account_Site", input.Class); productsList=List:Map(); for each Product in input.SubFormSet default focus field in published page
I am working on a queue application for my organization. We have a touch screen kiosk in our lobby to allow for customers to check-in to the queue. Since the customers will often be checking in with a barcode, I would like to find a way to make the topNext Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Free Webinar] Product Updates: Quick Catch-Up Session - Part II - Creator Tech Connect
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions designed for developers, administrators, and app builders.[Free Webinar] Learning Table Series – Education Management in Zoho Creator
Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. About the Learning Table Series The Learning Table Series is a free,[Free Webinar] Product Updates: Quick Catch-Up Session - Part I - Creator Tech Connect
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions designed for developers, administrators, and app builders.[Free Webinar] Learning Table Series - Creator for Infrastructure Management | A Partner-driven collaborative session
Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. About the Learning Table Series The Learning Table Series is a free,[Free Webinar] User Management in Zoho Creator - Creator Tech Connect
Hello Everyone! We welcome you all to the upcoming free webinar on 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
Most Discussed Topics
Passing a form object to a function
Suppose I have a sort_order field in multiple tables and I want to increment it by +1 onCreate of a new record. Is there a way to pass the form object as an argument into the function to keep things DRY? The following function from Zia works, but I'dResend Client Portal Invitation + View Email Delivery Status
Hi Zoho Team, We hope you are doing well. We would like to request two important enhancements related to the Zoho Creator Client Portal invitation process. At the moment, when we add a user to the Client Portal, Zoho Creator automatically sends an invitationPrinting from Zoho Creator hosted on my own server to printers hosted on my clients local network
Hello. Fairly new to Zoho Creator and looking for best options to be able to print from my application hosted on my own server to any printer hosted on my clients own local network. Any advice is welcome. Thank you.Zoho Creator Form Search
I'm new to Zoho Creator and so far i do like it but im shocked there seems to be no easy way to add a search function and/or navigation to there forms as this readily available in every platform i have used in the past. Anyway i have a form which i haveOpen a record to edit based on another form being edited
Hi all, I am trying to edit a record based on another record being edited. It works out like this: When I create a Monthly_Update and then submit I open the Monthly_Levels form and pass the ID from the Monthly_Update to a field called mu. I want it to
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.