Sub-Form help required
I need some assistance please with the new sub-form facility. I need to create an application to record jobs, and be able to allocate those jobs to certain people or vehicles. I would like to be able to view a certain person or job, and have a sub-form display the various jobs allocated to them, I would also need to be able to re-assign jobs from one person or vehicle to another if required. Can anyone tell me if the above scenario is possible, and if so give some pointers as to how it can be achieved.
dynamic picklist problem
Hi, I have just noticed a problem in my dynamic picklist recently, let say I load a Vehicle No picklist from form B with the criteria of matching date. The vehicle no in form B is not unique and it can show up in different date. Supposed I selected a vehicle no ABC 1234 of 4/12/2011, this vehicle no ABC 1234 also showed up in various date before. When I clicked the link to view the record in View mode, it will show the vehicle no ABC 1234 from another date, instead of 4/12/2011. Is this a bug or
Popup a verification screen from the function?
I have a function that is called as a Custom Action on each row of a view. The function makes a change to a field in the corresponding record. I would like to display a message for the user giving them a choice of OK or cancel. Something like this "You are about to change information for John Jones. Press OK to continue or Cancel to not make the change." Is there a way to popup a verification screen from the function? Herb Wexler
FIELD UPDATE WHILE FILLING FORM
Dear Sir / Madam In my form, There a some checkbox, I want when applicant start cliking the check boxs, one another fild start counting number of checks. based on the number of checks I would apply a formula in another field. Please help
HTML View: Sort by parameter passed through URL.
I have an HTML view in which there's a for each record in form loop. Now I'd like to sort these results by a parameter passed through the URL. For example, if ?sort=name is passed on with the URL, I'd like to execute the loop for each record in form sort by name. Is there any way to implement this directly instead of performing consecutive if - else loops containing the same piece of code, except for the sort by parameter? E.g. for now this is implemented like this : if ( input.sort == "name" ) {
contains() function inconsistencies - case sensitive in some cases, not in others
Hi, There are two other threads discussing this situation but I am not seeing any responses from Zoho support so I am consolidating these discussions here. My original post generated this thread and led us to include this other thread in our discussion. With some thorough testing Gaev discovered that, "Looks like .contains("xxx") is NOT Case Sensitive when applied to Collections ... otherwise it IS !!! Please respond to this. Thanks again for your excellent support. John
contains function is case sensitive despite documentation stating otherwise
On this help page:https://help.creator.zoho.com/Built-in-Functions.html ...the following is stated: A function is a set of code, that takes a finite number of input and optionally returns a value. None of these functions are case-sensitive. However, it turns out that the "contains" function is actually case sensitive. This caused me to waste a lot of time debugging the wrong parts of my scripts over the past few days! Anton
views and hidden fields
2 questions: 1. I duplicated a number of views based on a view that appears under the View button. For some reason the duplicated views are appearing under the Forms button when using the application. How can I change the views so they appear under Views? 2. I have a form where I have hidden a number of fields. But when I run the application, they appear on the form. Why is that? Is it because I am the admin? thanks, Ray
TABLE CREATION
Dear Sir/Madam I making a Application form, where I need a table in which the applicant will key-in the data. Please advice how I can create a table. I created a table thru Add Note but after creating the applicant unable to key-in data in that table. If I create table thru Sub form then type of matrix table not possible like 9FT 20Ft 40FT own - - - hired - - -
Disabled RTF the grey box appears below the field
I have a disabled RTF after several fields that are hidden. They grey shading that indicates the field is disabled appears 2 inches below the field. This is about where it would be if the hidden fields were displayed. I have the same result in FF and Chrome. Herb Wexler
Logo in the Forms or at Header Level
Dear Sir / Madam Please advice how a company logo can fix at header or inside the form I tried copy paste thru Add Note but unable to do Please help
Re in view of the number in the format
Hi How can I format numbers in view? I want to the format like 12,345,678.00,but the format always display 12345678.00 in VIEWS even the field is "$currency" also can't with a thousand digits,so it's not easy to read large numbers. I knew that in form and function in a format function can be used to solve this problem, but I do not know how to solve this problem IN views. Thanks Stanley Guo 2011-12-22
Backreference in replaceAll()
Is there a way to refer back to the search statement in the replace statement of the replaceAll() function? For example, I want to search (case-insensitive) for "abc" in a given string and replace it by "<0>" + found string + "<0>": "xxABCyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>ABC<0>yy" "xxabcyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>abc<0>yy" In other programming languages this is realized by creating a capturing group using round brackets
Adding multiple records to different forms based on calculations from initial form
I have a form (called ServiceRequest) that collects input for services that we provide. The input includes "Start Date" and "End Date". From this, the "Duration in Days" is calculated and a price is quoted (column name = Quote) What I would like to do upon submission of this form, is have it calculate the number of weeks in the duration (Duration_in_Days/7). Using this value, the equivalent number of records would be written to the table named (ServicePaymentCalendar) passing with it prorated
Upload images from an excel to an applicaition
i´ve got an excel that has registries, each one with an image. i want to migrate it to an application that i did in zoho creator but i don´t know how to upload images in the zoho application from an excel. they hace told me to use these exampel: https://creator.zoho.com/yoge_babu1/runtime-calculator/#View:File_Header_View look the attachement . i have´t got to work the example.
Individual Record View?
Hi Zoho, Lets say I have a view of list of customer accounts. Is there a way to break it down to individual view for each customer? so each customer can use the view to check on their account activities. They sure not need to look at other customers ones. I need to put this on another website, so that the customer A can access this view. I tried the "RIght Click" "View" in general view. It opens up in a new window. I need more than just a URL, plus i dont want them to see the whole link traced back
Subforms with the API and User Document Sessions
Hello, I'm inches away from being able to use Zoho Creator as the back end for my clients project. It would really be great if we can solve the following three issues; even with some kind of workaround. How would I go about using the API to submit data to a subform within a parent form as opposed to accessing the subform form directly. I hope that makes sense! The difference is that when adding a record in a subform it, quite rightly, doesn't treat the subform record as a new record but instead a
Reports not updating
My reports aren't always updating when the information has changed. It will be working fine and then all of sudden, it won't update again. I have to create a new report to have the changes reflected. Is this a known issue? Am I doing something wrong?
Can't find 'Deploy in Google App Engine' link
Can't find the Deployment link to Google App Engine, Is this option still supported?
Form Schedule can the record be accessed
Hi I have a form schedule which looks at a record dates in my form and sends me an email 7 days before that date (this works) Now when this record is matched i want to also include some additional fields in the email and also do some updates to the record Question, is there a way to access the record which triggers the form schedule ? i..e does it exist in a collection variable somewhere ? Thanks
HELP in access Data From another Application
Hello there, I need Help in order to retrieve data from one ZC App to another ZC App. Application A has a form called orden, here we track all the contracts belong to a Consultant, so for example I have the following fields: Name (Import file) from other form Contract Number (Single field) .....other fields... In this application one record is created every time the consultant has a new contract. Application B This application have the mission to store each payment for that consultant, so something
How to send hyperlinks to Zoho CRM
Hi, I'd like to send hyperlinks from Creator to CRM (in a multiline text field). The result in CRM is : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> And when I clic on edit (in CRM), I get it : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> This is working well when I copy-paste this code directly in CRM, but it desappear when
Could you please add a COUNT function in the view?
Hi Latha Now the view already has sum functions, can increase the count function in the view? because in the group statistics, only to see the total sum, there is no way to see the total count. Thanks Stanley Guo
HTML Print question
Hi, I've to print an HTML page to print a table : the Table has a bold separation. But when I want to print it, bold disappears. I thought about the browser's option "print background and images" (essential to print colored background) but it's the same.Do you have an idea to print those bold line please ? The style of this border is : <style>tr.bordertop td {border-top:2 solid black} </style> Thanks !
How to send email from a view including record data....
Hello Zoho Team, I want to send an email from a view, in order to do that I have a Function & custom action (Show action for each record), I want to send email only to a selected record each time. Until now I test and it work for plain Text only. Problem that I have is I can´t see how to include the data from the record selected, i.e. the record has Customer field, Prime Contractor field and other fields and I want to inform those fields as part of the message. How can I add field record
No option for Gapp Advanced Field
getting kinda frustrated with this set up a creator account through google apps, would like to have access to gapp user field in creator but its not there. have added/removed gapps, deleted/recreated app, closed/opened new zoho account. followed same steps with different domain, it worked fine. please tell me what needs to be done to gain access to the google advanced field
cross reference values
I have created an app for inventory management for my online sales. I have created a drop down menu for shipping options. My goal is to select the ship type in field1 and automatically populate the cost for that type shipping in field2- rather than having to manually type it in each time. I would also like the option to choose "other" as shipping type and enter my own value if needed. And if shipping charges change, I can change it at the data source... How should I be doing this? As a form within
How do I update the HTML page holding the ifram everytime the iframe reloads?
I have an HTML page holding an iFrame with a form. When the form is submitted, the next form loads within the iframe (i used an openURL function), passing the necessary values with it. However, what i really want is to use a function to open a new HTML page with the successive form and necessary variables. So i guess i would need to pass the variables through the URL string, is that correct? The reason i want to do this is because I am using wordpress and dropping the form URLs in the body. However
Populate field with IDs of related records
Hi, I need to create a new field "related" which is automatically populated (comma separated) with the IDs of all the records which are related to that record. Records are related by having the same value in one or more fields. For instance, I need it to look for value "X" in field "A", and/or value "Y" in field "B". If "X" or "Y" are present in a record, then amend the ID of that record to the list of IDs in the "related" field. I'd be really grateful if anyone can help
Looking for Zoho Creator Developer
We subscribe to Zoho Mail, Docs and Creator. We wish to use Creator to improve efficiency of our services and be able to better communicate with our clients. The project consists of building views for us to enter data and then have clients be able to log into a web page where previously entered information is available to view. I have created a blueprint (mockup) in FrontPage with the basic concept. I do not know the full capabilities of Creator. Thus, do not know if all of the functions that
Overrideable Field with Default Value from Another Form
I'm building a commission calculation tool with some complexities that I'm having trouble implementing. I have a form for entering orders. This has information like order number, total amount, date, etc. along with a dropdown to select the manufacturer from another table. That table just stores manufacturer name and default commission rate for each. I need to be able to put the default commission rate for the manufacturer the user has selected into a field in the orders form so that I can perform
Cannot Delete Application
Hi, There seems to be a problem with one of my Creator applications. When I attempt to delete it, no action is delivered except the message box, and the application still remains confirming delete. Since I had the problem I removed all the content from the application, it's nothing but an empty shell. I'm thinking the application is deleted, but obviously the master database is dirty. Thank you, Mario Stevenson, P.D.L. & TTEE, EQEACT
Where can find Detailed reference manual for class of ZC html table
Hi If use class of ZC html table in html view the table very beautiful,but hope get a complete detailed reference manual, such as： <table class=zc-viewtable> <caption class="zc-viewtitle"> <class="zc-viewtitle"viewrowheader"> <td class="zc-caption> etc... sample for class of ZC html table Thanks Stanley Guo 2011-11-11
Lookup between forms and alert when info found
I am so new to this, I'm a bit lost. I have an application with two forms accessed by two different groups of people. The first group will use the first form (form A) to enter a request for information related to a specific numbered asset (Asset_Name). The second group is logging row upon row of data related to various assets numbers in a second form (form B); they have two fields they use to capture the asset information. The first is a single line text field where the primary asset number
Hide Add button in Subform
Hi , Is there any option to hide the Add button in Sub form. Need to add only one information Sub form ,No need to add more than one information . Please help me out . Thank You
Can someone please help me or its all been for nothing
Hi, OK so here is what I want to do. I have been told that Zoho does not currently have the ability to trigger the add button of a sub form automatically from a script. This feature is vital to my project so I have been looking into this in an attempt to help you with the feature. If I could find a way of implementing the following Java code within a script, it should trigger the add button in the sub form. <script type="text/javascript"> $window.onload = function() { $eval(document.getElementsByClassName
Updating multiple records
I have a new script which calculates risk, which is drawing data from a risk matrix, which contains descriptions, and ratings for likelihood and result, I am using the following script on my two lookups: categoryresult = Risk_Matrix_Risk_Categories [(Min <= (input.Likelihood * input.Result) && Max >= (input.Likelihood * input.Result))]; Risk_Category.select(categoryresult.Risk_Category); It basically looks to see if the result of the two variables, Likelihood and Result lies in the ranges
Existing Data Base access
Good morning, I'm a new user to this site, in the company I work for, there are many kind of existing data bases (such as SQL Server, Oracle, MS Access, Excel, ecct.), can I create a new zoho application (with zoho creator) for an existing db? Is there any type of DB Connectors (using ODBC, JDBC or others)? Thanks Leo
show all rows from xxxx [xxx == zoho.loginuserid] has stopped fetching results in a view
Hi we use 'show all rows from Submit_IP_Topic [IP_Approver == zoho.loginuserid]' to show only items that belong to the IP approver specified in that field. it used to return results and has failed again and will not display anything. am i doing something wrong here? i have learnt that i need to use 'advanced' when you wish to use zoho.loginuserid otherwise it is treated as a value. often if i clear out the filter then reapply it to the view it will start returning values again. cheers
Validation on Radio field contingent on entry on number field
Hi, Can anybody help advice how I can validate that a radion field is selected if a number field is entered. For example: - The form has two fields. One number field and another radio field - The number field is not a required field - The radio field is required only if a value is entered in the number field Please help. Thanks! regards, KM
Next Page