How to apply lookup
Any one help me how to apply lookup like according to the STATE will be display CITY name in the form.
Strange sendmail command behaviour ... need workaround !!!
Hi: I have this code in the on Click section of a Stateless Form ... if (EmailTo == null) { //send only to admin sendmail ( To : zoho.adminuserid From : zoho.adminuserid Subject : EmailSubject Message : EmailMessage ) } else { //send to admin and provided email sendmail ( To : zoho.adminuserid, EmailTo From : zoho.adminuserid Subject : EmailSubject Message : EmailMessage ) }I am doing this so I can send the email to both the AppAdmin and the User ... but if there is no user email, I want to send
iPhone app behavior normal?
I am testing my app in an iPhone. I am using http://mobile.zoho.com/creator. The form loads but is very small and I need to expand it to see it everytime. Further, when I tap on a form to add a new record, it opens a new 'window' in the browser and I can't easily navigate back to the main page to select a different form to use or a view. Is this normal behavior? I hope not. Not user friendly at all. How can I change this? The app works better with this URL http://creator.zoho.com/mobile but
Is there a way I can set up a group email list using the records from my Creator database?
Hi, I am wondering if I can send a group email using the contacts in my Creator database. My email provider only lets me add each contact individually, so I can set up and email address group@mydomain.com.au but I would need to add each forwarder individually which would take me a year to set up. So I'm wondering of there is some other way I can email all my database at once, rather than copying the email addresses from my database and putting these into an email manually each time I want to email
Workflow integration with Zoho Creator
I need to build an application that combines an on-line database with workflow, so that workflow can control the timing and sequencing of information that is entered into the database. I also need to be able to generate emails in my workflow app which extracts information from Zoho and sends the results (in other words, I cannot generate the email from Zoho based on the "events" that are available to me). I have been working with RunMyProcess, and although that appears to do what I need from a
Share view/form but don't show it in menu
I would like to share a view or form without showing this view or form in the menu. Is that possible? I want the user to work from a view, and give only access to forms by using Custom Actions. Can this be done? thanks Henk
I DON'T WANT TO DELETE THE COMPLETE DATA FROM RECORD BUT JUST THE VALUE FROM LOOKUP FIELD
But doing this not helping me sole my problem .... actually i don't want to delete the data from second form database but from the lookup field i want to remove that value . for e.g . One form is there with name service challan anED THAT other is job status . In Ist form many fields are there where i enter all the details of the product n, type etc . one field is job no. whose value i have incremented automatically . now this job no. is used AS LOOKUP FIELD IN SECOND FORM . AND DATA RELATED
The year that was @ Zoho Creator..
2010 has been a memorable year for us. We announced new features, came up with enhancements to existing ones.. integrated some key Zoho Services with Zoho Creator.. wiped out bugs (well we did put in a few new ones.. but lets just forget them for the moment..) .. faced some harsh criticism.. smiled when praises came calling from unexpected quarters.. lost few old timers.. won some new fans...helped people migrate to our service when theirs shut shop.. reached memorable milestones .. and did a
Unable to save new colums
I just created a duplicate database to use for editing purposes. I have tried to add several new fields to it. However, they are not showing up in the application and under Views>Column properties, they are there and I check them but I am unable to save them. As soon as I check the boxes and click done, they uncheck themselves again and the page refreshes. Anyone have insight on how to fix this?
Data-dictionary problem
Hi, For the following form: https://creator.zoho.com/wwwapp/books4brains/#Form:Deliveries When trying to enter data I receive this error message. 1 . [t_466097000002994707] Exception occured while setting value in PreparedStatement for the Column [Counter_466097000002995476] Check whether the datatype for this column is given as specified in the data-dictionary .[t_466097000002994707] Exception occured while setting value in PreparedStatement for the Column [Counter_466097000002995476] Check whether
CONTACTID Retrievable from zoho.crm.create("contacts", contactinfo)
Hi all, I think I read somewhere that the CONTACTID for a CRM record is not immediately retrievable on creation of a CRM record within Creator...as per this example. contactinfo = { "Last Name" : input.Last_Name, "First Name" : input.First_Name, "Mobile" : input.Phone_Mobile, "Campaign Source" : "The Website", "Description" : input.How_did_you_heard_about_us, "Email" : input.Email_Id }; CRMResp = zoho.crm.create("Contacts", contactinfo ); But I do notice, if exposing the contents of the string CRMRestp....in
Need to bulk edit a checkboxes field without clearing current choices
Hello all, I would like to bulk edit a checkboxes field (4 choices) that already contain information (1 or more choices already selected) by checking an additional choice, without clearing the field. The following post (and solution) seems to be very close to what I need: http://help.zoho.com/portal/en/community/topic/suggestions-for-bulk-edit-of-multiselect-field?-6-12-2009 This is for a multiselect field. Could it be adapted for a checkboxes field? Thanks in advance, Patrice
Column width in summary view
hello, how can we set the column width in a summary view ? The help files refer to a "set column width" option in the configuration menu, but this option is not available for a summury (only for views). When I try to embed the summury in a web page, the view is too large and i wish to adjust the label size as well as the input field size. How can we do that ? Thanks for your help,
Print a list (view or summary)
Hello, Is there a way - to print views or summaries with a title, a header, page numbers... on each page in zoho creator ? - a way to manage page breaks, Is it possible to print all records using a form layout on each page ? - or to print an individual record of a summary on each page ? Thank you for your help ! inhuit
Custom filter
I wanted to create and save a filter with "added time" within last 30 days. How can I express this in a custom filter? Thanks.
Saving New Records
Can I save a record to a view with a stateless form? What I mean is that if I have a form called company and its view called company_view, can I have a stateless form called sub company create a new record and save it in company_view? Or can stateless forms only update records.
How come if I make changes at a Form, it doesn't automatically change the View?
Hello ZC Team How come if I make changes at a Form, it doesn't change the View according to it? Why aren't changes at Forms not automatically applied to Views? Wouldn't it be a nice DEFAULT SETTING behavior (of course with optional advanced settings to adjust it granularly)?
When I open a record in an HTML view it displays all records instead of a single record
I have tried to follow the various tutirials on this forum, but i am stuck. I have created a function that put a button on the list view of one of my form's data, that should open a single record, but when i click it it Opens all the records in the HTML view , instead of a single record... I have posted my code below, can someone PLEASE HELP. Thank you in advanced. htmlpage Compost_HTML_View(ID) displayname = "Compost HTML View" print = true content <%{%> <%for each x in Compost_Tracker {%> <div
can't save my app to script..
Hi why I can't save my app to script.. when I click "save script" the screen is nothin,just only show the "https://creator.zoho.com/exportScript.do?appid=142568000000203003&fileType=.ds&sharedBy=stanleyguo" in addrsee of browse,I used IE,Firfox and Chrome but the Result is same taht can't save script for my app. help me...please thanks STANLEY GUO
Cannot edit or view one of my forms from admin
When I try to edit my application I have one form which I can no longer view and therefore cannot edit. In my application Art Inventory Management 3.0 Form -> Arts When i go to this form nothing appears on screen. It just doesn't come up. Please can you fix this as son as possible. I cannot continue development of my application until this has been corrected.
relational database
I see that there are notes on the forum about adding relational database capability to Zoho database going as far back as 2007/2008. I am looking for this functionality but cannot find out how to access it. Has this functionality been added yet? If so, how can I use this functionality to validate a field value against a lookup table as soon as the value has been entered? Thanks!
Not easily getting into form
When someone goes to our form, www.ElevatingYourBusiness.com/b/Explore.html , it asks that they sign in before they complete the form. I don't want that to happen. I want them to see the form, fill it out, and submit it to me. I don't want any more notes from people like this as it shows that I'm not interested in customer service. Here is a recent one complant about the sign in: I tried to use my gmail account, as it suggested below the login area. It allowed me to login, but then said I didnt
Will Publishing application change name of application (and break URL links)?
I have an application that I have been developing for some time. I have shared this application to the users, but now want to publish to them (the client) so that I continue development. Will publishing change the application name? Will it break any of the URL links in the application. For example, I hyperlink to different views and forms using the application URLS.
How to fetch From View to HTML?
I have created in the view the ability tol allow me to view a HTML view. I cannot get it to fetch the data and merge to the HTML view!! Any Ideas????
Schedule report to be sent to a list of emails that are based on a view?
Is it possible to create a view of contacts and use that view as a mailing list for scheduled reports?
Importing accdbe files into Creator
Somewhere I read that it is possible to import .accde as well as .mdb files into Creator, but I haven't been unable to do so, and can't find any additional info. Is it possible to do so without conversion. Thanks,
Error message when editing a record from Form View
Hi -- I keep getting the following error when trying to edit data from a form view: [t_431470000000028161_PIDX] Exception occured while inserting rows Failed to update data. Thanks in advance!
Picklist (Checkbox items) to contain clickable URLs
I expect it's a bit of a violation of things...but I would like to be able to put a series of URLs/Web Addresses as items in a Checkbox list...and allow the user to click on them to open records in other locations (in this case Zoho CRM). I set target to '_blank' so that they open in a new tab. In each item, I put a persons first name, last name, and then the clickable link.The code below 'sorta works'...I do get something clickable...but there is quite a bit of unwanted extra info...here is an example
Insert Record hanging in Stateless form
mQuotation = Vehicle_Quotation [Quotation_ID == input.Quotation]; mFields = getFieldNames(); mID = zoho.currenttime.toString(); mData = map(); for each mKey in mFields { mData.put(mKey, getFieldValue(mKey)); } mQuotation.Status = "Reissued"; insert into Vehicle_Quotation [ Added_User = zoho.adminuser Bank = mData.get("Bank") Book_Days = (utilities.configuration.Setting("Default_Booked_Days").toLong() + (mData.get("Book_Days")).toLong() - 3) Color = mData.get("Color")
Getting the First Record from a Form - how to index it? (Radio button picklist)
This was a bit trickier than I expected...and I looked everywhere on the Forums and Deluge Script for it...and eventually came up with this - it may be wrong, and I'd love to hear a correction...(so if I've missed something blindingly simple, I won't be surprised) Basically, I am populating a Radio Button picklist with a series of strings which are each a field within a form record...so firstly I loop through each record, and use ui.add to add the string from each one to the picklist. But then I
Find Last Record in Form - MAX Function?
I have a form where the users inputs a sequence number (integer). I would like to autopopulate this with a user input script (when the previous field is updated). Is there a way to find the last record number? I was look for a MAX function or something similar. Thanks,
Reusable Widgets or sub-components (user-defined widget)
I have an application that does some searching (of CRM as it happens), which results in a list of email addresses which in turn are made available to an email template preparation/customisation app, which passes the resulting email text to an email previewing application. The reason I do this is because I want to treat the searching and the email previewing activities as 'reusable' components - because they will be used in multiple customisable email template instances. I want them to be reusable
Creating Customizable Template
Hello, I am trying to figure out the best way to make a user friendly email template. Let's say that the five field are set up, such as Name, Email Date, Time, and Place. Upon Submit, these fields are inserted into an email template that is stored in such a place that the user can access it in a rich text editor to make changes to it. This editor could be something like Zoho Writer. When the form is submitted, it needs to insert the variables into the template and sent it to the email entered in
action to copy field contents
Hi, I have two fields in a form, "site address" and "billing address". I have a radio button, "same as site address", with one option, "yes" I want to add an action on user input to this radio button so that if the option is selected then the text from the "site address" field is copied into the "billing address" field. I'm sure this is simple but I can't seem to work it out. Can anyone help? Thanks Jeff
Opening Single Records in HTML View
Hello, I have created an HTML view for one of my forms, and I need to know how to execute a function that will place a button in a column in a list view, that when clicked, it will open a new window displaying the specific record in the HTML view i created... How do i do this? thank you in advanced
Simple Question please help
I have a very large form, so to make it easyer for the user i made a drop down menu that shows only the section of the form that is selected. The problem is the script is so damn big, which causes crazy lag, Can anyone suggest a more effect way to do this... the current script located below http://creator.zoho.com/jpiajr/form/492/scriptbuilder/ under the "on user input" for "select a section to view" field
Ical feed help
I created a calendar with the intention of using iCal feeds for Outlook/Google calendar. I had the Start time and end time programmed as as DTSTART and DTEND as iCal feed parameters, but the feed doesn't work? any ideas why it's not working? Thanks http://creator.zoho.com/becomgmt/reservation-management/#View:RsrvCal_All_Rooms
Integrating my Applications with my website
Is it possible to integrate an entire application like your CRM example with my web site? If so, can you please explain how? I tried to use the "embed in your website" feature, but it appears to only embed individual forms and I want to embed the entire application. tkersnick
Deleting Copy of View
I created a Copy of a FormView which contained numerous records. The Copy was renamed CopyView and then the records residing within the CopyView were deleted. When I deleted the records within the CopyView, the original FormView lost all it's data records as well. Is there a way to delete a Copy of a View without impacting the original View?
How do I view submissions to a form I have created?
Hi, I created a form under the creator application. However, I am having trouble finding the submissions or completed forms. Can someone please explain to me how I view submissions and how I can export them to excel?? Thanks. Anne-Marie
Next Page