How to display hyperlink field value as a word/title rather than entire address in report view?
I have a hyperlink field in a form populated with: https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3. How do I display this value in my report view simply as "Audio"? https://www.media.carolinasoul.com/ebayAudio/ActiveAudio/3586755a.mp3
Add Rows to a SubForm Using Deluge
I got a form called Invoices with customer data and a subform that contains the fields: product, qty, price, subtotal. I also got a lookup field on the form used to lookup a quote number, so when I choose the quote number, the Invoice form is filled with the customer data and the subform is filled with the products data (product,qty,price,subtotal) present on that quote. I had read (post of 3 years ago here) that is not possible to fill data to a subform because only the first row is filled (in fact
Fetch, Update and Delete Subform records using criteria in Deluge
Hello Creators, While using standalone subform (not linked to other form), to find a particular record, we have to iterate through all the rows manually and this is definitely is cumbersome, instead it would be great if we can fetch, update and delete the sub form records just like form For Eg: Form_A is the main form and Subform_A is within Form A, it will be great to have a function like record = Form_A[Subform_A.ID==id]; (this should return only subform field collection not Form_A field collection)
Deactivating Enter in Creator Forms
Is it possible to deactivate the submit command when hitting the Enter key inside a Creator Field?
Is there a system variable for the base URL?
If I promote an app from development to production, the base url changes, from https://app.zohocreator.com/ to https://{org name}.zohocreator.com/. Is there a variable available that will return the base URL for the application in the environment it is
Create a ZML component/snippet that can be used on multiple pages?
According to Zoho's docs, "Snippets are stand-alone, re-usable code pieces." Is there a way to create a ZML component that can be used in multiple pages?
Zoho Creator 6 in Zoho One
Hello, Is there any ETA when Zoho One users will have Creator v6? Thanks!
Does anyone experiencing issues with downloading uploaded files?
My clients (different accounts and apps) getting this error when trying to download uploaded files.
Auto Document Number based on Dropdown Input
Hi Guys, I am a newbie and I am trying to automate document numbering based on user input from a dropdown or lookup input. For now, I used a long dropdown list and was following some youtube videos to create this code. The code seems to work, but it keeps
How to add portal user as approver?
Im struck in the process of creating a Approval Flow . I want to make portal user as approver but approval page is not showing to portal users . so, how do i add portal user as approver?
Displaying an image from a subform on a record template.
I'm trying to display images from a subform in a record template. It is working however I would like the images to shrink to fit on a the A4 page which I've set the record template to show. I'm pretty sure I need to edit the HTML on the record template
Need a solution to navigate or create dynamic links for long forms
Novice coder. I am using creator to customize an app for a particular project. The forms required are extremely long. How can I shorten the forms or make them easier to navigate?
Validate form based on subform fields not working
Can anyone tell me why this doesn't work? It runs on validate of my Projects form, which has the subform Tasks_Subform. An equivalent workflow run on validate of the Tasks form itself works perfectly, but the below code just seems to do nothing. The Projects
Pivot Charts in HTML view
Is there a way to create pivot charts through html without using javascript since zoho creator does not support javascript and I since I am also unable to use the pivot charts in the reports since the data I would like to display is inside a subform.
Export buttons to an html page
Hi All! I'm triying to add an "Export to Excel" button to my html page. anyone with a suggestion for this? I ran through the forum but did not found anything... Ravid
Explain About Parameter In Zoho Creator Custom App
Hello, Please Explain Me About Parameter. Any Custom App > Open Any Page,Form, Report or Anything. > Click On Setting > In Setting In Last Module Is Parameter. So Explain About This & Explain How To Use This. I Attach Screen Shot For Where Found Par
Does thisapp.portal.profileForUser work for demo users? i.e. in an environment
I am developing updates and have set up environments under Creator 6. I am attempting to test code that should react based on the permission set of the logged in user, however when I call thisapp.portal.profileForUser I get an empty string: userEmail
Portal User: error adding user
When I attempt to add a portal user with an email address of the form <base>+<discriminator>@<domain>, I receive a message that there was an error adding the user. If I specify an email address without the '+' character in the local part of the address,
Incorrect Documentation AGAIN
This is frustrating...Seems the documentation is wrong again here. How can I add a developer to Zoho Creator 5 application? This does NOT work: https://www.zoho.com/creator/newhelp/app-settings/add-developer.html Thanks for your help.
Inserting a watermark on an image upload field on zoho creator
Hello, how can I pass as an argument an image field upload to a java function and then insert a watermark and return the file with the watermark to a deluge script and replace the original with the watermarked image file?
Would like to create X number of records based on input
I have 2 forms, "Lots" and "Mass Create Lots". I would like to create X number of lots based on the criteria placed in the following form. This will be a useful tool to avoid the manual creation of Lots in the system. I think the best way to accomplish
Creator Dynamic Drop Down
Hi I am using creator to produce some site works on a particular project. So have two forms, one with all our sites (Form Name: Sites) that contains around 500 site details, and another to book the actual works (Form Name: Service Call). On the Service
Trying to hide fields based on dynamic dropdown entry
Somewhat new to Creator and Deluge. I have a dropdown field in a subform. It allows the user to pick a "Town". Based on that choice, I may want to hide most of the rest of the fields in the subform. If the user picks an actual town, they then go on to
Workflow functions disappearing and Form workflows turning themselves randomly between enabled and disabled
Hi, this is an issue that I have reported to you a number of times during the time I have been working with zoho and it is this. Firstly sometimes when I create deluge workflow functions. Then later in the day I need to go back to refine then. I regularly
Setting record ownership in script
I have a setup with Account and Account_Transaction. A portal user creates the Account records when they initially sign up, so the ownership of that record is correctly assigned to the portal user. Account_Transaction entries are created via a script
Creator field to update field in CRM
Hello, We are using Creator to create visit report swhen visiting Accounts. I created a field (dropdown) with Field Linke Name "Account_Status" with 3 options to choose from: - Active - Prospect - Not Active When we submit the visit report, we would like
Newbie Coder - "Error at Null" trying to save script
Hi, extremely new to coding in deluge (or coding at all). I'm working on a dependent dropdown function that takes 3 dropdowns and narrows down options based on user entry. This is what code I have, and every time I try to save it in a workflow I get "error
HTML Snippet iFrame Scroll Bars
See attached image. The image depicts a Zoho Page, with an iFrame that has a Calendar report embedded within the iFrame. The report displays three separate scroll bars - this is a bit annoying per user functionality. I've tried just about every CSS/HTML trick I know in an attempt to remove the scroll bars, however, nothing seems to work. Anyone have any suggestions, or is this just a bug/limitation?
Has Zoho Support Crumbled Again? Seems so...
Zoho support was really bad for a few years but seemed to get better until recently. I find myself waiting 5+ days for simple responses. Anyone else experiencing this?
How to upload a file from one upload field to another
Hello!!! I would like to get/download a file (of a record) from an upload field of Form A and upload it to an upload field of Form B. How can I do it with deluge?
How To I Set Autofill Field In Zoho Creator Application
I Have Created One Form Name Is New Lead. And I Created Second Form Name Is Demo. I Need, When I Select Organization Name Is Live Demo Form Then Contact No. & Email Id Field Are Autofill From New Lead record. According to the name of the organization
Submit multiple forms in a page with one click
Hi ! I'm trying to submit multiple forms within a page with just one click on submit. Is this possible ? Thank you !
Location searching - how to?
I need to allow users to search by zip code (we have many house listings with addresses), but I want to expand beyond the zip code they enter by X miles. What would be the best way to build something like that out?
Adding a Lead through Map view like Zoho CRM
How can I add a lead in Creator in Map View like Zoho CRM? I want to click on the Map and add a pin where it automatically finds location and address then can add a lead. Photo below from Zoho CRM. If it's not possible how can I add the CRM Lead Creation
Need Help understanding rebranded mobile apps
Greetings I'm going through the knowledgebase regarding the rebranded mobile apps and i need to understand the customer side app, do customers need to sign in to my portal on the creator website first and then they would be able to access my customer
Pivot chart with subform data
I need to create a chart with data from a form and a subform inside it. But when creating report, all fields but subform fields appear in the list to be used. What should I do ? Basically the subform has a list of "procedures". I need a chart where X is the "date of procedure" contained in form It should be easy, but I cannot find a solution. Thanks for any help.
How do I integrate the Zoho Creator API with a business application that is not web based?
In working through the OAuth APIs, there are only two Client types mentioned. Server based client and Self client for testing. The Server based client authentication protocol will not work as the application is not hosed on a server and will not have
Adjust width and height of report in HTML page
Hi! I'm aware I can edit the height and width by creating a widget and then refering to the report I'd like to show. But I noticed that the report loads much faster when inserting it directly with the insert form/report button in the script builder. Is there anyway I can adjust the width and height if I choose this option?
Reddit forum-like app in Creator
Has anyone ever created a Reddit forum-like app in Creator? I'm sure I could figure it out myself, but I was wondering if anyone else had done it before and had a roadmap of sorts. Thanks!
Create a Folder in Google Drive via API
Hello, I am trying to create a folder in Google Drive via API with below code: drive_map = Map(); drive_map.put("mimeType","application/vnd.google-apps.folder"); drive_map.put("name","folder name here"); response = postUrl("https://www.googleapis.com/drive/v3/files?key=API_KEY",drive_map); But I am getting this error. {"error":{"code":401,"message":"Login Required","errors":[{"reason":"required","domain":"global","locationType":"header","location":"Authorization","message":"Login Required"}]}}
Next Page