Parsing GS1 Barcode
Hello, I am building a simple application to capture inventory and location. The user would scan the item barcode and location barcode and would sumbit the form. I need help parsing the data. Here is a sample of an entry: 90I-3110-991010222179550 90 identifies
export report excel summary as url
Hi All can I make a openurl to download an excel summary? if not, can i have a regular list summary as pdf? or print? thanks
Creator on premise?
Hello Everyone, I could find a post of Creator on premise. It was three years ago...the reply was "coming soon"... Anyone has info on this topic, or scheduling please? Thanks George
How can we send as attachments photos of an subform upload field?
I have a subform with name Photos and a subform upload field with name Camera_Photos. I would like when someone adds photos in these subform then to send these photos as attachments in an email using the sendmail function Does anyone know how can i do
BUG: Code Editor Not Working in Chrome Browser
Just wondering if anyone else is experiencing this issue. Since earlier this week, when I click to edit a deluge script in chrome, the editor doesn't appear. Specifically, the issue is that the "wf-slider" <div> is being given a style of "display: none;"
Navigating to views of related records from within detail view.
Suppose I have forms A and B such that records of B are related to records of A via a lookup field (i.e. there is a one-to-many relation between A and B). Within the detail view of a report for A I can display the related records in form B as a related
Zoho Creator - Revamped Release Notes
Hello everyone! We're thrilled to announce the launch of our revamped Release Notes page. We'll now be saying goodbye to the current layout and introducing a fresh, updated Release Notes page in its place. A wide range of people have provided us with
Formula field and zoho.loginuserid
Hello, Can the formula field be used to display a value from another field based on the logged in user? I have multi lingual users so I'm thinking of having a single line field with the product name in Spanish and another in English, then use the formula
Problem with pass a value to a Zoho CRM Integration field
Dear All, In a form I have added a Zoho CRM Integration field ("Supplier" Name) which is connected in the Vendors Module of the CRM. I would like to create a record in Creator through Zoho CRM and this field to be filled with a specific value. I have
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
データ未提出のポータルユーザーの特定
社員全員に週に1回データを提出してもらうためのフォームを作成しています。 きちんと全員が提出したかを確認する必要があるのですが、未提出の社員がいる場合、特定することは可能ですか? 社員はポータルユーザーとして登録します。 どのような方法でもいいので、お知恵を貸していただけると幸いです。
Creator Mobile Menu: How to hide menu?
See attached images. When a customer portal user logs in they see this standard menu view, but I want them to be directed to our dashboard page shown in the second image with the blue buttons. How can I hide the mobile menu and show just my dashboard
Creator App not updating record
Hi Everyone I am a grou private practice (Therapist). So far I am loving Zoho One. Here is my issue: I created an app in Creator, for client chart. Previously, we did everything with Google Workspace and are migrating to Zoho One. Previously, the client
CRM with production data, Creator app with sandbox. How to test it?
Hello! I have a CRM project with production data in use. I have an app created in Creator. I need to make some major changes in app. So I decided to create sandbox app to make changes and test there before publish. My question is, how can I use non-prod
Display a collection of images within a page
I have an app that calls the realtor.com API. I am successfully grabbing a collection of images and uploading them via a subform of image fields. I would like to display the images from the most recent API call somewhere on a page in the app. I have made
Sub-Form Permissions
I have a Form with a Sub-Form on it. I would like users to be able to add records to this Sub-Form, but I do not want them to be able to edit or delete existing records that are in it. This is easy to do with top level Forms via user permissions, however,
Bulk edit lookup field
Im my form (MONEY) i have one old field CURRENCY (type string) with several pre-choices (usd, eur, lkr, etc). I have created new form (currencies) and report with these choices (usd, eur, lkr etc) to use it like lookup. I have there such fields as: Country, currency code. In my MONEY form i have created new lookup field NEW_CURRENCY (Bigint) witch takes data from new form (currencies) with specified criteria (country). But bulk edit do not allow me to edit this lookup field in old entries. What should
Question regarding Twilio deluge task
I am using the deluge twilio.sms.send to send SMS to clients. https://www.zoho.com/deluge/help/twilio/send-sms.html Is there any way to setup the below somehow? 1) I would like when a client receive an SMS the FROM to show a name like 'Transfer' and not
Can I get stock prices in Creator
Is there a way for me to get current stock prices, DayHigh, And DayLow into Zoho Creator the same way as in Zoho Sheet?
Changing the name of Record Template sent as attachment in SendMail
Is this doable or not yet?
Update / Refresh report automatically?
I have 2 forms: newspapers and prices. I have a report of newspapers linked to prices. If I update the price for a specific newspaper in form "prices", I would like to see the price of the existing record in my newspaper report change as well, which is currently not the case. How to automatically refresh the report? Thank you in advance
How do I make a report based on two forms?
Can I combine two Forms in the same report? For example I have a form with the average results of each student and a different form with the preferred assignatures and I would like to make a report (for example a list) combining both forms. Can I do that?
can't select "Collection of record " for multiple record
Why I can't select "Collection of record " for multiple record
Random Sort/Shuffle a List
I'm trying to figure out an efficient method to randomly shuffle a list. Basically an implementation of Fisher/Yates/Knuth algorithm. In order to do this efficiently the best way is to repeatedly swap two elements in a list (or even a map). The built in functions do not seem to allow you directly write to elements in lists. So I end up having to repeatedly create temporary lists. Which is obviously very inefficient and slow. Can anyone think of a better way to easily swap two elements within the
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?
@mention in comments no notification
Hi, hope someone can help. When we @mention someone in the comments in Zoho Creator, how is that user notifed as we don't get anything on email or in the app notifications.
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
Single User Subscription
Hi Everyone, I am working as freelancer. I am exploring ZOHO Creator. I am thinking for purchasing single user for my self for practicing. Please guide me whether I can purchase single user for ZOHO Creator.
WhatsApp and Zoho Creator Integration
#Tips of the Day ======================================================================================== How to Connect WhatsApp With Zoho Creator. -> Create an account on WATI API EndPoint https://app-server.wati.io/api/v1/sendTemplateMessages Pass
Turn Decision Box to a button
Dear all, I need your help on CSS to turn a Decision Box to a Button. I have a Decision Box like: Turn on/off to refresh the information. (on User Input, either True or False, will refresh the information) Now I want to simulate to treat it like a Refresh
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
Next Page