Picklist preserves previous choices
Hi tech support We have an application (for church service and roster) which contains multiple dropdown picklists. These picklists' choice is empty and dynamically generate items according to choices from other picklists. It all worked fine until recently. What I discovered is every time dynamic picklists generated, selected and submits, the chosen item actually inserted to the picklist statically. After 30 odd times, the dropdown picklist has 30 entries. On the form, using 'clear picklist', I can
Formula Field Update Frequency
My app is designed for elderly people. I need a formula field displaying how many months have passed since the record has been updated. But my formula will always display CERO because the record is updated everytime I try to update the formula field by giving the order r.formulafield=r.formulafield; ¿What is the "updating frequency" of the formula field ?
Copy Name from form to sub form
I've read through all the topics, but I cannot get it to work. Seems to be simple. Main form is named "Contacts", sub-form is "Invoice". I just want the field "company" to populate into the sub-form. on load on "Inventory" Input.company = company.company Help please!
how to round robin like functinality in leads
leads gets a number from 1-6 and after it again number starts from 1 and end on 6.
Trying to wright to Subform field inside a "for x in" loop
In the code below, the "Notes" field is a Subform field I'm trying to wright to when an auto reminder email goes out. I can't get the syntax correct to access the Subform field. What am I doing wrong? The Main form field name is "Notes" and the Subform field name it wrights to is "Notes" I've tried y.Notes.Notes, row.Notes, y.row.Notes ******************** for each y in test_emails[Received] { y.Notes = zoho.currentdate + " Auto DEL notice"; // Trying to create an entry in Subform field "Notes"
Schedules Attach Summary View as PDF
Is it possible to attach a summary view to an email in the Schedules section? Currently it convert the Summary view to a regular list view. Herb Wexler
Cannot create invoice through a form in Zoho Creator
Hello, I have created a form in Zoho Creator and I am trying to ask Zoho Invoice to create an Invoice. I am using the script code below (which I found in your help page:https://help.creator.zoho.com/create-zoho-invoice.html input.Invoice_Detail_Status = zoho.invoice.createinvoice({ "CustomerName" : input.Customer_Name, "ItemName" : input.Item_Name, "ItemRate" : input.Item_Rate, "Quantity" : input.Quantity }); I get the following error when I am trying to save the script:Error in statement at line
Action button windows with forms loading with large white space on the right
This happens quite alot with deferent forms I'm opening for filling out. My form is jammed on the left half and white space on the right half. If I go into the delveloper tools elements inspector of my browser, I find the Table containing my two column form <td> tags, but also this third <td> tag. <td elname="zc-formTableFix" style="vertical-align:top;width:99%;"> </td> If I remove this tag using the browsers developer tools window, the form than looks correct. Question, Why is Creater adding
Embedded reports not scaling correctly in Dreamweaver created site
An interesting one this one. I built a site with ten embedded Zoho reports. This was a very simple site and worked just fine. I adjusted the iFrames to 600 x 500 and the ZoHo content scaled perfectly. I then decided to do a better job based on CSS using Dreamweaver CS 5.5 (don't ask) and the reports did not NOT then scale properly and were elongated only showing about a quarter of the bar charts in the vertical direction. Actually it was very browser dependent - the only common thing was that no
Fetch record using checkboxes (Multiple Values)
Currently I have a form i.e (Finance Entry) in which we make Payment or Receipt entries. One of my another form having the entries of our Customer Outstanding. Form name: Payment Outstanding (eMail_Tool). In [finance entry form] I have to fetch the value from [Payment Outstanding form], I am able to do so using "Lookup - dropdown" (single entry) this is script I using in "Lookup - Dropdown" [Update_PO] // Variable FPO = eMail_Tool [Ticket_No == input.Update_PO]; // if (input.Customer_Name ==
Appending items in Lookup Field which display value is different than its value
Hi, In one form, we have a lookup field looking for ID but, displaying the description. Then, when we try to programmatically append a new item (we have also inserted the new item in the corresponding form, programmatically too), the only way is setting the new ID but then it displays the ID, not the description. It looks horrible! Is there a right way for appending the item correctly and displaying the description (the ui.append() function has only one parameter, for the value). Thank you very much,
Simply adding an image into my form to be displayed when the form is being filled out...
I just simply want to add and image to my form to be displayed when the user is filling out data for reference reasons. Through research it appears that this can be accomplished using the Notes filed; but I am not understanding how to get the image I want to use in an appropriate area so that the URL tags in the Notes field can reference and access it. Does my image need to be uploaded to Zoho somewhere so that it can be used in the NOtes field? Pardon my ignorance; but I thought it should be rather
Dynamically Created List Bug
Here's a picture of a test form's checkbox field with one item: In the form's code, I clear the checkbox and dynamically add items: clear ITEMS; for each r in LIST { ITEMS:ui.add(r.ITEM); } In live mode, it looks just fine. So I select an item and submit the form: Back in edit mode, the item I selected is now appearing! Somehow, the form's definition code was changed. This also happens for anonymous users submitting data with the form. I view this not only as a bug, but a security issue. For
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 ?
Next Page