How Do I Add a Filter to a Public (Permalink) Report URL
I have a public URL (permalink) where I am exporting as a xls. How do I add criteria to the export link? http://creatorexport.zoho.com/<username>/<app name>/xls/<report_name>/NSSrKNu5hhjZCQDDmEFmg6DkD4JGSR97HPSEGrgY0pVW<crazy_permalinkCode>/&Neighborhood_Associations.Active='false' But this does not work. I can use that exact critera in a non-permalink and it works fine. Can someone help with the structure? I cannot seem to get it right.
External Database Source
Hi everyone, Is it necessary to store data in Zoho creator database when I input the record through Zoho creator form? As there are some sensitive data, I would like to retrieve and store data on my SQL server or private cloud. Thanks.
Barcode scanner attached to PC
I am exploring the options available to use barcode scanning in a Zoho Creator app. At the moment it is possible to scan barcodes using the creator app (iOS), but this means users always needs to have access to a mobile device (phone/ tablet) Is it possible to use a standard barcode scanner attached to a PC to scan barcodes when the app accessed through desktop browsers ?
What is the right way to implement a new design onto an existing Zoho application
I'm new to Zoho but a long time application developer. I'm about to start making some modifications to an existing live Zoho Creator application. However, clearly I want to create a development version, make the changes there and then somehow update the live application once testing has been com pleted. My problem is that I can't find any documentation anywhere that explains the right way to safely and confidently transfer my updated design to the live database for implementation, and I don't
Zoho creator Sandbox and making updates to a live system.
I'm finding the help file on sandbox too simplistic to help me make some major design changes to an app i have been working on. It states that " Changes in Form Definition and View Definition cannot be made in Sandbox mode." However, there is no explanation as to what is meant by Form definition or View definition. I am still new to Zoho Creator and would like to know exactly what this means before I start using the Sandbox and finding out the hard way that some of my changes have not been implemented.
URL link to form not working
I created a webpage with a 3-button menu. Every button links to 3 different forms in my zoho creator app (using the URL pattern for example: "https://preapp.zohocreator.com/<my user name>/<my app name>/#Form:<myform name>" This menu page works perfect in the desktop version, and was working OK within the mobile app (which we use to scan QRCodes), but now when you click any of the menu buttons I got a message "An error occurred"... I emphasize that this happens only with the zoho creator app on my
Attach custom actions to security profiles
Does anyone know it you can attach custom actions to security profiles in zoho creator? The requirement I have is to approve purchase invoices. But the approve button should only be visible for the users in the management profile and for the users in the assistent or other profiles.
HIPPA
Are Zoho products HIPPA secure?
Call Deluge function via rest/xml rpc api?
Hi! I need to invoke deluge custom function via api. I can't find any information about it, except this tread. Is it possible? Thanks, Alex.
form/report to appear in multiple sections
Is there a way to assign a report or a form to appear in multiple sections? I want to create several sections for certain groups of users. (techs, manager, admin, etc)
Email
How can I add many emails adress in the same fealds? or add new feald for a new email adress'
Multiple mandatory fields
Hello, I'm trying to ensure that several fields are filled in based on following statement. if(DeliveryOption == "משלוח") Each field should produce different error message So I've created several "rules", one for each mandatory field like this: if(DeliveryOption == "משלוח" && DeliveryCity == null) { alert "יש להזין עיר למשלוח"; cancel submit; } if (( DeliveryOption == "משלוח" ) && (RecipientStreet == null)) { alert "יש להזין רחוב למשלוח"; cancel submit; } if (( DeliveryOption == "משלוח" ) && (RecipientHouseNum
Using Zoho Creator Login for Custom built mobile app and web application
Hi, We are trying to enable logging into our Custom mobile app and web application using Zoho's Creator's credentials. Is it possible to do the same? Do Zoho has a authentication apis/equivalent to do the same? Regards, Jeeva Gautam C K
Creating a CRM Task and assigning it to a CRM Lead
Hi, Hopefully a very simple question. I am trying to create a script in Zoho Creator that does a number of things. After a form is completed and validated do the following: 1. Send an email - Done 2. Create a new lead (or update an existing lead) if it exists - Done 3. Identify the lead ID in point 2 - Done 4. Create a new task for the lead created / updated in step 2 - Problem I am having an issue with how to create a new CRM Task AND assigning it to a lead. I can create a task, but it does not
Issue in checbox enabling
Hello , I'm facing some issue in checkbox. On some condition it should be able to check the checbox. It was working fine till now. But dont't know why it is not working! 1st form:Order 2nd Form: Line items. one Order has multiple line item. In the line item one check box is there. If the check box of all its line items is true, then Order form's one checkbox should be enabled. Earlier it was working fine but right now its not working. is it a org problem or what? How to fix this issue please
Error when trying to import .ds file
Hi I'm trying to import a .ds file from my developer account to the client one and am getting the following: Problem encountered while creating the application Error at line number : 727 Number of arguments mismatches A conversation using the chat feature seemed to time out though there was mention of needed to relink things? Can anyone help? Thanks
Dynamic Lookup field
Hi I have a lookup field (Lookup field 2) to show entries from another form. How do I control it to show variable # of entries per value entered in another field (Lookup field 1)? On the "on user input" action of the other field (Lookup field 1), how do I generate in real time the # of entries for this look up field (Lookup field 2)?
Zoho Creator - Subform not visible in OnEdit of all records.
Hi, I can't see the subforms in my OnEdit view, There are No error messages, and I can access those fields in OnAdd. So that it's proved that I have the access rights for those forms. How can I make the subforms visible? Any suggestions would be helpful, Thanks in Advance.
getUrl returns "internal exception"
I want to get a json list of items from a webservice: map Campaign.listSibCampaign() { mapheader = Map(); mapheader.put("api-key","Ab7XXXXXXXXXXXcaJ"); resp1 = getUrl("https://api.sendinblue.com/v2.0/list?page=1&page_limit=2", mapheader, false); return resp1; } This works fine with Postman I get this { "code": "success", "message": "Successfully retrieved list details", "data": { "lists": [ { "id": 689, "name":
Error message advanced email in Zoho Creator
I keep getting this error message. What I am doing wrong? Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression 1 sendmail 2 [ 3 from:zoho.adminuserid 4 to:Properties_20170822_200937[ID == input.Property Name].Email 5 subject:"Subject of the email" 8 message:"Your message" 9 content type:HTML ]
Validate multiple rows in subform
I currently have the following script in Form Actions > On Add > on validate: for each row in Order { inventoryamt = Promotional_Item_Input[ID = row.ItEm].Quantity_In_Stock; if(Order.Quantity > inventoryamt.toLong()) { rec = Promotional_Item_Input[ID = input.Order.ItEm]; alert "There are only " + inventoryamt + " left of " + rec.Item + ". Please adjust your order quantity."; cancel submit; } } It works to check the quantity of items ordered against quantity in stock for the first row in the subform,
Fetch criteria with "if" ?
Hi All, I have a function that gets two variables: Date (date) and SectionName (string), fetch entries from a form by criteria based on those variables, and than makes a change in the entries. The criteria always targets the "Date" field, and if "SectionName" var is not empty, it also targets "Section Name" field. Currently, I have the same syntax run twice - once if SectionName != "" (meaning it's not null, and than the function use it as a filter) and second time for SectionName = "" (meaning it's
Sharing permissions in lookup fields
Hi, I' trying to test sharing settings. I successfully managed to limit a user ability to see form A records not created by him. However, if in form B there is a lookup to form A he will see all records. Is this how it should work? How can I also limit the view permission in lookup fields? Thank you for your help. Bruno
Is anybody working in sand box environment
Hi Here is my story. I have to create assessment application with 43 forms. In first release, I've created 20 forms and moved to production environment. My client also started to working on it. I was supposed to create rest of the 23 forms on the same application and also need to test. When I approached zoho support, I was asked to use sandbox feature. But I could n't create sand box, as the application took too long time to create.Again support team helped to create sand box environment. I was
Images Broken on page?
hey all So I have a page that displays selected product information triggered via a custom function on a report. It shows the name of the product and price fine (also tried a bit of similar code for the image but just retruns a "True" string) Trying to get it to show the image that has been uploaded too, but keeps returning a broken image. here is the code im using at the moment: htmlpage ProductSample(empid) <%{%> <h2>Mood Board</h2><%prodLst = input.empid.toList(); for each prod in Add_Product
Disable row in subform
Why Can't I disable row in subform? Is there any way?
Combined Report - Setting report criteria with form fields
I have a Products Form (name, minimum stock) and Product Stock Form (product, current stock). I would like to display only the products with low stock. Like Product Stock Form->current stock < Products Form->minimum stock. It looks like the set criteria allows to enter values only. Is this possible?
Public sharing does NOT work anymore "Make public to all visitors over the web"
Dear Zoo Creator Support team, for our "werksviertel" Zoo Creator App we need public sharing of forms with the "Make public to all visitors over the web" feature. We use this feature already on several Zoo Creator applications and also within the "werksviertel" App, but this "Make public to all visitors over the web" feature is not available anymore. We use this public sharing option to request Zoo Creator data objects and image URL's via the JSON interface. I am an longtime Zoho Creator Enterprise
Uploading File via Restapi to Zoho Creator
Hi, I have developed an android application which sends image as a file to creator using the restapi put method. The request url is "https://creator.zoho.com/api/xml/fileupload/authtoken={authtoken}&scope=creatorapi&applinkname={applinkname}&formname={form_name}&fieldname={fieldname}&recordId={record_id}&filename=testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting.jpg&sharedBy={adminname}" But it doesnt work if my file name is "testingtestingtestingtestingtestingtestingtestingtestingtestingtestingtesting".
How to show a lookup with dynamic filter
I have services form (Plumbing, Wiring etc). I have Resources form. Each resource will work for different services. The services are selected through Service Lookup with multi select field. booking2.png. I have a booking form where I need to select a service and assign the booking to a resource. I have resources look up. Now I need to show the look up based on the selected service. (booking.png).
Search button
Hi All, Is it possible to search every record on the main menu on zoho creator? Because now i have to go to the report first to search records and the search of the reports is not handy. Thanks
Events from another form in Record Summary.
I have two lists. The first one is a list of people with their basic information. The other list is a list of events, on which I classify certain events, tagging the people involved. What I need is that in the people report, each record summary shows, below the basic info, a report of the event on where each person was involved.
Managing master and reference data
Hi, Hope you are well. I have a number of apps on Creator and am finding that some of the forms that I am creating are quite similar across the apps. Up until recently, whenever this has been the case, I have just used a lookup to the form that already has the data that I need. I have been reflecting on this and thought that this is a messy way of doing things as the master data required in order to make the rest of my apps work is all over the place. FYI, the kinds of data that I am referring to
How to filter a report with a lookup field using URL parameter?
I have a booking report with bookings assigned to users. I would like to show bookings assigned to a user based on the url parameter. I open the url like this. https://creator.zoho.com/XXXXXXXX/booking/#View:Booking_Report?Assigned_To=3021232000000294010 But it shows all records. However url parameter seems to be working other field types. Any idea?
Help needed: HTML Creator
Hello, I am new in this forum and to Zoho Creator. I made my first steps with Creator and Deluge and everything is fine so far. But now I hit a wall: I like to make custom Dashboards / Pages apart form the standard Report ones. To do that I have to program in HTML, right? Could you recommend me programs in which I could build html pages via drag and drop in order to copy the html code and paste it into the Zoho Creator Workflow in order to build my custom Dashboards / Pages? Thank you :)
Formula
Hi guys, MY clients can pay in 2 terms when ordering something from me. I use formula to track how much they still have to pay me, but is missing the payment 2 What i need is: 17-8-17 Price = 10 Payment 1 = 5 Payment 2 = 0 Payment 2 day = Need to be paid = 5 (Formula) 20-8-17 Price = 10 Payment 1 = 5 Payment 2 = 5 Payment 2 day = 20-8-17 Need to be paid = 0 Can someone help me with this? because i already have price-payment1 and it works. but if i try to put payment 2.. it stops working.
Query String Parameters
I've looked up all the Forum posts on Query String Parameters and I can't seem to find a direct answer to this question (lots of work-arounds thought). In various web programming languages, there's a way to access incoming Query String Parameters. For example, in PHP, if someone follows a URL like this http://www.example.com/page?myVar=xyz You can reference $_REQUEST['myVar'] Is there a way to do this in Deluge? Currently, I'm using a work around, I'm passing in a value via Query String like this
[Question] Subform Total Calculation and Main form Total
Dear all, I was making an application for car repairs. I looked at the sample from Zoho about subform https://www.zoho.com/creator/newhelp/forms/creating-subforms.html and would like to do the same, which are: 1. The subform will have a total per subform line 2. There's a total in the main form to total all subform line Please help me how to do that in the formula field both in subform and main form. Thank you very much. Michael Dharmawan
Mismatch data type for function 'addAll' at argument index 1 expected data type LIST found data type STRING
Hi There, I am going mad trying the accomplish the following: I am trying to run an algorithm from a stateless Form. I have Two tables TABLE OFFICES ------- OfficeName (String) TABLE USERS --------- User (String) OfficeRights (This is a Multi-Entry Lookup that takes many "OfficeName" from Table OFFICES) email (Email) Im trying to obtain all "OfficeName" from each User in TABLE USERS and add them to a list called ListOfz ListOfz = List(); for each Usr in USERS { ListOfz.addAll(Usr.OfficeRights.OfficeName);
Data will not display on published Page
I am working on an app to allow users from a website to search for and display certificates that are created on the fly by entering a product number in a search page and then having all of those certificates display on the page. I have developed it and it works in my creator home but when I publish it its not finding any data to display. What am I missing here I am sure its a simple fix. I am new to Creator. Tom
Next Page