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
Private link with parameters
Hi, Is it possible to create a private link with parameters in it? Here is an example: http://creator.zoho.com/zchelp/employee-manager/form-perma/Employee/Employee_ID=1234 The above link will require login information, I want the same link that can be accessed without login info. Thanks! Vishal Verma
Copy or duplicate application - not working with New Application Builder
I cannot copy or duplicate an application. I have been able to do this in the past and it has been a quick an easy way to share application logic between team members. It use to work by clicking on "Copy Application" under Options menu. Has this changed ? Is it broken by the New Application Builder?
Auto Updating Sub form based on a Lookup input that is not in the sub form
Hi Guys, I need some assistance. I have two forms: 01. A purchase request form that has a subform with details of items being requested for. The form also creates a unique number for each submission (the PR_Code). 02. A Purchase Order form that has a
Need to print barcode converted from a number or text field
Is there a way to convert a number or text field in a form to a barcode at least when printing. I need to print label for items that includes a barcode for item number or lot number. This way when the entire item or a quantity of the item is used, the label barcode is scanned by a handheld scanner on the item field or item report search, item record can be opened and the used quantity is entered, instead of having to type the long item or lot number. Does anybody know how to pull a font type (Barcode
Custom Portal on external domain
Sorry for this post looked into it, but just don't seem to get it. I try to add my customer portal to an external domain. Added a CNAME record to the external domain but it just doesn't resolve. Keep trying this, waited 24 hours and such but doesn't resolve and time isn't on my side in this case. for example my domain is https://www.mydomain.com i added a CNAME record with the following example data: Name Type Record Action example.mydomain.com. CNAME creator.cs.zohohost.com Delete Now i tried
Best way to dynamically add large amounts of choices to a drop down
Hello, I've got Zoho Creator app and I have a drop down that I'd like to be able to choose from my items list in Zoho Books. The issue with this is that we have thousands of items and my current method takes too long for the data to be fetched. Here is
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
Problem in iframe movile version
Hello everyone, I have a problem, I have a development that displays correctly in the desktop version, but the native zoho mobile version shows me in a strange way, it does not respect the proportions, this is a page with three iframes inside, one of
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
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
Next Page