Null field to be "zero" for "null" values
I have a formula field which 5 fields. Manipulating the 5 fields to reach a formula field value. If any of the 5 fields is null, then the formula does not give any value.... how to solve this issue. Thanks.
Question about populating fields on a form automatically.
Hello, I have created a form called for employee contact information, that has a user's name as well as the branch that they work at and other info. I have also created another form and I have it set up so that I can select the employee's name from a drop down last as they are created, but I would like to know how to have it populate a field with their branch location when their name is selected. Thanks.
Created new application under my account and gave user developer rights. The they don't have the option to edit application
I created a new application under my account. I added the usersemail to the share under the edit application. I marked them as developer. I assured the username under account settings is developer. However, when the user logs in to the application, they ddon'thave the edit application feature. Please help! Thanks you in advance
Reg availability of logged in user info in public apps
Dear Users, Username and emailid of the logged in user is available as zoho variables in all the applications created using Zoho Creator. The variables zoho.loginuser and zoho.loginuserid can be used in scripting to write logic based on the user viewing your application. For eg: You can have an application in Creator where you have data related to all your customers but you can make sure that each of the customers is able to view only those records that belong to them based on their logged in username
Number Conversion Function
I need to convert a Hex string to decimal. On doing a Google search for "Zoho hex to decimal" I found this function, apparently in Zoho Sheet: DECIMAL Returns a decimal number, given a text representation and its base radix. Syntax DECIMAL(text; radix) Syntax Description text is text representing a number with the base radix radix (an integer between 2 and 36). Any leading spaces and tabs are ignored. Letters, if any, may be upper or lower case. If radix is 16 (hexadecimal system), any leading 0x,
A href link in mail
Hello, I am trying to put the link in mail body of my email in Zoho creator. I need to provide the link to the uploaded document through mail sent. I have the link - "<a href='https://creatorexport.zoho.com/DownloadFile.do?filepath=/" + input.File_Upload + "&sharedBy=" + zoho.adminuser&appLinkName=test&viewLinkName=test_view+ "'>Uploaded File</a>" But it is displaying the entire link instead of the "Uploaded File" caption. The HTML tags are also enabled in Application settings. Please help me to
Marketplace - if you are not logged in you cannot search the marketplace
I happened to be browsing the marketplace today and was not logged in. I could not find a search box! The only option was to browse, which is highly inefficient for hundreds of apps. If you login, you see a search box. Please make this search box available to non-logged in users! Also, when I click the "Post Your Requirement" button, it did not work! In fact nothing happened, I only saw an error in the bottom left hand corner status bar. I was using IE 8. I did go back a second time and this time
Submit form and populate fields in a separate application form.
Please advise if this is possible: On successful submission of a form I want to use the OpenURL in a script to open a form in a different application but populate fields in that form based on the submission from the original form. For example, I have a Findings application with a Priority field and a Tasks application with a Priority field. When a user submits a Result I want the Tasks form to open and populate the Tasks.Priority field with what was submitted from the Findings.Priority field. These
Error in Importing DATA. HELP ASAP!!!
Sir, I've got a problem here. I used "create apps using DS file" and it work. But when I tried to import data into it an error occurred. Picture as stated below. This is the only apps in my acc. Why does it said I've reach record limit even though there is no record is inserted yet. No one reply to my previous topic so i've created new one.HELP ASAP pls...
Feature updates and bug fixes for 08-FEB-2011
Please link to or elaborate on these new additions... User defined & System fields are categorized across Zoho Creator. - View Edit Mode : Column properties, Column width, Group/sort by, Filters & criteria - Form Edit Mode : Lookup field's field selection drop down - View Access Mode : Show/hide columns "All Times are in" will be shown only when at least one date time field is shown in viewThanks, John M. Whitney PS: Please do some maintenance on the forum announcements (posted on the right). Some
Look up part of a field. Does field value contain a string.
I have an accounts form that allows our reps to enter in an account name. However to avoid non exact duplicates (i.e Global Travel and Global Travel LLC) I would like to have a note field that updates with all possible matches of what ever is typed so far. So for example when global is entered the notes field list Global Adventures, Global Assoc Growers, ect. Basically the same functionality as an auto complete based on a database lookup. Is there anyway to do this?
If condition in a view
Hi! I have a field in a view that depends on the values of two other fields and I need to show diferent values. My if condition is: if (input.Preco_jumbo > input.Preco_continente) { Mais_barato = "Continente"; } else { Mais_barato = "Jumbo"; } My question is where should be this statement? In the form field associated to an action like on add/edit or in the view script?
Remove 'All Times are in ' from forms
Very minor request. On the bottom left of all views is the phrase 'All Times are in ' even if there are no time fields on the view. Is there a way to remove this note? Herb Wexler
How do I pass data from one form to another form?
Hello, I'm trying to build a personal financial planning database. I want to pass the "Transaction Amount" from a Transaction Entry form to a similar field in a Transaction Summary form. The link between the two forms is the Transaction ID ("ID" in the Transaction Entry form and "Transaction ID" in the Transaction Summary form). I have been able to create a link between the two forms and pass the ID, but I'm confused about how to pass the Transaction Amount. Thanks so much, Ann
Aggregate Records - Sum
What I'm trying to take the sum of total earnings and have that put into a field called Actual Earnings. But i keep on getting this error. On Success Actual_Earnings = Business_Plan[Recruiter == input.Recruiter].sum(Earnings); And this is ther Error message: Error at line: 1 Variable "Recruiter" is not decleared
Rename a form button in real time
Hi, Is it possible to change the text that is used as a button's caption while running the application? I know I can change it when creating the form, but I would like to have it changed dynamically or when loading the form Rob
Sort lookup field by second column
Is there any way to sort a lookup drop down menu based on a second (hidden) column. My lookup table is [Item | Order] I want item displayed and order hidden but used for sorting. Asc 1 - xx But I see I can only sort alphabetically. Any ideas would be great. Thanks
OpenUrl only works in Firefox
Hi, I have a On Success Add script and a SendMail script also. The OpenUrl executes by opening a new window in firefox only and does not work in Safari and Chrome. Data entry and send email works fine. Any bug with other browsers? Thank you, SL
Creator to Invoice API Problem
Hi, Stuggling with creating a new customer in another users Zoho Invoice account. Using the following: invinfo = { "CustomerName" : input.Company_Name, "CurrencyCode" : "GBP", "BillingAddress" : input.Address_Line_1 + "<br>" + input.Address_Line_2 + "<br>" + input.City_Town + "<br>" + input.County + "<br>" + input.Postcode, "FirstName" : input.Your_name, "LastName" : input.Surname, "Email" : input.Email_Address }; invResp = zoho.invoice.createcustomer(invinfo, "OTHER-ZOHO-USER-NAME"); I'm getting
Cannot create report
I currently have no reports in my database. When I try to create a pivot table report based on a particular view, the fields (in the left-hand panel) are called Column 1, Column 2, Column 3, instead of the actual column names. When I proceed with the report anyway, I get useless results - a pivot table with one cell. Why does the report generator not connect up with the view correctly?
Stateless form
Hi, I have a view 'reservations' in grid. If I click on add the Form of all my data (Order_Management_Form) pops up for data entry. I would like to use a stateless form instead once I click on add called (Add_Order) How? Please help kind regards Michael
Plz help
Dear Sir, First of all, I would like to pay thanks to zoho as I recently got one serious query for my application. In same regard, plz guide that how can I allow my client to download my application through marketplace, once I confirm the receipt of payment. It's bit urgent hence plz guide. Regards, Abhinandan sharma apsplacements@gmail.com
Name of a View
How can I change the name of a "View?"
Multiple forms in single application
I have following different questions: How to create multiple forms in a single application? Is it possible to provide only view rights only to corresponding views of those forms to a person? Can one show or hide different forms within an application based on logged in user? or If this is not possible is it possible to keep only selected fields of forms editable for a logged in user? Please help urgently.
Can multiple forms be integrated in the form of single application?
My requirement is as follows: Create 3 different forms with associated views. Have one user as owner of each of the forms. Have another 4th user with only view privilege to all 3 forms(access to views) Finally export all the three forms as a single application with specific access rights to those 4 different users One more question is as follows i: Is it possible to read data in one column of one view in a different form (in validation script)? Regards AAP
Workday function
I need to calculate a date based on number of workdays. ie " 02/04/2011 + 4 workdays = 02/10/2011". I can not find a function for this. I am a complete neophyte - any help wold be greatly appreciated.
Multiple Filters
In list view, how do you apply more than one filter to the data? I want to filter to just one person and then for only a certain month.
How does the Search Interface actually work?
I am new to the Zoho Developer community, I have a background in scripting although HTML is not my strong point at all. I am trying to create a Search interface and am following the relevant Help options that Zoho have available (https://help.creator.zoho.com/Creating-a-Search-Interface.html and https://help.creator.zoho.com/Create-HTML-Views.html) but it is getting me absolutely nowhere. The templates they have available in the HTML views are so confusing and I am just stuck! All I want to do is
How do I see if a date range falls within or overlaps another date range?
I'm trying to make a school register. The teachers need to be able to print off a weekly sheet which shows on what days each student will be attending. Technically, I think this boils down to seeing if one date range (the period of the student's attendance) falls within another date range (the period of the register - these are needed weekly). Any help from anyone on how to do this would be greatly appreciated :)
Link gives 404 error
Hi Thanks for the response to my last question. In the answer you provided, the link gives a 404 error?? Can you provide correct link Regards Wayne
SOAP request?
Hello, I'm trying to post a SOAP XML request to a URL, but the postURL() function requires the data to be a map variable. It appears that this doesn't work because it places the SOAP XML request under a field header in the post data that isn't interpreted correctly by the server. Is there any way to pass the post data as a simple string, or a workaround? Thanks, Jesse
"Create a new Stateless form from an existing form" feature problem
The new feature Create a new Stateless form from an existing form - throws an error "Stateless forms can not have unique fields..." when it's used for the fields which have Unique property. Probably this is a situation not taken into consideration when this feature was built. Also, the error with the reference line doesn't make sense for the developer, because the code is not editable in there. Regards, George
How to send form data to my personal email?
Hi there, I am new to Zoho and recently created a 'Contact' form for my blog where visitors may submit enquiries to me. How can I have these enquiries get sent directly to my personal email? Your help is much appreciated! Thanks.
Zoho Creator update via API
I tried to update record via API but getting error: "2897 Permission denied to update record" . The application is my own with all correction about apikey Everyone can help me to solve it out. Thanks
"Error modifying the page: Index 1, Size 1"
Suddenly can't save my stateless form, which had been working for many months. I get the error message in topic title. What is going on? Someone please help, urgent. And yes, application shared with support.
Passign params to HTML view
Hi :o) I have created a HTML view that contains a form and a view. This is to represent a hosting account and associated email addresses. The form opens ok with the correct ID number in the address bar - but there is no data in the form and the view is not filtered. The script behind the view is below:- ---------------------------------------------------- htmlpage Hosting_Detail(Id) displayname = "Hosting Detail" content <%{%> <div elName='zc-component' formLinkName='Hosting_account' params='zc_Header=true&zc_SuccMsg=Data
Help - I don't think I'm doing anything wrong here. So what's the problem?
I keep getting this error:1 . [t_695252000000024060] Exception occured while setting value in PreparedStatement for the Column [Successor__695252000000054001] Check whether the datatype for this column is given as specified in the data-dictionary .[t_695252000000024060] Exception occured while setting value in PreparedStatement for the Column [Successor__695252000000054001] Check whether the datatype for this column is given as specified in the data-dictionary What am I doing wrong? I have a "single
t_483991000002580764] Exception occured while setting value in PreparedStatemen
Please fix this urgently... I've gotten these errors before.. 1 . [t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary .[t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary
Delete security warning
I use hosted images in an HTML view which apparently triggers the HTTPS security warning (see below) when my page loads. This HTTPS security warning is absolutely unacceptable. Is there any way to DELETE this HTTPS warning from my application? I must delete this warning for my users to feel comfortable using my application. Refer to this topic... inulhuq says... Re: IE8 warning for HTTPS forms UNRESOLVED! by inulhuq (Employee) on 23-Apr-2010 12:08 AM Sorry for the inconvenience caused. On analyzing
sharing developer
I wan to share my application with a developer. I have activated a user account to developer. Searched the forum and found the solution saying "Edit permission to......." but this does not show up in my settings. How can I share with a developer??? Kind regards Michael
Next Page