Delug Script doesn´t run on bulk edit
Hi, I have developed a script to run after update a specific field, nevertheless, when I update the field in a bulk edit, the script doesn´t run. I am going to disable the bulk edit option, but I was expecting that the script run also in bulk edit. Kind regards, Mari.
Is there a problem right not with CRM Update Record API from Creator?
Is there a problem right not with CRM API from Creator? This morning all of a sudden we cannot execute zoho.crm.updateRecord function. We are getting the following error: Error in executing Set Variable task. Unable to update template variable crm_quote_url. Error evaluating MAP expression We are getting this in our form Email_Quote. Please let me know if something has stopped working on zoho end or if our application just magically broke on its own. Thanks, Matt
Customer Portal Login
Hi, Is there a way to log in to the customer portal with cosign? I've read through https://www.zoho.com/creator/help/application/customer-portal.html and https://www.zoho.com/support/help/customer-portal.html and it doesn't mention anything about cosign. Is it at all possible to log in with cosign? Thanks!
Creating an approval based application, stuck
I want to create a simple application, which'll do following-: 1. Users will submit their expenses for reimbursement. 2. Manager will approve or reject or request more information 3. If expenses are rejected OR manager needs more information, then comments should be added 4. Submitter will be notified of each status update -- I created a user hidden dropdown field called status which has values of Pending (default), approved and reject. -- I created a comment box field and made it hidden in form
Printing Certification Cards
I need to print onto pre-made CPR and First Aid cards. I have developed a roster using Creator, but I cannot figure out how to print only the needed information onto the cards and adjust it so that the Name, Dates and Instructor prints at the proper location. As it shows in the attachment, it will be a sheet of 5 individual cards. Can anyone help? Thanks.
Cant fetch record from lookup field
Hi, Followed the tutorial for fetching a record. https://www.zoho.com/creator/help/script/fetch-records.html Went with option 3 as this is exactly what I am trying to do. I have 2 forms Form 1 is called "Anst_llda" Form 2 is called "Uppdrag" I have a lookup at Form 2 pointing to Form 1. This lookup is called "Anst_lld" I want the Email field from Form 1 to be copied to a field in Form 2 called "UserID" Here is the code that I added on the lookup field. Even tried adding it to "On Edit" and "On Success"
UTF-8 support when sending mail to Zoho creator?
Hi, When sending Germanic characters (such as Ä and Ö) the emails bounce back as it cant recognise those characters... Doesnt Zoho support UTF8? I get an email back with the following. The Following error has occured while adding this record: Failure, Invalid column value "G�teborg" specified TicketNR : 234234234234 Uppdragsstatus : Company : 234234234 Avdelning : G�teborg
How can i give permission to edit and delete to that user of customer portal
In zoho customer portal ,why user of that portal is not able to edit and delete anything ? I have customer portal and in that customer portal i have created users.and i am giving permissions to that user.I am giving permission of edit and delete to that user but still that user is not able to edit and delete anything in application. How can i give permission to edit and delete to that user?
How many columns i can add in database view ?
In zoho how many columns i can add in database view? I have 60 to 100 columns so is that possible to add this much columns in only one database view?
Converting Text to Number in Report?
In my form I'm creating a dropdown (single-select) field to enter a student's race/ethnicity (API, AAB, etc.). However, when I try to generate a pivot chart from the data, it shows the race/ethnicity field as being a number field, with data points ranging from 1000 to 1400. I have no idea where these numbers are coming from and how they are coming from the text choice options in the field settings. I've tried recreating the same field many times, but it always only shows the field as a number
Dashboard Sum Value too many decimals
Hi When displaying a total sum value in the dashboard (Zoho Creator) taken from a project value box in my form it is showing the total with 5-7 decimals, however it should just display 2 decimals. I have selected max decimal 2 in the form set up. Could you advise on how to rectify this issue? Thanks
Add event to Outlook calendar
I have a Vacation Request form. Once the vacation request is is approved, is there any way to add a link in the email notification so that the person emailed can add the event to their Outlook calendar? Thanks in advance for your help! Joy
custom function against selected records
Does anyone have a code snipet I can use to run a custom function against a selected record/s in a report? I want to be able to open a report with multiple records. select one or more of those records with the check box, and then run a custom function against just those.
Xpath predicates don't work
I've reached a show stopper as my application requires access to external data to function, using JSON to XML and/or XML direct input into the ExecuteXpath function. I have been doing some testing with multiple XML files, including using the example XML in the users guide (see below). The problem is when trying to filter using predicates, ExecuteXpath does not work at all. Using the example XML (very simple), I set up the xpath within XPath Builder as: /bookstore/book/year/text()[1] Which should
Home Page Loading Problem
When I start my app, the home page appears to try to load many many times before finally settling down. In my office I am running IE8 on Windows 7. On my laptop with Windows XP and IE7 this does not occur.
How can I configure this Embed Report, in order to show only the records that match with an certain criteria.?
I have created a PAGE with a Embed Report in this html page. How can I configure this Embed Report, in order to show only the records that match with an certain criteria.? I already tried with "Search String", but it doesnt work. ie. Search String: email_id=<%=current_Email%> thanks in advance
Zoho Creator - onEdit previous values
Hello, can I somehow access previous values of fields in form in action "On Edit" - in "Validate" and "On Success"? The form creates record that can be moved in Calendar View - "On Load" is not invoked when moving block in Calendar. It's only invoked when I explicitly click paticular record and choose "Edit".
Why approvals are difficult in zoho creator?
Approvals and rejections are very prominent part of business processes, i have been using kissflow to map them easily, but want to switch to creator as it enhances possibilities such as integration with zoho crm which i use. But its strange to see i have to script (which i don't know btw) for these common approval/rejections stuff, i know you might say your dedulge scripting is easy, but to have it at all for these common actions, why don't introduce something like kissflow and help people like me
Subform: if - then
Hey guys, I hope the following topic hasn't been covered elsewhere... I looked for a while without success. I have a quick question concerning increasing the efficiency of the use of subforms within one of my apps in a management capacity. As an example, I have a form with a subform that tracks work order issues. Each row added represents a work order issue that must be accompanied with corrective action to demonstrate that the problem has been resolved. The overall status of the work order is governed
Cant duplicate my application?
When i want to duplicate my application, it says Duplicate for 2-3 minutes and then nothing happends. Whats the problem?
Show/Hide Fields Based on Checkbox Selection
So I've created a form with a Checkbox containing 3 options. I would like different fields to be hidden/shown based on what selection the user made. Thus, I created a deluge script similar to the one described here: https://help.zoho.com/portal/en/community/topic/hide-or-show-multiple-fields. While this method has worked in many ways, I've encountered some problems. First, when a user tries to select more than one option from the checkbox, none of the hidden fields that should be revealed are shown.
zoho view starting from first page when clicking back button
Hi, I have a published view containing products. Every record contains a link to a detailed summary view of the product. My problem is that if one clicks on the link to open the detail of the product and then clicks on the back button of the browser the listing of products allways go back to the first page, which is annoying if one is already several pages ahead. is there a way to go back to the page number one was before clicking on the detailed view? here a link to see what I mean. thanks for
Duplicate Shared App
Is there a way to duplicate and app that another user is sharing with you into your own account? Thanks!
Database relationships
Is there a way to show the database relationships as they exsist within a zoho creator set of applications, from lookups?
Restrict editing capability on one column only
Is there a way to have one column visible but have it restricted from editing while leaving the rest editable?
Customer Portal: How to Hide the Navigational Menu
How can I hide the menu (on the left with sections etc.) for the customer portal? I have html pages that are being shown to the customer, that's it. I dont want them to see the actual page names listed to the left. Can I hide this? Thanks!
Dynamic Picklist: Add to picklist dynamically not working
I have a form where I am trying to add to a picklist dynamically. Form: Terminal Field: Terminal Name Company (Bi-directional relationship) (longlist) Form: Company Field: Name Terminal (Bi-directional relationship) (longlist) When I use the code on another form called Order_Form: VDFCompany = Company [ID!=0 ]; FilteredTerminals = Terminals [Company in VDFCompany.Company_Terminals]; Terminals:ui.add(FilteredTerminals); It works for other fields, but for one of my specific fields it does not work.
How to add a table in a FORM?
Is there a way I can add a table in the ZOHO form? I cant find it in the list of controls on the left side. Please see the attached image.
Zoho Creator: How to export roles, profiles and field permissions configuration?
Hello, I have developed an application using my Deleveloper Edition account. After that I exported the application and import it from the customer account (Enterprise version). However all configuration of roles, profiles and field permission are missing. What can I do in order to avoid reconfigure? Its a lot of work. Is it possible to export and import the permissions configuration? Thanks, Rodrigo Garcia G.
Invalid Email
I keep getting the following error when attempting to send an email via function. It seems to only occur when a certain email address is used in the from fields (rec.Return_Email and rec.CC_Email) however it is definitively a valid email address so I'm not sure why this happening. Error details: Error in executing sendemail2 workflow. Error. Error in executing Send Mail task. InValid email Address Found. Here is the function: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\"
How can I know the users logging my applications now
Hi, How can I know the users logging my applications now? Omar
Application that filters from other application to give results immediately in new window
I'm really new to Zoho creator. I've made some pretty basic applications, but what I am trying to do is pretty complex for me. I'll explain what I do and what I would like for Zoho to do for me. I have a tenant placement company with over 100 properties. I would like for when a person calls and specify what they are looking for, ie. I need a 3 bedroom with 2 bathrooms, on the east side in the price range of less than $1,200, I want to be able to choose from a drop list their specified requirements,
Push information to form
Is there a way to push information to another users form? A user might open a form or a report and stay on that screen for a while. If other information has changed can I show a message on the users screen. For example if the user is looking at a report and another user adds records to the report how do I tell the first user to refresh the report to see the new information? Or if the first user is on a form and another user changes something critical to that form is there a way to display a message
Shorten string
Is there a way to shorten a string to a maximum number of characters. I have an html page where I don't want to show an entire text field, just the first 50 characters of each post, as some of the descriptions are very long. I would have though trim(50) would do this, but instead it just trims any spaces out, rather then actually "trimming" a string.
Inserting image into HTML
I have an HTML view that gathers "blog posts" and displays them. I have an image upload in the form, and I want to display the image, but only if one has been uploaded. At the moment I can't get the image to load. I also can't seem to insert an IF statement after the for statement below. Any help greatly appreciated. htmlpage Blog_View11() displayname = "Photo and Video HTML Blog View" content <%{ for each post in Blog [(Department.contains("Photo and Video") && Expiry_Date > zoho.currentdate)]
postUrl broken since last hour
Hi There, All of my functions that use the postUrl function are returning errors at the moment. This has been happening for the last hour. Regards, Ben
How to display a jpeg image stored in a file upload field in record summary print template
I am trying to customize a record summary template for printing a database record. One of the fields is a file upload field that always contains a jpeg image. I am using the file upload field because it can handle images greater than 5MB. I need a way to display the contents of the file upload field on my printed report, but have been unable to figure out how. I have been trying to use HTML in conjunction with deluge scripting, but have been unsuccessful.
Importing from Excel - field matching
Hi I have a Zoho form. I have records that have been typed in Excel which I wish to import into the form. I need this at automated as can be. The form has 30+fields. When I try an import from Excel the field headers have been typed exactly however Zoho doesn't recognise the field matching headers and I have to match the Excel fields to the Zoho fields manually every time. I tried exporting the form from Zoho to Excel then copying my data into the Excel spreadsheet then importing back into Zoho
Multilangual App
How can I build a multilangual application with Zoho?. Means not Zoho to be multilangual, my application to support different languages. The LABELS of the menus and messages to be linked to my database with different languages.
Dynamic filter
Hello. I have 3 forms: Company Data>>Property Data>>Roof Section Data Property Data is related to Company Data via company name lookup the Roof Section Data is related to Property Data via property name lookup. I created a view based on Roof Section Data and have it filtered by company via the "Criteria" function. I'd like to create a drop down similar to the auto-filter in the below view and restrict the list to the properties belonging to the company name. Is it possible to do something like this?
Next Page