getting { "message": "Invalid Portal" } in response.
Hi, I have been hitting the below API GET method url = https://desk.zoho.com/api/v1/tickets?include=contacts with authtoken and orgid as headers like mentioned in the API documentation. But I am getting { "message": "Invalid Portal" } in response. I am sure my request format is correct. What would be the problem? when do I receive this response. Please revert back ASAP.
Zoho Creator integration with Books
I have created custom applications in Zoho Creator for billing customers, and sending purchase orders to vendors. Some of these orders have more than 1,000 line items each order. I need to reconcile the credits/debits back to Books. So some integration is needed. Has someone done this and/or can I get some directions on where to start? Thanks.
Linking two forms imported from Excel
OK, new to creator but have some database experience. I have imported three sheets from Excel that are related, i.e they have the same unique column index in each sheet. Had to split my data into three since I had too many columns for Creator. On importing into Creator I want to link / join the forms together so that I can create a report that has all the information in one view. (From reading the help sheets I need to create a relationship to do this. Lookup or Subform.) So, on the Members form,
Email link to record
I'm trying to create an onSuccess email. I want the email to include a link to the record that was just created. How do I go about getting that url?
Add signature to different records at the same time or with deluge
Is there a way to add the same signature to different records at the same time on Zoho Creator, or add signatrue with deluge?
Subform row heights - anything to do about it?
I would like to change appearances of subform rows in Creator Forms. There is a lot of space around the subform fields, which may look good on simple forms. However on large forms this is not practical. My client is looking to move the spreadsheet below to zoho forms. Additional options for columns would also be a blessing! Are there other means to achieve my goal?
Open Google Maps mobile from an application
I am a new user of Zoho Creator and my skills are low I want to be able to open the Google maps mobile when my application is opened on an IPad Using the URL from google maps does not open the google maps app I have tried using Google maps URL scheme but it does not work Overview A URL scheme allows you to launch a native iOS application from another iOS app or a web application. You can set options in the URL that will be passed to the launched application. The Google Maps for iOS app supports
new topic posting problems
why my new topic is not getting posted?
Web Site embedded Dynamic Reports
I have an APP that takes User Input data and does a calculation & queries a database table. When it finds a Record in the database that matches the Query criteria, it generates an Output Report. I have embedded the links for the "User Input" form and the "Output Report" into my Web Site and they appear on that web page. The User Input form works properly accepting data entry from a user, and performs the calculation & query when I click the Submit button. My problem is that the "Output Report"
How to zoho creator create, update o manage variables of XML? Could you give a example?
Good afternoon everybodye, How to manage the XML response of a webservice? For example: <response><result><application_list><applications></applications></application_list><application_owner>Public</application_owner></result></response>
Ideas for Script Editor
I am not a big fan of the script editor adding parentheses. It often makes the code hard to read later. I would like to change the color coding of the text. Thanks,
Quick question
Hi, Need to import data from an Excel file, I have a column related to the checkbox field in Zoho, what do I need to put in the excel column to show in Zoho that a checkbox is checked/not checked? I've used decision boxes for the checkboxes
Change Primary Contact
Hi Team, Good day! Can i possible change the "Primary contact" of my application? see attach picture for details: picture name 123.jpg How can I change the email address send after invitation of the application? see attach picture name 1234.jpg Regards, Jee
CRM lookup not working for some users
Hi! I made a form that has a CRM lookup field (to the Contacts module). When I access the form from the application creators account the lookup field works fine. However, when I access the form as a different user the lookup field doesn't work - it just says "No matches found". Could this be a permissions problem? If so, how do I resolve it? If not, what is the problem? Thanks! Rob
Restore failed / Error Occurred
Hi, I am trying to restore a recent Backup of my main Application (called DEOR) including forms and data to another application with a different name. I get the "Restore in Process" message, but after 10 minutes this is the what I get: Every time creates incomplete copies (no reports) of the original application which I am not even able to delete: Please, I need your help urgently. Thanks, Ceasr
Portal Emails
I have setup the Customer Portal, along with all areas. I have tested and works fine, except for customers email when they do not have a "Gmail account". I can receive the emails if they have a gmail type account, but not from others, like Yahoo, hotmail, or even customer based extensions. I have even tried the notifications area as well. Any ideas?
Execution of form On Load
Form On Load function has.. .... alert("hello"); ... alert("goodbye"); ... When the form loads guess which order the alert messages appear? Thats right goodbye then hello. Errrrr?
Create a Custom Module
Hi, I am working for a client and have a custom requirement. I need to Integrate third party library in ZohoCRM and client prefers it to be in the form of "Extension" which he can install in multiple ZohoCRM instances that he is having. Can you please let me know if this can be achieved? Thanks
HTML page to create record
Hi, I'm very new to Zoho Creator, is it possible, in Creator, to create an html page that users can use to create/edit records? We are finding that the 2 column CRM modules and Creator forms are very restrictive in terms of layout. I have created an HTML page with multiple columns but all I have found is that you can import data into the page from existing records where the input method would be a 2 column form. Our data is working data that is constantly changing and updating, not data that is
Creating picklist in code referencing form in other app
This is weird. I can have a lookup field which references a form in another creator app... but cant have descending order within the lookup field. I looked at the syntax for how the form lookup is declared and figured I'd try and manually build the lookup field contents mylist = othercreatorapp.formname[formfield == input.myfield] ; The above errors with Form 'formname' does not exist in this app! Whereas the form definition has type = picklist values = othercreatorapp.formname[formfield == input.myfield].ID
Is it possible to embed a pivot table report into a record summary?
Hello, I am trying to build a record summary that includes a report I have already created in the record summary along with other information. Is it possible? Thanks
Attachment
When i add attachment as link ( Record Summary as PDF link in Zoho Creator ) in zoho crm it shows as 400 Bad Request How to change that Name? The link that i have used was "https://app.zohocreator.com/parath2/management/report/Management_Report/exportRecSummary?recLinkID=" + input.ID Anyone Solve this
Custom Report looking for differences between records
I'm having a hard time figuring out how to create this report. Let's say I have these forms. Product ID Name Package Template ID Template_Subform Product Package ID Package_Template Package_Subform Product There are other fields in the Subforms, but they're not important. I would like to find out which packages don't match the template. So it's something like: Show me all packages where Package.product not in Package.Package_Template.Product Thanks for any help.
Set Display in a Lookup field to a field in another form which is itself a lookup field
Is it possible to set Display in a Lookup field to a field in another form which is itself a lookup field? Say I am setting the lookup field to connect to the auto index number in another form since it is unique but I want the user to see a combination of a Customer Name + Lot Number since that make more sense for him. How do I do this. Any ideas?
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
Next Page