Portal permissions
I have recently adapted the Fleet Hub Management app within Creator for our team to use. I have locked down certain parts of the app for the Admin only to have access to and have created a separate profile for drivers (Zoho One users) to use which only
Amount round off
I have a two fields : 1. Total Amout[Single Line],which will fetch from master as "INR 300" 2. Paying Amount[Decimal line],which the user will enter in form. I can validate if both the values or not same. But I can't validate the decimal amount in Total
Expected data type BIGINT found dataType STRING
I have an application where i have a drop down field where the options are numbers 1 to 5, a current date field and a return date field, what i want to do is add the number of days selected plus the current date field and set them as the return date date field. I had success using the addDay function and a static number This works: ReturnDate = input.Delivery_Date.addDay(3); input.Return_Date = ReturnDate.toDate(); However because i need to use a dynamic number based off a field what i actually
Deluge access to profile/personal information/full name
Using Deluge, how can I retrieve a user's full name from his/her profile?
Auto populate record on a sub-form
Hi Zoho Team. Requesting for your help regarding on this issue. The workflow that I've made supposedly will auto-populate record base on user-input of a field under a sub form however, it will only work on the 1st row entry but when I try to add new,
Zoho Sheet in Creator
How can display one or more of my zoho sheets as part of my zoho creator application? Thanks in advance.
Returning collection from function -- need to access field value before returning, otherwise empty?
I have a function in appA that returns a collection. In appB I am executing the function and attempting to read the values from the fields. If I simply iterate over the records and insert then into the return collection, when I try to read the field values
Nice way to persist params across page changes & note about hash URL's.
Zoho Creator uses Javascript's hashchange event, window.addEventListener("hashchange") or $(window).bind("hashchange"), to perform actions when a url's hash is updated. When a link like <a href="#View:my_view">My link</a> is clicked the window's hash is updated triggering the hashchange event. Then ZC uses AJAX to load in the html for the desired view. (Obviously not in view-perma mode). Anyways, usually you see demos of params being added to urls like so.. http://creator.zoho.com/zoho.adminuser/zoho.appname/#View:testing?param1=testing¶m2=testing
Recalculate every row in the subform
Hello, Can anyone help me with a script, please? I have an issue. Sometimes it happens, that in a multi row subform one of the rows show an incorrect row total value. Not really understand how it can happen, if I have a 20 row subform, 19 rows show correct
Reducing lag caused by workflows
Workflows have caused a considerable lag in one of my applications. I would love to hear feedback about how people are resolving such issues. The app is being used to manage security camera orders. The main form is an order form, and I have a subform
Loop through a list of fields
Hi there, I was wondering if there is a way to create a list variable of field names and then loop through them? Something like this... rstypes = typesfrm [ID == input.Bid_ID]; x=List(rstypes.supplieschk,rstypes.furniturechk,rstypes.ITchk,rstypes.staffchk); for each y in x { if(y==true) {show y;} else {hide y; y.clear();} } Regards, Will
I keep getting this Error message
Error details: Error in executing On User Input script of the field, Items. Null value occurred while performing Addition operation. Line:(18) this is my script. it will be something simple i know //Link the Item_Name field in subform to the Item_name field in Items Form; selected_item = Items[ID = row.Item_name]; //Set the quantity of the selected product to 1 by default, if no quantity is declared if(row.Quantity = null) { row.Quantity=1; } if(row.Quantity > selected_item.Quantity) { alert "Please
Footer in PDF template doesn't stay at the bottom of the page
When setting up a PDF template there is an option for a header / footer. The header stays at the top of the page however the footer does not. It appears the footer actually serves no purpose as it seems to rise up to underneath the header (see image). Is there a way to lock the footer to the bottom of the page? Otherwise what is the point of it? Image demonstrating what I mean. https://ibb.co/cJY1xZ4
Clearing Input Fields if Ticket not Found
Hi Zoho Team, Requesting again for your insights/tips for the workflow that I have made recently here's the code: I'm still new to deluge and Zoho API so I need some help here. Since our team has multiple department and what I'm trying to achieve here
Calendar view and .ics file in Email
Hello to the community, Using Zoho Creator with the Calendar Report posisibility, I'm wondering if someone can tell me how to send an Email containing an .ics file with the necessary data to integrate it in the recipient's calendar. I know how to send
Zoho creator updates field Zoho CRM
Hello In Zoho Creator we make a report and select an Account (that comes from the Zoho CRM) by a lookup field. We have a picklist field below with 3 options "Account Status" When we select an option in the "Account Status" it's important that this option
showing popup/modal on a form
Greetings i was wondering if there was a way to create a customized popup/modal and be able to show it on a form using some sort of button triggers or so. i'm having a form where i want to include explanations and instructions on how to fill it and i
Possibility of having version control for stored records
Greetings I was wondering if it was possible to have version control for records, something similar to the version control we have over deluge functions but for stored records. basically if a user edits/updates any record they would be able to view older
Search for Ticket Number then populate fields
Hi Zoho Team, I would like to verify if this code is possible or what could have gone wrong. What I'm trying to achieve here is to create a report that the user only inputs a ticket number then if record from desk was found, records will then be populated
splitting form in 2 columns makes fields and notes fields between the columns asymmetric
Greetings I'm working on a form where i need to show some explanatory text next to each form field, i did that by having a note field right next to each form field splitting the form into 2 columns which looked like what i want in the form builder (image
What is the "backend" or server side database for Zoho Creator?
Is it a common SQL database or a special home-grown one? I am wondering about the ability to take a database from another place and put it on Creator or even taking a database designed in Zoho Creator and migrating it to another DB. Brent Jones, in Oak Park, IL USA
Report summary header and footer??
Hi there! I´m building a report summary to export as PDF. I had set up the page size as A4 and enabled the header and footer. But when the pdf is exported, instead of puting the header and footer on every page, it just puts the header at the beginning of the first page and the footer at the end of the last page... How can i make them to apear as header and footer of every page??? Tanks!! =D
The new Creator 6 - How to migrate?
Greetings, I hope find all well and safe! Last days I have seen some social media posts about Creator 6, from Zoho, as an example this website link: https://www.zoho.com/creator/whatsnew/creator6.html But when I log in to my account (inside Zoho One)
[Suggestion] Visual indicator of comments in report
To enhance the usability of comments, it would be very usefull to display a message icon for each records in reports. This way, users can be sure to know that this specific records might have more relevant information in the comment section. Not urgent,
How to input all values from a Fetch Record and return to a Multi Line field
Hello Everyone, I'm having an issue I can't understand. This formula is working. The info statement shows me that all the proper records were retrieved and can be returned. for each r in Workout_Tracking[Single_Exercise_field == varSW] { input.test_report_text
Zoho Creator - [Free Webinar] Creator Tech Connect - JavaScript Widgets in Zoho Creator - An Extensive Outlook
Hello Everyone! Gear up for our next session in Creator Tech Connect Series ! About Creator Tech Connect Series In Creator, when we have to handle a complex business logic, we go for the combination of workflow and deluge scripting. To develop those business
Zoho Creator - [Free Webinar] Learning Table Series for Retail
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Zoho Commerce and Zoho creator customer portal
hi, is it possible to integrate Zoho Commerce and Zoho creator sharing the customer id? I.e. as if Zoho Commerce provides an alternative to customer portal autentication process? Or else how can I bring a customer from commerce to creator without having to authenticate twice? What would be the subscriptions required for this to be possible? thanks Luis
How do I change a Zoho Creator Form's styling with CSS?
Hi there, I have built a form with zoho creator. I'd like to change the field labels to be consistent with the website to which it will be embedded. What's the process for specifying web fonts and changing sizing, colours etc? Thanks
Are there page rules in zoho creator to hide/show elements?
Greetings i'm looking for a functionality similar to what we have in the creator forms where we show/hide certain fields based on actions/conditions. for example i have an HTML snippet in my page and button, when i click the button i want to toggle the
Print Using Record Template
Hi, I can use the record template using the Report Properties->Print & PDF options. However, I want to create a button to print my custom template on the same report. I want to maintain 2 different report format, one for the Detail View, and one custom
Fill a related field in a lookup field
Hello, I have an "order" form with a lookup field "client" that select a client in a client form. The lookup field search the client by it's name an shows the name in the lookup field. I also would like to pick the telephone and email in the "client"
List records based between 2 dates and do math
I have 3 forms, LOADS, DRIVER, CREATE SETTLEMENT. The LOADS form has following fields: Load # Driver Name (look-up from DRIVER) Driver Pay Delivery Date DRIVER has the following fields Driver Name In CREATE SETTLEMENT I want to be able to 1) select a
How to import subform data - SOLUTION
To all trying to import subform data, I might have a solution for you. First of all, for this solution to work, the subform data needs to be an independent form (not ad hoc created on the main form). Furthermore, this approach uses Excel sheets - it might not work using CSV/TSV. If this is true, then follow these steps: Import the subform records Then export these records once more including their ID Now prepare an import file for the main form that needs to contain the subform records Within this
Automating Backup
I have moved my business' blood and soul to Zoho Creator. Is there a way to automate backup so it happens every day without any action from me? Thanks much. S
Validation, Subforms and Note Fields
We are attempting to put some validation on a few Subforms on a fairly large subform as the dropdown values are conditionally populated based on other fields in the form. As a protection against any edge case or bugs we might discover after this goes
no such view exist
Hi, I am trying to attach report of a form in an email and have written concerned script for it which is as shown below. The name of the form is NMR Labour on site Today ( Daily Wage) sendmail [ from: zoho.adminuserid to: "harish@ebs.com" subject: "Daily
Subforms sorting rows
Is it possible to sort the rows in a subform? I have an application where the user uses a subform to record the steps in a process. They enter the details of Step 1 , later they add the details of Step 2 and so on for step 3, 4 & 5. When I edit the form the rows in the subform are in a random order. The best solution is for the rows to show in the order that I specify in the subform view. The second best is to use the date & time each row was entered as the default sort order. Any work arounds? Herb
Save PDF with a field as the file name.
We currently have to save and rename all the PDF's we store for sales documents. Is there a way in creator to have these default to a particular field in the form?
Uploading file to workdrive from creator
Hello I am trying to upload a file from creator into my zoho workdrive but it does not seem to be working. A file does get uploaded but there is nothing when I try to look at it and just gives an error message saying "We couldn't generate a preview due
Next Page