Number Conversion Function
I need to convert a Hex string to decimal. On doing a Google search for "Zoho hex to decimal" I found this function, apparently in Zoho Sheet: DECIMAL Returns a decimal number, given a text representation and its base radix. Syntax DECIMAL(text; radix) Syntax Description text is text representing a number with the base radix radix (an integer between 2 and 36). Any leading spaces and tabs are ignored. Letters, if any, may be upper or lower case. If radix is 16 (hexadecimal system), any leading 0x,
Marketplace - if you are not logged in you cannot search the marketplace
I happened to be browsing the marketplace today and was not logged in. I could not find a search box! The only option was to browse, which is highly inefficient for hundreds of apps. If you login, you see a search box. Please make this search box available to non-logged in users! Also, when I click the "Post Your Requirement" button, it did not work! In fact nothing happened, I only saw an error in the bottom left hand corner status bar. I was using IE 8. I did go back a second time and this time
Submit form and populate fields in a separate application form.
Please advise if this is possible: On successful submission of a form I want to use the OpenURL in a script to open a form in a different application but populate fields in that form based on the submission from the original form. For example, I have a Findings application with a Priority field and a Tasks application with a Priority field. When a user submits a Result I want the Tasks form to open and populate the Tasks.Priority field with what was submitted from the Findings.Priority field. These
Look up part of a field. Does field value contain a string.
I have an accounts form that allows our reps to enter in an account name. However to avoid non exact duplicates (i.e Global Travel and Global Travel LLC) I would like to have a note field that updates with all possible matches of what ever is typed so far. So for example when global is entered the notes field list Global Adventures, Global Assoc Growers, ect. Basically the same functionality as an auto complete based on a database lookup. Is there anyway to do this?
If condition in a view
Hi! I have a field in a view that depends on the values of two other fields and I need to show diferent values. My if condition is: if (input.Preco_jumbo > input.Preco_continente) { Mais_barato = "Continente"; } else { Mais_barato = "Jumbo"; } My question is where should be this statement? In the form field associated to an action like on add/edit or in the view script?
Multiple forms in single application
I have following different questions: How to create multiple forms in a single application? Is it possible to provide only view rights only to corresponding views of those forms to a person? Can one show or hide different forms within an application based on logged in user? or If this is not possible is it possible to keep only selected fields of forms editable for a logged in user? Please help urgently.
How does the Search Interface actually work?
I am new to the Zoho Developer community, I have a background in scripting although HTML is not my strong point at all. I am trying to create a Search interface and am following the relevant Help options that Zoho have available (https://help.creator.zoho.com/Creating-a-Search-Interface.html and https://help.creator.zoho.com/Create-HTML-Views.html) but it is getting me absolutely nowhere. The templates they have available in the HTML views are so confusing and I am just stuck! All I want to do is
How do I see if a date range falls within or overlaps another date range?
I'm trying to make a school register. The teachers need to be able to print off a weekly sheet which shows on what days each student will be attending. Technically, I think this boils down to seeing if one date range (the period of the student's attendance) falls within another date range (the period of the register - these are needed weekly). Any help from anyone on how to do this would be greatly appreciated :)
Zoho Creator update via API
I tried to update record via API but getting error: "2897 Permission denied to update record" . The application is my own with all correction about apikey Everyone can help me to solve it out. Thanks
Passign params to HTML view
Hi :o) I have created a HTML view that contains a form and a view. This is to represent a hosting account and associated email addresses. The form opens ok with the correct ID number in the address bar - but there is no data in the form and the view is not filtered. The script behind the view is below:- ---------------------------------------------------- htmlpage Hosting_Detail(Id) displayname = "Hosting Detail" content <%{%> <div elName='zc-component' formLinkName='Hosting_account' params='zc_Header=true&zc_SuccMsg=Data
t_483991000002580764] Exception occured while setting value in PreparedStatemen
Please fix this urgently... I've gotten these errors before.. 1 . [t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary .[t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary
sharing developer
I wan to share my application with a developer. I have activated a user account to developer. Searched the forum and found the solution saying "Edit permission to......." but this does not show up in my settings. How can I share with a developer??? Kind regards Michael
URL Syntax for subform with multiple arguments
I'm trying to define a function similar to the "Add Attendance," except I want to pass two arguments - one for ID (which works fine by itself) and another one for date (which also works fine by itself). When I try to combine them together in one URL statement, I don't receive any error messages when I save or execute the script. However, neither field passes to my form. This is the URL statement I've keyed: openUrl("#Form:Add_Distribution?Transaction_Date?Transaction_ID" + input.date + "" + input.id
Need help creating a Custom Action to execute a function that will change a field value...
Hi, I am trying to create a custom action button for each row in a View that, when clicked, will change a dropdown field called Vehicle Status from it's previous values (for example, "Inventory" and "Ready to Sell") to "On Sale." If you can please show me an example of how this is done without referring me back to the Zoho forums or developer site. I am new to this and will need more explanation than I am getting so far in the available sites. Thanks!
Multiple client Databases
I would like to develop a web based application where each company client (and their users) have their own unique database to ensure that their data is seperate from and secure from other company clients. I would like to do this within one application if possible for the following reasons: I only want to maintain and make changes to one copy of the application, The only access to my application will be through embedded forms and views on a website so I only want one version of the embedded site.
How would I create a graph or chart to track weight?
I run a dog site for a certain breed and would like members to be able to input their dogs weight over time. Where others can view data and compare with others. Info needed would be name of dog, weight, and age. Any help on this would be great! Thanks for your time!
Embedded view suddenly not working
I have many html views containing list views embedded as div-tags. I have not touched the code of my app for weeks but suddenly some of these views do not work anymore. What happens is that the criteria is not applied propperly (no records are listed) and the header is shown (despite the tag "zc_Header=false"). Here's an example: <div elName='zc-component' viewLinkName='Player_Entities_Embedded' params='Player_Name=<%=recP.Name%>&zc_RecSelect=true&Player_op=26&zc_Search=true&zc_AddRec=true&zc_DelRec=true&zc_Header=false&zc_Footer=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Summary=false'>Loading
Add time to date field
I have a date field that I am wanting to take upon user update and add the time to it and put that into a date time field. I keep getting an error when I try this: date = input.runDate + " " + zoho.currenttime.toString(); input.startTime = date.toTime(); input.endTime = input.startTime.addHour(1); It gives me the error unable to convert string to date. What is a better way to accomplish this?
Updating records - stateless forms
I have 3 stateless forms based on one large application form Application_Page_1 Application_Page_2 Application_Page_3 When I am at the end of page 1, I create a new record in the application table upon clicking the continue button. What I would like to do for page 2 and page 3 is update the current record that was just created in page 1 instead of saving a new record upon continue. How do I do that? Do I need to create a function that stores the recordID upon saving of the record in page 1 in some
use Deluge to limit records
I'm creating a view for a team member who only needs to see the most recent jobs we are working on. I'd like to set a criteria that will limit her view to records that have Estimated Start Dates from today to three months from today. I found a similar question at http://help.zoho.com/portal/en/community/topic/zoho-currentdate-in-url? but there the question-asker wants to use this in a URL I know there is a Zoho-wide variable called zoho.currentdate So in psudo code it is: Estimated_Job_Start_Date
Deluge Code 'include file' - containing fields that are common to a number of forms
Is there a tip or a trick that would allow me to set up a number of fields that will be same in a number of forms... For example...suppose I wanted each application to have 2 fields called 'Hidden_Passed_In_Unique_Key' and 'Hidden_Follow_On_URL', then is there a way that I could include the following snippet of Deluge Script in each form that needs to use these fields....I'd like something along the lines of '#include <common_deluge_scripts/hidden_fields.ds> Hidden_Passed_In_Unique_Key
Is there a way to get all of the strings in a Checklist/Picklist...not just the selected ones...
Hello, Apologies in advance this is a bit long... If I have a checkbox.. Checkbox_1 ( displayname = "Checkbox 1" type = checkboxes values = {"Option 1", "Option 2", "Option 3"} on user input { alert("In On User Input - input.Checkbox_1 is :" + input.Checkbox_1); } ) and a related Decision box...that gives the user the option to select or deselect all the strings in the checkbox in one step... Decision_box_1
searchRecords() in CRM returns Contact List (which is a List()) - how to check for empty list
Hi, I am having some trouble testing for an empty contact list when I use the CRM searchRecords call in Creator...anyone have a suggestion...the problem is the List that is returned always has 1 item in it...even if that item is 'null'. I guess if no CRM record is found matching the search criteria, I would expect there to be no records in the list...here's some code that may explain it... ContactsList = zoho.crm.searchRecords("Contacts", searchString); testContact = map(); testContact
Read ZOHO Database using PHP (CURL)
Here is the working version of PHP CURL to read data from your ZOHO database. Using the CSV POST method to avoid using GET"s that show your queries in the address bar This is the code for posting the data using PHP CURL <?php // This is the function for posting with PHP using CURL function curl_post($url, array $post = NULL, array $options = array()) { $defaults = array( CURLOPT_POST => TRUE, CURLOPT_HEADER => 0, CURLOPT_URL => $url, CURLOPT_FRESH_CONNECT => 1, CURLOPT_RETURNTRANSFER
Store a list variable in a single record?
I'm looking to store a list variable in a single record. How would I go about doing that? Thanks.
Help with syntax
I've created a check box field called 'options' that has three values, A,B & C I want to hide field 'date' on the form if the user selects option 'B' What would be the syntax please? Martyn
how to access "get" values in url from inside form code
I am trying to retrieve "get" values from a url and use them inside a Form's code. For example from the following url: http://creator.zoho.com/<user name>/<app name>/form-perma/<form name>/key=30409000000057085 I need to get the value 30409000000057085 and put it in a drop down list. The documentation on the following page says: "Note: The default field values will be available in the form's on load action." http://help.creator.zoho.com/Functionality-based-URLs.html#To_edit_individual_records_by_passing_record_id_in_the_URL
variables from one form in another form
Hello, I have a problem with connection of two variables in one dropdown menu. In one form I have two fields: "name" and "email" which You input in textboxes, in next form i would like to have a dropdown with values in form like: name(email) and after picking one of values from dropbox i would like to send a message to the chosen mail. Thank You for any help. (Sorry for my english)
Formatting email submission so it appears correctly in Zoho
I've figured out how to submit records to my zoho application using email. These are emails I am forwarding. The problem is now formatting the email so it doesn't show up as garbage in Zoho. I've found that changing the text encoding on the email to Unicode (UTF-8) will eliminate the problems with reading some characters such as apostrophes ('). It appears the submit data by email function reserves the colon (:) for identifying the fields that I'm using in the form. My work around is to replace
Passing form values to an external URL ?
Hi there, What I am trying to to is design a form, gather the data, and then take some of that data and redirect to an external URL passing some of the data across. Eg: Fill in Name, tel, email on the form click submit - it saves this info to the database, then redirects to eg: http://www.mydomain.com/cgi-bin/myprogram.pl?Name:Tel Is this possible and if so, how do I achieve this ? your help will be most appreciated.
Trying to total a sum for inventory
Hello, Currently, I am trying to track the running total of my inventory on a basic level. I have a "Quantity Onhand" field and a "Quantity Received" field. On submit, I would like the amount (Quantity Received) of the Product to be added to the Quantity Onhand. I am very new to scripting so any suggestions would be greatly appreciated. Here is what I have on the Quantity Onhand field on Update: temp = 0; for each rind in Order_form [Quantity_Received == input.Quantity_Received] { temp =
Work around for lack of sum function?
I understand there is no sum function in creator. I need to create a html view to display an income vs expense with a total of the income items and another total for expense and a grand total that calculates income - expense. The form has a field for item name and amount and a checkbox for income or expense. Right now the only way I can make it work is to have each expense amount be a negative number when entered. This prevents me from being able to make a chart from this data. If I could sum
Is there a way to link 2 applications?
I was wondering if there could be a way to link 2 applications i.e. App 1, let's call it Contacts, and then App 2, let's call that Hobbies, so in Contacts I would add all of the contacts and their info... so in Hobbies i can access Contacts and find a name then select the name and add a list of hobbies. I need the apps to be 2 different ones though as the information I am adding is a lot, and not all of the things in app 1 have the information, so it is easier to create 2 different apps so the information
Bug in Notice for Modified Function
I appreciate the notice below a modified function warning me about references to the function on other pages/forms. However, recently I'm seeing the notice below, even after correcting the references... Function is modified successfully However the following other functions have argument mismatch in invoking this function Make a note to correct them as early possible, as it may lead to execution errors In action script--> with arguments (int ,string ,string ,string ,string) Where? Usually it mentions
Zoho and e-marketing
Hi there!!! OK here's my dilema. I'm want to be able to sell "packs" in the form of grouped documents such as PDF documents to clients on my website. This will be in the form of a shopping trolley where clients can purchase using online payment such as PayPal. My question is this. Is there any way of linking Zoho database so the client can view the database of "packs" and then make a purchase, this is turn automatically filling a field stating "sold".
"No Records Found" page in HTML view?
Hello, I have an HTML view in Creator that displays records based on a search parameter (State and Country). How do I display a message on that page when there are no results found? I need to give users information for what they can do when they don't find any listings for their area in our organization. I've looked around and cannot find an answer to this. I need the code for "if search results=none then display this HTML". Thanks
Set criteria for a checkbox field in a view with URL
I have a checkbox field. I need to filter a view depending on a value of a selected checkbox field. For example, view all records where option1 is selected. Which operator should I use? I tried URL?fieldname=option1 and URL?fieldname=option1&fieldname_op=26 - none of them worked. Help please!
How do I put a form inside another project?
Hi How do I put a form inside another project? For example: I have a productive and have also the form Shopping .. They are individual forms, I need to put them on a new project or group that would be anew application called Management .... Thanks
How do I make that a Form A press on the screen data from another form in various fields?
Hi How do I make that a Form A press on the screen data from another form in variousfields? For example: The Form I-Product I want it in another form I select from a combobox the product name and thenautomatically loads itself into other fields all information of the product for which Iselected the name. Thanks
Add a checkbox on a view filled
Hi I need the following features: My example: I have the Form Products I need to create a View that has all the products registered in a productive and has anoption for eg a checkbox that I can mark it as a product with low. How would I do that? Thanks
Next Page