Automatically add record
Hello, I would like to know how could I do build a script that automatically adds the zoho.loginuser into a field (lets call USER field) of a form (lets call it form 2) of a user that has generated data into another form (lets call it form 1) when a record from another field that has imported data from the form 1 is selected. Example: FORM 1 Fields: - Product (text field) - Add User (zoho.loginuser) FORM 2 Fields: - Product List (Imported data from all the records of FORM 1 - Product Field) - USER
Connecting to Different CRM System
Hi, We are developing a creator application, where we are required to access different Zoho CRM instances. Currently, when we are calling records from Zoho CRM creator is fetching information from CRM connected to Creator's owner account. Please advice how this can be rectified. Also, can you please advice if we are developing an application using Zoho Creator and we would like to deploy this for the client how can we distribute this application. Regards, Kazi Hassan
Updating Quantities
Hi there If i have one form (products) And another one (products sold) and i want to update (products) table field (stock on hand) once i sell an item in the (products sold) table with the field (quantity) how do i deduct the (quantity sold) from the (stock on hand)? Thanks heaps Jason
Function - assigning a value to a field and calculations
Problem 1 I want to create function that looks like the one below but it doesn't work. void namespace.function() { input.Total = input.A.toLong() + input.B.toLong(); } input.A and B are dropdown boxes and everytime I select a value this function will be called to calculate the total. Also my form have different sections with different dropdowns. Problem 2 How to do I count the non-numeric options(Options: 4,3,2,1,NA)? Because my calculator function also needs to know that to be able to compute
handy date comparison hack
For people that want to check if a chosen date is before or after the current date: just subtract them. It gives a nonsensical number, but the sign is all telling. dateChosen = input.Date1; dateCurrent = zoho.currentDate; dateRemainder = dateChosen-dateCurrent; if (dateRemainder<0){ // day is in the past } if (dateRemainder==0){ // day is current } if (dateRemainder>0){ // day is in the future } Just wanted to share this with you, so that you don't have to break your head about
Inserting record in Zoho Creator by API in C#
Hi I am trying to insert a record in zoho creator by API in C#,i have provided the user name, password and api key as well but when i try to add the record it throws exception 500 internal server error, can you kindly let me know what can be incorrect which is causing the exception, kindly reply ASAP, or it would be great if you can provide me any code snippet in C#. regards,
view distinct values from a field?
I want to create view that displays the unique (SQL: distinct) values from a text field? how? once I get the unique values from the view, how can I use this data to populate a new form(table)?
Zoho Creator Search Engine for Applications
Recently I've been working on Zoho Creator applications that require search tools. I've been using the stateless form in conjunction with HTML view approach; however, the scripting involved is a lot of work and can get very complex as more search fields are added. I've noticed that the List View has a pretty good built-in search capability. It would be great to be able to use this search feature separately from the List View within forms. If it is not possible, it would be great for Zoho Creator
Show a list if entry is duplicate
Am a complete newby. If a Lastname and Firstname field are entered and these already exist I would like to show the existing record to the user and ask if they need to edit this record or not? Can anyone help to get me started with the coding? Thanks
Wufoo to Zoho Email Integration
Hi Anyone got this to work successfully, initial testing indicates that the wufoo styling feature causes an issue and the incoming email is not added to the zoho database Thanks
How to keep the track record of users in an application
There are many peoples ( or active users ) working on application in zoho . They are feeding data constantly , but who can I find which person has submitted which data.
Inserting data got from Creator application into CRM
I got data from my creator application(getleadsfromcrm) through api .Then I want to insert them into CRM by insertRecords(CRM api method).But their xml formats are different. How can I achieve it.please help me .Thanks !I tried it as follows: first:I get data from creator application getleadsfromcrm, thisurl = ("http://creator.baihui.com/api/xml/getleadsfromcrm/view/leads_view/apikey=2e16c27cff734a56b029f35e616f0008&ticket=2b3c5bb3e29bb7309af75a40d5794a82"); getXml = map(); str = postUrl(thisurl,
Announcing: Zoho Creator for Google Apps
Zoho Creator, is now available for Google Apps. Install it into your Google Apps Domain today and let us know how you like our Google Apps specific features. Zoho Creator has 4 new enhancements for Google Apps Users. Universal Navigation: Once Zoho Creator is installed in any Google Apps domain, users can access it right from the universal navigation bar in Google Apps. G Apps Users Field: Users in a Google Apps domain, can be added as one of the fields in Zoho Creator forms. This field provides
Advanced Filtering in Views (two level filtering)
Hi, grateful for any suggestions here My issue, I have an Auto filters for Regions/Products/period/countries etc etc (all work well) Then i want to further filter this list for to only show a particular sales person in that region (over 500) Am i missing something ? in list view, this seems impossible to do at the moment Will I be spending all weekend writing custom filters ? which for all the variations will be many Thanks
ACT to ZOHO
How do I transfer my ACT Database onto Zoho? Thanks! Jennifer
download attachments as files -- login for FileDownloader app not working
Hello Zoho, Back in March, I posted a topic about downloading attached files as docs. I received a response about an app that I downloaded and I remember this working really well - https://help.zoho.com/portal/en/community/topic/download-all-attachments-as-docs However, I just tried doing this again, and my login credentials get rejected. Is there anything that's changed that affects the behavior of this app? It is REALLY useful. Thanks, Kim
Error in Sample Application
Dear zCreator Team, I was redirected to a sample application for DateTime Picker (https://creator.zoho.com/sampleapps/time-format/form-perma/Date_Time_Picker/) in this URL (https://help.zoho.com/portal/en/community/topic/masked-edit-textbox-in-contact-form) I think the sample application is not working. It is throwing an error message "Error occured please contact application owner." as illustated in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Masked Edit Textbox in Contact Form
Dear zCreator Team, Is there a way we can create a Masked Edit textbox for time picker so that the user can type 20:00 or 08:00 PM (URL http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/MaskedEdit/MaskedEdit.aspx) and/or see attachment As the user types the words can be formatted automatically... ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How to make a next and previous button?
Hi, I would like to find the index number for a given record ID. Here is example, markRec = market [ID=123456]; and then find the index number indexRec = market[ID!=0] range from markRec.index to markRec.index; Reason for doing this: I can build a next or previos button to fetch the previous or next record. Any suggestion? Many thannks.
Search for negative values in view
Hi all, One of my views shows records from a form that contains one "number" field. This field is used to imput numbers, which are either positive, or negative. Negative values are entered preceeded by the "-" symbol. For some reason, in the view that displays those records, all negative values appear alongside the positive ones, but it is impossible to search for the negative values: whenever I input a negative number in the "search" field corresponding to the field, I get an error message "Please
How to add a time-only masked textbox?
I have a contact form for my website here: http://astrovighnesh.com/website/index.php?pg=contact I am looking to see if in the time of birth text-box I can create a textbox like hour:minute format. I could not use DateTime picker because people are not able to use the small time below the calendar and hence separated the controls. ---- http://www.astrovighnesh.com/website/index.php
Time axis setting for Pivot Chart / Table
Hi i'm evaluating the ZOHO Creator most requirement is satisfied but i got a question while using the pivot chart / table for example i have a form data with projects, each project has its own kick off date when i use pivot chart / table to analyse i may get the following result 2011 Jan 2011 Mar counts 1 2 since i have no project kicked off at 2011 Feb how can i get the following result 2011 Jan 2011 Feb
Customized Login page and automatic redirection
I'm currently running Zoho Creator Helpdesk and am using Google Apps for all my technicians, which just works great! However, my customers need to logon with an explicit non-googleApps ZOHO account. The only way to for them to log on is to open the ZOHO website at http://creator.zoho.com/home/index, logon to the ZOHO application cloud and click the link on my website in order to open my support CRM. Can I integrate a logon window on my own website and automatically redirect to my application URL
Paypal IPN
Hi Looking for assistance to integrate PayPal IPN with Creator Thanks
Embed light Gmail search criteria results in an HTML view
Hi, Is there a way to embed a Gmail window (with a search criteria on EmailID) in an HTML view. That will be very usefull in a custom CRM app. I tried with IFRAME but it's not working. Any tips ? Thanks. Pascal Veilleux
How to enter text in the forms
For Instance, I want to enter text above the form information, like: Please fill out the forms below and provide full essay questions (insert paragraph) I've looked through the drag and drop options and don't see where I can input text above my drop options, to make a more informative form if you will ;) Help!!!!
how do i add and subtract from a field so that it can be tracked?
example: Lot code: 11ZN-STE beginning volume - 1000 gallons action - barrel racking ending volume - 900 gallons wine loss - 100 gallons Then, the next time i open this field, i would like the beginning volume to be the last ending volume or 900 gallons. Any suggestions?
Download url
Hi, I have a form that send a link that allow downloading a file uploaded from the form. This form is private and I can't put the View as public. Exist a URL that allow downloading the file from the emailed link that origin view it's not public and not shared? Thanks Mic
Subscriptions Plans
Hi, I'm zoho user from october 2009. I have a STANDARD montly plan with bonus of 100.000 records and 1024 MB disk space, because I'm a old user. I would know if I buy a PROFESSIONAL EXPRESS plan, I still have also this bonus. Thanks Mic
Need to identify fields that are updated within Form Scheudle
I have created a Form Schedule that sends out an email when a record is added or changed within a specific form. I am able to identify the record by selecting a few unique fields in that record and include them within the email. I would also like to tell the email recipient the exact fields within the record that were changed. It would also be nice to include what the value was in this field before the change and what the new value is after the change. Is this possible? Thanks in advance for your
Form object operations
It would be great to be make form objects another variable type. Now a form object (such as someform [somefield > 0] ) can be passed as a parameter in a function, but can't be returned by a function. A function like this can't be valid: formobject somefunction (int nr) { if (nr > 10) { object = someform [somefield.contains("Tom")]; } else { object = someform [somefield.contains("Mary")]; } Return object ; } It would be also great to have operators/built in functions for form object. For example,
Assigning Values to Users
Is there a way to assign values or fields to usernames? I would like to assign a company name to each user in my application, then use that field to auto-populate a field in a form when the user submits data. Thanks in advance for your help!
Hosting form off main site
Wondered if any one can hlep me please. My new website is set up over two columns and as such the form wont fit in as it can only sit in one column or another. Is there anyway to host the form off the site and just have a link that the customer clicks on to access the form - for example in a pop up box? Would appreciate any help as I am going nuts over trying to make it fit. thanks!!!!
Review / Show details from last saved record in new stateless form?
Hi, I'd be grateful if anyone can help. I've got a form that takes a load of input details, then on submit calls a URL to send some info to a remote server. It then saves the response from the remote web server in a multi line field called 'Transfer Notes' in a view called Transfer Details. I then want to show this information to the operator in a new stateless form. So I can call the stateless form URL, and show a new field on load I can populate with static data. However could someone please advise
does anyone know how to create codes on the submit button with in a system created in zohocreator?
hey i need some help with creating some code that on the submit button that tells me if it has gone passed the date that is required, does anyone know how to do this?
lookup verus dropdown anything to consider
Hi Am building my forms in zoho and i tend to keep using lookup instead of dropdown Good Reasons for lookup so far are 1) With a lookup, one change is reflected in any form that uses that field 2) I can have columns in a lookup which with the advanced display helps a lot 3) I can list alphabetically 4) I can select a default 5) The default entry to the user is -select- stops me from thinking about it so far all good... question, am i missing something which is going to trip me up or another way any
Show .xls data in a form
I need to know how to show .xls data in a form.
Is it Safe to change the "Field name" for a lookup via the form definition
I have a fair amount of info in Zhoho at the moment so thought i would ask I want to change the Field name (refer to another field) on an existing lookup in one of my forms There does not seem to an option via the Edit Field properties but i can see how it is declared in the form definition Has anyone ever edited this directly ? So far i have been creating a new lookup with the new field and deleting the old existing, however as the existing lookup is tied to Deluge actions it can be a pain as you
The NO - REASON SALE
It's none of the holidays nor is it an occasion to celebrate. But we thought, we didn't need such special occasions to express our gratitude to our loyal old timers.. Presenting the NO REASON SALE at Zoho Creator. Get upto 20% off on plan upgrades to longer cycles. And if you still haven't upgraded your Zoho Creator account.. Now would be a great time to do it. Offer valid till 5th September 2011. Head over here for more details. Its time to ... Up.. Up .. and away Upgrade... Thanks Aparna
How can you limit number of registrants to 100 only?
How can you limit number of registrants to 100 only?
Next Page