Fetching records with multiple sort criteria
Wondering if anyone has had success running through a for each collection with multiple sorting instructions.... Example In a view's script you have.... sort by ( rep_name_grid ascending Talked_to_this_rep descending ) In a collection it looks like this..... for each r in Form_Name [group == group_var] sort by rep_name_grid range from startval to (endval - 1) However, in collecting records you set asc and desc in the scriptbuilder :) I tried to make the syntax work
How can I set a message to show when an upload file is loading?
We have an upload and parse script that goes through almost 2,000 records and takes a littler over 2 minutes to process. I would like the user to see a message that instructs them to be patient and allow the file to finish processing before trying to
Deluge code error in crm function
function getProductsByCategory() { products = zoho.crm.getRecords("Products"); categories = {}; for each product in products { category = product.get("Product Category"); if (categories.containsKey(category)) { categories.get(category).add(product); }
Automate and schedule data export CSV to a fisical folder
Greetings, I need to plan to export a table to a folder to synchronize with another software. At the moment I manually export from the settings screen of my "companies" table and save the csv in a specific folder on the physical server accessed by the
fields should be enable in a particular time
Hi, i have a form with 3 time fields,start time end time and shift time.and i added some data into it.Another form with shift time as lookup and some other fields.if start time<shift time<end time the forms fileds should be enable.otherwise fileds should
Creation of a numbered list
I have read a lot of threads on why Zoho doesn't use loops, but here is a case that I seem to run into many problems trying to accomplish. It should be very very simple. In one form, I ask among other things, for a maximum (N) number of entries to expect in a related form. Thus, I would like a picklist in that other form that allows the user to choose which set (1 -- N) that form represents. Usually you would just create a for loop and use add item(num); num++; but that seems impossible on here.
Possibility to create and send ICS file
Hi, I'm looking for a possibility to create an email which outlook can read. Discovered some, but don't know how to implent this into my script. I need to create a ICS file like this: BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN CALSCALE:GREGORIAN METHOD:PUBLISH BEGIN:VEVENT DTSTART;TZID=US/Central:20071214T210000Z DTEND;TZID=US/Central:20071214T230000Z SUMMARY: TEST SUMMARY DESCRIPTION: TEST DESCRIPTION UID:tpn1456-33432 SEQUENCE:0 DTSTAMP:20071207T151700
Number instead of Actual value
Hi All, I have created a form which gets data from other forms. For some of the field, it shows values in DIGIT instead of characters. For example, if i select any customer from drop down list the remaining fileds will get populated from other form. All fields are coming corectly except for CITY. Instead of city name (e.r. Newyork, it shows "1407460000000023095". Can someone help to figure this out? Regards, Medheal
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
Next Page