Disable Fields in a Spreadsheet Report
I am VERY new to Zoho, and I am trying to create a spreadsheet report to allow me to update multiple reports in a grid. I have figured out how to include and exclude fields, and how to limit the report to only allow edits, but I can't figure out how to disable some fields, but not others. I want to be able to assign a "follow-up type" (mail or fax) to a record, but I don't want the user to be able to change who the record is assigned to, only change the "follow-up type". Is this possible? Thank
Pop-Up "Close" & "Cancel" Buttons disappear after Cancel Submit
I have a Pop-Up Form. In the validation workflow, I have a Cancel Submit for when I client doesn't submit the correct information on a SubForm. The Alert and Cancel Submit return to the Pop-Up correctly. If I hit the "+ Add New" to add a new row, the
Order Form price sheet best practices
I am creating a project/order tracker for a Solar/HVAC installation company. Materials costs have been changing multiple times per year, So I need a layman to update the price 6-7 times per year. My question is, what is the best way to accomplish this?
NodeJS Functions: Add multiple files
As the title states, how do you upload large libraries all in one go to NodeJS functions?
What is syntax to get data from an Integration with CRM?
Please see videos which show two related questions. https://workdrive.zohoexternal.com/external/472ac1aa2c361ced8bc678d40db810f004ba18a3da7992311c25ec73bee1ac5e https://workdrive.zohoexternal.com/external/b1f8b571f82fe8b4d79cbc8bea7214910cf5a110c4c2
Zoho Creator filtered by prameter passed
Hello, Is there a way to pass a parameter for filtering a report (no a page) in Zoho Creator ?
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,
NO OUTPUTENCODING message
Hallo everyone, today when I export a html page for printing, it appears the NO OUTPUTENCODING message as you can see in the screenshots. I search the code of the page and I made also a screenshot in case it helps! Thanks in advance for your help!
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 can i use edit url in the html snippet dynamically using parameter ? after clicked on that value
after clicked on that value .. How can i use edit url in the html snippet dynamically using parameter ? for each record their corresponding record will open.. Can we have sample url for the same ?
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
Is there a way to do an "OR' search on a column, using normal Search?
Is there a way to do an "OR' search from the normal Search? Such as to find tenant name (text field) that contains "starbuck" OR contains "coffee" OR contains "brew"? If it is possible, please reveal the syntax. (I see that the Global search allows OR. But Global search does not assume wildcards and does not work right when wildcards are used with OR. And, global search has limits vs. searching on the actual report.) (And, using an automatic Filter requires a Lookup field, and this is not practical
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,
Bulk Edit Issue
Now the record Bulk Edit execute the Script On Edit --> On Success, But it was just update the selected field in Bulk Edit. Sample: If I want to update the Status field only to "Canceled" but the Status will be updated to "Completed". based on the script. Please advice about new Bulk Edit behavior. Omar
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);
Including field data within a URL
Hi, I'm trying to embed some fetched data into a URL to send out in an email but struggling. I have a field against a user called Calendly Username which i'm fetching from that form. That is all working fine. What i'm struggling with is using that data
Cannot Find Payment Module in Zoho Creator
Hi, I'm trying to integrate payment processing into a form I have on my application, but cannot find the option to add the relevant field anywhere. I have configured a Stripe connection (see first image), but there is no option to use it in the Integration
Next Page