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
Anyone know the Zoho Invoice Status Codes?
If I do a call to Zoho invoice and want to return the status of a particular invoice, all I get is a string number as opposed to the actual written value of it (i.e. "5" for "Void" etc) I've been searching far and wide, but have yet to find a resource that contains the translations for these... so far I've been able to extrapolate two and script them like so: i = Invoices [ID == c.Select_Invoice]; s = zoho.invoice.getInvoiceInfo(i.Inv_IDN); st = s.get("Status"); if (st
Print PDF
Hi, I want to capture some details in Zoho Creator form and on submit, it should print 2 copies of data, 1 of the printer can be Google Printer. How is it possible? Any Ideas?
Subform and Mainform relationship when using creator remote api
I have a main form and subform with subtotals the subform. If I want the main form to be updated when saving a record to the subform, where do I attach the script? I realize 'On user input' when I'm using the web interface, but where do I place the script when I'm adding records through the API?
Adding the totals from two reports
Hello, Does anyone know if it's possible to add (and subtract) the grand totals from two reports? I have two reports, each showing totals of the figures for a list of stock items. Both reports show totals of the same items... one is stock in and one is stock out. What I'd like to do is deduct stock out from stock in to give me a running total in a new report or page. Any help on how I might set this up would be appreciated. Many thanks.
Need to pull data from multiple tables into an HTML Page
I have a database containing student data. Within this, I have an html page to display (and allow staff to print) data from 15 tables. These tables are linked via a FullName lookup field. There are multiple I have created an html page and now need to: 1) Insert the zoho creator field names into relevant sections 2) Create new rows where needed to display multiple records in sections (eg My Family Contacts, My Daily Requirements, etc). 3) Enable users to be able to filter the Student
creator auto backup?
Hi how can i turn creator app to regular auto-backup ? for example 1 time every week
Possible bug with drop-down field (picklist) created with UI:ADD when editing an db entry?
I created a form with a drop-down (picklist) generated from a call to a Zoho Invoice account. I run the form, add a few entries. (see image below the Client drop-down is generated using an Zoho invoice API call on Contacts and populated using the deluge UI:ADD() ). The bug is when I edit an entry, the drop-down value is not selected. The form show the drop-down and below an input box with the value. If I edit any field other than the drop down and want to save I will get an error message (Invalid
Wrong criteria search on system fields for today ?
hi just make new view for working app there is about 26 today entries but with criteria "Added_Time == today" system finds 12 entries and with criteria "Modified_Time == today" system finds 0 entries in all entries report for today (for example) are 26 entries how can i make criteria field to view current today's entries?
Private URL Link and Application Portability
My client's application has a mixture of public and private sections. Some of the forms will be placed in iframes on hml pages shared using the private url option (share without a login). When I finally export this app and hand it over to my client, all the private url links will break. It would be nice to have a deluge function that takes care of this like: https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/form-perma/user_form/<%=zoho.privatekey%> Is this even possible? Cheers, John
Convert Zoho Creator App Into Smart Phone App
Can a Zoho Creator App be converted into a smartphone app?
Paypal - cancel payment
Hi - I have a form linked to paypal and everything works if you go through with the paypal process. But if you submit the form, and at the paypal screen change your mind and cancel - I get a "Payment has been cancelled" in a little zoho status window, and then at the main creator.zoho.com page - it doesn't go back to my site. Any ideas how to handle cancelled payments? This is not a subscription - just cancelling a one-time payment before it's submitted. Thanks,
Will Payment form (Paypal) preserve lookup parameter?
I have a customerID being passed to a payment form. On submit, the page is redirected to Paypal; once payment is posted the Paypal page is supposed to return to Creator. Will that customerID be preserved upon the page-return, or will the lookup value be empty?
Next Page