Edit error messages for required fields
Hi everybody, Is there a way to edit error messages for required fields (error popup and red text below the field). I wanted to use show field (and cancel submit) when submit but we can't. Any advice will be appreciated. Thanks Pascal
Remove previously selected lookup choice in subform
Hey guys, I've been thinking and working on this concept for a little while now and haven't been successful. The closest remedy I could find was the the thread: " How to remove item from picklist which have been selected in previous entries in a subform context?" The user found a solution but never posted the results. I've been using the methodology that he outlined in the post as a means to get started but I haven't been successful. For reference, my code nearly mirrors the code presented in this
Route Google
Hello, Does anyone know if it is possible to create a route in Google Maps based on records in Zoho containing GPS coördinates? Greatings, Erwin
Mobile Creator form style, can I use it for my normal Creator form permalinks/embeds?
Just started playing around on mobilecreator.zoho.com. It is a nice looking tool, but not really useful for real implementations in my opinion, versus the normal Creator. This one thing I prefer about the Mobile Creator is that the forms look so much nicer for mobile, the data entry is much more mobile friendly, and the big green submit button is easier. Currently I am embedding forms into my apps by changing the "form-perma" to "form-mobile" in my published URLs, but would much prefer to have similar
Image field in view on creator android app not showing image
Hello. I have an image field on a form and created a view that shows the image. When I access the view from the mobile app the field name is there but no image. Is there setting to turn this on? Arlan
Drop Down filter based on loginUserid
I am filtering a dropdown based on a field in the form - ForemanUserID if the current zohologinuserid == ForemanUserID the job should show in the dropdown. This works initially. When I log in as another user however, I see the list from the former user. Do I need to clear this list - somehow? This is on a subform. Additionally - this dropdown is used to filter the selection on the next field - also a dropdown. Don't know if this is relevant..
Running a code within html progress graph
I'm trying to make a code that you enter the variable in HTML code, a progress bar, but when I run the code the varible remains the variable name and not as the result: Grafica1 = "step1 visited-checkout-step" <div class = "checkout-progress"> <ul class = "progress bar"> <li class = "grafica1"> <span class = "triangle2"> </ span> <a href="#"> <em> 1 </ em> Order placed </a> <span class = "triangle after"> </ span> </ li> I want to run the code and that it isinstead of to stay as the original. Grafica1
Record Summary
When I format my Record Summary and save it even then some of the changes are not saved, however on screen it shows the changes as required. When you access the application it still shows the earlier version, even though you get a message "saving" on pressing the SAVE button. What is the problem ?. Is it saving the changes or not ? Can someone help. Thanks, Milind
Json feed mime type issue
Internet Explorer 11 (I did not tested other versions) currently blocks ZC json feeds in Ajax requests (for example, when it's used with JQuery getJSON() and probably the ZCML script proposed by Stephen here because it is also based on JSON feed parsing) and the issue is a type mismatch. This is the message from the IE developer tools console: <url> was blocked due to mime type mismatch (<url> stands for the current json feed url) In Chrome the json feed is not blocked, but the following message
Excel refresh
Hi how can I embed a Zoho view in an Excel file, and let the Excel side refresh automatically on a frequency or on demand? Thanks.
Re: Lookup in a Subform
Hi, I am hoping that someone can help me with this. I have two forms: Enquiries Look Up Customer Name (Drop down) Look Up Contact Customers Name Contact (Subform): Name, Telephone, Email I am trying to make it so that when a customer is selected from the drop down, the Look Up Contact gives a drop down of all contacts for this customer. Any help much appreciated. Thanks,
Auto Number
Hi, I am trying have an auto number field that is displayed when adding/editing a record. Our reference numbers are in the format: B-879 and increase by 1 each time. When it gets to B-999 the next record is C-000. Is it possible to do this? Any help much appreciated. Thanks,
render a list of product records and create a new quote record
I have a requirement where I need to show a list of product records and allow the user to select certain product records using a checkbox and then create a quotation by clicking on a custom button. Can this be achieved with ZOHO creator?
Fetching Records
Hi, I have an enquiry record which records the receiving and quoting of an enquiry received from our customer. In this we have a subform which has a look up field which records which supplier we have usedand the value of their quotation. We have another form which for Suppliers. In this Supplier form, I want to have a subform that displays the previous 5 enquiries where we have used this supplier. It will display fields Our Ref.:, Customer, Date Rcd, Drop Down, Value (from Supplier subform). Any
Reset Counter Daily??
We want to assign each entry a date code with index. So each submission would look something like YYMMDD-[Index] I can get the YYMMDD-[Index] and i have the function working to increment the index after each submission but what i can figure out is how to get [index] to reset every day so each day it starts at 1.
Different effects of sign-on on different computers
I ended up with 2 computers. On one computer, when I upload a ZOHO database that I DO NOT want viewers to make changes, I get the normal top heading, with SEARCH, and on the top Right SIGN IN . Without signing in properly no one can make changes. JUST WHAT I WANT. On the other computer when I do exactly the same and upload, I only get SEARCH on the left and SIGN IN is not there , and even I cannot make changes. Can you tell me what is going on. And how I can make all of my several CREATOR databases
Error Form
The request was triggered by different origin ...??????
Search page and pre-populating values in form
Hey Guys, I have a form in ZC which is used for simple data entry process(name tf2 ). fields: Name Age Mobile I have another stateless form(name stateless) in the same application. Here I'm entering a mobile number and checking whether any record for that mobile number exists in my previously entered data (in tf2). In the stateless form, when user enters a mob. no and hits "Search" button, I'm redirecting the page to show the available records found for that mobile number using OpenURL script.
Customer Portal Customization
I'd like to change the text under the "New User" Sign Up link on the login screen, which says this: "Create an account and contribute to the community.", which is not at all appropriate for the application I'm building. Can this be done? Thanks, Len Len Kamerman Hero Technical Solutions www.yourcrmhero.com
Running a code within html progress graph
I'm trying to make a code that you enter the variable in HTML code, a progress bar, but when I run the code the varible remains the variable name and not as the result: Grafica1 = "step1 visited-checkout-step" <div class = "checkout-progress"> <ul class = "progress bar"> <li class = "grafica1"> <span class = "triangle2"> </ span> <a href="#"> <em> 1 </ em> Order placed </a> <span class = "triangle after"> </ span> </ li> I want to run the code and that it isinstead of to stay as the original. Grafica1
Cannot get "old" data.
In Edit|Verify, Script Builder still has a tab for assigning a value to a variable that says "Old", but the code it creates won't compile. Is it still possible to get and use the previous field values? Bruce "Speedy G" Peaslee The World's Fastest Programmer
Time Zones
I've asked this question before, but I got no responses to my actual issue so I am trying again. I have multiple users who are in different time zones. I also have lots of date-time fields. I know how to determine what time zone a user is in. What I don't know is how to display the date-time fields accurately for the user who is viewing it. So for example I want user#1 on the east coast to enter a time stamp for the current time let's say 8:00 AM EST. I then want user#2 on the west coast to
Drop-Down Error on Subform w/ Mobile
I have an equipment leasing app. The main order form is the order "header" information (customer name, address, phone, etc.). A subform is used to record the individual items on the order. Two pieces of information are entered for each item leased - the item and the serial number of the specific unit that was leased. The application has a table with the serial numbers of each item (a child relationship to the parent of items). On entry of a lease, 1. The user selects the item from a drop-down
Not able to duplicate an application
I have created 3 applications in ZOHO creator. I am not able to duplicate a particular application only. All other applications I am able to duplicate except this one. Is there any settings issue? I am not able to understand. It does not give any error message as well. Please help. Thanks, Milind
How to manually set a file name when I click the pdf button
I created an html page and I enabled the pdf = true. I would like to ask you if there is any way when I click the PDF button and starts download the file to change the name of the downloaded file. I mean if I can manually set the name of the PDF file somewhere in the html page and by clicking the PDF button to set this name to the file
Email a PDF attachment to a specific existing record?
We can create a record with an attachment using the email template but is it possible to email an attachment to an existing record? Thanks...
Insert a report on a form / Record Summary
I have a form to input information on the company vehicles, maintenance and mileage and such. it keeps a log of the records and presents them in a 'record summary' view. \ i have a separate form for tool and item inventory, which can be assigned to trucks through a look-up field that allows you to select the truck number. i would like to have the items for the selected truck in the truck report 'view record' to show the items assigned to that truck. i though about putting the tool and item form in
Search Bar in Zoho SItes Form
hello im creating an onboarding form threw Zoho SItes everything is working fine but i want to know if there is anyway i can have a search bar in the form itself? i have all the companies in a drop down box but i want to be able to hide the companies so other companies dont click the wrong file in the drop box, i know i can use a single line and use if (input.Search = "Company Name") { show Venue4; } but you have to spell the whole word and corretly aswell, is there a way i can create a search
Mandatory Fields through script
hello im currently writing an onboarding form for work but im having trouble with makeing a mandatory field for certain companys but not others ive tried a different couple ways but im absolutely stumped on it if(input.Company = "Company Name") { if(input.First_Name = null) { alert ("Emergency Contact Required"); cancel submit; } } ive tried this and replacing null with "" and it still wont work please assist
hide specific column from attached view
Hello, How can I hide specific column like "upload file column" form view when I attached this view in email. without creating new report without this column. Regards, Omar
Calendar view ('Month' view) question
"Month" view: is it possible to freeze the 'Days of Week' pane/row, currently it scrolls up with dates. I realize that it can't be changed in the report/view settings. A question for developers? Thanks.
Enabled ZC Chat changes colors of the links to black
I have fields in some views that are linked to other views (lookup fields). The color of those fields used to be blue, but now they are black. They are still clickable. but they should be recognizable by color. in the view record they are blue. It happens only when the ZC Chat is enabled.I see that .authorChatPresence in a FF inspector when Chat is enabled. After I disabled the chat, blue color is back. I guess, this is a question for developers. Thanks.
how to create a form from script
I am new to Zoho Creator, I think the concept is cool, but the GUI is a bit clumsy and slow, and there are quite a few bugs. After spending couple of frustrating hours trying to create forms I will try to resort to scripting: When manually creating a form in creator there is an option to save as script. Lets say I edited the script, how can I use the new script to create a new form, where is the "load script" or "create form from script" command? Also, where can I find documentation about the scripting
Can I automate database so I set up one date and zoho calculate other dates?
Hey, I wanted to ask you and perhaps receive a few pointers on automating adding information to a database. Let's say I have a database that I input a main date. There are many date fields that I would like zoho to automatically fill based on this date. For example, the main date I fill is start of event. I would like to know how to make zoho automatically input date in other field, for example purchase a flight, which I want to always appear 2 weeks before the main date. Any ideas how I could do
Trying to customize image width in a list report
Hi there - I'm trying to create a customized list view of the records we have uploaded into one of our forms. Each record contains an image of varying width and height. I want to list view to force a width on the images so that it appears uniform when someone is accessing it. I can't seem to figure out how to do this, are you able to help? I've found ways to force a width AND a height to the images, however this causes a problem because it distorts the image and squishes or stretches it. Thanks!
Remove creator header from edit record custrom action popup window
I have a view with a custom action button that will open up a form and allow you to edit the form. I want this window to open without all the zoho creator header stuff (compay logo, creator tabs etc). Below if the function I am using. I think that there is another way to write the url that might remove the creator header stuff from the top of the popup window that opens but i do not know what it is. Please any help is appreciated. My function: void Quoting.editQuoteItem(int ID) { openUrl("https://creator.zoho.com/<zohoaccountID>/<AppName>/#Form:Quotes?recLinkID="
Create multiple records in blanc form
Hello, I have a question about the insert into function. I have three forms: Form A: containing the fields: Name, group and Number ; Form B: containing the field: Name, group and Number and Message; Form C (blanco form): Containing the field Group and Message; When I select the blanco form I have made a submit button with has to do the following action: Based on the selected group, it has to search in Form A who is in the selected group. It has to input the users who are in the group into form B.
Tracking historical data / trends with Pivot charts
Hi! I am having problems with creating pivot charts used to track historical data from forms that don't have a date in them. I spoke twice to Support but they couldn't help me, so I am posting it here. Let me provide you with two easy examples so you can see what I mean. Lets say I have an online store (which is true!). I have a form (Products) where I describe each product including the price and the total number of units I have in stock. I update manually the field with the price each time a vendor
Understanding Schedule
I am trying to wrap my head around the schedule feature in ZC. Say i have a Task table with contains Date Time when the task is due. I want to send out reminder email 1 day before the due date time. This schedule is good from 1/1/2016 to 12/31/2016. Under the schedule, there is a Start Date option. Is this the "execution start date" or the series start date (1/1/2016)? I assume it's the "execution start date". Am I correct? Now how can i specify this schedule is only good for 2016 only? Am I correct
Pass "input" as function call argument
How come I can't pass input as argument to function calls? A valid scenario is this, in On Edit-Validate, the input is the form before it's persisted to database. Let's say I have form called Company, input is of form Company. I have a custom function that uses fields inside Company to send emails. void mySendMail(Company c) {...} I want to be able to call the function in the following two ways: 1) mySendMail(input); 2) x = Company[ID== 2341252]; mySendMail(x); Now, because i can't pass input as
Next Page