Newbie question about printing HTML view
Hi, Thanks to your help, I have managed to create a HTML view with data from my forms. Can someone tell me please, how do I print what I have produced on the HTML view onto A5 paper and can I print automatically when the HTML view loads. Thanks
Export Filtered report and send via email using deluge?
Hi, As stated in the title is it possible to export a filtered report say into a spreadsheet and send this via email. I know this can be done manually from the report but i want this to be an automated thing that happens weekly so i am wondering if this
No duplicate entries in Lookup Field
I have two Forms: FormA and FormB. I have a Lookup in FormB called "LastName" wich imports data from "LastName" in FormA (dropdown single select). "LastName" in FormA is not able to have duplicate entries. Is there anyway to avoid having "LastName" in FormB with duplicate entries? In other words, once one LastName has been selected in FormB, it won�t appear in that dropdown list for the next records. Thank you very much for your software.
What is "environment"?
What is the purpose of the environment(Stage or Production) feature? I have succeeded in publishing the solution to production, but I don't know how my customers will access this solution. I used to add a solution to a portal and provide my customers
About Data Retention
How long will the submitted data be retained? How many records are in the amount of data to be submitted? I bought the professional plan. I'd like to ask you for your help. Thanks.
Can I display a currency symbol in a formula field?
Hi I am new to Zoho and have quick question - I am using a formula field and woudl like the result to display in AUD currency - is this possible or is there a work around? Thanks
Showing data in an HTML table in real time
I have a dashboard which has a stateless form with a notes field in it. The notes field is outputting an HTML table which is fetching data from a regular form. I wanted the table to show data in real time, without having to manually refresh the tab or
Zoho.com not accessible
Good day, I cannot log in to any of my Zoho Creator/CRM projects. The screen starts to load, but nothing happens. I cannot even open the Live Chat. Is there anyone else who has difficulty logging in?
How to add new row immediately below the current row and not in the last.
My current script is adding new row at the end of the subform but I want to add row next to or just below the current row. Can anyone help? Current Script: // Extract the numeric quantity from the 'Quantity added' string addedQtyText = row.Quantity_Added.toString();
Filtering for a specific date range....
Hello, Trying to set a filter for agenda items by Start Date. This report goes out every Sunday and the Start Date is the following Sunday (1 week ahead). The duration is 1 week, Sunday thru Saturday. Using the operator "next n weeks" where n=2 gets me
Image signature in sendmail task
Is there a way to have an image of my organization's logo at the foot of emails sent with the sendmail task? I have attempted uploading the image to a form and trying to fetch the actual image itself in my workflow that send the email, but I'm not having
Showing only logged in portal users data in reports.
Have multiple portal users. Need to display data only relevant to them identified by their email ID which is an field in the form. User A should see only their records and User B should see only their records. As of now the portal is not showing any data
Zoho Creator Upcoming Updates - September 2023
Hello all! Zoho Creator is on a journey of perpetual improvement, consistently adding new features and enhancements to enrich our platform. Today, we're excited to bring you the latest updates and enhancements for this month: Global variables New default
Widget with leaflet map in android mobile
Hello. I am using a widget that loads a map in my application. This map is filled with 3 Layergroups by request through the API to the database. In the desktop version it works correctly but in the Android mobile version it only loads one layer. I get
Click on "Add" in an HTML Table to add words to a Multi Line field
I have a stateless form with a notes field displaying a table. Clicking on Add should input the Multi Line field with that given word. Is this possible?
Using 'insert into' to duplicate a record
I have a form with a sub form. I want to be able to duplicate the record, but with some values left blank / changed (for example, barcode cannot be duplicated) so rather than use the report duplicate I decided to use a button. I have successfully Created
invokeConnector
Hi I have the following code, that used to work for me, but for some reason no longer executes. Can anyone shed any light on why that might be? deleteRecordMap = Map(); deleteRecordMap.put("module","Course_Bookings"); deleteRecordMap.put("id",bookingID);
Introducing AI Modeler—a no-code approach to adding AI to your business applications
Forward-thinking businesses today are embracing AI to make life easier for themselves, their employees, and their customers. But if you haven't started yet, you might be concerned that your business will be left behind. Or maybe you're worried because
Record "Added Time" not returned using Get Record by ID - v2.1 API
Documentation here: https://www.zoho.com/creator/help/api/v2.1/get-records-by-ID.html Using this API method with the {"field_config":"all"} parameter, not all of the data is returned from the record. Specifically, the "Added_Time" (record creation time)
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
Error occured please contact application owner.
While trying to edit one of my entry I am getting pop-up Error Invalid entries found. Please correct and submit again. The above error general comes when I missed out any mandatory field but when I recheck I haven't found any thing wrong. In addition what ever changes I do in form, it gets applied (when I refresh and look in the view form) and the error pop-up comes, how is it possible?. I have trigger email while editing, I'm not receiving the email. This issue only happens while editing the
Sending a canvas report via email
Hi, I have created a report layout using canvas and now I would like to send it via email as it can be done using a template. My working method so far is: sendmail [ from :gw@gmail.com to :mw@gmail.com subject :"Sample invoicel: " + input.CzeUzyNum message
Script for Email Notification including record summary as pdf attachment
Hi, Can anyone share the script for configuring email notification which includes record summary as pdf attachment? I want to create a custom action that can trigger email notification for a record on a view. Thanks! -V
Zoho Live Support Chat Not responsive
I have attempted to contact Zoho support via chat for the last month or so and every-time, I am informed that the chat was forwarded because no agents are available. Has the Zoho support level changed?
How to store auth credentials
Hi I have a Creator project with an external service I use through API with key and secret for auth. I store them in the app variables but not sure it's best practice. Tried on microservices custom connectors but the service requires the key and secret
Assistance Required for printing multiple Barcodes on a single sheet of paper.
Dear Zoho Support Team, I am currently working on a project within Zoho Creator where I need to generate and print a series of barcodes on A4-sized paper. Use Case Details: I need to generate barcodes specific dimensions (Xcm x Ycm) and a margin (Zcm)
Formula Field + .sum() Function
Dear support, It would be life changing if you allowed us to use the .sum() function in Formula Fields, especially to sum row values in Subforms. I'm aware of how to do it via deluge/workflows, however, this would save a tremendous amount of development
Receiving "API request's body is either missing or incomplete." error
Hi, I am attempting to call the Creator API V2 Delete Records function from a CRM function and receiving the error " {"code":3020,"message":"API request's body is either missing or incomplete."}". Below is a code snippet with some URL variables removed:
Handwriting field
Hi all, Do you think this is possible in Zoho Creator in the future? There is a use case that people like to take a quick short note (using S-Pen, Apple pencil, etc.) in the application instead of typing in a tablet. In the era of AI, it more better that
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widget/extension concepts - Part 1
Hello Everyone! About Creator TechConnect Series The Creator TechConnect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while building
Creator Email on Submit- dynamic content?
Hi, I have created a stateless form with custom reports etc. There's a bunch of custom fields for one customer that I do not want sent to other customers, and these are hidden in the forms for people who don't need them when being filled out. Example-
Is there a way for Deluge to get the ID of a record submitted via insert into FORM_NAME
Is there a way for Deluge to get the ID of a record submitted via insert into FORM_NAME? i.e. I have: insert into Work_Order [ Added_User = zoho.loginuser Work_Order_ID = issueID ] I'd like to get back the ID of the record created so I can use it in the
On Load Action
Hi Everyone., I hope you are well I have a subform that has a "Total" Field that gets filled in on Load of the form. I have a "profit" field that calculates "Total" less "Deductions" . I have tried adding the formula for "Profit" on Load as wll but it
Implementing Oauth 2.0 for google API
I'm trying to access a Google API and need to use Oauth 2.0 to do so. I think I can use posturl to request the authorization code, but Oauth 2.0 requires a Callback url to send it to. How can I do this? Thanks Joe
can we add print feature in the button by page?
Hello, I'm trying to generate barcodes in Zoho Creator using an external API, and it's generating successfully. However, when I attempt to print it, the predefined process in Zoho Creator seems complex. Is it possible to integrate printing features into
Required Date Format dd-mm-yyyy
Hi I have a requirment where i need to send date format in API , and the format is dd-mm-yyyy. Is there any default date function which can give the date exactly in this format, i couldnt find any. Instead i tried to get date, month, year separately and
Side Menu Bar Hide / Show Option
Hi, How to hide/ show side Menu Bar??
Timeout in invoke URL SOAP request
I have a quite big XML to send through a SOAP request. Initially, this works fine when starting small (30 orderlines instead of 100 orderlines) but when scaling up, I get a timeout because the timeout limit of the API call is 40 seconds in Zoho deluge.
How to convert string to byte array
How to convert string to byte array : I want to convert string to byte array and but i can't find any option for conversion. I got array type in deluge script like list but byte datatype not found. Any one have this question answer then reply me ASAP.
Error at null with error.message or error.lineNo in workflows
All my code was working fine and try catch was fine but I want to match on users uploading too large of files since they're manipulated in deluge so I went to access the error message and am unable to save with an error at null warning. I started by cutting
Next Page