How to create a payment payment projection in Zoho Creator?
Hey there! I'm new to Zoho Creator. I want to create an app that lets me register loans. That way, when I enter some information like the amount loaned, interest rate and time, it will create a table containing the amount to be paid by the user, for example
zoho creator QR code not work
Hello, I follow this guidance to create 2 fields with QR code input in a form, like this it should looks like this: however, QR icons don't show and it works as a normal manual input fields, like this: Can you help investigate this? Best,
How do I get more than 200 records from CRM
I want to populate a lookup field in a Creator Form with the Account Name from the Accounts module in our CRM. I will be creating a quote in our CRM later in the process and I don't want the users to mistype the clients name and then have to have multiple
Integrating Data from Zoho Mail in Creator JS Widget
I have an HTML page in creator app that pulls emails from Zoho Mail. I'm recreating this page as a JS Widget. Is there an easy way to connect to the Zoho Mail Api to pull the same data through to the widget? Thanks
Row spacing in template report
Hi all, Where can I find the documentations to configure the spacing between line/rows in the report template? The spacing on each rows using the templates is too huge, I don't know what parameters to adjust, any pointer is highly appreciated. T
Importing data (form and subform) from external platform to ZC
Hello, Could anyone help please, how I could automate data import from excel or csv (which is more reliable) to Creator? I have a sales form with a subform of sales details ( and there is a main form behind the subform). Currently sales invoices are entered
Apply Quick View Custom Layout on Custom Filters On Mobile Apps
Hi, I've created a reports with Custom Filters, but when I switch from the main reports to the filtered reports, the custom template did not applied on the Custom Filters UI. I don't seems to find away to apply the custom template on the filtered
Login to Customer Portal collects data not used (GDPR)
I have just made the Customer Portal Public to showcase our GDPR compliance portal and noticed that it collects Name of the user wanting to register, but there is no way of grabbing this data afterwards. I am working together with a Creator Partner Developer.
How to implement the @Mention capability of Notes CRM in a Creator app?
Is there a way to implement the @Mention capability of Notes CRM in a Creator app?
How to reference a checkbox value to show/hide fields in a Form
Hi, I have been using Creator for about 6 weeks to create an urgently required system and have found it very easy to pick up and produce a usable system for my users that is meeting all our expectations. Most of the system has now gone live and our users have added over 3000 records in it in the last two weeks! However, additional functionality has been requested which I am struggling to deliver because I can't find reference material to assist me in this learning process. I have a form where
Clickable URL in Form on Apps
Hi all, I tried to build a form that can take in QR codes for the entities in my records. I can pull the information out, but I would like to create a clickable URL link so that it can be redirect to the records I link. I try to make URL link using the
Passing rich text through ZML to print using HTML code (SVG)
Hi! I'd like to pass information from a rich text field to HTML code that I have embedded into a snippet on one of my pages. I currently use a single line variable, then pass that information through a custom function that I created to wrap text (cuts
Creating a URL filter when there is a space in the criteria
I've inherited a data set where I can not change the contents. There a number of drop down values that have spaces in that I would like to use for filters in a report : https://www.WEBSITE.com/#Report:REPORT?record_owner=portal_username§ion="Buildings
Subform content in email
In Creator, I have a workflow that's set to email the form submitter with all of the data they submitted. I'm using the "Include user submitted data". However, the email they receive doesn't include subform fields. It's critical that they see that subform
Inserting Rows in subform
Hi Can anyone see what I am doing wrong in my code? This is the the part of the form where the dates are selected This is how it is converting to the subform records: There should be 3 records under each date? But instead most of them are listed under
What is the easy way when input a lookup field can popup a select form like CRM lookup field. I don't want to use widget.
What is the easy way when input a lookup field can popup a form with data view like CRM lookup field. I don't want to use widget to do that. Does anyone can give me a advice?
Public record audit/changelog
Currently only admin have access to the changelog of records and have to do so by going to the admin/setting interface. We are building a audit platform where we need to display (to all users and inside the live app) all changes relative to the records.
How to get field literal value from CRM Integration
I've got three integrations with CRM modules. In Creator, I need a formula field that concatenates actual values from CRM, not the internal unique id. Something like this: Account + " - " + Deal + " - " + Product So that the result is: Acme Account -
How does Creator handle multi-user access and other tidbits
Hello, So I am relatively new to Creator 5 but not to programming itself. But I need some clarification on a few things and couldn't find this answer anywhere in the forums. Sorry for the long post but I cannot find this info anywhere. I am heavily modifying the Help Desk app and am scripting a ton of actions. I have several clients (not part of my company) that I want to be able to use this app for their own internal use. I understand that logged in "users" will only see the records they have created
help with base64Encode
A while ago I posted an issue I was having with using Star's passPRNT software with ZOHO Creator. Star told me that I needed to convert the URL I was passing to it to base64 before sending. No problem. I changed my code to use zoho.encryption.base64Encode to encrypt the URL, then I tried to pass it (via OpenURL) to passPRNT. Unfortunately, this also did not work, but I did find one clue as to why it didn't work. After I encode it, I use OpenURL to pass the URL to passPRNT. But there's a problem:
Prediction Field Formatting
We were very excited about the prediction field. Then we implemented it. We selected fields and the like. But when it runs, it needs a certain type of formatting... Fine... BUT YOU CAN'T CONTROL THE FORMATTING! Zoho, if you are going to go through all
Changing Tab Order
Hi all, I've noticed for tabbing through items on a form that it goes from top to bottom of columns before it switches to the next row. This isn't very intuitive for users as I have organized my fields to flow from left to right. Is there a way to change the the tab order? Thanks!
database
how can we give unique id to each customer in report
Increase the report limit
Hi, I have created a record template in my creator app and also created a button which sends the reports to my workdrive folder. But as there are so many limitations in the app and one of them is I can't send the reports to my workdrive which are of more
Creator Form : Filter the list of users in a form dropdown
I have a simple form that I have added the field type "Users". This will then return a dropdown list of all of my apps users, which is great. However I'd like to filter this list to ensure only those that have specific permissions are in the dropdown.
Is it possible to get the link that the customer portal uses in deluge
As our app is going to be placed in the marketplace, we want to add a link to the customer portal to confirmation e-mails. However, I can't see anyway of accessing this in the e-mail workflow. Is it possible to get this link without hard coding it, if
Can I get page parameter in report workflow (report in page)
I opened a page by openurl and pass parameter and that page have a report . I setup a report workflow . I need get page parameter in report workflow (functions). Can creator support this way?
Localisation is extremely difficult (and frustrating) to work with
I've been working with the localisation in Zoho Creator 2-3 years now, and the thing which is really a time waster is that the labels to be translated under Localisation are not listed in any particular order (see attached graphic). A useful grouping,
Submenus Now Height-limited (Scroll)
Anyone else not a fan of the new "feature" of having the submenus max-height set at 290px? So now for longer submenus you have to scroll up and down to see all the selections. What is worse is if you scroll down and then come back to the submenu it
Link Upload Subform Record to Main Form via Deluge Scripts
Hi, I have a main form (MainFormA) that contains Sub form (SubformB) as I need a record to group the records in SubformB via MainFromA as an entry records. I created a scripts to be executed when records in SubformB are imported via on success and the
Subform- Report
I need a report with the subform data, and I can not. how do I do? can I create a report in html and using data from a subform?
JSON not well formed error
Hello. Can anyone tell me why I always get a JSON not well formed error with the following command? I can not find the error. zoho.books.createRecord("contacts", "12345", { "contact_name" : input.first_name, "company_name" : input.account_name_company, "contact_persons" : { { "salutation" : input.salutation, "first_name" : input.first_name, "last_name" : input.last_name, "email" : input.email, "phone" : input.phone, "mobile" : input.mobile, "is_primary_contact" : true } }, "billing_address" : {
How i can schedule a automated backup download process in zoho creator everyday ?
This is for some safety and internal use i need the backup everyday and downloaded to a file automatically without i am doing anything.
Remove HTML Tag from string - HTML Stripper
HI, I have a Rich Text field in a form with some content now I would like to extract the plain text from Rich text into multi line field . when I try to extract using deluge code it insert html code as well instead of plain text .. like -- input.Multi_line = var.Rich_Text; input : Rich_text = Beet.TV: Having spent more than 25 years on the sales side of the television business, Catherine Sullivan thinks AT&T’s new Xandr unit can leapfrog the industry. output : Multi_line = <font size="2"><b>Beet.TV: </b><span
Can't see the field in report after added field from configure web and fields
Hi, from configure fields and web i have added the field named as - "boxes to storage" and says saved also.. but when i see in the report and checked after refresh , then i can't see that field in that report. can see fields after the fields and before
Delete records in subform when one record is deleted in main form
Hi, I've a form (Form A) that create records in another form (Form B) when I submit the record in Form A, I've inserted the main form ID to each rows of the records I created in From B. I created a delete record workflow on Form A to delete records in
Permission related lists
Hello, We have a problem with NON Admin users permission on Creator Reports and CRM related list. We would like to have visit reports visible on CRM (in related list) to non admin users. But we want "All visit reports" to be only viewed by Admins in
How to sum of lookup figure???
Hello, I hope anyone can help me. I'm almost giving up on this issue. I build a mainframe that enables me to choose each of the detailed forms. [Mainframe] Material cost[lookup]+ Process cost[lookup]+Quality cost[lookup]=SubTotalDirectCost I used "function"
Limit editable fields?
I see that in Zoho versions in the past you could limit editing to only the visible fields in a report, but it appears this is no longer a feature. But, is it still possible? For example, I have 20 fields, but I want my field technicians to only be able
Conditional statement make checkbox yes or no, what am I doing wrong.
So I have two fields, one where you select a employee(Managing_Therapists) in a lookup field and the other if a signature field (Managing_Signature) is signed. I want to Mark a Checkbox Yes if both Conditions are met, and no if one or both fields are
Next Page