Help with "Average" Aggregate Function
Hi all: I'm new to scripting in Deluge and have a question: How do I fetch only related records located in a sub-form (a.k.a. a related form) and then calculate the average of a specific field in that sub-form? Specifically, I need to know how to write the "criteria expression" part so it only finds those fields related to the parent form (not all records). I'm using the Fetch Records drag-n-drop function wizard. The pure Deluge Script syntax is... //to find the average of a numeric field for specific
Pass parameters to ZC form or view through the ZC html view page？
Hi In the html view page, when click on a link or an image, can I pass a parameter to the ZC and then open an existing record？ or have any suggestions? Thanks Stanley Guo 2012-1-12
problem in view for string with spaces
if in form there is a string with a lot of spaces results is trim the spaces ... example (field lormula in form that format string to fix length): "Name: " + Name + " age" + age ; result: Name: Peter age 30 Name: Augusto age 35 ---------- i like: Name: Peter age 30 Name: Augusto age 35 Ruggine from Italy
On Update on Add does it make sense
Hi just trying to get my head around this When you first add a form how can a field "On Update work", there is no reference to be updated ? maybe i am missing something and need to stop working so late
Setting CRM "Contact lookup" field value
Hi, In our CRM, we have added several custom fields in Solution entity. We have added a Contact lookup field. Then, we try to populate Solutions from a Creator Form via script, after creating, programmatically too, the Contact. We do something like this: c = map(); c.put("First Name", input.First_Name); c.put("Last Name", input.Last_Name); // other fields... i = zoho.crm.create("Contacts", c); // error treatment... s = map(); // other fields... s.put("Contact", input.First_Name + " " + input.Last_Name);
Suggestion - form template
form: optional header for SubForm fields .... or SubForm fields .... or SubForm optional footer for SubForm
ZC and GravityForms? Has anybody done this?
I'm considering buying the GravityForms wp plugin to easily make better looking and more functional forms, and I'm wondering how easy it will be to integrate this with ZC forms. Has anybody had experience using ZC and gravityforms together? I figure the GravityForm will either Post to the ZC form, or perhaps send email to ZC form. Any thoughts, suggestions, or examples of past experience would be very helpful. Thanks in Advance
OpenURL error: Passing arguments
G'day, I request assistance with an error associated with the following code. I suspect it is trivial. I send 2 parameters from a form to a HTML view using OpenURL: ((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#View:Boys_Search?searchParam=") + input.Choose_your_city + "&searchParamD=" + input.When.toDate("dd-MM-yyyy")) Possible errors: a) Syntactical error in how the two strings are being passed. b) Because 'When' is infact a Date field, toDate() function is redundant. Would greatly appreciate
View Enhancement Shared user Select box is no longer visible
I allow my shared user to add and to edit records....the select check box is no longer visible As admin i see the check box problem is in FF and Chrome Am i imagining this === Maybe i had the checkboxes there before because this view had functions..which are header based and which do act on a record
relative URL for image display in Marketplace demo?
In reference to the demo mode in Marketplace, this thread says that "the demo works only if relative urls are used and breaks when full url(starting with /<username >) is used." As documented in many places, I am using the "https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=titleImage%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Books_View" technique for displaying images that have been uploaded using the application I have developed. Of course, everything works
How can I display fetched records?
Seasons' Greetings! I am new here (see question). Would appreciate assistance with the following: - I have a stateless form with a 'Find' button. - On clicking 'Find', I fetch records from another form and store it in a variable. - How is it that Deluge allows me to display these fetched records? Thanking you in advance, inclininwirefree
Waiting Time on Click
Dear Sir/Madam I have assign a "Alert message" and a URL for next form in one Stateless form of my application. But once the user click, the form directly jump to next form. Waiting time for reading success message is very very less. Could somebody tell me how i can increase this waiting time after Click a stateless form Shiv
Sub form info in email
I have a simple form that has a sub form in it. I want to be able to send the information captured in sub form in an email, on submit of the parent form. But all i seem to be able to do is submit the IDs of the Subform records. Can someone please help this has taken me way to long and it seems like an easy thing to do.
Application functionality Stopped Working
I have arrived in my office this morning to receive multiple complaints about the changes you have made to the creator views. Some of these changes are truly awful and as I do not read the zoho forums on a regular basis, I had no idea that they were coming. I also have application functionality that no longer works which, barring a ridiculously improbable coincidence, must be the result of the changes you have made. You must reverse these changes immediately and give your users time ( say 1 month
Cant duplicate my project
Hi, I have problem duplicating one of my project, the project name is "Bilgain Transport Management" , i have allowed access to my apps, pls check it out. Thanks
Alert Function: Comma Invokes Two Windows
Alerts in both IE 8 and Chrome 16.x are showing as two pop-ups when the alert text contains a comma: alert "You have already entered hours for this activity on this date. If you need to edit the hours, please view your personal snaptime calendar and take the appropriate actions."; John M. Whitney
Email
I'm new to ZOHO and am looking for some help/assistance, for which I am happy to pay, if necessary We are using the product in its simplest format, a basic contact screen where are sales people call a prospect and from that there is an action required - the sending of one of say 5 different emails to the individual contact. How do I achieve this in ZOHO or is there someone out there who can help with the script. I need to be able to record within the record which email has been sent and the date
Record ID Link problem
Dear Sir / Madam I have passed below link thru mail to the user. I want user edit his record only. but when he clicks this URL the user id not capturing in the address bar, which resulted system showing "There is no such form in Zoho Creator" https://creator.zoho.com/hpclmittal/hmel-transport-tender-application/#Form:Transport_Tender_Application?/recLinkID=915357000000047453/&viewLinkName=Transport_Tender_Application_View Please help urgently and suggest if there is another code for this.
Is it possible to create Personal Custom Templates for Forms and/or Applications?
I would like to know whether users may create personal custom templates of Forms and/or Applications? With Applications, while I am aware of the copy function, this only works within the specific application type, e.g. if I have created a Personal App, I may only copy it to create a new Personal App, and not a Workspace App. Any information is appreciated ~ thanks!
Record ID
Dear Sir / Madam I have created a stateless form in which the applicant registered himself by entering data. As soon he submits the data a record will generate with ZOHO unique Record ID. I want to know how this Unique Record ID will directly communicate to the applicant thru his email id as soon as he registered himself. Thanks Shiv
Display null as " 0 "
Good day Zoho Gurus, I have this in an html filter: <%for each x in VAR_Staff { Person = x.Short_Name; HoursTotal_0_7 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '1W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours); HoursTotal_7_14 = Packaging_Process_Person_Workload[(Staff_Name == Person && (Due_Date <= (zoho.currentdate + '2W:0D:0H:0M:0S') && Due_Date >= zoho.currentdate))].sum(Estimated_Hours);
How to create an invoice in CRM with multiple items ?
Hi, I'd like to create an invoice in CRM with multiple items. Here's my code. void CreerFactureZohoCRM(string NoFacture) { f = Facture1 [Numero_de_facture == input.NoFacture]; c = Commande [Num_ro_de_commande == f.Numero_de_commande]; itemsList = List:Map(); for each i in Axis_Lignes_Commandes [No_Facture == input.NoFacture] sort by Produit1 { itemsList.add({ "Product Name" : i.Produit1, "Quantity" : i.Quantite, "Unit Price" : i.Prix_selon_format, "List Price"
Creating a Pricing/Sales Form
How can I create a simple pricing form using drop down menus to generate a total once items are selected? I'm not looking to create a invoice form, but more like something a sales agent can use to generate totals for a product efficiently? Here is an example: Products: - Test A - Test B - Test C User selected "Test B" Quantity: - 1 - 2 - 3 User selected "3" Shipping Method: - Ground - Overnight User selected "ground"
Image / Logo in the Form
I tried to Insert "Logo / Image" thru Add Notes by I am unable to add. Could some explain me how i can load the logo or image in the form
One Record Thru multiple stateless form
Dear Sir / Madam Could any body tell me how data input by a single user thru various stateless form (Which are the parts of a single Application) stored as a single record. Eg. If I input data thru a single large form, then only one record will be created. Please help.
IE9 Security warning
I have a webview embedded on a website. It is working exactly as expected in Chrome and FF. Unfortunately, in IE9, it is prompting a security warning. It is also refusing to download all content without the user agreeing to download "unsecure" information. This is a huge issue! It is imperative that the use of Zoho is transparent to the user. If they get prompted about a security issue, a lot of users are likely to go away. How do I prevent this from happening? Please don't tell me to change my
Ticket Zoho Creator
Hi, Where I can found the value to Ticket? Is a same value that the SecretKey? Tks
Summary view show only 1 record on website
How do I get Creator to show only one summary record pasted and shown on my web page ( I can only get 10 per page at the moment) and for it to delete the previous data every time you put new data into the form. (So that it only shows the last record). is this possible?
Upload & Download a File
Dear Sir / Madam I am creating an application form in zoho creator, in which i would like to attached/upload a file which eventually applicants download and after filling required data again upload in the form. Please help me how i upload and download the file
Can't create Applications on Workspaces
I would like to report this problem, the strange thing is that with one workspace I can keep creating Apps, but not with some other, account admins said nothing is changed...
views, hidden columns and Marketplace demo
Hi Forum, Recently I tried to upload an application that I developed to Marketplace. One of the problems I discovered is that views are not displayed as configured in my application originally. For example, many of my views have images displayed. In order to display an image properly in a view it is necessary to have both the field that contains the image name and location as well as the formula field that renders and displays the image. Of course I don't want the image name and location field
Selecting Last Entered Value as Lookup
Sorry if this is a basic question, I'm a noobie to Zoho. To simplify- I have a Form1 that has the fields, Date and Weight On My Mainform, I want to populate a "Current Weight" field with the last Weight that was entered on Form1 (Which should correspond to the record with the most recent Date,) How can I do this? I can have a dropdown box appear with Date and Weight displayed for the user to manually select the last one, but how to automatically populate the "Current Weight" field ? What is the
Enhancements to view actions.
I really don't like how view actions buttons are currently implemented. Here's the way I've been building them lately. and here's why! 1. They are located next to the other actions rather than Alllll they way to the right of a view.... The buttons become tedious to use when you have many columns in a view. Sometimes they remain completely off the page on the x axis so you have to scroll to the right. Let's get some Fitt's Law love and have you guys give us the option to move the actions to the
Can I give edit/delete access to specific users only, not all users?
I would like to give edit/delete access in a view to specific users in my application. Lets say I have, two users A and B and the view 'Employee List'. I would like to give edit access to this view to user A only. Is this possible? If I go to 'Set Permissions' and select option to allow users to 'Edit Records', it does not let me specify which users should be granted this access and it is given to ALL users (A and B). Thanks for your help! Jose
Logial way to check each colum in a row
I may have asked this before, not sure if anyone has found a better way. Lets say I fetch a row into a collection called "therow" I need to now check each column in that row, so I make make my way left to right if "therow.C1"........ if "therow.C2".... if therow.C2" I have 50 columns what i need is a "therow.C1+ 1 next column statement or to have therow.C1 replaced as a variable which i can build Any ideas from anyone ? thanks
Need help defining function for referencing fields from other apps
What I am trying to do: I need a form in my remote app to filter a lookup dropdown field based on the records from another master app. Ideally, it would work exactly as my on add and on edit scripts work in the master app. The current script used for that is: if (count(Tour_League_Division_Conference[Series == input.Series]) == 0) { clear Tour_League_Division_Conference_Name; } else { rec_TLDC = Tour_League_Division_Conference [Series == input.Series] sort by Name ; Tour_League_Division_Conference_Name:ui.add(rec_TLDC.Name.getall());
Update Record clear check box values
hi In a function i have retrieved a record, now i want to update the record and clear some check boxes which are checked cant seem to figure out what value to write to the record.. do i have to build a blank list first maybe ? Thanks
excel formula to deluge ..base-10 logarithm of a number
my formula in excel reads =5.8-(1710/(273+$C4))+0.67*LOG($H4) $C4 =Operating_Temp_C, $H4 = Fugacity_CO2_(kPa) which becomes 5.8-(1710/(273+Operating_Temp_C))+0.67*LOG(Fugacity_CO2_(kPa))but I can not get the LOG function to work I have tried log() …….Format:<numeric>.log()……. Returns the logarithmic value (LogeN) of the specified number. 5.8-(1710/(273+Operating_Temp_C))+0.67*log(Fugacity_CO2_(kPa)) but with no luck and LOG10 …Returns the base-10 logarithm of a number…..LOG10(number) ……Returns the
More Fun with Lists
This is a continuation on topic https://help.zoho.com/portal/en/community/topic/proposing-a-new-function-for-lists-remove-duplicates In this case, I'm attempting to find the intersection of two lists. For example, List_A = (a, b, c, d. e) and List_B = (c, e, f). The intersection of List_A and List_B is List_C = (c, e). In PHP, one can do this: $List_C = array_intersect($List_A, $List_B) But we do not have such functions in Creator. Now imagine a database where we have 100's of "List_A" records that
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?
Next Page