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
There has to be cleaner code
Word of warning....this is kind of a long post. In the past, I've tried being abstract in order to understand concepts, but I don't think my true intentions come through my posts, so here's what I'm working on. I've created a stateless form called frmTimeSheetDataEntry (see design below). What happens is this: when the user updates the intEventID, it follows this procedural flowchart (see below). I CAN get the form to do this procedure, but it is spaghetti code (see below). //1. User Updates intDuration
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!
I can not view the repports embed in Zoho Creator.
Hello, I have created a Report using the tool in Zoho Creator, but from some computers I can not view. I see the message The page web exploration has been canceled. The error detail are: Detalles de error de página web Agente de usuario: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; GTB6.4; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 3.0.30618; .NET CLR 3.5.30729) Fecha: Thu, 18 Feb 2010 17:44:53 UTC Mensaje: Carácter no válido Línea: 1 Carácter: 1
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.
Lower case doesn't work when trying to retrieve records
I use a secondary form where people write their e-mail and my application then searches on my primary table for a match. If a match is found, then all other fields in my secondary form are automatically populated using data from the primary one. The only problem is that when I do the comparison between the sumbitted e-mail and the ones that I already have, there is a distinction between lower case and upper case e-mails. So myemail@gmail.com is actually different from MYEMAIL@gmail.com. I thought
Is it possible to control column behavior depending on data in other columns in Zoho Creator
Hey guys! This is Jane McCarty with http://webappsatwork.blogspot.com. Currently I am trying to figure out the situation with dynamic in forms http://webappsatwork.blogspot.com/2010/02/lets-check-situation-with-some-dynamic.html I want also check if Zoho Creator is capable of doing this? Is there such a functionality in Zoho Creator and where can I find any info on this? Are there any tips in Help or on the web site? I would really appreciate any info on this! Thanks! Jane
Irregular line spacing in Note fields
In my forms I always comment on what the user is supposed to enter in the fields by including a short text in a field of type Note. These comments are displayed with irregular line spacing. It looks quite ugly. Support has edit access to my app. I use Firefox 3.5.8. Regards, Filip
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
Need to update records that contain multi select fields that were populated dynamically
I have a form containing a multi-select check box field that is dynamically populated from a look-up table according to a field selected above it. Eg. "Training Type" dynamically populates "Training Subjects" according to the Training Type selected. QUESTION: How do you configure the "On Edit" to populate the Edit form properly and allow you to submit the updates? I assume the multi-select field needs to be populated from the "On Update / On Load" function, but I can't figure it out. Either I get
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
Parameter passed from non-Zoho page into an embedded view not working
Here's my dilemma. I have an HTML view with serves as a dashboard to two other forms. Both of these links call different forms and pass to each the field Username to it in an attempt to prepopulate the Username field. The HTML view dashboard is embedded in a non-Zoho webpage. The non-Zoho webpage passes Username as a parameter to the HTML view. Thus, the intention is to pass the Username from the non-Zoho webpage to the dashboard, and then to the appropriately-called form. Somehow, the Username parameter
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
Count Records Matching Each List Value and Return Total for HTML View
I am trying to create an html view report to show the total records matching each value in a list from a dropdown field in a form. What is the most efficient way to do this? I have over fifteen choices in the dropdown field and would like to count how many records match each item in the list and show the total. I've seen different ways to do this on the forums. But I do not want to create fifteen to twenty variables. Is there a better way to iterate through a list and display each total? Thanks.
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
Images in HTML View
I have been using images from a third party repository on my Home Page (HTML view). Because that site is not secure, I get a warning message every time I navigate to the page. I think this problem would go away if I could upload the image to Zoho which I can do in an upload field on a form, but I have had no success refering to it on my Home Page. Thanks in advance.
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?
Basic development questions on displaying and keeping records
I really like the simplicity of one particular sample app (Basic Lending Library ) and would like to learn how to tweak a few things to better understand how to use Creator. If I wanted to track a member's borrowing history on Book Copies, what would I need to add? Such as Dates for check in/out, and writing to the member records what copy was borrowed. Under Book Title's All Title View you can see how many copies exist, is there anyway to display rather than number of copies the Book ID numbers
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?
Using the send mail function, can I send email from a second email address, not just the zoho.adminuserid?
I'm thinking of creating a form with a dropdown list asking if you have problem A, B or C. Can I customise the send mail comfirmations so that A queries receive a response from a@mywebsite.com, B queries from b@mywebsite.com etc?
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.
How can i keep this goin?
Hey folks I have through this Zoho Creator application been working on setting a DB up which looks like this: Test DB Now I'm doing this on a Free Account type within the Zoho environment. Recently having looking at the pros/cons of this type of account i found out that there is a limit to what can be done by this account type, and thats the issue! I know that i can upgrade to other account types, but the thing is that I'm doing the above DB test- project without any financial profit and am not
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!
Add Item Method
I'm trying to find some information on Add Item deluge statement, specifically the .getall() Method (method? property?) Are there other methods for this statement? Leo Saumure
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
Next Page