[Community Webinar] Using HTML with Deluge in Zoho Creator | April 29th, 2020
Dear developers, HTML can be an easy way to expand the capabilities of your Zoho Creator applications. From dynamic pages, record summaries & emails, to providing that extra oomph on your forms. On our previous webinars, we have received requests for
Creator : Calculate Hours/Minutes between two time fields
I have two time fields and need to know how many hours and minutes there are between them (and convert to decimal if possible). Every thing I've tried is either for datetime data types; won't let me do calculations on time fields or the function timeBetween()
On success script subform
Hello, anyone could explain me why On success script works only if I edit a form directly, but noi if I edit record in parent form that cointain subform. Thanks
information about web site www.WeAreSinging.org
Please send me information about the plan we have on our web site www.WeAreSinging.org ? How many members we can have in member portal? What are the limitation for link the member portal with the database made in creator?
Formula to calculate total number of products selected in a Lookup field
Hello there, I created a form to log all the orders received for certain products and the quantity ordered. Here's below you can see its related report: Now, I am creating another form, where I can select anyone of the items in "My Products" through a
Upgrade now to Zoho Creator 5
Hello App Creators, We've officially started the Creator 5 upgrade process and will be upgrading all Zoho accounts to Creator 5 by February 1st, 2021. For reference, please refer to our previous announcement. The upgrade wizard To reach this goal,
Dynamic subform rows combined with auto population
Hello, I'd like to create a form for registration of inventory checking. The way I'd like to do it as follows: I have form with some form fields and with a subform (subform is a blank form) If I choose the warehouse (form field) I want to check (the
Report manipulation
Hi, In creator, I would like to create a custom report by processing content of original report. For example,I want to add contents of two columns and display the sum in a third column. How can I achieve this in creator? Another case is I want to use
Zoho Creator Bug (Urgent)
When using report filter, the time filter "after" is not correct when used with "toStartOfWeek()". It actually is ">=" the date found instead of ">". Try that with "StartDate_Time after zoho.currentime.toStartOfWeek()" and it will include the Start of
More resolution for maps
I'm creating a simple application for listing properties and have noticed that the map provided for reports or location is from Open Street Maps with low resolution and many streets are not named. Is it possible to get a higher resolution map like the
Calendar Report - Weekly View - all-day
I have a feeling I know the answer to this, however, I'll give it a shot - please reference screenshot - is it possible to add a Decision box field to a calendar form that would set the event to "all-day", so the event then shows in the all-day section
Sum or Count of Related Records in CRM
Have Zoho Creator Linked with our Zoho CRM. Building an Application based around Accounts. Need to be able to pull out information on all potentials associated with the selected Account; getting a sum and count of all potentials and their values associated with that account, and setting an field in the creator application to this value. Thanks in advance.
Exporting report as file to other report
Hello Folks, I have a requirement to download report from Creator using api. But there is no api to download report. Data api have report view functionality but I can not sort data and if some one changes are order in report my functionality will fail.
Show Edit Form along with Parent form record details
Hello, I have Opportunities on which people can submit a Vote. Currently Vote is a Subform of Opportunities. I would like Users to be able to see on the same page: - the Vote edit Form - the related Opportunity record details I'm not too sure how to do
Attaching from a Creator form to the CRM
Hi all, We're looking to send our Zoho Creator Form's attachment to the CRM's record it's creating without much success. Looking at documentation, I'm doing the following: 1. Creating the "Accounts" record and getting the ID: accountID = createdAcct.get("id").toLong();
For Each Loop / Custom Iterating Variable? Is It Possible?
As a programmer, a client of mine asked for some help with their Zoho application. After jumping into Zoho for the last couple of hours - and seeing this code called Deluge, that is pretty self explanatory but frustrating. There is one thing I can not figure out thus far - how can I set a counter variable, and iterate through the fields of a form using "one" loop. Below, is an example where they have 40 part names, 160 lines of code - and the for each field in the code looks like the following for
integration
hello urgently needed Zoho developer application front is built or he can build it from scratch I want to integrate woo-commerce to a Zoho creator application (customers -orders-subscriptions-tickets) get data and add data (two ways) more information
Changing the year start and end dates by app
I have an app that contains a lot of financial information that needs to have a start date that isn't January. When I try and filter any report using the relative ThisYear or NextYear options it defaults to January - how can I change it ?
Customizing a Radio Field with CSS
Hey, I am attempting to use the CSS in the Notes Field trick to load some styles on the Load of a Creator Form. I have already got a background image and a few other things to work on Creator Pages. Is there a way to load a style for a single field and
Getting ZCRM to trigger ticket creation in ZDesk
Hi, I'm wanting to integrate our CRM and Desk so that when a Lead is converted to a won project, it automatically creates a ticket in Desk that pulls the client information from CRM to populate the ticket. I'm thinking the easiest way to do this will be to create a form in Creator that pulls the information from CRM and then uploads into Desk. Is this possible? How do I trigger this process to happen automatically upon conversion of the Lead in CRM? Does anyone have any links to example scripting
Filter report by users' department
Hey everyone, I have a question about reports. I can filter own records of a user by Added_user == zoho.loginuser criteria. On my app each user has a deparment and department have many users. So I want to filter a report by department of the logged in
Need help converting a report. Columns to rows.
I have a form that takes input from a user making a check request. They choose which line item to charge the request off to, and type the amount that should go to that budget line item. They can choose to distribute the money across up to 5 line items.
FIeld Rules not executing
I have a form with several field rules. NONE of them is executing. Sidenotes: There are no field rules of type On Create. There are no field rules of type On Edit. All "On user input" workflows are disabled. Why may this be happening?
OCR Field
i can't find ocr field in my zoho creator
Control sort order of subform
how do I control the sort of the items in a subform? for example, in the attached image, I want the dates to be chronologically accurate
Add line breaks to this formula
Hey Everyone, I'm having a hard time trying to figure out how to add line breaks to this formula. input.Notes = "Sets = " + SingleWorkout.Sets + "<br>" + "Reps = " + SingleWorkout.Reps + "<br>" + "Instructions = " + SingleWorkout.Instructions; It should look like this... Sets = XXX Reps = XXX Instructions = XXX but instead it just inputs the values as one line and the <br> as text. Any help would be great. Thanks!
Is it possible to create unique records in a form with multiple dropdown fields?
I have created a form which includes 3 dropdown fields. This form allows me to enter the selection combinations of these dropdown fields more than one time into it. I'm trying to create unique values (combinations) on this form which will then be used as a subform and each unique value (combination) will be assigned to multiple records on the main form. How can I achieve this task?
How to specify Digest Authentication in HTTP Header for POST Request?
I can't tell what the requirements are to establish Digest Authentication session with the creator Post URL function. I see a number of examples for basic, but none for digest.
Cannot capture data in form, I already fixed this.
error Error details: Error in executing On Add - On Success script Usage Limit Reached Line:(1)
Deleting all entries in other forms with references to the given form entry when deleted
Hello! I was wondering if there was a way to get a reference to the asset you are deleting in a workflow. I am currently setting up a system that has an "Asset" Form, and I want to make sure that when an asset is deleted it deletes all entries in various
Add Task if based on sub-form input
Hello, I have Brands containing a Voting sub-form. Voting contains the following fields: - User - Rating I would like to create a workflow so that whenever I add a Voting User to a Brand, it will create a task for that user if the Rating is null. I have
ZOHO CREATOR RUNS SOOO SLOWLY!
Anyone else have regular issues with this? Trying to edit records is painful and unusable sometimes
Report Columns width
Is there any way to control the width of a column in a list report? limit num of chars? Thanks
CUSTOMISE REPORTS LOOK AND FEEL
Hi, Is there a way to customize the report format in terms of giving color code to header line etc.. while exporting it or while sharing it through schedules. Thanks
Customer Portal Page Customization
About the customization of login / signup / password reset pages in Customer Portal. I am trying to reflect the clients brand, but there seems limited options. How to change the styling of the included forms. Eg default light blue colour of titles and buttons? I am confused by this post https://help.zoho.com/portal/en/community/topic/customer-portal-improvement where I see screenshot of highly customized signup page. This is my interface attached. Can I load additional CSS somewhere in the page?
How to have list of dates
I'm wondering how to have a list of dates and times, where they can be entered using calendar display functionality. The purpose is a tracking/logging app.
Populate a lookup field
I've been searching for an answer to this question. I've been able to auto-populate a field using: input.Notes = "sample text"; without any problems. But when I try and set a field that is a lookup it does nothing. For example, I have a service code field
Allow more super admins
We need the ability to add more than one super admin to a site. Currently my boss is the only that has super admin because the business is just starting out. Eventually the business will gain so much data that one person will not be able to adjust everything without large delays especially in new businesses that don't have a set model for how their website and data organization should look. With that in mind Zoho isn't that scalable in terms of website management because your limiting customization
Form does not load
If I am not logged in, the form is stuck in loading mode. I can see the form title, and a little spinning circle but the form fields do not load. This form is public. Any idea as to why this happens? How do I fix it? http://creator.zoho.com/d2x2/smyths/form/2/
Trying to create a lookup field formula for text and I only get numbers
Newbie here. I have a Project application and in it is a New Project form where there is a text field for the title of the project. I have an Assignment form that has a lookup field for the title of all existing projects. It also has a field for the person I want to assign a task to. I have a formula field that is supposed to give me the name of the project and the person assigned to it (So I can use that in a To-Do form later on). Every time I select a project in the Assignment form it returns a
Next Page