Offline Zoho Creator
Hello Everyone, My client's office is in a region, where the internet quality is very poor. He would like to run his Zoho Creator inventory app offline, on his servers. Is it available by now at Zoho? Thanks George
aggregate records of each calendar year
Hello, could anyone help me with the script ho to aggregate monthly revenues in a yearly revenue field? I have three fields date field monthly revenue yearly revenue I'd like the script to work on user input of monthly revenue field, and want to aggregate
Adding fields dynamically to a form using deluge
Greetings In my project i'm going to have an initially empty form that has an on load workflow that reads records from a report somewhere else in the app and then add input fields to the empty form based on these records. i was wondering if it's possible
Cannot change japanese text font when doing pdf export
I use openUrl to export my report with specific ID, but the Japanese font does not look clean when exporting. I have tried changing the font within my RTF, but no luck. Any idea on how to fix this?
Zoho Creator Programming
Dear all, I'm new to Zoho and I'm keen to find out more about Zoho scripting. 1) This is related to the extensions displayed at Zoho Marketplace, were extensions developed using Deluge alone? 2) Is Deluge powerful enough to do anything for you within
User-defined global variable
Is there something like a user-defined global variable that can hold values among forms and pages within an application? I would like to do the followings: When accessing the application for the first time, Deluge script run and store the values to user-defined global variable. While the access, the user-defined global variable can be used in all forms and pages.
SalesIQ Bot Not Getting Zoho Creator Page URL
How can I pass the Zoho Creator page url into SalesIQ...it seems it is passing something related to the Page Element or Javascript widget. I really need to be able to identify what page the user is on to implement a useful Bot. A snip of the url that
Script for Sub total and Totals in Subforms
I've been trying to do a simple calculation using Sub form's workflow. Search through the KB but no answer using the new interfaces. Just need 1) self-calculate the Sub total Price from ( Quantity * Price per unit) 2) Total up the sub total price to the Total Price Any help is appreciated.
Form in Page
I know you can input a form into a page using the HTML insert that is built into the Page HTML options. But is there a way to insert form fields individually using HTML into a page? For example, I don't want the entire form on the page. Using HTML I want
Autocomplete addresses
Is there a way, script or otherwise, to autofill addresses in a creator form based on Google or similar maps app?
Refer to url parameters on form load
Greetings in my app i redirect the user to a certain form and include query parameters in the url: openURL("#Form:Ideation?projectId=" + input.ID,"same window"); i want to create a workflow action that would run on form load to use the projectId parameter
How to extract Email address from string (Deluge)
The task was to extract an email address from a string variable, or any text-based field. It is usually done in javascript using regular expressions. Surprisingly, Deluge allows to replace substring using regular expression, but do not allow to search substring using regular expression. OMG. I finally came to below solution. It works. string GetEmailFromText (string Txt) { /* Extract first email address from the text Txt */ original_text = input.Txt; EMAIL_REGEX = ("[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?");
Allow user to add/remove certain fields dynamically
Greetings I'm working on an app that's going to contain a form to describe acts of a story, i want the user to be able to add and remove acts as they see fit. something similar to what subform field in zoho forms offers (attachment ss) with one exception
Is it possible to add custom submission buttons to creator forms?
Greetings I was wondering if it's possible to add custom buttons to my forms in zoho creator. so beside the default submit and reset buttons i'd also create a "submit and new" button that has custom action. is that possible? Thanks
Need better error message when an application error happens
ZC dev team: When running an application, if there is an error, this message appears across the screen: "Error occured please contact application owner." Unlike the (slightly) better error messages one gets in the script editor, THIS message is desperately unhelpful. Right? I would think that when the ZC program catches the error and throws the message, it must have some kind of useful information it could pass along in the error message, such as what statement was being executed or what field was
How to add Invoice in my Zoho Creator Custom App.
Hello, please i am finding it hard to add Invoice to my Zoho Creator App. Any help on that?
Error when I create the New Application
Hi, When I import a CSV file and I want to create return "Ooops,something wrong" What's the problem? Any file example? I'm attach the file I'm using. It's correct? Thanks,
Fetch and Fill from Lookup
All I have found are 11 year old answers to this.. I have a 2 forms (Locations and Load). When entering a new Load form I want to Lookup a Location Name. When that Location Name is selected in the Lookup I would like it to also auto populate other fields
OpenUrl with new window
When I run OpenUrl with "new window" option for a record in a report (https://app.zohocreator.com.au/user/appname/#Form:Extrusion?recLinkID=1234567890&viewLinkName=Extrusion_Report), it opens in a new tab which is fine. When I again run this script step for another record, it replaces previous record's window. If there are 10 records in a report and I want to open 10 new tabs. Is there a way to open new tab instead of replacing the previous tab? PS: I tried with a generic url like www.google.com.
open new message in default email client
Hi, We often have to send mails to participants of courses, that are unique. Therefore we need to be able to open a new message in the default mail client of the pc and have the selected emails inserted. Presently we do this by having a custom action in the report, that creates a comma separated list with the selected emails. This list is then passed to a Page where it is formatted as mailto link: htmlpage Mailadressen(emails) <%{%> <a href='mailto:<%=emails%>'>Hier klicken um Mail zu erstellen</a><%}%>
Add value On Load from most recent record
I have a form that holds a Stock Count Value in a sub form against a product name. When I load the form I am populating the product names in the sub form but I want to populate a field in the new form with the Stock Count Value from the last record created.
Barcode Generate in ZOHO Creator
Hello All, Problem:- How can Generate a barcode inside the Zoho creator? Solution:- BarCode API:- https://bwipjs-api.metafloor.com/?bcid=code128&text=PIyushGoyal&scale=3&rotate=N&includetext rotate:- N : Normal (not rotated). This is the default. R :
My nightmare continues!
The zoho team I fear is a bunch of idiots at this point. They've now put me through another 2 week nightmare where I'm waiting to get "approved" to use the Zoho Custom Solution Module. After 2 weeks, they zoho team simply sent me the link to the documentation
Bug: Report Action confirmation prompt is removed
When editing a Report, I have added several Action items under the Quick View section. I have the same Action available for both "For Single Record" and "For Multiple Records" and this Action has enabled the setting Execute the workflow: After confirmation.
Data Imported into a form report, not showing up into the report despite giving data import success message (Row count in Billing went up)
Hi all, Just trying to figure out what is going on in here, I have a file that I need to import into a form's report (with roughly 3300 lines). This form has no workflow or any script executing at import. It has a look-up field that is pretty straight
CRM Record Visibility
I am trying to develop a subform that loads Account Data from the CRM into the subform line. The issue I am encountering is that records not visible to other users inside the CRM are viewable in the Integration Field. Example: userA cannot view Records
Multi Page/Step Forms in creator
Greetings i was wondering if it's possible to create multipage/step forms on creator similar to what we have on zoho forms. is that possbile? Thanks
Tip 6: How to calculate the business days between two dates.
Hi everyone, Following our Zoho Creator - Tips and Tricks series every fortnight, we are back today with a tip based on one of the most asked questions in the forum. That's right. This tip would help you calculate the business days between two dates excluding the weekend. For example, if wish to know the number of working days in a particular month, you need to write a custom function to do this calculation. Functions are nothing but a unit of code written to perform a specific task. Let's see how
Approval Process
Hi, I am not getting approval process on my Development Portal. Is it a problem with Creator Version or something else. Please help. Thanks, Milind Manohar
Removing time from a date fields
I need to remove the time from these date fields. It is in the pivot table (please see attachments) Thanks in advance. Annette
Functionality URL Idea: The OR operator
Referring to this: https://www.zoho.com/creator/help/url-pattern/functionality-based-urls.html#To_set_criteria_for_a_view I propose to include "or" as well as "and" for creating views on the fly. For example, https://creatorexport.zoho.com/admin/mydata/json/My_View/Town=Lakeview||City=Summerville Would provide all records (in this case as a json stream) with either the Town Lakeview OR the City Summerville Is there a workaround? John M. Whitney
Converting Inches to decimal
I am trying to figure out how to create a form field that I enter in inches but it converts that input to decimal. I.e. I put 6 1/2 x 6 1/2 and the output would be 6.5 x 6.5. Thanks for any help
Subform report not showing related fields
I have a "Notes" subform containing the following fields: Job ID Time Notes It is linked to a parent form called "Job" by the lookup field Job ID. I want to create a report that contains fields from other the parent form and the subform. Parent form fields: Job Number Invoice Number Customer Subform fields: Time Notes I created the report with the above fields, but none of the parent form fields show any data. I created the report based on the subform. I'm not sure if I linked the forms incorrectly
Deluge Push Notification Error
Hi, I am unable to create a push notification to mobile apps using the following deluge scripts: notification = zoho.pushNotification("myemail@email.com", "New Request", "Variable", "Report_Link", input.ID); Error return "ID" is not defined. I am not
open url issue
Hi Everyone, Could anyone help me, please with my issue? I have three forms: Partners, Form1 and Form2. Both Form1 and Form2 has a lookup field with Partners form>>>Partner name field. If Form1 is submitted it opens Form2, and I'd like to populate Partner
Migrate to Creator 6????
I would like to get feedback from existing users before I migrate to Creator V6. Those of you who have migrated, do you like it? Those of you who have not, why? My use case - I am a self-employed researcher. My company is just me, so there is only one
Import/transform data from one application to another and preserve record ownership
I am upgrading an application, and for various reasons it has been necessary to do so by creating a parallel application with the new forms/tables, reports, pages and permissions. I now need to move data from the old application into the new one. I created
Custom function for each row
I am still new to deluge and have never made a custom function. I am creating a custom function that totals the price field in subform entries. I have tried using "for each," but I can't grasp what the arguments are supposed to be to make it work correctly.
Filtering Drop Downs in Zoho Creator
I have a very simple app. I have a table of organisations and a table of contacts. Contacts are a subform of organisations. So I can easily create contacts specific to an organisation. As you can see in my screenshot my organisation Great Orthopaedics
Execute a function or call a function as a specific user?
Since we are not able to explicitly set Added_User (record ownership) in script, is there a way to execute a function or to call a function and have it execute as if it was being executed by a specific user?
Next Page