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
Update a Multiselect List with .add?
bool helpers.testing(Events event) { info event.Event_Specifics_List; event.Event_Specifics_List.add(3206171000012706003); info event.Event_Specifics_List; return false; } Hey folks, inside the form Events I've got a Multiselect Lookup setup. I need
How to force text to wrap on mobile versions of reports
I am developing an app for use on both web and phone. I have constructed a nice Quick View layout for the phone version of a report with a photo on the left and several fields of text on the right. But when a field contains more text than can be displayed
Scroll to record that was just edited
Scenario: When viewing a report with a long list of records, you are scrolling down and reviewing all the data. Then you see a record that needs to be edited. You edit the record and save, but when you are returned to the previous report you are viewing
Set Default Entries for Subform in Script
How can i set the default number of rows in a subform in the script so that it can change dynamically. Thanks!
Triggering a CRM function from Updating a CRM Contact through a workflow
Hi, I am trying to call a CRM function when a tickbox is selected on the form for a CRM Contact. I have this working when you manually tick the checkbox, however i am wanting to do this through a button on a Zoho creator page. On the Creator page when
Count Subform Rows in Current Record
Is it possible to count the total subform rows as each is being added in the record that is being edited? So in the below example, the "Number of Children booked in" field would be 2. If I added another row it would update to 3, etc. It needs to NOT count
Fill in Fields in Copies of Original Printed Applications
Does anyone know how to do this? I would appreciate your help in advance. I would appreciate your help in advance. From an original printed application for a security guard, I want to make a digital copy, upload it to zoho creator and automatically fill
Behavior of roles
Hello, I have two questions concerning the behavior of roles. Unfortunately I can't test this myself right now. 1. What happens if an employee who belongs to Role1 switches to Role2. Can his former peers in Role1 still see the Data he entered while belonging
ZOHO CREATOR RECORD Template
how do you view a record template with custom function. I have a services report and add a button to view i used openUrl but dosen't seems to work.
Lookup field filter
Does anyone have any advice on what I am doing wrong here. When testing separately, the first part of the filter (Head Coach) is working, but the second part (Day/s) is not.
Filters on Sidebar that apply to all records
Before I deep dive too much into building this app I'm trying to determine if filtering on a sidebar that applies to all record views is possible. After entering projects, I'd like to be able to select a checkbox for 1 or multiple projects essentially
Next Page