Filter by user in Pivot Chart
I have a Pivot chart where the data should be filtered by user. The user enters the system and should see only the data that correspond to it. Can anyone help me?
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
Tip 3: How to dynamically filter reports using URL parameters
Hi folks, As part of Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on how to use URL parameters to filter reports. You don't always have to play with filters to drill down reports. Yes, that's right. You can pass URL parameters to set filter values and view only the required data. This technique is quite useful while linking reports in an email, a document, or when bookmarking an important report that you would like to view on a regular basis. For example,
Unselect All Options in a Single Select Radio Button field ...
Hi: Is there any way to "script a single choice Radio Button" field ... so none of the Options are selected ? You can have it so none of the Options are selected at form load time ... by setting the Intial Value property (at Edit time) to blank ... but once the user selects one of the options, I can not use any script command to reset it ... e.g. input.myRadioField = ""; ... does not do it. I can use input.myCheckBoxes.deselectall() with multiple choice (check box) fields ... but not with single
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
Send email with HTML page as PDF attachment
I am creating quotes and invoices etc. as HTML pages in PDF format with no problem. I can see that HTML pages in PDF format can be attached to email in Schedules. Has anyone created a general purpose solution to using the Schedule email facility to send emails with attachments on demand?
Color Coding
I am making an application that my company is going to use for scheduling construction jobs. We have one form that the output is placed in calender view. We would like to show each job on the calender and have it color coded occuring to the team that is working on it. Also on calender I need the entry to show on every day between my start date and end date automatically. Is it possible?
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
Set View Criteria: How can you specify "is empty"?
I have just racked my brains and plowed every resource to come up with this solution with no luck. I want to create a view with restricted criteria where a "fieldname" is empty. This helps me know which records need to be updated. Many resources point to creating a view where a fieldname is not empty, but doing the opposite has not worked. Can anybody walk me through this?
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?
Record Detail View in Page
Hello, is it possible to show an Detail View of an single Record in a Page? Simon
What's the difference between Rebranded Custom/Mobile Solution and Custom Solution?
What's the difference between the two below? I'm being told by Zoho Support staff that they're the exact same thing. I'm struggling to see the connection. These seem to be two different types of solutions... 1. https://www.zoho.com/creator/newhelp/app-settings/understand-download-mobile-app.html
Usage limit reached?? At 0?
I cannot enter any records because when I select "Submit" I get this message: "Usage limit reached. Your limit is 0. Your current count is 0. Please purchase Add ons or delete some records." I have a free account and haven't entered any of my 1000 records. Any assistance with this would be greatly appreciated... Thank you so much.
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?
Captcha verification not working
Hi, I have embedded a Zoho Creator form on my Wordpress site and the Captcha verification is not working. It refuses to accept the verification code I enter. I've tried it multiple way (caps, non-caps, Safari, Explorer) without success. I see a number of previous problems reported on this topic, but none appear to have been resolved. Thanks, Peter
Zoho Creator REACT JS widget
Good day, I have got a REACT JS widget that runs successfully in the Local Host Test Environment, but I have no idea how to pack and zip the widget in order to upload it to ZOHO. I did not use the Zet CLI to develop the Widget, seeing as I am using REACT.
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 !
Default View All <form> to show only the user's own records? Restrict fields to specific roles?
Is there a way, short of creating a custom report with specific criteria to be able to view all records that belong only to them (those that they created)? Or, more generally, be able to configure the permissions on certain forms such that it is impossible
How to Publish survey?
Hi- Im totally new with Zoho 2 days and absolutly love it. Im trying to uderstand how to publish a survey. After I create the form, I have like 100 contacts that I need to invite to complete the survey. I havent seen how to even save the form. What do I do with the form once I have selected all the fields I need? How do I save it- how do I send it to my contacts, or how do I get them to fill it in? Sorry, but I havent seen instructions on actually how to use the document once created and get it
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?
Password Field/Mask
Is there a way to create a password field or mask a field with certain characters. i.e. As I type 123456 it shows up as ****** Thanks.
Next Page