Scripting documentation hard to find
Scripting is needed once one moves past the basics, but documentation is not comprehensive that I can locate. One needs a list of all the functions available with the exact vocabulary and structure specified, but I can't find it. The few examples listed are good, but more are needed. A related issue is that the ToC for the scripting help menu doesn't cover all available help pages for scripting documentation, apparently. I discover, at least, many more than I can descend to hierarchically through
Form using Sendmail unable to send mail messages
I've developed a an application, https://creator.zoho.com/sancher/shift-allowance-tracker/. It is to help in tracking shift allowances in my project. Shift allowances are entered thru the month. At the beginning of a month, a mail is sent to various team members who have shift entries in the past month. This mail contains the shift entries pertaining to the team member along with the team members ID. A module, "Generate request to confirm shift details", has been developed for the above requirement.
Forms and number of users
Hi, im trying to create a form that will be used to assessed the technical support of one area to the organization to other internal areas. In order to do this, which kind of licence do i need? every person completing a form is considered a different user? Thanks, Juan
Posting JSON to HTML view and converting to Map.
This is in response to the following post. Got an error trying to post there so I started a new thread. http://help.zoho.com/portal/en/community/topic/500-internal-server-error-24-6-2010 Akash, I'm a little confused by your guidance here. I don't think that hesadanza it's trying to do a JSON "RPC'ish" post with a json body as ONE KEY. When submitting an html form via ajax doing this.... params : { name1 : value1, name2: value2, name3 : value3, } //jquery ajax post $.post(url,params,function(data){
Date Functions
I maintain a membership list for a club of sorts and need to keep track of when members fees are due. Is there a way to have their listing show up in a separate list after their payment date is over 365 days old? This refers to my MN application under my list of applications. Thanks for your help.
Query only rows where column matches X criteria?
I know this has to be simple. I could write this query in my sleep in SQL, but I'm short on time and trying to figure this out in Deluge. Basically I'm trying create a report that will only list the values that I specify in my script. For example... say I have column called ComputerName that lists out roughly 400 computers. I want to pull a specified list of computers. In SQL I would write it like this... select * from database where ComputerName in ('computer1','computer2','computer3',)
When I share my view with oher users, I just want that each user can ONLY edit their own records that they have captured by the form before.
When I share my view with other users, I just want that each user can ONLY edit their own records that they have captured by the form before. When I set the permission, it allows me to give the permission to every user with who I share the view. So they can edit any records that they want....and I don't want lol! I want that when a user captures his information by the form, he can only edit his own records! How can I proceed? Thank you
Fields required. I want to give two solutions to the user for giving a required information
I want to give two types of solution to user for submitting a required information. Like he can upload a file or write an URL where we can find the information. At least one of both information has to be filled in to allow information submitting. Example (pseudo code) : if URL_field/=null or upload_field/=null then submit=active.... I don't know how to program it...Someone can help me please??? Maybe I don't have to program it... Thank you!
creator reports
unable to open the report editor on clicking create new report....
How can I display an image in my form (not in the view)
I have left zoho one year ago with this problem and it is still here. Any solution? For example, i want to show a diferent image for each of the option in a drop list; when someone change the select product from the list, i want to show the picture of the product.
OpenURL query
I want to be able to display transactions between two dates using the following script, but doesn't work: openUrl("#View:Expenses_View?Date_field=" + input.Start_Date;input.End_Date, "new window"); Any ideas? Martyn
Email Address instead of verification code
Hi, I have an application in which one can enter his contact details. I would like to have him/her re-enter their email address instead of the verification code. Any chance I can do this? Thanks!
IMPORT DATA FAIL
Hi, I have given support access to the database. Here are more details with the issues. Importing DID WORK Denominations (simple two column, no linked or multi-select data) Suburbs (simple three column, no linked but one multi select data) Importing NOT working The forms; Churches AND Schools will not let me import I went through first and removed ALL "no duplicates allowed" options - did not fix I removed all field options for 'required field' - did not fix In the Schools Form: I removed the two
Hide some tab from User
Hi Team I have a question . For example My application is used by User and the administrator.I want to set some permission that the admin can see only some form/View.But the user can't access that view. ie I have three tab Dashbord,AddTable,ViewTable Can I hide View table tab from user but it will show while the admin is used. Is this possible? Thanks
TXT FILE
Hello, I am developing an application that must generate a txt file and the user must download. How can generate a txt in zoho creator and user can download it? Thanks
populate one form with information from another form
Hi, can soneone describe in simple terms how to populate one form with information from another form Thanks Nigel
toXML parse not working.. TRUST ME.
Hi, I use your getURL, postURL,toXML, and xpath functions extensively. Good stuff. However, I ran into an odd problem that I was able to debug. This problem throws erros both DS and in xpath builder app. In DS the my xml variable cannot be updated In xpath builder I get the following error Error :: Invalid XML/JSON format javax.xml.xpath.XPathExpressionException Anyways, it turns out that the problem occurs when an xml element looks like this <element attribute="" attribute="" > instead
Funny look to disabled fields
With Firefox 3.5.10 I get this look to the disabled fields: Not very attractive. Not true in IE8. Thanks, Bruce
Unable to delete application from homepage
This is the error i received, Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again. I tried deleting all forms and views inside but still didn't work. This really is a serious bug. I wish to delete the following applications, 1. inventoryt 2.copy of exam registration 3.copy of exam registration. Thanks
Upload Issue
I just uploaded my database and 250 of 4000+ entries came back as invalid type all in the same column. Reviewed, all in order and do not understand why this happened. Please advise how I can get this information into the database.
DECIMAL TO BIGINT
It's possible to transform a decimal variable into a big int variable into a script??? Thank you Sergio Galiano
If field disabled, remove from Views
Hello, If there is a field on the form that is currently disabled (through a decision box for example), can it be automatically removed from the View? thanks,
Can application use Facebook login instead of Zoho Login for user?
Requirement #1: I would like to create a membership application where user can login create account using their facebook ID and password. Requirement #2: I would like to create a membership application that has User create their own login data User fill out and modify basic info using their own created credential Simple search result by company, industry, age without need to log-in (not using Zoho account) Detail search result with need to log-in Hope that someone can help on this one! Thank you
Two script left (If field_1 is greater than field_2) field_3 = a numeric data
Here is the concept and below is my script. If the sum of total points for Blue Team is greater than the sum of the total points Yellow Team then the Yellow team gets 0 points and the Winner is Blue and receives 1 point If the sum of total points for Blue Team is less than the sum of the total points Yellow Team then the Blue Team gets 0 pts and the Winner is Yellow and receives 1 point here is the expression I wrote Mission_Score_Card > b_g1_wins > On User input if (input.b_g1_pts < input.y_g1_pts)
Problem
I just want all forms & Forms views in my left top pane. How can i see this ?
Where is the Save Setting being Stored?
I applied the steps described at https://help.zoho.com/portal/en/community/topic/how-do-you-to-sort-on-a-hidden-column-in-a-view#2266000001132452 that tell how to sort on a hidden field. After several attempts, it finally worked. But when I examined the .ds file I was unable to see where the change was made. The script of the view looked the same before and after I did the save. Can anyone tell me where this setting is being saved? Is this setting only good for the user who is saving the setting
HTML view: Error when use Rich text mode
Hi, If I try to make ANY changes using the rich text mode in my HTML view it gives me the following error: Lexical error at line 1, column 12. Encountered: "\\" (92), after : "" It doesnt even let me shift to plain text mode after this. All I can do is press cancel - but then my changes are lost. Please help ASAP Thanks
View for a specified range of date
Can I display the record with a specified range of date as input value, for eg: I want to display all records between the Startdate and Enddate: please help me Thanks
I love zoho
I recently signed up for your services and have spent the last 2 solid weeks building my somewhat complicated database. I love how you can customize everything. Being able to put my own code in has been hugely advantageous and has made it so nobody can possibly screw up an entry. I guess all that programming I learnt at university that I thought I'd never use is finally paying off. Im sure I'll be using your services for many years to come. Great job!
Begginer looking for manual.
I am a developer with over 20 years experience. Am new to Zoho Creator and I am looking for a manual for beginners. Thanks to all
Birthday Emails
Hi All, im using the Schedules section to create a script that will automatically email clients on their birthdays with a short message. ive set it up as per the instructions in the help section but it isnt working. heres what my script looks like: When to do: Birthday Notification { Execute on Contact.Birthday at 18:30:00 yearly } What to do: sendmail ( To : input.Email_Id From : zoho.adminuserid Subject : "Happy Birthday" Message : "Dear " + input.First_Name
getUrl function doesn't work
Since 2 hours ago, the getUrl function fails and no web-data is fetched into a variable. I suppose it is a temporary problem of Zoho api... Has anyone checked it? Thank you.
Count the Number of Member expire in these month
Hi Team I have table of members which contains the Member Expiry date. Can you please help me how can find the number of member expire in these month. Thanks
Delete multiple records
Hello all, Please be patient with me as my experience with databases is very limited,and I am hoping there is a simple solution. In my application I have a form named "Controllers" in this form there are three fields "Serial Number", "Max Temp", and "Hours" I am trying to create a lookup function for the form named "Controllers" I want the function to lookup the "Serial Numbers" of all of the "Controllers" in the form and display them as selectable check boxes. (This Part I know how to do) I then
Fetch specific characters in a data string
Is there a way to fetch a specific character in a data from a form field? This is my situation: I have created a database of car plate numbers (i.e. ABC123, ARX899, etc) which we are managing. Now I wish to be able to fetch the last digit of the plate number and create an automatic email notification based on the last digit of the plate number: If the ending plate number is "1", then we shall receive an email on January 1 to alert that the car needs to be registered on January. If the ending plate
is zoho appropriate for my application?
Members of my org need to view one table of contact data on the web. No adding, deleting, editing, just viewing. I would refresh the data weekly. they will select records based on values they enter for any of 5 fields. once the recordset is retrieved, they need to view it on a nicely formatted form that they can move through easily to see one record after another. They would not be happy with a gridlike view analogous to a datasheet view in Access. Is Zoho appropriate for this application?
Set the criteria on the current month
Hi Team Can you please help me how I can show the members whose Membership is expire on this month. I have the field for Expiry Date. Thanks
Emails not sent
Suddenly Emails not being sent from production application
database in creator
ive just tried for the first time the DB and everything was fine until i decide to add a multi-choice to contry and county, but even i select, the creator add all fields less this ones. also, is there a open source DB with UK all conties? thanks, Carla,
OpenURL - filter by date
I have a form called 'expenses' with two date fields - startdate & enddate. I want to open the view 'expense_list' but restrict transactions between the startdate & enddate. Can you help with the syntax for this requirement? Thanks, Martyn
Next Page