How to reverse rows to columns in reports
If I have a report like the image which I attach is there any way to change the rows to columns and vice versa? To have something like Super High Season High Season II High Season I Mid Season Low Season 02-Aug-2014 12-Jul-2014 07-jun-2014 etc etc 23-Aug-2014 01-Aug-2014 11-Jul-2014 etc etc
Sent mail with the content of Lookup field
I read many post regarding sent mail with the content of Lookup field. The notification email doesn't show the content of Lookup field, instead, it shows the ID number. Anup has answered for one post as following In the new app builder interface the lookups by default is linked to the ID field. So when you set an email notification to get the exact data from the lookup field, you can set the field value as "input.Lookup_field_name.Field_name". This way works well in setting FORM Email Notification
Count Jobs
Hi, I have created a job system which lists jobs per customer. I would like to have a field that counts per customer i.e Job1 Cust 1 - Open Job 2 Cust 2 - Closed I would like a field that shows a count of Jobs open and a filed that shows Jobs closed per customer? Cheers Scott
Print the report summary for multiple records at the same time.
I have created a customized report summary for a report instead of using the default template. The only way I know to print this custom summary is to run the report and click on View Record next to one of the rows of the report. The problem is that I can only print one record (row) at a time. If I have a lot of records (rows) that I want to print in the custom report summary format, doing one at a time will be very time consuming. Is there a way that I can select multiple records (rows) of the report
How to edit the URL in Customer Portal
I am using customer portal in my application. I created a new customer Portal URL but I am not happy with the name of the url which I gave to it. I would like to ask you if there is any way to edit the URL or to delete it and re-create a new one for this application.
Square Register
I am working on an application that will act as a guestbook for a historic site. We offer tours and I have made the form calculate the cost and record cash payment. Now, I want to make the form open the Square Register app that is installed on the tablet the form will be open on. It would open the app when a user clicks a checkbox for credit. Does anybody know how I can do this? I have read how you can do it on an android app, but I don't know how to make it work on Zoho
Stateless Form - contains more than one record (return fields values as list) - help!
Hi, I have created a stateless form from a master form. My master form contains the following fields: Unit No. Lease End Date Checklist Item 1 Checklist Item 2 Checklist Item 3 I have created a stateless form that fetches data from the master list based on Unit No. I worked out that I can then sort column by descending Lease End Date to pull up the most recent data. The Deluge script is as follows: RecData = Master[Unit_Number == input.Unit_Number] sort by Lease_End_Date desc; Lease_End_Date=RecData.Lease_End_Date;
Best way to develop a conditional form with fields that hide, show, clear and follow a series of steps?
I am creating a form that represents a lab procedure to follow step by step where each step is a field dropdown (Yes/ No) and may require data to be collected in a separate field. The steps are all conditional decisions and could lead a user down a different path each time. A user can also go back a step and choose a different value which then takes them down a different path. How can I accomplish this and be able to maintain the flow/ path and make changes to it? I don't think hard coding the
formatting values from related field in a record summary
Hi Zoho, I'm creating a template for a record summary and am having trouble with the formatting. I'm trying to get multi-select values to display in some other way (e.g. ordered or unordered list, or with line breaks) than just value,value,value,value,etc. If I'm just using "Insert Field" I can't figure out how to avoid this. If, instead, I drag from the left and drop the field onto the template, it accomplishes what I want but introduces a new problem: two labels. The left label is fine, but how
Multiply values from different forms in a formula field
Is it possible to calculate in a formula field two values from different forms? Lets say that I have a form called Product with a number field (Quantity) and a second form called Pricelist with a number field (Price). Is there any way to do this multiply Quantity*Price into a formula field?
Why is a new schedule bringing up code from another schedule?
Either this is a problem or this is just the dumbest most confusing user interface... So I create a new schedule, in my case I have 3 custom schedules. I set up the "When to do" part easy then click Save. Next i click "Next". I would expect zoho to take me to a blank code editor but instead it takes me to a code editor containing code from my other custom action. I'm not sure that a new custom action actually creates its own code, instead all the code is stored in the same place. What is the point
How to synchronize two date fields with the same date?
Dear Colleagues, My question is about the date fields. I have two datefields FROM and TO. As you can see in image1.png when I select FROM date (12/1/2015) then in TO field I have again to select the month and the year beginning from the today's date which is not very comfortable. Always the TO date should be after the FROM date. Is there any way to do something like image2.png? When I select the FROM date then the TO date to start with the date which we gave in the FROM field.
Populate a dropdown list
Hi there I'm trying to figure out how to populate a dropdown box based on another form. The setup is: Event Form has typical fields (name, date etc) but also has a multi select lookup from "Class" form. Nomination Form - has some member details (Full name, phone etc) as well as lookup fields for the Event Name and Event Date from the Event Form. On the Nomination Form, there is a subform called "Details" - amongst other fields, I have a dropdown on this subform that I want to populate with the options
Use values in a subform
HI I have one form, with subforms. In the form I have a Lookup field. In the subforms I also have a lookup field with the same values of the field of the parent form. How can I do that if I choose a value from the parent, when I add a new register on the subform the lookup field take the same value choosed on the lookup field from the parent form.?
Fetch Data using Stateless Form - More than 1 record - help!
Hi, I have created a stateless form from a master form. My master form contains the following fields: Unit No. Lease End Date Checklist Item 1 Checklist Item 2 Checklist Item 3 I have created a stateless form that fetches data from the master list based on Unit No. Throughout the year, I may have the same Unit No. that has 2 lease end dates (say 6 months apart). I worked out that I can sort column by descending Lease End Date & the stateless form will pull up the most recent data. The Deluge script
Auto Back Ups
I am looking for a way to auto backup my data in a timely way, so I don't loose my existing data. I would like it to be able to back up to a location, or send me an excel or google drive sheet for each form
How to export all Zoho Invoices into a Form in Zoho Creator?
I need to connect Zoho Invoice to Zoho Creator ( Not the otherway around) without using a 3rd party application. Has anyone accomplished this already? Function Get All Invoices saves the data on a MAP varaiable. How do I get it into a table from there?
Retrieving details from product details from Zoho CRM order
Hello everyone, In the application I am building on Zoho Creator, I need to retrieve product details from the Sales Orders which are in Zoho CRM. // Get the Sales Orders from Zoho CRM salesOrders = zoho.crm.searchRecords("SalesOrders", "(Status|=|Asignado)"); // Add the Sales Orders records in the Orders table for each saleOrderDet in salesOrders { // DEBUG info "Order: " + saleOrderDet.get("SO Number"); // DEBUG // Get the Products from every Sale Order record productOrders = saleOrderDet.get("product").toJSONList();
Populate a field into a form with zoho.loginuser
All, I created a form to enter data for customer engagement. One of the field is "userid" and I would like to populate this with the value of zoho.loginuser so that the user is already presented with a correct value that could not be changed. I know there is "added user" but I have old record where the added user was a different one and that now belong to a new user and I don't know/want to change all the "added user" value for that record. For this old record the "userid" field has been already
Formula field popup warning message
I am getting a warning message before I add a new fx Formula field "All reports involving this field also will deleted Do you really want to change expression?" I am confused because this is a new field and I have not seen this message before. I don't want to lose any reports. Can anyone explain why I am seeing this? I have not seen before. formula ((field1/field2)*100).round(2) Thanks
REST API, POST jsonp and authentification token
Hello, It seems than when using the Jquery $.ajax(type='GET') authtoken is correctly checked and no data can be retrieved if authtoken is wrong. When authtoken is correct, request status is success and data is correctly retrieved. This is, I guess, normal behaviour. But, when using the Jquery $.ajax(type='POST') $('#signIn').on("click",function(){ var formData = $("#userForm").serializeArray(); $.ajax({ type: 'POST', data: formData, url: 'https://creator.zoho.com/api/******/json/*********/form/User/record
Form reading from MYOB
Hi, Has anyone successfully connected a zoho form to MYOB for reading data? I know this post is duplicated but last question on myob was over a year old and only refers to buying third party software? Cheers Scott
Urgent Help for "invalid entries found please correct and submit again" error in zoho creator
I am getting this error message when we update data as "invalid entries found please correct and submit again" in zoho creator. We are adding data sucessfully but can not update it after that.
MultiSelect field doesnt give Item Names but only system ID. How can I get Item Names of selected items from a multi select items
Basically I want item names from lookup based multiselect field. I have a lookup in which I have selected a multiselect field, and when I select items in multiselect and submit the buttons , I only get System Id. I have written following code on submit buttton- <some variable> = input.<multiselectfield> I have even tried fetching Item names using for loop with following code but and I succeeded in getting name but it only returns 1 same name even if I select another item name : for each input
Creating Paydates
I am trying to create an Auto Pay date, based on Bi-Monthly dates, and have it auto fill. I want to use just Fridays and I loaded a start date, and added 14 dates to that date. It keeps coming back as a bad error on Load. Any Ideas? //Next Pay Date Automatic //Add auto increment number x = Paydates [ID != (1 / 7 / 2014)]; input.Next_Date = x.Next_Date + 14; x.Next_Date = x.Next_Date + 14;
Sign In and Out for Embedded Pages
I have a page that I shared publicly. It has some code that forces people to sign in. http://buzzable.info/?page_id=9 How do I get the sign in process to refresh either the iframe or whole page? I played around with the service url and it failed to do anything. After you sign in, I have added a button to sign out. Once again, how can I make the sign out process refresh the iframe or whole page Application buzzap/formacademy has been shared with support. Cheers, John Whitney
"Not able to find 'count' function"
I am trying to edit some code that is currently working but am not getting an error that says: "Not able to find 'count' function" The code with the problem is: filecount = Purchase_Request_Form[ID == input.Request_ID].count(Build_Files.ID); As I said this code is currently working including the count function. Im trying to change a parameter in an if statement in this form and I cant save the updated code now because of this error. I am in free flow scripting mode. What is wrong?
Exporting creator files to word templates
Hi I was wondering if there was any way to export information from the database creator to a template or word doc that I have created. Like what you can do with mail merge in excel. I primarily use zoho creator but am willing to incorporate zoho docs if need be Thanks Chris.
How to reload a stateless form with updated data
I have a stateless form with 2 fields. One is a key of a form. The user enters that field and clicks a button on the stateless form. This button retrieves the form using the key, and copies a data-filed from the retrieved form into the second field on the stateless form. What do I need to do to show this second field to the user? The <reload> function basically refreshes everything. Any suggestions? thanks Henk
REST API criteria in update request
Hello, I've tried to update my Zoho Creator View by using Email as criteria. $criteria = "Email=$user_info->user_email";The response is a failure, with the following response : update: {"formname":["User",{"operation":["update",{"newvalues":[{"WP_ID":"135","WP_login":"f","Origine":"wordpress"}],"criteria":"Email = f@mail.com","status":"Failure, No Records Found With Specified Criteria."}]}]} f@mail.com obviously exists in my zoho creator view, and a test based on another criteria ( WP_login ) works.
Customer portal and pictures
Dear team, For a project I am working on for a customer, I am having some questions related to the announcement on the blog about customer portal. My application will be used by operators in the field. They will therefore use Zoho Creator on their Android device. We would like to be able to add pictures as attachments to a form. This is because they want to have proof of delivery and install done with customer. Is that currently possible? My customer would like to show these pictures to his end customers.
Send Todays Tasks by Email
I have a built a tasks app, I would like to make it so that on the due date tasks are emailed to the relevant person. I am trying to add a schedule using "Workflow" and the "Schedules" and the "form schedule". I have done it all ok but if I click execute to test I get a message asking which task ID. In the "What to do" page I have it set to filter tasks that fit the criteria. Below is what I have in the "message" of the "When to do" page but when I click execute it asks for a task ID. That would
Users unable to view HTML page
I have spent some hours (and had a LOT of help from Herb Wexler) building an HTML page which displays a compiled view of information held on 15 tables within my database. The html page is run through an action button in one of the views. I have shared the page out to all domain users. Until now, myself and the developer have been running the html page and printing off the records, but we are ready to train users and hand this application over to business as usual. Unfortunately, when a user selects
IF statement -- Date == NULL Error.,
HI, I am facing null error on the below 1st line (IF statement). All 4 fields are of type Date. if((((input.From_date == null) || (input.To_Date == null)) || (input.From_mon == null)) || (input.Date_monto == null)) { Execute; } Else { Execute this; } Let me know the solution.,
Conditional if statement in scripting
What's wrong whit this script? Or what else can be wrong? I always get back the FALSE value, 200.0, regardless the input. input.Painting = if((input.BWS < 40.0),2.0,200.0); I have the sensation that the input.BWS < 40.0 has not be considered at all. Do you have some experience like this? (the input.BWS in the <boolean-expression> is Look-up field, with an applied filter, so it is dynamic) can it be a problem?
View Image without login
With Zoho Creator API, image fields are returned as HTML tags with src being the image URL. However, loading of images uploaded to Zoho database requires the user to have a valid session. I am building an application which requires public access of the uploaded images. Is there a solution to this problem without making public my view? Any help will be much appreciated.
Mail Suite Contact Data Entry through Web Form (NOT CRM Contacts)
Hi, I am trying to find out if I can make a web form that can be used to enter contacts into the zoho contacts that are part of the zoho mail suite (also accessible at contacts.zoho.com). VERY IMPORTANT - this is in reference to the contacts in zoho mail suite - NOT in CRM. I did see the webform for CRM contact entry, but we are planning on using zoho primarily for email and possibly campaign purposes, and while CRM's functionalities are impressive, they are not applicable for our purposes. While
Passing value through open URL not working for me.
Im using the following function on each record in a view. This function opens the edit mode for the record and I want it to set the field "edit_design" equal to "Yes". trouble is when i use the function the edit_design field is not set to Yes. What is wrong with this function? The field "edit_design" is in the form Purchase_Request_Form and is a drop down menu with values "Yes" and "No". Im sure this is something simple but i cant seem to find it. Please help! void editDesign_upload(int ID, string
Report for loop Syntax
I'm trying to construct a report that's to the value start date between the first and the last date of the current month. I know that I can do this through a filter but I'd like it to be coded so that I can ahve it be emailed list Report_Example { displayname = "Report Example" #show (for each TimeSheet in Time_Sheet [Start_Time > zoho.currentdate]) ( Employee_Details as "Employee" New_Company as "Client" New_Project as "Project" Start_Time as "Start
Open source fonts
Is it possible to use open source fonts (e.g. google fonts or icon fonts) on html pages? Thanks.
Next Page