PWA support for Mobile and Tablet views in Creator
Hi When (if not already available but really well hidden) will the PWA display on a mobile device be able to use the view configurations set up for Mobile and Tablet in creator. Using the Zoho App on the device is not practical as it's a pain for a customer
Input a Subform field into a formula field in the parent form
Is it possible to input a field from my subform into a formula field in the parent form.
Filtering Out options from a LookUp field
Hi Everyone Trying to make a form with a lookup field that will only show things in the Lookup field that do NOT already have a tracking number associated with them in the original report //once Sample has a US tracking number //that Sample should never
Holiday Request App
Hello there Has anyone created a holiday request app in Zoho Creator, please? Thank you. Karen Rapley Copper Connexions Ltd
Does the Customer Portal in Creator work?
I'm testing it and the tester can't update the record and I can't get an answer from Creator Support. The error says "Invalid Entries Found, Recrtify and Try Again" I don't know what these invalid entries are. When i tested it with my test account, I
Adding a chart on a custom page, using checkbox as x-axis
Hi, I'm a bit confused on how to use the checkbox fiels in a chart. It seems impossible to use it. I have set a checkbox fiels with 4 entries, which are basically 4 steps for a record (they might not be dependent from each other) I'm trying to create a chart (it can be another type of widget), which displays for each checked entry in each record, how many records have this states... Apparently checkbox fields can't be used in a chart ? Am I right ? Checkbox entries as x-axis: - option 1 - option
Duplicate a Form to Another Zoho Creator Application
I've just learned from Zoho suppport that it is no longer possible to duplicate a form from one Creator application to another Creator application. I've tried to copy and paste the script from the form's original Application IDE section to an App IDE section with the same name in another application. It doesn't work. Are there any clever hacks to accomplish this? I have a really complicated form that I don't want to completely rebuild. Thanks in advance for your help.
Create N Rows in Subform Based on Number Field
I have a number field to which I need to create N number of rows in a subform. For example, input.Number_of_Payments == 8 > on user input > insert 8 rows into subform. I'm capable of doing the entirety of the code, however, I'm having trouble conceptualizing
Disable insert in report detail (related blocks)
How to disable the insertion of records in the subforms from the detail of the reports. I have several subforms and the "+" symbol appears in some and not in others, and I believe that the user has the same permissions configured for all of them.
Save our custom Forms to templates
As long as i know this feature is not exists right now and can save a lots of time. For example: on my customers projects the Customer Form looks the same the most of the times and if i could save the Form as a template for using it across my projects
If field is empty - clear another field too
How would I add to the below scrip to say: if Enrolled_Classes field is empty (ie all classes have been deselected) clear any value in Type_of_Student field? if(Enrolled_Classes.Stream == "Cheer Advanced" || Enrolled_Classes.Stream == "Cheer Elite" ||
Fetch record error
Hi, Could anyone help with what I am doing wrong here?
Translate to new language saving only the last translated section
Hi, I found a very annoying problem with language translation. When i translate my app to different language (in my case Hebrew), i have to translate a section, save it (window closed) and open again the translation menu. If i don't save after each section,
Get Date from Current Date Time
Hi, I have a {$zoho.currenttime} field, is there a way for me to get only the Date but not the time from this field? Thanks for your input.
Get date only on zoho.currenttime field
Hi All, Is it possible to get Date only from Zoho.currettime field? I added days to the zoho.currenttime, but I want the data in Date only, is it possible? Best regards. Soon Joo
Using data in Creator as a "Lookup" in CRM
I am using the UI power of Creator to enhance my user's overall experience in CRM. How can I use data in Creator as a form of "lookup" value in CRM? Looking for some general or specific ways to implement this connectivity.
Zoho Creator is too expensive!!!
Now that I have your attention... Don't get me wrong, I think ZC is a formidable tool! The more I learn how to use it and the more I am impressed by its applications. You can pretty much build any kind of business logic without too much hassle and Pages and chart allow for building relevant dashboards. That said, at its core, the software is missing a couple of features that would justify its pricing. For the same price, here are a few key features missing in ZC that are provided out of the box by
Error details: log messages Invalid client task found corresponding properties Line:(3) Mismatch of data type expression. Expected BIGINT but found STRING Line:(3) (GET RELATED RECORDS)
viewinfo = Map(); viewinfo= zoho.crm.getRelatedRecords("Contacts","Contacts",input.First_Name.toLong()); input.Full_Name = viewinfo.get("Full_Name"); input.Email = viewinfo.get("Email"); alert viewinfo; i AM GETTING ERROR IN GET RELATED RECORDS API AND i WANT TO FETCH THE INTEGRATION FIELD DATA INTO THE OTHER SINGLE FIELD INPUT (YOU CAN CHECK BELOW ATTACH FILE )
Updating a field in another form when changes occur in current form
I have two forms that are linked via a lookup field. One of the forms is called Add_a_Class and the field is called "Students". The other form is called Add_a_Student and the field is called "Enrolled_Classes" In my Add_a_Class form, I also have a field
Feature Request: Add the ability to reorder item rows in Subforms.
It is currently not possible to change the order of items in subforms within Zoho Creator. It would be ideal to be able to use drag/drop for rows in the subforms to reorder them.
How to Update multiple records from a Multi-Select lookup field
Hi Everyone, Ive got a form built to intake information on incoming samples. This goes to factories. Ive got a second form for my employee who is supposed to select a Date, a Shipping Carrier, input the Tracking Number and the multi-select all the samples
Segregate Data from subform of Form-A and fill data in another subform of Form-B.
Hi, this is my Subform "Assign Items to Existing Supplier" of Form-A Now each supplier should see their details only, so we have Supplier Form (Form-B) which has subform called Quotation-- For Supplier A subform should look like Deliverable Quantity
Can you use a CC field at the send invitation to the customer portal?
Hi, we're developing an application with customer portal and we need to send the invitations to another email in carbon copy but we can't see how to do that or even if that is possible.
openurl methond on ios/iphone
we have a portal that are planing to release as an app for android and Ios. we have some panels that use the open page or open form, also a report that use a deluge with the openurl method, on web and on the zoho customer portal for android app, everything works as intended, but on iphone the open form/ open page/ openurl , any method that workd fine in the other plataforms, try to open the url in safari instead of using the zoho customer portal app or shows the web version inside the app instead
Record Summary Has Multiple Pages
I need to export multiple records to a summary template, but when I do the export each record is on a new page. These records are just line items for a single sale. Is there some way to merge all selected line items to one page?
Select/Deselect in succession does not work!
Hey guys, I managed to find a bug. It has to be a bug. I did loads of testing and can see no other reason this does not work. With my app I am trying to select a corresponding checkbox in another field when a user chooses its equal in another field which
Simple getRecordById deluge -> {"message":"Invalid Ticket Id","code":"4834"}
Hello, i have a big problem with the deluge integrated CRM functions. Every Call like zoho.crm.getRecordById("Contacts", xxxxxxxxxxxxxxxxxxx) returns {"message":"Invalid Ticket Id","code":"4834"} This works fine on yesturday, but today all of our CRM Functions are Broken!!! The ID definitely exist!! NEED fast help, we have over 200 customers on our Portal!!
Zoho Creator and CRM integration Error
Hello, I am using Zoho Creator to create an app that integrates with Zoho CRM data. I am using the following code: leadslist = zoho.crm.getRecords("Leads",1,10); for each leadDet in leadslist { info leadDet; } And getting the following output: {"message":"Invalid Ticket Id","code":"4834"} The documentation says this error is an API authentication error, but I am writing a deluge script from within Zoho Creator Please advise. Thanks
Script Troubleshooting help
I have form called “Add a Student” with a multiselect field called “Enrolled Classes”. I have another form called “Classes” with a field called "Max number of students” and a field called "Number of Students Enrolled” which counts how many students are
URL to form redirecting to app on mobile
I have an app which has a few forms publicly accessible by guests to our organization; they are provided a link to a form-perma in their email. When most try to open the link on an iOS mobile device, the device first asks them to download the app - if they choose Continue to mobile site , it routes them to a login screen instead of the public form. Is there a way around this, or just a quirk of the iOS browsers?
Is it possible to have a confirmation message during the form submission?
Hello, We have some forms and all the fields are not mandatory. Sometimes our clients when they add something then they hit the Enter button from the keyboard by fault. Of course then the form is submitted. Is there any way to create a confirmation message
FIREFOX will not show ZOHO database but EDGE will
I've been unable to work on my several (12+) ZOHO Creator database for some time. Now when I try - FIREFOX will not open any database. So I switched to EDGE and they work perfectly. I have no idea what browser my viewers will use so need all to work
Lookup fields in subform demanding unique values?
I have a form for our program sessions that includes a subform for the purpose of listing participants. The subform is a separate form, and includes three lookup fields: Name of the participant Sponsoring organization Occupational institution For some
Search with barcode on pages
Hello, When creating a Page (not a form) is it possible to set a search field to act as a barcode scanner similar to how it is done in the form pages? In other words I want to create a page whereby when I click the search field it activates the phones
How do I see the data submitted in the Creator Customer Portal?
I feel like this is a dumb question. I added the filter: email == zoho.loginuserid So that customers can only see their data, and not the data of any other customer. Now I can't see any of the submitted data as a Zoho user. How are Creator users meant
How to use searchRecords to pull more than 200 records within Stateless form
Hi, I'm using code below to pull open cases from zohoCRM and then looping through the results to create a dynamic picklist. My problem is I've more than 200 open cases. How can I pull them all and assign to searchCase so I can loop through. I've searched and there is no while loop available in Creator Appreciate any help in advance searchCase = zoho.crm.searchRecords("Cases","(Status|<>|Closed)",rangeStart,rangeEnd);
Fill in Fields in Copies of Original Printed Applications
In the Record Template in Zoho Creator, I have put the image of the format in the background. And then I can put the info. Until then there is no problem. The problem is when the format has more than one page. In record template it is not possible to
How to Pass Form Collection to a function?
I have been trying and trying and cant figure this one out! Trying to pass the entire collection to my custom function that I have tested and works. I am trying to invoke a function I wrote that takes all the form info and send to Zoho Sign. I have it
Data from a field of the subform doesn't appear in the report
Greetings, I hope find all well and safe! I have a form (image attached) with 2 (two) fields and a subform. - First filed is a lookup from another form (Estate field from Estate form) - Second field is a simple Data field. The subform: - The first field
Feature Request: Add a method for calling cloud functions (Java, Node.js, etc) using the Creator JS API
Many times when building a Creator Widget that integrates with an external service we need to build custom server functions and call them from inside our widget. At the moment this cannot be done. It would be very helpful if we could use the Creator JS
Next Page