How To Pass Parameters To Filter Report By Address Subfields?
I have an Address field with Subfields...I am trying to pass parameters to filter by State or Zip Code in a report. Can this be done? state = "CA"; For example: report_url + "?Address.state_province=" + state; ...does not work.
Zoho People Integration in Zoho Creator Through Deluge
Hello , I am doing zoho integration in zoho creator through deluge , I got the records when i am doing this: zoho.people.getRecords("P_Task") ; , zoho.people.getRecords("P_Employee"); etc. but i am stuck here when i want to get the LMS data which is a
Best of Creator App Examples
Does anyone know of or have examples of really awesome Creator examples? Perhaps some great HTML pages? I've been digging into the app for several months, and have been trying to find examples online of very well designed Creator app examples, but come up short. I know there are the pre-made applciations in Creator, however, they all appear dated looking. Would be great if Zoho would periodically provide a showcase of great Creator examples and the back-end code to make them.
ZC6 - No custom order for sorting/grouping ?!
Hello There, Upon analysing we could see that you are in the C6 version of Zoho Creator in which the custom order sorting/grouping is not supported as of now. I have raised a user voice for the same and our engineering team is working on the possibilities.
Dynamic Filter for CRM Integration Field
Is it possible to filter an integration field in the same way you can filter a dropdown or lookup field, by using ui.add() with a list of the module record ids I need to show? I am working on a Creator app that will be integrated with CRM. I need to be
Redesign - Rearranging sections in ZC
Regarding rearranging sections in ZC, I think the current layout of the panel could use a very simple tweak to make it way more usable. Currently you are trying to fit the "active" and "inactive" components in one columns while you still have tons of
NodeJS version
Good day! I would like to ask what NodeJS version is used in Creator. I am planning to incorporate node scripts on a POC project that we are making. Thanks!
Trying to send email using CRM template via API from Creator
Hello Everyone, I have been trying to send an email template that has been stored in CRM via an API function that I am executing in Zoho Creator. I am using the following function: email_mp = Map(); email_mp.put("from",{"user_name":"xyz","email": zoho.loginuserid});
How to use a dynamic value in and API call with invoke url
I am working on a form that will autofill multiple fields based off of a parameter (Case_Number) value that is passed through url. I want to append that value to the endpoint in my API as query so I can grab the corresponding data to that Case_Number
How do I collect single-row checkbox value in a report?
Hi Zoho Community, I would like to collect a report checkbox value and would like to execute some Deluge code based on checkbox-checked report rows. Is there any way to collect this checkbox value?
Calling function in another app
I have 2 applications in our account. I want to call function1 in app1 from app2. I have tried to create a function and use the following code: myvar = app1.function1(); But I just get "not able to find 'function1' function. I've tried with the function
How do I fill a single form two relational lookup fields data with select data?
Hi Zoho Community, I have created a zoho creator form with two dropdown lookup fields and I have set the query to filter one lookup field's data based on another look field's input data. But When I have filled the lookup field value with selected data
Conditional enable/disable of subform rows
My app contains 2 forms: MainForm = Contains some data in various fields Subform = contains comments in the form of multiple rows My users can add new comments by adding rows. All this is working fine. What is needed is: 1. Disable all rows "comment field" when the MainForm is edited e.g. "disable comment;" 2. On Add Row, enable the field e.g. "enable row.comment;" I can successful achieve #1 by adding "disable comment;" in the Edit -> On Load. However, when I add "enable row.comment;" on the "On
Pass This Year Filter in zoho Creator Report URL
Hello Team @Bhoomi Joshi How we can pass this year's filter in Report URL Inside the zoho creator? Please update on this asap. Thanks & Regards Piyush Goyal
How to utilize a callback URL with Zoho Creator (OAuth 2.0 authentication)
I have successfully made calls fetching public data from the Socrata API, but I am attempting to work with a private dataset that requires OAuth 2.0. I am having trouble with figuring out how to use a callback URL to handle the token. Any feedback on
new system field
what is record status(system fields) in zoho creator?
How to use QR codes to lookup a record
Hi all I've designed a simple equipment record and maintenance tracking app. Everything works fine, but we are planning to have QR codes on equipment that can link straight to its own record. Rather than get URLs for the equipment records from the QR
do invoice for customer for automatics invoices
I have an application in which I serve clients, I worked a contract between me and the client on a certain date, I want to send the customer invoices that 3 invoices every end of the month how to do that in the Creator, and how to separate his clients
redirect to edit record form from creator widget
Greetings i'm working on a widget for my creator app where i'll be displaying details of different records, for each record i want to have a button where the user can click it and be redirected to the edit record form to edit that specific record. how
Zoho Creator - How to avoid multiple IF statements?
Hi All, Is there a way to avoid multiple if statements by referencing a map or similar? For example, I have dropdown list with 15 options. The input of this field will trigger different options in the form. I want to avoid 15 separate IF statements so
Need an Application to Creating Interview Tracker using information from Candidate Module and a custom module ( Interview information ) using Zoho recruit and Zoho Sheet
Hi Zoho team, I would like to have a online meeting with your creator team to make them understand my requirements, show them how we are doing and so that my requirements are captured and flow of development work can be defined, You may suggest a developer
How do I round up a number to the nearest 1000 or round down to the nearest 1,000?
For example: Round up the number 133,768 to 134,000 (nearest 1000) Round down the number 133,768 to 133,000 (nearest 1000) Thanks
Update production data from development environment C6
Hi guys, I am using C6 and one of my struggles is that I want to update some production data without needing to create a function and transfer this to the production environment to update some data. Little bit of elaboration: I have invoice lines in Creator
Material Reconciliation in Zoho Creator
I have created a Zoho Creator app for my purchase and production. Now I want to create ledger for material code that is Receipt and Consumption and Balance for a particular period. I don't know how to achieve this.
Recording values in different currencies
I have a creator form that we use for survey recommendations and, at the moment, the value saved is set up as £GBP. However we have some clients from other countries and would like to save a value as a different currency. It doesn't need to make any exchange
Hide sort & group options in mobile app
Hello. Is it possible to hide the grouping and sorting options in the mobile app in a report embedded in an html widget?
Royalty/Sum Calculation app based on uploaded statements.
Good afternoon. I'm relatively new to Creator but have adopted the software for my new business currently setting up. I plan work in music publishing and have the following question. Is it possible to build an App in creator where i can upload a royalty statement from a record label (as a .CSV or Excel File), align the columns and then calculate % splits and report out the new statements? Something similar to this - https://label-engine.com/record_label_accounting.php
How to protect my reports data.
I don't want anyone to copy my report data. For now able to select all and then copy hole data. How to stop Copying data.
hide formula field
Now that there is an option to show a formula field on a form we also need the ability to conditionally hide these fields. When I try to hide a formula field the following error message is displayed. hide/show/enable/disable fields is not applicable for formula field Herb Wexler
How to change the Permalink(Publish) Form- Width and height
Help me to change the Width and Height of the Permalink Form Which the Permalink is Published . Is there any way to change the Width and Height without customizing the fields in the Forms?
how to make creator widget sdk work on my localhost
Greetings i'm trying to connect my widget to my zoho creator app, what i have now in my code is the basic example: ZOHO.CREATOR.init() .then(function (data) { console.log(data); }).catch(err => { console.log(err); }); this code doesn't work locally, it
Zoho Creator Environments is an underdeveloped feature that is full of bugs
I have been using Zoho Creator for the past year and a half for developing and maintaining a custom business system for a client of mine. I want to start by saying, I think Zoho Deluge and Creator is general is a very powerful and useful tool. I have
Lookup Field Checkboxes
Hi, I have this problem currently in all my applications. To simplify I have created a Test application with the following form: form Untitled_Form { displayname = "Untitled Form" field alignment = left Checkbox ( type = checkboxes values = {"Choice 1", "Choice 2", "Choice 3"} ) Choices ( type = checkboxes values = Choices.ID displayformat = [ Single_Line ] sortorder = ascending searchable = true
Is there a way to have custom scriptable buttons in creator forms without being forced to resort to use stateless forms?
Greetings In my form i need a very simple functionality that is to have a button submit a record and then be redirected to another form, and another button to submit a record and reload form so a user can enter new records. the only way i found to be
Deluge code formatting
Hello Zohoholics I'm trying out Zoho Creator and there is a lot to like. Coming from a programming background I'm enjoying the productivity gains in Creator. But, as a low level coder the Deluge editor is reformatting my code! It removes spaces and moves my braces placement. This is not good - any way I can turn this off please! Also is it possible to theme the Creator itself (not the application) to have a dark background (or at least the code editor). Thanks in advance. David.
Referencing a filw in Workdrive
Hi, I'm building a form where the user will need to reference (not upload) documents hosted in our workdrive. I thought about using the Upload field, but this would copy the document from workdrive to Creator. Not reference it (is permalink it) Using
check vacation request on other form
Hi all, Could anyone help me what's wrong with this code? My intention is if the assistant set vacation status on the Timesheet form the script should check if the employee has a valid vacation request for the certain day on Vacation form. checkvacreq=Vacation[ID==input.Name];
Update account on inventory bundle
Could someone please give me the deluge code needed to change one of the account numbers on the accounting transaction that's created when you create a bundle? Specifically, the entry is: DR Finished Goods CR Uncategorized expense And I want Deluge code
Subform details in a email
I have read the following: https://www.zoho.com/creator/help/forms/creating-subforms.html#To_send_subform_details_in_an_email and tried putting this into my form: message=""; for each item in Progress { message=message + item.Progress + "<br />"; } But this is getting ALL the items in progress, but I just want the ones that have been added as subforms to just the current form. How do I do this? Is there a way to identify in the subform what mainform ID is associated with it?
Dynamic Population of Subform Dropdown
On the user input of a field in the main form, I want to auto create subform rows (based on records in another form) and populate a dropdown field in each based on a third form. I've been able to dynamically populate subform row dropdown fields on the
Next Page