On Update on Add does it make sense
Hi just trying to get my head around this When you first add a form how can a field "On Update work", there is no reference to be updated ? maybe i am missing something and need to stop working so late
prevent a user to record/submit a form more than once by the same user
i need to make a form that cannot be completed by the same user twice , regardless of what he will do, something like an ip banned, or for a period that i set and to be able to edit that period anytime with any values. pls help me !!!
adding a row (not column) of numbers
Hi I have a form with multiple columns, marked Jan1 to Jan5, and TOTAL. Let's say that in Row1, there is a '1' under those columns Jan1-Jan5. Can I edit the TOTAL column to get the Jan1-Jan5 total of 5 ? It seems a simple request, but I'm just getting familiar with Creator and can't be sure it exists... Thanks Paul
Setting CRM "Contact lookup" field value
Hi, In our CRM, we have added several custom fields in Solution entity. We have added a Contact lookup field. Then, we try to populate Solutions from a Creator Form via script, after creating, programmatically too, the Contact. We do something like this: c = map(); c.put("First Name", input.First_Name); c.put("Last Name", input.Last_Name); // other fields... i = zoho.crm.create("Contacts", c); // error treatment... s = map(); // other fields... s.put("Contact", input.First_Name + " " + input.Last_Name);
Is there revision history at Zoho Creator
Is there a history of revisions at Zoho Creator?
Label Position
I am probably missing something obvious and, if so, apologise in advance, but in all my Zoho Creator Applications the labels mostly appear to the left of the fields. Is it possible to reposition the labels so that they are above the fields?
Combining data from form and view to ascertain count
Hi, I am taking input from 2 forms. One to take details of students, the other to take details of instructors. Each student is allocated to an instructor, so I have 3 views. One is a table of students. A second is a table of instructors, and a third is a reduced view of the instructors to show only one field other than name, that is a number of private students the instructor has. What I really want to figure out is how to add that number to the count of current students. Currently I have to use
Suggestion - form template
form: optional header for SubForm fields .... or SubForm fields .... or SubForm optional footer for SubForm
ZC and GravityForms? Has anybody done this?
I'm considering buying the GravityForms wp plugin to easily make better looking and more functional forms, and I'm wondering how easy it will be to integrate this with ZC forms. Has anybody had experience using ZC and gravityforms together? I figure the GravityForm will either Post to the ZC form, or perhaps send email to ZC form. Any thoughts, suggestions, or examples of past experience would be very helpful. Thanks in Advance
OpenURL error: Passing arguments
G'day, I request assistance with an error associated with the following code. I suspect it is trivial. I send 2 parameters from a form to a HTML view using OpenURL: ((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#View:Boys_Search?searchParam=") + input.Choose_your_city + "&searchParamD=" + input.When.toDate("dd-MM-yyyy")) Possible errors: a) Syntactical error in how the two strings are being passed. b) Because 'When' is infact a Date field, toDate() function is redundant. Would greatly appreciate
Import Data Enhancements
Dear Users, Continuing with our efforts to improve and enhance the import functionality in live mode, we are providing the ability to import records for the looked-up form(s) by uploading the combined data as a single file. This is explained briefly with an example below. Consider you have two forms "Department" and "Employee", you can import data for both the forms via the "Employee" form itself, if "Department.Name" is looked-up here as SINGLE SELECT. For this, go to the live mode of the "Employee"
Setting permissions for each record
I have an Excel table with 50 rows and 5 columns of data that I have successfully uploaded. Each row of data is specific to a certain individual. I want to verify the data but want to give each individual access to only their row/record while hiding the remaining data. Any assistance would be appreciated. Thanks!
How to Duplicate Meeting List in Active Website
Hello! I contacted the webmaster of a website that has a meeting list I want to duplicate. He led me to Zoho, which looks like a GREAT tool, and I am very excited. However, I have NO IDEA how to replicate the meeting list shown here: Example Site I realize it is created and then pulled through an iframe, but I am lost on how to create it. It isn't a form, is it? Can someone please assist? Where do I start? What do I need to do? Thank you so much!
Formula Fields do not appear in form
how come when I create a form and add a formula field, it does not appear in the form when I "access this application"?
Thumbnail generation
Hi -- I haven't been following new features for about a year or so. Has thumbnail generation been implemented yet? I've got people uploading images up to 4MB, which makes views display VERY slow at times... Thanks.
Show fields and save ID in dropdown menu
In a form I have a lookup field called Dipendente (form Dipendenti) that contain ID field but is displayed as "Name Surname" (Advanced display options). This lookup field is child of another field (Cooperativa). When I select the Cooperativa, the child field show only filtered records. It works fine but when filtered the field Dipendente I see ID field and not "Name Surname". I want view "Name Surname" and save ID. Thank you This is the code for Cooperativa field: on user input {
Web Application creator keywords in spanish
Hi Zoho, i've got a quick question. Is there any way to switch the "Add", "Delete", "Bulk Edit" and "Search" keywords to a different language from English, for instance Spanish? If so, how to proceed? regards Gabriel g_puig123@hotmail.com g_puig123
Question from newbe
I made a html with 3 slideshows with the help of the Beginner Demo of JQuery Cycle Plugin (see below). But I don't know how I can get rid of the text which comes in view when the htlml is shown: $('#s1').cycle({ fx: 'fade', speed: 1000 }); This text seems to be necessary for the code. How can I hide the code? Can anybody help? This is the code: <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"
Is there a way to have a checkbox fill a text box?
Is there any way to have a single line text box fill with the choices from a checkbox list and have them separated by commas?
Are you looking for a regular Zoho developer to help you develop your apps?
I'm looking to develop a partnership with a client in which I make a number of basic/intermediate forms and/or fill out these forms for a monthly rate of $100 US to pay some monthly bills. Developer Notes: Zoho Creator has limits on the information stored on its servers by your applications, based on your subscription service. Please be aware of the pricing limitations set forth by Zoho Creator and also be aware that the format in which your forms and tables are generated is limited to what Zoho
Can I add organization information into Saasu from Zoho-Creator?
I have an account in Saasu. And also have an account in Zoho. I created an application in Zoho-Creator. In that application I am trying to insert new Organization records in the Saasu account. How can I do this? I have the webservice key and fileId of Saasu. Can any one help me?
Show Data From External Database (mySQL) from my ZOHO Creator App.
Hi, sorry my english!!! I have a mysql database store in a external host, I need run a query from my Zoho creator application to query a customer table in my external database. How do I do this? thanks
View Enhancement Shared user Select box is no longer visible
I allow my shared user to add and to edit records....the select check box is no longer visible As admin i see the check box problem is in FF and Chrome Am i imagining this === Maybe i had the checkboxes there before because this view had functions..which are header based and which do act on a record
Create link from text input
Hi, Using this as a starter I am trying to take some text, append to an existing url and create a link. The text I am taking is from input.Postcode and is appended to http://maps.google.co.uk/maps?q= and then converted to a link to be placed in input.Map_Link So far I have input.Map_Link = (((("<a href='http://maps.google.co.uk/maps?q=" + input.Postcode + "' target='_blank'> ") + " http://maps.google.co.uk/maps?q=") + input.Postcode) + ) "</a>"; ...which is not working. Very much a beginner...any
Scheduler auto disabled
I have a schedule set to daily count the age of a record. This worked fine, until my users complained that the ages were wrong. On looking at the application, I indeed noticed that most entries after the beginning of 2012 were still aged 0, even though they were quite a few days in the system. When I looked at the schedule to see what the problem was, I saw it was disabled. I can definitely say I never disabled it, so what happened? This is making me look bad through no fault of my own, and from
relative URL for image display in Marketplace demo?
In reference to the demo mode in Marketplace, this thread says that "the demo works only if relative urls are used and breaks when full url(starting with /<username >) is used." As documented in many places, I am using the "https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=titleImage%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Books_View" technique for displaying images that have been uploaded using the application I have developed. Of course, everything works
How can I display fetched records?
Seasons' Greetings! I am new here (see question). Would appreciate assistance with the following: - I have a stateless form with a 'Find' button. - On clicking 'Find', I fetch records from another form and store it in a variable. - How is it that Deluge allows me to display these fetched records? Thanking you in advance, inclininwirefree
Re localized date field
Hi Our Creator has been used in date fields are in English, hoping to have localized date field (like the Chinese, etc.) Thanks Hope like bellow( localized) Stanley Guo 2012-1-12
Waiting Time on Click
Dear Sir/Madam I have assign a "Alert message" and a URL for next form in one Stateless form of my application. But once the user click, the form directly jump to next form. Waiting time for reading success message is very very less. Could somebody tell me how i can increase this waiting time after Click a stateless form Shiv
Sub form info in email
I have a simple form that has a sub form in it. I want to be able to send the information captured in sub form in an email, on submit of the parent form. But all i seem to be able to do is submit the IDs of the Subform records. Can someone please help this has taken me way to long and it seems like an easy thing to do.
How to add a link in a form?
Hi, I would like to add a link in a form to open an html view page. How can I do it? Thanks, FMN
Nealry identical script produces error
The following script is preceded by 4 others that are nearly identical. The only differnce is when the emails are sent and the content of the emails. When I add this script I get an "on load" error. All of the scripts are set to run "on load". The script should be executed 31 days after the record is added, if NY2012 is "no". else if ((lead.Added_Time.addDay(31) < zoho.currentdate) && (lead.NY2012 == "no")) { sendmail ( To : lead.Email From
Application functionality Stopped Working
I have arrived in my office this morning to receive multiple complaints about the changes you have made to the creator views. Some of these changes are truly awful and as I do not read the zoho forums on a regular basis, I had no idea that they were coming. I also have application functionality that no longer works which, barring a ridiculously improbable coincidence, must be the result of the changes you have made. You must reverse these changes immediately and give your users time ( say 1 month
Firellwall access to Zoho from Restricted LAN
Hi We have firewalled our LAN to block all internet traffic. We need to ALLOW only Zoho services in particular Zoho creator. Our route does not accept domain and thus we need to allow the Zoho IP addresses. I am not sure what these and and how to go about doing it but a reverse lookup gave this IP, 74.201.154.156, for Zoho creator Please advise on the correct IP addresses to use and how this can be achieved Thanks
displaying formula results on a form
is there any way at all to display formula results on a form? any hacks out there that might be useful? i am simply having people enter height and weight and I want to display body mass index on the form. i can't understand why this feature isn't included. thanks
View Enhancements-Custom Actions
I thought this topic should have a separate thread. _____________________________________________________________ 9) Bulk Edit,Delete,Duplicate and the custom actions will appear only when one or more records are selected. If the Custom Actions only show when a record is selected there will be no visual clue that there are custom actions. The user will have no reason to select a record. They will only accidentally discover that there are custom actions if they try to duplicate or delete a record.
Creating multiple records
I need help! I'm trying to create multiple records in db based upon my checkbox field called class. I've tried to write the code but it isn't work. Is it possible for someone to assist me? I started off by checking to ensure that there is a value. If there is...then for each value create a record in the db. if (input.Class != Null){ for each key in input.Class { insert into Classwork_Tracker [ Added_User = zoho.loginuser Class = key.Class Bell_Ringer
Html view print has changed...
Hi, I have been using the Html view to create brochures using data input into our database. For the past year it has been printing nicely onto A4 sheets. However for some reason (without me changing any of the script) it has now changed and is appearing larger on my print version, so that the page which used to fit perfectly on an A4 page, is now printing outside of the margins, and getting cut off. I have tried printing from a different computer and different user account, to see if it was my
Lookups
I have noticed in the precreator there is "Search and Auto-Complete", when testing this feature I noticed that my filters which I apply to my lookup field are not being applied. For example, I have my equipment categorized by location, and then by type, so for example, I can just look at head office equipment, that is computer hardware, then I can quickly select from the list the equipment I want to associate with that incident. For now in precreator I have just turned off search, and it's back to
Cant duplicate my project
Hi, I have problem duplicating one of my project, the project name is "Bilgain Transport Management" , i have allowed access to my apps, pls check it out. Thanks
Next Page