calculation on date field
I'm new to zoho I have a form with date field which the user has to enter. I have another field which I want to calculate based on the date entered by the user. I want the calculation to be "the date entered + 9 days". What s the best way to do this ? thanks for any response
Error Executing Workflow On User Input Script
My scripts were working a few months ago. As far as I know, nothing has changed. I have not added or modified any of the fields nor the scripts that access the fields. This week I needed to add new records and update some existing records. I received the following error: The field CONSULTATION STATUS is changed from either "NEW" or "IN PROCESS" to "COMPLETE" when the consultation is done and I click UPDATE. At that point I have code to calculate some totals and percentages. Here is the script
Export in excel format
Dear all I have issues when I try to export in excel a report including field in a currency format. The data of an amount fiel is not in a right foramt for excel and I am not able to make some calculations with these amounts. Many thanks for your help. Isabelle from Banook Group
Unknown Error
Just got this error: Left expression is of type BIGINT and right expression is of type BIGINTLIST and operator + is not valid Anybody know what it means?
Zoho creator to Quickbooks customer mapping
So I wanted to be able to create a customer and add info from a created sheet when it is submitted. I am able to create the customer and add Family name, display name, and billing and shipping address info with the following code: //Declare Map Variable to hold the customer details Customer_Details = map(); temp = Quote_Sheet [ID == input.Customer_Name]; //Add the customer details to the map variable Customer_Details.put("FullyQualifiedName", temp.Customer_Name); Customer_Details.put("DisplayName",
Fetching and updating records from another database
While I know it's possible to use a lookup field in a form to relate a record from another application, is it possible to use script to fetch records into a variable from another application?
Making formula field data available for export/import
Hi. I exported formula field data from one application and when importing the data into another, there is no labeled field to accept the record data. How can I make a field in the form that mirrors the data calculated in the formula field so I can import it?
Contact Form Not Redirecting to "thank You" page
My contact form is not redirecting the user to the thank you after they fill out the form. I'm considering zoho for my company but having this issue is not helping. http://residencialsantaelena.com/contacto/
Issues with Web Embed
Hi all, I'm having a couple little issues with embedding my database on a webpage, I wonder if anyone has encountered similar issues and if there's an easy solution. The first is that when I embed my reports, initially they never show up. It's only when I change the display from say List to Summary that they show up. Another issue I'm having is that when I search my app on Zoho, if I have a multiple select field when I go to search that field all of my possible inputs show up and I can just select
Bidirectional lookup from one subform to multiple mainforms
The solution offered here works perfect when there is one subform and one mainform. I have a scenario where I have one subform that is included in multiple main forms, and I'm looking to somehow link them together. If I try to add bidirectional lookups to the subform based on the existing relationships - I can only choose one at a time - so it only works for one main / sub relationship. Ideally I would have a single 'Source' column in the subform that is linked to the main forms that were used at
"Other" option is added to a drop-down even when the option is not marked!
Hi Zoho, I have a form (Loan_Valuations) that for a drop-down field of its suboform (Loan_Valuations_Broker - broker name field) it takes a list from a third form (Loan_Comp_Req - approved brokers field) and append it to the drop-down list On Load both on On Add and On Edit. This should not have a "other" option, and it is not marked as applicable anywhere. But: On Edit mode, there is an "other" option available !!! Please fix this ASAP. thanks Ravid
Complex criteria in pivot reports and charts
Some time back pivot reports and pivot tables were created based on views. The criteria embedded in those views were carried over into the reports. Since pivot table and charts are now created using the form, criteria restricting others from seeing the data is limited to 'Only logged in user records' and 'all records' but not to others authorized to view it as well. What am I missing?
Filter within an sub form
How do I filter within a Sub Form? In the "wiring" form we use Filter Site.ID equals input.wiring_site on a Device drop down. I want the same filter within a Sub form but it states wiring_site is not defined?
Upload Image File via Creator API from iOS App
I'm writing an iOS app that will upload information to a Creator application using the REST API. I can upload text fine, but I can't get file uploads to work. I'm trying to use this API, but as the example is for how to set up a web form I don't know what the structure of the POST request needs to be. I've tried a few different ways but I either get back a status code 500 and a HTML error message or a 200 response with a message saying the request was successful but the image is not uploaded.
Google AutoComplete Address DropDown
Hey Zoho Team, I need to make a google autocomplete Address Dropdown for my application. I need to know how is this possible with your javascripting code side. or any other alternative to do this. I am attaching a Screenshot for it also. Please Check and Explain with your best Example. Thanks
File Uploads Using Zoho Creator API
Hi, I'm having trouble getting a file upload field to work using the Server Side Rest API in my form. Please see code below: <form method="POST" action="http://creator.zoho.com/api/xml/myapplication/myapplication_Form/add/apikey=XXXXX&ticket=[XXXXX]"> <table> <tr> <td>Photo Upload: </td> <td><input type="file" name="Photo_Upload" size="19"></td> </tr> </table> <input type="submit" value="Submit XML String" enctype="multipart/form-data" > <input type="text" name="zc_ownername" value="[myname]"> Everything
Auto Number
I would like to auto generate a unique 3 digit number in field "wiring_reference" in wiring "table". The number needs to be unique for each "site" which is selected from a look up field of "wiring_site" in the wiring table which looks up "site_reference" field of table "sites"
Auto-Field Updates
Hi everyone, I'm new to using Creator and am confused about how to accomplish something. I have created a call-tracking form that fetches contact records from Zoho CRM. I can't figure out how to auto-update the next field, which is the customer's account number; this is a field in CRM. Does anyone know how this can be done? I have checked different help articles and am still confused. Any insight would be greatly appreciated. Xavier
Fetch Data from 2 different form?
Hi people, I'm newbie to creator and deluge, I'm following forums and help center and creating a application for my business needs. I have problem with fetch datas. Let me explain the structure that I have create and ask questions I have 3 different forms and; First form called Courses, it has 3 different single line text fields to explain 3 features of course (1st one name, 2nd one group, 3rd one Semester) And second form called Students; this form has student information and course information,
Zoho creator: How to add a record from a vb.net forms application
Hello, I am struggling for one day and I hope someone can help me. I try to add a record from a windows forms application using vb.net. This is my code: Public Sub addRecord(ByVal ht As Hashtable) Dim apiUrl As String = "https://creator.zoho.com/api/<xxx>/xml/<appname>/form/<form name>/record/add/" Dim xmlStr As New System.Text.StringBuilder xmlStr.Append("<input type=""hidden"" name =""authtoken"" value=""abcdefghijk"">") xmlStr.Append("<input type=""hidden"" name
How to Renew My domain
Need help renewing my website so it can be alive. Please assist me in this matter.
Function works only for one field !?
Hello All I created function to fill 2 fields with current infos in the report when button clicked to update instead of ask user to refill it , Function works well but with one field only , I don't know how to make it work for 2 fields when use " &" or other symbol error message appear , when use " +" no error but all string come in one field , Patient_Secludes void progress(int ID) { (this one working) a = DrNote[ID == input.ID].Patient_Secludes ; (No working even added after comma in
Looking for some one to build me a Data Base and CRM ASAP
Hi, I am looking for some one to build me a Data Base and CRM ASAP who can do it Skype gabigeva regards GG
Pass information from one form to another
The reason for my mail is to see if you can help me in a development that I am doing. The main problem is that I need to pass information from one form to another, through global variables or functions, depending on the case, I would like to know if there is a way to do this, and that my action is executed when you press a button or similar. Thanks!
search interface
Hi, I’ve successfully created a search page with html views. The search page allows our users to type in a keyword from any of these fields, Requestor, Request Details and Response. The script is – <%for each find in Add_a_reference_request [((Requestor.contains(input.searchStr) || Research_Request_Details.contains(input.searchStr)) || Response.contains(input.searchStr))]... What I like to do is to create a Boolean expression for the search. If a user types in a requestor’s name and a keyword
cannot edit site, everything isnjust freezed, no drop down menus and cannot publish it. HELP!
when i open my site editor, i cannot edit anything and when i click on publish, the loading bar pops-up and nothing happens for hours.
'item' is a lookup field and child fields cannot be accessed
Hi, I have 2 forms First with product name and rate second quantity and amount i want to multiply rate from parent form field with quantity of child form field and display in amount field. Please help new to zoho creator.. I get "'item' is a lookup field and child fields cannot be accessed" error thanks anand
Cryptography Function (SHA-1)
I need a function that calculates an HMAC hash from a Date String as the value, a shared Secret Access Key (both the sender and receiver have this key), and SHA1 as the hash algorithm. Why? This is a simple way to verify the authenticity of information. For example, if you send an email to a client and included the hash as a "signature", the data can be validated by the client. There are many instances where this would find value. SHA1 is a standard cryptography method Many APIs require a hashed
Problem with Lookup Function
I created a form which does a lookup for PO number from another form, this works fine, however when I try to lookup a second field which contains the PO Name information from the same form using the first lookup results as a filter I get a type mismatch saying I can not use that because it is a BIGINT format, but it was created as a string. Why is is converting this and how do I get around it, or alternately how do I bring multiple fields across in a lookup function and display them in separate fields
Subfrom on iOS app
There is no back button after clicking on a subform in the ios app. This is a big oversight because there is no way to return to the main from unless you add a subform record or close the app. If there is more than one record then the back icon appears but there needs to be an option to return when only one record is there or being added. What's the reason for this? Can this be fixed in the near future? Thanks
Find and Find+Replace
The utility for a Find and Find+Replace aspect to the script editor is obvious. For example, recently I have been converting all my internal URL references to relative links i.e. openUrl("https://creator.zoho.com/mygroup/inventory/#View:My_View","Same window"); to openUrl(("/" + ((zoho.adminuser) + "/") + zoho.appname) + "/#View:My_View","Same window"); Find+Replace would really speed-up the edits. John M. Whitney
Ability to drag attachements from emails straight into Zoho Creator
Currently, if I want to import an attachment from an email into Zoho I have to download it from the email onto my computer, then upload it into a Zoho Creator file upload field. It would be great if you could click and drag the document straight into the file upload field. For similar example, within Gmail you can click and drag an attachment from an email straight into a folder in Windows File Explorer.
SOS! specific entry can't be edited - user gets error
Hi Zoho When trying to edit entry in Loan_Valuations form (ID=2983417000014531035) - when trying to edit from the report, I get time out - when user try to edit using a link, she gets the following message: Loan - Vessel Valuation We failed to retrieve this form. An error occurred when we tried retrieving Loan - Vessel Valuation. This error has been reported to Zoho Creator support. created a duplicate of the entry, same problem please let me know how to fix Ravid
Creator Report with Zoho Invoice values
Hi, I would like to create a Report which include a value from Zoho Invoice. May I know what approach should I use? I read the manual of the custom function feature, but look like it is not I want. I would like to get an Invoice total amount and list it with every records on my Report, assume I already input an Invoice ID for each record. Thanks Mike
Is data stored in Creator encrypted at rest?
I know data is encrypted in transit. Is data encrypted at rest? This is a must for many governmental requirements.
How do I control column display in a subform?
My subform was created as part of the main form - i.e., it does not appear in the Dashboard as a separate report. When displayed inside the main form, it's displaying every column in the underlying form, and I don't want that. How can I control the columns displayed in an embedded subform? I can't see a way.
Error when creating function - on fi
Hi Zoho, when creating a new function I got this weird error. why? Thanks Ravid
How can I include graphics in Record Templates
Hi I have a report that shows company information along with revenues. To improve the look of the report I have created a record template. This works well for formatting text. However, I would like to create a graph or graphics to represent the revenue. I cannot find out how to do the following: 1. A Graph showing the last three years turnover 2. Display a different graphics to denote turnover level - eg A thumbs up for $100,000 revenue and a thumbs down for $100,000 Any ideas? Tony
Check MultiSelect/Checkbox is not empty returns error
Hi, When I try to use both of the following in a function I get an error: if(record.Multiselect_Field_Name.isempty() { } Error returned is: Error details: Error in executing On Edit - On Success script. Error in executing thisapp.Material_Issues_TS.Bank_guarantee_limitations function. Line:(184) Value is empty and 'isempty' function cannot be applied Line:(31) if(record.Multiselect_Field_Name.size() > 0 { } Error details: Error in executing On Edit - On Success script. Error in executing thisapp.Material_Issues_TS.Bank_guarantee_limitations
Look Up Current URL in Workflow Automation
I have created a URL field in my reports for the URL of the current project. I need this so I have a link in Advanced CRM directly back to the original project. So I've made a workflow automation that will fill in that field when the project is created. Now I just need to know how to use the current URL to fill in that URL field.
Next Page