Tip 2: Recursive functions in Deluge: How to dynamically run a function for a specified number of times.
Hi folks, As part of the Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on Recursive functions. Let us first quickly understand what Recursive functions are: A function that calls itself one or more times is known as a Recursive function. That is, you can execute a function to perform a particular action a specific number of times. And, at the end of each iteration, a new output is generated. Recursive functions are commonly used by programmers as it enables
Pass values from stateless form into function
I have a function w/ a list of dates and a list of strings that populates a bunch of data in form1 - it works when executed. I want to use statelessForm inputs dateField and dropDown to populate dateList and genreList in the below function and run it.
Is this hacky solution for admin filtering records in a report safe?
Portal users need to be able to see and edit some records other portal users create. Admins should be able to see and edit all records. I haven't seen any solution that doesn't involve adding some field to every form that is some kind of admin check.
Calendar start time limit
Hi all, Has anyone found a magical way to filter calendar reports to start from, let's say 8:00, and not 0:00? Or at least to auto scroll there like Google Calendar for example?
success message <expression>,<duration>
Hello, I created a Auto Number field to let system auto create a unique number for each record created in a form. Is it possible to a) display this auto generated number at the time user is entering the record, or if not possible b) allow to show to user the auto number within the Success Message once user clicks on Submit button. Your assistance is much appreciated.
Retrieving value from inventory API getRecord gives null
Hi all, I have an issue with my platform I am building. I would like to fetch a list of all my sales orders that are pending shipment from zoho inventory into zoho creator as a list. This is my code for now. When running the script, i get a null value
problem exporting/reporting on Rich Text fields
I have a view based on a form that contains a rich text field. Works fine for editing in the form, but all export options for the corresponding view (PDF, XLS etc.) show embedded html in the text, things like <BR> for line breaks and for spaces. I cannot produce proper output from this view and that is a huge problem! I could convert the field to multiline plain text without a huge loss of functionality, but it's my understanding that Zoho would throw away the data in doing so. That is
Error in syntax parser involving invokeUrl and workdrive upload file
I wasted way too much time and haven't even bothered to get this working yet but it all should be simple after debugging this issue. I see literally no different results between the two syntaxes and have seen no one else talk about this issue but it just
Difficulty retrieving portions of Date-Time object
Having some issues with date-time objects and could use some guidance. I've retrieved a timestamp from a module, in this case the "Created Time" timestamp. The timestamp variable returns true for isDate(), but when I attempt to use .getHour(), .getMinutes()
Timing on Success Message
Is there a way to edit the length the success message stays up after a user submits the form? It disappears in about 3 seconds. please let me know if there is a solution for this.
Creating a data entry table form
Hi I was wondering if Zoho Creator allows to create tables for data entry instead of just single line and multi line in the form builder. For example the highlighted cells below represents the cells to be entered. Regards
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 3 - 2023
Hello Everyone, We are constantly working towards the platform features to optimise the user experience and to increase the value of the product. As always, our utmost precedence has always been on educating and keeping the users informed about newly
Integreat 05: Integrating Zoho Creator with Zoho Cliq
Hi everyone, This month, we'll look at how to integrate your Zoho Creator application with Zoho Cliq. This is one of the most popular Zoho integrations that our customers use. What is Zoho Cliq? Cliq is a workplace chat application that's part of the Zoho product suite. Integrating with Zoho Cliq You can use this integration to automate processes like posting comments in chat channels or BOT channels. 1. Post a comment in a chat channel in Cliq, directly from Zoho Creator Once you integrate your
Change membership
Bugün bir İçerik Oluşturucu üyeliği oluşturdum ancak ihtiyacım olan üyelik site üyeliği. Planımı değiştirmeme yardım eder misin lütfen?
Change Label Name with script
Hello everyone, Is there a way to change the Label Name with script?? I would like to have the option to change the language of the application, so I was thinking if this could be done? Besides that, is there a way to know the user that is Sign In? Because I could automate the language function if the principal question were responded. Thank you very much for your help and sorry for my grammar English errors.
How to Hide Or Show Submit Button But NOT Disable the Alert Button
I'm sure this has been posted before, but I found a follow up way to hide or show specific buttons and KEEP the Alert Button Working Fine. (this is based on the info I found on the below website so thanks for the user who added this) All this does is adjust the CSS or Style of parts of your form. In this case the Buttons. The website it worth looking at as my idea just builds on this: https://infitarit.com/2019/03/28/how-to-disable-or-hide-submit-or-reset-button-in-zoho-creator-form/ As an extension
Zoho Forms: "Save Progress" or "Continue Later" ability
So I've created a rather long form that could take some time to fill out. Is there a way the user can save their progress and come back to their work later? I know it's possible for Zoho Survey (https://help.zoho.com/portal/en/community/topic/can-zoho-save-progress-and-continue-later) but couldn't find a way to make it work for my form. Does anyone know whether or not it is possible? Thank you!
Are dynamic images in a record template possible?
Hi there, My challenge is getting an image of a signature in a contract which is build up using variables. The signature is variable as well, based on the issuer of the contract. The signature are stored on external website, but I also added an image
Ability to access Zoho Creator Success/Failure Logs programmatically, via Deluge
It would be great to have an ability to access logs programmatically. Currently I am manually checking logs every day to ensure I pick up any errors and bugs. I would like to be able to automatically iterate and check those via Deluge on schedule. In
How to connect to the Braintree API from creator?
I'm attempting to connect to the Braintree API from deluge and I'm having some problems. I'm trying to use Braintree's graphql to do this. https://graphql.braintreepayments.com/guides/making_api_calls/ I'm able to set up a basic query but I'm having
Send Mail | Insert Code | How to use it? What's it for?
Hi All, After a few hours of web searching, I'm struggling to figure out how to use the insert code feature in send mail. I'm trying to create a dynamic reference code based on the current year. If the year is 2023 then the code would be DEPOSIT23. Next
How to update zoho creator record ( a look up field) through widgets - js api?
Can I ask help how to update a record with a look up field from a widget using JS API? I get to fetch value of look up field using the code below. But I'm not sure how to update the record in creator when user selected a different option from the dropdown.
Access token rate limit issue
We are using Zoho Creator API to retrieve data using the Data API. We have a large number of reports and running into rate limits for access tokens. Since we use serverless processes, we can not share memory across multiple runs. So we retrieve a token
Tool to automate via API's
Hello, I want to automate some task within our instance of Zoho analytics via the APIs (Delete's with specific criteria, Select-Insert using download then Insert etc) I can do this via Postman, but when I try to schedule the tasks, the scheduling does
Zoho Creator - [Free Webinar]Learning Table Series for Media
Hello Everyone! For the month of December - Bringing on to your table - Zoho Creator for Media 12 Months 12 Industries Media Industry The media industry is an ever-evolving and influential force that includes journalism, entertainment, advertising, and
OnSubmit workflow won't run when record is added with ;insert into' through another form?
Form A has a workflow that triggers on successful form submission but most of the time, records are added with an insert into function in a different form. Should the workflow for on successful form submission still work if records are being added this
Zoho Channel/Reseller Portal
Does anyone know is there a good package available that is built on Zoho for managing channel partners (deal registration, support tickets, Marketing document access, and a dashboard)? I would be open to Zoho but their portals seem very limited and can't
Is there a way to invoke deluge function from within a widget?
Hi! I have custom functions in deluge and I was wondering whether there is any way to call this function through a widget? Something like on click of a button inside a widget, run the deluge custom function. Would this be possible?
Update record from another form to subform Zoho Creator
Hi. - I have a form name maintain - And a subform (in another form: car_maintain) name car_maintain.set_up_maintain I want to update every new record in form maintain to subform car_maintain.set_up_maintain if maintain.car = car_maintain.car AND maintain.type
Display image on form
how to insert image on a form, the image field only allows for upload of images.
Creator theme menu levels possible?
Hey, Is there a way to get a second level to the menu structures in zoho creator? I have too many tabs to fit on screen and too many views already in the tabs I have. i could easily have 25+ views and forms in an admin tab but they would stretch well beyond the page limits. How can I add a second level of menus? Currently it seems I can only do 2 levels. For example Admin Parts Part ID Part Categories Users Rolls .. and 30 some odd other admin related items.
Create hierarchy chart?
Is it possible to create a organizational chart based upon records in Creator? I would like to do this using a "Manager" field.
Hide 'Add' button on a report
Hi All I have created a report using the summary view for use as a settings page, where I have added decision boxes for things like notifying users by email when a record has ben added. If the field is checked, an IF statement checks the condition of the decision box before sending the email (email is sent if decisionbox is true/not sent if decision box is false). I have limited the number of records in the report to one, however, my question is, can i disable or hide the blue 'Add' button on the
Image field preview and download are broken
Something changed recently (rights-wise?) in which my non-admin users are presented with a broken image icon when trying to view images in a report's Quick View or Detail View. When they click on an image, they receive the following error message: "Something
Can I connect Creator to a user created module in CRM
I want to be able to create a trigger which, when actioned, will add an item to a custom module i created. Is that possible? In the conenction setting between creator and crm, it only has a few modules. Thanks
Sample code for passing parameter to a widget. And code for fetching record in a look up field.
Hi! Im trying to create a widget but I didnt know how I can pass paremeter? There isnt much documentation avaialable? If I have the widget in a page and this page has parameter. How can I pass it to the widget? Also how can I get record from a look up
Rename the attachment from record template pdf in the sendmail deluge script
Hello Zoho, I urgently need a feature to rename record templates that I send via the sendmail feature. The program I created sends emails to clients with an invoices that have been created in the invoice database. If the user selects 3 invoice numbers,
Feature request: Zoho Creator - Zoho Writer integration for mail merge
Hi, I've set up a purchase order template on Zoho Writer and I want to have the fields in my template linked to the fields in a report in Zoho Creator. So far I was only able to achieve this by exporting a CSV file from ZC and importing it into ZW through mail merge. Is there anyway to automate this process? Will Zoho consider integrating both apps?
Is it possible to disable add entry feature when clicking on date grid in calendar report
Hi, I am having a calendar report. The event records are added using deluge to the form associated with the calendar report. Basically, I want to use the calendar report only for viewing. But, clicking on the date grid brings up the corresponding add
Zoho Developer Creator Privately Published app, cannot remove clients?
When creating an app through the creator developer space and publishing it privately to a client, is there no way to remove clients? View clients from the developer dash shows the clients but no way to remove them? Deleting the app to effectively “remove”
Next Page