Deluge script - button click - can't hide or show field
Just wondering why custom buttons can not hide or show fields? Error on show or hide is "show" can only be used on load actions. But a decision field can show or hide a field, so why not a custom button?
Stuck on "Please wait, while we work our Magic!"
Hi I've just created an account but cant use the templates, it just says gets stuck on "please wait, while we work our magic" Can you help please Thanks G
Creating Database first in Zoho
Hi, I'm just wondering if it's possible to create a database first in zoho before creating any form? Or is zoho's database depends on the form you created or files you imported? Thanks in advance for the answers
App Problem
I have four shared apps in my portal, 3 are working but the fourth seems to be disconnected. I can open it but am unable to do any search or functions period.
Encrypt name, address, phone number
I see we can encrypt single line and number fields but I don't see how to encrypt name, address and phone number fields. This seems pretty important for an added layer of security. Any thoughts about how we can do this?
How to craete PDF and upload to workdrive?
Hi, We need to create pdf and upload to workdrive. 1. we have success create pdf by caretor url. 2. we have sucess upload file to workdrive. But the url that craete pdf didn't upload to workdrive it need actual file url. Any trick to make it.
Kanban Report by User Fields
It would be nice to be able to create a Kanban report by the system user fields. Those are finite, just like a lookup, dropdown, or radio button. My use case is that users (employees) scan codes for tasks completed, and that form uses the system 'added user' field to designate who did the work. I would like to be able to see this is a Kanban setup by user, which is not currently possible. I realize that I could add an additional dropdown field and have it set by a workflow based on the added user,
Version 5.24.1 iOS bugs
Creator version 5.24.1 is causing havoc. Please update us on progress. Users report date format issues on existing records and Address field no longer has tap to adjust location. Now there are no apps shown in workspace view. All issues reported are on iOS.
Is it possible to merge two Zoho Creator apps into one app
Is it possible to merge two Zoho Creator apps into one app It would be very useful if I could
form.submit
Hi, I'm using the Zoho Creator for an inventory management application and have found most things really awesome. I require to do an auto submit of the forms once all the fields are filled up correctly, something like a form.submit in Javascript. Is there a way to do this ? Is there a "force submit" counterpart of "cancel submit" ? Is there a way we can embed our own Javascript to do this ? Thanks, Zainul.
PDF from Page properties
Hello, I am generating few tables using page from different forms and reports using HTML snippet. But when i try to export the page as pdf i receive the the following view which the file i have attached. Here's the code: <%{ fet_UpperWear = Upper_Wear_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_BottomWear = Bottom_Wear_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_KidsWear = Kids_Garment_Stock_Report[Stock_Location.contains(param_location)]; fet_Accessories
Fteching Data from Lookup Field in Another Form
I have the following Forms: Form Name: Components Field: Comp_Description Field: Comp_Category (this is a LookUp field linked to another form named Category) Form Name: Category Field: Cat_Category Form Name: Pricing Within this form I am fetching data from the Components form using the following script: if(Components[ID == input.Pricing_Part_Number].count() > 0) { x = Components[ID == input.Pricing_Part_Number]; input.Pricing_Description = x.Comp_Description; input.Pricing_Category =
Filter a look up
We are looking at getting zoho creator. The first part of what we need to do is create a fliter on a lookup....I am told this is achiveable - but how?
Zoho Creator | Scheduled downtime for EU users on September 27th, 2020
Hello App Creators, We want to make you aware that we've scheduled a maintenance activity at our EU data centers on Sunday, September 27th, 2020, from 3:00 AM to 3:15 AM (UPDATED) from 1:30 AM to 1:45 AM CEST (Central European Summer Time). During this period, Zoho Creator will be completely unavailable for the accounts in our EU data centers . This means that the following will be temporarily inaccessible for these accounts: The Creator applications and their schedules, integrations, and APIs The
Problem with Mass creation of invoices
I have a script to generate an 'x' amount of invoices. Recently I'm facing the problem where in example, if I tell the script to create 120 invoices; the script stops working when it creates 70 invoices, and the rest don't get created. The script used to work fine and could create even up to 160 invoices. Below is the following error, and an example of the script that creates the invoices. Error details: Error in executing On Edit - On Success script. Value is empty and 'get' function cannot be applied
Conditional switching of mandatory field status
Hi I have a form that requires a number of fields to be hidden depending on the selection of a yes/No radio button field, ie if the radio button selection is "no", then about 6 other fields are not necessary and must be hidden. Obviously, if the fields which must be conditionally hidden are defined as mandatory, then on submit, errors are thrown for each of those hidden fields. Conversely, if the radio button selection is "yes", then all fields must be shown and they must be required fields. Is
Intigration with facebook
Hi, This is Surya, I am trying to integrate with Facebook and i want to post an image to Facebook from the creator using deluge [The image was already uploaded to creator using image field from local storage]. It is working when I use an image URL from external sites. But I can't post the images that are already uploaded to zoho creator.Please give me a solution for this. Regards, Surya.
Linking Customers to Customer Portal
Hello! I have a Form with 50+ Teachers. Each Teacher has multiple Students. Two Questions: 1) What is the best process for me to create portal access for all the Teachers? 2) If they log in to their customer portal and fill out a new form, how do I only show their students? Thanks!
Detecting a user closing a form without submitting it.
I probably know the answer to this but I though I'd just ask in case someone has found a way to do this. is there a some kind of on close or on quit event where deluge script can be run when a user cancels or closes a form or quits the window that a form is open without submitting or updating a form.? It would be useful for us to do some data clear up if this happened to one of our forms. Thanks
Upcoming updates - May-June, 2020
Hello App Creators, We'll be releasing the following features in the next 2-3 weeks: API v2 Mobile SDK Federated login support for customer portal Lookup creation UI revamp Enhanced offline capabilities Support for duplicating permission sets Satellite and street views in map reports The following features from our previous posts: Freezing subform headers Beta property that brings improvements for printing and exporting records as PDFs Upcoming online training: - - - - - - - - - - - - API v2 Availability
updateRelatedRecord does not overwrite CRM list
I am using the following command to replace the contents of a related list in the CRM with those of my own list. updateCRM = zoho.crm.updateRelatedRecord("Products",productID.toLong(),"Accounts",input.Account_ID.toLong(),Map:String({"Products":subList})); It adds the records of my list that are not in the CRM list just fine, but it does not remove the records not present in my list. In other words, It's adding the new records I want but not removing the old ones. Does anyone know if there is a way
Assigning value from field A to field B
Hi, I want to setup a function to assign the value of a formula field (DateTime output) in my layout form Licence Expiry Date to a DateTime field Custom Licence Expiry (we have an integrated system that reads values from the Custom Licence Expiry field). I wrote the following deluge function but it doesn't work, can anybody please help? CustomLicenceExpiry = getFieldValue("LicenceExpiryDate"); Thanks Wing
how to create a button in View and a timer
Hi! I am new to Zoho and I need a bit of help with something. I want to add a button in a View so that users can click and go to the next Form. How can I do that? Also, is there any way of inserting or creating a timer for my application? Thank you!
Deluge function/code for converting decimal to Base36?
Hi, I'm familiar with Excel converting Numbers upto base36 with the BASE function. BASE( number, radix, [min_length] ) Can we do this in deluge in Creator? What's the workaround if not. Use Case: I have an Auto-number field, based on the auto-number field which is in decimals, I want a formula field/function to generate a BASE36 number on another field. Appreciate the help, Thank you, Jayanta
Filter by date on panel in dashboard to show calendar months
In my dashboard page, I am creating a panel showing count of selected records based on date. I want to show each calendar month of the year. i'm not sure how to do this using the date filter options. i can do for each month in 2020, using calendar options 'before' and 'after' but I want the dashboard to roll over into next year and the next etc. So essentially, I need, "if month is January, if month is February" etc. Any ideas?
Payment Cancelled - Still Creates Record
I've written an event booking part of my new system. In this they book in and pay for the competition. I just had a guy press book now, but then close the payment window as he didn't realise he didn't have his card on him. This has still created a Competition Registration record, it's just not marked as paid. This isn't the expected behaviour though. The average user would assume that this cancelled the registration process. Wondering what the best way to handle this is?
Looking for a Scripted Telesales/Telemarketing Campaign Solution
Hello, I'm looking for a way to do scripted telesales/telemarketing campaigns in Zoho Creator or Zoho CRM. I have seen solutions like GrapeCity Telesales for Salesforce and CallPro CRM and they do exactly what I want to do, but they don't do it with Zoho which is the platform I would prefer to use due to the pricing structure and the month-to-month payment model. Particularly GrapeCity; they do a great job of this, include prospect scoring and their interface is easy to use. But they are only on
Accessing code for Form
I'm having trouble finding how to view/edit the code that makes forms work. I'm trying to make a data tracking application that will be supported by database.
Coupon Generator with end of date use
Hello World, I needed a coupon generator to generate about 200 unique coupon per day for my ecommerce and couldn't find one. I never coded before the last 48h and didn't know what a variable,function or index was. I watched a video about JavaScript for Beginner and went true the Zoho Deluge website to find functions. I then created this one. It gives about one and a half billion combination per day. Should i worry about having a double coupon value happening? Is there a way of avoiding it? Should
Any way to add actions to Duplicate record function?
I have a report where I've enabled the Duplicate link, allowing the user to make a copy of the selected record. But I would like to give the user the option of altering three specific field values after the record is duplicated. What is the best way to do that?
Repeatedly Add Item from a lookup field
I want to create a form which could repeatedly add item from another form? is it possible? Currently i can use the lookup field to link item from another form, but I want to repeatedly added more items. Thanks for any input in advanced.
Deluge Records of Current Month
Hi I want to pull from the form "Job" and find the number of warranties in the given month. The underlined portion is what i need. On the job form I have a field called Date Received. I want the deluge script to count all records from the current month with the job number than contains W. I can do this via records however this script runs daily and need to do it from deluge. thanks Jobs_Day_Count = Job[Job_Status == "Approved" || Job_Status == "In Queue" || Job_Status == "In Progress" || Job_Status
Public Link Zoho Creator Basic form
Hello, I am trying to find a way to share the public link from Zoho Creator. I see that they say it's been done, but when I press on my share button, many options that appear on these solution sites don't appear to me. Is it because I have the free version? Best regards, Sabrina
Zoho Creator for Zoho One and SSO
Hi, In zoho creator for Zoho One, I can't find the "Click on the SAML option." as described in the help (cf. https://www.zoho.com/creator/newhelp/app-settings/configure-saml-authentication.html). I would like use SSO for customer portal in zoho creator. It is very important for me.Is it impossible with Zoho Creator for Zoho One ? Thanks a lot
Bootstrap
Wondering if it is possible to use Bootstrap for custom html pages.
Submenus & relations
I have a database setup like this : Warehouses > Sections > Boxes. Boxes are located inside sections and sections are divisions of warehouses. Considering that each section is linked to one warehouse only, is there a way when creating a new box and assigning it to a section to have the drop menu list only the sections of the warehouse selected for that box, like a "sections" sub-menu of the menu "warehouses" ? Secondary question : is there a way in a "warehouse" report that have Zoho Creator list
How to access individual fields of a blank sub-form in a report
Hello, I have a form which consists of a blank subform (with 5 fields). Is there any way to generate a report with these 5 fields individually? The only solution which I found for now (in a report) is in a single column to add these fields with space (or comma) as choice delimiter or by creating a link to view (and then the system shows the detailed view). But I would like to have these 5 blank subform fields as 5 columns in my report.
Updates - October, 2019
Hello App Creators, After a short wait we’re here with the first set of features mentioned in our September, 2019 announcement. The following are now available in Zoho Creator 5: Time field and 12-hour format Record comments Search element in pages New UI for the record template builder Quick references: - Release notes - Hands-on training and certification in London on November 12-13, 2019 - register here - - - - - - - - - Time field and 12-hour format Welcome to the new Time field and the 12-hour
how to enable my application through my proxy server
I have a squid proxy server on my network that is used to block access to internet, i want to allow my application through the proxy settings , what ip addresses should be allowed in the proxy server so that the browser can run my application while keeping blocked the internet access in general.
Field Focus on Mobile App
In a web browser the first field in a form has the focus and is active when the form is loaded. This is not true on the iOS or Android apps. The filed must be tapped to bring up the keyboard. Is there any way to give the field the focus and make it active automatically? My application uses a keyboard wedge barcode reader. If the field is not active, the scans are not entered. It is a common error for the user to forget to tap on the field. I'd like to avoid this by making the field activate
Next Page