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
Augmenting subform capabilities
Greetings, everyone! Finally, the day has come for us to announce some of the most anticipated, requested, and exciting updates to subforms in Zoho Creator. As you're aware, subforms are an integral part of Creator forms, as they help in establishing
How do I get the sum of a field in a sub-form
I am completely new to Zoho Creator. Using the SUM documentation below, I attempted to use a formula field to sum a single numeric field in a sub-form. I could never get it to work. I then tried with all fields in a db with only one form. Still no go, and I got the same errors. Should sum() work in the Expression property of a Formula field? If not, where do I use it to get a total for a field? If the sum function is not the way to go, what is? Here are results of various entries in Expression
Selling Zoho Creator's apps as a service
I've been thinking and working at several apps that i would like to sell as a service. So I've been studying the developper area to see if i can make a profitable plan. But, at the developer console, when i try to create a pricing plan, i see that the base price "will be decided during Review"... This doesn't allow me to make a business plan because i cant calculate the costs of using Zoho's platform. How do you suggest i should do my business plan?
Restricting Calendar View to Working Hours
Hi: I'm trying to implement a calendar which displays all of my customer appointments. Currently, the calendar shows all 24 hours of the day. Is there a way to restrict the hours to simply the times my business is open? Thanks!
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
Pivot table reports stuck on regeneration
Hi, All my pivot tables have been stuck showing "regenerating" for 24hrs. All tables are now only showing partial data. There are only 4000 records in the entire database so not a lot of data at all. Problem is we need to report on that data TODAY! I
Input validation phone number
I am trying to find a way to make field constraints for input of a phone number. Example: France (country code 33) local number 0142687984 should be input as 33142687984 and not for example 00331 42687984, 0033 (1) 42687984, +33 1 42 68 79 84 etc basically the number should never start with 0, should not include spaces or signs like + ( ) etc and should have at least 9 digits I have been trying to find a sample for deluge scripting but no success. Please help
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.
Introducing Cloud Functions
Hello App Creators, Greetings from Zoho Creator! We are happy to inform you about a new feature in Zoho Creator called Cloud Functions . They are functions which are executed serverless, supported only by Creator's infrastructure, and hence the name Cloud Functions. The new cloud functions support two languages: Java and Node.js. This feature will be available under the Functions section of the Workflows module. Once these functions have been configured and written, they can be called from any of
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
Window tablet native app
Hi Zoho, With windows based tablets are becoming more popular and starting to gain market share from Android and Apple it would be nice to see Zoho publish the Creator app for larger devices. We are moving all of users off the ipad onto the Microsoft Surface line this year and would like to use it as a native app. I would assume this would be very useful for many businesses... Windows phone version is already created and published, why not make it available for tablets? Thanks for your consideration.
Formula field Calculation Used in another formula
Hello! I' m having issues trying to show the price after date selection. * I have to dates ( arrival and departure ) * I have a formula field (total days) that calculate the days difference ( everything working so far) * I want to have another field(Price total) that shows the price depending on how many days in (total days) I tried to go to workflow and add a new action that says If total days is 1, set field value (Price toal) to 590. It didn't work, so I tried to do this with another field
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
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?
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
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.
How to get zoho.loginuserid or loginuser in JS SDK Widget in Creator?
I want to use zoho.loginuserid and zoho.loginuser variables inside my JS widget. How to achieve this? Keeping in mind that these 2 are very important variables. Would parsing as parameters be an option?
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
Can you create confirmation messages in Zoho Creator?
Hello, I would like to create a confirmation message that asks the user to confirm that information they have added in a field is correct when they attempt to submit the form, and gives them a "Continue" or "Cancel" option. Is this possible, and if not, is there a workaround? Thanks!
How to read a file from workdrive
How should I read a file with deluge from zoho workdrive? ( more specific a json file? ) fileVariable = invokeUrl [ url :"https://workdrive.zoho.xxxxxx" type: GET connection:"workdriveconnection" ]; is working, but i not succeed in getting the file content.
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
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?
error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
Zoho Creator Upcoming Updates — March 2023
Hello all! Zoho Creator continues to rapidly develop new features and functionalities to help you solve your business challenges. We'll never cease working to amaze you with incredible new updates. And today, we're announcing a neat range of features
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
Multiple criteria in searchRecords
Hi, is it possible to search with multiple criteria in zoho.crm.searchRecords? I have tried several variations of the following without much success. CustomerRecord = zoho.crm.searchRecords("Contacts", "(First Name|=| lee)" && "(Last Name|=| spencer)"); Thanks. Chris
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
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
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.
Feature Request: Dynamic Field Names/Labels
I would like to suggest a feature that allows us to flex the Display Name (sometimes referred to as Label) of a Form Field. Example: Lets say I have two clients using the same Zoho Creator Form to input employee names. The Form has a hidden field called "user code" that I pass into the form via a URL to distinguish which client is doing the data entry. One client has normal employees, but the other has interns. Using the same field with the same deluge name, I'd like to change the display/label
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
Lookup returns ID not value
I've created a sales order form, and when I select the account for the sale via Lookup it returns the ID for the Billing Country, Billing State, Shipping Country and Shipping State instead of the value. Here's the code I am using to pull the account information into the order form: selected_Sold_To = Account [ID = input.Sold_To]; input.Billing_Street = selected_Sold_To.Billing_Street; input.Billing_City = selected_Sold_To.Billing_City; input.Billing_Country = selected_Sold_To.Billing_Country.toString();
How to disable sub-form fields?
For each line in my sub-form, I have various fields that I don't want the user to be able to edit. There are also a few fields that I want to be kept hidden but I can't seem to figure out how to do that either. I've created a new workflow for adding a
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];
Migrating a Zoho Forms form into Zoho Creator
Hi, How can I migrate my Zoho Forms form into Zoho Creator? Thanks. Truly, Emad
Next Page