Reorder report search fields
How do I rearrange the order of the search fields for a report? We have a lot of fields and it can be difficult to find the most used relevant ones that can be buried down. I tried to look at the application IDE and that does not have any effect. Something
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
Is there any work-around to show/ hide formula fields?
Hi, how do I dynamically show/ hide formula fields? The straight-forward way ('show/ hide [formulafield]') doesn't work. Is there any credible work-around?
Hiding Search From Customer Portal Report
EDIT Sorry this is meant to be in Zoho Creator Forum - could an admin pelase move? I'd like to start using Zoho Creator as a Customer Portal but am finding it a bit too leaky on information. I'm trying to setup a simple report tracking contract dates
ZOHO CREATOR
Zoho ceator
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
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.
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();
Zoho Creator : Changing owner of esablished app
We have several apps and analytics dashboards/datasources that were created by the owner of our company. He now longer has the time to maintain the system and wishes to hand ownership over to the head developer. I believe that several elements of creator
Where is the template for "Thank you for signing up"
I can see in the cutomer portal there are templates for Login Page Signup Page Reset Password Page However I am looking for the screen that displays when someone has hit the "Sign Up" button. On my system it looks like this : I would like to change the
Import Error
I try to import a .ds file from the workspace, to create another application in the same (workspace). But while importing the .ds file this type of error occurred "same application name already exists".So I change the Application name and try to import
External CSS. Is it possible to <link> to external CSS from a HTML View?
External CSS. Is it possible to <link> to external CSS from a HTML View?
How to pass dynamic parameters directly in the publish url zoho creator.
Hello I need some help. I am publishing a page. When I publish a page it ask for parameter which I had define in Page argument. When i pass Hardcore value it show its published page preview. But When I pass parameters like input.id and so on. It shows an error in preview. Please tell me how can i pass parameters value during publishing my page.
Zoho Creator Shortcuts
In 2023, Zoho Creator will be getting a lot of new features. Like Canvas and the advanced Deluge Editor, which will improve Zoho Creator's functionality and give developers a fresh experience. I'll shed some light on shortcuts so that you can utilise
Portal permissions
I have recently adapted the Fleet Hub Management app within Creator for our team to use. I have locked down certain parts of the app for the Admin only to have access to and have created a separate profile for drivers (Zoho One users) to use which only
Report summary header and footer??
Hi there! I´m building a report summary to export as PDF. I had set up the page size as A4 and enabled the header and footer. But when the pdf is exported, instead of puting the header and footer on every page, it just puts the header at the beginning of the first page and the footer at the end of the last page... How can i make them to apear as header and footer of every page??? Tanks!! =D
How to input all values from a Fetch Record and return to a Multi Line field
Hello Everyone, I'm having an issue I can't understand. This formula is working. The info statement shows me that all the proper records were retrieved and can be returned. for each r in Workout_Tracking[Single_Exercise_field == varSW] { input.test_report_text
How do I change a Zoho Creator Form's styling with CSS?
Hi there, I have built a form with zoho creator. I'd like to change the field labels to be consistent with the website to which it will be embedded. What's the process for specifying web fonts and changing sizing, colours etc? Thanks
no such view exist
Hi, I am trying to attach report of a form in an email and have written concerned script for it which is as shown below. The name of the form is NMR Labour on site Today ( Daily Wage) sendmail [ from: zoho.adminuserid to: "harish@ebs.com" subject: "Daily
Need better error message when an application error happens
ZC dev team: When running an application, if there is an error, this message appears across the screen: "Error occured please contact application owner." Unlike the (slightly) better error messages one gets in the script editor, THIS message is desperately unhelpful. Right? I would think that when the ZC program catches the error and throws the message, it must have some kind of useful information it could pass along in the error message, such as what statement was being executed or what field was
Error when I create the New Application
Hi, When I import a CSV file and I want to create return "Ooops,something wrong" What's the problem? Any file example? I'm attach the file I'm using. It's correct? Thanks,
How to disable a subform field based on the input of another subform field
Hello, I have a subform within a form. I want one of the fields within that subform (Checker) to be disabled based on the input of another field (Editor) within the same subform. Editor is a lookup field that pulls from the Name field in another form (Team_Members). I want Checker to be disabled when the Status field for the relevant entry within the Team_Members form is equal to "Graduate". How do I do this?
Zoho support
Is there a problem because for weeks we have been sending emails and not receiving a response and no solution ?
Pass values from the current form to a function before submitting the form
Hello, I want to pass the values from the current form BEFORE it is submitted, i.e. it doesn't have an ID yet. Is there a way, apart from manually passing each field value (or creating lists or maps, etc.)? Thanks, Fidel Martín
Private link with parameters
Hi, Is it possible to create a private link with parameters in it? Here is an example: http://creator.zoho.com/zchelp/employee-manager/form-perma/Employee/Employee_ID=1234 The above link will require login information, I want the same link that can be accessed without login info. Thanks! Vishal Verma
Copy or duplicate application - not working with New Application Builder
I cannot copy or duplicate an application. I have been able to do this in the past and it has been a quick an easy way to share application logic between team members. It use to work by clicking on "Copy Application" under Options menu. Has this changed ? Is it broken by the New Application Builder?
Auto Updating Sub form based on a Lookup input that is not in the sub form
Hi Guys, I need some assistance. I have two forms: 01. A purchase request form that has a subform with details of items being requested for. The form also creates a unique number for each submission (the PR_Code). 02. A Purchase Order form that has a
Need to print barcode converted from a number or text field
Is there a way to convert a number or text field in a form to a barcode at least when printing. I need to print label for items that includes a barcode for item number or lot number. This way when the entire item or a quantity of the item is used, the label barcode is scanned by a handheld scanner on the item field or item report search, item record can be opened and the used quantity is entered, instead of having to type the long item or lot number. Does anybody know how to pull a font type (Barcode
Custom Portal on external domain
Sorry for this post looked into it, but just don't seem to get it. I try to add my customer portal to an external domain. Added a CNAME record to the external domain but it just doesn't resolve. Keep trying this, waited 24 hours and such but doesn't resolve and time isn't on my side in this case. for example my domain is https://www.mydomain.com i added a CNAME record with the following example data: Name Type Record Action example.mydomain.com. CNAME creator.cs.zohohost.com Delete Now i tried
Best way to dynamically add large amounts of choices to a drop down
Hello, I've got Zoho Creator app and I have a drop down that I'd like to be able to choose from my items list in Zoho Books. The issue with this is that we have thousands of items and my current method takes too long for the data to be fetched. Here is
Problem in iframe movile version
Hello everyone, I have a problem, I have a development that displays correctly in the desktop version, but the native zoho mobile version shows me in a strange way, it does not respect the proportions, this is a page with three iframes inside, one of
Unselect All Options in a Single Select Radio Button field ...
Hi: Is there any way to "script a single choice Radio Button" field ... so none of the Options are selected ? You can have it so none of the Options are selected at form load time ... by setting the Intial Value property (at Edit time) to blank ... but once the user selects one of the options, I can not use any script command to reset it ... e.g. input.myRadioField = ""; ... does not do it. I can use input.myCheckBoxes.deselectall() with multiple choice (check box) fields ... but not with single
Color Coding
I am making an application that my company is going to use for scheduling construction jobs. We have one form that the output is placed in calender view. We would like to show each job on the calender and have it color coded occuring to the team that is working on it. Also on calender I need the entry to show on every day between my start date and end date automatically. Is it possible?
Set View Criteria: How can you specify "is empty"?
I have just racked my brains and plowed every resource to come up with this solution with no luck. I want to create a view with restricted criteria where a "fieldname" is empty. This helps me know which records need to be updated. Many resources point to creating a view where a fieldname is not empty, but doing the opposite has not worked. Can anybody walk me through this?
Record Detail View in Page
Hello, is it possible to show an Detail View of an single Record in a Page? Simon
What's the difference between Rebranded Custom/Mobile Solution and Custom Solution?
What's the difference between the two below? I'm being told by Zoho Support staff that they're the exact same thing. I'm struggling to see the connection. These seem to be two different types of solutions... 1. https://www.zoho.com/creator/newhelp/app-settings/understand-download-mobile-app.html
Usage limit reached?? At 0?
I cannot enter any records because when I select "Submit" I get this message: "Usage limit reached. Your limit is 0. Your current count is 0. Please purchase Add ons or delete some records." I have a free account and haven't entered any of my 1000 records. Any assistance with this would be greatly appreciated... Thank you so much.
Captcha verification not working
Hi, I have embedded a Zoho Creator form on my Wordpress site and the Captcha verification is not working. It refuses to accept the verification code I enter. I've tried it multiple way (caps, non-caps, Safari, Explorer) without success. I see a number of previous problems reported on this topic, but none appear to have been resolved. Thanks, Peter
Zoho Creator REACT JS widget
Good day, I have got a REACT JS widget that runs successfully in the Local Host Test Environment, but I have no idea how to pack and zip the widget in order to upload it to ZOHO. I did not use the Zet CLI to develop the Widget, seeing as I am using REACT.
Default View All <form> to show only the user's own records? Restrict fields to specific roles?
Is there a way, short of creating a custom report with specific criteria to be able to view all records that belong only to them (those that they created)? Or, more generally, be able to configure the permissions on certain forms such that it is impossible
Next Page