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?
Issue creating app
Screen displays are all over the place when accessing app to edit and such. Screens are all jumbled up. Cannot access field values to change, screen stays on Form tab. Refreshing screen just jumbles everything on my screen worse. Emailed app comes in as SPAM and shows this on email. Firefox 39.0
What is the best practice for editing fields of a form from a list on an html page?
I have an html page. In this html page I have a table with iterated records from a form. I need the ability to click a button on one of the rows, which will then allow the user to edit only a few of the fields from the form. The primary field that will be edited is a dropdown. What is the best way to do this? It seems there are multiple routes to go: From the page, create a stateless form that pops-up or iframe with the fields to edit. Have buttons that use url variables that correspond with the
Alert Box on HTML Page (Creator Page)
I would love the ability to quickly debug my code in a html page by using the alert(); function. But it can only be used on a form in the onload section. The only workaround is to email to myself. BUT, its more than the debug function though. I would like the ability to alert my users as to change they made. Like, you just updated your subscription preferences. How have others been able to do this adequately? Is there a workaround?
User Field with zoho.loginuser
I have a main form with User field that is populated with zoho.loginuser upon add. As an admin, when I change the user field to another user, I want my subform to reflect the same loginuser. The subform has a field called User_name and it is a string field (not a user field). In the On Update of the User field in the Main Form, I wrote a deluge script to populate the User_Name field (string) of the subform so they are in synch. It does not appear that the functionality is present for User fields?
Custom Action Sendmail and set field value
I have my sendmail function setup and working so that when the user selects multiple records they are emailed. However, i would also like these selected records to be marked as "emailed" so that another user does not come along and email them again. How do I accomplish this? Here is my sendmail function if it's relevent: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\" style=\"\" width=\"90%\" cellpadding=\"5\">\n <tbody>\n <tr>\n <th align=\"left\"
Form created to filter records in report
Hi, I have created a search form which is supposed to filter the records in an existing report. On this search form, I have the option to search by three different criteria (you can only search by one given criteria). For example you can choose to search by Name. I am not sure what I am doing wrong here; I would like to use the public link of my published report. This is what I have: if ((input.Search_by == "Name") && ((input.Name != "") && (input.Name != null))) { openUrl("https://creator.zohopublic.com/zoho_jchan5/copy-of-requests-for-purchasing/view-perma/New_Request_Report/Xy2yfT1JP48sAa9ZbTmP6Yh8qtPAXvYBVvOgrxnkABdnrjU2f3Tat66zKN8V7XUz3xUTugdx2OnMMsBMP2k0fr4GxBSQqN9nJ5fv?Requested_By="
If... does not contain in sendmail
Hi, This is probably going to be the most simple thing, but I just can't seem to figure it out. I have a sendmail function, in which I want it to be triggered if a certain field DOES NOT CONTAIN a certain name. I am not quite sure how to go about putting this down in code. So right now, I have: ((input.Location == "Toronto") && (input.Department_text == "Head Office")) and I'd like to add the criteria that input.Employee does not contain "Celeste" Thanks in advance! Joy
Top to Bottom Deluge Help, Real Newbie Creating First App
Hello, So I'm designing an app for my business coaching company and planning on buying the paid version for all of my coaches. My plan is to offer an "Accomplishment Report" to my clients that populates the "Coach Report" for my coaches. So far I've gotten a handle on creating the fields for both forms, creating simple lookup fields, creating/implementing rules and tasks (i.e. populating certain fields when a drop down choice is made), and managing the "Report" that every click of the "Submit"
Outputting images in Creator
Hi, I am having a problem with how images are being outputted in Creator and also when the app is linked to my Zoho CRM. It is a product database and the products are linked to the client account in CRM. When the image is outputted in the report in creator it is huge (dimensionally) so the report is impossible to use efficiently. What I was hoping is that a thumbnail would be outputted and when clicked would be bigger. I tried changing the dimensions on this screen https://www.dropbox.com/s/9fon0mh6thl15k1/Screenshot%202015-07-09%2013.51.43.png?dl=0
Link in email notification to edit one record
Hi, I am unable to figure this one out. When a user fills in a form and submits it, i would like a link to be available in the email for them to edit that record that they just submitted. I have used this as the link, but it does not work! Please help! I have published the form and used the public URL that is provided in Zoho. https://creator.zohopublic.com/<public URL>/record-edit/<ViewName>/Request_Number=input.Request_Number Thanks in advance!!! Joy
Adding data via email
I have a main form called New Request and a stateless form called Update Request Status. Employees will enter requests via the form on our website. The details are then emailed to the employee for confirmation. Is it possible to have the employee add data to their existing request (i.e. record) via email? Or is it only used for adding NEW records? Thank you in advance!
quickbooks create error evaluating MAP Expression Probem
I have tried to follow the instructions for setting up zoho creator api with quick books. Instructions are found here: https://www.zoho.com/creator/help/script/quickbooks-add-record.html It seems even when i copy the example i am getting the following error message. Seems that there is something wrong with my map variable but i cant see what. If i put the map variable in an alert box it seems to look fine to me. This is located in my Purchase_Request_Form on the Order_Number on User input field.
Filter by conditional formatting
Hi With conditional formatting we have the ability to format table cells in particular ways. It would be good to be able to filter records by the way they are formatted. For example if I have two rules which both color a particular column in a record red, an option to filter that column to show records which are red or not red would be good. Thanks Craig
Next Page