How do I change the color of the Help text?
I have many fields in my form that need Help text lines but all are in Tundora color, how can I change the color of the Help text to Red?
Changing hour when creating an event from calendar in mobile
Hi, When creating an event from a calendar report the date from the date-time field gets properly expressed, however when accessing the field to add an hour it changes the date of the calendar popping up to today. Which forces me to look for the date I want again. This does not happen when accessing from a pc... I've been trying different options (setting a predefined date-time, atempting to change the hour on-load,...) with no success. Does anyone have a solution? Thanks!
zoho.desk.getRecordById always null!
Hello, everytime i try to fetch a ticket out of Desk via the Creator, i get the Response "null" You can see the code and the response in the Screenshots attached. The OrgID and the TicketID are 100% correct, because in Postman i get the Ticket-Data with same OrgID and TicketID. Can you please help me with that fast, because of the Zoho Desk API Deprecation on today, i need to fix many rows of code... Kind regards Klaus Brandt
My Search Textbox is missing in Zoho Creator Report
I read the guide from Zoho's Help page: Search records But in my form, the Textbox for inputting texts to search is missing, what I need to do to make it appear? Textbox for Search is missing
Time
Is it possible to both remove the calander and ss of minutes from the date field. I would only like the user to see a time and a time only to be displayed and stored in this field. Thanks
Convert to JSON format
How can i convert following to json format using deluge, i have debugged a bit found that i need to replace ],[ with , (comma), but i have no success. [{ "name": "Ron", "email": "ron@test.com" }, { "name": "Jaby", "email": "jaby@test.com" }],[{ "name": "Karen", "email": "karen@test.com" }, { "name": "Clowy", "email": "clowy@test.com" }]
How to read xml file with zoho creator
Hi All Hope you all are doing great!!! I need help, whatever u know about this topic. Please share with me. Because am new to zoho ,if anybody help me it will appreciate. My questions are below : How can i read the xml data using deluge script using zoho creator? And how can i store the xml data to the database? Then build a report with these data in zoho creator? Note : The xml file will be upload using file upload in zoho Docs/Workdrive Hope you all are help me and share your knowledge here:-)
Add drop down answer to the On Success code
Hi there Im having trouble adding the code to send email with confirmation details with a drop down box. Here is half of my script, My drop down box called "Chain" Can any one help me with a script to add? sendmail [ from :zoho.adminuserid to :input.Email cc:"sample@gmail.com" subject :"new booking" message :input.Full_Name + ", <br />\n<br />\nIt was good to speak to you on the phone earlier. <br />\nAs discussed, please find below the details of your booking. <br />\n Please be
Name field issues with Deluge c5
Hello, I am attempted to "add record" in deluge. The problem is that the form I am trying to use has a "Name" field. When I try to use the following insert into Add_A_Contact [ Added_User = zoho.adminuser Assigned_User = EventInfo.Assigned_User Email = input.Email Contact_Name.first_name = input.First_Name Contact_Name.last_name = input.Last_Name Phone_Number = input.Phone_Number ] I get the following error: Field 'Contact Name is of type Name Object but given expression is of type STRING I have
duplicate value
in my service tickets I have a ticket number field. I am checking off "no duplicate values" but the system still allows those entries. When I go back to edit mode, I see the option is unchecked. What am I missing?
Duplicate of app or Restore of app is not working
Zoho Support, I have two apps that will not duplicate or successfully restore from backup. Other apps work but these two will not and I need to duplicate at least one of them in order to not spend hours and hours re-creating the app. Please let me know what could be causing this.
Linking a form to another application
Hi, I only have a basic understanding of the software so this may be a simple solution. I want to link a form in one app to another app. For example, I have both a HR app for the client, where they can request help etc and a work log app where employees can track their requests etc. When a client uses their application to submit a request log using the form, I want it to move to the employee work tracker application to be dealt with. Is this possible? Thanks
Change app's default language
Hello, I built my app in Spanish but as I have signed new customers from other countries I need to do English and Portuguese localizations. So I went to settings -> localization and apparently my app is configured with English as the default language (even if it's actually in spanish). I figured I would translate everything in the original app to English and then create Spanish and Portuguese localization but it seems counterintuitive. Is it possible to change the default language instead so it is
script version
can somebody please explain me how the script version works or how can it be used? see picture below. thanks.
How do I display images in my report using the inbuilt zoho creator PDF.
Hi, I have a parent form called Invoice with an Invoice Details Sub-form. In the Invoice Details Sub-form there is a Rich Text Field which correctly displays a product image both in the form and report. See the attachments. When I print the form these images print correctly in the html view. Also when I print to an external PDF creator the images also show. When I print a PDF using the Zoho creater inbuild PDF the images in the Rich Text Field are blank (see attachment). They are also blank if I
INR in Words
Hi, In Zoho creator it is possible to get Currency in Words? for e.g Total Amount is Rs 3,09,986 In Words: Three lakh nine thousand nine hundred eighty six Only
Variables - How do I print values of variables?
Hi I am new to deluge and I am using the play with deluge application to learn. I am stuck. Pls see attachment. Many thanks
Fetch Record Data in CRM and Add to Subform in Creator App
I am having trouble figuring out exactly how to complete the following; I have a form "Add Lender" that has a subform "Lender Contacts Subform" Fields in "Lender Contacts Subform" Contact - Integration/look up to CRM Contacts Role - Picklist Email - Email Phone - Phone Mobile - Phone The goal is to look up the contact in CRM and once selected, pull in applicable info already there, which would be email, phone, and mobile. What I have is: Workflow executed in form "Add
Changelog Tracking
Hi, This has a couple of steps so apologies in advance. I am rather new to Creator and I am attempting to build an Asset Register. I am hoping to be able to develop an Asset history based around field updates of a record. Let's say I have the following fields: - Manufacturer (asset_man) - Model (asset_mod) - Asset Tag (asset_tag) [unique] - Serial # (asset_ser) [unique] - Status (asset_sta) - Location (asset_loc) - Notes (asset_not) When someone makes an update to either Status or Location, I would
Adding "amount" to a multi-select lookup field
Hi, I have two forms. The second form(recipes) has a multi-select lookup field to the first (components). The problem I'm running into is that each recipe could include multiple of the same component. Is this possible and how can I accomplish this? Basically, I need to add an "amount" field to each of the chosen components in the multi-select lookup field.
Drag and drop in calendar from list
Hello all, We have a challenge since one role is separated in two roles. We work with work orders and these are planned in a calendar/agenda. Now two roles are applicable: One person creates the work order which gets in a list of open work orders Another person plans the work orders in the agenda Preferably the work order can be selected in a list view and dragged and dropped into the calendar. In this way, the gaps in the schedules can be easliy filled. Please find an example of the desired situation.
Help with auto calculating inventory
Hello, I am currently trying to create a program that will auto calculate a refill field and a threshold field and schedule it to run every night. We want to take 60 days worth of data and divide it by 2 to get an average for a month and then divide it by two again to get our threshold. I have not ran my code yet because I am nervous if it is wrong, it will change all the values to wrong. Any help/advice would be greatly appreciated. //Fetching all records from Book and Invoice Tables Books = Books[ID
Unknown form field tag when editing form
I had never seen the tag next to the field name before and can't figure out what it means, please help! None of the other field labels show the tag next to them. Thank you!
Creator and CRM Deals Integration
Hello everyone. I wolud like to create a kanban report for ZOHO CRM but when I create form integration in ZOHO Creator there is no option to add Deals from CRM. Any hint? Thanks!
[Urgent Feature Request] - Auto logout after 5 minutes
Hi, Please please can you implement an auto logout feature with Zoho Creator. We use zoho creator daily (it's brilliant) but we use it to store sensitive data. My only problem is with the way the login system works. Our staff are permanently logged in. I think it's a serious security flaw in the system if the app your creating handles personal data. Would it be possible for Zoho to implement a 5 minute inactivity logout system? Surely it wouldn't take that much development
Portal headaches - Setup, users and access... None of it works.
As much as I enjoy Zoho Creator's ease of building apps, the customer portal feature is the complete opposite. Nothing about this good or useful because apparently it doesn't even work. Boy am I glad I paid $99 a month for it. What a sweet deal. Let's start with the image I see when I click on the portal link I setup... Uhh... what exactly am I supposed to do here? By the way, it looks like this in every single major browser and on two different computers in my home. I've unpublished, republished,
Zoho Creator Sandbox Access Revoke
Hi Team, Can we able to create a sandbox for a application for different-different developer.I am unable to access my sandbox Its says "Access Denied contact zoho support".Then i Revoke the Sandbox then i am able to view the application. Question:- If somebody has created the sandbox for me and other developer has made some changes so all the changes will removed or not ?? what happend when i revoke the access of the sandbox.
IP change in Zoho's EU DC - May, 2019
Hello App Creators, There's going to be a change in Zoho's EU DC IPs. The following ranges will apply to both incoming and outgoing traffic: 31.186.226.0/24 is going to be replaced by 31.186.243.0/24 84.207.209.0/24 is going to be replaced by 89.36.170.0/24 Please ensure to update your relevant whitelisting instances accordingly. In addition to our changelog, we'll update here once these changes are live. Best, Lakshman | Zoho Creator
China block zoho creator?
my client travel to china and he complaint that the zoho creator mobile apps is not responding, web browser able to login but with extremely slow speed and that will not be able to use. Both zoho creator and zoho creator portal. anyone facing the same issue? any solution? thanks in advance.
Filtering a lookup via a multi-select field
Hi there, I have a filtered lookup called Assets which only shows assets that are added to a development. (Development A has Asset A and B, Development B has Asset A, Asset B and Asset C. When you select Development A you can only see A and B) That works great and is a multi select tool so if you select Development A, you can then select from Assets A-Z as per their record. What I would then like to do is have a subform where you select testing requirements (e.g. Asset G needs Test 1 and Test
Delete child record (from entire database) from parent form without deleting parent record
Parent Form: Incident Child Form: Task If I delete a Task from the "All Tasks" report, it is removed from the Incident Form. I used deluge scripting to delete the Task record when I delete the Incident record. If I delete a Task record from the Incident record (but I do not delete the incident itself), the Task remains in the "All Tasks" report. I need the Task to be completely deleted from the database if it is deleted from the Incident. Ideas?
zoho creator does not show stateless form when adding subforn
When modifying an existing form to show a subform, you have to add the subform into it. But when adding the subform field, the selector does not show the stateless form !! Any help would be appreciated Peter
Can Zoho Creator use API to talk to other systems like Google Places?
I don't need to know how to do this just if this is possible. With our current custom CRM, we have records called Buildings which are basically addresses, and then we list all companies at that address. We have a button that when pressed, queries Google Places via their API and in a popup shows a list of all companies at that address. The user can then select "Add" beside any of them, and it will automatically create a company record in our CRM with that company info. If that company already
[Suggestion feature] Allow for multiple emails and phone one field
Hi there, It would be nice to be able to input multiple email in one Email field. Here's a use case: an app for wedding organizers with a Contact form to store the client's information. A single contact consist of 2 people (getting married) and communication must always reach both. The normal method would be to use theses fields: Name field: Bob and Ann Phone #1: 123-456-7890 Phone #2: 123-456-7891 Email #1: bob@contact.com Email #2: ann@contact.com This requires report to always display the 4 contact
ZC to add request to ServiceDesk Plus with attachment
Hello! I have a Zoho Creator form that adds a request to ServiceDesk Plus via API. I need it to also add an attachment to the request when creating it, however I cannot get it to work. Has anyone done something similar? When using postman I can get the request with an attachment to go through (the attachment info is added to the body) but I'm unsure how to add a file to the body in the deluge scripts. Any help is greatly appreciated!
Merging creator apps
Is it possible to merge 2 existing creator apps into one? Other than manually recreating the forms, I am wondering how best to approach this. Thanks Sowmya
How to resend user invitation Zoho People
With the new interface of Zoho people, I cannot find a way to resend my invitation for a user. How do I do that exactly?
Custom app sending webhook to creator
New to this but I am not finding exactly what I am looking for. I have an application in Creator that I want my custom app to send information to. What I am looking for is the steps or an example please. Custom App in cloud sends json field information for example cust_id, firstname, lastname to any url when custom app triggers an event. I want to see an example of the Creator application that has the fields in the form to receive the information and populate the three fields. I believe my issue
Select and Deselect in a sub-form field
I have a script that will update a field in a sub-form here: Contacts_subform.Event_Role = "Venue Contact"; //(this works) However this method will remove all other options and only add this option. I want to be able to add a selection with select() and remove just one option with 'deselect()'. by using this: Contacts_subform.Event_Role.select("Venue Contact"); //(this does not work) Unfortunately I get the following error: 'Event_Role' does not exist in this form.
how do you guys create a custom calendar?
Hi, just curious how do you guys create a custom calendar? Is it possible for me to create a hotel calendar looks like the one that I attached? If it yes, what should I learn? HTML? ZML? I need a sort of table that could accommodate my user to see all the room list, status and how long the room will be occupied. I wonder this table also appear based on user record. Do you guys have any Idea or reference for me to chase my dream? I'm pretty new to coding or web programer things, but I'm eager to be
Next Page