How to insert multiple selected records from a report into subform of a form in zoho creator?
I am developing a simple site apkzhola inventory application in zoho creator. There are 2 forms in this case. Form A: Material request. This form has a subform with fields for product and quantity, Form B: Purchase Order. Has a subform with fields for
Masking phone number
Hi all, I'm trying to mask the first 3 digits of a phone number, like this example: Original: "912384735" Masked: "xxx384735" I've tried use the remove and replace function but with no success. Thank you for your help. Best regards, Rui
how deluge statement usage limits are count
Hi, There is a limit of 5000 statements in a script, for example when I process an on load or submit script. In an earlier forum post I found this text: But if you have a "for each" loop within your action script, the number of times the tasks are executed depends on "the number of records iterated x the number of tasks". For example, if you have 500 records to be iterated and 3 tasks, the total number of executable statements for this action is 1500. It is not the number of times they are triggered
Multi Language
Dear all, what is the best way to create a ZOHO Creator application, which is multi-language based on the Language settings of the User? Thanks, David
Import CSV and set Added Date
Hello, I was wondering if it was possible to set the Added Date when importing from a CSV/TSV. I had an "Added Date" column with a date, but it didn't get set. So I guess I have two questions: 1) Is it possible to set when importing via CSV/TSV? 2) Is it possible to set via the API? Kudos on Zoho Creator. It looks great. I'm really looking forward to subforms and future tweaks.
debug - where is "view log details"
On the page below, https://help.creator.zoho.com/Info.html it says you can debug a script by clicking "View log details", but where is this button/link?
Using URL field to create clever links to maps
First of all - thanks for a dandy little service! I'm trying to use the URL widget to dynamically look at another field (a text field called ADDRESS) upon successfully editing the record, I'd like the script to look at the address and create a properly formed URL to Google Maps. I believe I understand how to transform an address into the required strings for the URL (ie, substitute '+' for <SPACE> etc.). My problem is how to dynamically assign a URL to the URL field, and dynamically assign the address
Creator scheduled Deluge repeatedly failing - unable to replicate error manually
I have a scheduled workflow that runs every morning to bring in data from another system and check for updates. I'm seeing in the error logs that it fails : Error details: Error in executing SYSTEMNAME Update Error at line : 23, Invalid collection string
Zoho Creator Usage Details for 11 Sep 2024
Hello Support, I want to get the usage details for Zoho Creator for 11 Sep 2024.
Publishing an Application with a Student Account
Dear Zoho Creator Team, I hope this message finds you well. I would like to know if I can publish the application I built using my Zoho Creator account, which is currently a student account. If it is possible, could you please guide me on how to go about
Problem with simple IF script with a variable
Hello, I reaaly don't understand what I do wrong, and it must best super stupid... With this simple script : doublon = Test_Client.count(); if (doublon > 0 ); openUrl(www.fermerondine.com, "same window"); I always get this error for line 2 : Incomplete
Publishing an Application with a Student Account
Dear Zoho Creator Team, I hope this message finds you well. I would like to know if I can publish the application I built using my Zoho Creator account, which is currently a student account. If it is possible, could you please guide me on how to go about
Multi page form, trigger API call or function on page 2 load
I have a multi page form. On page one is basic info: Name, email, address, phone, etc. Page 2 would look like this: Checkbox - "By checking this box you agree that you may have to travel up to XX miles for your internship" Text Field, read only - XX miles
Zoho Creator - Using Connection to create an entry in another application
Hi there I want to add a record into another Creator application. Both applications fall under the same superadmin/company. Now, I have the following system-generated connection, which I have authorised. My line of code is this: record = zoho.creator.createRecord(zoho.adminuser,
Need Suggestions for how to Develop a Fitness Tracker that Tracks and Emails Progress
Alright, I just wanted to run this question by you guys because I have been trying to develop a database application for people to enter in just fitness numbers like number of pushups, height, weight, etc. They would use a person number so that the people interfacing with the database will not see the data (but that's trivial, and I can figure that out). What has been challenging is making it so that people can enter data at several times, and having the databse email them the percent change from
Please suggest a zoho creator based in Kolkata
Need a developer have a grip in Zoho Creator and is based In Kolkata and can work part or full time urgent contact
Dynamically pass multi-select values to a chart/gauge criteria; Or, get sum total of multiple counts from a for each loop
I want to use a multi-select field in a form to dynamically show results in a gauge/chart/graph. I would assume that when passing the multi-select values to the page variable, the page variable should be of type Collection..? When I try to set my gauge
Adding Record(s) in Zoho Creator using a widget written in JS, HTML and CSS.
Hello Guys, I recently shared a good documentation with real code on how to add records to reports in Zoho creator using a widget built in JS, CSS and HTML You can check up the article on this link or https://medium.com/@simelj/adding-record-s-in-zoho-creator-using-a-widget-written-in-js-html-and-css-2a45ba2a9bd9
Change Blueprint Stage in Creator via Deluge
Hi there, I currently have an ordering system created on Zoho Creator. This is for when we want to order goods from suppliers. I have created a blueprint for these orders. Simplified it comes down to something like this: - Order to be approved - To be
Assistance Needed: Adding Company Logo and Phone Number to Printed Report
Hello, I’m using Zoho Creator and need assistance in adding my company’s logo and phone number to a report I’m printing. I’ve attached an image of the report, which is primarily a row in the Report section. Could you please guide me on how to do this?
Bottom navigation bar
I'm losing money hand over fist because people think when they've reached the bottom of the first page of products that that's all I have. I tried putting instructions telling them go to back to the top and click the arrow on the navigation bar. I worked at Lotus Development (the creators of Lotus 123) for 10 years and I sent the page to my colleages from there as well as friends and relatives asking them if they thought http://GetThemToday.com/spfoods.html was usable or if people were going away
Can I clear only a section of a form?
I have a form with several sections. Many times we duplicate records and only need to clear a (section) of the form and not the entire form. I know there's a "reset" button for the entire form, but is there a way to make a button which will clear only
Remove alternative Options in Reports.
Welcome everyone, is there a way to remove the option to transform a calendar report into an kanban, list or timeline report? Especially kanban and timeline are confusing in my case. Thanks in advance! Best Regards Jan
How can I make a field visible/unvisible
Hi I plan to expand my form with more information. But before I do this I need to know if it is possible to make fields visible/unvisible depending on selected values in other fields? BR Dennis Skouboe
Sub form not updating all rows of another subform
Hello, i have a form in creator that has two subforms in it. both subforms have a dropdown that i am trying to make related. i want to get the dropdown inputs from each row of the first subform and display them as options for a dropdown in the other subform.
Subform data not fully sync to Zoho Analytics
Has anyone faced the same issue? I have a form called Production Order, with a subform called Actual Consumption. The sync status is successful. Looking at the table: Production Order_PO Actual Consumption Info I have tried using the PO number or the
Calculating Time difference between fields Question
I have two date and time files and I would like a third field to be a formula field that calculates the difference and displays it in a simple manner... Any ideas? coolass
How to edit related block tables in canvas?
i am creating a canvas that uses a related subform as a table, but the table columns are all the same width reguardless of data and it makes the table very long. is there a way to set the column widths like we can in record templates?
How can I print comments.
Hey guys, a few hours ago I started building a Student registration form, and I saw that you can print out the Report for that form, as in select a specific "Student" that was added and print as summary, however I also noticed that the comments that you can place on those students didnnt get printed, is there any way to accomplish printing a Student report with all their data alongside the comments that I have added to it?
Allow uses to clear out URL Filters
Users link into a Zoho Creator report via URLs. These URLs have filters. Something like: https://creatorapp.zoho.com/acct_owner/app_name/#Report:SomeReport?SomeField=123 This is problematic. The report (default list view) does not indicate to the user
Application is Not Showing Data Properly
Hi everyone, I will be grateful for any help I can get on this issue I have been unable to resolve. Context - This application I'm working on was built years ago by someone who has left our organisation. I do not have any coding background and experience.
New to Zoho Creator
Hi all, I'm new to low code platforms. I've written an application (a statistical model) in Javascript. I want to develop some additional components in a low code platform such as some basic screens with a user interface and a database which will store
Multi language support for Notes Fields and Published Forms
We just upgraded to take advantage of multi language / translation support, and have the following questions: 1. The "notes" field does not appear to have translation support. Is there any workaround? Our forms included instructions using "note" fields, and we want to have these instructions showing in the appropriate language. Is it possible to display/hide note fields based on the language setting? 2. On a published public form that is embedded in a webpage, is there any way to have the user select
Minutes / Hours DELAY IN ALL OUTGOING MAIL
All my outgoing mail has been lagging by minutes / hours (randomly) or sometime 12-14 hours delay. and i can receive some email as normal (receive 1-2 minute after the script sent email) It's not very certain. When will there be a problem. Some days there
Field/Column Width in Subforms
I am new to Zoho. So far I have like all, but I am having difficulty with the limitations of the sub-form paradigm. Is there a way to set the column/field widths that are displayed in a sub-form. It seems to be forcing equal field widths, and I can't find a way to change. If i set the pixel width in the originating form, but those default back to mandatory widths when displayed in the main form. Thanks in advance for any suggestions.
How to Upload Report in zoho drive from zoho creator as a pdf
Hi, I am using Zoho Creator and am sending an email to the customer with a copy of its record Now I want to upload this pdf file into Zoho WorkDrive how do I achieve this?
Cant Access Zoho Creator
Hello, I am having an issue accessing the zoho creator page from my Zoho login. I had been working on an app for well over 2 hours with no issues, then suddenly I got the attached error. My login still works for our other zoho services like zoho invoice, but no longer for zoho creator. I can log into the zoho creator mobile app, but my records are blank-only when I click edit do I see the information entered. I am the administrator on the account and no other uses have access to these apps and data.
A major warning to Zoho Creator Users about backup limitations
Hello everyone, I felt compelled to write this topic to warn fellow Zoho Creator users about what happened to my business and the potential risks to yours. A piece of rogue deluge script in our system deleted thousands of records which had multiple links
HELP! Re-Order Blocks on Report Detail View
Is there any way to simply re-arrange the order of the blocks on a record's detail view? I'm showing that you can re-arrange the FIELDS however you'd like, but the blocks can not be re-arranged. This is a VERY BIG MISSING piece. Any possible update coming on this?
Fetch Records
Hi, I'm trying to autofill a form based on another form using fetch records. When the user inputs a name, I want it to auto-fill an address. I've put this under "on user input" for the account name variable. When I use the code below, it gives no errors. However it doesn't seem to do anything. It doesn't populate the address field in the form, and does not add the data to the table on form submit. What am I doing wrong? TableLink = Account_Information_Form [ Account_Name == (input.Account_Name_from_Order).toString()];
Next Page