Automatic Time Refresh upon new entry
One of the applications we are using with Zoho is a Call Log. The date and time of the call are logged in. Is there a way to set the form so it automatically updates or refreshes the screen with the correct time when a new call entry is made? Right now, the person has to manually refresh the screen every time a call comes in, sometimes they forget to do that and then it throws our records off because our work is time sensitive. Thanks.
Trying to make cell color RED if AGE is = or < 18 using a function
I'm trying to create a function where if the age of the user is less than or equal to 18 ( legally a minor ) the cell back ground color would turn RED. I've been trying to work this out but I'm not sure how to approach. With this current function setup I am getting the following error, and I havn't even got to the changing the cellcolor portion yet :( The Left expression is of type TIMESTAMP and the right expression is of type BIGINT And the operator - is not valid here bool isMinor(int Student_DOB)
Getting records after a specific date.
By now, I know how to set a criterion for a view to restrict by relative date, such as "within the last year" or "before today". What I need is to know how to restrict a view to only show records after a specific date. Background: I have an invoicing application, and for this one view, I only care about seeing unpaid invoices (Date_Paid is null) that were sent in or after 2010. So I'm trying for something like Date_Sent > "2009-12-31" (which is the date format that my application uses), but I can't
Need user to fetch data to update form using iframes??
Hello, I have 2 stateless forms, each called to an iframe in an HTML view. On the bottom iframe is a duplicate of my main form (which is public) used for updating records. The top iframe has two single line text fields, Group ID and Listing ID. I want to use these fields to look up a record and populate the bottom stateless form so users can update that record. Our organization has 1000+ groups whose officers change all the time, so Zoho user accounts are not going to work here. I want whoever
How do I get an ID field to register with an auto fill of one on one?
Hi How do I get an ID field to register with an auto fill of one on one? For example: First Registration Field ID and auto-filled with a According Register Field ID and auto-filled with 2 And so on ... Thanks
How to Monetize a Database?
I am interested in creating a database app to sell. How can I sell a Creator app by user? For instance, each user is $25 per month. Each database would have a $50 set up fee. Also, if these are individual instances of the database, how are revisions sent out to all the installs if the master is modified? Does it make sense to sell individual apps like this or have one master app and sell access to it?
2 forms 1 sub form
I would like to know if 2 forms can share a sub form, and if possible how one would implement this. ex: sub form would look like: ----------------------- Student name: Housing Name: Move-in date: Move-out date: ----------------------- both the Housing form and Student form would connect to this sub form
Two lookup fields from same form - BUG
In my "Admin System" application, I have three forms: Tasks, Task_System, Task_Core_System "Task_Core_System" is a stateless form which is used to populate the "Tasks" form/table. "Task_System" is a form/table that holds all of the system names that I want to assign tasks to. "Tasks" form has a lookup field called "System" which references the "System" field in "Task_System" "Task_Core_System" has an on-submit action script that populates "Tasks", including the "System" field. This all works fine!!
Sendmail script with pictures
Does anyone know if there is a way to embed a picture on the automated email that applications send? i tried inserting in an <img> html tag but it only showed in the email as text.
Function that returns a boolean, boolean variables
Hi, I'm trying to figure out what is wrong with my function... I'm having trouble using boolean variables. I find this function works fine (returns a constant): bool PlayerGameAlreadyExists(string PlayerName, date GameStart) { Exists = true; return true; // this line works fine, returning a constant // return Exists; // this line doesn't work, attempting to return a variable } but if I try to return a boolean variable instead (see the commented out line above), I get an error
How do I create a view that receives data from two forms?
Hello How do I create a view that receives data from two forms? Example: Products have the form This form is to view Products It includes A few more information on this view, Now I want to create another form to add other information in this same view. Thanks
No Value on field (Null) not displayed in Filter Criteria
Hi, I have the following criteria on a view: ((((Status == "Available" && Retail >= 1) && Image_1.contains("http://www.")) && Quantity >= 0) && Ship_Weight_LBS >= 1) edit and I wanted to add "shipping_price" has some value in the field how could I express this in the above criteria. I don't want to use the word null but in the above criteria if there is no value in "shipping_price" I do not want that record displayed. Any help would be appreciated and how does the ((('s work? Is each (
Please Help - Weight Database
Could someone please help me figure out how to create a database for users to submit their dogs growth over time. Info listed would be dogs name, owners name, weight , and age. Where owners could look at a graph or chart of some sort showing all weights at certain ages to compare with others. This would be for just one certain breed. Any suggestions or help on this would be great. Thanks for your time!
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
Next Page