Score
Hello, I am working on retrieving a score based on a chioce that a user makes from a drop down. I have the following forms: Policy Write-Up (Database) - This is where I have a database of all the possible policy violations and a point number attached to each. The fields are: Policy Number Policy Violation Policy Rule Points Write-Up Data - This is a formula that combines Policy Number + Policy Violation + Policy Rule Write-Up - This is where I want the user to be able to enter in an employee
PHP-Fusion
My current website uses the software PHP-Fusion and our non-profit organization has gathered 7 years worth of data using the CMS. Is it possible to take the MySQL database and integrate it into a new, search and display application through Zoho Creator? Please advise. - Potential Customer
formula1's result as variable in formula2. how?
hi i have 5 too complex formulas in my application each formula has a result - result1, result2, result3, result4, result5 in what way can i use result1 as a variable in formula 2 ? and other formulas right now i just copy full code from formula1 to formula2. this make application code too complex
Retrieve the loginuserid using the corresponding loginuser ?
Hi, I use a form to dynamically share forms/views with users. I just have to fill the "Email" and use it for the sharing details. I'd like to add a field like "zoho_username" to be autofilled according to the the email (registered in Zoho) : I fill "myUsername@myEmail.com" then my field "zoho username" should be filled with Deluge. Is there a way to do it please ? (I precise that all accounts will always be created first in Zoho). Something like : myUsername = zoho.username(input.Email) ; Actually
Greater Than and Less Than nuisance
Deluge script is replacing "<" and ">" with "&lt;" and "&gt;", respectively. Is there a way to stop that behavior?
Reports to Creator: Iterate Records
Currently I keep employee information in Creator but what I am trying to do is pull it from Reports. What I have currently is the following: for each var in Harvesters [Team = input.Team] { insert into Harvesters_Daily [ Added_User = zoho.loginuser EEID = var.EEID Harvester_ID = var.Harvester_ID Id1 = input.ID Name = var.Name Team = var.Team Team_Position = var.Team_Position ] } ^This creates a new record for each harvester for
Basic question for selecting and Updating records
I'm new and know very little about programming or code. I want to create a very simple form that manages contact info that I can update from the form view. For instance, if I had a form that was simply Name, Address, and Phone number, I would populate the info and submit it. However, I would like to have a drop down list above the Name field to search for an existing name that I can select and have all the existing information populated into the fields. From there, if I modified the phone number
I want a site where users log in... can I do this?
Hi. I want to build a real estate site, where sellers log in to create their ad, and then buyers can search/query the data to find the properties they are looking for. Is that possible? Thanks. Maryanne
Block form for Weekend
Hi, I need some help in a code. I´m blocking the access for this code if (((hr >= 19) && (min > 0)) && (sec > 0)) { hide Nome; hide N_de_Colaborador; hide Email; hide Data_de_Registo; hide ideia; hide Tipo_de_Ideia; hide Descri_o_da_Ideia; hide Benef_cios; hide Coment_rios; alert("Este acesso só está disponível no seu local de trabalho"); } But in case of Saturday and Sunday I want the forms to be blocked all day, the schedule only applies for weekdays
Hide/show actions on user input from checkboxes
Im trying to hide and show a few fields based on if checkboxes are checked or not checked. I have the fields hidden initially on form load. I also successfully show the fields when the option is checked. My problem is i dont know how to make those fields disappear if i uncheck that box... what would be the best way to approach the opposite function of input.contains()? ____________________________________________________________________________________________ ON LOAD _____________________________________________________________________________________________
Apply autonumber with Form Object Function?
I have a form object function that sets the value of a date field in a collection of records (script below). Now I would like to set the value of the ItemNumber field in each record of this collection as well... ...BUT I would like to autonumber those values so that the ItemNumber fields start at 1 and continue with 2, 3, etc. until the entire collection has been assigned an ItemNumber field value. ALSO the order of the assignments is important and should follow the order of a field called Unit which
openURL not executing in function
Here is the function code: void JulDepositDateSet() { JulNextDepositList = Payment [(JulPayment > 0.01 && (JulDepositDate is null))]; JulNextDepositList.JulDepositDate = zoho.currentdate.addDay(1); openUrl("https://creator.zoho.com/rampartcrossinghoa/rcb/#View:Jul?JulDepositDate_op=33", "Same window"); }What I done wrong to not have this openUrl command execute? Thank you for your help.
dialer
is there any way to enable a phone number field to be clicked in a view and trigger a dialer?
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
Next Page