Zoho database and Visual Basic
Dear all, I'm a new user and I need to know if is possible the connection on my DB (created using zoho creator) whit Visual Basic because I need to run an applicaton (made whit VB) to update this database Does a connection string exist? Best Regards
Configuring Date field
I have a date field in one of my registration forms. However, the current format is "dd.MM.yy" and I would like to change this to "dd/mmm/yy" like it is in one of my other forms. I looked to http://help.creator.zoho.com/Configuring-a-date-field.html for help, but the date format option is not available in my application settings for some reason... What else can I do?
Another Field dropped from the Application Settings Form
ZOHO Creator Support: In addition to the missing Date Configuration field on the Application Settings Form ... documented here ... http://help.zoho.com/portal/en/community/?ftid=2266000000681910 ... I believe the field related to the assignment of a Developer (i.e. Provide edit permission to:) is also missing from this form. Please investigate and advise ... I can not assist a client until this is fixed. Gaev
How to create a relation 1-200+?
Hi I have one form where I can enter stakeholders. For each stakeholder, I would like to select his requirements. Around 20 requirements per stakeholder. These requirements are stored in a table, about 200-300 requirements. How can I create a from where I can "add" requirements in a nice way? If I do it like here http://zohocreator.wiki.zoho.com/Creating-relationship.html I have either 20 very long dropdowns or 200-300 checkboxes. Both not very userfriendly. I would prefere something like a dropdown
Hiding a field when embedding a Form in a webpage
Hi - I have a form that includes 4 fields. I only want 3 of these fields to appear when I embed the Form in a website for customers to input the initial data. Is there a way to hide these fields when embedding them in a webpage? I would still want the ability to add data to these fields when I access the application myself later. For example, my Form includes Name, Address, Phone, and Category. Name, Address and Phone would be embedded in a webpage for customers to input. However, I do not
Interfacing ZC with outside server
Not sure if this is for the API forum or Creator so I'll start here :) Would love advice on how to take my application to the "next level". Currently we are using ZC to manage our video assets that are living on an outside server (Ubuntu server). We have certain meta information including title, fileName , and other info on our ZC app. The ZC interface is very slick and we love the potential and now would like to do more. On the outside server we are doing two primary tasks: encoding and ftp transfer
Do Zoho creator free version has export to CSV
Do Zoho creator free version has export to CSV facility ? If it has , how do i do that ?
CREATION A DROPDOWN LIST LINKED
I WOULD LIKE TO CREATE 3 DROP DOWN LISTS LINKED CLICKING ON THE FIRST DROPDOWN LIST WILL DETERMINE REACTIONS OF THE 2 OTHERS
How do I use a Variables to Call a Function?
Hello. I'm working on a Zoho App where I will be using many functions for determine eligibility for client membership and each function's name will be assigned to a specific Criteria form. The Criteria form will have a String or Text field named "Function Name". I'm hoping to call the function name on a separate Form named "Screening" where if the Criteria Type is equal to "Function" and the "Function Name" is present, it will use that particular function assigned variable to call the specific function
Issue with EDIT record
In my apps, only the admin can edit a record with that kind of link : https://creator.zoho.com/<adminuser>/<appname>/<formname>/record-edit/<viewname>/290930000006308125 The view and form are shared with users. Any tips ? Thanks, Pascal
Stateless Forms
There three distinct types of buttons: Submit, Reset and Custom buttons in Stateless forms. So Could you tell me what is different about the 'Submit' and 'Custom buttons'?
Limiting the Amount of Text Displayed in a List View
Hi. I have a table displayed in a list view which has a couple of multiline fields. Because these can be up to 65k characters, they can grow quite large and make a compact display impossible: Is there any way, for display purposes only, that I can limit the amount of text, while not disrupting the actual underlying data? Thanks very much! matt
Passing key fields to other forms as a global variable
I just started with Zoho Creater this morning - it seems like fantastic scalable application !!. !I am having problems with creating a common key field called DEAL_ID and using this to pass to other Forms as the key field. I have tried various ways such as using a script on the form called New_Deal DEAL_ID4 = input.ID + "_" + input.Deal_Name; share form("application", DEAL_ID4); But this does not seem to pass the DEAL_ID4 variable to any other Forms in my application ? Would appreciate any answers
Powered by ZOHO Logo
Today, I now have the 10 user plan, but all my embedded forms still have the "powered by" logo. I read a few other posts here about this issue and tried to clear the browser cache, rename labels, rename forms, etc..but the logo is still there. It's not a big issue since I enjoy helping spread ZOHO awareness, but I'm curious just the same.
Background color of Zoho Creator forms
When embedding a Zoho Creator form in another webpage, it has an ugly, gray background in IE7. I believe this is because the body's background color is not set to transparent in the form, and when you embed it as an iframe in IE7, there is no way to change the background color so it is always gray. Could the form body's background color be set to transparent, or at least white, so that it looks decent when embedded in another webpage and viewed in IE7? Thanks! razorwit
Infinite loop when using replace function
I have tried multiple ways to get zoho to stop replacing text when the first replacement is done, but cannot get it to work. The code I have right now in the on user input section of the Reference Name 1 field is: refName=input.Reference_Name_1; if (input.Reference_Name_1.contains(" ")) { refNameReplace=(refName).replaceFirst(" ","%20"); input.Reference_Name_1=refNameReplace; } else { }but it does not seem to stop the loop. Can anyone spot the error in this code that is not stopping the function?
Glitches all day in addition to slow access
In addition to getting complaints all day about slow access to our Zoho Creator application, I am receiving multiple reports from people who are having trouble accessing data. For awhile one of my users received the message "We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com" although nothing had changed with his access or our application. Now when another user is trying to submit an item into our database, he is receiving the
need workaround/fix for extremely slow access
Hi friends, Is anyone else experiencing extremely slow creator access time? It is taking 30-40 seconds to access my home page or applications, the slowest ever, and i'm timing out on about 25%. Forums and help pages working fine, just creator apps slow. I cleared cache and rebooted, but it's not better. We are at the point where it is too slow to work! :(. Any ideas of what I can do? Dax
Backup failed
ZC Team,I tried today to make a backup for two applications from my account, and the backup failed. In both cases the following message was displayed: java.sql.SQLException: org.jboss.util.NestedSQLException: Interrupted while requesting permit! Waited 0 ms; - nested throwable: (javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms) Regards, George
Creater & Zoho CRM API Help
Very new at this.... I've constructed a url using the Zoho CRM API that posts a lead and this works perfectly in my browser - inserts the contents into the leads section. How do I translate this to a Creator form. I want the submitted form to be sent to the CRM and I've been messing around with maps and variables and posturl and the best I've got is nowhere. Could someone point me to a simple deluge script that will do this. Thanks for any help, Jon
Added User Profile Picture!
Added User profile picture can be added to the creator views column properties premade label names, as on Added User label! this will make easier for user identification.. just a suggestion..
Lookup Function On Creator
I added a lookup field on form B which references a single line field in form A. However when I am on B View Mode. The data does link automatically to form A database. I've been using Zoho CRM for years now and I love this functionality where I can map field dependencies across application within the CRM. For example, you can do a look up of contacts even if you are under the Invoice module. Is there a way to do this in creator? Eugene
How to show records count in a report ?
Hello, I use Zoho Creator to manage my comic books (it was done on MS Access before...). I've around 400 books and I like to have a list ready when I go to the shop or browse internet to buy new ones. Each book is noted with its Title and is a collection/'serie' member (mainly/most of the time is collection is the hero's name). I have so How could I print the record count : a - by collection at the bottom of each collection ? For exemple : I have the comic book "There is treasure everywhere" ; this
How to print a list without record break between pages ?
Good morning, I have a list of client with a lot of details in it. In order to bring this list on the road with me I've done a dedicated view I called it contacts. This includes only name , complete address and telephone.When I print this contacts list , I got the record at the bottom record of the page wich is broken, continuing on next page. How to avoid this ? How to insert an intelligent page break and having only full records per page, even if this creates more pages ? Regards
Freeze/Fix the Column Headings in VIEWS & Relocate/Move Columns in views by End User
Hello, Is there a Creator feature that allows the column titles/names to be locked/fixed and not disappear when scrolling down the View? - Excel has a "Freeze" feature. Also, I know that columns can be Hidden/Shown but can they be repositioned on the View by the end user? Thank you. George YourBizzWizz
Retrieving data of mails sent above usage limit
Hi Zoho, I have an application that sent more than 1500 mails today. Just before my application started I realised that this was going to happen and I increased the number of mails to be sent daily to 2000. However, I think this was not established in the application itself I believe. I now try to retrieve the not sent e-mails from within the https://creator.zoho.com/showTaskLimitLog.do page. I select today (20 nov 09), but then nothing happens or shows up. Could you please help me to indicate
Send email to an address, filled out by the user of the form
Hello. I'm fairly new to the Zoho Creator, mainly to the scripting part of it. I have a task of creating a registration form that would send an email to the person, that is filling out the form. The email address would be provided by the person itself while filling out the "email" field. The email message should contain all the filled-out data. This is meant for the users conformation, so he/she could verify the entered data is correct and also for his/her safe keeping, so there is a local backup
Import Data to update a field(s)
I'm a former user of one of the competition (Dabbledb) and congratulations to zoho as this is much more robust platform. I think once we solve many of the bugs (I have a number of issues into tech support) i'll be a very happy guy... One very basic thing I miss that was so easy before was importing records in order to update a field with a match. So if I have a db with three fields ID,name, address i'd like to "import 50 names and update "address" if "ID" is a match. Can someone advise how to
Importing data - linefeed issues
The data I want to import has lots or linefeeds in the data, but Creator incorrectly interprets these as end of lines. The linefeeds are used by Excel in multiline cells, ideally I needs some method to map these to multiline cells in Creator. Any ideas?
iFrame or embedded views with link to pop-up dialog
Hi, I'm a bit stumped. I think it's because I don't fully understand the different URL formats, I'm afraid... I have an HTML view, and it contains a link to pop up a dialog: <a href="https://creator.zoho.com/katieboyle598/testing/#View:ProjectSummary?zc_LoadIn=dialog">Link</a> That works fine. But then i put an iFrame into the HTML view, and put a copy of the same link into the source view for the iFrame. When I click on this link, the dialog still pops up correctly. However, the iFrame in the
How to generate reports using search interface in Zoho Creator?
Hi, I am creating a patient record database for a small doctor's clinic in Zoho Creator. I have two forms: 1) Patient Info with information like Name, Address, Telephone Number; and 2) Visits with information like Name, Date of visit, Illness that day, Treatment prescribed. Each patient has one record in the "Patient Info" form, and one or more records in the "Visits" form. This is my question: I would like to create a report for each patient with their information and a summary of each visit.
Can anyone help with a workaround for format masking phone numbers, serial numbers, etc.
Can anyone help me? This seems like a stupid problem but I'm stumped. Our accounting has to have SS numbers formatted with hyphens, but our users do not always enter them. Since creator currently has no input masking functionality (to correct format in user-entered phone numbers, serial numbers, etc), I need a work around. I've got no problem stripping out hyphens, dots, spaces, etc. to create a clean unpunctuated number, but I just can't figure out how to get the hypnens put in the correct places!
Return statement
When presented with this error message: Encountered "exit ;" at line 22, column 13. Was expecting one of: "if" ... "for" ... "delete" ... "insert" ... "inserthtml" ... "share" ... "unshare" ... "%>" ... "input" ... "." ... "=" ... ":" ... "hide" ... "show" ... "clear" ... "enable" ... "disable" ... "select" ... "set" ... "info" ... "alert" ... "success message" ... "sendmail" ... "cancel" ... "return" ... "(" ... I was wondering what return does. Anyone? Leo
Data Validation
Is there a way that I can write a data validation function, like a phone validation function using deluge scripting? I cannot find a function that determines if a value is a number or any sort of string parsing. Thank you jlinfamily
stateless forms - how to close the window once data is entered?
Hi, I am trying to use a stateless form to populate another database on creator. When a customer enters the data and clicks the submit button, the data is stored in the database. In order to avoid the customer submitting the data over and over again, I want to close the windown and I have the following code: openUrl("http://creator.zoho.com/alhudaonlinecourses/alhuda-student-data/#Script:page.parent.close","same window"); But the window doesnt close, nothing happens. Please help Thansk
Stuck in a loop (I wish)
Hi all, apologies for the pun. I have stateless form with a button that generates new appointment slots in another table. User enters a date, and a start time and end time, and date, length of appointments (X minutes) and presses Generate. I want the routine to start with the start time and keep creating appointments in the other table X minutes apart until the appointment time equals stop time. For each loop, it needs to create a record in other table with the appointment time (last appointment
There is security hole in such URL http://creator.zoho.com/kunjichen/test1/#Form:test4?recLinkID=216507000000428104&viewLinkName=test4view_added_by_me
This kind of URL is very useful for me. However there are security hole in it: http://creator.zoho.com/kunjichen/test1/#Form:test4?recLinkID=216507000000428104&viewLinkName=test4view_added_by_me Th filter of View "test4view_added_by_me" is: Added_User == zoho.loginuser Currently there are two rows in View "test4 view". One is added by user "kunjichen", the other is added by user "chenkunji". See below: http://creator.zoho.com/kunjichen/test1/#View:test4_view name Added_User ID b chenkunji
Is it possible to calculate duration taking into account working days & hours in Zoho Creator?
Does anybody know is it possible to calculate duration taking into account working days and hours in Zoho Creator? http://webappsatwork.blogspot.com/2009/09/i-want-to-calculate-working-time-good.html If anyone can set up an app for me that can calculate this I'd really appreciate your help! Jane McCarty http://webappsatwork.blogspot.com
Create Working "Print this Record" button?
I'm new to Zoho Creator and new to scripting so I'm looking for help with getting simple code snippets to function. I'm trying to add a "Print this Record" button to a list view. I've figured out that once I have created the function, I can call the function from a button using the "Custom Actions" edit screen. I've figured out that I can format the printout the way I need by creating a special view which I call "One per page". I've figured out that I can get exactly the result I need by entering
Is there a way to reprint one database record in a configurable format?
The records in my database (https://creator.zoho.com/lauriemetz/apr-database) contain around 50 fields that I need to print out in a pre-specified format. I can recreate this format in a word document or spreadsheet, but don't know how to populate those fields with a selected record from the database. Even if I could just print out the form that I created to enter the data, that would work, but whenever I access the application and select a record to view, it shows up in a single column format.
Next Page