script written in form don't seem to work when form is used as a sub form
a script that works in a form, doesn't seem to work when i use that form as a subform. any help?
Field Required via Script
Hello Guys, i have two fields for Text and this Code. if (((input.Acount_Code_1A != "") && (input.Acount_Code_1A != null)) { if (!(input.Acount_Code_1A).toString().matches("[a-zA-Z0-9]{2,15}")) { alert ("Account_Code_1A should be between 2 and 15!"); cancel submit; } } how can i write the code so the user always has to fill one of the two fields without which there are pre-mandatory. Thanks Carsten
Mass editing using zoho creator
I want to build an app to edit my existing records in Leads/Accounts/Contacts/Potentials module of zoho crm massively. Can you please guide how can I do that?
can i create api in trial version?
i want to use crator API in trail version . is it possible in trial version?
Custom Schedule
Hi ! i look around but dind't find my answer ! If i set a schedule to run every Last day of month wich in the list i have 31 days !! is it gonna run if there is only 28 days in the month ???
Sort button in pivot chart not working
Sort button is not highlighted and can't sort the pivot chart axys Any ideas why not working? Thanks
Barcode Recognition
Is there anyway to include a web based barcode recognition tool to import inventory. Or barcode generator. This would be similar to something like the new google phone has. Scannerfly has something like this for amazon books.
lookup function 3 levels
Hi, I need your assistance with 3 level of Lookup function. Example of My data: products short-name full-name code Mobiles Samsung 3 3.5" Android Phones Samsung 3 9983 Mobiles Samsung 3 3.6" Android Phones Samsung 3 9984 Mobiles Samsung 3 3.7"-3.9" Android Phones Samsung 3 9985 Mobiles Samsung 4 4.7" Android Phones Samsung 4 9986 Mobiles Samsung 4 5.0" Android Phones Samsung 4 9987 Mobiles Samsung 4 5.3"-5.5"
Showing all records in Table Report
Hello all When using Zoho reports to create Pivot Table, the default setting is to hide all those records that are have duplicates. Is there a workaround around this? I would like to have a Pivot Table and have all the records appear in the Pivot Table. Looking forward to your ideas and help.
Sort button in pivot chart not highlighted
For some reason the sort button doesn't work in pivot charts. I can't sort the x or y axys. Is this a bug or missing something Thanks
Creating a report with fileds from Sub-From
Hi there I am wanting to create a report, based on the parent form, but bringing in various fields from 3 sub-forms of this parent form. I have created this type of report using the view link method, but the format of this is not satisfactory, and I want each field to show as a separate column in the report. (This is fine for one field alone, but not numerous) The Subform is logically a one-to many relationship, so I am not sure why the subform columns do not show as options in the report creator,
Subform handling that worked on the old platform is no longer producing the same results!
I have a form that was created on the previous Creator platform. This form contains a subform and is working fine. I created a new form using the old form as a template. I had to use a different subform in the new form. The new subform is an exact copy of the old subform. The code is identical in both forms. The new form does not produce the same results as the old form. In the old form the code listed below returns the string with the contents of the subform field Activity. This is exactly what
adding unique rows
i want to know how to avoid duplication of records while inserting data?i want to know validation for same. when i will upload file only new rows can be added..
Single or double equals (or no equals) for boolean criteria
Hi, A fairly basic question but it would be great to have a definitive answer and I can't find one anywhere. What is the correct format for boolean criteria for a conditional expression (like an if, or to select form data)? And does it matter which format you use? (Because it doesn't seem to make any difference when I test out the different versions). A. One equals, e.g. FormData = Form[bool = true]or e.g. if (bool = true) {<expression>;} B. Two equals, e.g. FormData = Form[bool == false] or e.g.
Customer Portal Document Access
Our application has documents within the database, however the users we have set up through the customer portal are unable to open these documents with their userid and pwds. When they click on the link for the documents they are asked to sign in again via a link to the url via zoho and NOT our landing page, but their credentials do NOT work, making the documents within our application un-accessible to them. How do we fix this issue?
usage limit (how to manage)
OK, I have been using zoho creator for some time and has worked so far fine for my purpose. I do business process management and also store sales transactions. The sales transactions in particular I cannot afford to delete when I reach the usage limit. the other suff I can. Eventually (soon) I will reach the usage limit filled up with sales transactions. I need to figure out a way to manage this before that moment arrives. Obviously I can buy more records, great but eventually these will be used
Zoho CRM integration for dropdown field
I have the following code that works (in the load of a form): accountlist = zoho.crm.getRecords(("Accounts"),1,200); for each rowvar in accountlist { Client:ui.add(rowvar.get(("Account Name"))); } My question is how do I sort the Account Name for my dropdown field (Client)? Thanks
How can I create multiple rows of numbers and then connect US to it
The promo code is alpha numeric making it a pain in the ass to enter them 1 by 1 instead of doing a range of codes owned by a consultant. I would like to find a way to enter the fields: Country - (This could be a checkbox or text box or radio button) the options are either US or CH Code - (6 digit code) # of Codes - (How many sequential codes to assign to the consultant) Somehow I need to write a script that takes <code>+1 repeated <# of codes> then add or connect Country. So after inputting US 101010
iFrame vs JavaScript embed to show full report? Help Needed!
Hi, I am trying to embed reports in my website via "IFrame" so that the user has the "search" & "sort" options. But no matter what I try, it will only show the first 10 records of the report and is using "paging". I want the entire report (all records) to show, just as it does automatically if I use a "JavaScript" embed method instead. Unfortunately, when I use the JavaScript embed the user has no access to "search" or "sort" options. I would actually prefer the JavaScript embed, if I could get
Customizing a Record Summary to show continuous records
I would love to know how to make a form almost exactly like the invoice shown on this example page: https://www.zoho.com/creator/help/views/record-summary.html. The problem I am having is the data from the subform that would go in the Item,Quantity, Rate part of the view displays all in one record with a comma between them (so instead of two records, "Widget A" and "Widget B," I get one record with "Widget A, Widget B." I'm a new user and it might be that there is a relationship problem in my
Forms and reports
Is it possible to create a report based on 2 different forms that are not linked in any way?
NULL Search
How do I select records for which a field contains no data, sometimes called a NULL search? Thank you. Roger
Managing Our Products (Price List)
Hi, We would be interested in someone developing a database for us with the following fields, if interested, can you please get in touch with me? Product Name Product Code Manufacturer (drop down) Manufacturer Name Manufacturer Code Length Width Height Diameter Weight Cubic Metres (calculation L X W X H) Cost (USD) Exchange Rate (perhaps can be auto filled online or happy to enter it manually) Cost (AUD) (formula COST USD X Exchange Rate) Landing Costs per cubic Metre (I will manually enter this)
Search over multiple fields of subform data
I have a list showing the data from the subforms. I have several fields from the subforms showing. I am concatenating the fields from the subform so they can all be seen on the view. When I search I only get matches against the first field in the list of fields that are concatenated. eg. main form has name, sub-form has age-band and location. If a row shows "Martin" for name and "London 0-10 11-20" and I search for contains "0-10" I receive zero matches.
username microsoft windows
Hello, is there a way to know the user name logged in microsoft windows? Thanks in advance. David
Embed Calendar view in Creator doesn't work
I can't seem to get calendar view in creator to embed properly in my website. All I get is the report view, not the calendar view. What am I doing wrong?
lookup field on a lookup field
Hi there I am trying to add a Look-up Field onto a Sub-Form that appears in the Parent Form, BUT the Parent Form Field I require is also a "Look-up" field, linking this to another table in my App. I tried creating a Look-up to the Linked table (Not my Parent table), but this does not allow me to run reports with data from my parent table. Any assistance? Thanks Kevin
Zoho Creator: Error in executing Send Mail task. From Address is NULL.
Hello everyone. Just created an application including one form and one report via Zoho Creator. I set the form so that anyone filling the form will then send a confirmation email (one copy to me) including all data given. I tested the form and it works perfectly to me, I receive the confirmation email (I filled the form using my personal email account) and I also get it as a copy to my other email account as creator of the form. The problem is: when everyone else is filling the form, they don't appear
Field with Change Log?
Hi, I have a project tracker application, and a rich text field I use for keeping action notes, I was wondering if there’s a way to have a change log recorded option, and easy way to access it if I want to go back and look at notes I have deleted as I updated the field for new notes or projects
Problem signing into database after user changes email address in Zoho account.
Hello, I am the administrator for a database. One of the users changed their login account to a different email address: Now they are getting an error message when trying to log into the database: The error message is: "You have logged in as adminvs1. You are not allowed to access this application. ..... Please click here to login as a different user." I had already changed the usrer's email address/login to the new email address the user has changed to. The user is able to log into her Zoho account
How to Assign multi-select records for Selected user and Allow Permission to view by only the User
Hi Guys, How to Assign multi-select records for Selected user and Allow Permission to view by only the User. I have couple of users (user-A, User-B, etc.) and couple records (record-1,record-2,record-3,record-4,record-5, etc.) in the application. I want to create one form with multi-select for records and lookup for user. on submit Select records must assign to the selected user. Such as for user-A assigned records record-1,record-2,record-3 and user-B assigned records record-4,record-5 Once done
Call a function on Field Action , On User Input
Could someone help please? I have this function which works fine on test: void workorder.UsedQty(Work_Orders workorder) { for each recRow in workorder.Pick_Items { Item_Name = Maintenance_Item [ID == recRow.Item_Name]; Item_Name.Qty_on_Hand = recRow.Qty_Remaining; } } But when I want to set variable or call this function, I get the error “UsedQty is not a valid function” I am trying to call this function after a Field Action , On User Input , script as follows which
Delete User After form is closed? Unshare/ deactivate users shared to app?
I am trying to delete users as soon as they use the application that I have set up. Is there a code that could help me do that? I tried "unsharing" the user in the "on success" part of the application but it doesn't seem to unshare the user at all. In fact, the command seems essentially pointless. I need users to log in so that an email can be sent from their prospective email addresses, but then I would like said user to be automatically deleted from the account. OR If there is a way to use their
Mobile forms
Hi, Is there an option to turn off the zoho header on mobile form? I can understand why Zoho doesn't support customization in mobile, but the ability to turn off the header should be available. Something like ‘form-mobile/formname/zc_Header=false….’ Having the ability to link to mobile forms without a menu back to the entire application seems like a big oversight... Is there a workaround for this? Thanks in advance.
How to specify the start marker for the form
I am new and I have created a survey form in zoho creator which I have embedded on a webpage. When the survey loads it loads at the bottom of the survey instead of the first field. Is there a setting I am missing or some other task I need to do to specify the form load at the top at the first form input field? Thanks
Variable sales price
Dear, I'm currently testing Zoho to replace our excel based order and quotation system. Up to now everything what we need seems to work but 1 thing I can't grasp. Hope someone of you knows how to tackle this... The sales price of our products are depending on the order qty. for example: from 0 to 5 pieces = 10€/piece from 5 to 10 pieces = 9€/pieces from 10 pieces = 8€/piece I would really appreciate any guidance on how to approach this? Kind regards, Noel
Zoho Creator Blues
Is anybody else having problems sharing apps in Zoho Creator? About a week ago I started getting calls from Users with whom I had shared apps. They were logging in as usual but getting an error message: You have logged in as (xyzabc). You are not allowed to access this view. When I checked the apps it showed they were still listed as shared users. I had not exceeded my user quota. My own login (as Admin) was working fine. Despite all that, when I tried to log in as them, I got the same error message.
Record Summary customization problem
I am trying to set up a record summary view very similar to the sample invoice shown on this page: https://www.zoho.com/creator/help/views/record-summary.html The problem I am having is that the subform area (like the Item, Quantity, Price fields on the sample invoice) are not displaying multiple records. Instead, they show the multiple items in one field (like instead of showing two records for Item "Widget A" and Item "Widget B" they show one record and list the Items as "Widget A, Widget B."
Custom Button Function
Hi There I have created a Stateless Form with a Custom Button, in order to copy records from one form to another. My Script is: for each x in Project_Info[ID!=0] { insert into Install_Project [ <Job_No>=x.<Job_Number>; <Project_Name>=x.<Customer>; ]; } I however get an error on Line 1 - Improper Statement Please assist in explaining why this error is being received? Thanks Kevin
Summary View does not show all data. Specifically embedded external data. HELP.
I created a form that includes the "rich text" column. From there I am embedding external data. That data is not showing up in my summary view - which was the entire point of creating this form. Please advise. The html code I use elsewhere works fine, so its not the source code. Also, the document I am embedding shows up fine in the form when I embed it. It's just not showing up in the summary view. HELP Please. Rene
Next Page