Community-driven poll for feature requests
How many of my fellow forum users are interested in having a community-driven poll for feature requests? Something far more useful to understand and easier to use than manually +1'ing topics? For example: a polling system that breaks out poll topics by:
Change filename in export pdf
It is possible to export to pdf by changing the file name both for users and for the customer portal without publishing the report. For users it can be done by setting a custom action but I don't know how to do it for the customer portal without publishing
Sync from production to development
Hi, I've accidentally delete a page in my Creator development environment. It's deployed correctly in Stage and Production. How can I restore it in development? Thanks, Aaron
Learn Try Catch
Hi, I am just starting learning Script Deluge. I am taking the course "Learn Deluge" and i got stock here. can somebody help me?
Are there try catch statements in deluge?
How can I catch errors? I'm using this script: void googlemap.getLatitudeAndLongitudeMap(providers provider) { /*address = provider.Full_Address; latandlngXml = getUrl("http://maps.google.com/maps/api/geocode/xml?address=" + address + "&sensor=true"); // Retriving xml containing latitude and langitude xml if ((latandlngXml).length() > 0) { latitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lat/text()"); longitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lng/text()");
Possible Use Case for Zoho Creator: eBook App / Offline Website?
Hi Zoho Creator Team, Please confirm if you have any resources describing how Zoho Creator could be used to create a book app / offline website? We have a book website (www.agribook.co.za) which we would like farmers to be able to access while offline,
Shared Data - Developed App for Multiple Clients
Hi, I am currently designing an industry-specific app that I would like to sell to multiple clients. I was thinking of creating a single app (or DB) that has all vendors in it and uses it between all clients. This way I didn't have to populate each deployed
Copy data from one subform to another subform in a different mainform
I have two sub forms in different main form. I want to fetch all the subform rows from one subform to second subform. Thanks in advance.
Total when deleting subform row
I have a subform which contain a field 'SubAmount' ,which gets summed to 'Amount' in the main form. Is there a way for the parent form 'Amount' total to update after a sub form row has been removed, but before the main form has been submitted? I've tried this "On Delete Row", but it doesn't seem to be working. delete from Washpack_SubAmount[ ID == row.ID ]; grandTotal = 0.0; for each item in SubAmount { if (item.SubAmount != null) { grandTotal = (grandTotal + item.SubAmount);
Custom Layouts problems
Recently the custom layout for mobile and tablet have stopped being applied in some reports. Attempting to make changes to the custom layouts for mobile and tablet have no effect. Can you check this please!
Zoho Creator lookup field data transfered to Zoho Forms form
Hi guys, Struggling with this but I have a form in Zoho creator with a lookup to the ID which works great within the app. Trouble is I need my form to be a bit more child friendly and Zoho Forms offers this in the picture options that it has. I have now
How powerful is Zoho Deluge combined with Zoho Creator to develop complex apps?
Hi! I am trying to understand how powerful are Deluge and Creator to build new software. Let's say you want to build a complex application like an ERP (obviously this is just an example). Are Deluge and Creator capable of achieving this? I wonder if Deluge
Amount Display
Hi, Is it possible format amount display like "1,123,123.00" rather "1123123.00". It is hard to recognize Long number. Thanks for your great work. Ming zhumingca
Sendmail function / custom action?
I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been entered
The Zoho Creator 6 - 100Rails Manifesto
Hi Folks I thought if I DON'T ask I will never get , so below is a list of FEATURES or FEATURE CHANGES that I have been thinking about for a while with ZC 5 that I wish were being included. I have listed below some areas that I think need rethinking: SECURITY needs standardising on Profiles that can be SHARED and new users INVITED programmatically. Do NOT tie menu sections to security. Improve the profiles with deluge commands. USER INTERFACE needs improving for Developers as the number of clicks
Run a script on a date range
Greetings all.... I need to write a script that runs on a range of dates. I understand how to use the for each record and for each list value but I can't figure out how to iterate a script based on a date range. For example: The user enters a start date and end date... The script runs a series of actions (if then statements) based upon each date in the date range. Thanks in advance for any help you can offer. Joel
Subform fields width
Hello, I write several times about this problem, and understand that you have your roadmap of developing but... In subforms, we can't control width of fields. Sometimes it's critical - for example, lookups fields, when displaying text is wide. It's very hard to find your value, especally when values a very similar in start. Some time ago, we have ability to use some css tricks and use "notes" field in form with this SubForm where I write something like this: <style> div[...some css selector to select
Relating two Lookup fields and making them dynamic
Hello, I am trying to find a solution on how can I relate two lookup fields and how can I dynamically change the values of one lookup field on the basis of the choices made in another lookup field related to it. For example, I have two lookup fields;
Zoho creator Page Break
So I recently started using Zoho creator, I want to make a Multi-page Form, but I can't seem to find the page breaker according to: https://help.zoho.com/portal/en/kb/forms/user-guide/form-building-tools/multi-page-forms/articles/multi-page-forms#Cr
Can you format Formula field results at all?
I have a formula field that divides one number by another and produces a percentage. Except it displays as a decimal i.e. 0.666 instead of 66%. Is it possible to apply formatting to the result to make it display as a percentage? I have seen an old post
Form as PopUp Box
I am having a difficult time successfully displaying a Form in a popup window. Deluge Script - On load: thisapp.PopUpForms.PopUpAddEvent(); Function: void PopUpForms.PopUpAddEvent() { openUrl("#Form:Add_Event","popup window","height=600,width=1200"); } Problems/Issues: The purpose here is to allow our Users to submit an "Add Event" form while on another page/form/etc. The popup displays with the code above, however the background/main window also changes to the "Add Event" form and the popup
How to simulate a Quick Filter on Single Line field in List view?
How to simulate a Quick Filter on Single Line field in List view?
Autonumber subform rows through deluge script
Hi all, Ive been trying to create a numbering system for each new subform row added. The problem ive come to is on add row, it doesnt show show the value Im trying to display Here is the code ive tried: on Add row: linecount = 1; for each item in Items_Ordered { //This will autonumber each new line added in items ordered items.Line_Number = linecount; linecount = (linecount + 1); } The output I'm looking for is to have each new row added contain a row number, starting at 1 and increasing
Simple Photo Gallery in Creator
I'm wondering if anyone has ever created a simple photo gallery in Creator. I'm envisioning an HTML view that has a list of links dynamically created from a separate Photo_Upload form. The form includes a title from the photo, a caption, and the upload field, with a possible option to denote a default photo to show on the HTML view. The HTML view shows the default photo with a set of links above, possibly a dropdown menu. Using the iframe refresh method, if a link is selected the picture changes.
Is it best practice to use the exact same if statement in two different places?
I'm using the following if statement: // Display Writer Rate field if Position contains "Writer" and Type is "Freelancer"; hide otherwise. hide Writer_Rate; if ((input.Type == "Freelancer") && input.Position_s.contains("Writer")) { show Writer_Rate; } I've included this statement within the On User Input section of two different fields: Position and Type. Is that best practice? It feels messy to me (e.g. if you wanted to amend the if statement, you'd need to remember to do it in the two different
Dose ZOHO Creator Support a True JSON POST ?
I want to make POST Request to Google Calender API and its Content Type is in JSON Format for example look image1. see its content type is in JSON Format and i am Writing code which will make POST Request to Google Calender API but ZOHO is not sending the JSON format to Google Calender API. what should i do to force it to change in JSON Format. here is something i am geeting look image2= So how i force ZOHO to Change its Content Type to JSON and i Want to Send Actual JSON From ZOHO to Google API
Custom layouts not working
Something has happened with the custom layouts in the last updates. I have custom mobile layouts but they have stopped applying in the last few days. Does anyone have information on this and how it can be fixed? It happens to me in several reports.
How to hide/show a section in Zoho creator 5?
Ho can I hide/show an entire section in Zoho creator 5. I searched for the solution but every says go to Application Settings<Sections. But I don't find sections page in settings. Here's how my section page looks.
Record Template - MICR Font
Please add MICR font to Record Templates. This will enable users to issue checks from Zoho Creator.
Tip 4: How to dynamically display images in a live form.
Hi everyone, We hope our previous tip was useful to many of you here. We are back with a new tip that would help enhance the user experience of your app. Yes, that's right. Today, we will look at how to display an image in a live form that is already uploaded using another Zoho Creator form. That is, we will auto-populate the image within the Add Notes field based on input in another field. The logic behind this is pretty simple — just store, fetch, and display. To get a better understanding, let's
Multiple modal forms for one record with prev/next buttons
Hi, I've made multiple modal forms with prev/next buttons for data entry for one record. The modal forms are opened as a pop-up. The one problem I have is that I can't close the modal form that is open when clicking the next or previous button. So that
Invalid Entries Found on Hidden Required Fields
When I submit a new record a warning appears that says "Invalid Entries Found" on a hidden required field. When a required field is hidden an error should not appear. And it hasn't for me in the past. How can I fix this problem?
Duo Two factor authentication
Hello, Do you support the integration two factor authentication (duo.com) within an App Developed Zoho Creator? I need to be able to insert the two factor authentication within the login form in certain circumstances (e.g. based on the user IP location). Please advise, Regards, Edson.
Sort Lookup field by frequency of usage when table is in another application
I have a list of items in App1,->Form1->TextField1, w/ an additional number field "Count" which will ideally collect the number of times each item in TextField1 is used in App2->Form2->Lookup. I think I know how to sort the Lookup in App2 once I have
Possible to Filter a Zoho CRM Lookup Field
Is it possible to filter a CRM lookup field onload? If not possible, is their a good workaround? I'm basically trying to pull all cases with status of "New" from the CRM so a user can select one for updating. We have about 5000 cases but only ever have
Get User Language
Hi, Question: How can I get the User Language via Deluge Script. Use Case: The user set up the language to A. Then the user opens a form. In this form is a Note field in language A. When the user change the language settings to B the Note field change to language B. Solution: Set up localization settings with language A and B Create a Workflow when opening the form Create a If/else deluge script depending on the user language settings when opening the form Change the input.note value to whatever
Create a Capacity Schedule in ZOHO
I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will
Export Limit
Hi, I am trying to export report to XLS but there is a limit saying it's limit to 1000 records. Is this intentional? As I saw from the Known Limitation, export to PDF is limit to 5000 but it seems that everything is now limited to 1000 rows? May I know
FYI: how to show/hide subform delete entry for specific users
Create a hidden (admin only) field in your main form, e.g. Current_User Create a workflow for your form: Form > Edited (or Created or Edited) > Field Rules > name of workflow Add two actions: Action #1: Execute without condition, Set value of [Current_User]
How to download multiple files in Creator?
I'm trying to download multiple files from a creator report using a for loop but it only seems to be downloading one file. It seems like no more code can be run after downloading this one file. Is there a way to download multiple files? I'm currently
Next Page