Why does count not work if value is "null"
Hi, I have a count function saying as below: What can be wrong? Br Skouboe
Load form with requested data
Dear all, I am totally new to this application and programming in general, and need an answer to this basic question. I am looking for the easiest way for the user to edit data. I would like the user to click a button next to the school's name where upon he will be taken to a form where the data has already been inserted and where he is able to edit the information and click "save". It is that simple. But how do I do it? J
Using a Multiselect Checkbox Look Up Field
I am having fun with the new openURL command targeting an iframe in an HTML view. I'm trying to develop a simple voting application where users can add their own questions dynamically (I've got that figured out in an html view an it updates the choices nicely). Then I would like them to pick their favorite three questions from the list. Below is a sample picture: My questions: How can a limit the users to just three checks? How can I divide out the check box text to count each entry separately?
Realtional Database
I am new to database work. I need two simple forms 1. Apartment Form - with a "tenant apartment number" and a "tenant phone" feild only. 2. Repair Form - with an input feild "tenant apartment nunber", a "repair needed" feild and a "repair telephone" feild After all tenents are entered in the Apartment Form database, I would that on the Repair Form I could just enter an apartment number (not a dropdown, but enter it via keyboard) and the tenants telephone shows automatically in the "repair
Search in Creator
I would really like to know how to create search boxes for a database. I am creating a database where people will create a username and password to access. They will then select from a drop down menu with three choices: if choice 1 is picked then only certain fields are shown, if choice 2 is picked, then a different set of input boxes are shown, etc. I would like to create a search page where users can enter their search terms and search the entire database. Optimally, I would like to have multiple
Multi-select response triggers action on single-item field
Not sure if that title best describes what I'm trying to do but I hope that someone can help me with the coding for this problem. I'll be asking about a series of questions for which data may not be available, e.g. height, weight, shoe size We like to have a response for every question, i.e. no blank values. For dropdown fields, we'll include an "unknown" value, but to handle single-item fields, I am thinking of including a field (multi-select or checkbox) that allows people indicate that data for
September 2nd. Did anyone get notified the fixes were delay again. I didn't.
Proactive - Reactive @Charles, did you miss the promised date of September 2nd for many fixes and features discussed in this forum? It is September 2nd. I do NOT find that the features and fixes are implemented. Not the end of the world. But where on earth is your communication to the developer community. We promise features to our users based on your commitment to us. So the sh*t truly does roll down hill. I think I speak for all of us that we need better communication. (Take note from the amazing
Restore problems
Today, August the 27th, I went to my Restore in progres menu and I saw that: app-coin Started 2009-07-23 02:18:21.0 It's started one month ago!!!!! I Make a new restore and I realize that it doesnt works. I cannot import my script .ds either from my computer,because the import progress never ends. Any Ideas? Thank you.
how to create 4 mutualy dependent lines
Hello, similarly to a country/state dependent lines where accoridng to the country you choose, the seocnd line "state" would adjust to the choice of the country, i need to create 4 linges that each depends on the previous line choice. First line for examp,e would be maths, french, english if you choose french, a subset would appear , for example french litterature, french history and french arts. Then on the 3rd line, if you choosse french history, appears a subset of choices "french literature
Check if email field is blank before send mail
Hi everyone, in order to promote my blog I created a simple form so that visitors can tell there friends to come.It looks like this: Visitor's have to write down at least one email of there friends. How could I check if optional email fields (2,3,4) are not blank so the sendmail script does not bug? ("To:" field doesn't accept blanks...) Many thanks!! Sébastien
viewing uploades picture in view section
I made a database that I want from users to input specific information like : name , last name , and uploading a picture ... and I used upload tool in database for uploading their picture ... but in view section I want view that picture but I dont know how get the relation between that picture uploaded in form sction and viewing that picture in view section ...
Multi-Select Field: Sorted in Edit mode, but unsorted in View
I have a Multi-Select Field which displays all values (selected and not selected) sorted in Edit mode. But when I save the record, the selected values appear unsorted in the List View. They also appear unsorted when I read the values with an html View. Further info: The field's property to sort the values is selected (field properties) I modify the field with Deluge script in the On Load event and use the built-in sort functionalityThanks for any help. Filip
Re solutiong for how let customers to easy place order
Hi I hope got bloow interface for place order by customer,how do that? I tried ued "for each list value" to read a Multiple List (it's a product list) , but do not know how to let about customers to input the number of urgent,hope you give me some recommendations and your solutions, thanks! Stanley Guo
VERY VERY simple application
I am having toruble creating a very basic application where: Users enters 6 fields including 1 link to a picture and the application creates a new html code. (i already have the html code and know where the 6 fields should go) please help PS the input part is already created i am having trouble creating the view
empty fields
Hello, I have table and i would like to create 2 different views with 2 different criterias. one criteria is: that a multichoice field called "received" is empty. in the form its a yes / no choice, but since i cant choose a default value (which would be "no") i have somehow to also define the state that the field is still empty. But i dont get it: it doesnt work. I tried it with length = 0 with !="" but i don't get it And the other criteria is that a DATE field is empty. i thought about it and than
How do I create a field that performs a "SUMIF" function?
How do I create a field that performs a "SUMIF" function? =SUMIF(A:A,"A",B:B) Example: Summarizing together all values for Field B when Field A matches search criteria. Field A Field B Field C = 1700 a 100 b 200 c 300 c 400 c 500 c 600 a 700 c 800 a 900
Bug ignored. Please HELP! Related field in views.
I'm starting a new thread in hopes of getting an answer to a promised update that is languishing for 6 months now. Here is my existing thread: http://help.zoho.com/portal/en/community?ftid=2266000000144107 Please Help, tony.
Sharing
Hello, i had shared by app to a user. I removed the user from sharing list and now the app is not shared with anyone anymore. now i am trying to share my app someone new but it doesent work! Any idea? thanks
Can I create a subform that is already pre-filled?
Hi, I'm doing an app where people can order products, however I wish to be able to let them choose a product and finish filling the details of the order. It is simple, there is a view where they can find the products and for each product they want they make the order. http://creator.zoho.com/mbelatam/mx-compras-corporativas/view-perma/Productos_Corporativos/k1ZxMvbKmpgpr0gdC8yZ2GMqzyhx2ah4e3VZ5ZaREaXgP5j6ahzawASr9dbr9U2ARgaTxSzGreQ8eTpEyOeFwTpqPqt6wmAjzzZP When they click on the action button "Hacer
Embedding Zoho Creator apps as OpenSocial Gadgets in Orkut !
I am trying to integrate a Zoho App as an OpenSocial Gadget in Orkut ... and my approach is as follows : 1. Get the source code of the page that displays the ZohoApp form 2. Place the code on my own webserver and test whether the App can be accessed [ Record get added, etc ] 3. Transfer this code into an XML container, with or without using Googles, Open Social Development kit 4. Same the XML file into my webserver 5. Define the Orkut gadget in the Orkut sandbox and point to the XML file on my webserver
Please Wait msg not closing
I have a form that allows the user to upload 4 different files (Word, Excel, PDF, GPX). The user selects the file to upload and clicks on Update. The Please Wait message shows and never closes. If the user clicks on Close in the upper right the edit screen closes revealing the original View. The Please Wait msg is still showing. The file has been uploaded correctly. but the Please Wait never closes. This happens in both IE 8 and FF 3.5 -Herb Wexler -
HTML View code window is suddenly BLANK, but preview still shows output!
Zoho Creator Support.... please help! I was working on an HTML view and all was well. Then I got an error message about "Kindness" -- sorry I didn't note the entire error message because I didn't realize how serious it was. From that point forward I am not able to view my code in HTML view, either in Script Builder or Free Flow. But if I click on Preview, it previews correctly, suggesting to me that the code is there, but not being displayed for some reason. The URL to this html view is: https://creator.zoho.com/w21admin/w21data/htmlview/Workshops/edit/
New Problem
So everything before this weekend was working great with my app. Its a timeclock application, and this is the error i get now when i try to clock in or out: Error details: Error occured while executing on click script. Unable to fetch data for the form variable 'null' Error occured Anyone have any ideas on this?? Nothing has changed and i have been using this app for a few months now.
1. CR characters will be removed after executing of SendMail function in Deluge 2. Need RichEdit control
Here is one of my strong suggestion of Creator. I has been using Zoho Creator for nearly 10 months. I have only two feedbacks listing below. They are what I was very willing to tell Zoho Creator team. 1. CR characters will be removed after executing of SendMail function in Deluge. sendmail ( To : input.Emails From : zoho.loginuserid Subject : input.Title Message : input.formdata ) eg. the source data is: -----------------------------------------------
"Invalid entries found..." Error When Updating with Multi-Select Lookup Field
Here is the app: http://creator.zoho.com/tombest610/cfcsongs I have opened it up to support access. Problem: When I choose values for the "Sundays" field of the songs form, I get the error message "Invalid entries found. Please correct and submit again." It works fine when I make it a single-select instead of multi-select. Can you tell me what I'm doing wrong? Thanks. Tom Editing this... to add... I just noticed that it works fine for adding new records. I added one with Title "zzz TESTING for Lookup
View Print Error
When printing a view in Creator the first line of the second screen displays correctly but does not print - it is completely ignored (neither appears on paper nor do values accumulate as requested). Example : if 20 rows are displayed row # 21 appears on display screen but not on printed report. I have not tested for >2 pages of printed output. Zoho newbie
Record shows on zoho view but not when embedded
I have a rogue record that shows up in the view when in zoho but not when I've embedded the view in a webpage. I've double checked to make sure that the correct view was being embedded but there's still this one record that won't appear. I've tried exporting and re-importing the data to no avail. I've also manually entered the information. The record will appear in the zoho view but still not in the webpage. I've gotten it to appear once but it was not shown correctly. Has anyone else encountered
Date of today
Dear Friends, i have a text that i send via mail there are markers in the text being substituted, now there is a mark that should be substituted by the current date (i.e. today) Is there any function? thx
Views and forms with date field not working.
Hi, I am experiencing a system wide outage in my application. It appears to be related to date fields. I don't believe any changes I have made could cause this. Please advise. This is urgent. Tony.
How do I create a permalink to 'add a new record' rather than view the whole database
Hi, I've created a small application which records members and their details. I want to generate a link that I can send to new members so they can complete their details and add themselves to the database. I have a number of 'views' but whichever I use to create a permalink, the link allows shows the whole database, not the form itself (which should allow people just to fill in their details). I've created an html form which seems to do the trick - but there isn't an option for 'more actions' for
How to show Image file in browser?
Is there a way to have a direct link to an image file that someone has uploaded in my Zoho Creator, such that clicking on the link will cause the image to display in their browser (as opposed to prompting them to download the file)? Right now, I am having companies fill out the form, which includes uploading their company logo. The logo displays just fine in the Creator Form View, but if I copy the URL path to the image, it only includes a link to download the file. I would like to have a link
Help! Powered by Zoho logo just appeared out of nowhere
Help! Powered by Zoho logo just appeared out of nowhere on my form. is there anyway to remove it..its messing up the proportions i set for it. Thank you
Backup restore not working
I have just attempted to restore a backup to a new application in order to test some application changes I wish to make and am now experiencing problems accessing the original application. I performed a backup which completed OK but the restore that I requested has not completed and I am now getting "Unable to fetch data" error messages when accessing the original application ( Herringham ) that I backed up. Can someone investigate as a matter of urgency please.
Shared XML Api not returning records
Sorry if this is a bit of a newbie question, I have searched the forum but not found an answer. I have built up an XML rpc query : <ZohoCreator> <application name="myapp"> <form name="Client_Offer"> <criteria> <field name="ClientID" compOperator="NotEqual" value="Frank" /> </criteria> <range> <startindex>1</startindex> <limit>100</limit> </range> </form> </application> </ZohoCreator> ClientId is a string, I have used compops of EQUALs,
Cannot copy application
I cannot copy my application? It appears to work, but does not present me with a copy. Thanks
Demo Application - use of named iframe in openurl command
Over here ... http://help.zoho.com/portal/en/community/?ftid=2266000000399525 ... at the behest of ZOHO User tonythomas ... the ZOHO Creator Team released an ehancement (last week) where by Developers could use the openurl command to have Application resources (like Forms and Views) displayed in a named iframe on the same web page as the calling Resource. This has opened up huge opportunities for Developers to improve the interface/interaction of their Applications ... and provide Web 2.0 (AJAX)
Fetching data is not work
Help me, please! The Help topic is not correct or I dont understand how to make this operation. Help topic (see question #3): http://zohocreator.wiki.zoho.com/Fetch-and-Update-Records.html#fetchall I did fully as show at help and paste this code in "on user input" script, but error arose at Row #3 and Col#9: "expecting one of "!", ">" ... ... ... etc." Below is a code from Help topic. Plefse, tell me, how I must to do correctly? Customer_No ( displayname = "Customer Number" type = picklist values
Mobile Form and Japanese
I am making a public form for a school I work for and on the PC side works great. The mobile side I'm having issues I can't solve. When the customer inputs Japanese and submits, I get ??? in my email and on the Zoho view(which is private) All the feilds come displaying Japanese in the mail but it's just the user input. Please help.
How to display the totals of numerical values from multiple records
Every client record has a field with a numerical value. How can I display the total of all client records for that field? Creator is so easy I must be missing something?????
ZC automatically close my window!
Hi I have an application where I have the following script on input: if (input.QMCreate_Change_Notice_based_on_this_QCS == "Yes") { openUrl("http://www.creator.zoho.com/xxx", "popup window", "height=600,width=750"); } When I set "QMCreate_Change_Notice_based_on_this_QCS" to "Yes" it opens a new window correctly, but unfortunately it also close my already open window which is in edit mode, and close it without updating. Why does it close the existing? this does not make any sense! Br Skouboe
Next Page