Marking records that haven't been update on a specific date
HI, I'm building a Creator app, with 2 forms "Work Orders" and "Helper". Every day, an excel sheet is uploaded / imported to the Helper form, where each row is added as new record. One column of the excel sheet is a unique number "WO number" and is saved
fishing warnings from gmail on zoho creator hosted apps
Hi, we are getting fishing warnings from gmail on the zoho creator domain. Other zoho services such as marketing automation are aware of this and offer workarounds. When will creator allow us to use a custom domain so we are not impacted by free (and
Any way to stop my lists / maps from being minified?
I did look around and didn't see any options for it and it happens even with syntax assist off but basically I want creator to stop automatically minifying my maps and such. Or is there at least some option to make it revert to the human readable when
Lookup between two forms
Hello group, I season with FileMaker but green with creator. Hoping someone can guide me on a database i am trying to create. i have two forms, one "(item list) that contain all the items in inventory and the other form contains the quantity on hand for
Multiple user updating inventory qty with deluge
Hi all, i have a scenario below I have a inventory product A with qty 10 and there are three users submit their order at the same time. user A ordered 10 user B ordered 10 user C ordered 10 i have script on validate to check if the qty goes less than
Fetching Purchase Order to Zoho Creator
Hi yalls. Pretty confused with the API documentation for Creator and Inventory integration. I am trying to retrieve a specific Purchase Order from my inventory account to Creator, but all I can do it retrieve all Purchase Orders (see img below) What should
Image not getting uploaded
Hi All, I have created one form for storing the images, with field names, 'ImgData' - Name of pic and 'Image' - Image loaded. Second form has a deluge script to fetch the image on the click of a radio button and the script is as below. It loads the image
How to Manage Number of statement execution limit exceed condition
Hello Team, we have to execute more calculation again and again at that time the error will shows like execution limit exceed how to manage this issues.
Selling Zoho Creator's apps as a service
I've been thinking and working at several apps that i would like to sell as a service. So I've been studying the developper area to see if i can make a profitable plan. But, at the developer console, when i try to create a pricing plan, i see that the base price "will be decided during Review"... This doesn't allow me to make a business plan because i cant calculate the costs of using Zoho's platform. How do you suggest i should do my business plan?
Logs more useful
Hi, I'm a developer for a company that uses Zoho Creator for its internal management software. The application logs are too complex to use because they contain general references to errors or information, making it difficult for me to pinpoint the exact
How to add Zoho invoice features to my Integrate Zoho Creator
HI I hope to get some advice and guidance. I created several forms to complete some order functions as well as order entry and management, but I still want synchronization or collaboration with invoice functions. I think there is no need to create a new
Lookup field in deluge
Hello, I'm trying to 'play' with the lookup field type and its 'fetch mode' in Deluge. So, I have a lookup field, 'user', in a form. When I use it in a Deluge script within a Workflow, I can access all properties of my 'referenced' field. For example,
Zoho creator and Zoho People Integration
Hi, we use Zoho creator extensively to track issues, incidents, etc. We currently have a table within creator that holds our crew, I'd like to drive this from zoho people, so that I can use the HR catagories, and organazational structure to drive aspects of our forms, for example, some fields would display for certain levels of managment.
Borders on ZML and Html Snippets in Zoho Creator Pages
Hi there I understand that is not possible to remove grey borders from html snippets, zml snippets and iframes on a Creator page. Could the ability do set the colour of these elements be added, as the default grey border gives quite an ugly output to
Record summary link for Customer Portal
Dears, I'd like to ask what is the URL for the record summary view used for the Customer Portal? I have a blueprint and there is a stage that needs the customer to confirm via the customer portal. There would be an email sent to him/her with the link
Zoho as an ERP, CRM, and more for a Manufacturing company?
We are looking at solutions for ERP versus an off the shelf ERP system. Our hope is to use much of the full suite of Zoho apps along with some custom build-out for our manufacturing company. I was wondering if there are users or developers on here with
Create Ticket in Desk on Creator Form submission.
So I read the post below and they discuss all sorts of integration except how to create a ticket: https://help.zoho.com/portal/en-gb/community/topic/integreat-04-integrating-zoho-creator-with-zoho-desk-part-1 My app sends an email to the Ticket channel
help with code
Hello, could anyone help me with the code, I would like when I enter the payment date it fills in automatically, monthly, on the correct date of the following months eg: 15/03, 15/04, 15/05 and 15/06. it's possible
Initial Loading Delay in Zoho Creator App
Our Zoho Creator application experiences a delay in displaying data and opening forms upon the initial load, impacting user experience. Could you please provide guidance or best practices to address this issue? Your help is greatly appreciated.
Is it possible to download record template without opining it in a new tap?
Is there a way to download multiply record templates without oppinging lot of tab. I'm using this code: openUrl(url + linkName + "/" + input.ID + "/" + fileName,"new window","successive=true"); An once I click to download the record template you can see
Suggestion: Setting field focus programmatically.
I propose a new feature that would allow you to programmatically set focus to a specified field. Example: setFocus Name; That is all. Carry on.
Fetch zoho projects via creator widget
Hello, I'm creating a widget for Zoho Creator that serves the client's need UI. The thing is, the requirement is to display all projects and their children e.g. task lists from Zoho projects in this widget. Locally I can make server-side API calls (that
Generate QR code to edit a form entry.
I would like to QR code scan to edit a form entry. I would like to take the URL of a submitted form entry and create a QR code with the URL. Once we have the QR code we would like to print a sticker with the information and QR code. We would then like
Criteria for Field Rules Not Working if Criteria is Based on a Disabled or Hidden Field
I have an issue where I have "Field A" that essentially serves as a reference field containing a unique ID. So that field, by default, is disabled. I am trying to create another field rule to hide or show "Field B" based on "Field A" value, but the criteria
How to update decision box field based on two criteria
Hi, I am trying to update a decision box field which will show an assessment record as "overdue" if it has not been marked. I want this to be based on if the due date is before the current date and the marked box is false. I am trying to use this code
Zoho creator form confirm success show message for multi language
https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/manage-forms/articles/understand-showing-success-message#Understand_showing_a_message_on_form_submission How can I setup different language message ?
change font colour of certain items in lookup list.
Is it possible to change the colour of the font of certain items in a lookup list? I have form that allocates tickets. Once a school has recieved tickets, a field called 'Received tickets' in another form(Add/Edit schools) has its value changed to yes.
Getting an error on saving code that there is an error connecting to the service
While working on some bug fixes this morning we are running into an the attached error message. "Error occurred while saving the script. Could not establish a connection to the service." This is while saving the script for a Page
Creating URL in deluge/HTML
Having difficulty adding target=“_BLANK” to a URL I’m creating. I have dispLnk = "<a href='" + i.URL + "'>" + i.Title_Name + "</a>" + " - " + i.Description; where i.URL is a companies site, i.Title_Name is the company name and i.Description is their tag
Passing data to a form invoked by clicking the "create new" button in a lookup field.
Here is the scenario... I have a form called "order". In this form I have a lookup field called "ticket" which creates a relationship with a ticket form. In this lookup field I have turned on the ability to add new entries. What I'd like to have happen is that when a user is creating a new order (using the order form) if they click "add new" to create a new related ticket, I'd like to populate some of the fields in the ticket form from data the user has entered in the order form. Is this possible?
Passing parameters to "add new add entries" form
Hello, It will be great to have possibility to have property for each field in form (checkbox) "pass this to add new entries forms". For example: Form "Clients_Requests" Lookup_field: "Client_ID". Checked "Pass this to add new entries" Lookup_field: "Contact_Person" with checked "Show a link to add new entries in Contact_Persons" property. When you click "Add new" for Contact_Person, new form is loaded and Client_ID is setted to "Client_ID" from "Clients_Requests" parent form "Contact_Persons"
Image field pan, zoom and crop feature
It would be nice to let users arrange the images they input in image fields by allowing them to pan, zoom the image. Nowadays this is a standard input method used in most applications, so I think it will be very useful.
Check for Duplicate Date Range
I am trying to update my reservation application to check for units already booked. For a specific property, the unit is booked from a start date to an end date. What I am trying to do is to add code to check if some one tries to add another record where the from and to dates overlap. For example, Unit #1 (Unit) is reserved from (Check_In field) July 18, 2013 to July 25, 2013 (Check_Out field). If a user tries to book this same unit from July 20 to July 30, I want them to get an error message.
Update Subform items based on main form status
I am working on a deluge script to update the status of a subform ( "Samples"). The individual items have a "Status" that should be updated when the main form "Status" is updated. I have set up the workflow as a conditional workflow that executes only
Problem with Expenses App
The sub-categories are not populating with the Category selection. Meaning once I click the category, the sub category has the full list to choose from which is very annoying instead of just the subcategories that are associated with the particular category I selected.
What is best method to link or lookup tables with encrypted fields.
I am testing out Zoho Creator for making a HIPAA database to keep track of patients and their appointments. I have two tables: Patients and Appointments that I would like to be related as one-to-many (one patient can have many appointments). Per these
Customer portal users and data visibility on reports
Hi, Suppose I have two companies Rocket Science (RS) and Quantum Politics (QP) as my customers. Both companies access the application through the customer portal. When a customer portal user RS A fills data in a form, the user RS A can view the data in the corresponding report. The same is true for a customer portal user RS B. The user RS A can't see RS B's data and the user RS B can't see user RS A's data on the report. If permission set is configured to "View all", then all the users will see
Creator Page that Has Charts Filtered by CRM Account
We use Zoho CRM. We also have a Creator application called Reports that captures monthly reports with detailed metrics for each CRM Account. We use the Creator integration widget to pull the Account from the CRM and make it part of the Creator record
Subforms added after main records creation have "null" IDs.
Hi Zoho Community, I added a subform (pre-populated) to my main form. I want all existing records to have this pre-filled subform. When I manually edit an existing record, I can see the subform and the pre-filled values. But it does not show in the report
Implement an API call using Oauth 1.0
Hello Everyone; I am trying to communicate with another web application using an app in Zoho Creator, which happens to use Oauth 1.0... The problem is, i am able to test it using Postman successfully, but i can't write the code in deluge to authenticate, specifically to produce the nonce and timestamp needed in Oauth 1.0 protocol... Has anyone successfully wrote a code to authenticate using Oauth 1.0 protocol? Can you share how to make my code succeed? Thanks in Advance
Next Page