Migration error message - How
I'm trying to use the Migration tool to populate a table with XLS spreadsheet data. I've got a Windows 7 64-bit computer, so I get this error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." On researching, I see that Jet won't operate in 64-bit. I read that, "The solution is to configure the application pool and enable 32-bit application support." Is this a setting somewhere on my computer or is the application pool on the server? Please help....
Set last entry date as default date
How do I set the last entry date to be the default value of the date? E.g. If I key in the first entry, the date is 1st May, then for the second entry, I want to default value of the date to be 1st May too.
Sharing new views automatically
Hi Zoho, I have an application and regularly have the need to add new views. I find that every time I add new views, I have to re-share the application to all of the users so that they can see them. Is there any way this can happen automatically? Thanks, Kim
Is there any way to add more than one filter to a table?
I have a large table of organizations, and I need to make it easy for others to browse it as a database--they need to be able to narrow it down into various groups and subgroups. The problem is that you can only filter for one category at a time. For example, let's say I have three columns in my table: (1) "Organization Name," (2) "Type" (e.g., non-profit, government agency, or school), (3) "State(s) of Operation" (e.g., Texas, Massachusetts, etc). If I want to see a list of all non-profits on
Excel 's Data Problem
Dear all , i managed to export to excel my data , but all fields are considered as "General" , is there any way to have it with the same format? eg.. sale "Number" , when exporting it shows "General" in excel. thank you :)
Sorry, but brain is dead need help with alerts
I hope i placed in the correct sub forum. Its been a little while since i had to update my form and having some issues. I have it set up for a 'coordinates' field, with the format as ###|### (#=number). I have an alert to pop up if they input the coordinates wrong. I am also trying to have an alert pop up if the new coordinates are already entered. I do have it checking for dup's and will give an error like: 'invalid entry for key2' ... What i would like is for it to compare to DB and if already
[t_741848000000027025_PIDX] Exception occured while inserting rows Failed to update data
I have a form with a list view. When the data is entered via the list view edit form, I get the Exception error above whenever the dropdown fields need to be edited. Please help
Why won't this script lookup wildcard matches?
I'm looking up two fields here, Case_Name and Adverse_Party to see if there is any wildcard match in the database. Adverse_Party works fine in this script but Case_Name only shows a match on the current entry and never matches any historic data even though I know there should be matches. What's going wrong? cnt=count(Case_Management_Form[(Case_Name.contains(input.Case_Name) || (Adverse_Party.contains(input.Adverse_Party) && Case_Code != input.Case_Code))]); if((cnt > 0)) { records = Case_Management_Form[Case_Name.contains(input.Case_Name)];
Invalid XML - while exporting data as RSS
Hello, I am using zoho creator to gather data and used it in my iPhone application by exporting it as RSS (xml feed). In last few days I have updated some of the data and try to use it as xml feed. But now I am facing an issue with exported XML while parsing it. It gives me an error like invalid XML. I am using W3C validator to check XML. I have attached XML feed data with this post for ref.
How to allow user to see all records in one table that match criteria in another table?
I have 2 tables: customer and appointment. I can search the customer view to find the customer record I want. I have a Lookup in Appointment to Customer, so that when you create a new appointment, you choose the customer. But, how do I then click on something to see *all* past appointment records for this customer? I can imagine a button in each row of the Customer table where I could click "See Appointments" and it would bring up the Appointments page, but of course, only showing the records
Error defining picklist
Hi, I'm getting an error trying to define a picklist...code is below: must have Office ( type = text width = 200px on user input { if (count(Order_form[Office_Name == input.Office && Received_Impressions && Sent_to_HK == false]) == 0) { clear Order_List; } else { for each y in Order_form [((Office_Name == input.Office && Received_Impressions) && Sent_to_HK ==
email adresses
Hi, I have a form and I want it to be completed by my players in an online RPG so they can submit their orders online. I have an email account where the submitted form should go to but I would also like the following if possible. 1. For them to be able to preview the orders before sending, ie confirmation of what they have put in. 2. For them to get a copy as confirmation it has been sent. Is this all possible? regards
Reply To : Address Problem
When i insert a reply to email address in my sendmail on success script, the reply to address that actually gets used is different... instead of "@gmail.com the mail contains "@xn--gmil-mg0l.com" Anyone know how to fix this???
Can you left align a number field in a view
Text fields are left aligned and number fields are right aligned in views. Is there a way to left align a number column?
Anyone have a step by step with regard to zoho creator and google calander?
A sample app maybe? I cant get it to work?
Lookup field is not populated in "Edit" mode
Hi, I've got an application that was working fine until a couple of weeks ago, but is now not working I'm afraid. I have a form called "Games". The only field in this form is "GameDate". This is a date field. I have another form called "Results". This has a lookup field called "Game", which references the "GameDate" field of the "Games" form. When I look at the view for the "Results" form, I can see that the reference to "GameDate" is working fine. When I *View* one of the records, the "GameDate"
Online Survey
Hi, First of all I want to say that Zoho is light years away from any Google and Microsoft online services. Zoho rules! I want to make an online survey, but Zoho has so many services that I don't know which is the best. I'm between Zoho Creator and Zoho Challenge. I need to create a permanent survey, that anyone in the web can reply. Public. The person will input data such as name, phone number, and others (personal data, so I'm the only one that can see the results). Also need radio box, multiple
Report PDF Exports do not match User Filter criteria
When I enter criteria in a user filter on a Report, such as a date range, and then go to Export to PDF, the export includes everything from the database and not just the data within the date range I had specified. Please let me know if I am doing anything wrong if there's any way I can help you recreate this issue. Thanks, Jennifer
Auto-populate fields based on Login
Hi Zoho, I have a form that I am using for our team members to log issues related to various publications. There are certain fields that they have to enter over and over again that are the same, depending which project they are working on. Is there any way that I can have the form automatically set default vallues depending on the login. For example, If loginid = xyz then Course = "Level 1" Reporter = "Jane Doe" else if loginid = abc then Course = "Level 2" Reporter = "John Smith" end if Is there
changing existing form to another
hi, I want to know how to change an existing form to the timesheet form thank you
Browser Connection Setting NOT honoured in Chrome and Internet Explorer Browsers
On this page ... accounts.zoho.com/u/h#setting/preference ...my Browser Connection: setting is UNCHECKED. When I sign in using Firefox ... my Home Page and the Home pages of my Applications are all accessed using http. But when I sign in using Chrome (v11.0.696.71) or Internet Explorer (v8.0.6001.18702)... making sure that Use Secure Access is UNCHECKED ... my Home Page and the Home pages of my Applications are all accessed using https. Gaev
ZCreator with Google Apps sharing ONLY with Google Apps users
I'm an administrator of a small Google Apps.I've installed ZCreator in my Google Apps, because I want to share ONE of my application with Google Apps users. Other applications I'd like to share with users outside the Google Apps, but now I'm not able to do it. It can't be true, can it? :)
How do I create a function in "On User input" action?
I am not really familiar with scripting languges, so I need an advice on syntax of functions definition. I understand how to create functions in "Functions" section. But I want to use "hide" and "show" keywords inside a function. As I understood I can not use it in scripts from "Functions" section, only in "On User input" action or so. Thanks in advance!
The Alert Box...
How do I do a new line in the alert box? Tried <br> as a guess, but didn't work. Also, how can I do a "for each" in an alert box? I want to list 2 fields from records. Right now, it lists all the info I want, but it does <field1><field1><field2><field2> I'd rather have this: <field1><field2> <field1><field2> Hope I explained that correctly. Thanks in advance!
Nested dropdowns?
I'm trying to create multiple nested dropdowns for use in an attribute agreement analysis, but cannot seem to get this to work beyond the 2nd column. I have a source sheet (Sheet2) that has 5 columns of data - each connected to the next. I need to be able to create 5 dropdowns in Sheet1 that populate left to right based on the prior selection. The idea is that I want people to evaluate the test cases in Sheet1, and get the right options populated in the dropdowns from Sheet2. I imported the workbook
Filter results in a lookup multiselect field according to a lookup dropdown menu
Hello, I have two databases: one concerning centres, and another concerning students registered at theses centers. I would like to filter the results in the lookup multiselect field (listing all the students), according to selecting previously the appropriate centre in the lookup dropdown menu. For instance: List of centres: AAAA, BBBB, CCCC Lista of students: Carlos (AAAA), Marisa (BBBB), Peter (BBBB), John (CCCC) So idea would be: if we chose "BBBB" in the lookup dropdown menu, then display only
Email Data into Zoho Creator
How long does it take for data to show up in a view when using the email data feature? I've sent 3 emails in, about 10 mins apart, and none of them have shown up. I'm using the same account (email address) that I used to create the application when I'm emailing in the data. Thanks.
All my zoho creator embed form down this morning?
Hi support, All my zoho creator embed form/ view down this morning, can't access at all... it seems just shut down. Kevin
MAC computers...cannot access Zoho creator...
- several users on MAC computers cannot access zoho creator .... they've tried Firefox and Safari browsers. Any advice?
SQL like queries.
Dear All, I have 2 forms with 2 views created on my Zoho creator. I am not using the ids generated by zoho, because the forms will use ID entered by the user (just because this a requirement from the place I work). So, I am trying to write a script that will do the following: while the user is entering data into form B, he will enter the ID from one item from form/view A. After the ID is entered, it will show the information from that item into the form B, and some fields from form B will be automatically
Sharing a linked COPY of an application (without using the Marketplace)
I've developed an application which I'd like to share with another company. Note that I DON'T mean simply inviting other individuals to contribute data to my application -- I mean creating a separate copy of the application's forms, views, scripting, data so that another company can use the app themselves. And if I make a change to the source code, I'd like the change to propagate to the other company. Is this type of arrangement possible? Can I do this using the Marketplace? Can I do it without
Create combined views with more than two related forms
In the help Page about views https://help.creator.zoho.com/Quick-Start-Guide.html#create%20combined%20view it's said : Create combined view You can create a combined view with two or more related forms. "or more" ... it looks like ZC is able to relate two forms and not more. Will zc be able in the future to create combined views with a 3rd (4th?) related form ? (I mean without having to write script in parent form)
Problem with Record(s) that cannot be edited and submitted! Please assist.
I have a record in a particular form that when edited cannot be submitted successfully. Here is an example: The view link is: https://creator.zoho.com/w21admin/w21data/#View:Contacts_All The record ID is: 340313000007715263 When you 'Edit' the record, the form pops up. But whether or not you change any data, when you do a Submit you get the following error: (it is impossible to resubmit this record) Please advise. If you find issues with this record, please scan all records in that form
Lookup field not retaining format
I have a form for products that includes a price field in currency format. I also have a transaction form that includes a lookup field for the product price field. How do I make the lookup field appear in currency format?
Dropdown ID
Hi! Let say, I have two forms: 1. Items (ID, Name) 2. PriceList (ID, ItemID, Price) In this variant if I make in PriceList a dropdown box with ItemID it will be very unconviniend, while very complicate to define item mane by item id. But this dropdown will be unique. Another variant is to put instead of ItemID an ItemName. It will be visible, but not correct for table connections (it must be made through ID) So, how to show in form PriceList dropdown with Item Names, but after choise save in PriceList
Easy way to auto-populate a field with last value entered
Hi Zoho, I have a project where team members are repeatedly entering the same values over and over again for a period of time (an hour or so), then values may change and they are entering those over and over for the next hour. Is there any type of short-cut key that will auto-populate a field with the value that you had previously entered into the same field on the previous record? That would save a lot of time. Thanks, Kim
PickList
I have a question regarding the picklist, I want to set a value from one particular picklist by url on a form, if I set the picklist from the wizard when I am creating the component, when I pass the parameter by url, the set is made correctly however if I populate that picklist from deluge script and I pass the parameter by url, the set is not done correctly, Why?????
Saving changed records in Grid View is *still* hanging and not saving changed records (intermittent, but frequent)
This problem was reported and acknowledged many months ago and still remains an ongoing problem: When in Grid view, if you change some records and click the "Save" link, the application hangs while displaying "Saving Records". The problem seems intermittent, but FREQUENT. After waiting a long time for the saving to complete and finally refreshing the browser, you see that NO CHANGED RECORDS WERE SAVED during the "saving" process. Could this be looked into please? Months ago you said it would
Return type for create tasks
The Zoho Tasks for creating records in CRM and Invoice has its response returned as String Variable. This String response contains the result of the Create Operation in XML Format as a series of inputs for various fields. Since it is XML as a String, you have to use the XPath expressions to access the field type that you need. Say for example, if you need to extract the First Name of the contact, then you should be using this XPath expression : contactinfo = { "Last Name" : input.Last_Name, "First
Update Html
How can i update data in a table in a HTML View everytime new data is entered in my form?
Next Page