Sales Order Line Items into Zoho Creator
Hello, I am trying to integrate the information of a sales order into a Zoho Creator Form so we can attach certain items to each individual line item. This is needed because it is unique to each order and is not available in sales orders currentl y. So far the only items I am not able to pull in is the product details. Can someone please help me do this using Zoho Creator? Shaun
Access preview link for pdf instead of direct download link within widget using Zoho Creator API
Is there a way to access a file within the Creator file system and preview the file instead of direct file download? I understand the files are hosted on the Creator server, and that the previews are made possible most likely to finding the file and embedding
Using "If Condition/Statement" with two forms
Form A: Used to select email notification preferences (Multi-Select Field) Form B: Used to add and manage work orders SCENARIO First, the user submits Form A, setting their notification preferences. Then, the user submits Form B to create a work order
how to add current date and time in date-time field on load of the form
Hi, how to add current date and time in date-time field on load of the form date = zoho.currentdate; time = zoho.currenttime; this is the code i have tried; but either date or time i am getting in different variables, so how can i store both into one
Upcoming Updates - May-June 2022
Hi all, Greetings from the Zoho Creator team! We're looking forward to delivering on all the exciting updates we previously announced for you. In this update, we'll be going over: Revising developer permissions API limitations on workflow looping Standardizing
Specific tab titles in the editor
As it currently stands, each tab title in the editor is "Zoho Creator", which makes it impossible to tell which tab is which. Instead, it would be handy to have the tab titles in the editor reflect where one is in the editor. E.g. FormA FormB ReportA
Cascading Dropdowns w/ Add New, etc., etc.
I have 3 record types: Company Branch Contact Where Contacts belong to Branches which belong to Companies. Question 1: On the form for Contact, I want to be able to choose which Company and Branch the Contact is being created for. I got this working by
Basic Budget Application
I am trying to determine if Creator will work for a basic budgeting application that I am wanting to put together. I would like to have a form that I can use simular to a check registry, a form where I can create a monthly budget with categories, and some views that show actual versus budgeted totals. I can not figure out two things: 1. How to have a running balance for the form that I want to use like a check registry. For example: Date Payee Amount Balance Category 11/21/06 Wal-Mart 25.00 100.00
Renaming
How do I change the name "Sheet1" to "Customers" in the figure below?
Email data to form
Hello, I’ve a couple problems while trying to send an email to a form. While I don’t think it’s a zoho problem, I’m gonna ask you anyway, maybe you have a solution. Sometimes when a user sends an email to the form, the content won’t be captured by ZC_Content.
Zoho Developer "Custom Solution" Question
I've made a few basic applications within Zoho Creator for my company's own internal usage. I want to recreate one of these applications within Zoho Developer as a Custom Solution, so that I can sell it to other companies. I'm not quite grasping the Pricing
Syncing data between the environments
Is there a way to sync the data from the production environment to the development? Everytime I publish and update I lose all the data in the production version
Hide empty fields in summary report
In the summary report view, how do i hide the fields that are null?
Panel filter not working
Hi, I am trying to construct a panel filter like below: But it seems does not work, only one of the conditions is fulfilled. Any way I can achieve what I need to do?
IMPORTANT: Restriction on Public Access, to control phishing.
We already have processes in place to detect fraudulent usage of Zoho Creator. We never permit storing of sensitive information like credit card details, passwords, social security numbers, etc., on our apps. But as we are sensing deceitful usage of applications, mostly in Free subscription and Trial period, we have decided to disable the option of making an application as Public. Henceforth, all the applications that are created will be Private and only a shared user will have access to the applications.
Introducing Zoho Creator's v2 APIs
Hello App Creators, Welcome to Zoho Creator's v2 APIs! This post will serve as the central point for migrating implementations of Creator's current APIs (v1) to v2. Improvements that v2 brings OAuth-based authentication, which is more secure than the
Zoho Creator Lookup field wrong data type
Hi I'm trying to get to grips with fetching records in creator and have created 2 forms: Visitors (Name, Email) Appointments (Date, Visitor, Email) The Visitior field in Appointments is a lookup field related to the visitors form. I've tried to define an action in script builder to take the name displayed from the lookup and fetch the email address of that visitor. The problem is that the name field in Visitors is a single-line text field whereas the Visitor lookup field is being shown as numeric.
How to push image URL in Image field of Zoho Creator using custom function/deluge script or creator API?
Hi, I want to add an image to Image field in Zoho Creator by giving URL of image into Image field using custom function or deluge script. I tried to give URL of an image in Image field in Zoho Creator's record using the following code: insert into Testing [ Added_User = zoho.loginuser Name = "Test Record" Email = "MyEmailAddress" Image = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/01/nature-wallpapers-38-798x350.jpg" ] But it is not adding image to Image field.
Custom Button in Quick View of Report should be Available for Mobile View
Hi @Zoho Team, I believe having a button available on quick view of report for Mobile app is very important. I understand that having it inside Detailed view or adding into action buttons does solve the problem but from the user journey point of view
Forms to enter data and retrieve data
Hi, I am very new to Zoho Creator. I am looking for a really simple sample application so I can learn from it. I want a simple form to enter an employee personal data. That I have figured it out. Next I want to search for an employee by name, or by email,
Zoho Creator Should have Folder Management Capability
Hi @Zoho Team I think once of the major things that Zoho creator lacks is the Folder management capability as all major ERPs and CRMs do come with resource management section but there is no specific resource management section in creator which I believe
increment a number field
I don't want to use the autonumber field in this case and would like to add my own. I've create a number field called Client_Code, how do I go about incrementing this field by +1 in deluge? Form Name = Customers Field Deluge Name = Client_Code thanks
OAuth 2.0 Connector with PKCE
I want to announce here new version of application on marketplace [OAuth 2.0 Connector with PKCE] This is renovated app for minting the OAuth 2.0 tokens. As you may know, [PKCE] (Code Verifier) is becoming a new standard for OAuth and as of now supported
Report Template - How to remove page break after each record?
Hi, We have report template for a list report. It looks good at screen. But when printing, it creates a page break after each record. How to remove the it? So we can print multiple records in same page. Please look at the attached screenshots. Report Template Report Print Preview
Collapse Menus
In Zoho Creator, is it possible to create a page that includes collapsible or accordian menus? Thanks.
Deluge Question: Conditional Statement
Hello, I made a short video showing where I'm stuck. How can I add "For every 5000 over 44,001" execute___? Video: CLICK HERE TO VIEW Thanks for your help! if(Program == "Lawn Mowing" && Property_Sq_Ft >= 0 && Property_Sq_Ft <= 4500) { input.Services.clear();
Zoho Deluge (Creator App)
I need help understanding how to automatically populate and add rows to a subform. I'm using a dropdown field as the "trigger". I made a 1 minute video hopefully someone can point me in the right direction? Thanks for your help and time. Chris https
Import subform data into one form and push to another form
Hi. We have a user portal where: the client receives spreadsheet template download after submitting details client enters subform data into the spreadsheet, then imports the spreadsheet back into the same form's report. We need the imported record and
Paged data from Inventory using Creator api: how to get?
According to Get Records from Zoho Inventory, data from Inventory is paged and has a default page size of 200 matching the behaviour seen in Get Records from Zoho CRM but where as the call for CRM allows you to supply paging information to get subsequent
"Convert" a blank subform into a regular (sub) form
Other than manually exporting, importing, and linking, is there a faster and easier way to "convert" a blank subform to a regular form (to be used as a subform)?
Unconditional transition is not working
Hi, I have a new transition called Merchant cancelled In my dev environment I have 3 records in Merchant terminated stage 2 of them were moved to this stage before that new transition was configured, one after and only for that one record it is possible
Changing Field Name value
Hi, Is it possible to change the field name on a form base on the value passed in runtime using deluge? I have 100+ elements in a form I want the user to write the name of the element who wanted and change the field name base on the user input in another
Creator : Formatting help - ZML to HTML
I need some assistance with making a HTML panel look the same as a ZML panel, however my HTML skills are severely lacking and I can't get it to look the same. This is visually how the two panels look side by side : And this is the ZML code for the panel
Add Related List from Zoho Creator App To CRM Module
I'm very new to zoho. I have an simple creator app that contains a simple form: A name and an integrated source to the Deals component. There could be a hundred items associated with this "deal". How could bring this associated items as a related list
how to change the name instead of info we want shipmydeal
Hi, Please check attached file .. as in the name i am trying to change the from 'info' to 'shipmydeal' ... how should i change ? and this is the code i have written sendmail [ from :zoho.adminuserid to :input.email subject :"Registration" message :"Thank
A method for renaming tab titles in Creator to display more relevant information
Hi Zoho Devs, Updates: Rules Export File attached; you can now import this into Tab Modifier instead of manually entering the rules yourself) 2022-06-08: Updated rules so that crm.zoho.com tabs are not affected; uploaded new .json import file 2022-06-09:
Missing backup data for the entire month of April.
My biggest app is missing backup data for the month of April. I have had a weekly backup scheduled since inception. I went back to look through some historic data and learned that all of my backup data is missing for the month of April. Has this happened
Please Fix Error Message Locators for 'IF' statements
As you can see from my screenshot attached, the error message says there is an "Error at line number: 1". This is incorrect. The error ACTUALLY exists on line 82. I've noticed this miscommunication often occurs when there are 'IF' statements involved. Whenever
Zoho Creator Roadshow 2022 | We're coming to a city near you!
Hi everyone, Hope everybody's having a great week! We're excited to announce the launch of our Global Roadshow 2022 in 13 cities around the world and we'd love for you to be part of it! Whether you're a long-time customer looking to explore the
Restrict Previous Date Calendar Booking
Hi All. I am facing diffculty in implementing the functionality. When User click on Previous Date on calendar , System should Alert "Booking Not Allowed in Previous Dates" and system should not open Booking form for previous dates. Same functionality
Next Page