Application Design
I am looking for a bit of help designing an Application for Creator. Basically its a message taking application, but rather than setting up an application for each person, I want to created a drop down box which will be who the message is for, then when I submit the form, it emails that person. Can anyone help with the script that would be needed?
2nd condition being ignored in validation script
I have a form with 2 fields "Region" and "New Region" Region is a look-up field from another form and New Region is a Single entry text field. When I use the following script to validate that there are entries in both, the first condition is evaluated and submit is canceled. However the second condition is not and the form will process even when the second field is null or empty. if ((input.Region == null) && (input.New_Region == null)) { alert "enter a region"; cancel submit; } If
URL field not working correctly
I have a view with a list of records and each record has a URL field. All of the URL fields work correctly; when I click on the URL it opens in the same window. This is the way I want it to work. But, when I click on the URL field in the last record, it opens in a new window. This is NOT the way I want it to work. Why does the last record in a list behave this way, when all of the other records work correctly.
Error
Error occured, please contact administrator, for 2 weeks now. Email pjmitchell@rocketmail.com or account holder, herndon.tim@gmail.com
Create a view or report based in diferent forms
hello, how can i create a view or a report based in different forms. Example: I have different forms for different product sales. In the end of a day i want to have a view, or a report, wich give the result of the sales of that day, including the summ of the sales. can you help me please. Kind regards, José Pedro alvarez
Validation of 2 conditions fails when 1 is a look-up field
To see the whole discussion see: http://help.zoho.com/portal/en/community/topic/2nd-condition-being-ignored-in-validation-script I have a form with 2 fields "Region" and "New Region" Region is a look-up field from another form and New Region is a Single entry text field. When I use the following script to validate that there are entries in both, the first condition is evaluated and submit is canceled. However the second condition is not and the form will process even when the second field is null
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
How can your get a link for an application that can be embeded in a website? Application was created by uploading an excell document.
Show related views on one screen.
I have an application with several related forms. There is the client details form then a form for the details of each of the clients children, then a form for each of the clients automobiles, then a form for each of the clients pets. The forms have many to one relationship with the client. Is there a way to show all this information on one screen? What I envision is a list on top of the screen showing the clients. When a client name is highlighted the lists of children, automobiles and pets show
Cycle 3: Review the Features and Cast Your Vote!
The voting application can be found at this link http://creator.zoho.com/niskypto/cycle3/ Please review the proposed features, which now include comments from the ZOHO Creator team. To vote, you will need to sign in to your ZOHO account. Votes will be collected from 13-JAN-2010 until 27-JAN-2010.
Formula to calulate days until closing
I'm trying to calulate the number of days until a project closes. So I need to take the closing date minus now to get the number of days so I can write a rule. This is what I have but it shows nothing. Datecomp(Now(),${Potentials.Closing Date})
Can you or how do you get the contents of the form (in Zoho creator) sent to you via email once somebody has filled it out?
Can you or how do you get the contents of the form (in Zoho creator) sent to you via email once somebody has filled it out? Many Thanks!
I Get a Blank Page When I Go to Edit Form
I am no longer able to edit my form as it doesn't show in edit mode. The form is "VarietySlotting" under the PDdbMobile application. I have given support access. Please let me know if I did something wrong to cause this so I don't do it again. Thanks!
Auto assigning values to fields based on a pre-defined criteria
Hi Guys, I use Zoho Creator to run a runner ranking program. The idea is that runners submit their timings for a particular distance (they can choose from a total of 6 different distances). For a given distance, i need a 'rank' assigned to each runner. Right now, i do it manually i.e. export the data and sort the entries and then assign ranks (which will be displayed through a view). I know i can auto-assign serial numbers (by using counters), but can't seem to get a solution for assigning ranks
Lookup Criteria
I have this form to match individuals already matched with project onto a second project. So I've based a lookup on two criteria, both of which must be met, that reads something like this: (Match != null) && (Second_Match == null) I just KNOW there are records in my database that meet this criteria, the form selected is right, but no matter what I do, the dropdown is empty. why won't it work?
Filling a field with On User Input
I'm having a bit of trouble getting one field to fill in based on the input of another field. Here are the details: I have one form called Part_Types. In that form there are only two fields: Part_Type (single line) & Part_ID_Number (decimal). The Part_Types form is completely populated with all of its needed data. The second form is called Parts. In the Parts form I have, among others, a Type field, which is a drop-down list based on on the Part_Type field from the Part_Types form and a Part_ID field
Undeterminated Error
Hello, I'm getting this error when i include a record to a form: Duplicate entry '' for key 2 there is no aparent reason for this. Here is the code of the form: form Funcionarios_Dependentes { displayname = "Funcionarios Dependentes" must have Funcionario ( type = picklist values = Funcionarios.Nome_Completo sortorder = ascending ) must have Dependente ( type = picklist values = {"Conjuge", "Filho/Filha", "Pai/Mãe", "Irmão/Irmã", "Outros"} ) must have Nome ( type = text ) Observacoes ( displayname
Error Code 2892
Yes, it seems Zoho Creator has a problem recognizing my application's name. This (API key and ticket crossed out for any security reasons): <form method="POST" action="http://creator.zoho.com/api/xml/read/apikey=[edited]&ticket=[edited]"> <input type="hidden" name="zc_ownername" value="hjdoyle"> <input type="hidden" name="XMLString" id="XMLString" value=QueryRequest> <input type="submit" value="Get List"> </form> ..always returns 2892 - "Specified application name
Criteria - Show only if date field is older than one month
How would I write the script for the criteria on a view that only shows records that have a Date field that is older than 1 month from the current date? In other words, I don't want a record to show up in a certain view unless the Date field on that record has an entry that is older than one month from the current day.
Any way to hide image name in my application?
In my application MNMemebership, is there any way to hide the image name in the view of the form but still have the image show up in the view?
Form is Scrambled on Mobile
Hello Zoho Team, One of my forms ("Trial") is scrambled on my mobile device. It is the only one with this problem. The form is in perfect order on the PC. Zoho currently has full access to my application. mobile format: http://creator.zoho.com/mobileForm.do?zc-mobile=true&appLinkName=pddbmobile&formLinkName=Trial&link=true&deploy=true&sharedBy=smspdd PC format: http://creator.zoho.com/smspdd/pddbmobile/# Thanks for your help.
html views are rendered into blank PDFs
Hello Zoho Creator Team All my links to PDFs (created by Creator on the basis of html views) give me blank PDF Files. Example (adjusted slightly for confidentiality reasons): https://creator.zoho.com/username/MyApp/pdf/Print_Asset_English/&recID=373791000000813031&zc_FileName=Asset_XYZ&zc_PdfOrientation=portrait&zc_PdfSize=A4 Regards, Filip
Item Reported to be Fixed ... but it is not !!!
On this page ... http://help.creator.zoho.com/Feature-updates-and-bug-fixes.html ... amongst the list of items reported to be fixed for ... Friday, Jan 08, 2019 ... is a line that says ... In a view containing many columns, when search is clicked, for the operator "Between". the search text boxes were very small. Fixed ... but it appears not to have been fixed ... see attached image. Gaev
Export data from a long form
Hi, I've done this form https://creator.zoho.com/simona_landi/questionario/#Form:Internet_form it's a long form... Now I need to export my data in a spreedsheet (excel), I don't need a view. I've tried using a view but the number of my colums (138) are too much, if I reduce the number of displayed colums when I export data I cant't get all the form data. Is there a solution? Thanks. lorenzo
Internet explorer problems????
Hi, My users are having problems since january 2010. Problems: - when submiting they dont receive the confirmation message and the internet explorer opens an pop up suggesting to download .do file... - the data field is not opening, they have to write instead of using the calendar pop up I use a mac os with safari, and I dont have problems is it a internet explorer problem?? Please fix it to me.... thanks
Is there any way to link Zoho Creator & Zoho Invoice?
I am trying to come up with a better system of collecting purchase orders and book orders from retailers that we work with. It would be great if I could create an application with fields necessary to placing the order and have that translate into the invoice ability. Is it possible to link a Creator app to Invoice, so that I can invoice each entry as it is entered in? Thank you! Ashley Ainley
Does insert command fail to execute if null values are encountered ?
Hi Team, I have a Parent From with foll fields Exec Name Designation Company Name (Drop down with list of existing companies from company master populated at runtime + "-Not in list- " Address City State Website When CompanyName = "-Not in list- "is selected, a text box is shown to the end user to enter the company name Other details are filled.. and form submit. On Form submit, I have Insert command for if(CompanyName =="-Not in list-") { [ insert into CompanyMaster Company Name = input.companynametextbox
Create 2 or more different forms to update same table?
Is it possible to create multiple forms with different field layouts but all saving the data to the same table. As far as I can tell each form is the table itself and only that form can update the table that stores the data. I know that many views can access the Forms data.... My input Form has "Set Email Notification" associated with it that is automatically sent when a record is added. However, my the database administrator needs to add records to the database/form and not have an automatic
Cycle 3: ZOHO Creator Team Responds
Community: After we get a response from the Creator Team, the voting phase will begin on or around 24-JAN-2010 Creator Team: Please review the submitted features. Would ZOHO offer this feature? Which plan (free or otherwise) does ZOHO see this feature available? Comment on any other limitations per plan as necessary. How long to implementation? Note: The community understands the issues with guessing this. Summary ▼ ZOHO User ▼ Feature ID ▼ IsIs NotIs EmptyIs Not EmptyStarts WithEnds WithLikeContainsNot
Permalink without login is not working in ie
Permalink without login for html view is not working in IE Requires authorization.
Permalink not working without login.....I have it set up to not require login.
My form YRI_Agreement_Request_Form is asking users to enter their login. 99% of those entering data into the form are not Zoho users. The form originally worked, but now, for some reason is telling users they must login. The form was originally set up without a login, but I re-did the link just to make sure. It is still requesting a login. I have trouble seeing the issue myself because the form always loads for me, whether I have logged into Zoho that particular day or not. I appreciate help
Zoho Upload API Help Documentation
This might be a simple question, but the answer has been eluding me for some time now. Any assistance would be appreciated. I am trying to upload a document using Zoho's Upload API (http://apihelp.wiki.zoho.com/Upload-APIs.html) and I'm looking for a step-by-step guide for doing this. The only API of the POST type that I could find in the help documentation was http://help.creator.zoho.com/Add-Record-using-Zoho-Creator-API.html#deluge A similar help doc on Upload API would help other non-techie 'developers'
Text wrapping and the Safari browser for Mac OS X
In Safari on a Macintosh computer, text does not wrap to the window. It will continue off the side of the window. For example, if you make a calendar view and click on the name of an event scheduled on that calendar, the summary of the event will continue off to the side of the window, and you have to scroll to read it. I would rather have the text wrap to the window.
Combining Data Between Apps
Greetings, So I have 2 separate apps that both share a similar need, creating educational classes. The equipment that is used in the classes is from the same location.Instead of opening up both apps separately, how can i create a shared view or report to monitor both apps at once? Can i use a stateless form to place data in two separate apps simultaneously? Any ideas would help, thanks.
Export records problem
Search and export record does not work- search for record is working, but if I want to export it I recieve " no records were found"
Strange Pop-up in zoho
Hey Zoho, We have noticed that when we upload data through our form on zoho creator that we occasionally get a pop up message that some users interpret as an error. Just wondering if you might know what the issue might be? -Elliot
xPath Builder Error
In working with Zoho Sheet, I have stumbled upon an error which was raised in an earlier post on this forum. (https://help.zoho.com/portal/en/community/topic/xpathbuilder-error) I couldnt find the answer in that thread. Can someone pl enlighten me on this? My error message is as follows - Error :: Invalid XML/JSON format javax.xml.xpath.XPathExpressionException Funny thing is I've got similar code that works very fine with Zoho Writer.
Creator erased my data upon adding data in an unrelated field!
Bad bug! I added a Currency Column. Started inputting data, and then realized it erased data from some of my other fields in the same group! What happened?
Problem with embedding.
When embedding the application in a website, why is only the application's name visible? And how does someone access that data when viewing via the website.
How about a spot where we can view all the custom script we made in a Creator Database?
How about a spot where we can view all the custom script we made in a Creator Database? It took a while to understand deluge script, but I like it now. Would it be possible to create a spot in the program where we can view all the custom code in one location? I ended up writing so much code, that I had to start copying it to a text editor so I could visualize it all in one location. Just an idea. Thanks, r_gutowski
Form Email Notification Cap
There appears to be an issue when setting email notification for a form. It will not allow more than three email addresses to be included. The workaround I have found is that the limitation is only to each line item. So I can have three on the "To" line, three on the "CC" line, and three on the "BC" line. Is this limitation intentional?
Next Page