Calculate BMI
Hello, Could you please help me with the following calculation: Height registration is in feet & inches. Weight registration is in pounds & LBS. I want to calculate the BMI for example: //Calculate pounds dec = row.Today_s_Weight_st_lbs.toDecimal() * 100; num = row.Today_s_Weight_st_lbs.toLong() * 14; pounds = (dec + num); //Calculate inches dec1 = X.Height_ft_ins.toDecimal() * 100; num1 = X.Height_ft_ins.toLong() * 12; inches = (num1 + dec1); //BMI Calculation row.BMI = (pounds * 0.45) / ((inches
QR Code generation - native
All, FYI Google have recently depreciated their QR Code API refer: https://stackoverflow.com/questions/55021765/deprecation-of-google-infographics-qr-codes Annoyingly, this has meant we needed to change our links over to another provider. Creator team:
Portal users embed access
So I have a page with a form, and two reports on either side. The reports are embedded as html snippets. So basically, it's set up that when I select a material from the form lookup field, it reloads the report embeds but filters the records with the
Creator - Programmatic Update not Triggering Flow
I have a Flow set up to be triggered by a Record Updated action in Zoho Creator. When I update the record manually via the UI, everything works as expected. However, I have a workflow that can be triggered in the UI to update a specific field in the Creator
How do I list all users and their email addresses within an application?
The application I created is a system where by users submit issues. An admin will then assign the issue to a particular user (not necessarily the one who submitted it). Obviously I need to create the users in the Setting page and allow them access to the parts of the app that are relevant to them. My question is this: Is it possible to create on a form a dropdown box that will show the available users or do I need to create the user a second time within a table (ie. Name, Email, etc...)?
No duplicates in lookup field
I have a lookup field that is based on items from a material report. The problem is, there are a lot of duplicate material names for the particular field that it's based on. Is there any way to limit it to only show one of each item?
Lookup field based on another lookup field
So I have a material entry form with a lookup field to an unrelated form in it. I have another form with a lookup field that shows records from the material entry form. The issue is, I want to set the the lookup field in the second form to be based on
Zoho Creator Embedding a Zoho Form in a Creator App
Hi I've created multiple Zoho Forms for my company for internal use by myself, I am trying to find a way I can either create an app using creator that when I open it then I'll have all my forms listed on the left hand side, so each one will have it's
Total number of External Call Statements exceeded
Hi, In a Zoho Creator application yesterday we started getting this error: Total number of External Call Statements exceeded. Line:(8) The line referenced looks like this: contact = zoho.crm.getRecordById("Contacts",contact_ID); Can anyone tell me where
How to deal with multiple people requesting to order parts, then auto send and email to the customer at the end of the week
Hi there , so I like to be able to send an e mail once a week to order parts that the guys over ordered over the week, also we need to maybe order parts from an other customer there and have an the email ready to go once its been approved. What would
How to get value from html element using deluge?
I am trying to capture the value entered in an HTML <input> tag of type "date" and store it in a variable using Deluge scripting. Here's the snippet of my code <%{ date_value = // Here I want to store the value entered in the below HTML tag %> <input
....should be an easy one
I have a form that includes a radio selection field with three options: - Board Chair - Executive Director - Other I then have an "Other" text field. I have a workflow set up so the "Other" field is hidden when the form loads. What I want to have happen
Split PDF file upload to seperate files before emailing.
Hi Support, I have recently returned from Zoholics and keen to tackle some business problems. While taking to the Zoho Team, they have mentioned that you can help with coding. So here is what i'd like help with : I have a form where a PDF file is to be
Close popup
Is there a simple deluge command to close the current active popup window? Background of my question: A form is openen as a popup window with the openurl function I added a deluge function on success > direct to a certain page (depending on who is logged in). That works, however the form in the popup stays open (but blank so maybe reloads or resets). In one case it's even worse since it starts with a stateless form, which then opens a second form, both in popups. After submit, both popups stay open
Deluge Count Function for Subform is it supported
Hi This var1 = count(SubForm_1[ID!=0 ]); Gives the error Form SubForm_1 does not exist in this application Is there a syntax mistake or is it no supported in such a manner
Application Menu
Dears, Just a little bit pushing on this :D. Really hope this is going to be released soon.
Referencing a record's parent record
I have a form Application with a subform Tools. Tools is a form in its own right, and I have a view of All Tools. However, I can't find a way to show in All Tools which Application each tools record is associated with (unless I add a lookup field for
Applying a custom filter to report on load
Hi all Is it possible to applying a pre-built custom filter to a report on load? The filter I have created within the report basically filters out all records that are superseded. I would like to apply this filter on load as default so it only shows records that are not superseded. Regards Martin
Can a new Zoho User (Zoho Account) be created via an API?
I am looking for a way to be able to create new Zoho users (Zoho account) from within my application. I.e. I have a process where candidates apply via a public zoho creator form. When I like the candidate, I just click a button "Accept" and I want zoho user account created for that user, the user emailed the account information and they start getting access to the relevant areas of the zoho application. I have come across two conflicting posts with replies from Zoho support regarding my query -
Adjusting subform layout in custom record template (PDF)
Hi there, For one of my forms, I’m working with a custom record template (PDF) that includes a subform. The subform contains two fields per row: an image field for uploading images and a single-line text field for descriptions. When I add the subform
ZOHO API / KEYYO API
Dear All I am located in France , I would like to find someone who have developed already a connecting process between ZOHO API and KEYYO PI KEYYO is a phone IP provider. I would like to get some one which have already done or which is interesting to develop all together. thank's for you news. You can exchange by mail : jleveille@msccocept.com or Phone : +33 6 78 80 90 16 best regards.
zoho creator widget not filling container
i created a zoho widget that just fills the container viewport a simple html file <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <title>Document</title> <style>
Using a Zoho Analytics table as a datasource in Zoho Creator
I'm wanting to build an interface in Zoho Creator for data in a table in Zoho Analytics. Most of the searching that I have done is about using Zoho Analytics to report on data in the Zoho Creator app or to use Creator to add or modify data in a Zoho Analytics
Regarding developer support for Creator
Hello Team, We would like to understand if there is any developer support available for building creator application directly from Zoho's team and not via partners. Please let me know. Thanks!
OAuth 2 for customer portal
In Zoho Creator, is it possible to set up an OAuth 2 connection with an external service (in this case - Zoom) for customer portal users? Specifically, I want each user to be directed to an authentication page for Zoom, and then have the connection established
Creator - Portal users management
Setting up users in Portal at the moment reqires the following steps in sequence: Invite new email/login/user configure reports visibility accept the invitation in email set password If a login or multiple logins are created to assign reports visibiliity
"Number of statement execution limit exceed" error
Hi everyone. I know that this is a already discussed topic, but I want to express my discomfort with wasting a lot of time solving this pseudo error instead solving real client problems. I hate introducing changes in the code to manage this error.
Unformatted text on dropdown menu
Has anyone encountered this problem? My dropdown fields are showing unformatted text, like what you see below This is happening to all my dropdown fields across all my apps. I tried the different language options under "localization", but that doesn't
Help with "Record Not Found"
"Record Not Found" is not necessarily an error message, but a situation I want to prevent from disabling my Deluge script, and allowing it to finish with some alternative output. In it, The code is in a CRM custom function, and I'm searching for a record in the "Products" module of the CRM. productSearchCriteria="(Product Name|=|" + ws1 + ")"; productSearchResults = zoho.crm.searchRecords("Products",productSearchCriteria); This 2 line approach is necessary because "ws1" is a variable. The problem
Error creating an XML file
I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} How
Chrome autofill breaking subform
I have a form that uses a lot of subforms. One of these subforms is setup to populate 7 rows for the public to fill out. this is an on load workflow. When using chrome's autfofill feature for a preceding address field, it breaks a multiselect field in
Edge Browser Autofill
When using the autofill feature on the Edge browser, multiple fields open up and start glitching. Please see attached
Access To One Drive (Business / Sharepoint) Inside All Zoho Products
A vast number of businesses are switching to Office 365 with Sharepoint and Onedrive included. At the moment getting documents in and out of Zoho requires us to upload download via the local PC. At the moment you do have One Drive within Zoho Desk, but not Creator and it is only a personal one drive account, a business One Drive will not work. If it did, then I could access Sharepoint files without having to go back to Synced files on my PC. The only reason we have synced files is due to programs
Hiding the default navigation bar
I would like to hide the default navigation bars on my html page views and replace them with my own custom navigation on the html page itself. Is this possible? I have tried hiding all sections in Application Settings --> Sections but the bars are still there. Thanks.
Apostrophes stop Analytics dashboard rendering when embedded in Creator
I have an Analytics dashboard which I am embedding into a Creator page, prefiltered to the organisations that the user belongs to. This works beautifully, except when an organisation name includes an apostrophe, at which point the Creator page thinks
LIMIT OF CREDITS
Hello there, I've just purchased the PLUS account on the OpenAI website and the Standard package on the Zoho website. Nevertheless, I still cannot use ZIA to generate the app I wanted. The following message shows up: "you exceeded your current quota,
invokeurl function in Flow to add record in Creator returning response EXTRA_KEY_FOUND_IN_JSON
I'm attempting to create a function in Zoho Flow to add a new record to our Zoho Creator app, but keep getting this response: {
code : 2945,
description : "EXTRA_KEY_FOUND_IN_JSON"
} Here is my function: string createOWSinstallOrders(int customerZohoID,
Maximum number of entries
Please help me with solutions on this error message "You have reached the maximum number of entries allowed" Thanks.
Announcing Zoho Creator's 2024 Release Projection 2
Hello Creators! Greetings from all of us here at Zoho! We hope you’ve been having an incredible journey with this low-code platform we all love. And here’s a gentle reminder that it’s that time of the year again—where we open up and give you a sneak peek
Referencing a record's parent record
Hi I have a form Application with a subform Tools. Tools is a form in its own right, and I have a view of All Tools. However, I can't find a way to show in All Tools which Application each tools record is associated with (unless I add a lookup field for
Next Page