Rolling Average
Hi, I am trying to calculate a rolling 8 week rolling average for several entries that are made on a weekly basis. Each week the following fields are entered: 1. Date 2. Weekly Revenue 3. Weekly Labor 4. Weekly Spread I am trying to take the 8 most recent entries (weeks), and average them out and display the results... Any help would be very appreciated.. Thanks Nick
Import XML
Dear ZOHO, I'm looking for an option that a user can upload an xml-fle (or paste the contents of an XML file in a text-field) and then have it store its data in the ZOHO database with the node-information stored in designated fields. This looks much like the option to upload data in an existing ZOHO-database via CSV or Excel. Maybe JSON could be the answer to this? So it is NOT the option that a developer only once uploads such an XML file, but a regular user. How would I go about it to achieve something
Disable "Add New" Row Feature on Sub-Forms
Hi, Is there a way to disable "Add New" Row feature on sub-forms? Basically, based on the user input on the main form, I want to allow him/her to enter data on the sub-form. Please let me know if there is a solution or a workaround. Thanks! V
Creating work assignment app
I am working on an App to track work orders completed by an empoyee. I would like to keep my data in four different tables. Is this the best way to go about doing this type of app? I am planning on using on using the Johnsmith, PropertyName, UnitNumber field as look up fileds. Please advice and any guidance would be greatly appreciated. My goal is to be able to track work progress and report on properties adn units that have had maintanence performed and which employee performed the work. ………Empoyee……Propertyinfo……....UnitInfo…………….TaskAssingedTo......
Getting an image out of the field
Before Zoho's API changed a few days ago, it used to be that I could right-click on an image (in View mode) that is in a record to save the image. How can we export or extract images that have been uploaded into the database now?
apps & add-ons
we use the add & app-ons to make cutom form and use send mail field under it.but face a problem after send a one/two mail this field dont give any response..whats the problem arise it so its dont get reply pls solve this problem.. send this to my mail id:parveen@primaryplus.org thanks
URLs not clickable when HTML view is exported to PDF
Hi, I have an HTML view with Print and PDF buttons. When looking at the HTML view, the links look and work fine. However, when the user exports to PDF, the URLs appear in blue (as if they were links) but are not clickable. Please advise. Thank you very much, Kim
Disable subform lookup fields with Search & Auto-Complete not working.
I have a subform with two lookup fields that have Search and Auto-Complete turned on. Under certain conditions I disable these fields in the On Edit -> On Load. However the fields are not diabled unless I turn off the Search and Auto-Complete for these fields in the subform form. Herb Wexler
password policy
This is probably asked in the past, but I could not find solution to that question: 1. Is it possibly to enforce password policy : expire in number of days, or have mininum number of characters set. 2. Is it possible to integrate system authentication with Active Directory, LDAP, Shibboleth, or other SAML-based service for user authentication and password management?
Paypal transaction is being processed Please Wait...
I used the payment option and everything seemed to work correctly. I received a confirmation email from Paypal and even got a confirmation email from my Zoho application. But after clicking OK on the Paypal screen I had a never-ending message 'Transaction is being processed Please Wait Do not close this screen' Is this a problem on the Paypal side or on the Zoho side? I used Firefox. Thanks for looking in to this problem. Herb Wexler
Creator, Reports and Cloud SQL
Hi - I am developing a web application and would like to know if it is possible to send/receive HTTP MySQL data to/from Zoho Creator using a combination of Cloud SQL and Zoho Reports. Since zoho report supports the necessary api calls for the http requests, would it be possible to store all of the data within the reports? From there, could I easily (and automatically) query the data from a Creator application?
how to move php code to formula in creator
hi i have complex formula coded in php by previous programmer. what way is move code from php to code in zoho creator? i need same code in my application
Parameter passing
I am new to Zoho, can any one help me out in the concepts of "Parameter passing". Can any one share the link were do i get the concept clear. I am stucked up very badly.
com.adventnet.workengine.task.TaskExecutionException
Hi, My system return this error for several schedules used to update a form. I don't understand what happened, it was working fine last month. Who can help me? To explain: I've got a form A and a form B. I import datas in the form B (6200 records) and I use this records to update monthly the records in the form A (6200 records too). Because of the limit of executable statements per deluge action, I use form schedules delayed in time (2 minutes) to detect the import of data and update some fields
Populating a picklist with values in another form
Hi Guys, It's been a while since I've done this - can you assist please? Form1: 'Job_Numbers' Has two fields 1) Job_Number & 2) Client (lookup) Form2: 'Job_Elements' Has two fields 1) Client (lookup) & 2) Job_No (lookup) I want to populate the lookup field Job_No with the Job_Numbers stored in the Job_Numbers form where the client is equal in both forms. I hope this makes sense. Many thanks, Martyn
Formula field does not work on currency input?
First , I tried to create a formula field with a Currency field as input... it does not work? Second, how to round up the calculation result in a Formula field to 2 decimal points? Thanks a lot folks ! Love your apps!
Printing Current Date With View
Hi, I am wondering if there is a way to add the current date to the title or header of a view. I would like to have the current date appear at the top of a number of my views when they are printed. Thanks, Emma
Problem deleting record(s)
I cannot delete record where branch name == "junk" from https://creator.zoho.com/mllwydberger/#view:company_info_view I am in the middle of experimenting with converting an existing database with lots of relationships. Today, I also could not delete records in a form with multiple lookups after I uploaded the same record multiple times to do testing. That time, I just deleted the form and started over. As for the record listed above, I think I created the company form the first day I started playing
Unable to see Customer Table when creating a New P.O.
I just got this problem. When I try to create a new P.O., I suppose to search customer from a Customer Table. But now when I select the table, I am not able to see the list of customers. Please help!
Excel formula to Zoho Creator formula
I am trying to replicate this Excel formula into Zoho Creator; but it's not working. Can you take a look for me? =IF(INPUT>2000,(INPUT-2000)* 5%+2000*0.07,IF(AND(INPUT<=2000,INPUT>500),(INPUT-500)*7%+500*0.1,IF(AND(INPUT<=500,INPUT>100),(INPUT-100)*10%+100*0.14,IF((INPUT<=100),(INPUT)*14%,0)))) It works fine in Excel.
Dynamic Form Embedding
I join the request for RTL support in Zoho Creator - especially critical for me in form embedding. Another possibility is to allow users to add ANY html code before and after the form is embedded, this will allow us to change direction (and also fonts, css, etc).... This would allow us to insert a <div dir=rtl align=right> before the rendered code, and </div> after.
Can't Update data in CRM through Zoho Creator
Hello Zoho Members and Programmers I am created an application which puch data in Zoho CRM Contact module, everything is fine data is successfully stored at both locations Zoho CRM and Zoho Creator. Now i want that when i am edited any data row in Creator then corresponding Zoho CRM contact module row is also updated. So for this i am follow following post: https://kbase.creator.zoho.com/crm/how-to-get-the-id-of-the-crm-record-that-is-created-using-the-zoho-crm-create-task and use following Coding
How to send a filled form in my own email
Hello, I am new to this so all help is welcome. I have succesfully created a form and posted it on my web site. How do I get the filled form into my email and not into the Zoho creator Contact View. I trired changing the set email notifications, the TO: email in to my own but I still do not get the filled form into my own e-mail. What am I doing wrong? Thank you for taking time helping me, Erja K
Tell a Friend about Zoho Creator - Win Cash Rewards!
A lot of you have used Zoho Creator for building your customized business applications. Some of you have also told your friends and colleagues about Zoho Creator and how simple it is to conjure up a custom application in minutes. Thank you, each and every one of you, for spreading the word on Zoho Creator's awesomeness. Here's one more reason for your to continue doing this wonderful deed. Presenting the " Tell a friend " program. Tell all your friends about Zoho Creator - its simplicity, its many
Counting Checkbox selections?
Hi, I'm trying to count the checkbox selections in a form and then use the result to calculate a currency amount and populate another field with that amount. I have a checkbox list and in its On User Input event I have: NumSigs=0; for each r in Members { NumSigs=(NumSigs + 1); } input.Total=(input.SIG_Fee * NumSigs); This works a little, meaning intermittently, but not consistently. When I put an alert on the NumSigs=(NumSigs+1); line, I consistently got an alert that said NumSigs was "1," "2," and
Print HTML View - Suppress Header & Footer
Is there any way to either suppress the headers/footers when printing an HTML view or to set a text value to be printed?
View
Hi, Can a "View" be customized based on user's login id? Basically, I want a user to see info related to his user id only on the view and not about other users. Thanks! V
Schedule criteria not saving
Hi, I have a decision box on a form for sending out a task reminder 10 days before the event and the schedule code looks like this: Task Reminder { Execute on 10 days before of Tasks[day_reminder == true].Due_Date at 01:00:00 } It saves fine and no errors appear but when you reload the schedule page it changes to this: Task Reminder { Execute on 10 days before of Tasks[day_reminder].Due_Date at 01:00:00 } Need to get it run the script only when the decision box is ticked..... Any ideas? Thanks
Application Ownership
I have added an administrator to my account who created a new application. While my current account states I have 10 user capability the application the new administrator created says it can only share 3 users on a free account. Since he is an administrator on my account shouldn't it be possible to share with all users? Thanks Bilmathis
Subforms on views attached to scheduled emails shows record ID
I have a form with a subform which shows correctly in a view. However when the view is attached to an email as a PDF in the schedule system the column only displays the subform record ID. Herb Wexler
CASE INSENSITIVE EXAMPLE PLEASE
I don't know coding and i would like someone to post an example of the contain() functions. i want the search field of my stateless form to be case insensitive.
Creating full-fledged app with Creator
I've set up a basic Creator application, with several tables. It's intended to keep track of application specs, functional tests against the specs, and defect reports. However, it's unclear where I go from here. I'm used to doing database apps using C# and SQL Server. I realize that one option would be to keep using C# and the Creator API to manipulate the tables. But I'd rather do it all in Zoho. So I'd appreciate help in getting started. Maybe there's a tutorial I've overlooked. Anyway, here's
crm.create doesn't seem to be working for me
Hello, thank you for your help in advance I am trying to do a simple zoho.crm.create("potentials",map) I have placed the script under the submit onclick button, but when I look in the crm I do not see the new potential added. Any help would be greatly appreciated (I also have it so you can edit the application already) it is under test/add_potential this is how the script looks NewOpp={ "Description" : input.Plombier, "Nom de l’Opportunité" : "Test!", "Nom du Compte"
Column Widths
Hi, In trying to adjust column widths I'm not seeing any significant decrease in size. I need this app to be as straightforward as possible as I have users logging in that are not very computer literate. Having to scroll through multiple pages of data is going to be problematic. Any help would be appreciated! I'll make my application accessible to Zoho staff. Thanks, Diana
I have two identical (lookup) (checkbox) lists. I need them to have the oppsite selected
Okay, I have 2 fields. Each field is a lookup field that looks up the exact same data in another form. I have them set to checkbox fields. What I need is for them to be opposites as far as what they have selected. Say for example I have them lookup the following data: (A, B, C, D) So the form will look like this (the "X" will represent a checked box and a "O" will represent an unchecked box) FIELD 1 X - A O - B X - C O - D FIELD 2 O - A X - B O - C X - D I'd like it so that whenever you check or
Limitation With Multiple Calls to Function?
I have an HTML view that creates a table with 15 x 10 cells. Most of these cells contain a number that is called from a function. If I include this function-call (line 20), the view fails to load. If I remove it, it works. If I call it just form one cell, it returns a number. htmlpage SUBSTATS() <%{ TABLE = "<table width='400' border='1' cellpadding='1' cellspacing='1'><tbody><tr><td>Mailing List</td><td>Total Subscribers</td>"; for each sec_list in LISTS [LIST_TYPE = "Secondary"] {
Lining up a Decision Check Box
When using a decision check box it lines up to the left edge even when the Field Alignment is set to Right. This makes the form difficult to read. This is the only field type with the label to the right of the data entry portion. Perhaps the label can line up with data entry portion of the other fields on the form. Herb Wexler
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com. Noticeable changes: Short Circuit evaluation is supported in Deluge IF statement - more info OnEdit -> On Validate/On Success actions will get triggered when values are updated through drag/drop action in calendar view - more info Dialogs (eg: alert/warning messages) in IE are positioned exactly in the center of the window Complete change logs are documented at https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html.
Excel formula to Zoho
I'm trying to adapt the next formula from Excel to Zoho but, it changes the formula: This is the formula what I'm trying to insert: 4.6 + (0.182258 * (Kilometers * 1000) / (minutos + (segundos / 60)))) + (0.000104 * (Kilometers * 1000 / (minutos + (segundos / 60)) * (Kilometers * 1000 / (minutos + (segundos / 60))))) And this is how it channge: (4.6 + 0.182258 * Kilometers * 1000 / (minutos + segundos / 60)) Please, someone can help me, I've tried everything.
using payment form
when submit is clicked and it goes to payment, if the payment is not completed, the form still creates a new record. i don't want it to create a new record unless the payment is successfully completed. can this be done?
Next Page