Dynamically adding rows to a sub-form. Problem with populating drop-down list
Hello, I need help on the following code. Here I am inserting rows in a sub-form called Period_Info1 (which is in main form Create_Time_Table) from another sub-form AA.Period_info. The fields Period_no, Fr_Time and To_Time are inserted correctly but field Course, which is a drop-down list is not getting populated with List L_S. If the number of rows in the sub-from are predefined then the drop-down gets populated correctly from the list L_S. The drop-down is not populated when it is part of the
UTMs Forwarding in Embeded Forms
Is there a way to forward any URL UTMs when embedding a form in a website and redirecting the user after a successful submit? We would like to be able to track campaigns to the conversion of a form submit.
Zoho Creator Developer
Hi, I started using Zoho Creator and believe that we can use this to develop applications for our company but I am having second thoughts as I cannot find the correct resources. We are looking for an experienced expert Zoho Creator developer for our office in Gurgaon. We are also willing to take someone on that wants to work remotely but still we cannot find the right person. All the proposals we get are from companies or freelancers or from candidates that have very little experience. We are looking
Looking for a Zoho Creator Developer
Hi, I'm looking for someone to help edit, improve and add new features to an existing Zoho Creator application. It was built by a developer who is no longer available for freelance work so I'm looking for someone new to work with - most likely for semi-regular updates. Please list your previous work with Zoho Creator, your timezone and general availability both short and long term. Thanks, Andrew
Update zoho CRM deal stage on form field update
We found the way to create a deal in CRM everytime someone submission the form. Now we are looking for a way to update the stage once we approve that submission. Basicly we have a button that sends the response on the form submission and would like to
Hide/Show Subform Fields On User Input
Hello, Are there any future updates in Hide/Show Subform Fields "On User Input"?
Is it possible to add options to a multi-select through deluge
I am trying to update a multi-select field with a value not called out on the form, I am trying to do this through deluge, not in form. So for example a multi-select that has options {"A","B","C"} but through a script I want to be able to do something like this: field.add("D"); Is this possible?
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
Next Page