Complex formula in Creator
Hi I have a formula in Excel: =0.3*POWER(EXP(1), (-5*x)) "x" is the only input. Exp(1) is equivalent to the mathematical constant e. Is there a way to render this in Zoho Creator in a formula or in Zoho Reports? thanks.
Matches Function issue:Fetch record task,unable use Matches in criteria
Using Matches function for a crateria to Fetch record do has a bug or not supported for example matchedRecords = formName [Single_Line.matches("abc.{4}d")]; abc.{4}d is regular expression return variable matchedRecords contains all record from in formName. it means regular expresstion do not work。 how let regular expression do work in matches function at fetch record task?
HELP SALES FORM
USE THE ZOHO INVENTORY TEMPLATE BUT BY ADDING SALES I MADE THIS ERROR, BUT ONLY ON SOME ITEMS, HELP!!!!! :(
Intermittent Math Errors
I have a simple app which works perfectly over and over, then, randomly, it makes a math error. I'm talking about simple addition and subtraction. Maybe it is a processing time issue. Perhaps the next entry is happening while the last one is still processing? Regardless, it makes our scorecards unreliable in the eyes of the users. Help would be appreciated... Our techs use the app/form to walk through a checklist. The result is a number of "passed" items and a percent passed score. Basically, at
PDF View first page blank
When I create a PDF view from a HTML view, it is creating a blank first page. Following is a snippet of the view code: htmlpage Rental_Agreement_HTLM(ReservationNo) displayname = "Rental Ageeement" pdf = true content <%{ RentalAgreement = Rental_Agreement [Reservation = input.ReservationNo.toLong()]; PropertyInfo = Propery [Code == RentalAgreement.Property_Code];%> <table width="100%" cellspacing="1" cellpadding="1" border="0"> <caption><b><%=PropertyInfo.Property1.toUpperCase()%> RENTAL
MIME type may not contain reserved characters / Internal Exception
Good Afternoon everyone, When I try to call SOAP request, it responses with the exception messages 'Internal Exception' map validateXML() { xmlString = ""; xmlString = xmlString + "<soapenv:Envelope "; xmlString = xmlString + "xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" "; xmlString = xmlString + "xmlns:ec=\"http://ec.gob.sri.ws.recepcion\">"; xmlString = xmlString + "<soapenv:Header/>"; xmlString = xmlString + "<soapenv:Body>"; xmlString = xmlString + "<ec:validarComprobante>"; xmlString
Auto-populate multiselect lookup field from another multiselect field
Hi, I want to auto-populate a multi-select lookup field with the data from another multi-select lookup field. Form 1 "Item" "Name" (text field) "type" (multi-select lookup) Form 2 Multi-select field "Item Name" (this lets me pull up any of the form 1 entries) Multi-select field "type" --- this is the one I want to auto-populate from whatever was on the form 1 entry. For instance if form 1 entry was: Name: Pencils Type: Office supplies Then when I select "pencils" entry in form 2, I want it to be
URGENT - Zoho ID seems to have a 1 appended to the end of some users
Hi there I have an issue where by a database that is more than 2 years old has suddenly started acting strangely. Specifically, some "Active Users" ID's seemed to have changed. For example, i have one user who's id is zoho_bear in our system, but in the active users section under Manage Users, it now says zoho_bear1 There are a number of users this has affected, but not all of them. Does anyone have any ideas? Thanks Aaron
single select radio button default value
I want to make a single select radio field with no default value selected. Then I want the field to be mandatory. In other words, the user must select one of the several items, otherwise, he will receive a message reminding him he must make a selection
Public forms not loading/working
Hi, We are getting this error message when accessing our forms that are set to public. Some accounts are able to view it while some are getting the error below. We are also getting the same problem w/ public pages w/ embeded public forms. We already emailed support@zohocreator.com regarding the issue and we haven't received reply for the past 2 weeks. Here's the email reference no.: 18938532
zoho creator plans
I have been a zoho user for more than 5 years. We have more than 20 premium users. We pay the license annually in advance. We love Zoho. But recent changes to subscription plans are not good. The jumps are very big, we do not have ways to add addons and they limit us in many ways. Please ask them as a user to reveal it, those plans are not good. It does not allow small companies to grow. We are limited in records, web components, etc.
Using Zoho Survey for quiz
Hi Have anyone ever use Zoho Survey for Online Quiz Campaign (Desktop & Mobile)? I'm looking for good online engine that can create Online Quiz and review the result in Campaign session, gather user info such as facebook email & contact number, sort user base on date and time by Campaign session (Per Campaign). If anyone ever use Zoho Survey for Online Quiz, would you mind to share some experience with us? Thanks Jack
Published view/report from Zoho Creator to be exported by any user with the link?
I have published a view/report from within Zoho Creator with a PermaLink with a long random string in it. I have enabled this Report to be exported by users. But if a user opens the link without logging in, the view can't be exported. Is this by design? This is not very convenient.
Scheduling recurring appointments in Zoho creator
Hello. We are builind an app for a corporate course providing company. The courses are or recurring nature, for example: Start date 10 nov 2017 time: 10:00-11:30 repeat: Every Friday and Wednesday this means every Wednesday and Friday, this course takes place between 10:00 and 11:30 Until: date is reached (date x) OR a number of (lets say 20) occasions have occured additional fields: location, customer, instructor Then we need to view these events in a calendar and ? or report view, and be able
Background App Refresh on iphones or ipads??
I'm not seeing an option for "Background App Refresh" offered on our mobile devices. This translates into having to come back to a report or record you were working off of as if you are opening zoho for the first time - from the top level of zoho, then click the application, then locate the report, then the record, etc. They take calls, read texts, emails, etc in between zoho updates as well. Coming back to where you left off, background app refresh, seems like basic functionality. Is there a setting
API throws error when passing (&) ampersand and (%) percent via XML
I have the same problem as described in the title and in this related discussion. The above referenced discussion seems to have been moved offline. I was wondering what the resolution was? In short, I am trying to pass (via XML) to the API a URL containing query parameters using the ampersand. The API then throws a 2830 error. Same problem happens when I encode the “&” using “&” — as the percent symbol seems to trigger the identical error. Can somebody please help? Note: I have unsuccessfully tried
"," separator in numbers
I found that in all Zoho Applications the "," thousands separator is causing the number not being recognized as a number. Can this be rectified? this is very annoying.
Multi-language
How to develop a multi-language database with Zoho? The aim is to select a language at the opening of the database and only one.
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
URL field - Link Name
I have multiple records with an entry for field type URL for which the Link Name needs to be updated. I switched to Show as Spreadsheet, so that I can quickly change each entry without having to edit each one individually. Using google chrome. Right click on field, option comes up to replace the value, enter text to replace the existing string ... but it fails to update: Just do double check I go back to Show as List, and the link name remains as it was before: How can I update multiple Link Names
Bulk Edit - wildcard to find/remove blank space
I need to remove an unwanted space in a field for multiple records. Example: TX- 12345678 => TX-12345678 A search using * for wildcard (select field, enter "*- *" shows several hundred records as desired. But then when I want to do a bulk edit to remove the blank space, the field does not show up in the dropdown for bulk edit. How can I remove an unwanted space in a specific field for multiple records at once?
Integration
which voice calling Third party applications will Integrate with Zoho Creator ? and Further Integrate with Zoho CRM Satish Kaushik Zoho Certified Developer, Net Greater Technologies,LLP Mobile: +91 956 071 6262 Email: netgreater@gmail.com Website:www.netgreater.com Skype: netgreater
Help! One to many relationship - idexing
I am new to Zoho Creator, but hope to create some simple but usefull applications. Currently I have a problem that I cant find a solution too, I hope someone can help me. I am creating an applications which makes to possible to register several "targets" in form#1 which has a one to many relationship to values ("tasks") in form#2, which again har a one to many relationship to values ("subtasks") in form#3. TARGETS=>TASKS=>SUBTASKS I am able to create this with lookup fields and subforms, but how
Invitación a AppCreator
Estimados, llevo mucho tiempo esperando la invitación para utilizar AppCreator; cada vez que entro recibo el mismo mensaje: "AppCreator - Your invite is on its way! You have requested an invite to sign up for Zoho AppCreator. Thank you for your interest. While we are excited to have you on board, there are a couple of things we need to do to make your experience comfortable with us. We shall send you an invite as soon as we are ready." Podrían indicarme por favor en qué estado se encuentra mi solicitud?
Feature Request - Total application count
Hi there, In the usage details section of the dashboard it would be very helpful to have a total application count to tell you exactly how many applications you have. We have hundreds so actually counting them up is extremely difficult. I'm sure this feature would be beneficial for most users Thanks
Is There a Way to Turn Off Picklist Filtering
Hi, I have a lookup field "lessons" that I want to be filtered by a lookup field above it called "modules". Here's the thing: I also want the option to choose a lesson regardless of module. Is there a way to create an option to switch the filtering "off" from the form? Thanks,
Importing two linked tables
I have not found any information on importing two linked tables. Say I build table Suppliers and table Products. Now each of these is a table in Excel. I have a unique Supplier_ID column in the table Suppliers. In the Products table I use this ID to reference the supplier. Creator has a built-in ID field for each from. Since it is an auto-number field, I plan to use that to link tables in the Creator. Is there a way to import Excel tables into the Creator so that data from both tables are properly
Run a Google Script from Zoho
Hi All, I have a script in Google Scripts that I'd like to run from Zoho. The script has a few parameters, including a file that I need to attach. Is it possible? Thank you Ravid
Concern
Hi, Every time i submit it will always pop up error like the picture below: 1 picture is the first error. 2 picture is "Successfully send remarks" and i attach my code;
Creating report containing email addresses so that I don't have to input email in every single form?
I have a Vacation Requests form. The basic process is this: Employee submits vacation request Submit button then determines who is sent a notification for 1st approval. (It could be a number of managers, depending on which department, etc the employee is in) 1st approval person approves/rejects. If they approve, it is then sent to the HR Manager for review. She/he is sent an email telling them to review this. HR Manager then decides if she will final approve this or if the President of the company
Not able to change a report to spreadsheet format
I have a report that I'm trying to convert into a spreadsheet format, so that fields can be edited from the report screen in one click. However, I'm not getting the view I'm expecting (see screenshots) – i.e. the report is still uneditable unless you click into an individual record screen. Any ideas why?
Lost Table Relationships
Hello. I have used the MS Access Migration Tool several times to upload/import my Access database to ZOHO.. All of the tables and data seem to be there but none of the relationships. Any idea on what I'm doing wrong?
Updating Application/Patch
I have two zoho creator application 1 is the original and 2 is the duplicate. 1. The original application will be used by others by sharing to them the permission to used. 2. The duplicate one is for me to change or to update the application. My question is: How do i update my original application from duplicate one without deleting the users,data and the user profile of the application? Thank you in advance, Jee Zoho creator User
Insert into returning lookup ID instead of value
I am creating records on a secondary form on submit and everything works great except the client field, since is a lookup field on the main form, it is inserting the ID into the secondary form record, can you please help me telling me how to convert the ID to value? [ Added_User = zoho.loginuser Cliente = Cliente (this is a lookup field) Codigo = Paquetes_sub.Codigo Telefono = Telefono Paquete = Paquetes_sub.Paquete Fecha_de_vencimiento = Paquetes_sub.Fecha_vencimiento Servicios_disponibles = 2 Saldo
Performing a Look-up within a Function
Hi - I'm having trouble fetching a string value in conjunction with a Function that uses a Form Object Argument. I have a Tasks Form that uses a look-up to Project_Name from another form....once a Task is Completed I would like to be able to press a custom action button to have it marked completed and logged in a separate Project_Notes form. The code below is working but it is giving me a numerical value for the Project_Name in the confirmation email. Normally I'd do a look-up but this doesn't
Format the Excel - Export Data
Hi Team I can export the data using url in excel format. for eg: http://creator.zoho.com/zchelp/employee-manager/xls/Employee_View My question is that Can I get the Excel file as the First row is in Bold .So that it will differentiate from the data.Also Can IAdd some header text in the file, ie, Employee Details Please Help me Thanks
How do I create multiple views in a Report?
I would like to create many visualization layouts without creating new reports. In Customer Portal, if a customer modifies a Report, Zoho suggests to create a View inside the current Report withour creating a new one. When I modify a Report as admin, this option does not appear, only suggesting me to create a new Report. Where is it hidden?user
Next Page