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
Totally New....wondering if this site can do what I need....
I have developed a website for people to share book trailers, using FrontPage. I would like to incorporate a search feature on the site, using data from a spreadsheet. Does anyone know if this is doable? I already have a spreadsheet with all of the details in it. Can I create a database with this information and then create a search feature from it? Does that make any sense? Here's my site: http://booktrailersforall.com
Sendmail without attachment question
Hello, I've ported my license manager application written in Java with the Zoho Creator within minutes (just to try it out and have fun! It's GREAT!). Sadly it's not possible to send attachments, so it's rather useless for me, because when I enter a new customer a small file with the license key is generated and attached to the email (at least in my java version). The only other solution I see instead of an attachment is: After creation of the customer entry create a file in some zoho webspace where
New users not getting password
My new users are not getting thier passwords sent via email. Please help.
URL Syntax for subform with multiple arguments
I'm trying to define a function similar to the "Add Attendance," except I want to pass two arguments - one for ID (which works fine by itself) and another one for date (which also works fine by itself). When I try to combine them together in one URL statement, I don't receive any error messages when I save or execute the script. However, neither field passes to my form. This is the URL statement I've keyed: openUrl("#Form:Add_Distribution?Transaction_Date?Transaction_ID" + input.date + "" + input.id
Need help creating a Custom Action to execute a function that will change a field value...
Hi, I am trying to create a custom action button for each row in a View that, when clicked, will change a dropdown field called Vehicle Status from it's previous values (for example, "Inventory" and "Ready to Sell") to "On Sale." If you can please show me an example of how this is done without referring me back to the Zoho forums or developer site. I am new to this and will need more explanation than I am getting so far in the available sites. Thanks!
Multiple client Databases
I would like to develop a web based application where each company client (and their users) have their own unique database to ensure that their data is seperate from and secure from other company clients. I would like to do this within one application if possible for the following reasons: I only want to maintain and make changes to one copy of the application, The only access to my application will be through embedded forms and views on a website so I only want one version of the embedded site.
Link Creator Forms/Views directly to Personal or Project Dashboards?
I'm contemplating using Zoho to create a company intranet of sorts...I generally like the collaborative aspects and timesheet of the Zoho dashboard...but would like to have a link on the side where someone could goto a view containing a list of RFI's created by Creator...is that possible?
Import data - values multiplied by 100 in the view
Hi! When importing data from .xls file to a form, i get the values multiplied by 100. example: value in the cell= 0,99, the value i get on the view is 99,00. does anyone know why this happens? Thanks in advance
How would I create a graph or chart to track weight?
I run a dog site for a certain breed and would like members to be able to input their dogs weight over time. Where others can view data and compare with others. Info needed would be name of dog, weight, and age. Any help on this would be great! Thanks for your time!
Field Missing when I create a Report
I added a new checkbox field to my database, but when I attempt to use that new field as a filter, the new field is not showing. Please tell me how I can find this new field. Thanks, Kevin
There is no such form in Zoho Creator
When I embed my form into my blog - i get this error message - see below This is strange - as i have never had a problem - ever - with my forms going into Blogspot.com - bloggers!!! There is no such form in Zoho Creator
Display records in a form depending upon lookup selection
HI, i've created a form with lookups to another form. I want the user to be able to select an item in the lookup field and depending upon their selection, information is shown to the side of the form fields. For example: User selects Country. If user selects Australia, a message displays to the side of the form which says "Australia has these States..(and then pulls the states by doing a lookup from the States table where the state relates to Australia) Any ideas how I achieve this? Thanks Daryl
Embedded view suddenly not working
I have many html views containing list views embedded as div-tags. I have not touched the code of my app for weeks but suddenly some of these views do not work anymore. What happens is that the criteria is not applied propperly (no records are listed) and the header is shown (despite the tag "zc_Header=false"). Here's an example: <div elName='zc-component' viewLinkName='Player_Entities_Embedded' params='Player_Name=<%=recP.Name%>&zc_RecSelect=true&Player_op=26&zc_Search=true&zc_AddRec=true&zc_DelRec=true&zc_Header=false&zc_Footer=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Summary=false'>Loading
What does "px" stand for? - How does "auto" work? Zoho Creator
In Zoho Creator, when modifying a "View," when working in "Set Column Widths" what does "px" mean? How does "auto" work when setting column widths? Thanks, Kevin
Next Page