Can I Build a POS using ZOHO creator and integrate it with ZOHO Books?
Hello, I have a Zoho Books account and I was wondering if I can have a POS system that integrates with it. Primarily with Inventory, Customers and Payment and ofcourse Create invoices and credit notes. So, would Zoho creator provide me with this solution? Thank you,
Efficient Fetching Approach : collection ( criteria )
right to the point : what I mean is if there's a Table say Task with a Status field with 3 values as : pending , inprogress , done so to show count of all task count and status wise count of task we have to write this code currently and run the query
Convert Unix Time Stamp to Date
I am getting external data with a Unix time stamp (number of seconds since 1/1/70... the Unix epoch). I have used a formula field to give us the right date serial number. This formula is: (createdTime/86400 + 25569 + (-5/24)) The explanation for doing this in Excel is here (http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/) Now, since the formula is a number, how do I then convert it to dd/mm/yy format?
Using Deluge to Set Tooltip
Is it possible to use Deluge to set a tooltip? I want to dynamically set tooltips for multiple Multi-line fields.
Direct URL to "View Record"
I would like to create a button (Deluge Script) to jump to the "view record" without passing by the record menu, but I can not aford to find the right url. I don't want the "view record" as a single page. I want the "view record" in the application like the picture below: Thanks in advance for your help
Integrate Zoho Mail contacts for email "TO" field?
Is there a way to make an email field use the user's contact list from Zoho mail for lookup? We have a form used for creating and sending quotes to our customer, and filling out the email address is a bit cumbersome having to search for the email address
Add/Remove Drop Down Items
Are we able to add/remove drop down items via script? I do not want to make a Lookup field, but simply be able to add an item to an existing drop down field upon user input. This is most likely a beginner question, but every time I look for the solution I can only find Lookup field tutorials, so thank you for your patience. Please let me know if this is possible! Thank you in advance!
webhook intergration
I have an app from creator that am trying to call an external service api with a web hook anyone got any ideas?
Deluge and creator integration - creator connection does not exists
Hello, i've made a simple app in Zoho Creator, with a form and a report. Filled some records in the form and created the connection microservice (with read privileges on creator). Then in my CRM i wanna make a connection between my customers and the data
How to Preview the PDF file in widget.
In order to preview the PDF file, I had to develop the widget page. I've included the PDF file that serves as my response. how to display the PDF in a widget or modify the format as PDF.
Filter a lookup field based upon selection done in another lookup field in the same form
Hi, I would like to implement the same behaviour that I see in the application "Order Management 4.0" already available as a template. I'm referring especially to the form "New Product" in which the user selects the "business Group" item and according to this choice the "Product Group" field is filtered. How is it implemented? I tried to reproduce that behaviour without success. Thanks
CPQ Solution in Creator
Any solution available for a CPQ developed in Creator? We would use the CPQ for quotes and proposals and integrate with Book and CRM. Creator seems to be able to create the conditions and rules for products and exceptions for products, groups, bundles,
Gmail's new guidelines and their impact on Zoho Creator
Hello everyone, We'd like to inform you about the upcoming changes to Gmail's guidelines, set to take effect on February 1, 2024, which will have implications for Zoho Creator, especially on send mail tasks. Gmail is rolling out policy changes with the
Concerns about the announcement of the new Gmail guidelines.
1. Starting in February, will portal users or Administrators not be allowed to add Gmail email accounts? 2. Do the email addresses of the super administrators' accounts that are already active with Gmail have to be changed? 3. Is there also a problem
Is it possible for using Zoho Creator as a public application without login?
Hi there, I recently had a client who was looking at building a learning resource on Zoho Creator. However he had a requirement that course content that he builds may be publicly accessible. My question is that, is it possible to have public pages with
Not Working Get Recode API V2 and V2.1
Hello Zoho Team, curl --location 'https://creator.zoho.com/api/v2.1/zoho_admin8544/powerbi-connector/report/PowerBi_CRM_Form' \ --header 'Authorization: Zoho-oauthtoken 1000.036ed6dbd843860314596bf7eca4fc13.20b068cbfb671318a625466d4b8d8712' \ --header
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?
Next Page