zoho creator sync to on premise sql server
I am sure the answer is in here somewhere.... I just turned on zoho for the first time, as we are looking for a tool to display some subsets of data from our ERP system (sql back end, on premise). Is there a tool in Zoho to allow sync'ing to on premise databases? I am the finance guy, not the programming guy so something wizard based is more beneficial for me. Thank you Ken
Summary View Help
Hello again, I'm looking for some help creating a summary view. I know how to do it, I just can't get my head around the table and how to display the data that I require. My ultimate aim is to have a list of employees and when I click on one, it shows a summary of all training sessions that that person has attended. I have two tables: Employee & Training Course When a training course is 'booked' it chooses an employee from a lookup in the form. The tables are therefore linked. When i create a
Simple Function for Custom Action request
I'm trying to improve the workflow for my company by limiting clicks to update records. I'd like to have a simple Custom Action button that updates one of the fields of the specific records. The goal is that when in the report view to click a custom action button labeled "closed" to change the "status" field from "open" or "scheduled" to "closed" inside of that record. I'm sure I'm missing something silly, but I appreciate any help.
Filter a lookup in a subform with a field in the main form
Hello, i have a Main Form with a Text field. Under i have a subform with a lookup on another form. How can i create a filter on the lookup with MyLookup.MysubField CONTAINS Mainform.TextField ? is it possible ? thanks you
How to show only hours and minutes of a date-time field in an alert box
Hello, I have a form with a date-time field. When I click the 'Preview Mode' (see the image), an alert box loads a preview mode of a submit view As you can see when I have in the time field the format 'hh:mm:ss' it works fine But when I change it to "hh:mm" then it shows me "00:00:00" Image 2 The deluge which I am using in order to load this value is input.Date_Time.toTime() Is there any way to solve this issue?
Trying to "Open in new tab" the "Edit this application" button gets to error
Hi Zoho, After the last update, when I right- click on the "Edit this application" icon on page, and choose "Open in new tab", the new tab open to "about:blank" instead of the Zoho Creator system... Thanks! Ravid
Form validation for a lookup field
I'm trying to write deluge validation to check a multi-select lookup field for selections made by the user before the record is added or edited. I've wrote scripts for the On Add and On Edit form actions of the Submit button, but I'm not having success and get an error mentioning the mismatch in my expression (field type is BIGINTLIST on left, but String on right). I guess I'm using the incorrect operator ==. I also tried doing a count of the list, but wasn't successful there either. The number of
sub table
Can this be achieved with Zoho Creator? One table inside another, each one are different parameters.
Users relationship between Creator and AppCreator
I have an application I'm building for a client, there is a back-office administration web application built in Creator and then a mobile app built in AppCreator where field agents collect & view data stored in Creator. I want to store the user who added the record in Creator but the field agents won't have access to the backoffice application. Both Creator and AppCreator have the option to invite users but do I have to invite from both? I'm concerned about the logisitics of having to invite users
How can I set report criteria for each login user?
Hi, We have multiple contractors and we want to show report data related for them only and don't want them to see other contractors rows. Some contractors have multiple users so we can't use criteria something like [userid == zoho.loginuserid]. I need to fetch company name from user table. Getting company info from userid is easy with a function like get_companyid(zoho.loginuserid). But I got error when I try to use function in report criteria like [company_id = get_companyid(zoho.loginuserid)]
Dashboard: code reuse doesn't work?
I tried to reuse the HTML code of the "Sales Management" application in my own application. I'm particularly interested in the style that you use to create the little tiles in the dashboard, e.g. "My This Months' Sales". Can you help?
Paypal Transaction Cancelled
I have observed if you cancel a paypal transaction, form data still appears in my view. How do you verify if a paypal transaction is canceled? I tried to use input.ZC_Payment.payment_id = null in form validation, but that does not work. Cheers, John Whitney
Html checkbox sync with embeded from?
Hi Zoho, I have an html page with a long table, based on a one form (1 row = 1 entry). I'd like to have the option to make several rows, and than edit multiple entries together. ~~ I cannot embed a report in the html, due to several reasons ~~ I thought about creating a checkbox for each row, than sending the list of IDs based on the rows checked to a form embeded in the html page, and sending the form will update the entries based on the ID. Since I only started to code with Zoho, I need help with
query expression question
Hi all, How can I get all Orders which have been modified in the last 3 months? I tried the following but got the error "Not able to find monthsBetween function". for each o in New_Order [(Grand_Total != 0.0) && monthsBetween(Modified_Time, now) < 3]
Zoho button to create new auto-populated form
So in my application dashboard, I have created 2 Forms. One is a Quote Sheet and the other is a Customer Sheet. I want to be able to configure the submit button on the Quote sheet so that "On Edit" it will be a "Make New Customer". I want the action to pull up the Customer Sheet and auto-populate from certain fields of the Quote Sheet. Is this possible in Zoho and if so, how can go about doing this?
I hate the auto indent feature
Hi Zoho, just letting you know I think the auto-indent feature sucks:P It keeps on moving braces around and mucking up my indentation. Could you provide an option to turn off auto-indent? cheers, Jeremy
Fields from related forms displayed as "no value" in pivot table
Form A has a multi-lookup field to Form B. Report X needs to list records in Form A that includes fields from Form B (ideally as additional rows) Creator shows "-No Value-" for any/all of the fields coming from Form B. I'm assuming this is because reports support forms related by a multi-lookup, ie 1-to-many relationship ? In the example image uploaded the fields System, Sub system and components are on Form A while Mitigation Task Type and Summary come from the looked up Form B. Hoping I've missed
ADD NOTES FIELD
Hi, could you please explain the purpose of TABLE ICON in ADD NOTES field?
Can't view report as spreadsheet?
Hi - I was wondering why I cannot view a report as a spreadsheet? The option has simply disappeared for one of my reports. I am wondering if it has to do with having subforms involved in the form? Is there a way to bring back the ability to view and edit the report in spreadsheet view? Thanks!
Customer portal in zoho creator
Good morning, I read about CUSTOMER PORTAL in zoho creator help.when I tried that I can able invite users through their mail and they are able to set their password from their mail.but I don't able to know the purpose of sign up form in customer portal.Is it able to embed the sign up form in webpage?
Adding values to a multi select lookup field
Hi, I have an Order form, which contains a multi-select bidirectional relation between Order and Transaction. Essentially, one Order can have multiple Transaction. When I need to add a transaction to this list programatically, I am doing this. Please see my questions in the code comment. tList = foundOrder.Transactions; // does this create a copy of the list or return a reference to the list??? tList.add(txn.ID); foundOrder.Transactions = tList; // depends on whether it returns copy or a reference,
Help text for form / field?
I have created a form with fields that require more help / explanation than the 255 characters allowed for the Tooltip Message. How do I add additional help text to a field?
Simple Patient Look Up
My application has a patient information form with various data concerning the patient. I'm trying to create a "Look Up" form that will search the patient information database, by first name and /or last name fields, and display the patient information form for that particular patient for editing etc. Just a simple way to look up a patient by name and edit their patient information form. I've tried to use the Look Up feature but without success. Thank you, David
Auto Number not showing up
I can't get the Auto Number field to show for some reason, even though I am the application administrator. The help page says " By default, this field will be displayed only to the administrator of the application." How do i modify it so it displays to all? Because I can't get it to work on my existing form, i can't test it. I'm also curious what happens when I add this Auto Number field to a form already have multiple records? Help page I found: https://www.zoho.com/creator/help/fields/configuring-autonumber-field.html
Scheduling an SMS based on date/time in a form
Hi everyone, I'd like to send SMS messages according to a schedule - where the time and date is filled in a form. I have used the automatic SMS function on submitting a form which is super simple and handy, but I'd like to be able for someone to submit this form and then trigger the SMS as defined in that form. The content of the SMS would be customised based on the content of the form. e.g. Form fields: Name: PhoneNumber: Date/time: Message1: Message2: It seems like this is really doable using Zoho
Display my report like my input form
I have a form that creates a LOT number. YYYYMMDD##-ProductName This all works, and I save the generate lot number into the form on save. I Started using a sub form to add ingredients into the product lot. It works nicely. My problem is I'm trying to generate a report that mimics the input form. I can generate a report using the BATCH form that shows the LOT# generating information, but can't display the ingredients nicely. If I use the sub form INGREDIENTS I can list all the ingredients,
Include Form Data in Push Notification
Hi, Brilliant app however I'm struggling to include form data in Push Notifications... I've tried ${input.formName} in gui and input.formName outside of quotes in code view, both produce ${input.formName} in the notification instead of the actual value of input.formName Any help would be greatly appreciated, Sam
Fetching data from a multi select field
Please could someone advise how to fetch data from a multi select lookup field to a single line field in another form? Thanks in advance Sean
Skip Payment Processing
I'd like to offer some customers the ability to skip the paypal payment step if they enter a coupon code. I'm not seeing a way to code for this. I added some code to set the fee to $0, but it still goes to paypal and they will not accept a $0 payment. Cheers, John Whitney
Custom Report
Good day, I am trying to produce a custom report that looks like the pdf attached. Is this possible. I have an order form that collects the information for each order. the form collects the vendor information, there is a subform in this form that collects the items along with their quantities. So how can a format this data to produce a beautiful form like I attached?
Form fields based on previous field
For Zoho Creator is it possible to create a form where specific fields show up based on what was answered previously. For example, someone selects A in a dropdown, so X field shows up next. Or someone selects B in a dropdown so Y field shows up next.
BAR CODE IN ZOHO CREATOR
Hi, Good Morning,Is it able to generate bar code in zoho creator?If not,could you please tell how to generate barcode using API ? Thank you.
Embed Forms Navbar
Hello, I have created a navbar within a page and I would like to embed forms into the difference sections of the navbar. Can someone please I am unsure where I need to add the code to embed the multiple forms which can be accessible by clicking the relevant button the navbar? htmlpage Paraplanning_Database() displayname = "Paraplanning Database" content <%{%> <style> ul { list-style-type: none; margin: 0; padding: 0; overflow: hidden; background-color: #696969; } li {
Function calling is not supported from Component Criteria error problem
I have several working conditional data highlighting in reports with the format xxx.before.today.subDay(90) to highlight data fields older than 90 days. In the last week or so, if i try to add more or to change the 90 days to 60 days i get the error message "Function calling is not supported from Component Criteria" and can't update the change. Please advise on how to fix. Scott
Lookup inside a lookup?
I have a Application Accounts, I also have an application Equipment and I am working on another Application Service Call that when I choose the Account lookup reference, I want another lookup field to show only the equipment associated with that account not all the equipment. Thanks for your help.
Checkbox Onclick "add to list"?
Hi Zoho, I have a checkbox on my html page, and when its checked I'd like to add its value to a List I've created before. Right now this is the script: htmlpage test_page(VarListParam) displayname = "test page" content <%{ List = {"Bike", "Car", "Motor","Helicopter"}; VarList = List();%> <form action="" method="get"> <%for each EachVeh in List {%> <input type="checkbox" name="vehicle" id="myCheck" value=<%=EachVeh%>onclick=VarList.add(EachVeh)>I have a <%=EachVeh%><br> <%}%>
AddYear not recognised?
Hi again, Any idea why it says it cant find the addYear function when i add this script: For each ServDue1 in Customer_Database [ServDue1 < zoho.currentdate] { ServDue1=ServDue1.addYear(1) ; } Yet if i put this For each ServDue1 in Customer_Database [ServDue1 < zoho.currentdate] { ServDue1.addYear(1) ; } It says built in functions can only be in the format x=y.z() So it is clearly recognising it in the second instance but when I call it correctly it can't find it?? Thanks Sam
toDate() errors
I have a form called Lab_Test_Value, and two form fields that are doing a cascading lookup, as follows: 1) Field_1 is a 'Lookup' field, where the user picks a value from a drop-down list. During the 'On User Input' event, the key value selected in Field_1 is used to lookup and generate a distinct list of string date values. The format for the resulting date list "yyyy-MM-dd". This list of string date values is used to populate the options for Field_2. Here is the Field_1 'On User Input' event code,
Managing an embeded from width in an html page
Hi Zoho! I have a list in my html page, and I'm using a form embeded in the page so the user can filter it. how can I set the form's width? I've adjusted the field's name width and the drop-down width in the form's properties, but it looks like there is a lot of space to the right of every form and on the buttom also (I've used float:left" to set them one by one). I've tried to use "Width="20%" etc. but it did not help.... (I've attached a screenshot to make it clear) Thanks! Ravid
Data Analyzation Capabilities
Hello, Is possible to build an app that will allow me to upload all of the parents at my school and track which parents have and have not completed the form on a dashboard? I am not a developer but I will attempt to build the app if this is possible. Thank you for your help.
Next Page