XML RPC API Issue
hi, I am using XML RPC API "http://www.zoho.com/creator/help/api/xml-rpc-api/xml-rpc-api-add-records.html" for adding 20 records to my form. I have prepared the required XML request as per the your documentation and made a request. But in the response I am only getting the last record with 'Success' status. Also, the form reflects only that last record. Kindly look into this. Also, let me know if you need anything from me. Thanks Gurpreet
Creator to Invoice API
Is is possible to send the Billing Postcode/Zip code over from Creator to Invoice when creating a new customer using the API. Been reading this page and it doesn't mention it https://help.creator.zoho.com/Create-Customer.html
can i convert the default value of dropdown field into integer value such as zero / 0 ?
//question: I have this Script that I want to calculate: (IF(How_many_days_is_your_group_skiing != "-Select-",How_many_days_is_your_group_skiing.toLong(),0) * ( (IF(Kids_Skis_Age_12_and_under != "-Select-",Kids_Skis_Age_12_and_under.toLong(),0) * 23) + (IF(Adult_Skis != "-Select-",Adult_Skis.toLong(),0) * 30) + (IF(Performance_Skis != "-Select-",Performance_Skis.toLong(),0) * 41) + (IF(High_Performance_Skis != "-Select-",High_Performance_Skis.toLong(),0) * 50) + (IF(Kid_s_Snowboard_Age_12_and_under
Query regarding the send email
HI I have question regarding send email functionality in zoho creator. To : r.EmailId From : zoho.adminuserid Subject : "Regarding subscription to our newsletter" Message : "Your subscription is approved" If i want to address to be dyanmic then in that case do i need to have paid account because it is not allowing us this in free account Regards Rana Ammar
Help my form has gone lobsided
Hi, My form https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job has some how changed the column widths so the right hand column is wider than the left. Not sure what I did to make this happen but it has worked fine with all the current fields. Please help. Cheers Nigel
Feature Request: Merge records
Hi, I've recently started developing an application for our organisation. The data that has been imported has some duplicates, and this is causing problems with our records. It would be great if in one of the views, I could select two records and click on "Merge" (which would display any conflicts, as well), and fix up any record relations. Is this on the cards?
Sum of field on related table
Good Afternoon, I am trying to find a solution to the following and haven't been able to find any help articles on it. In a table called Client I have a field called Total. I have a table called OpenItems with a field called Value I would like the Total field to be the sum of the Value field when the ClientID field matches. Any help on completing this would be appreciated. Many thanks. Best regards John MacPherson www.saffuze.com
Document date in age ?
Good Afternoon, Could someone please direct me on how to create a field that generates the 'age' of a document in days (not years). I can find the help file on calculating date of birth but I don't really understand the formula and which section to remove to convert back to days. ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) I am confused why (zoho.currentdate - documentdate) doesn't appear to work. Also will this field only update on creation and if so how do I get the field to
View showing empty fields as NULL: how to show nothing/blank instead?
Hi, In a form, I have two picklists which can be selected, or left empty. I then have a formula field which gathers these picklists in one field using the calculation picklist1 + picklist2. In a view based on this form, I have the formula field showing, but whenever any one of the picklists have been left empty, the column shows the word "null" instead of a blank. How do I get rid of the word "null", and just list an empty field if nothing has been selected?
About the Express Pricing
Hi, Since the changes Zoho has made, and I have moved into research and development. It appears that ZCreator has become exactly what I now need. Strange considering about a year ago, my position was reversed in using Zoho at all! Creator is exactly what I need...exactly, especially for our new embedded-design projects! What exactly is this express pricing? Thank you, Mario Stevenson, P.D.L. & TTEE, EQEACT
Report User Filters - Date locale not respected
Hi I've added a date range as a user filter to a report. The calendar drop-down works fine, but if I type in the date the system is forcing interpretation to US date format, despite the application settings being set for European (e.g. if I type in range 1/9/2010 to 30/8/2011 the first is interpreted as 9th Jan and the second is not resolved). Am I missing something or is this a bug that needs fixing? (App is Pupil Assessments and report is Pupil Progress. Support access is on)
Subform: How can show a field value existing in the main form?
Hello Zoho; I have a main form and a subform in order to track availability of consultant skills, idea is to add into main form all the information regarding an Technology open position. Then in a second instancy HR will add on the subform all the candidates matching that open position (Name, available date, CV file, etc). In order to easy track that I need that the open seat # field which is a field generated on the on add of the main form can be automatically passed to other field in the
schedule quota
We have same problem as same as bellow topic about schedule quota (though our plan is standard). https://help.zoho.com/portal/en/community/topic/schedules-quota-are-too-few How do we do ?
How do you change the value of a List() element?
The help documentation is clear about how to add and delete (remove) an element from a List(). But, unless I'm missing something, there's no explanation on how to change the value of an element in a List() using an index. Example: myList = List({"Larry", "Mo", "Curly"}); myList(2) = "Shemp"; <-- this is what I want to do, change the element with index=2 (the third element) to "Shemp" ...now the list should contain "Larry", "Mo", and "Shemp" or, something like: myList(2).set("Shemp"); <--
picklist criteria
hi folks, i am trying to add a date criteria to my picklist however i am not quite sure how can it be done. the scenario is i only want the list on form B to show result that match the current input date on form A, so i put something like this in the criteria Date_field == input.Date_field but obviously this was not allowed, hope you guys can help. thanks!
Help with code please
In the following code, Why wont null stay as Null with a capital N when I change it and why wont nacm hide itself when I delete the Mobile field. The url if you want to see in action is https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job if (input.Mobile != input.Mobile.getAlphaNumeric()) { input.Mobile = input.Mobile.getAlphaNumeric(); } if ((input.Mobile).length() = 11) { show Type_of_text; show RFC_text; show Send_RFC_email; show Customer_contact; show Time_of_contact;
using this </br> in script submits it as text not a next line
Hi we have </br> set in a 'on edit' 'on success' script and it is submitting the the </br> as text instead of next line. I have also tried "</ br>" and "<br />"
Currency symbol (€ - Euro) not showing properly in HTML view
I have to put some € - Euro symbol in HTML view. It was working pretty well but now it shows as : € What can I do to solve that ? Thanks Pascal Veilleux
Subform and Picklist
Hello I have a Subform related to a main form and I want to retrieve information based a third form , I wrote the code below and if a test that from the subform itself this is working, however when I test from the Main Form containing the subform and click on add row and then when I click on Nacionalidad field which is a lookup field trying to reduce the numbers of occurrence the picklist candidato its not working, why is that?, which are the differences testing the subform isolated like a form
Quick Fast Application
Hi, I cannot believe that in the past three hours, I nearly completed an entire platform aimed for the Small and Mid-sized Business (SMB!) I'm anxious to release the product into the marketplace. I'm looking to include future versions of the application into our embedded designs. This turned out to be a fantastic solution! I would like to see Logo Branding available in all versions; the Zoho Corp copyright is already showing in the footer. I would also like to see that copyright link converted
Very much looking forward to it possible to convert the Deluge to android and ios code...
Hi ZC team Very much looking forward to it possible to convert the Deluge to android and ios code services for mobile devices, if possible, will greatly enhance the developer's participation and bring to ZC broaderrange of applications.. Thanks Stanley guo 2011-11-24
Files hosting overpriced... Files hosting should be free.
One should be able to have one's business in the same place. I need a way to have all of my files (like free email services have) in the same place. Right know you'll charge me for every byte of data. It's not affordable, is a mess! Files in my PC and files in ZOHO. I can't afford your file hosting pricing. Is too expensive. A small business can have huge amounts of data, like real estate business, pictures, contracts, legal documents. I need to get organized and zoho is not woking for I cant afford
Display uploaded image in exported pdf
I'm trying to export a pdf that displays an image that was uploaded. When I view the html view online, I can see the images. BUT, when I export the view to the pdf, the image disappears. Do I need to reference the image differently when export it in a pdf? Here is my reference to it: <img src="http://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec.Image%>&sharedBy=<%=zoho.adminuser%>&appLinkName=skypro&viewLinkName=Employees_View">
Ability to Add Record to a form in a private application as a shared user through API
Hello, I know in your REST API webpage (http://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html) you state that "Only the owner of the application can add a record to a private Form." but it is also stated that "Any user with an API Key, Ticket and share permission can add a record to a shared Form." I want to ask if its possible for a user, who is not the owner of the application, to add records to a form, in a private application, it has a share permission to? (maybe i'm a little
Fixing chart scale in Creator reports?
Is it possible to inhibit the auto-scaling of the Y axis of charts in Zoho Creator reports? It's really annoying that it rescales when filters are changed as you don't see the relative changes if the chart compensates. If I know the range is 0-5 then I would like to fix the scale at that. Have I missed it, or is this a feature request? regards Simon
Don't want website visitors to edit records
I have set permissions but have not checked edit record. but in my data view (list) I am still seeing bulk edit still available. View OK. Not edit record.
View Criteria error
Hi, I have a form with 2 views, each trying to set a certain criteria to display a set of data. one of the views works fine with the criteria, however, another view always return this error when i set the criteria, no matter in script or ide mode. here is the error msg that come up when i tried to save the script Error modifying the page The following column names are duplicated in this table [t_882922000000021615.Order_Loca_882922000000021617] the code i put are as follow [location == "Ipoh"]
Fetch records based on a form date field then update the collected records
Hi I have a form with a date field so i fetch a range of dates like this rangetocancel = Hospital_Rooms [(Date1 >= anycancel.Admission_Date && Date1 <= anycancel.Discharge_Date)]; seems to work as the collection holds 4 records and there are 4 dates from admission to discharge Then i want to update another field in the same form rangetocancel.room1 = "empty"; BUT it only seems to modify the first date Admission Date not the date range from Admission to Discharge any ideas ?
Relationships between Forms
Can data from a Field "Event Date" entered in FORM A be simultaneously entered in Field "Event Date"in FORM B of the same application? I can get the data in the look-up box on FORM B but that isnt much help.
Custom Filters for a view based on tableA
Hello all, Is it possible to generate a set of custom filters for a view based on the values from a separate table (TABLE A)? TABLE A is used by several forms in my application, and if I only have to update one table, instead of this table, and filters it would be much easier. Jason Rapp
Please help with variable please and show how clever you are.
Hi, Simple scenario... Form A Form B If you run form A an alert comes up saying "You have run form A" If you open form A from form B, I want the alert to say "You run form A from form B" In simple terms the code should be When in form A make a variable called, lets say, xxa=1 and carry it over to form B when in form B say (if xxa=1 then alert "You run form A from form B" else alert "You have run form A") Could one of you clever people show me the correct script for this problem Thanks in advance
How to count records that meet criteria and show in HTML View?
I have an HTML view that acts as a home page for an app. On it, I want to show some usage metrics for the app: - # Available Items - # Expired Items - # Items Added in last 30 days from today Example: "43 Available Items 16 Expired Items 10 Added in Last 30 Days" How can I count these records On Load and display them in the HTML View? Will this slow the view down as more records are added to the app?
Support Named Calendars for iCal Feeds
ref: https://help.zoho.com/portal/en/community/topic/ical-feeds-11-11-2011 ref: https://help.zoho.com/portal/en/community/topic/new-zc-variables-for-the-ical-feed Please add a new user-definable variable for constructing an ical url that enables the definition of a calendar's name. Currently an ical's feed value for X-WR-CALNAME = the view the feed comes from. This is very limiting in the case of generating multiple ical urls from the same view. In the case of established ical feeds from ZOHO Creator,
Email Notification question
Hi, I have a couple of question regarding the email notification 1. Is it not possible to include formdata in the message for the email notification during On-delete - On success event? 2. I wanted to custom display the login name for the from address, here is what i put but it seem not successful "zoho.loginuser<" + zoho.loginuserid + ">" is it possible to put the display name associate with the user name of the login user id? 3. How do we display some of the input field in the subject header
Dark PDF Background
When I export a nested HTML view the background of the PDF is dark like the one below. The HTML view has a white background.
Invoice integration - BillingState/City in invoice function and createEstimate
Is there any way to specify Billing State & City by invoice function ? I referred to the help page and found that I can specify "BillingAddress", but there weren't BillingState or BillingCity. Without these, we need to combine all the address values into "BillingAddress" but it will cause problems when we retrieve those data in templates etc. Also, I want to create estimate in the same way to createinvoice(). Is there any function to create estimate such as createestimate()? If not, will it be supported
Formula field not resolving in reports
I am having problems getting a formula field to work in reports. The formula is to get the season of birth from a DOB field: if((DOB.getMonth() < 3),"Winter",if((DOB.getMonth() < 6),"Spring",if((DOB.getMonth() < 9),"Summer",if((DOB.getMonth() < 12),"Autumn","Winter")))) It works fine in the list, but when I try to report using a pie chart it reports "No data Available" and the legend has 1 item "Unknown". Is this a known issue, or am I doing something wrong?
How do i limit the number of times someone can submit a specific answer.
I have created a basic form with numerous questions. The selection for answers are all the same: Do not use that feature of the product Not important Important Very important How do i limit how many times they can select Very Important? They should only be able to select this 10 times. Thanks!
3 user defined filters, and an automatic filter used to populate multiple fields.
I already have a support ticket on this particular issue, but I thought some other developers may find the information useful if a solution is found. I wish to have multiple fields in my Pulser_Report form. 1. I will need nine pairs of numeric fields that will be named “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours”, “Run_2_Total_Hours_Below_Rotary” and “Run_2_Total_Circulating_Hours”…….. 2. Every pair of fields will be hidden on form load. 3. The operator will
Summation of column in a form field, (NOT IN A VIEW)
Hello all, I am trying to auto populate the field Total_Hours_Below_Rotary in my Pulser_Reports form from the Service_Hours_Below_Rotary in the form Lifetime_Hours. The below code is returning the first value entered in the Service_Hours_Below_Rotary column. What I need to display is the SUM of all entries in the , not just the first entry Service_Hours_Below_Rotary column that match Job_Number, Description,and Serial_Number. for each value in Lifetime_Hours [((Job_Number == input.Job_Number &&
Next Page