Help with Deluge implementation - accessing reports variables from Sales page through code
Hello all, I have been struggling with the implementation for an app that I am working on and I would appreciate the assistance of the community. Brief Overview: The app is a Quote calculator/display page for on-site service sale. The sales agent will
Recent UI Change in Zoho Creator's Application Sections: A Step Backward?
The November 10 update to Zoho Creator's Application Sections, introducing drop-downs for single-component sections, seems to add unnecessary complexity. This change slows down user interactions, leading to a less efficient experience. What are your thoughts
Need help in ZML
Hi, I've design new page in ZML. I'm having an issue with the buttons, is there a way to reduce the button width? I can't find an option, is there some code I can copy? I appreciate any help... here's a screen shot - to make it neater. Thank you in
Can't fetch data from JSON response
I'm connecting to an external API with a postURL and saving the result to a 'result' variable. I'm getting the correct response, as shown in the screenshot below, but I'm unable to extract data from it with get(), getJSON, etc. If I manually copy and
Trigger Actions on Customer Portal Sign Up in Zoho Creator v5
When a customer signs up in the Customer Portal in Zoho Creator v5, how can I trigger actions, such as filling in a form field with their sign-up email address?
Beware: Formula fields not triggered when dependant value updated via script
I wanted to warn application developers of a fundamental issue with formula fields. Formula fields do not get updated when the value of fields they refer to are updated via script. Create a simple form with 3 fields: Drop Down list– ‘Drop Down 1’ - with a script on user input to increment a numeric field by 1 - input.Number_1 = (input.Number_1 + 1); Numeric field – ‘Number_1’ - with default value of 1 Formula field – ‘Formula_1’ - with expression “Number_1” setting it equal to the numeric field.
Unable to create many-to-many relation between existing subform and form
Hello, I'm trying to create a many-to-many relation between existing subform and form following this guide: Bidirectional relationship between main and sub-form | Zoho Creator Here's the structure. Form 1: Tasks - Task name (single line field) - Steps
Zoho Creator API - is there a way to retrieve reports of type other than List?
We are trying to sync data between Zoho creator and our dw using the below API; https://www.zoho.com/creator/help/api/v2.1/get-records.html However, we are unable to pull reports that are not of type List. The requests error out with: {"code":2930,"message":"Error
Customer Portal - Data Access
Hi there, Is there a way to enable customer portal users to see existing records (created by non-customers app users) ? I want to create a Customer Portal to enable clients to see product catalog, create orders, and see their history (orders, payments, etc.). However, their purchases and payments will be registered by normal zoho app users. The main purpose of the customer portal is to enable clients to see their own reports which will be populated by internal users. Thanks
Help for working with Rest API and Powershell using Creator
Hi i want to start out with that i am new to Zoho Products. and have been using Power Automate and many years work with PowerShell. I am trying to figure out what the approach is to create an app that can do lookup from API calls and maybe trigger a PowerShell
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 2 - 2023
Hello Everyone, Creator's Release updates - Part 2 - 2023 Frequent product updates continually enhance the overall performance and functionality of the platform, ultimately improving the ease of using Zoho Creator and making it more efficient for businesses
iFrame not Showing on mobile phones
Need help why iFrame is not showing on mobile phones. I have iFrame in a html snippet in zoho creator. It does show on desktop but when I tried on mobile phones, it isnt showing anything. It's just blank. Is there anyway I can do to solve this?
How to add a new row in the middle of a subform
Dear All, I know that with the buttons in the subform I cannot do it but I was thinking if there is any 'hack' way via deluge. I have a subform and I fill the first 10 rows for example, then I click submit. For some reason I want to edit again this record and add a row between the 3rd and 4th row in the subform. The manual way is to delete all the rows under the 4th row and then add here the new row Is there any way to do that programatically? I know that with the Add Row we can add rows only in
Use Zoho Creator as a source for merge templates in Zoho Writer
Hello all! We're excited to share that we've enhanced Zoho Creator's integration with Zoho Writer to make this combination even more powerful. You can now use Zoho Creator as a data source for mail merge templates in Zoho Writer. Making more data from
Tip 10: How to fetch data from a custom module in Zoho CRM.
Hi Folks, A fortnight has gone by, and we are back with a new tip that would help you fetch data from a custom module in Zoho CRM and use it in a form created in Zoho Creator. As you may already know the default integration field does not list the custom modules that you have created in Zoho CRM. The current integration task will only allow you to choose from the default list of modules available in Zoho CRM (as show in the below-given image). However, if you want to fetch data from a custom module
500 Internal Server Error
I have been trying to create my first app in Creator, but have been getting the 500: Internal Server Error. When I used the Create New Application link, it gave me the error after naming the application. After logging out, and back in, the application that I created was in the list, but when I try to open it to start creating my app, it gives me the 500: Internal Server Error. Please help! Also, I tried making my named app public, but I even get the error when trying to do that.
Can regular user and portal user from China access to Creator in US DC (.com)
Hi, We are an American company that register Creator account with US DC (.com). Most of of customers are located in China, also there is a small office team in China. As title mentioned, would like to know will the regular user and portal user having
Hide certain columns in a published report/page
I am working on a way to make a report in my app searchable by the public in a published page. A have a search bar that takes user input and assigns it to a page variable that is the filter criteria in my report. This all works fine, but there are certain
Update adding dropdown menu for only one component
This "subtle UI tweak" results in double the amount of clicks for my users. I was making use of the fact that menu sections with only one component did not have a drop-down, so that those components could be accessed directly. Almost all of my applications
Unhelpful Error message that could worry portal using clients
In my subform that is in list view I want to show and hide a simple field based on a boolean and it does work nicely and simply. if (row.boolean == "Yes") { show row.thing; } else { hide row.thing; } However if the user has toggled the radio choice and
Pop up error message window for functions
Sorry if this has been posted before, but I can't seem to find the answer. I have set up a button on each record of a view, when the user clicks the button a function is called to send an email. In the function, before the email is sent, it checks all the required info is present. If it is NOT present, all I want to do is show a message "Please enter missing info and then try again" and then exit the function. Seems simple, but I can't figure how to show the message.
BUG?? Search in Page can pass only the Search
Hi, Since the page variables and scripts update, when searching with the Search component in the page, we can pass only the search string to the "Target Page" (Attached Screenshot) For me, it makes the Search component useless. Is it BUG or another step
Subtracting a value from another form
Hi, I have a form called performances which has 3 numerical fields: Number_of_Tickets_Available Number_of_Tickets_Allocated Tickets_Remaining I have another form called Tickets_Allocated. This form pulls the values of the three numerical fields from the
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 1 - 2023
Hello Everyone, What is Creator's Tech Connect Release Update Series? Regular updates to the product improve the overall performance and functionality of the platform. As a result, using Creator becomes easier and more efficient for businesses of all
Does anyone know any workaround how to use javascript to published pages ?
Does anyone know any workaround how to use javascript to published pages ?
Populating a form field from a report button
Hello, I have a form report that has a list of coach companies, and a column that enables users to add a review by clicking a button. (See below): There is an 'Add a Review' button on every line (next to each coach company. When the user clicks add a
If statement not working?
Hey guys, I have a if/else statement which works on the first 2 criteria in green (150mm Adjustment and 100mm Adjustment), but fails on the last when no criteria has been met. I must be missing something very simple. Can anybody help me please? It will
(Deluge) Filtering fetched records
I am trying to create a script that checks the status of the zoho sign document where the field waiver_status equals sent, unopened or viewed. We have thousands of records so I was trying to filter the fetched records but it is telling me I cannot and
Creator Portal - Execute Deluge script on successful SSO Login
Is there an event that can be captured during the Portal SSO login process on the successful SSO login? I know I can create a Creator Portal user/adjust a user's permissions via Deluge but, is there an event that fires on successful SSO login that will
Issue with Navigating Components in App Localization
While using the app localization feature in Zoho Creator to translate my apps into a new language, I encountered an issue that made it difficult to navigate between different components (forms and reports) and add translations. The feature would only
alignment in forms
Hi there, I have two questions: 1. In a form, how can I align checkboxes to the left margin? 2. Is there a way to force a single or multiple line text field to appear below the label? The form I'm talking about is http://creator.zoho.com/kimschotanus/intas-projects-coordinators-and-team-leaders/form/50/
Error when exporting the Canvas Detail View in Creator 5
When I attempt to export a custom canvas detail view layout, the file does not export as a JSON. Is anyone else experiencing this issue? I have requested help from support but still no solution to issue
Zoho Creator Calendar view
Is there any way of sorting a list of items on a given day in Calendar view to display in alphabetical order?
Configuring sendmail to use variable record templates
I have code working nicely to send offer letters to applicants from Uganda: sendmail [ from :sender_text to :application_record.Email cc:application_record.Email2,application_record.Allocated_to.Email reply to :zoho.loginuserid subject :"Offer of tools,
Send email notification to added employees when a record is added to a multiselect-lookup field
Hello, I'm using Zoho Creator to keep tracks of who's responsible for each Function in the company. Here's an example of a "Function" record: Function name = Invoicing Main owner(s) = John Doe Substitute owner(s) = Amanda Lear, David Bowie Where: Function
multi-select fields and report builder
Hello, Is there a work around (via deluge script or else) to allow data in multi-select fields be grouped or filtered in the report builder? We have activities that are participated by multiple participants that we input via look up -multi-select fields. We need to make a monthly report for each of the participant vis-a-vis the collective activities they have participated. How can we do this here? Its a feature we commonly used at dabbledb. Thanks, Edith
Add suffix to a field value in detail view
I'd like to show the unit of measurement of a field in the detail view of a record like this (the red "mm" text): I searched for a solution but couldn't find any. Is there a way to do this?
Enable report button based on the current user role
Greetings i have a report that contains action buttons, i want these buttons to appear as enabled only when the current logged in user has a certain role, for example only CEO role users will be able to use this button. but when setting the conditions
How can a published page (permalink) show up as a pop up window
Hi. Is there a way for a published page (user access the page using permalink) to appear in a pop up window? Apprently zc_loadIn does not work on external link, like the permalink for a published page. How will I be able to redirect user from a zoho creator
Useless scroll bars with no space to scroll need to disappear
Check out the scroll bars on the right and bottom of the image. The one on the right moves the view about 1 line and there is no reason for it being there since there's another one in the pivot table that actually works. The one on the bottom hardly moves
Next Page