escape new line character
Hi, I would like to check if a string contains a \ character (backslash) I try this: if ((input.invoer).indexOf("\") > 0) { found = true; } But the I get the error: Error at line xx : Script contains new line character, kindly remove it and try again. I have tried ("\\") but that doesn't work So how do I do this?Field/Column Width in Subforms
I am new to Zoho. So far I have like all, but I am having difficulty with the limitations of the sub-form paradigm. Is there a way to set the column/field widths that are displayed in a sub-form. It seems to be forcing equal field widths, and I can't find a way to change. If i set the pixel width in the originating form, but those default back to mandatory widths when displayed in the main form. Thanks in advance for any suggestions.External data sources in Zoho Creator, powered by Zoho DataPrep
We’re thrilled to announce that you can now expand your data connectivity capabilities by integrating external data sources with Zoho Creator with help of the new Zoho Creator connector within Zoho DataPrep. This exciting feature allows you to connectAdd a portal user form within an app.
Hi, Is it possible to add a portal user via a button from within an app? I tried some code from ChatGPT, but unsurprisingly it didn't work. I want to this as a time-saving measure, i.e. one customer can have a different role and be able to allocatePopulating a field with a customers name based on their email
Hello, I am trying to auto-populate a field with a customers name base on the email address which they use to login. The email address they use to login is the same as in their customer details. Their name and email address is on a form, called customerGoogle Places API
Hello! In the application I am building I would like to be able to get the Google Places AutoComplete look up for Address. How would I imponent this into a form instead of using the default address field where you manual have to add it in. The reasonMap with "\" when adding text variable
Hi all, I'm trying to create an invoice on Quickbooks from Zoho Creator using the intuit.quickbooks.create deluge command. How it's supposed to work is that the user selects all the Invoice lines from a report, and then it clicks an "Invoice" button that will execute a function to create the Invoice on Quickbooks. To get the Invoice Lines data I'm using the following code: //Generate Invoice Lines InvoiceLines = Map(); LineNum = 1; AllLines = ""; for each line in getRevenues { InvoiceLines.put("LineNum",LineNum);How to Upload Report in zoho drive from zoho creator as a pdf
Hi, I am using Zoho Creator and am sending an email to the customer with a copy of its record Now I want to upload this pdf file into Zoho WorkDrive how do I achieve this?Error: Improper Statement
My Code: htmlpage Frame(Display_Booking) displayname = "EmbeddedView" content <%{%> <div elName='zc-component' formLinkName='Display' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&Display_Booking=<%=Display_Booking%>' >Loading Form...</div> <div elName='zc-component' viewLinkName='Booking_Summary_Report' params='zc_Header=true&ID=<%=Display_Booking%>'></div> <% Userselectedid = input.Display_Booking.toLong();Loading multiple images efficiently in Zoho Creator
I have an app in creator that is linked to a report template in Zoho Writer. One of the fields is a sub-form just for uploading images. Upon successful merge, the images uploaded through the sub-form will be arranged as a table with single column in theZoho Creator Upcoming Updates - October 2023
Hello all! As we step into the final quarter of this year, we're ushering in a fresh wave of improvements and new features to supercharge your experience with Zoho Creator. Join us today as we present the newest updates and enhancements for this month:QR Code generation - native
All, FYI Google have recently depreciated their QR Code API refer: https://stackoverflow.com/questions/55021765/deprecation-of-google-infographics-qr-codes Annoyingly, this has meant we needed to change our links over to another provider. Creator team:How can I access associated form data using JS (trying to build a widget)?
I have a widget page that offers a detailed view of a record of my Projects form. I have other forms associated with the Projects form and I wanted to display their data as well. I have tried doing it like this: document.getElementById("Assessment_Date").textContentSchedule a function that exceeds number of statement execution limit
Hi guys, I've got an error on a schedule that I'm running to update the age of my service users. It says the number of statement execution limit is exceeded. Each day I use a schedule to run the following function: void update_age() { for each rec inCant Access Zoho Creator
Hello, I am having an issue accessing the zoho creator page from my Zoho login. I had been working on an app for well over 2 hours with no issues, then suddenly I got the attached error. My login still works for our other zoho services like zoho invoice, but no longer for zoho creator. I can log into the zoho creator mobile app, but my records are blank-only when I click edit do I see the information entered. I am the administrator on the account and no other uses have access to these apps and data.InteGreat 03: Integrating Zoho Creator with Zoho Books
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Zoho Books. This is one of the most popular Zoho integrations that our customers use. You can use this integration to automate processes like: Creating quotes and invoices in Zoho Books from within Zoho Creator Accessing quotes, bills, and invoices from within Zoho Creator Linking bills and invoices to a project and performing profit calculations With Deluge, you can use the built-in integration task to connect with theHow to create a budget remaining field
Hi all, I am trying to figure out a way to display a field that takes a total budget figure and subtracts it by all the associated records with that specific tag to have a remaining budget figure in the budget form. Budget Form: This form is where theA major warning to Zoho Creator Users about backup limitations
Hello everyone, I felt compelled to write this topic to warn fellow Zoho Creator users about what happened to my business and the potential risks to yours. A piece of rogue deluge script in our system deleted thousands of records which had multiple linksHow to push item name from Zoho Books to Zoho Creator using Custom function?
There are multiple module in Zoho Books, Suppose I need to push data of Estimate into Zoho Creator, I have created similar form in Zoho Creator as well as I made a connection with Zoho Books to Zoho Creator. I am able to push other data except this ItemHow can I display lookup field data on a widget page?
I have a widget page that offers a detailed view of a record of my Projects form. I have other forms associated with the Projects form and I wanted to display their data as well. I have tried doing it like this: document.getElementById("Assessment_Date").textContentUndestanding execution limit
Hi, i'm trying to understand the execution limit on creator's function. So, take a look to this screen: This snippet work. But if i add: i reach execution limits. Also if a wrote ONLY if (condition) {} this if gives to me an execution limit error. ButProblem with record summary send mail inline
Hi guys, I'm having an issue with multiple elements of a record summary not showing up when sending as email inline. [ from :zoho.adminuserid to : SUrec.Email subject :"We value your feedback" message :"" Attachments :template:Send_feedback_email as InlineHELP! Re-Order Blocks on Report Detail View
Is there any way to simply re-arrange the order of the blocks on a record's detail view? I'm showing that you can re-arrange the FIELDS however you'd like, but the blocks can not be re-arranged. This is a VERY BIG MISSING piece. Any possible update coming on this?Zoho Creator | Panel not saving after editing keeps on loading.
Issue with Embedded Report Not Retaining Filters/Sorting/Grouping on Refresh
Hi, I’m encountering a significant issue with embedded reports. While filters, sorting, and grouping are saved in browser cookies and correctly applied when reloading the page, this functionality doesn't work for embedded reports. It seems that embeddedDetail View Layout - Reorder Block Option
Dear Creator Support, Would love to have an option to drag/drop the Blocks to reorder or add new blocks. It's a big hassle having to delete all the existing blocks to add new fields/sections to the Detail View, then re-add the previous information.Why am I getting this error?
Can someone explain why I would be getting this error?Zoho Creator Widgets - Do we have any option to test the widgets in Local Server?
Our current process We make changes in the widget code We pack and upload to Zoho creator then we do the testing after adding to the page. Is there any option to test this from local server? ThanksURL for downloading uploaded file - THE SOLUTION
Hi, I would like to share the solution for downloading uploaded files using url. There is no documentation for it and there are multiple forum threads with old solutions that didn't work for me. Here is the updated url - tested and works! fet = form_name[IDHere's how to set a numeric field to null or to blank
I'm not sure this tip is discussed anywhere, so I thought I'd share it. When a form has a numeric field, it initially is blank (assuming you have not given it a default value). However at runtime, once you give it a value, you are not able to clear the field again.with a script unless you click the reset button or reload the form. Unfortunately, that will clear all the fields in the form, not just the one field. Although you can compare the value of a numeric field to null, you cannot assign aFetch Records
Hi, I'm trying to autofill a form based on another form using fetch records. When the user inputs a name, I want it to auto-fill an address. I've put this under "on user input" for the account name variable. When I use the code below, it gives no errors. However it doesn't seem to do anything. It doesn't populate the address field in the form, and does not add the data to the table on form submit. What am I doing wrong? TableLink = Account_Information_Form [ Account_Name == (input.Account_Name_from_Order).toString()];Auto remove corresponding record from subform report
I have a main form with a subform in it. So lets say I make an entry in the main form, and make two entries/rows in the subform and hit submit. Now, the subform report should have two entries in it. But now, if I go back and edit the main entry and removeWhat does this error mean?
Can someone explain what this error means when I try to update my deluge script?Collapse/expand groups en report view
Hi! We suggest adding the indicated functionality through a report configuration option when defining grouping criteria. Thanks, Eduardo SantanderJSON not well formed error
Hi, can anyone tell me why I always get JSON is not well formed error message if I try to create a new contact in Zoho Books with the following code? Error message: {"message":"JSON is not well formed","code":1038} response = zoho.books.createRecord("contacts", "123456", { "contact_name" : input.first_name, "company_name" : input.account_name_company, "contact_persons" : {{ "salutation" : input.salutation, "first_name" : input.first_name, "last_name" : input.last_name, "email" : input.email, "phone"Connections in Creator
A while ago, the way connections can be created changed so that ONLY the application OWNER can create connections. It makes it really difficult as a developer, because 1. the OWNER of the application rarely knows how to create a connection. 2. It is nearlyapi criteria Question.
https://creator.zoho.com/api/v2/customer.service_americaship/zoho-test-bed/report/Package_to_Shipment_Report?from=200&limit=200&criteria=Package_ID==“184063” && Shipment_ID==“83676” 在上面的链接中，&&条件不起作用，如果使用AND则不起作用。Reorder blocks in Detail View
It's been a long time in coming, but I'd like to thank the Creator team for finally allowing us to drag and drop blocks within the detail view. It's not a great new shiny feature, but it's these little improvements that make working with Creator a moreWhat does this error mean?
Can someone please explain what this error means when I try saving my deluge script?REST API in ZC Widget
Hi All, How can i run REST API in Widget. I have tried executing but an error is occurring. I have attached screenshot of error too. Here's the code: <html> <meta http-equiv="Content-Security-Policy" content="default-src * self blob: data: gap:; style-srcNext Page
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
External data sources in Zoho Creator, powered by Zoho DataPrep
We’re thrilled to announce that you can now expand your data connectivity capabilities by integrating external data sources with Zoho Creator with help of the new Zoho Creator connector within Zoho DataPrep. This exciting feature allows you to connectZoho Creator Upcoming Updates - October 2023
Hello all! As we step into the final quarter of this year, we're ushering in a fresh wave of improvements and new features to supercharge your experience with Zoho Creator. Join us today as we present the newest updates and enhancements for this month:InteGreat 03: Integrating Zoho Creator with Zoho Books
Hi everyone, Today, we'll look at how to integrate your Zoho Creator app with Zoho Books. This is one of the most popular Zoho integrations that our customers use. You can use this integration to automate processes like: Creating quotes and invoices in Zoho Books from within Zoho Creator Accessing quotes, bills, and invoices from within Zoho Creator Linking bills and invoices to a project and performing profit calculations With Deluge, you can use the built-in integration task to connect with the[Free Webinar] Creator Tech Connect series - Product Release Updates in Zoho Creator
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[Free Webinar] Learning Table Series - Creator for the Agriculture Industry
Hello Everyone! 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 experience by demonstrating how Creator can be used as a solution for various
Most Discussed Topics
Prevent deletion record if there is connected records
I want to prevent deletion records, if there is connected records in any other Forms or Apps in my solutionsIssue with Embedded Report Not Retaining Filters/Sorting/Grouping on Refresh
Hi, I’m encountering a significant issue with embedded reports. While filters, sorting, and grouping are saved in browser cookies and correctly applied when reloading the page, this functionality doesn't work for embedded reports. It seems that embeddedPopulating a field with a customers name based on their email
Hello, I am trying to auto-populate a field with a customers name base on the email address which they use to login. The email address they use to login is the same as in their customer details. Their name and email address is on a form, called customerWhy am I getting this error?
Can someone explain why I would be getting this error?QR Code generation - native
All, FYI Google have recently depreciated their QR Code API refer: https://stackoverflow.com/questions/55021765/deprecation-of-google-infographics-qr-codes Annoyingly, this has meant we needed to change our links over to another provider. Creator team:
Zoho Developer Community
Zoho DataPrep Resources
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
Zoho Campaigns Resources
Zoho WorkDrive 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.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continueZoho Creator User Group meetups in a city near you! - Oct - Nov, 2023
Greetings from the Zoho Creator team! We're hosting a series of Zoho Creator meetups in various cities across the globe, and we'd love to meet you there! Our meetups are a great opportunity to network with industry peers, exchange ideas and best practices,Zoho Creator - 2023 Release Projection 2
Hello everyone! Time truly flies when you're having an incredible journey, and today we mark the completion of an eventful and action-packed six months. It feels like just yesterday when we embarked on this adventure together with the launch of our newCelebrating our Zoho Community SuperBuds!
The SuperBud program recognizes the efforts Zoho users put in to help the rest of the community thrive and grow in their individual Zoho journeys. Be it the ZUG meetups or these forums, several Zoho users including our MVPs andZUG leaders, have stepped
Top Contributors
Damien Cregan
Sriram U
Vigneshwaran K
Ha Son Tung
MOHAMMED