Can forms/views be hidden from the navigation?
I have certain forms and views that are embedded inside an HTML View. I want the user to access only the HTML view to access the underlying forms and views (embedded in that HTML view). How can I take the underlying forms and views off the navigation so that user only sees the link to the HTML container view in the left navigation pane and never sees the direct link in the left navigation to the embedded forms and views. Thanks in advance.
If then formula for final cost
I am totally new to this and I think it is something simple. I'm trying to get final cost...This is where I'm at If(Margin= =20),(input.Net Cost x 1.25), If(Margin= =25),(input.Net Cost x 1.33)
View criteria help required please
Can anyone help with the following with regards to setting criteria for a view. The following statement works fine and restricts the view to show only records where field "Load_ID.Status" is null and also where field "Status" is null... show all rows from Create_Pallets [(Load_ID.Status is null) && (Status is null)] I need to add another criteria to further restrict the view to show only records where, in addition to the above, field "Client.Company" contains either "word_a" or "word_b" I've
Cancel button not working in popup window opened from an embedded stateless form
I have a stateless form that is embedded in my website (no Zoho HTML view, a regular HTML website). In this stateless form I have a checkbox that opens a record for editing in a popup window on user input. To open the popup window I use openUrl("#Form:Test_Form?recLinkID=" + r.ID + "&viewLinkName=Test_Form_View", "Popup window"); where r.ID is the id of the record I want to edit. Unfortunately the Cancel button in the popup window doesn't work. When I click on it, nothing happens and the popup window
Lookup and display current information on forms and views
My Zoho Creator database has a one to many relationship of one skater to many tests passed. In several views, I need to be able to display the highest test passed of three different test types (Moves, Dance, and Free) for each skater. I have successfully created fields in the Skater Information form which are populated on form success. The script in the form looks for the highest test of three different test types and places the high test number and name in fields in the form. I can display those
App sharing
I am the admin of an app. I shared the app to a "developer"-type user, but this user can't edit the app..... do I need to do something additional?????
Pivot Chart generated from Creator subform column
Hi How do I make a pivot chart auto-regenerate when the underlying data in the subform it is based on is updated? If I have a pivot chart that is created from a main form it auto-updates the chart when ever I add new data via the form but if my chart is based on a column in a subform I can only get an updated chart by manually clicking on "regenerate" option. Thanks EDIT: Actually the chart based on the subform data will update automatically(synchronize) if I submit the subform data by using the
Create an estimate from Soho Creator
Could someone provide a sample code to create an estimate using Soho Creator's Deluge script? The following script doesn't work. For the XMLString, I copied the sample that is given in the Soho Invoice API documentation for adding an estimate into a map. What am I doing wrong? mymap = map(); myURLXMLstring = encodeUrl("<Estimate><CustomerID>3000000000338</CustomerID><EstimateDate>2009-09-06</EstimateDate><ReferenceNumber>121</ReferenceNumber><EstimateItems><EstimateItem><ProductID>3000000000332</ProductID></EstimateItem><EstimateItem><ItemName>Sample
Expense in Zoho Creator
hye there, besides creating new invoice in Zoho Invoice in Zoho Creator, is there any way to create an expense in Zoho Invoice (expense) through Zoho Creator? may i know, what's the function invole? zoho.invoice.XXXX? thanks..
How to use openUrl to act like the built-in edit record behavior
Hi i have used customer action to call forms to update records in popup window but i encounter some problem while closing the popup window if using openUrl("#Script:page.refresh", "same window") the view page reloaded to default setting, all search/filter are gone if using openUrl("#Script:page.close", "same window"); popup window closed, but the newest update is not shown in view page how can i make the openUrl act just like the built-in edit record behavior? remain the search/filter
Can Invoice pass "paid" status to creator?
is there a way to pass a "paid" status to Creator from Invoice. If the customer has made a full or partial payment, can a custom variable be passed to a table in Creator to reflect it that a payment has been received?
How to make fields required by default?
Is there a simple way to do this? In our forms, almost every field is required. It would be much easier to make everything required by default rather than having to click 'Options' and then 'Required' for every field in a very long form.
Re user management and app share..
Hi 1, Re user management, hope add a user nickname and department, because the user is described only by mail, if the user can more difficult to identify, so difficult in share form or view. 2, when share form and view by group, it is best to be able to see the group members name, and now can only see the name of the group. 3, if the administrators to all users according to the current can drag and drop create a group and can change the group members, will facilitate administrators to quickly deploy.you
Help! My public forms have disappeared my on public website
I have really got myself in a twist - please help! It was all working OK then my two Forms have disappeared from my web site: http://www.gare.co.uk/gas/submit.htm The problem started when I created a number of new reports. The real issue is in the sharing tab as I cannot get the forms or many of the reports set to Public mode. They stay stuck at Unshared no matter no matter how many times I click the Make public to all visitors over the web button. The only items I want to be private are the two
Need to create a hash based on email adrdess or zip code
I would like to create a unique hash for a public user based on email address or zip code or some other field. Any idea how I can do this easily or point me to a coding or function solution? Thought there might be a .hashcode() function somewhere. Chris
Specifying constant time for date-time field, not supported
"Error in scheduling parameters: Specifying constant time for date-time field, not supported" This is the error I received when trying to save a Schedule. What does this error mean?
error when updating dynamic pick lists
Hi, I have a form where I have subsecuent pick lists being updated dynamically based on the previous one selection. The issue I have is that when the user updates the first value, the script moves through the whole chain of picklists until the an error is issued based on the null selection of values. in other words, when a pick list is assigned with values, the script considers that as a user input which triggers the next pick list assingment. This ends up with a mistake at the end of the chain.
Need help for sort in view custom action drop-down button
Hi Can I sort in view custom action drop-down button, I tried to not do the sort, is there a way can be done? please check attch pic but when I browsing the view it's not as the sorting .. Thanks Stanley Guo 2012-2-27
Maximum Concurrent User Tickets Limit Exceeded
Hello, I'm relaunching my application a lot during development work and have hit this API login problem after about four months: "https://accounts.zoho.com/login" with the correct parameters set returns: "# #Thu May 19 04:30:10 PDT 2011 CAUSE=Maximum Concurrent User Tickets Limit Exceeded RESULT=FALSE " I can't find any reference to this error. I assume it's because I'm logging in very often. Normally I wouldn't login so often but am relaunching and re-logging in every time during development. Is
General error, message from server: "Got error 139 from storage engine".
Hi, I had a form working fine for quite some time. Today I've added two dozen text fields to it and tried to modify entries, and got the following error - General error, message from server: "Got error 139 from storage engine". Googling up showed that the error is with MySQL InnoDB max row length limitation. Is there a way to fix it, to make text fields blobs for example ?
Need Zoho creator programmer to help customize application
Hi I am looking to find a zoho creator programmer who will work under a Confidentiality Agreement as a consultant to assist in customizing application. Interested parties please contact me at ecamastro@impaxlabs.com Eric
Any good Zoho people for hire in London?
Hi, we are an SME that uses Zoho and wants to use it more. We usually have an in house resource for this but work is so busy we haven't got any spare time for him to work on it and a list of things that need to be done. Are there any freelancers out there that could spend a week in our office and help us make our Zoho system better?
Sharing with large number of users
My app has about 100 users and that number changes. I'd like for all user to be able access the view, but don't want non-users (public) sharing. Is there a way to allow a view to be accessed by ALL users without having to enter them individually or maintain a group?
tooltip for formula field
Now that formula fields can be displayed on a form we need a Tooltip for the formula. This will help communicate to the user information about the formula. Herb Wexler
Subforms on load
I have an application which contains a subform that loads 5 records on load of the parent form. in this subform i have a fields called "day". What i would like to do is have the names of the days of the week be embedded into those fields on load of the parent form, starting with Monday, and ending with Sunday. Here is the Application This is what I want it to look like (image) This thing has been driving me crazy. Any help would be GREATLY appreciated. thank you in advanced.
Search Interface
Hello all, I would kindly like to get help in making a search interface. I have already created the stateless form with the search button and also the html view. However, am having difficulties in writing the script. Ideally the search form has 6 fields which can be used to search,I would like that an input into any of the fields gives a result. Any ideas and help will be highly appreciated.
Disable SSL
We work from a slow connection and find that SSL is quite slow when logging queries. Is it possible to disable SSL when adding data to a database ?
Passing parameters via URL in embed form (or permalink) not working on iPad
Hi guys, I can't pass parameters via URL on iPad... This is working everywhere else. Is there a way to make it work ? http://creator.zoho.com/nsisolution/<appname>/form-perma/iPad_Test/from=iPad Thanks Pascal
How to Sum across all records in an application
I have an application where there are 2 fields that capture numbers in dollars. I want to be able to total all numbers for all of the reports. How would i go about doing this? Here is the application I want to be able to get a total for all records for the fields "PAID" & "BACK" thank you in advanced.
Trying to fire an email that contains a group of reports for a single country
I'm trying to fire an email that contains a group of reports for a country. For instance reports due for this month or reports past due, etc. I've got it sending 1 report per email - not what I want and I've got it sending all reports to every country (not just their own, but every single one) - not what I want What I want is to send only the reports for a particular country in a single email. As in sending the 4 over due reports for Ghana in one email. Thoughts? ******************** This sends every
GApps Users
I tried pulling in the GApps Users option from the form builder, but when running the application from a Google Site - all I get is "Select" in the dropdown field and no user names. I don't particularly want a dropdown list - I'd rather actually capture the GApps User's name behind the scenes and tag the username for the user adding data to a form. Any more examples of how to implement? I've tried logging out and logging back in to my GApps acct to see if that would trigger it, but that didn't work.
How do I integrate a Creator Form into CRM?
I created a Form to update the contact information in crm. Is there a way to post this data into crm when the submit button is pressed?
[Form Customization]: How go control the location of placement of a control in Zoho Creator
I think I had come across this information at some place a while back but can't seem to find it now that I really need it. I need to layout the controls on the form so that they are placed over three vertical columns (v/s two columns that is the default). Actually in my case, most users have a wide screen and prefer to have the controls laid over three columns such that they all fit in a single screen view without any scrolling. I do not want to break the controls over two forms either as they want
Custom Action - E-Mail Notification Question?
Hello Zoho Community, I Would Like To Have A Custom Action - E-Mail Notification Button ("show action in view header") that sends notification to all that meet the following condition. void MonthMembershipExpirationNotification() { for each record in Form [(E_Mail != "" && Method_of_Payment = "Cash" && zoho.currentdate.getMonth() = input.Month_Membership_Expiration_Notification.getMonth()] { sendmail ( To : record.E_Mail From : ""
How to find Zoho expert in Nashville, TN
I'm looking for help in configuring zoho for specialized real estate company
Submit Print Button
Hi I use this link https://help.zoho.com/portal/en/community/#topic/2266000000362158 for print a view but I have a problem: howe can i change the default header and footer to invisible when i print a view??? this my mail: walid.jaha@yahoo.fr thanks
Share by information in a View
I would like to share portions of an application by information in a View. For example an application may have a list of members that are either Active or Inactive. I would like to restrict access to some sections to Active members. In the share section it would nice to select a View and indicate the column which contains email address. When a member changes from Active to Inactive there would be no need to go back to the share section and change the list of email addresses. This feature can evolve
Commissions Calculation
hello all, In my application, am trying to calculate the commissions to be paid out to sales people. I already have the criteria for the commission, e.g if a clients purchases product A, the sales persons gets "x". am having difficulties in writing this code; it would run like this: if the Product is A, then commission is "x". Any ideas on this? kind regards,
Need help email notification.
hello all, I would like to enable email notification on a stateless form, based on the following criteria: my application is based on managing the sales task force, I use the stateless form to update the status of the clients that the salespersons talked to. In the form, I do not capture the salespersons email id, but I do have their email i.ds. How do i enable, that when each client details is updated, an email is sent to the sales person about the status of the client, including the details? Thank
Frame tageting is broken again.
Hi. Behavior that has been working for 2 years is now not working. The submit success message is breaking the frame targeting. Use Case: 1) Target a frame using the anchor link attribute TARGET. Like this: 2) Open this page and click this link: Matthew Trouts <a class="_Lnk" target="tskCal" href="http://creator.zoho.com/ensobase/david_bartels/Listings/record-edit/All_Listings/243881000033951289/&zc_SuccMsg=Finished" style="font-weight: bold;">Matthew Trouts</a>3) The proper form loads in the Frame.
Next Page