Update a lookup field in CRM from Creator using deluge
I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have
Captchas: No support for Google reCAPTCHA or similar
Hi all, The current captcha integrated into Creator is very basic, and often near-impossible to read. I'm building an app for a charity which includes a couple of public-facing forms, and this is a real issue for people with dyslexia and related conditions - it's effectively excluding them if you want any form of spam protection at all on your published forms (and that being said, the current captcha doesn't even seem very effective - bots can often read it more easily than humans). I've raised this
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
Filter embedded report
How to filter embedded report in a page, below code is not working. dateField => startDate & dateField=< endDate The report should print on page containing records from startDate to endDate. params='zc_Header=true&Service_Date__gte=<%=startDate%>&Service_Date__lte=<%=endDate%>'
Alert for Back Navigation in Zoho Creator Widgets on Mobile Apps
In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmation
How to bulk update lookup fields
"I have a primary key named Product SKU in one form called Master SKU (which contains details like price, color, size, etc.). I also have another form called FBA, which has the same primary key, Product SKU, and contains stock quantity information for
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?
Custom API - Need to create a string return value, not only MAP
@Support: When creating a Custom API it only allows a return from a function of MAP type. The service I'm using requires a string return, how can this be achieved?
Automate data upload process like reports
I'll start with the end in mind. I want to basically keep certain creator tables updated with data that are in a sql database/tables in our office (employees, active jobs, employee positions) so I can reference that data and not have to duplicate it by hand every time someone adds a new job or employee in the office desktop software. Here are some thoughts I had about how to do this, but am unsure as to whether any of them are actually possible and how to go about it from there: Is there any way
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:
Subform Data in v2 REST API
What is the mechanism for adding subform data in the Creator v2 REST APIs? There is nothing documented in the Data APIs documentation (https://www.zoho.com/creator/help/api/v2/). I was able to determine how to GET the subform data by adding it to the
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...)?
Field Type: Address, Change District/State to Dropdown with picklist??
Using the Address Field type, is there a way to make the District/State field be a dropdown with a picklist so the users can select rather than type the state name every time? I know this can be done if I use a drowdown field for the State (or entire address information), but that isn't as tidy as using the address field type. I apologize if this is a duplicate. I posted this question the other day, or so I though. Can't find that post.
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
[Free Webinar] Learning Table Series - Creator for the Finance Industry
Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various
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
Is it possible to do validation for the Actions added to Reports?
We have an all-around On Validate function that checks all the possibilities before the Created/Edited form submissions. We want to have a button in the report view, so we can change records without entering. We are able to add this button, and it does
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.
Next Page