Privacy error
Privacy error on Chrome for all embedded forms and reports, this is a huge issue: "Your connection is not private Attackers might be trying to steal your information from creator.zohopublic.com (for example, passwords, messages, or credit cards). NET::ERR_CERT_COMMON_NAME_INVALID"
Counting downloads of a file
Hello Could anyone help me, I would like to use a custom script to count how many times a file contained in a record has been downloaded. Is that something that is possible in Creator? Thanks Estelle
How can I insert and update field data of a sub-form without adding data into the main form’s mandatory fields.
1. I have a main form that contains a sub-form. I need to update the data of the sub-form from a function, but I am unable to do so. How can I achieve this in Zoho Creator? 2. How can I insert data into a sub-form without inserting data into the mandatory
Problem with multiple pages record template
Hi, I have a record template with multiple pages. When I print, it has gaps between pages. How can i fix it?
How to Display a Logo Image on a Public Form?
I would like to display a logo image in the header of a form. To achieve this, I added an Add Notes field to the form. The code below works perfectly for Zoho users accessing the form. However, when the form is made public, the image does not load properly:
How to Automate Form Creation and Workflow Setup in Zoho Creator?
Does anyone have ideas on how to create a form workflow that can perform the following functions automatically when a new submission is received for the existing form? Create a new form and report Create a new page Generate a new form workflow for the
How can i use edit url in the html snippet dynamically using parameter ? after clicked on that value
after clicked on that value .. How can i use edit url in the html snippet dynamically using parameter ? for each record their corresponding record will open.. Can we have sample url for the same ?
Updating sum of subform
I encountered another problem for updating of sum of fields in a subform. on a main form (Make_claim), I have a dynamic drop down (approved_budget_purpose) list to which filters the the items display in a subform (expense_claim_history1). In the subform,
Process FOR loop for subform items in the order of the manual sorting
Hi Guys, I have searched everywhere and tried everything, but I still not able to resolve one particular challenge. I have a subform in my Invoice with rows for each item. I made it so that we can change the order of the items manually. I need to be able
[Free Webinar] Creator Tech Connect Series - Product Release Updates in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Settings - Time Display 12-hour vs 24-hour
Hi All This is probably a question for developers as it only seems to be an issued on applications published from Developer account to client accounts. Usually a client would update how they want to view their time (12-hour vs 24-hour) in the Settings
Blueprint transition help needed
I have 5 approvers. For a stage to be passed to the next stage, I require any 3 out of these 5 approvers to make the approval. There is no particular sequence of approval, at any one time, any one can approve. As long as 3 approvers approve, the stage
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
Zoho CRM Integration Form + Custom Fields
Hi! I've created an Integration Form from Zoho CRM's Vendors Module, but I can choose a few standard fields and no custom fields I've created in Zoho CRM. There is a plan to add this feature soon? Thanks in advance.
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.
Next Page