Create an app for ordering food, can I do this with Zoho?
I want to create an app that will allow restaurants to easily take orders from online. First, restaurant managers will create an account and post the list of food items. Then, customers can to the page of the restaurant, and order food for pickup. The restaurant will get an email and/or text. Any restaurant can automatically sign up. So, the restaurant will sign up onto my website, create an account, etc. The restaurant will then post menus. Then, people will go to the restaurant page and order,
Change the order of records in zoho creator report
As we know when we add a new record in a form then in the form report it shows it first. Always the first record is the last one in the report Example: 1st: Coffee 2nd: Sugar Coffee 3rd: Milk Sugar Coffee and so on. Is there any way to have the first record always first(in the report) and the others below it? Like: 1st: Coffee 2nd: Coffee Sugar 3nd: Coffee Sugar Milk
Accessing user profile fields in a Deluge script
I would like to be able to retrieve the following fields for the logged-in user in my Deluge scripts: User's first name User's last name User's phone number Is there a way to do this please? I need to use them in SendMail functions to populate the message body and/or subject. Thanks very much
How to track running totals (e.g. inventory)?
Newbie here. I'm trying to do something I think should be relatively easy but haven't been able to figure out. I'd like to track product inventory at stores. To that end, I have: 1) created a form to add stores to the database 2) created a form to add products to the database 3) created a form to add a product to a store; this one utilizes look-up fields from the add store and add product forms. There is also a quantity field to input the quantity of the particular product being added to the
Prevent "Click to wee the data" In Pivot Chart
I have a pivot chart in which I do NOT want users to be able to "Click to see the data" because the detailed data in the form includes information that users should not see. Is there any way to prevent the users from seeing the detail data? It would be nice if we could build a pivot chart from a view instead of only the form.
Why does the same code appear in each individual 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
What does this mean?: [Form_Button_WFlow] Column 'BUTTON_ID' cannot be null
Since there's no duplicate stateless form option, I'm attempting to paste a form definition with action into a blank stateless form definition. It's giving this error. Since it will not let me save the form, I cannot share it to support in any way... Cheers, John Whitney
Accessing variables amongst different fields
I have a form that will allow a user to customize the options of an oven. The oven has a customizable cook top that can have a pasta cooker or a griddle, or burners etc. There is a total of 160cm of space available and each type of cook top has a given space, such as 120cm, 80cm, 60cm and 40cm. When a certain oven model is selected, I wanted to set a variable called space_left = 160. Then display dropdown for each size, so a dropdown for 120cm cook tops, 80cm cook tops, etc. When a user selects
Email notification for sub forms and sub records
I have a form with some subforms. I would like to send an email notification that includes the submitted data. The email notification is sent with the fields and values of all types of fields in the form , but it only sends the ID of the subform and not any fields or raw. WC-352 : 1714287000000191043, 1714287000000191047 WC-352 is a subform and I would like its rows of fields be included in the email as it appears on the record report. the two ID above are related to the following field and values
Add to a picklist dynamically?
I have record Class with field Students, it is a picklist that looks up record Student I need another form, that will dynamically add student to the Class, code something like this theStudent = Student [ID == input.Student]; theClass = Class [Title == input.ClassName]; theClass.Students.add(theStudent.ID); This compiles with no errors, but it wont run or produce any results.
Payroll in Creator
I'm trying to create a program in ZC that allows us to track some payroll information and margins on a per cleaning bases (own a cleaning company with several hundred clients). Here's what I need and I've attached the beginnings of my form/view as well: We work in crews of 3-4 people. Each crew supervisor brings back work orders for all the homes they cleaned each day. Usually between 4-6 homes per day. I need my admin person to take each work order and input the following information on a
copy certain field in multiple data entry
I created a form for data entry called "Report". It is used to register time spent on different project.User have to enter multiple record in a single data entry session and some of the filed are always the same. In particular Month (with is a dropdown field) and Manager (which not a dropdown field). How can I get the following behaviour: - a user log in and go to the application with the form "report' it enter the first data with all the field blank. - hit submit for the first record - when the
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.
Next Page