Zoho (Files)
I don't know if it is places any elswhere in the great Zoho forums. But now a days there are some cloud hosting programs. Just like to name: Dropbox, SugarSync, MegaCloud, Google Drive, SkyDrive, SkyFile, etc, etc. Like to know if Zoho has plans wiht it. I mean: develop any app so that we can manage the files that we store in our zoho space. I think it would be nice and handy. Like to hear from you.
Open View from Form Link in Popup Window
Is it possible to create a hyperlink on a form to open a popup window to a view? I can create a link on my form to open the view, by creating a plain text field in my form with this code: Calendar_Link ( type = plaintext value = "<br />\n" ) And then using the OnLoad command of the form to create a dynamic link using this code: input.Calendar_Link =(((("<a href='https://creator.zoho.com/carlgifford/vacation-rental/#View:Reservations_Popup?Property="
Alternate "Submit" Button
Good morning, I'm working on a form with a new requirement. I have a set of forms, each form is a "stage" in a process. When one process is complete you either move to the next or the process is closed. The new requirement is depending on the status of the overall process, a user may need to jump from form-0 to form-3. So, I've put a conditional statement in. If "need to jump" == "Yes", then user needs to go to "form-3" else "show the hidden fields to complete stage" Pretty basic. What I'd like
Zoho Reports to Zoho Creator
Is there a way I can pull data from Zoho Reports to Zoho Creator. ex. On load of Zoho Creator I want feild "Axx" to update to all values in column "Bxx" in Zoho Reports.
Radio button selection as a single-line text entry
Is it possible to have a radio button selection be a single-line text entry? I'd like to have two choices: 1. a person's name, and 2. a "write in" entry. If "#2" is chosen, I'd like the user to be able to enter a name other than that presented as choice #1. Can this be done with radio buttons or some other field type? Thanks.
action on checkbox option selected
Hello guys, I want to send an specific email if in my multiply option check box one option is selected. So let's say if checkbox option 3 is selected I send an email with "x" content if checkbox option 15 is selected I send an email with "z" content if checkbox option 4 and 6 and 10 selected I send an email with "a, b, c" content I cannot find any reference on how to build this code in I have choosen "if" than put input.checkbox optiom_3 = true but it is not the right code. Can you please help
Web Application for multiple clients
Hi, I have a doubt in developing a web application, I want to create a web application for multiple users. Based on user role or region flow is changed User details can be hosted as services Please help me to understand these questions. Thanks, Phani
How to move a lead to converted
Hi Guy's, A complete newbie here so please be patient :) Basicly I want to create a form "new lead" in that form it will have a drop down status with the following options >Contacted >Converted >Not intrested When the drop down is changed to "converted" I would like to move it to another form/view "leads" and on moving it to this new form it will allow me to enter further info. So I have created a form "new leads" and created a form "converted" how do I get the data to move from new leads to
Send email with custom subject to selected records
Hello Zoho team! I want to send an email with custom subject to selected records in a view. I have viewed https://help.creator.zoho.com/Sample-Code.html#Email_Notification but I want that the subject of the message could be user edited. Thanks.
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!
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
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
ReplaceAll dont work?
I have this code: texto = "0.90"; alert(texto.replaceAll(".", ",")); Return to me ",,,," WHy???????????
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......
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
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
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!
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
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
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?
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
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"] {
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?
Subform edits not persisted
After updating a form in which subform data is changed, we receive the "Data Successfully Updated" message, but sadly, the subform data remains unchanged.
On Add --> Validate : Script Action Fail
What I am trying to do is have an alert box pop up if a field value is null, but I only want this to happen once on validate and if the user decides this null field is ok then the user can submit again without having an alert box pop up. Currently I am trying: if ((input.Radio_1 = null) && (input.hiddenvalue != "nullcheck")) { input.hiddenvalue = "nullcheck"; alert "You have not completed the form are you sure you want to submit? To submit click ok then click submit again."; cancel submit;
Trying to autofill potential using the creator
Hello and thanks in advance for the help, I am new to Zoho but know how to program. I am building a form that uses labels to find 1.a contact (using Zoho CRM label) 2. an item serial number(using the database lookup) 3. and then creating a simple activation code for a product(using a function that returns answer in a label. Now I want to have the user to create a new potential (that will be set up with a Zoho CRM label) but on creation it autofills the values that have already been input (the contact
Again, what script will the new Drag & Drop calendar date change feature call?
I'm desperately trying to negate the effects of the drag and drop feature because it does not allow me to control the manner in which users change record dates. I haven't been able to get any script to call upon a drag and drop[UPDATE: the problem was on my end...I was testing older dates that didn't have my control field value loaded.] If someone would please post here an example of calling script with the drag and drop I would greatly appreciate it.
joining two forms
If I have a form of orders that includes zip code and a form of userid/zipcode (they can service more than 1 zip code) how do I create a view that shows each userid only the orders that match a zipcode in their userid/zipcode list?
Next Page