Z-Index & HTML Views
Hello, I have an HTML view set up in Zoho Creator. The HTML view uses iframes embedded within div tags. I have the div tags set to absolute positioning with a z-index set to a negative number. No matter how low I set it, the drop-down menus drop down behind the iframes. Is there something that can be done to allow the drop-down menu's to drop over the embedded iframes?
How to sort custom filters?
Is it possible to sort the custom filters in the dropdown of a view? Although my script has them in alphabetical order, they do display in alphabetical order in the filter dropdown. Thanks.
Autoincrement failing - professional use?
Hi, as I say here I have problems with duplicating autoincrement numer (with maxvalue). Yesterday occurred the same with data ID 92720000000543123 92720000000543131 As in other post I'm preoccuped with this issue because my application depend for security on this impossibility to duplicate number. But now other issue.... autonamber fail "jumping numbers" 92720000000542071 assigned xxx43 92720000000542141 assigned xxx46.... What's about xxx44 & xxx45? May autoincrement function be used
Display Data
I have 2 forms. The 1st is named Property_Input and a stateless from named Status. The Property_Input form is where I input the data for 3 fields "PropertyAddress, Date_Filed, and StatusUpdate". The stateless form has 1 field which is a lookup dropdown box populated with the data from the PropertyAddress field from the first form. I am trying to make it so that when an address is selected from the stateless form it displays all the status updates and dates for just that one property. And hides
Fill form via Script
Ok, Lets say I have a stateless form called frmTest. This form has one integer field and one string field called intEventID & strLabel Is it possible to write a function that would populate this form on the intEventID On User Update? (I know there are ways to do it within the form itself, but I'm wondering about the syntax of writing a function). Here is what I'm thinking for the function: void basFillForm(int intEventID) { varData = frmTimeSheet [intEventID == input.intEventID]; ***Populate
Excel in the Header Option
I would like to see the excel download option for the Header Option: You can choose to have a Header option for this html view in the Live mode.
Getting the data
I created a form using creator to collect registration data. How do I access the data? I made a report, so can see the info, but need to download the raw data collected to my computer. xls, csv, etc. not fussy! Thank you!
Is there a deluge command for "close window"?
Can someone please let me know if there is a deluge command to close a window that a form has opened in. Thanks.
Execute a Funxction When View Opens
I have a Decision Box field in a form that gets "set" when one date exceeds another. I know I can easily do this in a function, but I want to call the functiion when the View opens without having to click on a Custom Action button. Is this possible? Thanks.
Add public records, login to view; Relational database ability?
I've been testing Zoho for an upcoming project and I seem to have two factors that are holding me back. First, the application needs to allow Public users to input data, but only specific users to login and access the data. Second, is it possible to create relationships between different datasets? For example, ideally I would need to have a table of user data, and link it to survey data. Are these two aspects possible? I've been trying to read up yesterday and today but I can't seem to find
PDF and PRINT header buttons not working in HTML View
I have an HTML view that has the Header option enabled for PDF and PRINT. The buttons that appear on the view worked originally, but suddenly they are not working now. When the buttons are clicked on a blank window opens up, but no PDF or Print functions. The opening lines of code in my html view are: htmlpage Screen_Printing_Invoice(recordID) displayname = "Screen Printing Invoice" print = true pdf = true content <%{%>The page source for the html view has this code for the implementation of the
I can't access this form
http://creator.zoho.com/bungyhqav/incident-report/#Form:Crew
Where is Zoho Creator help?
This link: https://help.creator.zoho.com/ (it redirects from http://zohocreator.wiki.zoho.com/) is not working!! Regards, Filip
Client can't see a form from her log-in
The app is hosted under her name, but when I log in as a user everything works just fine. When she logs in, the form "Purchase Order" doesn't show up when you click the "Create New Purchase Order" heading at the top. I've logged on under her login to see this. When I hit edit, then access this application, the form loads correctly, but if I navigate away from it, then back, it doesn't show up again. Please help.
Secure embedded form in a blog
Hi, I put an embedded form in a blog, but when people click on it the browser (Firefox or Mozzilla) display that's exist a problem with security certificate. Really browser adivice that isn't a security problem, and the certificate it's know, but that isn't the same certificate of the site. We can do anything? Anyone have experienced the same issue? Thanks Mic
Firefox 3.6 warning
ZC Team, look at the picture below. This is what Firefox 3.6 shows to me when I try to access www.creator.zoho.com. I know that it's a trusted connection, but you decide if it's important to avoid such warnings for www.creator.zoho.com . Regards, George
count function not working
I am trying to use 2 criteria in a count function to see if there are any items 1) with the same po as the current item AND 2) if the items aren't marked "Received" I am doing this because I would like to update the po to "complete", if all of the items have been received I first tried to fetch records, create a list, then see if the list was empty but it wouldn't let me So then I tried a count function, and if the count function returns == 0 then I will update the order But everything is satisfying
Can't Delete Applications
For several days I have been unable to delete applications - the message "error occured. we are sorry for the inconvenience. please try after some time or refresh page and try again" repeatedly pops up. Please advise.
Amount field not accepting updates?
All of my USD amount columns on a form that are no longer accepting updates. If I supply a value to the form and update the record I get the standard message that 'data updated successfully' but when I return to the record the value remains what it was before I performed the update. All of the other non-amount columns are behaving as expected. p.s. All of the edits being processed against the values entered into these amount columns are working. The db is just not reflecting these updates.
Filter dropdown lists
How can I filter the data users can select from a drop-down list? Example: A sales person wants to enter a sales meeting it had. He selects his name from a dropdown list and after that he wants to select the company he visited ( he previously entered the company in another form, with all its details ). How can the dropdown list with companies filter only the companies he is accounting for?
Import data
I cannot upload my excel file into Creator. Have tried over and over. says done but no data. Have read the import information and followed all details. What can I be doing wrong?
On user Input help
How do write a script so that when a user inputs a certain value another field will appear? Help!!
HELP PAGES Not Loading
Greg Malone Santa Fe, New Mexico, US
Formula problem
when I add a formula by taking two of the fields, and take one of them and divide by the other one, i get the correct answer but i do not want anything after the decimal, for instance the number is 1520.0055045657 I only want the 1520. Where can i fix this, I know when I add the field i can select the format but when the formula calculates it it does not keep that format.
Error with Stateless Form on Website
I have created a stateless form for Contact information that I have embedded in external facing website. The form is set to Public; however when I try to update the form from the website I am gettting the following error: Error occured please contact application owner.
How to create a Stateless Form?
Okay, so here are my requirements for this stateless form. It is called "Delete Subscriptions" (ds name Delete_Subscriptions). It is used to cancel subscriptions, so from there, it should ask you for, the "Employee Name" (ds name Emp_Name) and it should then pull up there relevent subscriptions (those are independent of each other, they all are under one name, just they have different types, independent of each other), located in "Add Subscriptions" (ds name Add_Subscription) under "Employee Name"
Suntrust Commerical!
A Zoho Creator Application was featured on a Suntrust Bank TV Commercial. So congratulations Zoho!
Result of search in Iframe
Hi, I've to write some params to open a result of search in Iframe. I've an html view with the search form in Frame1 and I want put the result of search in Frame2 of the same html. <br /><div params="zc_SuccMsg=Please Wait&zc_SubmitVal=Submit&zc_ResetVal=Reset" formlinkname="Search" elname="zc-component">Loading Form...</div> Someone know this params? Another question, If I have more fields in the search form and I want to find a word ex. Apple, contained in a field, which is the script to search
WELL DONE
FABULOUS SITE! THANKS
importing excel into Creator, need help
Still cannot uplocoad my excel file to Creator. Have followed all steps.
Cannot update Form in htmlview
Hi, I have a strange error. In a form, when 'normally' accessed to edit, I can Update the data. But when the form is shown in a HTML view, on Update I get : 'Invalid entries found. Please correct and submit again.', and a red 'undefined' on the screen. For support : the app is Hotel, and the HTML View is Reserveren, I have shared it for support. Thanks, Danny
Best way to deal with null variables in an HTML view
I have an HTML view that is populated by 50 differerent variables. Some are from drop-downs, some aren't. On fields that aren't required, what's the best way to keep them from showing up as "null" in the document? I understand there is a way to use a tempVariable, but this would have to be done for each variable and seems messy.
How to make a search view?
I have looked at the information on the Zoho Creator Help Documents and they haven't helped me. Can somebody help me set up a search view? I have the stateless form and everything, I just don't know how to code it. Any help would be amazing. Thanks, Michael McNeill
Synchronise contact from database to Outlook
Hi Zoho! Is there a way to synchronise contacts from the database that you create to go straight into outlook?? thanks! v
Backups Not Made of Correct Application
When I do a backup for a specific application it is subsequently listed as a backup to another application. Since backups are crucial, I need this corrected ASAP. Thank you.
How do you conditionally send mail?
Okay so in my application I have two forms one to add subscriptions and the other to add subscription types. The Add subscription type form has options to allow the user to select whether he or she wants to email the subscriber and email the team leader. Then once a subscription is added the respective emails should be sent out. But those vary with each subscription selected. The Type is a Lookup field (ds name Type), the Email Team Leader field is a dropdown list (ds name Email_Team_Leader),
How do you restrict the number of items that can be selected?
Okay so my system has a set of subscriptions and basically each location has a special number of subscriptions that they are allowed to have. How can I restrict the number of subscriptions so that they do not over subscribe.
HTML in Zoho Creator
Hi I would love to be able to paste some HTML in a Form. I explain a little more : I would love to paste some tracking tool like google Analytics to analyse what people are looking into my data base. So the idea is to paste some google analytics scipt some where in the form or view. I have tried already pasting directly in the code. No success. Creating a multi line field and psting the code : No success either. Does any body has an idea ? Thanks in advance hgonay
Cascading deletes
Hi there, I have two forms, one with a lookup field to the other. I've noticed that if I delete a record in the parent form, the corresponding child records are not deleted. Instead, the lookup field is set to blank. I just wanted to check if there's any way to enforce cascading deletes within Zoho Creator, so that the child records are not left orphaned? (From the forums, I read that this is how it's done in Zoho Reports?) If it's not currently possible in Zoho Creator, could I please put my
problem for contains in set criteria
When I put "contains" in the criteria in records in editing mode there is a message saying that "adding criteria failed" please refresh or try again later. neither works; only "equals" works. please can you correct the problem urgently
Next Page