String Operations
Does any one know how to search for a string within another string? Here is the string I am looking for: temp_string="def" Here is the string I want to look within (notice it is comma-separated) temp_comma_list="abc,def,ghi,jkl" thank you
Can Zoho creator data be integrated with Infusionsoft?
Does anyone know if zoho can be integrated with Infusionsoft? I would like my zoho data to be passed into infusionsoft when forms are submitted. Is this possible? Their website is: http://www.infusionsoft.com/ Thanks
All Times are in COST??
What means "All Times are in COST"?
Grid view hangs when saving
I just created a Grid View to make it easier for one of the people on my team to edit records directly into the grid, table view. However, we found that it hangs when pressing the Save button. It doesn't appear that records get saved. Any suggestions?
15-character limit in calendar view
Per title and attachment: why is this in place? Is there a way to change it? An ideal solution would be a flexible character limit: truncate the string with ellipses (...) when the text is too wide. A more than adequate solution would be to simply have no character limit, and let the string wrap. If these are not feasible, changing the character limit would be much better than the current situation. Sorry if this has been reported before.
first question of many: linking forms
"I am not a programmer" Nevertheless, I'm trying to replicate the functionality of a fairly large and complex database that I, the nonprogrammer, somehow managed to build in Access, despite complete ignorance of SQL and VisualBasic. Ok, so, first question: is there any way (or is there planned to be a way) to link between two forms using a field type OTHER than single select/multiple select? I am trying to link (to use one example) the "authorname" field in my "manuscript submission" form to the
jquery help regarding grayscale(this);!!
Hi, I'm still new to Jquery, and I found a similar code that I was looking for which lets images go grayscale when hovered. What I am looking for is the other way round, so the image is grayscale, but turns color back when hovered. I know I can do this by rewriting this code: $(document).ready(function(){ $('div.tabsFeaturedImage img').hover(function(){ grayscale(this); }, function(){ grayscale.reset(this); }) }); but not sure how! Can anyone help me? Thanks a bunch.
Form Linking (again!)
Hi, I've just discovered ZOHO and have started playing around with deluge scripting which is fantastic for a non-programmer like me but, here's my problem: I have 3 forms A,B and C each with a CustomerID. Form A contains the address, B preferences and C past orders. How do I link A, B and C automatically so that when I navigate from one the correct linked data is shown in the other? Thanks for your help. Kavin.
Recently my viewers are being asked to login?
I maintain a website for my old school and a couple of areas use Creator. The forms i set up are working fine and the views I set up for people to see the data worked fine for about three years. A few months ago the pages started asking viewers to login. I have never set a password to view content and indeed dont want one as it is a publicly viewable website. I set up the databases a long time ago with the idea that they would become largly self maintaining and have long since forgotten how I
How to receive an Email Alert in 60 seconds or less?
Hi, I have an email alert set up that executes when a particular service fails. It looks like the email is sent roughly 5 minutes after the service is stopped (manual test). I don't see how to configure the email to be sent right after the alarm is set. I would like the email to come in 60 seconds and not 5 minutes. Does anybody know how to configure this? Thanks.
password ***************
Could you add a checkbox to determine if the charachters are shown or not. richardson.christopher
Iphone will not display creator form properly
My Zoho creator application will not display on my iphone or ipad properly. The form looks as the image attached. It seems to do it to all of my forms with two columns. Is this not supported on iphones, etc? Works fine on my blackberry and computer. I have also tried accessing it using using mobile.zoho.com/.. in this case there is no columns and the field name is above the field and right justified. Very confusing. What is going on? How can i fix this?
Fancy Formatting in Sendmail
I want to set the background color for some text in an email so that it looks like this. I tried to set a variable to = <font style="BACKGROUND-COLOR: #ff0000" color="#ffff66"> but it does not handle the quote mark " or the pound sign #. Any suggestion? Herb Wexler
Jquery help!!!
Hello I am new to Jquery and javascript I have tried dozens of coinsliders and none of them have worked. I am using local host and using the jquery hosted file from Google. I am going crazy because I was hoping to have a slideshow and Jquery validator a couple weeks ago and have gotten now where. I want to know that the proper way to use it is. I don't know what to do some one please help, i have tried everything w3schools youtube vids and still nothing. I don't know what category this should go
Issues with Sharing as Developer
I have tried to share to an application to another of my accounts so that it has developer permission, but it is not working. I have also had a client share an application to me with developer permissions, but it is not working. Any suggestions, or something I am missing? Thanks!
Date/Time Questions
I have a form that I would like to have one date/time field and two drop down menus one for hours and one for minute. When someone selects the date time they want and selects the duration I would to have a box on the view page that shows the ending date and time for that event, but it has to be in the same date time format because I want to use it in the ical feed
Is there a place to post creator jobs?
Is there a place where i can post a job that I am willing to pay for? I need some help finishing my program and am willing to pay just to get it done. I would have thought it would be in the developer section but i cant find anything. Where could i post the job requirements to find someone here on zoho? I have already posted my job with vworker.com http://www.vworker.com/RentACoder/misc/BidRequests/ShowBidRequest.asp?lngBidRequestId=1510904 but it doesn't look like a lot of people there use zoho
multiple conditions on "if" request
I want customers to be able to enter a field to identify them on my web site with the application embedded, but I cannot use the "or" function (see below). It is accepted, but will not work. if ((input.Buyer_ID != 12346) || (input.Buyer_ID != 12345)) { alert "If you are not registered, you cannot bid. Please go to www.xxx.co.uk to register"; cancel submit; } Can you advise please how I can do this? Kind regards dp
Deleted database by mistake ;-< Please help restore
The data in Final Meaningful Use Method form "Objectives2" was deleted by mistake. I urgently need to restore it. Please Help! I did a backup yesterday. Thanks,
"Duplicate entry '' for key 2" but form is allowed duplicate entries.
While entering data into my product form which is linked with look up fields to other forms, i am getting an error "Duplicate entry '' for key 2" I have checked if the fields are set to reject duplicate entries which they are not and I am still getting this error. Originally they were set this way as this is what i want. However i changed it thinking it would fix the problem, it has not. Also in looking at the fields, there are no duplicate entries. I don't know but maybe this could be related
Cannot access scripting [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Cannot access action on user input or any other scripting. I get the following error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' Please help, what can i do? I also noticed that i have a view that i cannot access. I get the same error when i try to access it to delete it. I think its a view that goes to a field that no longer exists. It is the Publisher view. You will see there are two Publisher views. Its the one that is hidden. This is in my Art Inventory Management 2.0 program.
WHat is the best way to do this?
I am working on essentially an inventory control application. But we actually manufacture all of the items. When the plant finishes building an item they need to input it into the data base. The plant manufactures many of the same items over and over again. We wanted to have a data base of items that the plant manufactures and this way when they finish a product it is much easier, all they need to do is tie a serial number to the new item (record). Problem is, with thousands of items how can i
Export XML
Hi there, Is it possible (or can it be made possible) to get a full XML export of the contents of a view? The existing RSS export option only contains 25 entries, so it's OK for tracking changes to data, but not for real analysis. I'd like to get the whole view as XML, in the same way that I can get it as CSV / JSON / etc. best wishes, Mo ffg
jquery and online form conflict
Hi there, I'm using jquery-1.3.2.js for my gallery on my portfolio page. I insert an online form as well. It works fine in terms of sending emails, but when I try to type anything into any input type fields in my forms it doesn't display space between words. When I disable jquery script it works just fine so I presume the problem is with jquery. I spent ages trying to find the solution online, but no luck. I would appreciate any advice. Cheers, Kashka infinitadesign.net
Bug with URL Functionality Based Login
I'm making an observation I posted here into a bug report: http://help.zoho.com/portal/en/community/topic/registered-user-subclass Using functionality based urls (Ref: http://help.creator.zoho.com/Functionality-based-URLs.html), the ZOHO sign-in page no longer has a link to "sign-up for free". The user is forced to perform a federated sign-in or leave the application.
Multi-Select for a Transaction Form
Form A Product Price apples 5.00 oranges 6.00 bananas 7.00 etc........ Form B is a transaction with a multi-select (apples,oranges,bananas,etc.) Deluge Script help If a customer were to buy more than one fruit, how could i get the total price of multiple fruit. ex. apples and oranges were purchased, the answer would be $11.00 Thanks for any help.
One or more fields were dynamically changed
I am getting the following error message: "One or more fields were dynamically changed Try clicking resubmit" What does it mean and how can i eliminate it? It does not happen on all occasions and i cannot figure out why it is happening. I have essentially copied the Site Inventory application from market place into my application. My application is Art Inventory Management 2.0 and the problem is under Consignment Locations -> Consignment Location Edit access to support has been turned on.
Backup for Creator Database Fails
I am trying to backup one of our databases, and I consistently get the message that the backup fails. No reason is given. Any suggestions?
Problems with Back-up
I have problems with back-up process. It started but it nevers ends. Is any log to see which form, view or script is blocking the back-up process? Any solution? Thanks Sergio Galiano
Update in Creator
Hi everybody, I read the support and it is explain that we can't do a big update while importing data in Z Creator. That's what I want to do : I upload my CSV file and I'd like Z Creator to update old entries (using an ID column for exemple) and add new entries at the same time. My CSV files will be between some to thousands of entries I'd like to know if somebody found a solution. If not, I'd like to know if it is possible for Z Sheet to communicate with Z Creator in order to do my updates in Z
delete project
how to delete project ? thx
Data Dictionary Again
3 or 4 times I have encountered these data dictionary errors while working on various apps. Once they occur you can't continue. They seem to clear themselves up after some time. I have asked about what causes them and have never received an explanation. It would be nice to understand if it is something I am doing so I can avoid it, and if there is anything I can do about it. Nothing I do seems to get past it once they occur. 1 . [t_591877000000035043] Exception occured while setting value in PreparedStatement
Look Up not working with drop down (single select)
I am trying to create a relationship using the instructions given here: https://help.creator.zoho.com/Creating-relationship.html I am trying to import a field that contains a list of locations. When I add a LookUp field to the form none of the fields in my other form are displayed (they are all drop down single select). Just to check, I tried using LookUp to create a relationship with another form, the only fields that displayed as an option to import were the single line fields. Why aren't the drop-down
New Currency Types added
Dear Users, We have updated http://precreator.zoho.com with the below mentioned new features : New option to show/hide "Sign up for Free" link from the login box in application live mode. This enhancement is provided(for paid users) under the Application Settings screen. The following currency types are added: ANG - Netherlands Antilles Guilder GHS - Ghanaian Cedi (new) HNL - Honduran Lempira MMK - Myanmar (Burma) Kyat PAB - Panamanian Balboa XPF - CFP Franc (Pacific Financial Community)
Search interface HTML view does not work when embedded in external site
Hi, I recently created a search interface for my view following Latha's article here (https://kbase.creator.zoho.com/forms/search-interface) and this allowed me to create multiple search criteria/filters which is great. However, when I embed this HTML view in an external site, the search interface does not work. I am embedding this view in an external site to allow me to create a really custom header for the application. My questions are: Is it possible to get the search interface to work when embedded
Exception occured while setting value in PreparedStatement for the Column !...
I am getting the following erro and cannot submit my form in Submitted Grant Applications 1 . [t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified in the data-dictionary .[t_539276000000011043] Exception occured while setting value in PreparedStatement for the Column [Invoice_da_539276000000477911] Check whether the datatype for this column is given as specified
How to pad a string with spaces
Hi Everyone, I have an application that will export records to MYOB accounting, and am trying to set up one field properly. The field will be a concatenation of four other fields. The entire length of the feild must be 255 characters long and have the following attributes: strPO + varCellPadding + cboClient + cboMethod + cboLanguage The trick is that varCellPadding is a variable: varCellPadding = 255 - (strPO + cboClient + cboMethod + cboLanguage) Getting this value is easy, but how do I actually
Was this defect not corrected last year ???
Last year I reported the problem with the on User Input sections NOT being triggered BEFORE the on Click (or on Success) sections for Date fields when the user ... a) changed the values via keyboard (instead of using the Calendar Widget) b) followed it up with a click of the Form Button As I recall ... after a number of interim measures, this issues was reported as fixed. I also recall verifying it at the time. Today, one of my clients reported a problem ... which after considerable investigation
Email notification from field value change?
I have a hidden picklist on my form named “status” that has three options {"Pending", "Approved", "Denied"} and I would like to have different email notification going out to the person who submitted the form when this status is changed. Is this possible? And where can I find some sample code for this? Currently the from generates an email on form submit and the status field is set to pending (hidden field),but I would like it to generate emails when the status changes to approve or denied with
Rich Text Editor - Limited functionality
I had been looking forward to The Rich Text Editor functionality and it will make my Zoho Creator experience that much more satisfying. But the functionality seems limited, at least, for now. As Niskypto has mentioned here, 'on user input' commands do not work for the RTE fields. But the problem seems to be wider than that. I couldn't update an RTE field through an "on-load" command; and the RTE field cannot be updated on input of other fields either. So I get the impression the current version of
Next Page