Is possible a partial submit?
I'm working in Zoho survey for the first time. I want to allow user to submit data to some question and come back later to complete their survey? Is that possible? Thanks
Order management validation
Hi , In our order management application ,The Total field value Must be 100 ,when i submit a form If the Total value is more than or less than 100 the alert has to display i.e " Total should 100 " , where can i write the validation code in order management application . Please Help me out . Thank you
How can any user send an e-mail with changes in a field, when the field is modified
I wrote the following script to send an e-mail with the changes made in a field (Product) when this field is modified. So far is working fine, however only when the admin makes the changes to the field the e-mail is successfully sent. When another user tries to make a change in the field "Product", the e-mail is not sent. Any solutions? ON EDIT > VALIDATE changed_values = map(); if (input.Product != old.Product) { changed_values.put("New Product", input.Product); changed_values.put("Old
function calls openurl then wait for form submission can this be done
Hi I open a form from a function using openURL and the function keeps executing can the function be made to wait for a return submission notice from the form which has been called ? So like this If a=b openurl form form has been submitted does a=c basically checking what the user has submitted, i guess if the form submission passed back the newly created ID i could go and query the record ===== Bump =====
XML - Error occured in the insert Html task
Please check the app below. I have allowed support access to the app already. It is giving me the "Error occured in the insert Html" task error. The xml works fine if I view it but in the app it doesn't work. https://creator.zoho.com/nazario.mariano/qa-department-lab/#View:Call_List Thanks.
Using the "AND" and "OR" operators
I know this is an easy question for the experienced, but I am not. I am a network engineer pulled into a project for a client. I have created a form for inquiries, but am having problems creating some of the required views. I need a view that will filter records based on the following three criteria. If the attorney_week matches one of my values AND has been added within the last 8 days. But I also want to display any records that have an empty/null value for the final_disposition field regardless
itDuzzit provides connectors and pre-built solutions for cloud-based applications
Hi NOT AN AD and i don't work for this company http://www.itduzzit.com/site/ For those of us using Zoho Creator to work with other cloud apps this could provide a nice solution especially for those who are pretend programmers like me. They list Zoho CRM as a connector and i have asked about Creator, ZOHO .. you working with these guys ?? If anyone picks up on this let me know, promise will share back. Is there anything better being used by others ?
Need to define multiple primary email addresses
Hi there - We have purchased Zoho, and plan to use it for multiple applications. The confirmation email sent on success for each of those applications needs to come from a different individual, not just the "primary email address" for the account. Is there a way to do this, or do we need to open multiple accounts? Thanks! Jess Weiss
Rest API Add record does it get processed via the forms on success logic
Hi For a form i have some Deluge script logic which i process in the "on success" section, i now want to replace this form and send the data via the Rest Api. Question when i add the record will the "on success" deluge script still be processed ? thanks
Unable to delete an application
I have a hold application that I can't delete from the Home page. The application is coming from the MarketPlace and I can't access to the source code. I receive the error message below. Please, can you delete and erase all data about that application. https://creator.zoho.com/slack/help-desk/ thanks This application components is used in the following places,Please remove this and try deleting the application. The function 'thisapp.helpdesk.getTechnicianPageUrl' is referred in following place
Validation of a File upload field ?
Hi, I'd like to limit the extension of the uploaded files in a form. I've written a script in the On add > Validation to check the filename. That's works correctly : if (input.FileUploadField.endsWith(".jpg")) { show or hide some fields; } Now, I'd like to check the filename before submiting the form, using a script in the "On User Input" of my FileUploadField, but the filename seems to be stay == "" and don't read the selected filename. Have you a suggestion for that please
Form is not loading in Edit Application mode
Something is corruped in my application try to Edit form in Edit application mode: ito_mu account - > EP_Attestation program, Select Systems form Form is not loading I cannot even delete this form I cannot create deluge script now for this application, and also when I try to view form definition from script mode, I get "Loading" forever. Please help me out here
In list view, need to display "New!" for records added in past 3 months
Hello, I have a database that displays worldwide group listings. I need to display text or a small image designating new records added in the past 3 months. How do I do this, or can I? Thanks
problem with order management edit option
Hi we are getting problem with order management application which is in our shared apps. we are unable to access the edit application option, could you please suggest how to get edit application option for my shared order management application. seeking you kind suggestion and solution Thanks regards
Form question
Can I create 1 form that does different things based on what radio button is chosen. for example If I create 4 HTML views that each do a slightly different task say 1 Proof of ownership 2 Invoice 3 Technical Sheet 3 Sales Sheet If I select radio button 1 it will print my proof of ownership HTML view If I select radio button 2 it will print my invoice HTML form and so on. Logic tells me it can be done but I am lost as to what code to use and how. currently to print the proof of ownership HTML view
Use Zoho Creator to create mass Invoices in Zoho Invoice
Hi, I am current Zoho CRM and Zoho Invoice user looking at Creator. In reading some posts, it appears that I can integrate my Zoho CRM Contacts with Creator. It looks like I can also create a single invoice for a customer one at a time in Creator and have integration with Zoho Invoice. What I would like to do is create multiple invoices of the same product based on the customers I have selected in a list. Here is my application. I need to invoice about 50 people for my club's membership dues once
email checkboxes not checked
I have a checkbox field with 10 choices. I want to send an email showing which items were NOT checked. Alternatively I would like show all 10 items in the email with a checkmark next to the items that the user checked. Any suggestions on how to do this? Herb Wexler
Render Image
I know that there are several threads on this issue, but I have read everything that I could find and can't get it to work. When I go to the View for the form the pictures will not display, and instead give a broken link icon. I have a file upload field names Image_Upload and a formula field named Student Picture. The expression I have is as follows: ((("<img width='64' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Image_Upload + "&sharedBy=" + zoho.adminuser) + "&appLinkName=")
Which AP is right for me.
Hello All; I'm very new here. I'm not even sure which AP is right for me. I'll put my simple case study and see if I get answers. I'm a member of clergy in a church, we have out congregation database, that we have on a central computer. Me and the other clergy members also have the contact information for the church members on our smartphone. The very basic idea here, is that I would like to move the database to be on the cloud, while any of us (clergy+office staff) makes any changes on the contact
Creating an applicant view for jobs still allows add/edit/delete
Hello all, I'm new to Zoho but find it very simple to get a working database running. I'm trying to integrate a jobs database for my company's internal Google website and need to be able to push changes to the public corporate website. For my jobs site, I've successfully embedded the app into the internal Google site but anyone can add/edit/delete jobs even though I unticked all three in the settings. Is it because I'm logged into my account? If I could get permission to make the site public, then
Mail Merge
Is there a way to mail merge to a MS Word or Zoho Writer document from Zoho Creator? I saw you have this capability in CRM but is it also in Creator?
Radio Button Display adds the intial choce to the List of choices
Hi Did Radio buttons always work like this or has something changed Radio Button A B C Initial value: Z (why because i want a default other than the choices BUT The Initial value:, is now displayed as one of my choices Radio Button A B C Z
Simple Redirect Question
Hello There, What I need to do is: after save data on Form ("on success"), redirect the user to View instead of Form. Seems that the default Form ("on success") behaviour after you save data on a Form, is to be redirect to same Form, but instead of this, I would like to redirect it to View of that Form. I am new on Zoho Creator, but before I make this question here, I tried to find out the solution (without succeed). Thanks in advance Juliano.
grouping a Lookup
Hi there, Here's the situation i have: In the Main form, i have a Lookup field called year. This is setup as a dropdown. It's lookup definition is to grab Recruitment_Year from Reference form. Recruitment_Year in the Reference form can be the same for multiple records. As in, i can have records form that may be: Recruitment_Year/Recruit_Name 2008/Jack Black 2009/John Doe 2009/Susie Q 2010/Jennifer Brown 2010/Alan Partridge Currently, if i pull up this Lookup picklist in the Main Form, it shows
Can't download or delete a backup
Hello, I'm currently trying to delete the oldest backup version for one of my apps in order to create a new backup but when I click to delete it nothing happens. Also for the same backup version when I click download I get an error page: "An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." I can download all other backups and I would assume I can delete the others although I do not wish to delete them yet. Thanks
Is it possible to to make Aggregate Records values clickable?
I'm using Aggregate Records in an form and it works great. However, I would now like to be able to click on the numerical value created by this function and be shown the records it has matched. How do I achieve that effect?
Error in views editing
If I have a view with a lot of fields in a view, and I enter in the view definition where I delete most of them in order to have just a few displayed on the view (and there is no syntax problem), the following error message is displayed: Error modifying the page Exception occured while publishing message to the topic :: [DataModelTopic] I don't know if this is something specific to the application I work on it or there is a limitation in views editing. Regards, George
ZOHO DOCUMENTS
I AM NEW TO ZOHO TRYING TO DO A LEGAL FORM BUT WHEN I TRY TO FILL IN BLANKS THE FORM MOVES. WHAT DO I DO TO STABILIZE FORM?
Error when creating report
I have been trying to create a report for our team -- but each time I try, it fails. I have tried changing some of the parameters (different name, save to different location, based on different query). To no avail. I keep getting this message: "Sorry. Error occurred while creating the report " Any suggestions? This is the first time this has happened -- perhaps a temporary hiccup? Thanks, Kim By the way, have tried with both Firefox 7.0.1 and Chrome 14.0.835.202
Creating conditional code based on form selections in the same page
I have a product selector where there are four fields: Category Item Price SKU Each SKU is a unique combination of Category and Item. I'd like to create a field that automatically populates the Price and SKU based on pulldown selections of the Category and Item. If I were able to code it in SQL, it would look something like SELECT SKU, where Category={pulldown.category} and Item = {pulldown.item} AS SKU SELECT Price, where Category={pulldown.category} and Item = {pulldown.item} AS Price I'm not
Access to source data in Creator apps?
Several of my apps use zoho.userid data. Is there a way of changing this data after it's posted? The short version is that I had to use a public url briefly and now need to recode that field as it's used in performance measures. Is there a way to access the data through phpmyadmin, for instance? Thanks
Potential bug: migration tool loads all files in folder
Hi, Earlier this week, I reported an issue with the migration tool not loading my file. What was happening was that the when I selected a file, it the tool would hang and not do anything. I thought that the tool was not working so I re-downloaded it but had no luck. Today, I was clearing up my computer and cleaned out my downloads folder. Since I had reported the issue to support, I thought I would try and download the tool again and try one last time. This time it worked but instead of loading
Dollars sign in a field
How do I display a number with a dollar sign and thousands separator, such as $60,000 instead of 60000. Earnest ehart5905
video
can I attach video? Since this is essential for me I thought I'd ask befoe getting started. thx
'Back to Form' missing
When editing a form script there used to be a button in the upper right to go back to the Form design. It no longer shows. I use two different computers (XP & Vista) and Chrome 10 and FF 3.6. Does it still show for other developers? Herb Wexler
Relationship
Hi, Can I create a relationship without using lookup Thanks
HELP with HTML View on web site
Hi, I wonder if anyone can help please, I have 3 files "Jobs" "Job Progress Enquiry" "Job progress HTML view" I have enabled the support access on my zoho site If you look at app mrcomputer-biz and look at the form Job Progress Enquiry you will see it works perfectly. However, I dont want my customers to have access to Zoho so I put the code on http://jobprogress.mrcomputer.biz but when you fill in the field on the web site it does not work. On zoho I use the code openUrl("#View:Job_Progress?same="
Managing users in groups
Hi, My users are telling me they don't have access. So I'm trying to troubleshoot their accounts. When I go to the Manage Groups are I do not know how to see the members information. Clicking on their name or icon does nothing. How do I look at the members in groups account information? This the form I'm on:
Mail to a group of contacts from Creator application
Hi, hello I need a function/feature that allows me to send generic predefined mails to groups of contacts, filtered from a form created for that task. Lets say that I have 850 contacts in my Creator application "Agenda Personal" and I want sen an invitation only to the "Golf Club Friends" and they are 38 people. Now I have to send 38 different mails. I like to pick the list of the 38 email addresses and move that to the "TO:" field of the SEND MAIL function and send only one mail using the "TO:"
need support(
Hi, please help me to solve these 2 problems 1. How would you normalize this relation??? Consider a Relation R(A,B,C,D,E,F) with the following dependencies (A,B)->C, (A,D)->E, D->B, E->C Do lossless join decomposition of R so it is in BCNF normal form 2.Consider the relation R, which has attributes that hold schedules of courses and sections at a university; R = {CourseNo, SecNo, OfferingDept, Credit-Hours, CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo, NoOfStudents}. Suppose that
Next Page