multiple many-to-many relationships
Main Problem is I want to ensure the database structure is correct so that I can convert it into Zoho Creator Form Combination (This is one element from a multi-function 50 Form application (Functions range from ordering products from suppliers to maintaining inventory etc...) I can give access if necessary, I have attached a visual of the 'problem' as Design Specs.pdf and A copy of the already implement database in Zoho Creator (which works and I am happy with, I develop the relationships in Access
User Creator to create seo application to track domains and project status/next actions
Is there a way to use Creator to extend ZOHO Crm to track domains per Account and marketing activities. Is this done easily by integrating zoho projects or do we need to build a custom app in Creator? Thank You
Missing Embedded Code
Dear ZoHo Experts, I have a problem with ZoHo Creator, i have builded an app. It looks good. But now the problem: I cann't find the embedded code for the website. It seems that the embedded code has disappeared from the Publish tab. Can you figure out what is wrong? Is it a bug that you have to solve? Kind Regards, Jan Willem
Possible Bug?
Hi, When I try to execute the "Add Product" action from your Order Management 4.0 sample. (Please refer to attachment Script image) The Error message displayed. (Please refer to attachment Error image)
Why does this request give error 2892? The application name is correct.
https://precreator.zoho.com/api/json/myapp/forms/?authtoken=0e508cec205591dc3f137662b614f2fb&scope=creatorapi I don't know why this gives an error. The authtoken and application name are both correct. Is this a bug? If not, how can this be fixed? Thank you.
Not All Table Objects Available in Form?
In my Phone_Line form, I am trying to add a reference from another form Line_Account. The following is the code from the field I'm creating in the form Phone_Line. Why does this work: must have Line_Account_BTN ( displayname = "Line Account (BTN)" type = picklist values = Line_Account.ID displayformat = [ Parent_Account_ID + " - " + Phone_Number ] sortorder = ascending searchable = true width = 206px ) But this does
Is there a formal enhancement request system with Creator?
Is there a formal enhancement request system available for Creator? I am hoping that I can log many enhancement requests to make this tool more wonderful. It is a great tool already. But like every piece of system, there are always rooms for improvement. I would appreciate if any of the Zoho Creator team can response to this. Thanks.
Import Inline Subform Data
Is it possible to import data from Excel to a form that has embedded subforms in it (subforms that are created inside the parent form as opposed to being created on their own and linked)? In excel I have one subform field populated with comma-delimited values. In the import wizard, I map this excel column to the subform field (tried it by selecting and deselecting the import subform data checkbox on the first page of the wizard). The import declares success for both the parent record and the subform
Automated Mail to Specific used
Is it possible to send automated mail to specific users based on user selection? I have 5 spocs whose names are available in the drop down field, Automated mail need to be send to them based on the user selection with some or complete data of the details entered by user. As of now I have used send confirmation mail option which send mails to all users. I need to restrict it to specific users. I don't know scripting nor any have any developer to help me. I understand it is possible with little bit
Possible bug with date-time list
I have a records with date-time values (Program_Starts), and have copied some of the values below to explain what I'm seeing 29-Apr-2014 13:00:00, 29-Apr-2014 17:00:00, 30-Apr-2014 09:00:00, 30-Apr-2014 13:00:00, 30-Apr-2014 17:00:00, 01-May-2014 09:00:00 What I'm trying to do it make a list of records that only have date-time values after today. Here's my code class_list = (Classes[(Program == "XYZ" && Program_Starts > zoho.currentdate)].Program_Number).getall(); When I run this, it returns all
Calling Zoho Creator API from .net CSharp
I'm able to make the request with desired fields (WebRequest.Create), using csharp code but got an error in response. Below is the response (request.GetResponse()), all required fields are provided still I get the error: Failure, Enter a value for...... <response><result><form name="Decision"><add><values xmlns="add"> <field name="LDC"> <value>AGL</value></field> <field name="Commodity"> <value>Gas</value></field> <field name="Customer Name and Parent Name"> <value>TEST CUSTOMER</value></field>
Issue about HTML page
Hi, In old edit mode, I can using the code in HTML as below: <%if (count(Dept[Dept_NO == 1])>0){%> You have already added the department. <%} else {%> You need to add department first. <%}%> But in new edit mode, I can not using this code in HTML. It displays "null". Kindly help me to check it ?
Implement search algorrithm on zoho data
Hi, I have to created a form which takes the user input and stores data, for example a form like expenses. Now i have to create a page which will take input like expense type/date/ expense by fields and select all the rows belonging to the input and calculate the aggregate expense and display it to user. If i give all the parameters the logic works but i want to know if we can build dynamic queries based to user input to fetch the records from the database.
getUrl has stopped working. Are others facing this issue too?
I had a working application until yesterday and the now, the getUrl call returns null for the code and text!! I have verified this both ways - I make the get call (from my browser) from my own PC and it works without any issues and I have also tried several other urls in the getUrl call. getUrl simply does not work. My suspicion is that a backend upgrade by Zoho could have caused this issue. Is anyone else experiencing a similar problem?
need help with regular expression and matches function
if(mystring.matches("?")) == true) I need to check if mystring starts with number or any letter in alphabet A-D, not sure how to do it. Thank you in advance for help.
Need help for stateless form
I am currently want to learn how stateless form work. I look at the instruction zoho provide but I don't understand and could not make it work. I am new to Zoho and programming. could any one help me make it work please? Currently there is no error but when I pick the list, the name field is not pulling the name in to the field box I am welcome any example that could help my understanding such as example application or explanation of the code. Thank you
Login System with Master Admin, admin and users
My question is quite general and i would like your suggestions. It is not about technical problems etc. Well, as we know, customer portal has limitations (unfortunately, we can have the same permissions to all the users) my question is as below: Is there any way to create manual a login system with Master Admin, Admin and users? Let's say an example. We have 3 hotels (A, B, C) which are parts of a main hotel (D). We would like each hotel (A, B, C) to have separate users (login for each user). Each
Customer Portal
I'm evaluating whether Zoho Creator is the right tool to implement an application that I need. The application is a booking/payment system for a mobile car wash company. There are many vans, going around to many buildings and washing residents' cars on-demand. Here are some of the requirements: 1) database storing all buildings, customers and all their respective cars 2) schedule of which vans are going to which building and when 3) secure login system for customers to register, store/edit all their
Changing Import Data field from type Radio Buttons to Drop Down list
Dear ZOHO, I have an Import Data field in my form and it is displayed as a Radion Button control. However, I want to change it to a Drop Down list display. In the editor, I does not seem to be possible to change the diplay type. Do I really have to define this field all over again? This would be very cumbersome and difficult. Is there a way to change this more easily? Thanks in advance. Silvester
Convert decimal to big int in .addDay() function
I am trying to use the .addDay() function but the number of days will be determined by a calculation using several date fields. I'm getting the following error and don't know how to avoid it. Mismatch data type for function addDay at argument index 1 expected data type BIGINT found dataType DECIMAL The code I'm using is as follows: request.Date = request.Date.addDay(((request.End_Date - request.Start_Date) / (1000 * 60 * 60 * 24))); I know there is a function to change a big to decimal but
Creator reports restrict access by user ids
Here is what Im trying to do. I want to show records of my report only to selected users, in my case I have many Hotels and I want users to see records only for their own Hotel. Here is how Im doing this: Im creating certain groups of users by creating a form User_IDs which holds "hotel_id" and an Email (which is zoho.loginuserid) , so each logged in user belongs to a "hotel_id". In my Hotel_Details form I have a lookup field hotel_id, so I want to show records only if zoho.loginuserid in form User_IDs
Creator removing final zero in decimal field displayed on a page.
Im having a display issue when I am showing decimal fields from a form on a page. Creator is removing the last 0 in the number. The problem is that my decimal fields are set to 2 decimal points but they display with the wrong number of decimal points. I want the number to display as follows: 45.00 or 45.50 or 45.20 Trouble is they display as follows instead: : 45.0 or 45.5 or 45.2 Creator is cutting off the last 0. I want this zero to display. How can i get the zero to show? My page uses the following
how to use aggregate functions in a subform context
I would like to use the "sum" function in a subform script as follows: On User Input (for a subform field): input.Total = rows.sum(Item_Amount); This doesn't work at present. Any suggestions? Will this be implemented in future? Anton
Importing Data from Google Spreadsheet Using Deluge Script
Good day to you, I would like to be able to import data from Google Spreadsheet using Deluge script. Is this possible? I'm able to publish a spreadsheet to the web and is gives me a url like the following: "https://docs.google.com/a/mydomain.com/spreadsheet/pub?key=0.............&output=html" Any help would be appreciated.
Usage Limits report is badly broken.
Usage limits as seen from at: https://creator.zoho.com/dashboard#usagelimit is badly broken. The used and remaining measures have apparently swapped. What's worse is that cleaning up data is actually decrementing this 'new' used count. Please take a look at this urgently! -Varun.
Multicheck boxes and subform
Hi, I create a POS for Pizza and i have the follow problem to fix: I create a form that include a subform to choose the product and a second subform with multiply checkboxes that you can choose the extras. For example you can choose: PIZZA MARGARITA and in Extras you can choose EXTRA HAM +0,20$, EXTRA CHEESE +0,40$ etc.... All records works well but my problem is how i can fetch the prices for calculate the total. Right now i try to fetch by: row.TIMH_EXTRA_SUB = EXTRAS[ID == row.EXTRAS].MASTER_TIMH_EXTRA.toDecimal();
How to add to a date but not add time?
I have a field called Checkout_date that has a date without showing a time (i.e. 1-01-2011) I have a Due_Date field that has the following formula Checkout_date.addMonth(4) The result that gives me is 5-01-2011 02:00:00 How can I make it so it doesn't show or doesn't ever include the time, only the date?
Multiple records update with zoho api
i have a requirement of updating my zoho records from my website through api. is there a way to update the zoho form records throgh an api of my web app.
Inventory Form Question
I've made an inventory form to receive inventory items and set up initial item quantities. i.e. starting inventory = 1,000 widgets. But I need help creating a new form to enter daily sales and have those sales reduce inventory quantities. i.e. today's sales are 100 so the new total quantity needs to be changed to 900.
Subform Drop Down Field Width
Hello everyone, This is one of the most common form fields - a lookup to another database referencing products/services/products etc within a subform. However, as it stands now the width of the look up field is extremely narrow and even though there is a horizontal scroll bar on the bottom of the drop down users have a VERY DIFFICULT time selecting the correct record. Please try to address this as soon as possible or as a quick fix until they can be customized just increase the default width....
look up field or drop down with numbers
Is it possible to have a loop up field or drop down with numbers and then work with those numbers on a pivot report. Right now even If I have a look field as number on my pivot is reflected as string and I cannot work with those numbers. see my attached
count() is automatically replaced by Zoho platform with count(null) in html views
In a html view I have the following code: <%=users[ID>0].count()%> When I close the edit mode and open it again and return to the view, the code above appears as <%=users[ID>0].count(null)%>Of course, if I try to save the html view, an error is displayed "Field null does not exist ... " So .count() is automatically replaced by Zoho platform with .count(null) - which is a wrong syntax . Regards, George
Any way to get Minimum Date in a Creator report?
I'm trying to figure out some way I can use a minimum aggregate function (or conceptually comparable approach) on a date field in a Creator report. If there were a Min/Max option like there is for numeric fields in a basic list report with grouping, that would work - but there's not. I tried to use a pivot report, but date fields do not appear to have a min/max calculation option here either. Is there any way that this can be accomplished with reports (I know it can probably be done with custom html
Update Lookup based on Dropdown selection
I have a stateless form with a lookup, dropdown and a number of single line fields The form currently works with the lookup pulling back an object when an item in the lookup dropdown is selected, this then populates the dropdown and single line fields with values in the data repository. I'd like to improve the form by allowing a pre-selection in the dropdown list which acts as a filter on lookup. Is this possible?
can i insert data in subform (Blank/Inline subform) by code???
I have a parent form with a subform. The subform is called "conceptos". i am trying to copy records from parent form, but i can not copy the subform data. i am using this code: propuesta = formPropuestasProveedor[ID == idPropuesta]; //-->The record that i want copy insert into formPropuestasProveedor[ codigoProveedor = propuesta.codigoProveedor codigoPeticion = propuesta.codigoPeticion proveedor = propuesta.proveedor letra = propuesta.letra conceptos = propuesta.conceptos //--> the subform data
RFP for Vendor evaluation
Hi, I'm looking to implement IT software and would like to invite vendors to respond. I'm going to put list of questionnaires (which can be designed through zoho creator) with different forms & pages I'm planing to notify vendors to direct to the zohoform, so that they can login and update the information - They should be able to save and come back at a later stage to edit (obviously need to create user) - They shouldn't be looking other vendor responses (restricted to their own entries Can
Mandatory attachement
Hello, how to force the user to attach a file to validate the recording? Regards,
Cannot figure out how to fetch data from a subform field (on_user_input)
Hello, I am a new to Zoho (just bought the license) but I am an experienced programmer and database developer. Yet I could not figure out how to fetch data from a field in a subform. I am following the documentation, in my subform, my lookup field execute a field action script on_user_input. The goal is to fetch an unit cost for the selected product - very basic stuff ! So my script is the following: selected_ingredient = Ingredient_form[ ingredient_name == row.ingr_name ] ; Ingredient_form = name
Record Limit Workaround
I'm working on an app for a client that holds practice SAT tests. They want the app to be able to create and store 200 question long tests for up to 100 students (currently, although they plan to expand in the future), and each student may have up to 5 different tests. They also want the app to include a variety of Zoho Reports showing breakdowns of statistics about types of questions, responses, and so on. Right now I have it set up so each separate question on a test is its own record, as is each
Email Notification via custom action - Urgent Request
Hi, Is it possible to send email notification via custom action for a particular record and include user submitted data template (custom record summary) as pdf? Please let me know your answer at the earliest. Thanks! -V
Next Page