if condition then OpenURLl else if condition OpenUrl
erros on the Elfse if, why if(input.I_want.contains "demo" && input.I_want.contains "supportcenter" ) { openUrl("http://www.manageengine.com/supportcenter","same window"); else if(input.Sexe == "M") { openUrl("http://www.manageengine.com/supportcenter","same window"); } }
Auto populate fields (or pass data) between a form and a view via an Action Button
Greetings - I have a question on passing data between a view and a form. Currently, I have a Member view that lists all Members with their first/last name, address, etc. For each record, I have created a custom Action Button of "Add Donation". When the user selects the "Add Donation" button, a popup form displays, allowing the user to enter donation information. On this Donation form, I would like to auto-populate the Members First and Last Name, carried over from whichever record they chose
XML-RPC / CSV-RPC Has Stopped working in ZOHO Creator
A few hours ago, the Zoho Creator API has started returning empty responses. The application has been working for over a year now - so its not a code problem on my end. I receive the ticket ok - but no matter what type of call i make (add/updated/edit) - i receive an empty response Is anyone else having this problem? I'm using the xml-rpc post method also tried csv-rpc. Both return Empty <response></response> no matter what query I attempt to run I setup test queries on my application via a standard
HTML view not working with IE 7 or IE 8
Hello. I created some simple tables and am bringing text as a string from some of my scripts into an HTML view and it doesn't view properly in Internet Explorer (IE just shows a blank page) but it looks right on Firefox. QUESTION?> Is there some specific settings to make these HTML views work on all browsers? My clients use a mixture of IE and Firefox. I need my apps to work on both. Any help would be greatly appreciated. Thanks. Update: I get this script error with IE version 8 Webpage error details
Email data
Can you email data to a private database or would it only work if the database was public? Thanks, Leo Saumure
Autofilter Lookup field Checkboxes
I am trying to create a way to keep track of a deck of flash cards I am creating. The cards will each have a letter sound (and the location of that letter sound in a word) associated with them. For example: fish - beg f face - beg f dress - end s snail - beg sn I have two forms Card_List and WordsSounds which is a list similar to the one above... just much longer. When you enter the Card Sound on to the Card_List I would like it too look up all the words from WordsSounds that match that sound, then
problem with form validation
Hi all, I'm writing my first few bits of script. I want to validate a form that has two drop downs. If the first drop down is not set to a value from the list (ie it must not == -Select-) then the script should show an alert then cancel submit. If the first drop down succeeds then test the second similarly. What ever I do the first drop down fails. I always get a message in the status bar of the form with my error message. My condition looks like if ((form.field != "Option 1") || (form.field
Copy Form?
Is there an easier way to copy a form than pasting the majority of the script? It seems with Formsite and GDocs it is just a given to have such an ease of operation. Is it something I am missing or is it something that would bring my app down in flames if it were there?
Please help: Boolean expression to show who should be in attendance...
I have a list of participants, they have 5 checkboxes on their record signifying Monday through Friday. I also have a form for attendance. I would like my attendance for to simply have a yes or no next to the participants names'. What I can't figure out is how is how to display their names with a yes or no radio based on if they are supposed to even be here on the given day. For example, if today is Tuesday and I have 5 participants schedule to attend on Tuesday, and 7 total (2 not scheduled for
Snake eating it's own tail?
I could be wrong but this seems like it could be really bad. Does not Zoho worry that by having a marketplace where developers can quote, build and charge you for their knowledge it could hinder the concept of public applications let alone community support? I mean I have many questions about how this system works and I worry that little if any will get any attention from people who know what they are doing, if I knew I would certainly sell my services and feed my children than give away the knowledge
Freezing Screen when trying to access With Action - Free Flow Scripting for a Form
I can access the free flow scripting for a form and all other actions, except for with action. Everytime I click on this link my window freezes. There is scripting information within this link that I need to view. Is there another way to access the scripting information?
Autofilter Picklists
Hi - I currently have a form, called form1, with a last name and first name lookup field. The lookup fields arepopulated from a single line field on another form, called form2. I am trying to figure out some scripting that will allow me to have the first name lookup field, on form1, autofilter so that when a last name is selected only the corresponding first name will be displayed. (For example, if I have Bob Jones entered on form2, then when I select Jones from form1 I want the first name lookup
Any suggestions for Zoho Creator Application Development Form, View, & Function Naming Conventions
Hello. While considering that good and proven software development techniques utilize some form of standardization of naming conventions database methodologies I'd like to know what the Zoho Creator user community is using to make their development projects easier in order to conform to naming standards and database normalization. This is what I'm planning to use for naming conventions (for the actual "link name" as the form will have its regular name in the "XXX" part of the form name): Forms -
Combining Zoho Creator and other Zoho Apps like Zoho Forums, Invoice, Business, Share, Wiki, etc.
Hello. I'd like to know if any of the Zoho Creator developers out there are using Zoho Creator with other Zoho Apps and how well they interface together in allowing bi-directional communication (whenever possible). My interest in this is due to that fact that I don't want to reinvent the "wheel" so to speak if a Zoho App already provides the functional capabilities. For example, I have functional specs from a client that requires a Web Application where the majority of it's functional requirements
Experiments with some built-in Map and Field functions ...
In this post ... http://help.zoho.com/portal/en/community/#Topic/2266000000625224 ... user srhyne (Stephen to his friends) mentioned ... Put all your form fields and form values into a map variable WITH 7 LINES OF CODE! fields = getFieldNames(); form_map = map(); for each field in fields { value = getFieldValue(field); form_map.put(field, value); }Being the "push the envelope" kind of guy ... my immediate thought was ... Can we reduce this to just one line of code ? What if you could create a User
How to Embedd a view (filter by the the form input) into the same form (stateless)?
I have a form called Tasks and Bits I can do: I would like to create a stateless form that has one drop down box which displays all the the task owners. When the user selects an owner from the drop down box I would like the form... Bits I can't do: ..to display a list of the tasks where the owner is euqal to the one the user slected in the drop down box. I though this could be done by embedding a view of the tasks which had been filtered dynamicaly, but I am not sure how to do this. Hope someone
How to do if condition on a list box string list
A form with a checkbox called "I_ want" with 2 options, "General info" and "call back" and with a checkbox "product" with 2 options, "supportCenter" and "Servicedesk" I need help for the IF statement where "I_want" is a string list based on 2 selected value out of listboxes he/she is redirected to a URL On submit I want to have a script if (" info " in input.I_want) and input.product == "supportcenter" { http://www.manageengine.com/supportcenter ( then go to) else if (" info " in input.I_want)
Add a button that link to a form for people to fill in
My application involves a list of job records with a 'Apply This Job' button for each record. I know there is an example in Zoho Creator where you can add define a function that sends an email How do I go about doing the same except that this function will bring user to a form with pre-filled data? Thanks in advance
currency problem
Hello, I'm trying to build my first database. It's a database that I want to use to compare different fishing boats. I would like to put different form field, like: boatyard name type of boat lenght weight .... price I have a problem with this field because I have prices in $ and €, how can I put the numeric value and than select the currency? I would also like to build an automatic converter $-€. I tought about creating a new form with a numeric value for the change and than use a formula for the
How send SMS from ZC
Hi Yoge I have read your blog for "How to send SMS from Zoho Creator apps" and install the script (.ds file) ,but still don't know how Replace those parameter, so I give your my third-paty SMS provider information,hope you give me instruction one by one (my account and password sent you by email) The Information as bellow and waiting help Thanks Stanley Guo Third-paty SMS provider information as bellows 3,Short Message Service HTTP protocol access instructions Smart express letter of the API
ZOHO CREATOR
Hello to all. I've create a zoho creator applican, whit inside a choice list whit the date. www.bee-tse.org When the people fill my form on succes will receive an email. How I can send different e-mail differs according to the chosen date. For example after the choice choice a: Ok. Presented in Rome Choice b: Ok. Presented in Milan THANKS IN ADVANCE Laura
Formula field to Count specifc
I need help writing the Deluge script for a Formula field that counts the number of records from another Form. ------ I need to count the total number of records on a Form in my Application that meet certain criteria. The field is not from the same form as the Formula field so the Deluge script will have to reference which script has it. i.e. Count the number of records in the 'Donors' form where (Status == "Paid").
Fetch Record: select from two different forms
I am creating a donor form. I already have a member and a constituent form (two separate ones) -- they need to be separate. I would like to use one ID code from the member / constitutent code to fetch a record from either form. Here is an example: MEMBER: Student Jane, ID 33333 CONSTITUENT: Benefactor Organization, ID 22333 Member donates $50. Constituent donates $100. In the DONOR form: I want to fetch either Member or Constituent in one field and have their address record show up (just address,
Payment Information: Amount split to different codes
Is it possible to take one amount and divide its purpose among several categories? I have my donations divided into CATEGORY & CAMPAIGN. My example: Donor gives $260. $200 is for Annual Fund, $30 is for Merchandise, and $30 is for Supply Donation. Is it possible to split one entry into 3 allocations without having to create three records>
Formula field to pull value from another form with specifc criteria..
The Lookup field only allows me the following types: Dropdown, Radio, Checkboxes, & Multiselect. I need the ability for a Formula field to pull a single, specific value (text, number, etc) from another form based on specific criteria (i.e. ID == ID). How can I do this? Is it possible via Deluge scripting?
Zoho Web Developer
Hello I think Zoho Creator is a great enterprise application generator (EAG). I think it could also be the basis of a great web application framework (WAF). As an EAG, I think it pretty much hits the mark; I don't think it needs much more. As a WAF, I think: its pricing is inappropriate, it needs some payment processing features, and it would be a good idea to better leverage Google's App Engine. I suggest Zoho introduce a new product, perhaps called Zoho Web Developer. This should have all the features
Integrating existing application in to Zoho
Hey guys, hopefully someone can answer this question. Pretty new to Zoho, so just poking around. I have a PHP app that requires users to authenticate with a database. I want to be able to add this app to zoho for other users in my group to access. It seems like my app runs in an iFrame on zoho, so my question is, is there anyway for me to bypass authentication and use Zoho authentication of the user that is currently trying to access my app. In other words, user clicks on my app from within Zoho,
How to Alert the User on whether their Web Browser is a Supported Browser
Hello. I'm interested in writing a script within an HTML view or within the html coding of the View to notify the user of whether or not they are using a "supported browser" on my Zoho App.(I got over 100 Zoho users on my App) I get a lot of help desk calls and most of them are related to unsupported web browsers such as Safari & IE version 8. Any suggestions for this would be greatly appreciated. Thanks.
Criteria for embeded view: how to implement 'many-to-many'?
I have an html view in which I have implemented deluge script to fetch a list of cities from a certain "Form A" record (multi-select field). Below that (in the same html view) I want to embed a view that shows all "Form B" records where at least one of the selected cities are the same (Form B also has a multi-select field with cities in it). Is there something like: <div elName='zc-component' viewLinkName='TestView' params='Cities={London:Paris:New York}&Cities_op=99>Loading View...</div> where 99
Issue with date format when importing data
When I import data into an existing form, the import defaults to assuming any date is in a dd-MM-yyyy format, and sets the format to MM-dd-yyyy if it detects that the date is invalid in dd-MM-yyyy format but is valid in MM-dd-yyyy format. For example, if I import the following data:Transaction Date Transaction Amount 9/5/2008 52.39 9/12/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39 Zoho puts the data into my form as: 5/9/2008 52.39 12/9/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39
having created form sent
ok here is what I am trying to do: I created a sports registration form that I embed on my website. The goal is to have a parent of a child access the site, fill out the registration form, and then have a copy of the actual form get emailed to the person who filled out the form, as well as to the treasurer of the association (we are a non-profit church group). So far, I have been able to have the form filled out and the database updated without a problem. I believe that I have the access so that
Make it stop!
I have a simple "on user input" invoked function to make some text conform to a standard. input.RMC = thisapp.inventory.RMC_CHECK(input.RMC); It works, but the "on user input" keeps running forever (little spinning arrow next to input field). How can I specify this function to only run when a human changes the input field, and not when the function itself acts on the string in the field?
New String Function
Here's a simple request to compliment the built-in string function: xyz.removeAllAlphaNumeric() Please support: xyz.removeAllNonAlphaNumeric() Thus "OUCH! I banged my little @#$% toe!" would become "OUCHIbangedmylittletoe" Thanks!
how to create an editable multi select dynamic picklist?
for example dynamically create a books_i_like picklist from all the books. then allow a person to check and uncheck their selections without destroying their previous choices by rebuilding the picklist.
multiple pop-up windows / dialogs
Hi, I wondered if it's possible to have a pop-up dialog on top of another pop-up dialog? I've tried this myself, and it seems to have some odd behaviour. So I'm guessing it's not valid, but I just wanted to double check? Here's what I did: I created a view, with custom actions. The custom action is to pop-up a view (as shown in the attached picture). The pop-up view *also* has a custom action, which is supposed to pop up another view. But this second pop-up just seems appear momentarily, and
Strange behaviour on HTML embedded views that receive params
Hi all! I'm making an HTML view called 'Test' within 2 embeded HTML views. Both embedded HTML views are the same HTML view, but receiving diferent parameter values to print. See the code below: htmlpage Test() <%{ <div elName='zc-component' viewLinkName='HTML_view_A' params='message=FirstMessage'>Loading View...</div> <div elName='zc-component' viewLinkName='HTML_view_A' params='message=SecondMessage'>Loading View...</div> <%}%> And htmlpage HTML_view_A(message) <%{%> <%=message%> <%}%> Ok,
Disabling the standard edit and view links in a view
Hi, I badly want to know how I can hide the standard edit and view linktext in a view. These linktext always seem to be present in a list-view. I do not see some settings to disable those (and I need this because I want the users to edit the recors via a function via Edit a record via Record ID). Or is this dependent also on whether you are an admin of an application? Any help is appreciated. Kind regards, Silvester
How to show a field that is in another form?
On Add, I would like to add code that will allow me to Show and Enable a field from another form. When I select the Show option the pull-down menu does not display the fields from another form.
image loading is very slow
Is there a problem with the loading of attachements as the service is very slow, and is almost unusable due to the process. It actually appears as though it stops. Can you advise please? dp
When using IF I want to use the or function for a set of inputs but cannot make it work
When an input is made on a form and on field actions on user input I want to set a set of or conditions if (input.Key_post_code_area == "AB") however, I cannot make this save, and have had to add it condition by condition, which slows the process. Can you help? dp
Next Page