Creator as a Production/Live System
I was wondering if anyone is using Creator as Production System that requires substantial uptime. I have been reviewing the Creator and have determined it will likely meet my clients requirements, however I want to get some feedback on what sort of uptime we can expect. How stable the Creator is, and whether it can be used as a live syste, that is used throughout the business day. Is the Creator ready for daily and frequent use, or should I be looking else where? Glenn.
How to fetch a record and create HTML like a compare site?
Hi, I do real estate listing business. How do I fetch a record from Zoho Creator and create HTML showing top-down information like comparison site below? David
Purchase Order Database
I want to create a Purchase Order database whereby I can create a unique Purchase Order number and add a quantity of product lines to the order and have it total at the bottom. Is this possible in Creator? Thanks, Martyn
Schedule sometimes says "An internal exception occured ", but why ?
Hi forum readers, I have written an interface using CRM API that's retrieving specific records from a view, then sync a creator table. As far as I know, here is no problem as I know of with the script, and all the records are currently retrieved, and creator tables updated. Every night, a custom schedule runs and calls this script. However, when I looked at account usage log for this schedule, I realized I sometimes get "An internal exception occured" message (see capture “Schedule Log.PNG”) After
Password and email
I was wondering if there was any way where you can get a fetch record (witch i dont know how to do) then find the email that they put in and have a password they have to have that is correct and it will let them move on and if it is wrong it will ask them to redo it. I dont want just one password i want every user to beable to do it. i also would likea way so that it will create a list that can be modafyed with all the passwords and emails so they are always there and if you delete the records they
Prompt for input on record-level custom action
I'm developing a view with a custom action for each record, but I want to be able to have a prompt for one of the variables passed to the function. Right now it looks like all the arguments must come from the record. What if I want to customize a different message that is sent to each record's email address via a custom action? I want to be able to click on a button next to the record "Send Email" and then be prompted for custom input to pass to the email function. How would I do that? Thanks!
can't get field.select("XXXXXX") to work
I have a form <Contacts> with a field <Roles> (Lookup, Multi Select, Checkbox). In a script I want to select one of the values. I use the following statement (after fetching the appropriate record in <Contacts> using Collection x): x.Roles.select("Volunteer"); I get a message that this is not a valid statement. What am I doing wrong? thanks Henk
getURL() hangs on me for (what seems like) a valid URL...having trouble with APIKeys too
If, when logged in to Zoho Creator, I type:- http://creator.zoho.com/liamzoho2/sfit-email-templates/rss/Employee_Detail_View/ into my browser address bar, I get a nicely laid out response which shows the records in that Form View... But...when I use 'getURL()' within another form to try and replicate this...the system just hangs....here is a code snippet...suffice to say, if just hangs on the first line... response = getUrl("http://creator.zoho.com/liamzoho2/sfit-email-templates/rss/Employee_Detail_View/");
What happened to the PHP Expense Tracker application?
Hi, I was looking at using PHP from an external website to access a Creator Form and cam across this blogpost which looked interesting... http://blogs.zoho.com/creator/apis-for-zoho-creator But the link to the example provided (or at least I got the impression that this example was PHP source code)...http://creatorapps.zoho.com/ is broken... Is there an alternative I can look at, or can anyone else provide some PHP code examples for accessing Zoho Forms from external websites? Regards, Liam
Lookup fields problem
I have a lookup field that draws from another form, but the other form has some fields with the same value. Is there anyway to leave out multiple values and have it show up as just one entry?
Need help relating forms!!!!!
Hi, I a new to this but here is my problem: I created a form (Requerimientos) that is going to be filled by some person, then I created another form (Informe) that is going to contain the info that was filled on Requerimientos. I am trying to place a lookup field and opens the box where asks me to select the app where I want to get the info, the app is OK but then I cannot find the info I want to get from the other form, it is too general and does not relate to a specific form, therefore I can't
Add a blackslash to HTMl view
I have a path that appears at the top of our HTML dashboard page that references a folder in our directory structure. This is so I can easily cut and paste the link into my computer and used apps and I jump right to the folder I need. However when I try to enter in the html z:\print_jobs\ <%=order.Order_Number%> or the deluge script <%="z:\print_jobs\ + order.Order_Number%> the backslash throws an error. Any ideas? Thanks.
"Error at on update script"
I made a couple of changes to my form, and now I can't update an existing record, because when I do: Error at on update script. Note: We are working on giving more meaningful error messages on script failures All I am doing is changing one text field, so it's not like I'm acting on the world, here. I removed all onUpdate scripts from the fields, to no avail and no change in the error. The only things I've changed since yesterday: * I made a field a numeric field. * I added add-validation on that
PHP calls to Creator Forms using Post method via PHP CLI - almost there...please help me over the line....
OK...I was able to use a form in HTML/PHP to add a record to one of my Creator Forms...and I posted this solution here... http://help.zoho.com/portal/en/community/topic/need-help-with-zoho-creator-api#2266000001962402 So now I want to emulate this by a PHP command line call...and I've done some research...I think quite a number of people are disappointed that there isn't PHP example source code for this feature available...I've looked at the Java code...and can't figure out what needs to be done...I
Running a ski racing league - will Zoho be a good application for this
Hi, I have been running a ski racing league for several years using Excel. Each week I copy results from website into excel. Each racer skis on the green course and the yellow course and records times. I then add a column to total these two times, then sort them by the fastest combined times to get the pairings for the week (1st fastest races 2nd fastest, 3rd and 4th race, etc) (we race for beer !) Does anyone think I could use this program to import times each week (bib numbers never change)
What are the basic functions of zoho?
What are the basic functions of zoho? Functions for handling data from forms to forms among other things. Thanks
record view in HTML
I would like to create an html view of a record which I can print as well. I am not efficient with coding and scripting. In the view, I'd like to see records from multiple forms. [student form] Student ID# Student Picture Student Name, Student Emergency contact ... etc [housing form] housing name housing location housing info .. etc [school form] school name school location school info ... etc
Refresh Button on a view
I want to create a refresh button on a view, but cannot use the reload action on a user defined function. What is the best way to create the refresh button on the view?
Alphabetize With Deluge
I am currently using a deluge work around to add the fields to a lookup list and keep from having the same entry twice. The problem I have from doing this is that they do not get put in the field in alphabetical order. So my question is, is there a way to alphabetize a list in deluge?
Are <form> HTML tags allowed in fields?
I can input links and images via HTML tags into fields, but if I try to do <form></form> tags, it looks like Zoho strips it all out. Is there any way of including <form> tags in a field to render the HTML form in a view? Thanks.
Emailing data to forms creates duplicate records
I am email data to a creator form using the email functionality, but all of a sudden I am getting multiple records for each record I email. Intially, I thought this was an issue with my code, but I tried it with a different form in my application (with only two fields and no actions on add/edit/load) and I am getting the same results. Did something change or is there a bug in this functionality? http://creator.zoho.com/carlgifford/test form: Seasons This application is shared to support
Autopopulate Field - Unique identifier for concurrent users?
Hi there, I want to autopopulate a unique field per record load. I got the script and instructions for this from suppport, see below: Add a new form with name MaxValueHolder form to your application. Add a number field named "highestval" to this form, to store the value. Add a record to the MaxValueHolder form with a starting value that needs to be incremented sequentially, ie, enter 18000 In the AOE PEST CONTROL Form, add the following code in the on add -> on load block of the script tab,
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
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
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.
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?
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
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
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
Replace All with Input Field
I need to replace text in string field dynamically based upon another input field in the form. I am trying to do this with the Replace All function but this does not seem to be working. Here's my sample code: PropertyOwnerInfo = input.Property_Owner; BodyText = (BodyText).replaceAll("PROPERTY_OWNER",PropertyOwnerInfo); input.Body1 = BodyText; If I use an actually string text in the replace all function (e.g. BodyText = (BodyText).replaceAll("PROPERTY_OWNER","Bob Smith"); it does work. Is there
Issues with Functionally based URLs on List Views
Hello. I'm having issues using functionally based URLs on List Views that have lookup fields from other forms. I use the specified format on the user guide with no success. Is this even possible or is there a different format for this type of url? The Zoho Creator User Guide says to use the following format: To set criteria for a view The criteria for a view can be passed as part of a query string to a view url. Multiple criterias are specified by appending it along with the URL using '&'
Hide/Show form cells based on criteria
For example: I have a form that has job numbers with a varying amount of entries tied to each number. What I am wondering is if it is possible that in another form if a user selects job number 574 and it has 4 entries tied to that number is it possible to have 4 text boxes show themselves with information from each entry. I know how to show information from different forms i just need to know how to toggle visibility. Is this even possible?
auto expanding list
Hello, Is there a widget in the Form creator that provides an auto-expanding list? An example: On a contacts form, I wish to have users provide one or more email addresses, phone numbers, etc. this widget would give a plus sign and allow for the user to enter multiple items (I have attached a screenshot from Google Contacts that provides this functionality). I know that you can create a faux-subform using a view but until subforms being inside of stateful forms is a reality is there any way to accomplish
Fetching data in stateless form from other form
I have generated customer form and stateless customer form. I have generated one field in stateless form which has a condition. Suppose anybody enters sMobile NO in phone field of stateless customer form it shows name in sName field of stateless customer form provided that phone number is already entered in Mobile No field of customer form and name also entered against that Mobile No field in name field of customer form. I have generated following script and put it in on user input of sMobile NO
XML RPC API, CSV RPC API, and Shared Apps
I'm trying to use the XML RPC API and CSV RPC API to view records from an application that has been shared to me and both methods are not returning any data. I can successfully use the XML RPC API and CSV RPC API to view records from an application that I created and own, however, using the same methods to view records from an application that has been shared to me does not seem to work. Should I be able to use the XML RPC API and CSV RPC API to view records from an application that has been
How can i get the lookup value when user edit the field
for example when user select the stock symbol in one field it automatically update the company name in other field matching with the correct company name in other form.
Pass Dropdown values between forms
Hi All I am very new at this creator stuff. I started yesterday. Anywho I have a drop down box on a form which only has two fields on it deliberately for mobile phone access. The two fields are where are you and who are you. Based on the where are you drop down box I open another form over this form. In the new form just opened I want to dynamically alter the drop down in the new form to show only jobs requested for this site. I cannot see how to pass the value from one form to the other
Can I open a view directly with the search bar open?
I would like to open a view and immediately open the search bar. Is that possible? And I have the same question when I open that view using a url I use now the following url: openUrl("#View:Contacts_Donations_Search", "same window"); thanks Henk
Default Date Format Not Working
I have a registration application I am working on which has a main registration form. The application also has a form to add available dates. Each date available for scheduling also has an associated capacity. I want to dynamically add to a picklist of dates on the registration form based on the selected number of participants (capacity). I can get this to work just fine with the code below: adate = Available_Program_Dates [Program_Available_for_How_Many_Participants > input.Estimated_Number_of_Participants]
About ZohoAPI
Guys, Can we integrate the Creator and the Writer through API? We havea creator application need use writer, give me some tips thanks, Andy
Next Page