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
Permission query
we have two permission settings i.e 'user permission ' & 'portal user permission' and both have the same setting that we enable for our users, Now those who have access to user permission can see a button on the pivot table, "regenerate" but those who
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()];
Collapse/expand groups en report view
Hi! We suggest adding the indicated functionality through a report configuration option when defining grouping criteria. Thanks, Eduardo Santander
Connections in Creator
A while ago, the way connections can be created changed so that ONLY the application OWNER can create connections. It makes it really difficult as a developer, because 1. the OWNER of the application rarely knows how to create a connection. 2. It is nearly
Decimal places in Formula Fields
I want to multipy a numeric field with two decimal places (Shares) times a currency field (Per_Share) with two decimal places. The result, a formula field (Total) should be of the currency type with two decimal places. When I do this (GUI), I do not get trailing zeroes. For example, if I multiply 2 * $4.55, I get $9.1 but want to get $9.10. I tried scripting, decimalplaces = 2, but the system just ignores that. Thanks. Frank Driscoll
Resizing the last column in the report is terrible
Resizing the last column in the report is terrible. Has anyone faced this issue or am I doing wrong here? Please see the video attached.
Serious problem with backup /restore
Creator is mangling ID's for entries in applications that are restored from backup. This problem is preventing us from doing our work. Could someone get back to me on this problem? Here's what I've figured out... If you take a perfectly good Creator application you can add the "ID" field to any of its views and you will see that every entry in the table will have a unique ID field. If you backup the application then restore it and look at the ID fields in the restored application you will see that
postURL - Error due to - 'Internal Exception'
Good day, I created a function that makes a simple postURL call to our API without authentication. It works using Postman but I get Error due to - 'Internal Exception' in Zoho Here's my code : HeaderMap = Map(); HeaderMap.put("content-type","application/x-www-form-urlencoded"); param = Map(); param.put("param","test"); url = "https://zoho-teleopti.tpcc-trim.com/api/Zoho/post"; result = postUrl(url,param,HeaderMap,false); info result;
Number Plate Recognition Using ZC inbuilt OCR
Hi Guys, I want to build a system to record number plates of vehicles that enter and leave our company depot. I'm thinking of using ZC's OCR feature however I'm not sure how I can get images from a camera to my ZC app automatically. Any thoughts on the matter would be greatly appreciated! Cheers, Justin
Hide Field or Section when the form load | Zoho Creator
In Zoho Creator an I hide Fields or Section when the form load and show it if I select a option from a drop down I tried to code it with deluge but I can't make it work.
Getting error while calling API in extension widget
Hi all, We are trying to call an public API in a Zoho creator extension. I am getting as follows r Refused to connect to xhr.js:188 https://www.zohoapis.com/creator/custom/user2_demo2127/testApi?publickey=TCCn@7KEpRUAEuxDz4VMt...because it violates the
Verify User on Last Record with Current Submission
Not sure if this is possible, as I am not sure when the Added User field can be verified during submission or after. I am attempting to make sure the user who is submitting form is the same person that was on the last Record. I have it set up that fields
Restricting Fields in Bulk Edit
As simple as the title, we would like to have a feature to hide certain fields in the bulk edit.
Contains operator in Creator REST API
Hi, How can I use the "contains" CompOperator from the REST API ? If I do http://creator.zoho.com/api/csv/dvd/DVD/view/matchall/Title=Heroes/apikey=... it will work for exact matches. But how can I search for fields which contain the string I specify? Many thanks, Richard
How to use creator edit mode form in a widget
I can publish a creator form and report with embed code and use it in the widget. but I need a edit mode form embed. is there any way to get it ?
Stumped by OpenUrl when trying to open a filtered report with the click of a button.
I have two Forms, Accounts (parent) and Jobsheets (child), with their respective reports. They are related in 1:N relationship. I tried adding a button in the Accounts report, as a column labeled "View Jobsheets". The intent is for the on-click action
Spacing between fields
how do you control spaces between fields? I have a lot of fields to put on a form and want to put the fields more closely together. It seems like the spacing between the fields are automatically set and I am not sure where I can change this if possible.
Prepopulate a field name based upon a zipcode table
I have a created 2 forms, an application that people will enter their information. Once they enter the field zip code I want to pre populate a field in form 1 with the city information. Form 1 is the application Form 2 is the zipcode with city and county fields Pls help I am new with building scripts
Next Page