Select DropBox and update Other...
Hi, my english is bad :( I have two forms Clients and Works... I post all my clients in the CLIENT FORM whit several fields (address, phone, blabla): Fields Importants: DNI (unique number of client) First Name and Last Name (string) And in the WORK FORM: I charge the work (not important now) maked a each user. But Selecting the Field Type DNI: "Import Data" DNI of the CLIENT FORM and First Name and Last Name of CLIENT FORM also... I need to a Script when I select in WORKS FORM a DNI (see images),
how to use another form's field in different form view?
how to use another form's field in different form view? is this possible? how to do it? reply. my email : bhaveshgodhaniya@gmail.com
how to count records in form view?
how to count records in form view? and display it in end of the view page. how to solve it? reply. my email : bhaveshgodhaniya@gmail.com
Search properties
how to have a search function in the form so that i can search for those data available in another form that fulfill my requirement? Thanks
Helpdesk addition
Love this App very close to what I am ultimately after Can we group requesters into accounts? I this way a requester can enter a ticket and we can keep the company sponsor advised (especially if chargeable)
Multi-line field size?
Hi, Is there a way to make a multi-line field have more rows and columns? I want a large field, similar to the one in which I'm typing this forum message. Andrew
Accessing XML attributes Tip...
Hi Just a tip..... If you ever need to drop a bunch of xml element attributes into a map variable. Here's how I did it. //create element variable file = xml.executeXPath("/response/tree/folder/files/file"); //create a map to hold the attribute variables data = map(); //make a list of attributes (note their is a way to do this agnostically where you don't know the name of the attribute //prior. But it's more complicated.. attributes = {"id","created","shared","sha1","file_name","size","updated"};
Message to User
I have a Custom Action that should only be used by the Administrator for debugging purposes. I've written the script for this so it only executes the important part of the logged in user is the Administrator. The problem is that the system gives any user the message that it was succesful, even though nothing in the data changed. Is it possible to give the user a specific message like this? if (zoho.adminuser == zoho.loginuser) { do_the_thing; } else { message "Sorry, only the Administrator
Best way to duplicate data
I want to duplicate both 1) Application and the 2) Data in the application - From what I have read, the only way to duplicate the data is to export the data and then import into a new application - Pls. let me know that there is a better way? Yours truly, Steve Eichenbaum Web Merchandising Manager -------------------------------------- AMG Medical Inc.
How to localize ZOHO login screens
I have noticed the various discussions about non-ZOHO branded login screens, and I am happy to see that ZOHO has come up with a solution that should address most of the concerns. Unfortunately, it seems that while almost any message in the form can be customized (and hence localized), this is not the case with the login screen, and as a result a show-stopper for many international end-users. Is there a way to have the login and sign-up screen localized, and if so, how? And if not, what is the ETA
How to Insert data In dropdown - Next step
Thanks for your help. It's working well. But now I have a 2 more questions: 1) Can we add permanent picture on form. For looking only. 2) Can I have dropdown choices according to my previous selection? For example. In my case i have (client/Project/part) So i'd like since i picked one client, my next box will propose me only the projects of this client. ( Not all the project I have imported in the past) Thanks for your help.
Online presence
Hello, It is not clear to me if the input and output forms are visible to those who have no soho account. For example Input - if someone want to sign to mailing list he as to be a soho user ? Output if I create a product catalog will it be available Online ? Thank you
Multiselect - if condidion to.String
Hi, I have a Multiselect field in which, in On user input, I put: if (input.Setor.toString() != "-Select-") { if (input.Setor == "Assistência") { hide Number1; hide Number2; hide Number3; hide Number4; .... System return that: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here I try to quit toString or put toLong, but nothing. Any help? Thanks Mic
Copy application
Hi, I can't copy this application: http://creator.zoho.com/zoho1/bulkemail/#Form:Mailer System return that: [ServletException in:/jsp/edit/form/newform.jsp] null' Thanks Mic
How to Insert data In dropdown?
Dear All, I'd like to create a drawing data base (Client, part name, updload drawing...) Right now, when i'm importing Data, I have to import all of them one by one, even if data have been imported previously. (For example, same client but 2 parts) That i'd like to do now, it's insert my new data in dropdown, then if I need to add drawing for the same client, i can pick the name in the dropdwon. No need to type it again. Is there sby who can help me? Thanks in advance for your help.
Schedule not disponible
Hi, I have a standard subscription. When I try to acces to schedule service system return that: "Schedules are available only from the "Basic Plan" onwards. Kindly upgrade to a suitable plan to continue." Thanks Mic
radio button columns not appearing in view?
I have a view and 2 columns formatted as radio buttons do not appear in my view. All other columns appear just fine. Any thoughts? If this is not a common problem I can make my app available to support. Let me know. Thanks.
Statement Limit and Clipped Wings
To: Zoho Creator Support & Dev Community Please tell me exactly how to calculate statement limits. I have run into the 5000 statement limit (one individual process i.e., on load, on submit, etc.) frequently and I want to know exactly how to calculate this so I can stay under the bar so to speak. Right now this is how I have been counting... variable = "variable"; = 1 statement for each r in form sort form variable1 range 1 to 3 { get_form = form[ID != 0]; get_form.variable1 = "variable1"; get_form.variable2
how to count records
how to count that how many records we inserted in particular form? reply. my email : bhaveshgodhaniya@gmail.com
zoho displays wrong date and problem ocur while insert textbox control using drag & drop in the form
The date of zoho.currentdate shows the wrong date on any day before 12:00 AM after that it shows correct date. It means before 12:00 AM it shows the date of one ago, and after 12:00 AM it shows correct date. What could be the reason for that? how to solve it? And another one is i cant insert any single line or multi line textbox control using drag and drop in my form i don't know whats the problem. is there any page size limit? My email: bhaveshgodhaniya@gmail.com
PDF Export Broken Again
PDF exports are broken again, again, again. Can we have a permanent fix please!
How to show the image in thunpnail view for the view form.
In the view of the form, for image it is displaying only the name of the image not the thumpnail view? Whether i have to change any settings or else it is an issue??? See the attachment...............
set input field to content of notes field?
I've created a user agreement form, which has a note field that has the user agreement text. I would like a hidden field that gets assigned the contents of the note field that has the user agreement text upon submit (or load). If the agreement language changes, I need to have a copy of the exact text that was in place when each person "signed" the agreement. When I try to do this on validate, I get this error when trying to save: Field plain does not exist in the form User_Agreement When I try to
how to solve a problem
. [t_501594000000013007] Exception occured while setting value in PreparedStatement for the Column [Machine_Un_501594000000018010] Check whether the datatype for this column is given as specified in the data-dictionary .[t_501594000000013007] Exception occured while setting value in PreparedStatement for the Column [Machine_Un_501594000000018010] Check whether the datatype for this column is given as specified in the data-dictionary may email :bhaveshgodhaniya@gmail.com
Can't open the report tab next to my Home button ?
Can't open the report tab.When I click on the "create report tab, nothing happends. There is a button made called report next to my Home button but when i click te button don't fuction. and I can;t create any more. Please help Regards Rob from Holland
Difference in Print Summary and PDF Summary View and Export PDF in IE and Firefox
Hi, I have noticed that when Print a summary view, it does it correctly, but when export it to PDF, it exports it as List. Check : http://creatorexport.zoho.com/dnjs/reco-institution-list/print/New_Reco_Institution_View/Institution=Academy of English and http://creatorexport.zoho.com/dnjs/reco-institution-list/pdf/New_Reco_Institution_View/Institution=Academy of English Also, see the difference in the Export to PDF in IE and Firefox. In Firefox it gets an extra .html added, so it is not opened correctly.
alert messages - how to erease ?
when I make a alert in 'edit mode' or in 'user input' how can I erase this alert when the user write the right thing in the field and continue to fill all other fields. it looks not very nice when the alert message is still on the screen until submit or update. regards john
Photo
I am creating a curriculum and need to insert a picture. How should I do?
Date Time - very simple question.
I have a very simple question which is boggling me. I have a Date-Time field in my form. I have the following function: if ((input.Date_Time == zoho.currentdate)) { Send email... } I want emails sent out only if the date scheduled in the record is todays date. I know my field is a Date-Time field, but for this function, I only care about being the same date. I don't know why I can't figure this out, but its not working for me. Thanks
Report
Hy! I'm having a problem with creating a report... So when I create a report that consists rows with name, surname, phone,... of a user, then, when I click in my application on that report, it shows me three users that I've previously created but I've already deleted them and so the "DB" should be empty! If I insert some of the users in "DB", it also shows me all of them - deleted and newly created... What can I do? Thanks!
Column auto-update upon view refresh - can it be done?
I am putting together a company/contract database to show a list of companies and the current status of their contracts with me (expired/active/etc) Therefore I would like the company list view to show the current status of their contract, based upon the contract start date and duration, and the current date. I've added the code to the contracts form to automatically calculate the expiry date for the record, in the On User Input/On Update events of the start date and duration fields. I have linked
Implementing one to many in one form
Hey All, I have form1 which has a one to many relationship with form2. So for every record in form1 there are multiple records in form2. Now what i would like to do is enter all the records for form2 while entering data in form2. Can we have multiple record lines in from1 which essentially take an input for form2 Form1 Name, Contact, Email There are five personality types. The personality table is as follows Form2 type date of manifestation dominant/not dominant So for every record in form1, there
1 to many tables
I have an application in Access that has many tables, some are one to many, and with look-up tables. Is it possible to import the tables as is? Is it possible to have 1-to-many tables in Zoho? I'm a newbie here.... Thx Rob
ZOHO Creator is slow to respond ...
In the last hour ZOHO Creator is slow to respond ... actions that require round trip to the server take 10 seconds or more ... normally about one to three seconds. Even when Editing the Application, response is slow. However, access to ZOHO Forum, ZOHO Writer and even ZOHO Creator Help is fine. Gaev
When reaching record limit on Professional plan, will entries be blocked, or will they be accepted at an extra charge?
I'd prefer that submissions of new entries be blocked once the limit is reached. Is that possible?
Adding cells
I have a form that has 10 cells that take a number input. The problem I am having is that not all of the cells will always have a number entered by the user. In fact most of the time it will be around 2-3. I assume what is going wrong is that the formula is trying to add void cells since there is not data inputed into them by the user. I tried making the initial value 0, but apparently that does not roll over either. Does anyone know how to fix this problem?
Permissions
Is there a way to edit permission and on a per user name basis? If not that would be a very nice feature to be able to grant individual 'users' different access rights for adding, editing, deleting, etc. records.
need
I need access to enabling public access
Questions
Can I change times to EDT? Can I add attachments to CRM?
Blank PDFs from a view
I have developed an application which has a feature which allows the user to download or print an invoice. It simply is a view which they can print or create a PDF. The PDF creation is the problem. When they click on PDF they receive a blank PDF in their viewer of choice. Occassionally though this does work??? The printing works fine. Why are they getting blank pages?? Is there a timer involved???
Next Page