Federated Login with more services
Hello. I am working on connecting WordPress and Zoho Creator. One of my headaches was how to sync users' data between them. Fundamentally, if Zoho Creator accepts more services for Federated Login, that would open a gate wider to accept more users. Is there any plan to add more, such as AOL, Windows Live, etc? It seems to be getting popular to user FID. Even WordPress has a couple of plugins to accept 20+ services. http://wordpress.org/plugins/oa-social-login/ http://wordpress.org/plugins/loginradius-for-wordpress/
Reports disappearing
I can't seem to find reports that I created earlier. Can you please investigate what has happened to the following reports? https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_STATUS/ https://creator.zoho.com/essistmgmt/assets/report-embed/TELCO_SERVICE_ORDERS_BY_USER/ https://creator.zoho.com/essistmgmt/assets/report-embed/MONTHLY_TELCO_SERVICE_ORDERS_BY_SERVICE_TYPE/ When I try to view the links, I get the following error message There is no such view in Zoho Creator
XML Documentation has missing information - 'Page not Found'
Whilst the discussion forums are a great source of knowledge, many of us rely on the on-line documentation. The documentation I require is relating to XPATH and loading XML into ZOHO, but vital images are missing. The page in question is : https://www.zoho.com/creator/help/script/execute-xml.html I count 6 images 'not available' which is like trying to follow a recipe with pages missing from the book....! An example of one missing image : https://www.zoho.com/creator/help/images/xml-execute-ui.JPG
Using lookup fields in "Display as" for lookups
Hello, Do you plan to make availiable to use lookup fields in Display as for lookups fields?
Issues in using multiselect Field ?
Hi, I'm currently evaluating Zoho Creator. I have an access app that I am are trying to replicate on Zoho. So far I have done with replicating one of our access form. I have a MultiSelect text field in that form and I'm populating options in this field from 2 zoho database views/tables using deluge fetch function. Problem here is, I want to show data from 3 different columns in single option. So I done that by appending data from columns into a single string. Check below, for each moveReq in move_quotes
Subform code disappearing
Over the last few weeks, I've noticed that Field Action code has been disappearing for subform. The latest example is Application: https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/ Subform: INITIAL_SERVICE_AGREEMENT Field: SITE_ID Note, the application is shared for support editing I've previously added code but it has disappeared. Not only has the subform field actions disappeared but the version history disappeared too. Can you please investigate? I keep having to put the code back in.
Subform code not generating properly
Subform code does not appear to be generating properly when I try and edit the code. Form https://creator.zoho.com/essistmgmt/form/1713/scriptbuilder/# Subform: INITIAL_SERVICES_AGREEMENT Note, the green circle is active for PRODUCT_SERVICE_ID field but when I try and view the code, the code editor is blank. The behaviour is inconsistent since some fields show code and others don't. Other fields that show a green circle but display empty code are MANUFACTURER_ID, SUB_SELL_MRC, SUB_SELL_NRC, etc Although
View code not generating properly
I have noticed that for a number of views, the fields listed in the display columns are not being displayed in the view. View: https://creator.zoho.com/essistmgmt/assets/#View:PROJECT_View1 Note, the application is shared for support editing With the current example, I have selected the following fields to be displayed Fields selected Fields displayed PROJECT ID PROJECT NAME PROJECT DESCRIPTION CUSTOMER AGREEMENT PROJECT STATUS PROJECT MANAGER PROJECT ESCALATION FINISH DATE START DATE PROJECT BUDGET
Error while trying to edit a View
Hi team ZOHO I have just started to recieve the following error when I try to edit one specific View in my application. [ServletException in:/jsp/edit/view/viewedit.jsp] null' I can still edit other Views without any problems and users can still access the view in question, I just cant edit it. Any help greatly appreciated. Regards Simon
Why Not Data that had been entered and stored has been disappeared
Hi Please help me that subject on this mail. The detail is quite simple, all product data that I had entered has been gone!!! It had been stored correctly but, just a few minutes ago, all data had begun not to show up. WHy??? What the hell happened?? Please Help me.
Right Click Menu of the new UI hidden by Chrome Browser Right Click Menu
Not sure if this is already on the bug radar - See the browser right click menu appearing on top of the new right click menu introduced in the new UI. Regards Moiz Tankiwala Smart Training & IT Solutions
Really Need Help with Stateless Forms/Search Interface
I am having incredible difficulty trying to use a stateless form to create a search interface for going on a week now and I'm hoping might know what to do. I would just like to be able to search the data that people have submitted to my other forms by the email field. All my forms have an email field, and being able to search the stored data (from all of my forms) by email, will allow me to find the information that I need. I've been in contact with Zoho support and they've linked me to guide for
Disable Zoho form buttons in creator
I want to use multiple ZOHO Forms on ZOHO Page. But I want only one SUBMIT button for whole ZOHO Page. How is it possible?
Unable to create a function using the Builder
I'm not able to create a function using the builder. When I try, I get an error message. See this http://screencast.com/t/PJMeI2e0Zl Thanks Alex
Price List Price Breaks
Many of the price lists I am given by suppliers have different prices for different order quantities (price breaks). Is there a 'standard' way of implementing price breaks in databases. Obviously, I don't want to repeat a complete record of Part_Number, Description, Valid_Date, Supplier etc. but I'm not sure creating another related table/form for Quantity, Price and Lead_Time is the answer. Another issue is importing a price list - most of which list price breaks in separate rows.
Setting the value of a Lookup field in Deluge
I have imported two spreadsheets into two forms (Organizations and Contacts) to get some data into my application. The Contacts spreadsheet (and form) contains a field with the name of the organization to which the contact belongs. In the Contacts form I also have a lookup field for the organization name, and now I need to go through every contact to look up the organization in the Organizations form in order to populate that field. I've tried to automate this in Deluge but I don't know how to set
Email Subform Sum on Success
I have created a simple application to bulk register youth for an event. The Adult leader fills in their info in the Parent Form, the parent form data is copied into each subform entry where the adult lists each youth that is attending by adding a new row for each. I need to produce a Success email to that adult leader that has a total cost reminder. Basically multiplying the number of rows submitted by $140. I have created a hidden field for each youth that pre-populates with 140 - so I would
issue in inserting the quotes
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
replaceAll empty string
I am using the replaceAll inbuilt function and noticed I was getting errors when I put in empty strings. Should the function return null and accept null values?
Can Print option include the search criteria?
Before printing from a view it is common to search for specific values in the view. A nice feature would be to include the search criteria on the top of the printed output. Is there any work around to accomplish this currently? Herb Wexler
Make search work on the basis of long string.
I have created a form in Zoho creator. And in this form I have drop down fields containing data having large strings with special characters. I want to select one of the option listed in the drop down field and make the search happen. But as field contains large string with special characters so it is not possible to make the search work. Is there any way with which I can make the search working.
i am facing issue in inserting quotes in zoho crm
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
facing issues in inserting quotes
the xml date is like below $xmlData = '<Quotes> <row no="1"> <FL val="Room Design">http://creatorexport.zoho.com/DownloadFile.do?filepath=/1355684768006_Classroom.jpg&sharedBy=somebody&appLinkName=applinknam-lab&viewLinkName=room_templates_View</FL> here in the value i am getting the following error string '<response><error><code>4600</code><message>Unable to process your request. Please verify if the name and value is appropriate for the "xmlData" parameter.</message></error></response> ' (length=184)
Rounding Problem
I have created a simple form to capture data from our locations. I have set all the key numerical fields (used to capture transactions and hours) to be decimals. However, I have found that it is not capturing the decimal points and is in fact truncating off the decimals. I checked the fields and all are set to 1-2 but if I edit a record at a later date, it's truncated and if I pick 2 numbers it adds to the truncated amount (4.5 & 4.5 for instance add to 8). Can someone assist me in getting this
How to automatically assign an ID number
I'm creating a property database and I need to assign an ID to each property acquired. I'd like the ID number to be automatically assigned so that users don't have to input an ID and also so that they can't adjust the value. I'd like the first property to be assigned an ID of 100, then the next 101, then 102, and so on. Does anybody know how I can do this? Thanks for your help.
I can not share
I can not share the application, I need to make it public and I can not, I urge please
Data lost for certain records - Need urgent help!
Hi, We lost data in certain fields for certain records over last week. We have over 7,000 records in the database. We run a small e-commerce business and we store customer details, order info, delivery info in the database. On Thursday we lost about 66 records, we re-entered the lost info manually, next day we lost data in over 187 records. Today we lost data in 239 records. This is really frustrating and extremely concerning. We sent e-mail to zoho support but did not get any support. I am not
Glitch in the Add Records Deluge Script Builder
This is hard to describe. On Success, I was trying to use the script builder to add records from Form A into Form B. The script builder in not functioning properly. When Selecting Form B as the target, the available field list is showing fields from Form A. Switched back to the old script builder and it works fine.
Restore a database from yesterday
OK, so I knew not to mess with live data, and I thought I backed it up by copying the form, but that didn't copy the data. So when I editted the name fields in a radio button list, all of the data that was the original name is now blank. Armitage was editted to 2: Armitage, so now all of the records that had Armitage in that field are blank Not sure if it is hidden or lost, but guessing the data is lost. So the question now becomes is my data backed up anywhere. I did not make a proper back up,
Columns missing in Pivot Chart/Table
Hi, I created a pivot chart using my one of my form/table but only few columns are available at the left side. I also tried using different form and it works fine. All columns are available.
Deluge script not working
I am having many problems using the Zoho Creator application builder. First of all, changes to an element action do not save. Instead, if I make a change and click "Save" it wipes out the script and saves as though I cleared out the script. Second, I cannot add more users to the application. Third, I cannot share the application with any of the current users. Fourth, the "My Account" window does not load anything except a white screen. This application needs to be launched ASAP so a response would
Where is "Share to Support" in New App Builder?
I've looked under Settings> General and Share it cannot find it. Where are you hiding it?
Lookup Field - Set Criteria
Hi I am using a lookup criteria that is retrieving a list of names (Assessor_Names). In the set criteria section I want it to only show a select few of their names. E.g. Assessor1, Assessor 2 and Assessor3. I can get it show only one Assessor by using: Assessor_Name == "Assessor1" But I want to specify three different Assessors to display. Sorry for the dumb question! Still learning! Thanks
Uploaded Images in HTML Views
I would like to display uploaded images on my HTML views. I followed the instructions on the following page to no avail. https://kbase.creator.zoho.com/general/i-have-uploaded-images-to-my-form-using-the-upload-field-type-how-can-i-refer-this-image-in-my-html-view Is this problem possibly due to my application being "Private"? If so is there a way to use a "key" within the url to allow access? Here is the generic html code: rec = Form [Image_Name = input.ImageName]; <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec.FileUpload%>&sharedBy=userName&appLinkName=app1&viewLinkName=view1'>
Desparately Seeking Fetch Help
I am very new to this and attempting fetch the value of a formula to populate to populate a field on another form. This is the script: PropPub1 = LUX_Enrollment[Street_Address == input.Prop1]; if(input.Prop1 == PropPub1.Street_Address) { if(PropPub1.Pub1 == "") { PropPub1.Pub1=input.PubNameLPC; PropPub1.Pub1Cost=input.Insertion_Cost; PropPub1.PubIssue1=input.IssueLPC; } My other fields work fine but the formula is exhausting me. The number fields are set as
Basic question about using values from Lookup fields
I've managed to get quite a way with Zoho but keep tripping up over some basic functionality - and I can't find any reference to it in the user manual. In a Task form, I create a lookup field (ProjectName) to the Project Name in a Projects form. I discovered that in Deluge script in the Task form, input.ProjectName returns a BIGINT, rather than the actual Project Name. So my question is... how can I convert input.ProjectName into the string of the Project Name that it refers to? Thanks for you
zoho.gapps.createEvents
Hi All I see it could be possible to write events into Google Calendar from my Creator App. Its possible to have many Google Calendars so which one does the entry go into or is it configurable? It is possible to create an entry but what about deleting an entry. I noticed there is a return code for a successful entry. Can this be stored and then used to delete an entry when prompted to by the Creator app? Cheers
Automatically assigning an ID number
I'm creating a property management database and need to assign an ID number to each property acquired. I'd like the ID to be automatically assigned so that users don't have to input an ID and so that they can't adjust the ID. I'd like the first property to have an ID of 100, then the next to be assigned 101, then 102, and so on. Does anybody know how to do this?
combined view from different forms in new app bulider
Could you please explain how to create a combined view(report) from two or different forms in the NEW APP BUILDER? You had given the explanation for the old builder but such things are not possible in the new builder. Please someone suggest me
Error Passing Form Objects
Hi, I'm getting an error any time I try and pass a form object. Take a look at this simple example and the errors I am receiving. Report Function void report(Employee employee) { }Test Function void test() { for each emp in Employee { //NO ERROR: thisapp.report(); //ERROR: Error at line number : 8 Number of arguments mismatches thisapp.report(emp); //ERROR: Error at line number : 10 Number of arguments mismatches thisapp.report(emp.ID);
Next Page