Many views missing when using firefox
I have a lot of views, which means they drop down in more than one column when I'm editing the application, but they stopped showing up on firefox this week and I am having to use internet explorer. Ideas?
Big problem with dropdowns!!
ZC Team: Look how a dropdown field from a form looks in FF 3.6 and the same field in the same form in IE 8: You can see that the longer records are truncated in IE, and in some cases the public forms may become useless, being impossible for them to properly display the records from a dropdown field in the most used browser worldwide. Please solve this as soon as possible, because it may cause real problems to some users. I've spent hours to find a new solution in order to avoid the dropdown display
Update Formulas...
Hello, In calculating a difference between dates in Creator using a formula, I want to know how to refresh the calculation. When I edit the field it updates all the records, but otherwise they are locked in at the date submitted. How do I refresh them to calculate current time - submitted date?
prepopulate one form with data that has been previously entered in another form
I have two forms - one COMPANY (contains names and addresses of companies I deal with) and another PARTS (all parts I stock, can have multiple parts from one company). I have on the PARTS form a lookup for a COMPANY NAME from the COMPANY form. Now as I select the COMPANY NAME from the list I would like to have fields for the address, city, state, zip from COMPANY form update on the PARTS form. I saw the example here http://help.creator.zoho.com/Fetch-and-Update-Records.html but cannot implement the
Remove Record Count on Public List
How do I remove the Record Count link in my public database?
Calculate number of business days ( weekdays)
Hello, I am trying to calculate the number of business days between the current time (date) and the Submit Date I have on a form. Is there any built-in weekday options for this? Thanks!
Unable to add new applications
Hi! I have noticed today that I can add more applications. I understand that the free account allows me to have 3 applications, although at the Home section only two are showing. I have recently removed one to add another for testing, and I think the issue began after I disable the application and then tried to add a new one unsuccessfully, then deleted the disabled application. I have also checked my account status (when we go on pricing section, is shows my actual plan usage) and it says I have
Error en un Form y View.
No me muestra el Form Operario-Plus, y cuando quiero ver la View me da este error: [ServletException in:/jsp/edit/view/viewedit.jsp] com.adventnet.persistence.DataAccessException: Exception occured during processing the DataSet >'
Currency Field Decimal Places
I have an application that modifies a currency field in Deluge code. When I do so, the field, which is specifically set to display two decimal places in USD, only displays one decimal place. In other words, setting the field for a dollar and fifty cents makes the form display "1.5" instead of the expected "1.50". Is there a fix or workaround for this?
toXML() fails to parse html strings
I want to write a function in that extracts some content from an external html file. I saw an explanation on how to do this, basically: mapvar = getUrl(<URL>, false); stringdata = mapvar.get("responseText"); x = stringdata.toXML(); ... now parse data in x as XML ... However for anything but a trivial html page, the toXML() call fails with "Unable to update variable x". e.g. fails for http://www.google.com. Am I missing something? If nothing can be done about this, what other utilities can I use to
issue when importing excel for a new form
I've tried to create a form using this specific excel file but every time i get the following error. The date format selected does not match with your data. Please select the exact date format. Upon choosing a date format, i get the following error An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home Even if i remove the only column from the excel file and try again, the first error does not come up but ehrn
How to store data in Creator after we create a form?
Hi. I'm new here, and my problem is a little weird. Wen i start to create a new form, i just uncheck the box "Store data in Creator" and create a nice and complex form. I thought i woudn't need to record data on zoho space, but when i finish the job, i realize that i need that function ready again. So, is there a setting or anything else that could allow me to setup that function (store data in Creator) back? I don't want to create my form from zero again. Thank you all.
Link Zoho Creator and Zoho CRM
Hi there, I am new to Zoho Creator and would like to know if I can link the data from Zoho Creator into Zoho CRM? I need to create an online form to collect client's information and then manage through Zoho CRM. If anyone can give me some information on this will be much appreciated.
Can you match a regular expression in Creator?
I know that search and replace will use regular expressions. However, I'd like to use a regexp in an if statement, just to see if something matches the regular expression without doing any changes with the expression. Is that possible?
Sendmail when data submitted not by admin
Hello Zoho, first of all: I like your service a lot, great work! Maybee you can help me with some script? My database is public and I want to get a mail-message, if someone except me (admin) submitted or changed data. So function has to be some sort of: on add -> on success: if (input != useradmin) {sendmail...} Is there a way to do such a script? I didn't find a pregiven function for that.. Thank you very much!
How Can I create an order form to accept multiple Items, the invoice example does not allow multiple item entries.
I am creating an inventory tracking and order form. The place order form is a stateless form that updates my order form table and orders table. I am trying to create a form that an associate can enter their name and shipping information and order multiple items. The shipping info will update the order form (form) and the items will update the Orders table (form). Also, I need to create a keyed OrderID auto number to tie the order form and orders table together. Is this possible with ZOHO creator,
Embeded Form - Log Out Functionality
I've embedded my form into web site and require log-in credentials to access the form. Is there any way to program a logout button to allow the form to close gracefully and require a user to re-enter credentials to access the form again?
Form to Form Update - Fetch Records
I have created two forms and have linked the two with the lookup field. I now need to pull records from "Form A" into "Form B" based on user input form "Form B". I attempted to use the Fetch Record code below from the instructions in the Developers Guide but I keep getting errors. CodeLookup ( displayname = "Code Lookup" type = picklist values = Property_Agent_Detail.Code2 sortorder = ascending tooltip = "Please Select Code" on user input
No. of Days Calculation
Can anyone assist with this Using formula field to calculate Number of Days between two dates gives errors if result is > 27 days eg 15-Mar-2010 - 16-Feb-2010 gives 27.95833333 Formula ((FinishDate - StartDate) / (1000 * 60 * 60 * 24)) Thanks
We are unable to fetch this data, sorry! Error.
A new view 'Prior Year Customers' is producing the following error..... We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com Zoho support has full access to my app 'bp-com'. Thanks for your help with resolving this.
How do i create a searchable member directory for my website?
Hi, I am trying to create an application which would enable visitors to the site to be able to find other members with relevant research interests i.e. so they can search by name or research keyword similar to this: http://www.cardiff.ac.uk/news/mediacentre/directoryofexpertise/index.html I have added the excel sheet to to zoho but this seems only to allow users to ad their entry, not to search. Any guidance for this zoho newbie would be much appreciated. many thanks, Angela.
Trying to rename my form and it keeps going back to the original name.
Help.
rename new form from "Copy of..." old form
I copied a previous form as a basis for a new application. I am trying to change the name of the new form from "Copy of....(old form)" to one with a new name. No luck. The view header on the new form still reads "Copy of...."
print veiw
I use creator to track work orders. I would like to have a quick printable veiw to print out each workorder to give to employees. Can this be done ... if so how ?
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
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
Next Page