multiplying decimal numbers resulting from dropdown selection
Hello, I have the following issue : I have a dropdown with option a, b and c and another with d,e,f. Depending on the dropdown choice, a decimal value is assigned to a Decimal Field (say x-factor and y-factor) for each dropdown respectively. I then try to multiply these fields in a formula field. For some reason I get no value whatever I do. If I just type numbers in Decimal Fields x-factor and y-factor I get a value in the formula field !!
type mismatch on code that was not chnaged?
I have this error showing when I click on save: "Mismatch data type for function 'getAge' at argument index 1 expected data type TIMESTAMP found data type BIGINT" it occurs in the line beginning row.age: if ((row.personId.dateOfBirth != null) && (input.dateAndTime != null)) { row.age = thisapp.stc.getAge(row.personId.dateOfBirth, input.dateAndTime); } this is code that was not changed but with this error I cannot make edits any way.
How to get values from multiple records?
Hi All, I thought this would be straight forward but I've lost the plot ... I have a form Customers. On Add Customer, sometimes, the customer name already exists in the table, which is fine because the address may be different. So we could have "Doe, John" with an address of "Hokitika" and "Doe, John" with an address in "Taranaki". Perfectly ok but I'd like to bring this to the attention of the user. It isn't possible to compare addresses as there could be slight differences between entries. What
Dear administrator
I am yash pandya an indipendent security researcher i have found xss vulnurability in your site link https://creator.zoho.com/eryash9/swf/#View:swf_View_img_src_s_onerror_prompt_2 step to reproduce : 1 create account in https://creator.zoho.com/ ex: my account https://creator.zoho.com/eryash9/ now, 2 go to the edit this application 3 Now in display name add xss java script like swf"><img src=x onerror=prompt(2)> and add link name = swf"><img src=x onerror=prompt(2)> 4 now click on accpet this
How to make consistent values in a field of the main Form and a Subform
Hello, how can I make it to have date-fields in an Subform be consistent with a date-field in the Mainform? Or in other words: I have a date field in MainForm, when I update this, I want that all dates in the depending Subform-rows are being updated.
Lookup fields and null state
Hi All, I have a simple bit of code that doesn't appear to be playing by the rules! Both Task_Helicopters_Required and Task_Pilots_Required are non bidirectional Lookup fields. if (Task_Helicopters_Required = null ) && (Task_Pilots_Required = null) { enable Task_Type; } else { disable Task_Type; } The above is accepted as valid script but Task_Type is immediately disabled on form load. I have tried changing null to "" and again it's accepted but in this case, Task_Type is never disabled. Am I being
Clearing Multiselect On Edit > On Load
I have a multiselect check box that I would like to clear of its values upon On Edit > On Load. I have tried input.Field = null; but the previously selected values are still selected.
Get subform records
Hello I ahve an application with Shops and Contacts. A Contacts can work for many shops. Used forms : - Shops - Contacts with a subform ShopWork with is a lookup field, drop-down list of Shops called Shop I want to display all Contacts for a given Shop. Input.ID is the Shop ID. lst="" ; rs = Contacts [ ShopWork.Shop == input.ID] ; for each Contacts in rs { lst=lst + rs.ID + " " + rs.ContactName + "<p>" ; } input.ListeContact = lst ; I get some names but, they have all the same values...
Certificate Error
Not only do I have to mess around to log in, now I get "Certificate Error" warning.
International Characters not handled correctly in so many places
Good morning ! I need all Zoho Management attention on this matter. I need a fix ASAP or you will loose customers and a also me delivering services. The alarming thing I would like Zoho to get fixed is the incorrect sort order for international languages. ( Swedish .... character with åäö are last in the swedish alphabet but å and ä is treated as a and ö is treated as o. If a field starts with åäö or ÅÄÖ it gets. - Incorrectly order sorted in Views and Reports - Incorrectly order displayed in lookups
Change color of embedded Zoho-Calendar in Zoho-Creator
Hello, is there a possibility to change the color of Zoho-Calendar (like in Zoho-Mail) when I embed it in Zoho-Creator? I created a page and embed Zoho-Calendar with the following code: <iframe name='zohoview' height='800px' width='100%' frameborder='0' scrolling='Auto' src='https://calendar.zoho.com/mycalendar#' ></iframe> Because the blue theme of Zoho-Calendar looks not good with Profesional-Black theme of Zoho-Creator → I want to use grey theme. Is there also a possibility to hide the Header
Zoho Creator to CRM
I have data in my creator account that gets sent to my zoho leads file in my CRM. However, it appears to have stopped sending the data. Is there any reason for this? It was working fine previously.
go to next url
On a form I use the Go to Next URL option to select a view in the application. At the top of the screen it indicates that the setting has been saved. However if I click on a field and then come back to Form Properties the setting is changed to blank. Is there something special I need to do to get the settings to stick?
Entering data in a format similar to an Excel spreadsheet
Hi, I need to create an application where I can enter data in a similar way of an Excel spreadsheet. Is there any way of having a form that looks like a spreadsheet with multiple rows and columns? Thanks a lot!
Pre-filling forms using the Permalink
Hello, Is there anyway to cutomize the url so that some fields in the form are pre-filled so that it appears more relevant to the person filling the form? I want to send the same form link (without login require): Send to Customer A - Name field to be filled with "Customer A" Send to Customer B - Name field to be filled with "Customer B" Is this possible? Is there a way we can append something to this form link that pre-fills the value in ? https://creator.zoho.com/form/form-perma/89OK0nb0Kd4aqjnnPgRcustomername=customerA
auto-create form and run calculations
Hi - I have a Calculations form which runs a bunch of calculations on User input of a Project name. I would like a record to be created in the Calculations form each time a set of criteria is met in the Project itself (i.e. if I enter the finished length of the project, create a new Calculation record for this project and run all the calculation statements). It would also be nice if the Calculation form would update if the Project form updated and that two of the same calculation form couldn't be
How to implement AGGREGATE functions in Reports in each group
Is there a technique in Zoho Creator Report to display the Average when grouped by specific column? Say per date. Thanks!
Dynamic Lookup not working
Hi, I've followed the example shown on https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup to the letter, however cannot get it to work - is there a version problem that is causing this example to no longer work?
Script Builder Deleting Parentheses and Throwing Error
In free flow, I type this and save it without any errors: Changing to script-builder it deletes the parentheses and throws an error: In Criteria left expression is of type STRING and right expression is of type BOOLEAN and the operator + is not valid If I fix it in script building and then go back to free flow, it again deletes the parenthesis. ZC must have some additional error-checking when switching between the two edit modes that should be analyzed and fixed. Cheers, John Whitney
App not publishing in marketplace
Anyone else had problems publishing apps to the marketplace?
google maps
Hello, Im new to ZOHO Creator, im trying to figure out how to get addresses on a database to be plotted onto Google maps. im sorry if someone else has posted this. Thanks
Bypass print dialogue
Any way to bypass the print dialogue? for frequent printing this is becoming a hassle to close the print dialogue each time.
Editing a record someone else created
I am running as Admin. I am trying to edit a record using this link: https://creator.zoho.com/..../Contracts/record-edit/Contracts_List/1526298000000568067 That works OK. If I use the ID of a record created by someone ELSE, I get You are not authorized to edit this record. BUT, if I use a different view which has exactly the same permissions.... https://creator.zoho.com/.....Contracts/record-edit/Contracts_Testing/1526298000000568067 I CAN edit any record. Anyone have any ideas? Alex
Data records missing - just 2 remain
I have entered data over the last few months on student details. All of a sudden, now all I see is just 2 records. I have no idea where all the other entries have gone? Is there an option to restore or access this data? Please help.
Upload field is not tall enough
All of the sudden every time I put in an upload field it is not tall enough and the data as well as the word "Browse" is chopped in half. It never used to do this. I submitted a support ticket but was just told they don't see it despite the fact that hundreds of my members do. Not sure what to do and how to fix this as it is very important and I do not get a reply from my support ticket. Yehoshua
how add entry via email?
hi how can i enter new entries in my app via email?
Date-time "daysBetween" is not being recognized.
The compiler isn't recognizing the method anymore. daysBetween(today,today.addDay(3)); throws up the error: Error at line number : 1 Not able to find 'daysBetween' function -Varun.
auto populate problem
i know a lot of people has discussed it earlier but i have problems with my auto populate fields i want to share my problems with the developers so they can fix it for me as i am very new to zoho and programming bitsi can give links to my app if they wanna have a look into it the code i am using is this if (Quote_Info[Quote_No == input.Quote_No1]) { temp=Quote_Info[Quote_No==input.Quote_No1]; input.Date_of_Issue1=temp.Date_of_Issue; input.Acceptance_Date1=temp.Acceptance_Date; } quote info is the
Chart based on record entered by UserID
Is it possible to have a chart that only shows information that was entered by the current userid? Actually I'm looking for something more complex. The application has multiple stores. Each store manager has a Zoho Login ID. I would like a function that checks the userid against the store file and and gets the store ID for that user. It then displays a chart of the activity for that store ID. Is this possible?
Auto populate date field with timestamp date
I have a date field that I would like to have auto populated with the timestamp date (mm-dd-yyyy 00:00:00) on Add and Edit. I don't see a timestamp function. How can I acheive this?
On User Input error, evaluating STRING
I have a subform that has on user input coding that is supposed to auto fill the a majority of the form. When I use the form on its on it works perfectly. When I use it through the main form the sub-form gives this error. I understand where the error is occurring I'm just not sure what is wrong with it. Especially when it works find on the main page.
Sharing of a subform
I am using the new style subform which does not require a separate form. One of the fields in the subform is a file upload field. On the view of the form I show some fields from the subform as a hyperlink. When the user clicks a window pops up showing all the fields from the subform including the file upload field. When clicking on the upload field they are asked for a zoho login ID as if they do not have access rights to the field. Since there is no separate form how do I change the rights for the
New App Builder: discussion/feedback?
I haven't used Zoho Creator in the last 2 months. I have recently found the "New App Builder". How are people finding it? What are the pros/cons? I'm used to the old builder and don't want to switch to the new app builder if there are problems/bugs.
Converting Simple Excel Formula to Deluge Script
Hi I'm currently evaluating Creator and have fallen at the first hurdle. I have a simple excel formula to calculate commission on sale price: =IF(Net Sold Price <50,Commission Level *Net Sold Price,0) I know that I need to write a script in Creator to achieve this same result. I am not a developer, i don't know java or VBA so this simple task is extremely frustrating. Can anyone provide the script that I need to enter in to the form? Any help would be much appreciated! Thanks Adam
Problem with Field in Email
I have a form that generates an email that includes a number of fields. I created a second form including some of the same fields and I am creating the script for the email. However, when I add the deluge statement for that field (<%=Property%>) the script generates the following error message: Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression Furthermore, if I go and edit the script for the first form, without making any changes
Conditionally show a field on a form if a calculated field value goes below 5000
I can use the show/hide functionality on user input however this is based on a calculated field.
input field in Mail Sujbect...
Hi Zoho Team, It seems like many things working on old UI now are working different or not working as expected in the new dev app builder. For example I'm using a mail subject string + an inpunt field and Zoho shows when email arrive the following: Solicitud de Dia por Examen del Empleado:282109000002355476 The number 282109000002355476 should be displayed as the Consultant Name. Code used was: Solicitud de Dia por Examen del Empleado: + input.name Can you tell me why this is happening?. Thanks
Need method to show relationship between different records in the same form.
I have a contacts form with multiple subforms with in it. I need to show that any one record could be related to several other records in the same form ( One to many relationship between multiple records in the same table) The method I attempted was to create a relationships table with a lookup pointing to the contacts form. I then placed this relationship form as a subform in the contacts table. The view displays properly and seems to work however the contacts form crashes with the unable to
Can't upgrade
Trying to upgrade my plan but the page just keeps going back to the upgrade options page. Help.
Forms
I created a form. When users have completed it, it gives a message that data was submitted. However, the form does not close. It stays open, so users can keep entering again and again. How do I correct that?
Next Page