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
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?
Adding Subform row when adding new row in deluge
I am still new to deluge, but I have have trouble locating information on this. I have an online order form for my website. I would like to have a button to move that record information my main order form. I created a button in that report view of the
How to OpenUrl to print a report that's filtered w/ a collection variable
I want to open a filtered report in print summary mode to print a series of barcode stickers for inventory, here's what I'm doing, but it's not working: stickers = myForm[Added_User = zoho.loginuser] sort by Added_Time desc range from 1 to input.Qty;
How to store Image from a web URL as an image file in Image field?
Hi all, I'm new to Zoho Creator! I'm trying to save an image from a URL and generate public URL from creator. I've understood how to generate a URL of an Image stored in the Image field. The question is: I'm rendering an Image from "https://www.expamle.com/taskID?apikey=xyz"
Append Sorting
Hello Everyone! i have been going through how to sort or filter my DropDown based on selected DropDown in the Main Form, The DropDown works as expected where i fetched the Data from Subform of another Form and it works. my Problem now is only sorting,
How to disable a subform field based on the input of another subform field
Hello, I have a subform within a form. I want one of the fields within that subform (Checker) to be disabled based on the input of another field (Editor) within the same subform. Editor is a lookup field that pulls from the Name field in another form (Team_Members). I want Checker to be disabled when the Status field for the relevant entry within the Team_Members form is equal to "Graduate". How do I do this?
How do you add buttons to a form?
Hello, I am new to zoho creator and I would like to add several buttons to the form But i can't see where buttons are for the same
Export Zoho Creator Report By the API
Hello Team, Problem Statement:- Is there anyway we can export the Report in Excel or CSV Format by the API inside the zoho creator. if anyone have knowledge in this area please help with the API. Thanks & Regards Piyush Goyal +91-8619164837
insert multiple records from a number
The reason I write is that when the user enters a numerical value, this value performs a mathematical operation, for example, that the final result was 7, what he wants the system to do is insert a new record in another module depending on of the amount thrown by the mathematical operation, for example 7 e system creates 7 records for that record. I know that in other programming languages I only use a FOR (i: 0; i <7; i ++) and inside I specified that I wanted it to work. In this case, how can we
Can you change how reports are filtered with deluge?
Hi all. I'm using C6. I have a list of records that categorize upcoming events by the sport played, with several lookup fields to other forms. While using test data, the reports are functioning as desired (I have kanban and list reports, and a calendar).
Report - image - custom action - button
I'm looking for info or codes to integrate an image on a "custom action" button in a report and not just text. Is it possible? In the report custom action "Etapes" ( workflow = Etapes show action in view header = true show action in edit record menu =
Zoho support
Is there a problem because for weeks we have been sending emails and not receiving a response and no solution ?
Transfer portal users to new application?
I've had to set up a new application in order to do some major changes to an app. I'd like to move the existing portal users to the new app. Is there a way to do that?
How to deny access if accessed from Mobile Devices/Tablets
Hi, I'm currently developing an attendance tracker application. Is there a way to disable the application if accessed from other device aside from PC/Laptops? Or is there a way to disable access from other device? Thanks
Designig Page: Is it possible to use ZML and Deluge to create a Panel dynamically?
Hi. I want to create a Page with a panel for each record in a Form. I tried to use 'for each , but get get only 1 panel containing the first record. Is it possible to create a panel dynamically? This is my code: <%{ for each rec in Contact[ID != 0]
Zoho Desk to Zoho Creator
Hi Zoho Team, Do you have a sample code to link ticket records from Zoho desk to creator because our team is trying to automate the form and one criteria that we would like to test is by a trigger event - input by user. Example: Ticket Number search then
Zoho Creator - [Free Webinar] Creator Tech Connect - Integrations in Zoho Creator
About Creator Tech Connect Series In Creator, when we have to handle a complex business logic, we solely depend on the combination of workflow and deluge scripting. To develop those business logics effortlessly, you have to know the technical nuances
Zoho Creator - [Free Webinar] Learning Table Series for HealthCare
Hello everyone! Cheers to more shared successes in the new year! The beginning is the most important part of the work. With this New Start we are taking the Learning Table series to the next level. About Learning Table Series We have different user base
How to display hyperlink field value as a word/title rather than entire address in report view?
I have a hyperlink field in a form populated with: https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3. How do I display this value in my report view simply as "Audio"? https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3
Pass values from the current form to a function before submitting the form
Hello, I want to pass the values from the current form BEFORE it is submitted, i.e. it doesn't have an ID yet. Is there a way, apart from manually passing each field value (or creating lists or maps, etc.)? Thanks, Fidel Martín
Next Page