How to prefill data on a subform properly?
Hi everyone, I'm struggling on how to prefill the data on a subform properly. Scenario: I have 3 Forms: Shops, Clients and Needs Analysis. Shops is a subform of Clients as well as Needs Analysis. Whenever I create a new Client then I can add in the Shop
Zoho Desk and Zoho Creator Integration
Hello Everyone, I have an senario about Zoho Desk and Zoho Creator integration. I developed a app for our service team and they fill up the service form end of the service. But I want to merge ticket and service form. For example I created a ticket from
Creator information to Books custom field
Hello community, I've two surely basic questions for people with more expertise than me, but it's been two days checking forum posts to get a solution without success. Context In our business, we need to qualify/approve all our suppliers before allowing
Scanning App
Hi, I have created a scanner app for events that we host, this works fine as we have different ticket types from different vendors, however there is one ticket type that comes in that is a URL which when accessed checks the attendee in on the vendors
2 Field With same value
Dear Sir I need help with a problem I'm facing If I have 2 fields with their respective values then I have recorded them, when I enter the same data for the two files, the new record will automatically be rejected by the system or can't be save, see the
Route Draw on Google Map
Can we draw a route between the two locations using Google Map?
Zoho Recruit to Zoho Creator
I have been working on an application in Zoho Creator and created a form. But I am only stuck with this one problem. What I can't do is that I want the integration to happen this way that when the user inputs the Candidate ID which is an auto number field
Changing Developers
Hi! How hard is it for one coder in Creator to take over for another coder in Creator? We have someone who created some complex code for us and isn't finished the project. We need someone to take over the project without having to start from scratch.
Local development workflow for Zoho widgets.
I am working on a creator widget using the Zoho ZET CLI. I can import the JS SDK, and initialize it using ZOHO.CREATOR.init() However I am only able to access the SDK functions by deploying the widget. Running the development server using "zet run" shows
Stone & Pounds minus Stone & Pounds
Hello everyone, I've made a formula to calculate the difference between two decimal fields for example: 12.13 = 12 stones and 13 pounds Now I would like to calculate the difference between two stone & pounds decimal fields. The script I've written is below. The problem is 0.14 pounds is 1 stone. So in the below formula I got a problem with the following outcome: 1.15. Actually this has to be 2 stone and 0,01 pounds. How could I resolve this? //Calculatie today's weight loss in stones and lbs //Stones&LBS
zoho.ai.recognizeText(my_pdf_file) returns 2 to 4 repetitions of the text
I have tested this function to convert pdf files to text and have found that it works, but in very many cases (almost all) it returns the same text over and over again repeatedly. This of course is not the original text, but a massive rewrite that causes
How to get user zoho id
Hi, I'm trying to assign user on creator to zoho projects, I didn't found a way to get the zoho user id (not the email and username) using deluge to assign a user using the "person_responsible". Is there any way That I can get all the users ids or at
Portal Permissions not Publishing to Stage
I am having difficulty getting portal permission sets to publish to the stage environment. We've updated the portal permission sets, granting access to different reports/modules and they show up as changes when we go to publish, don't throw any errors
Google Maps and Zoho Creator Integration
Hello everyone, I would like to ask a question about Zoho Creator. I want to calculate between how many distance between two location. Is it possible to integrate Google Maps into Zoho Creator. That's way I would choose start and end location then it
getRecords - Avoid duplicates
Hello community, I'm maintaining a Vendors table in creator, fetching data from Zoho Books. The vendor table can not contain duplicates for consistency in the records of my app. That's why I've checked the "No Duplicates" option on the contact_id fetched
Automatically updating date based on field status change
I am working on some automated date stuff and having a bit of a hard time getting the script. I have a checkout form in that I would like the "Return_Date" field to be automatically updated to the current date and time when the "Status" field is updated
Auto populate fields based on user selected crm integration drop-down list
I have an app that I am trying to update customer details in a form based on an integration drop-down. I would like to select a customer in the crm integration drop-down list and then based on the selected record it updates customer values on the form;
Create a chart using data from different components
Hello, I'm using Zoho Creator to create an app which will be used track who's responsible for specific tasks in the company. I have the following components with the following fields: Component 1: tasks task name description employee in charge for the
Missing "manage" section in zoho creator app
Hello, I have been trying to assign permisions to a new hire to see a custom form made with Zoho Creator, but I do not see the manage tab of the app when accessing it: I am the administrator in Zoho CRM if this info helps. Can you please help me understand
logic based calculations
Hi can anybody help me? I need to plot of financial forecast from information in our CRM that splits a payment based on a bunch of logic statements. As an example: if supplier = A then split the payment into 10 parts, starting from three months after
How to create a URL link to include filtering on a field from an associated form
I have two forms Carbon and Emission Source. I am trying to create a filtered url hyperlink to a form called All Carbon which included a specifi field from the Emission Source form. The field in question does appear in the report to be filtered The field
Trouble fetching data from parent and child form to input into another form based on lookup field
I have similar scripts for other forms that seem to work fine. i'm not sure why this one doesn't work. All data is from one form and it's subform based on the lookup field Accession_Number. The script was working until I added the child form lines. This
Jira Integration Experience with Zoho Creator
Does anyone have experience integrating Zoho Creator to Atlassian Jira?
Zoho is not MIME-decoding filenames of attachments containing international characters
We are trying to use Zoho incoming email to form functionality and it works, but when customers attach files that contain international characters (letters with accents, etc.) then Microsoft Outlook has MIME-encoded the names of these files. Zoho totally
Creator Development: Import JSON data into a map
1. I have created a function that fetches data from Bouncie's API (3rd party GPS Tracking service) and has that data in a JSON. I need a way to import that data into a map so that the location coordinates can be used to mark multiple pins on the map dynamically.
Problem to publish approval flow in STG - Urgent
Hi, I'm having trouble testing an approval flow. Under the same conditions in the DEV environment, the flow runs correctly. However, in the STG environment the expected behavior is not generated. Publishing the changes to STG starts the process. But the
fetch record ID and generate URL
I wonder if anyone can help I've created a form that on submit sends an email to a specific user but I want the email to contain a url to record that was just created. For this to work I need to fetch the record ID and generate a url including it. Is that possible? Thanks, Paul.
Zoho Creator - [Free Webinar] Creator Tech Connect - Handling Deluge and Cloud functions in Creator - Session 2
Hello Everyone! Gear up for our next session in Creator Tech Connect Series! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into key essentials and technical nuances while
Server Down - Delay in application refresh, Creator tool issue.
Hi All, I am facing few issues while working on Creator mentioned in the title. Is it happening to anyone else? Thanks
geoapify API
I'm unsure how to do this. This url "https://api.geoapify.com/v1/boundaries/part-of?lon=-94.9368478&lat=38.7965975&apiKey=c5d7af51995f42b7b310e0554604e9dc" shows a bunch of info. I'm sorry as I'm not familiar with coding, so I apologize if I do not make
Edit Page Break in Record Template (defaults to breaking every new line in table)
Hello! I see that this question has been asked several years ago as well as recently, but did not find a satisfactory workaround, so was wondering if someone could help. In the Record Template, Zoho places the default page break at the end of one cell of the table (see pic below). Whereas it would be much more natural to let the table fill up the page, then to insert a page break so that none of the cells are cut off. Is there a workaround that anyone has found to accomplish this? Currently looking
ZOHO creatorの選択肢の集計について
ZOHOcreatorで簡易発注アプリを作成しています。 商品は1種類のみ、週間発注で1日あたり最大1つしか注文しない想定のため、数量入力ではなく曜日選択式にしたいと思っています。 例えば月曜日と水曜日に商品が必要な場合、 ・複数選択フィールドで月曜日と水曜日を選択してもらう ・ラジオボタンやチェックボックスで月～金まで用意し、必要な曜日のみ選択してもらう など、細かいUIは何でも構わないのですが、1ユーザーが週にいくつ注文したのかを集計し、数字として出力したいです。 （月曜日と水曜日が選択されたなら【2】を出力したい）
What is the erecno?
Someone knows what means erecno? This term appears in various examples of code on help center. Stela Wacunzo.
Linking drop down feild
Hello Everyone, I want to link drop down between each others. For example, I am choosing a brand the drop down field. Product drop field should show me products which belong to the brand I chose. Is it possible to do that with Zoho Creator Forms ? Thanks
Zoho Creator and Bluetooth Beacons?
Hi all, Has anyone developed anything in Zoho Creator that leverages Bluetooth? Specifically to detect bluetooth beacons (iBeacon, Eddystone, etc.)? Thank you, Josh
Zoho CRM related list - embed Zoho Creator report view as a widget instead of pre-built related list integration
Hi, In my Zoho Creator app, I have a form representing Loan applications (Deals). Another form is Documents, which is linked in a many-to-many relationship with the Deals module. There is a client portal in which the client can upload their documents. My report view has a few useful buttons for the broker who reviews the documents: - Voir documents (Preview documents) - Accept - Refuse I want the report view to appear exactly as it is in Zoho Creator, in a related list in Zoho CRM. The prebuilt Zcrm-Zcreator
Zoho Creator backup and recovery.
Hello my friends, I have created a backup file from dash board, and downloaded it to my computer, it is a "ZIP" file. Now I want to recover this file to another account, but I did not find the way. Can you please help me to finish it? Thank you!
SaaS :: Building a Recurring Revenue SaaS business with Zoho Creator...
HI folks, for the last 2 years I have been building SaaS apps for various hyper niche industries using ZC (Zoho Creator) I have developed a whole heap of short cuts and libraries for the development plus a number of marketing resources that you can use for actually selling the solution to multiple new clients... Is anyone interested in learning about how they could leverage their current ZC skills and projects and turn them into money making SaaS apps? Just message me if you know of someone that
Importing from Excel - Phone Number mapping error
I'm trying to import a phone number and keep getting the mapping error : "'Number' column is mapped to a 'Phone' field" or "'Text' column is mapped to a 'Phone' field" I have refined the phone field so that the country code will automatically pull from
""a specific field" does not exist in this form" Deluge error message
Dear all I can't see what's wrong in the line 18 of this portión of code in a "on edit/on load" form action. i would appreciate any advice 1 hide ConceptosdelDM.Documento_de_medici_n; 2 disable ConceptosdelDM.Total1; 3 disable Total_Habilitaciones; 4 disable Total_DM; 5 defaultnumber="4500056465"; 6 if(input.Orden_de_Compra == null) 7 { 8 Orden_de_Compra = Orden_de_Compra[Numero == defaultnumber].ID; 9 } 10 filas = (ConceptosOC[Orden_de_Compra == input.Orden_de_Compra].Concepto_Facturable).getall();
Next Page