Tip 7: How to fetch data from another application?
Hi everyone, Following our Zoho Creator - Tips and Tricks series every fortnight, we are back today with a tip based on one of the most popular questions asked in our forum. This tip would help you fetch data from another application(App B) and use it
URL shortener service
Does Zoho have an API-supported URL shortener service?
Pagination help
Hello everyone. I have this code below that gets all accounts based on specific criteria. I just discovered that it's not pulling in all of the accounts due to the 200 item limit. I've been trying to follow some pagination examples but can't seem to figure
Parent Form -> Subfrom with Lookup Field - Desync on Parent Form Viewport
I have a Parent Form (Accounts) with a Sub-from (Documents). The Documents form contains a lookup field for Accounts, however when the "Related Account" Lookup Field is updated via the Documents form, the change is not reflected in the Accounts Form's
Hide/Remove Zia search bar in Mobile app
How do i hide the Zia Search button " Search across Zoho apps " in the app?
Produce application url to be common for all the Creator application Stages
I am trying to develop an application using the 3 environments steps like development, stage, production. I am trying to pass in a variable url like which redirects to a Report inside the application URL = "https://creatorapp.zoho.eu/insurancemarket/environment/development/all/#Report:Sign_Up_Form_Report"
Zoho Creator not loading
Hello. I can not access my Creator account. After I login, it wont load to my pages, Has been doing this since Friday. I have checked with my I.T dept and cant see a problem on our side. I have also tried logging in via my private laptop and PC and have
submit/upload form as csv
Hello Everyone, I've created a form in Zoho Creator to capture notes, details and images from a monthly meeting. I can't seem to figure out how to ensure the form is uploaded via CSV and into the Zoho Database. Any guidance would be GREATLY appreciated.
Display Record Image on Custom page in html widgets - Environment issue
Hi, I am trying to display an image from a record on a detailed record page. The page is created with a html widget. I noticed that the default retuned image url has to be processed. Something like : carImage.replaceAll("sharedBy","accountname").replaceAll("appLinkName","appName").replaceAll("fieldName","Fieldname").replaceAll("viewLinkName","reportname");
How to update a custom field in zoho inventory?
I have a custom field in inventory that I'm trying to update through deluge in creator but I keep getting a strange error. Here's my attempt at updating the custom field. The name of my custom field is "cf_substatus" and I noticed that it was contained
Unchecked an option in a checkbox when another option is checked
Hi, in a Creator form, I have around twenty checkbox fields, named for example "cb1", "cb2", "cb3", etc... Each of these fields have two options: Done and N/A. I would like to be able to for each field, if I check "Done", "N/A" is unchecked, and if I
How can I format numbers in an html table?
I am building an html table to display how much people have paid, but the numbers are losing their formatting: application_table = application_table + "<td style='text-align: right;'>" + payment_row.Amount_Local + "</td>"; Amount_Local is a decimal field,
Closing a Stateless Window
Hi! I have a stateless form that I'm displaying with openUrl("https://creator.zohopublic.com/company/application/form-perma/ISN_Stateless?Trade_Order_Id1=" + input.ID,"popup window","height=300, width=500"); and that works great. The form has an 'OK' and a Cancel button. At the end of either event (OK & Cancel) script I put openUrl("http://creator.zoho.com" + zoho.appuri + "#Script:script.close","same window"); but the popup window merely 'refreshes' and the window stays. A cancel will not kill
Attachment Template as PDF from Another Form Zoho Creator
Hi Everyone, have a good day. I have question, below my script for put the attachment into email. But my template PDF from another form ("Form B"). I get errror because template PDF not exist in the form "Alasan Reject". The form name for example "Form
Customer Portal Users Metrics
Hi, Is there any way to know who and when a specific customer portal user accessed? without having to use the metrics page.
How to Set filter OR, AND?
Hi, I'm struggling with a data filtering problem. In Subform I have two fields of type Lookup (multiselect). First field. Ingredient, has links to the secound filed Function. I want to set the filter to in secound field Function. ID equals input.Ingridient,
Downloading Image from Subform using Deluge (invokeUrl) - Data Mismatch / Connection Issues
Hi Zoho Community, I'm struggling to download an image from a subform in Zoho Creator using Deluge and then attach it to a Zoho CRM Deal record. I've been working on this for a while, and I'm encountering issues that I believe are related to either data
Custom Icon on zoho Creator APP
Is is possible to have a company logo as the APP image rather than the Zoho image? thank you.
Can I print a set of record templates as a single pdf?
I have a record template formatted as a gift certificate. I can email a single gift certificate to each recipient, but I also need to print the whole batch for the organiser, and they won't want 40 separate files. The layout needs to be identical, so
is it possible to adjust the date field to show Monday as a first day
Hi, Is it possible to adjust somewhere the date field, so the first day of the week is Monday (instead of Sunday)? Thank you! Ferenc
In what case it's better to use Developer Console? Only for marketplace?
As I can see from the documentation, the limitations are challenging. No Custom API No Page Variables No Custom Connections.
Creator Simplified #13: Identify the user's device type using system variable
Hey Creators, Welcome back to this week's post in the Creator Simplified series. For today's post, we will learn how to determine the user's device type using a simple system variable. Identify whether the users are accessing your application via web,
Zoho Creator to Zoho Books
Hi, I use Zoho Creator and Zoho Books. I use Creator to produce and send invoices (for specific reasons) but want to create a corresponding invoice in Books. Has anyone done this and if so, how? I have the following documentation but can't make sense
Subform Zoho Form to Creator
Hi, I would like to be able to retrieve the values of a Zoho Form subform to create an entry for each in Zoho Creator. To send from Form to Creator, I use Zoho Flow. I have a custom function, which should normally retrieve each field value then create
ZDC Hackathon 2024 Category-wise Winners – Zoho Creator
Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho Creator – Product Category award for their outstanding innovations! Team 1: Wonderboy Thandanani MthiyaneTeam
Retrieve separate records from multiselect lookup field
Hi, I know there are many post on this one, but I just don't get it. I have a multiselect look-up field named Delivery containing 3 different informations like this : Montreal - Tuesday - 3 to 4 pm I need to do an IF script based on the first item in
Deluge script that creates a popup with a dropdown list of choices
Hi, In an order form, when a portal user choose a delivery day, another field is automatically filled with a delivery location, and that field is not linked with a lookup. I have now one day of the week that has 2 delivery locations. I do not want to
Insert information on another form of a Zoho loginuser
Hello, I have 2 forms that are linked, a customer form, and then a subscription form in which there will be a subscription number that I would like to transfer back in a field of the first form called "current subscription number", How do I write the
Edit button near "x" (delete icon) for lookup fields
Hello, What do you think about possibility to edit record, selected in lookup fields by clicking "edi"t (pen icon) located near "x" icon? You can choose in which View user will edit record You can show or hide icon programmaticaly Look here: https://drive.google.com/file/d/0ByIK2qthuUqwRWktenZFQ2czT1k/edit?usp=sharing
Pivot Chart - Zoho Creator
In Zoho Creator, I want to enable an edit option within the Pivot Chart itself. Additionally, I want to avoid showing duplicated values for certain columns. For example, I’ve created a month-wise sales report for each product type. The form contains fields
Building a form with Categories and multiple sub-categories
Hello, I am completely new to Zoho and the Deluge programming language. I would like to build an easy way to lookup a set of previous orders from my order tracking sheet. What I have done so far is import my Excel order list into Zoho so it shows all
Generate a QR code from Form data
Hi everyone, Simple function from which I can't seem to find other people in the same case. I want to create a form with a few fields (client name, product name, date). Whenever the form is filed up, a QR code is automatically generated from the data filled in and available for printing. Is that not possible? Looking much forward for your help! Cheers.
Zoho Creator Get Records Integration Task
Trying to use Zoho Creator's Get Records integration task to fetch records from a specified report in Zoho Creator: https://www.zoho.com/deluge/help/creator/get-records.html However, I continue to receive a code 2894 error saying that the report is not
One editable subform entry to more than one parent record (of the same parent type)
Is it possible for two records of Form A to share a subform B record? As in the subform B record shows up and is editable in both of the Form A records and when I create a form A record I can associate it with other form A records through deluge. I'm
"sudo" for Zoho Creator
There should be a way to allow for the developer/owner account to switch user to any one. I need to be able to test the roles of all my users of my app and because logging off and back on is way too ridiculous, I've had to code in my own pseudo-sudo app. It really slows down the app. There should be a built-in way for me to just be able to assume the identity of any user at any point in time during the use of the app.
Zoho Creator User Group meetups in a city near you!
Greetings from the Zoho Creator team! We're excited to announce that we're hosting a series of Zoho Creator meetups in various cities across Australia and New Zealand. We invite you to join us for an exciting day of learning and fun. Our meetups are a
Passing Information from ZohoCRM to ZohoCreator
I've got a use case where I'm attempting to use a button within ZohoCRM to pull a list of options into buttons on creator when page is loaded. I'm pretty well versed in Deluge, but I'm having a difficult time trying to understand how to dynamically place
Problem when condition with lookup field in Zoho Creator
this is my code: if input.promotions1 != null { info input.promotions1; } And this my result: when i info input.promotion1 (which is a lookup field), it turn back nothing, so what type of this field is? normally i use the condition: if lookup_field ==
Trying to setup a record to automatically create on a weekly basis
Hello all, I need multiple records to be automatically created on a weekly basis. What I'm trying to accomplish is, I have a maintenance database where I track when I work on IT related systems. Every week on the same days I perform backups on systems
How to upload image from Creator field to CRM File Upload Field or Module Notes section
Hello, How can I upload an image from Creator Image Upload Field to CRM Module Image field (or Notes section). The file upload field type would also work. I just cannot seem to find a way to upload the images from one application to another. Case: Field record requires images as part of the report. I would like the image from the field record form in Creator to be uploaded in the CRM as well as. All of the other fields from the Creator Field Record Report work perfectly. Thank you very much for
Next Page