Deep/complex UI
Is it possible to create a form that allows you to work with more than 2 levels. For example, creating an order to sell widgets. Each order will have one or more widgets. Each widget can have a different size, and number/type of drawers (e.g. 1 ring
how to pass basic auth using getUrl() function
Is it still the case that zoho getUrl does not support basic authentication? Someone suggested a workaround here, but I'm new to web programming so I'm not sure how to do it. https://help.zoho.com/portal/en/community/topic/geturl-posturl-cannot-pass-authorization-key-in-header-map Does it involve setting up another server to run PHP and have my ZC app talk to that PHP for every single API call? Any someone elaborate?
Retrieving custom field into Zoho Creator from Zoho CRM
I have one integration field that provides me the account name from the accounts module in Zoho CRM. It works fine. I would also like to populate another field with a custom field value in the Accounts module for the same account. For example the account
What (if any) reason would there be to NOT use bidirectional for all relationships?
I'm trying to understand a situation where one would NOT want to use a bidirectional relationship. It seems bidirectional relationships provide more flexibility with data manipulation in the future, and it seems it would be tough to move from a unidirectional
Prefilling name fields and address fields using URL parameters
Hi, quick question: In my Zoho Creator form I'm using the standard name and address field. How do I prefill those using URL parameters?
Lookup displays as field ID rather than contents
I know I've come across this before, but can't remember for the life of me. The add record code I have is this; Where Users is a lookup field (basically a form that contains a list of staff). The line that starts "Description=" produces this; whereas
Conditional Alert Message If Another Form Populated
Hi community, I'm building an application that has a "Settings" form. The settings form will provide logic to other forms throughout the application. When a user opens another form in the app, On Load, I want the application to check whether the Settings
It's time to evolve: Upgrading to Zoho Creator 5
Dear App Creators, With our commitment to continually refining and improving our user experience, we're gearing up to upgrade all accounts to Creator 5 on (UPDATED) from December 1st, 2020 , in phases . In other words, from this date forward, all your
Custom SMTP Settings
In the admin's account settings, provide a way to enable custom SMTP settings so that any sendmail script will route thru another SMTP server rather than ZOHO's. Example: Amazon SES now offers sending mail via SMTP (as well as an API). The typical settings for their SMTP server are as follows: Server Name: email-smtp.us-east-1.amazonaws.com Port: 25, 465 or 587 Use Transport Layer Security (TLS): Yes SMTP user name: XRASRT565FGR8909 SMTP password: XRASRT565FGR8909XRASRT565FGR8909 I'm not sure if
Zoho Creator Published Form on Wordpress Page
Tried using the embedded iframe and perma link on a Wordpress page for a published Zoho Form, however, Wordpress won't show the form. Am I missing something?
Ability to clear the search criteria on a page
I have a Zoho Creator 'page' with a search box, which sends the search term to a 'report' on the same page. This works nicely, except there is no way to clear the search criteria....the only option a user has is to enter another search term (which is
How to convert firstName.lastName@domain.com email to a proper name in formula field
I'm having difficulty converting an email field into a proper name. The email address all are firstName.secondName@domain.com Here is what I've created in a formula field based on the "Primary_Tax_Partner" field but it only seems to work sometimes: (input.Primary_Tax_Partner.getPrefix(".")
Community Webinar: Integrating Zoho Creator and Zoho People | October 27, 2020
Dear developers, Thank you for your support and encouragement towards this initiative. We hope to continue our efforts in creating an extensive knowledge base for our developers. Next up is a session on "Integrating Zoho Creator and Zoho People". Date:
How to integrate Record to external database (MySQL)??
I wanto to send data in 3 fields when my new record add, or record updated to MySQL Database outside Zoho Creator For Example: New Zoho Creator Recorded Added=> Send data to MySQL database for new Line adding Store Order Number Order Status A
Gantt Chart
Is it possible to create a gantt chart in Zoho Creator?
Convert a string to date
1) How can I convert a string (numeric) to a month or date format? For example: I have a field that contains one numeric string: like 0-9. I would like to convert this into month format, such that when the string is "1", the month will be January, when the string is "2", the month will be February, when the string is "3", the month will be March, and so on.... I tried the toDate() function, but it did not return a value. 2) On another note, i tried the getMonth() function on a form field (DATE type),
Zoho Creator as web app to handle results from scraping / API response
Hi, I am planning to scrape thousands of URL on a daily basis. As an alternative to handle this all in Python, I am evaluating, if this would be feasible in ZC too. Typical workflow: * List of URLs is generated in ZC* List of URLs is send to an API
IT Asset Tracker app Search by QR Code
I am setting up the IT Asset Tracker and I would like to be able to search by a QR code via the mobile app. I am able to use a QR code to input data in form fields for Add New Hardware. But when I click the search button on the All Hardware page, I am
CAUSE=INVALID_PASSWORD
Hi I tried generating an auth token but getting an error whenever i added the url in the browser kindly help. See the full result below #
#Tue Dec 01 08:05:54 PST 2020
CAUSE=INVALID_PASSWORD
RESULT=FALSE
postUrl returns 201 and never reach the target URL
I am working to get an app hitting webmerge url with postUrl. But from Webmerge's logs and reports, it seems like my request never made its way to their endpoint. So I decide to debug the postUrl response and what I got is this: {"responseText":{"success":1,"queued":1},"responseHeader":{"date":"Thu,
Searching by Lookup Field Stopped Working
Hello, I have code that has been working for years suddenly stop working a few days ago, around 2020-Dec-03. The lookup field used to have Field Name "HH ID", Deluge Name "HH_ID" and Field ID of "HH_ID_ID". Despite the awkwardness it worked for years.
Zoho Creator to Zoho CRM - Create new record with attachments
I am trying to create a new record in our CRM when a new record is created in Zoho Creator. This works well with simple fields, but I am having trouble figuring out how to pass out an attachment. link1 = "https://creatorexport.zoho.com/paulina108/dev-app/View_All_Visits/"; recordid = input.ID; link2 = "/patientAttachments&privatelink=9C2k9U29NCUwF7XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; attachmentURL = link1 + recordid + link2; I would then use this URL with zoho.crm.attachfiles as the file object along
Can I POST file content with invokeURL to a webhook?
Hi, As in the docs is not very specific of posting file upload to external webhook with invokeURL. Am I able to send the file content of a file attachment from a Creator form to an external webhook with POST request? Thanks
Pass value back from stateless popup to calling form
If #Script:page.close is used to close a stateless popup window, are there any methods for passing values back to the "calling" form without reloading the calling form and losing any entered info? I'm trying to zero out the calling radio button's value if my popup's Cancel button is clicked. @damien?
Collapsing Group items in a report view
I have a report grouped by purchase order number and beneath each PO I have the line entries for each order. I would like to have these collapsed so that they all fit on one screen and the operator can expand them if needed. Is that possible? I would
Cannot get authorization code for API purpose
When my external server get response from ZOHO the browser doesn't allow to show the link screen to connect with my ZOHO account. I enabled cookies for third party on chrome and also removed any extension from the browser.
Upcoming updates - October-November, 2020
Hello App Creators, We'll be rolling out the following updates in the next 4-5 weeks: Support for encrypting IP addresses Applying permissions while printing and exporting Using pixels to specify font size in pages Connections for panels and Deluge integration
Close Tab With Submit Button
Hello, I have a link in Zoho CRM that opens up a Zoho Creator form in another tab. I would like the "Submit" button in the Zoho Creator form to then close out that tab. Thanks,
How to display zoho.loginuser and zoho.loginuserid on Page
Hi, I would like to make a page with user name and user's e-mail address. It might be very simple thing, but I could not find a documentation about how to display zoho.loginuser and zoho.loginuserid on page by using script. As I am not a programmer, I tried print(zoho.loginuser); write(zoho.loginuserid); by putting after <%{%> or <%{ but nothing worked. Can anybody help me to make my page work correctly? Thank you very much.
Where is the 'public link' for reports in Creator 5
Hi there, I am upgraded now to Creator 5, but my public reports are no longer working. Answers to either of these questions would be helpful: 1. Where do I find the public link for a report in C5? 2. Where do you now publish a page in C5
Zoho CRM Integrating Google AdWords with zoho creator forms
Hi I would add to my forms created with Zoho Creator the Google Adwords tracking for Zoho CRM. I followed this guide https://www.zoho.com/crm/help/google-adwords/configure.html It's not clear where I can put the follow code in Zoho Creator forms: <input type = 'hidden' id = "zc_gad" name = "zc_gad" value = "" /> In the guide I have to put it in <form>...</form>, but I have not the entire code of form from Zoho Creator. Please could you help me? Thank you
Zoho runs so slowly!
Hi The speed on Zoho Creator is almost unusable sometimes, such as at the moment. We have a fair bit of information on there as we use it as our database for an office, with 25 users. However it is becoming more and more difficult to use and everyone
PDF and Print buttons not appearing on Zoho page
Just upgraded to C5 and found one of my pages does not offer the PDF or Print buttons....despite being enabled. Anyone had this problem?
Como hacer que diversos elementos de las paginas carguen los datos de un intervalo de tiempo
Hola, tengo una aplicación de visitas comerciales y técnicas y en algunos de sus elementos me gustaría que se cargaran los registros del ultimo mes, por ejemplo. Mi problema es sobre todo en un grafico circular, en el que se divide el numero de visita
deluge script on subform fields
Maybe it's just me, but I'm not really liking the new format for workflows. I find it cumbersome to have to create a new workflow for just about everything when before we could put several different types of workflow into one. In any case, with the
Size of Widgets in Creator - How to resize to just single line or double line?
... Happy Morning! We have custom widgets created for display of timer, messages and metrics... how do we resize these widgets to single line or double line of font size 12. the current size of widgets is too big for what we need on a page Thanks K
Community Webinar: Working with Zoho Creator’s v2 API: Examples and Best Practices
Dear developers, Our next webinar is a much awaited session on Zoho Creator's v2 API. Developer APIs are a core pillar of Creator’s extendability. They allow third-party applications to exchange data with Creator enabling a holistic and unified approach
Backups failing due to broken Schedule workflows
I am having endless issues in 2 versions of my app. In an app that Zoho took 3 weeks to recover by repairing a broken backup, I decided to use the Sandbox so I could roll back changes if it broke anything further. Big mistake. Creator could not publish
Can a customer portal user change his email?
Hi, I would like to know if a customer portal user can change his email? Because sometimes we want to create the account for the user (a customer portal user) and fill it with data and give it to him for testing instead of just inviting and then asking
Email Notification Dashboard/Report
Hi, A report containing the Email Notifications sent by Zoho Creator, whether it has been delivered/bounced/opened/clicked etc. is a much needed feature. Ability to export these reports is also needed. Some times, customers complain that they haven't
Next Page