Aggregating data in a view
Hi, I am new to Zoho Creator. Need help solving a simple issue. I have so far worked in SQL only, so here is what I want to achieve in Creator. In the usual employee and department database, I need to find the name of employee in each department who gets minimum salary in his department. I would have written this in SQL to do that. select ename,deptno, sal from emp where sal in (select min(sal) from emp group by deptno) I figured there is no SQL here in Creator. Could anyone help me on how it can
Marketplace Trial
I want to create a trial for marketplace and provide a time or record limit. Is there a canned way to accomplish this? If not, is there an "on load" hook for the entire application? Thanks for any help!
import data from dropdownlist
Hi, I would like to import data from a filed configured as a DropdownList on Form A to a filed on Form B. When I attempt this action I don't get presented with the option to select the field configured as a dropdown list My dropdown list contains street names which i would like to import inot a Field on Form B and have them presented as a dropdownlist as Well. Can this be accomplished? or is there a better way to do this?
Freeze header row
How do I freeze the header row on an embedded database so that users can scroll up and down and still see the column names? I'd like to apply this feature here: http://juiced.gs/index/
Left justification of Search, Add, Print links
How do I make the Search, Add, Print, etc. links left justified. I am constantly scrolling right to find the search link. I've attached a screen shot of my Creator app.
update data problem
I am trying to update about 25 rows in my database with data that is generally found in a lookup field. When trying to do this using the edit function in the view it accepts a change and then when I attempt to change the next record with the same value it accepts the change and removes the value from the previous record. This will continue if I attempt to make the change again. I have seen this before and worked around it but have hit an issue here and so need a response. I also attempted to make
New Interface filters - problem with advanced display options in lookup fileds
I like the new interface and the way filters are displayed is a great thing in the new application. However, there is one aspect which needs to be fixed. If in a form we have a lookup field which references to ID field form another form and we use for it Advanced Display Options to display for example First Name and Last Name. The values coming from that field are correctly displayed in views. Also, filtering is possible, because First Name and Last Name are displayed in the built in filter instead
Enable Edit Record only where login user id is same as added user id
Hi, On a particular view, I want only the user who added the record to be able to modify/edit it. Basically, on the view, I want to write a code which will enable Edit function where zoho.loginuserid is equal to addeduser id. Please help. Vishal
Update - Date Search Calendar missing
Since the update when performing a date or date range search in a view, the calendar no longer appears. Also if you "Click to Add Record", there appears to be no way of closing the pop up box, should you decide not to add a record. You have to close ZC and start again to continue. Regards Mark Australia
How to read the upload xml file datas using deluge script?
Hi All Hope you all are doing great!!! I need the way are script anything whatever u know about this topic. Please share with me.It's very urgent work for me. Because am new to zoho ,if anybody help me it will appreciate. and i will tie up with you for my zoho projects. My questions are below : How can i read the xml data using deluge script using zoho creator? And how can i store the xml date to the database? How to create the database and tables in zoho creator? How to validate the file extension?
Usage allowance
I understand that to access an application for FREE, I cannot have more than 2 users, and that the amount of data I can store is 400 Mb. Is that correct? I would like to track the data usage, so I can know if/when I am getting close to the 400Mb limit. Can you please tell me how I can do this? Thanks Kevin Murray kevandglenny
ReplaceAll dont work?
I have this code: texto = "0.90"; alert(texto.replaceAll(".", ",")); Return to me ",,,," WHy???????????
One entry to update multiple records
Hi .. I am setting up a database for a dog rescue. I have a list of dogs and a list of foster carers. I have a field in the dog form to assign a foster carer to that dog. Is there a way to automatically update the foster carer records to show the dogs name in their records. At the moment I have to go into each record individually to update them.
Simple Dynamic HTML
Hi, I am aiming to make a very simple Dynamic HTML page, do you think You could help me? Basically we're building a Database of Local Work Seekers. The Work Seeker Application form has all the information for that Work Seeker. Upon Submit, we want the App to generate a Resume for that individual based on their data. Below is the link to the App. https://creator.zoho.com/dylanvdb/good-help-employment-marketplace/#View:Curriculum_Vitae (I have opened up the App to Support.)
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?
Next Page