New import tool doesn't support subform data?
Please tell me this isn't true? In trying to import data to Creator using an excel file I found that the ability to import subform data is no longer supported. I got on the chat support who confirmed this is the case. I would imagine this will cause major
Creator : Stateless form as a search parameter - using result in Page panel
Hi, I have a stateless form containing a single lookup to a list of portfolios. I've put this form on a Page containing a lot of panels that will sum the results from a form where it matches certain criteria - how can I add the ID chosen in the stateless
Is there ANY way to output a function response as an ARRAY of MAPS?
I need to hae something like the following produced and created as a MAP. As of now, i have tried for 3 consecutive weeks to resolve this issue. No matter what I attempt, Zoho will see the data as a String, or if it gets converted to a map it only sends
Displaying CRM Custom Fields with Creator (Leads)
Hi There, Apologises in advance if this has been covered already, a few of the articles are 9 years old and with broken links. I have a couple of things I am looking to solve. Custom fields with CRM Leads: I have a couple of custom fields within Zoho
How can I control a form don't allow execute in browser mode?
I have a form with a field must be input by barcode scanning. So this form only can execute in native mobile mode. How can I control this form don't allow execute in browser mode?
When export can't find the field 'product' ??
Hi, I am trying to export the product ; but in that i couldn't found the 'Product' fields there. When i checked 'Configure field for Web' in the Layout there i can see the field 'Product'. please check attached screenshots Please let me know. Thanks
NodeJS server listening on port 4242
Hi, I have a NodeJS function that I need to listen for requests on port 4242. The following code does not seem to work, though. const express = require("express"); const app = express(); app.use(express.static("public")); app.use(express.json()); app.listen(4242,
CC field in Creator workflow email?
Hi, I have a workflow set up which sends a confirmation email to a customer when I click submit or update in a record. Can I add a cc field so that I get a copy of that email?
Can I publish App and manage accounts by my school
I want to know. If I use the school App, can I put it in Google Play with my personal name? Do students and staff need to log into it through a Zoho account, or can a separate account be created?
when i use # in url, the params go before the hashtag
i write this code in the snippet html <form action='/guillaumon/gestao-de-tarefas#Page:Kanban_Lead_4_1' target='_self'>
<label for="Pesquisa">Pesquisa:</label>
<input type="text" id="pesquisa" name="pesquisa">
"Failed" V2 Bulk Read API
I'm receiving a "Failed" status when requesting a bulk read request from the creator API after about a minute of requesting updates using the request ID. This occurs when requesting data out of a report containing over 1 million records. I've tried submitting
Search and Update a sub form
I am creating a simple sales, product and inventory app. Issue is each product has multiple sub items to track and update Forms: Products Boxes Inventory Sales My "Sales" form is calling the "Products" form to get a SKU and what box it is shipped
Help taking subform data and placing in a new variable to use in Desk task
I have a subform collecting 4 fields. Using Deluge, I plan to pass the subform fields to a description field in a new Desk ticket. I plan on using a variable to store it to use in a create ticket task. I know how to create the ticket, but how do I pass
How to automatically pre-fill several fields in Creator App based on CRM integration
Hi, I have several fields (like Birthday etc. or some custom fields like "Course name") in my creator app, which are integrated with the CRM module "Contacts". How can I automatically pre-fill other existing fields in the creator app, choosing only the
Creating record in Zoho CRM and upload file
Hi, I'm stuck on this issue, and I don't find the problem. i have a Zoho creator form with several fields : This application is linked to Zoho CRM, it creating a ticket in Zoho CRM. Everything works fine, but I can't upload document to Zoho CRM. Here my code : //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the quotes ). Creator field’s deluge name is used here. myFieldMap = Map();
How to use Java script in HTML Snippet (or on a page?)
Want to add some java script to a page. Any way to do this? Basically need to drag one image to another spot. Will also need to update a field in the record... but that will be the next step (and extra credit if you provide pointers on that!). For now, just need to get the drag and drop to work. <style> #div1, #div2, #div3 { float: left; width: 100px; height: 35px; margin: 10px; padding: 10px; border: 1px solid black; } </style> <script> function allowDrop(ev) { ev.preventDefault();
Publishing a page with a widget in it causes the widget interface to error
I've just done a test publish of a page that contains a widget, however in the console log it tells me that the authorisation token has expired. What is the correct way to publish a page with a widget? What we want to do is allow a customer to review
Sample angular service for zoho widget api
After a week of frustration getting this to work (granted I'm still a newbie at web development) I thought that I should share the fruits of my development. Below you should have the basics of an Angular service written in Typescript that you'll be able
How should i Remove starting space using deluge ?
How could i Remove starting space using deluge ? like if a = " ABC DEF"; then output should be ->ABC DEF , remove starting space only if available how ? Remove all spaces from starting before first text. Thanks and Regards, Sidhant A.
Looking for Zoho Creator Mentor.
Hello, I am looking for a Zoho Creator mentor that can guide me to what I needed. I want to learn it myself so I prefer a mentor rather than a person who will build it. I am also paying for mentorship if that is how it works. Our project is to create
Get a URL parameter inside a widget
I've written a widget that will use a URL parameter to search for a booking, however at the moment this doesn't seem to be translating through to the widget on the form. How can I make this work?
Conditional Formatting bug
Hi, Conditional formatting does not appear to be working in reports. In the example below, i have created two conditional formatting criteria to highlight a record either red or green based on its value. However, when running the report it simply applies the formatting from the last criteria to all records. (It is as if there is no criteria at all and it is simply applying the formatting to all records). Further to this, when i create a conditional format with a criteria, save it, and then edit
Showing Subform Field based on Subform Dropdown
Hi, on my main form "Contact Info" I have some dropdowns that will show a single line field based on what is selected in the dropdown. i.e. In the "Distribution Method" dropdown, I select "FedEx", and a "Tracking #" field appears. I have tried to do this same thing within a subform, but the subform just displays all of the fields and won't use the rules/logic I've setup in the form ("Contact Info Subform"). Do subforms not use the logic that are specified in them? Is there another way to have a subform
How can i update the value using deluge (dynamically) ?
How can i update the value using deluge (dynamically) ? The thing is we had already did insert task; but as we added 2 new fields later , so we wants to update these 2 fields into other report and there are lots of data there. How ? Thanks and Regards,
Is this code right ? Because only fnsku, sku and asin values are not updateing
Here is the code, lstv = input.FNSKU_SKU_ASIN; if(lstv != null) { lstV = lstv.toList(" "); info lstV.size(); info lstV; if(lstV.size() == 3) { a = lstV.get(0); info a; b = lstV.get(1); info b; c = lstV.get(2); info c; } if(lstV.size() == 2) { a = lstV.get(0);
get values differ and store in variable
Hi, For example , we have a text as - abc def ghe in that , i want to store - as a = abc b=def c=ghe like this , based on space. because only space is common for all the texts . How can i do this ?? Thanks and Regards, Sidhant A.
How to Fetch report of Subforms with a Lookup field in form 2
I have created an app, due to field limitations, I have to divide my app in 2 forms. My First form also contains a subform to add data according to the user requirements, but that subform fields are not accessible in the report of 2nd form with the lookup
Error
Hi, Getting this error as attached .. Please check asap Code - fet = Form[ID != 0]; if(fet.WEEK != null) { for each rec in fet { // info rec.WEEK + " :: " +rec.ID; sat = rec.WEEK.addDay(5); if(zoho.currentdate > sat) { rec.WEEK=zoho.currentdate.toStartOfWeek().addDay(1).addDay(7);
Automatically moves to next Blueprint Section
Hi, I created a blueprint where I have a Stage A, in the After section I'm executing a set of actions and depending of the result of these actions I want that the blueprint moves to Stage B if success or Stage C otherwise. I noticed that I can´t update
Set Custom Function to Open "Detail View" of a record
This may be an easy solution, however, I am looking to create a custom function button that will directly access the "Detail View" of the same record I'm viewing in another report. I assume this will be some variation of an Open Url script? i know how to create the function, just not the particular code needed to access the record detail view. Any help would be greatly appreciated.
How to show/hide fields depending on their values from another field
I have a Products form I use to insert products to my custom application (built with Creator). There are 8 checkboxes for each product... we manually mark the checkboxes (or leave them empty) during input. Then I have a "WorkOrder" form which also has
for loop of widget - API.getAllRecords
Hi, so i have a widget and i need to get all the records of my report - more than 200. so i can call getAllRecords twice, because each time i get a 200-records page. if i don't know how many records i have, i need to use a for loop of records and loop
Angular support in widgets
Has anyone successfully used angular in their widgets? Is it possible? This is what it looks like in local debug - ng serve This is what it looks like in zoho creator
How to create serial number in sub-form without using if condition
hi.... How to create s_no on deletion of rows without using if condition (or) using auto number fields. Thanks in advance for your help. Raja
Line break code assistance
Hi Could anyone advise how I could code the below to add a line break between each: This is the code: input.Trial_Class_Booked = input.Trial_Class_Options.Class.Class_Name_for_Customer_Enrolment1; This is the workflow: https://creator.zoho.com.au/appbuilder/laura_shireelite/shire-elite/workflowbuilder/Input_Trial_Class_Booked_/edit
Developing widget with real data
Is it possible to configure zet to connect to the app that we're going to be attaching a widget to. I want to be able to develop this without needing to keep packing, uploading and refreshing the page with the widget in it.
Add Record To Form A in Application A when Form B in Application B is submitted.
Problem: I'm not able to select any forms in ApplicationA in the insert record task I'm adding to FormB in ApplicationB On Success action? I know it is more complicated to lookup a record in another application than it is to lookup a record in another form in the same application which i was able to figure out but I can't seem to find any information on "adding" a record from a form one application to a form in another application and I'm not able to select any forms in ApplicationA in the insert
"\t" is not working
Char syntax "\t" is not working since new year, is there anyone with the same problem?
Can i get a zml snippet to show a value that is generated by a function
Hi All, Any help would be appreciated, i am trying to show the last record of data on a dashboard page and below is my code used but i don't think it will allow me. Before you say i know the text value is incorrect, but i was trying different methods. <%{ last_record = Digester_Data[ID>0] sort by Date_field desc; a = last_record.Water_Temp; {%> <panel> <pr height='fill' width='fill'> <pc width='100%' bgColor='#FFFFFF' padding='20px' hAlign='center' vAlign='middle'> <pr height='auto' width='auto'>
Deluge - Quarter Inches - Remove Leading Zero
Hi, I am taking an API reading that is in total inches. I am converting to Feet, Inches, and Quarter Inches. I'm using the following code to round the quarter inches to (.25, .50, and .75) // Routine to Check for Quarter Inches vNumber2 = vTotalInches
Next Page