UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
Group security
My clients are complaining that they can no longer see some forms or views. The PROVISIONING forms and views are shared to the Provisioning group. I have 16 members part of the provisioning group. Users in the group can not see the forms or views that are shared to the Provisioning group. Previously it was working. Is anyone experiencing security problems?
passing 2 or more parameters to an html view
So in the example: https://www.zoho.com/creator/help/views/create-html-views.html htmlpage "Expense Report By Date"(From, To) <%{%> ................... .................. }%>but what would the script for the button be??? openUrl("#View:ExpenseReport?from=" + input.From ???,"Same window");
Script doesn't save properly
I am trying to save the following code to one of my scripts for each schedule_row in input.SCHEDULE { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({schedule_row.SITE_ID}), schedule_row.ALL_SITES, input.AGREEMENT_ID, schedule_row.SCHEDULE_TYPE, "0", "0", "0"); } for each variation_row in input.VARIATION { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({variation_row.SITE_ID}), variation_row.ALL_SITES, input.AGREEMENT_ID, variation_row.VARIATION_ID, "0", "0", "0"); } When I click Save Script, I
Defining contents of a lookup dropdown field
Hi, I have an issue with my application I was hoping to fix. I have two forms: - Client (Has fields for "Client Name", and a Multiple Choice field for "Project Name") - Staffing (Has a list of staff names, and Lookup fields for both "Client" and "Project" fields from "Client form" I want to find a way that if the Client is selected in the Lookup dropdown, then the Project dropdown contains only the projects against their name in the "Client" form. Does anyone know if this is possible? Regards, David
Change text color in a view
I would like to be able to have different color text show in my view, or be able to change the background color of the box where the text is. For example, under view, I have a list. One of the columns is STATUS I would like for it to list like this: NONE - Black Arrived - Blue Delayed - Red Finished - Green. I figured out that if I just put HTML code into the drop down menu like <FONT COLOR="RED>Delayed</FONT>, this will work. But I have a lot of other IF statements and other things which will
Add record by post url stopped working
I have been using a post to url with auth token for awhile . Today at 10:30 it stopped adding records to zoho. I have changed nothing please advise
Zoho Creator Regular Standard plan: how many email notifications?
Hello Zoho team, I want to select the correct plan for my customer, who needs email notifications that will be kicked off by Schedules. The Zoho Creator pricing page (https://www.zoho.com/creator/pricing.html) shows the different plans available. For example, Regular Standard has "5 Users; 10,000 Records; Storage - 1 GB; Unlimited Apps; 10 Reports; 50 Schedules; Backup". (Note: it does not mention email notifications) Underneath the plans it lists the Add Ons to those plans, such as "Email Notifications: 500
I cannot use order by clause in select ouery of my html view...... ????
there is always an error of xmlparsing.. i m getting data from reports and showing it through xml parsing but order by rand() clause used in the select query of my html view is not working all others are working....and that orderby rand() is also showing results in reports query table..... can anybody have an idea how to run it ...
modification of email on custom action
If we wish to modify the email before sending on custom action, as per the record in the view .. How is this possible?
Export Dashboard to excel
Dear all, Where is the export to excel option in Zoho ? is it possible to export to excel.
App location? (Future proofing an app)
I have my first app currently being trialed by my company. As I created the app the URL for it is "https://creator.zoho.com/my_user_name/my-app-name" but what happens at the point when I decide to leave the company and they want to kill off my account? Am I better off having the app run from a generic account from the beginning i.e. "support_dept" and setting myself as the developer or can a backup be performed by me and then restored by another user at that time so the URL will change to be their
Script sort by code disappears
I want to show results sorted alphabetically. However, I am finding issues with the sort by code disappearing after I try to implement it. When I try to save the following code c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID sort by CUSTOMER_ID).getAll() in my form script, I see Script saved However, when I refresh the code, I see c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID).getall(); Script generated I have tried both in the Script Editor and Free Flow Scripting. It
Place View under multiple tabs
I want to place a VARIATION View under the AGREEMENT and PROJECT tab. When I created the view, the "Place this View under" only allows you to select 1 tab. How can I make the view visible to both tabs?
Email notification on request
I'd like for an email notification only when I decide at time of entry. I created a field "email_notification" of the type "Decision check box" What would be the better strategie for allowing email notification upon checking that field only.
success message - Specify Duration(Optional)
Hi, Please explain the type of input expected when setting on a form its On Success success message. Is it units of seconds? Should it be written 8s? It is not explained in this page: http://www.zoho.com/creator/help/script/success-message.html Many thanks,
Warning prompt on custom action
How can i show warning message on custom action??? Help........
My App is gone
My app I have been I made is gone from the index view. I can't make backups of it. Also If I go to http://creator.zoho.com/home/index it shows I have no apps but if I manually go to the link of my App it still exists, and I can access it that way. Is there any way to fix this issue so I can make it appear in my index and also make backups of it? Many thanks
usage limit notification
I received an email with an alert stating "You have reached the maximum Schedule limit permitted for this account. Please upgrade to add more." What does this mean? On my zoho home page it says ive got no schedules created.
Importing Data to fill various fields in a form
Sorry im a complete NOOB and not sure if the subject has been posted. Sorry in Advance. What I want to do is to do a form in wich you do a lookup for one field and automatically fills all the other fields in the form. Im trying to create a method for planning industrial equipment Maintenance. So I have a form in wich I enter the data of all my equipment, so now I want a form in wich it imports the Data from Form 1 to Form 2 and in Form 2 enter the Maintenance Date. Now you can import data for one
Temporary fields in Forms with store data in Creator
Hello! Very often I need to have some field in Form, which I use only for control of Form behaviour during displaying, and dont neet to store its value in database. It will be great if I can set parameter for each field "Don't store value in database" For example desision box which is used for displaying or hiding group of fields, or auxiliary lookup field, which help to control data in Form while editiong and so on
Adding Sorting in dynamically generated HTML VIEWS
hELLO tHERE.. please help, i am puzzled in a very tiresome task from 2 days, i want to add the sorting functionality in a html view created dynamically by using api mapping with reports..... please suggest me some other way if that's not possible.....
Invalid Entries detected when updating records from the Report view
I am receiving the Invalid Entries error when editing records in the report view of a couple of my forms. This will be a required feature of the application for actions such as administrator approval. It appears when I select Edit on a record and then Update it, even if I have not changed any of the data in the record. Usually this issue does not occur for the first update I make but then persists for no obvious reason.
Zoho Calendar view only for a certain time range?
I'd like the Calendar to only display for 9am to 9pm, is there a way to do this?
Lookup Fields of the same form
Is it possible to create a lookup field on a form, to a field on that same form? This is hard to explain... I have an app that I use to log "issues" on a website. Occasionally I have issues that are related... So on my "Issues" form I'd like create a lookup of a field on the issues form that I would then call "Related too". When when adding a lookup field it doesn't let me choose from the form I am working on. Any ideas? Thank you! Greg
Chrome openurl new window is a popup not a new window
Firefox openurl command with new window opens a new tab Chrome openurl command with new window opens a popup which starts life as being blocked chrome ver 15.0.874.121 Any ideas ? anyone Thanks
Validate form and change value
I want to change field values when a form is validated. I have a CONTACTS form with a mobile and phone field. If either are empty, I want to populate a message with instructions. As I have multiple rules, I do not want to use alerts but instead populate the contact_msg field. I have the following code on validate if ((input.CONTACT_MOBILE == "") && (input.CONTACT_PHONE_OTHER == "")) { input.CONTACT_MSG = "Please enter either a mobile or other phone number"; cancel submit; } When I run
Send mail from one form to matching entries on another form
How would I go about sending an email to all people in Form B that match certain criteria in Form A. My application is being used to match up people looking for a job with employers in their area. Form A is where the job seeker submits their info (contact info, resume, etc.) Form B is where the employer lists their info (contact info, city/state/zip they are hiring in) For example: When a job seeker submits their info with a zip code of 91320, an email is sent to all employers requesting notifications
Zoho Creator API JSON Mis-formatted for Related Fields
Hi, It seems I have come across an issue with how the JSON is displayed when getting the JSON from a view where I link a Field to an additional view and then show a field from that linked view. How It Should Work: Lets say I have two views: View 1 1 2 3 View A A B C If View A is linked to View 1 with a related field, the JSON should be formatted as follows, where the view A details are nested underneath View 1. Entry # 1 1 2 3 View A A B C But this is not how it works. How It Currently Works - Bug:
problems after recent platform change
I have troubles after a recent platform change, and some existing code no more works. 1. The most serious problem is that it is no more possible to concatenate a string with an integer, a thing which was allowed in Deluge . An example - a test function string test1() { nr = 2; return "The number is " + nr; } The code is saved without error, but an error appears when the function is executed. I have to change the return statement to return "The number is " + nr.tostring(); in order to make
Fetch records HTML page
Hello everyone, this is going to be a long one so please bear with me! I am new to deluge scripting and am stuck with a few key principles. Outline of what I am trying to achieve: Use Mail Merge to load a HTML page which i will then print - an example of the page which i currently print from a access database is here How far I have got: Created a HTML page Created a data view with a custom action to load my HTML page. Created a function for my custom action (below) void netbooks.SignOutForm(int
WTF! [ServletException in:/jsp/edit/view/viewedit.jsp] null'
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
When duplicating a Creator Application - very annoying bug
The fields seem to all be duplicating correctly, except this option It is checked in original application, but unchecked in the duplicate
Multi-select field show/hide
I'm not the sharpest knife in the drawer when it comes to scripting, and Deluge is no exception. I have figured out how to make a field show or hide based on binary statement (on or off via checkbox) or on any sort of input regardless of what the input is. What I am trying to get happen is when specific options from a multi-select field are selected, specific fields show themselves corresponding with them. I thought maybe having a list somewhere of all the options, and then trying to get it to
Script to create a new record with a subform, and populate data
Consider this example So what would be the code to create a new record? insert into Class [ date_field = zoho.currenttime (?) insert into Student [ name = "Billy Bob" ] insert into Student [ name = "Jane" Doe" ] ];
restrict characters in single line field?
Is there a way to prevent users from using, for example, spaces in a single line field? If not, is there a way to replace spaces with, for example, underscores during the submission process? Thanks.
URGENT! Unable to add any new records!
I cannot add data anymore. When I fill in the screen and click submit, the please wait message is displayed, but the information is not added, and the screen never clears. It is critical that this be fixed ASAP!
Subform and Associated Projects
Hi, I work in publishing and I am working on figuring out how to track contacts (with certain details) and their connection to 1) sales opportunities and 2) projects. So I would essentially need 3 tables - A. Contacts, B. Sales Opportunities and C. Projects. Setting up the relationships is what has been a problem for me. I'd like to be able to view each table's associated record , within the context of the other tables. For instance, when I look at contact, I want to be able to also see the associated
URGENT HELP NEEDED: Can't Add Data to Database and Can't Update Deluge Names
I have two problems: 1) Member Data Form: I am unable to submit a form I created to the database called 'Member Data'. All other forms seems to add data to the database as purposed. Please help, this is critical. 2) Approval Decision Report (View): In the Approval Decision Report View, there are two fields called 'Registration'. One should be called 'First Name', the other 'Last Name'. I have checked the fields many times to ensure that they are set up appropriately (and they are)--both the Label
Next Page