Embed a form into HTML view with pre-filled parameters?
I'm building an HTML view that allows users to select an Account, then shows a list of current projects assigned to that Account, as well as a form that lets them request a new project. Ideally I'd like to pre-fill the New Project form with the specified account (passed into the html view as input.account), but can't figure out whether or not it's possible. I know about functionality-based URLs but appending &Account=input.account doesn't make any difference to the form. Is this possible and if
Script Error
When importing a script from an application to create a new application, I receive the following message: Problem encountered while creating the application Exception occured while publishing message to the topic :: [DataModelTopic] The application I exported from is working perfectly. I just want to duplicate it to customize for other clients. Thanks
view dropdown in editor
Often times I have many views with similar names in the editor's view drop down. It would be tremendous if you colored different types of views so perhaps... list views: blue chart views: red html views: and so on... I find myself accessing the app just to find the page I want to edit then going back into the editor. Another nice way of grouping would be to put some sort of option to group views how you have them grouped in your pages. Now "that" would be so great as it would make you feel like the
Update data form + copy form option
Hello, I've build an application where users can add change requests to a list of requests. Whenever a new request is added it mails to me. Next for me to do is update the request form specifying release date and other information. I should be able to: - mail the user to notify him that I updated his request (status 'scheduled') - mail the user later when I modify the request status to 'closed' - mail the user when I reject a change (+ ability to give a reason) - update the request using the same
z-index HTML views and ZC Menu
Anyone else had problems with transparent menus when using a ZC dropdown menu in and HTML view? I also have z-index issues when trying to use the ZC menu on an HTML page... The menu drops down, I go to select, the correct view/form and the menu falls away after hitting the line of my first div in my HTML. I've tried changing the z-index in my html and that seams to work but not always :) browser: firefox
Importing data via email
Hello, the graphic on the Product Overview Page says you can do it, but I'll be darned if I see how. I have several dozen sites that collect data email it. I'm trying to get ZC to read those emails and put the data in the db. After 30 minutes of looking for how to do this, I give up and ask for a link or other guidance. Thanks.
Link variable between forms
Hi, I have created 2 forms but how do I reference variable from another form? Say: FormA has varA1 and varA2. FormB has varB1 and varB2. varB2 should derive from varA1 plus(+) varB1 but confused with the script builder. Any idea? Thanks lots.
String functions
Hi, Does Zoho Creator have a Left() or Right() function similar to VBA? I'm trying to create a code based on a LastName + FirstName fields. I was thinking something like: Left((LastName + FirstName), 4) Is there any way I can do this with Deluge? Thanks, Leo Saumure
Html error...
Hi, My new html view show the html text double(not double in rich text mode field) and my view will not load..What can be wrong? Br Skouboe
Passing Parameters to Charts
So when I was new to Zoho Creator I would create multiple Charts for virtually the same chart with just a few minor changes like, office name, criteria, etc. I become increasingly annoyed with having a ton of charts to manage until I realized, "Hey if I can pass parameters to list views, forms, and calendars through my URL or my viewLinkName's in my embedded forms & views why can't I do that with charts? The answer is YOU CAN! Example... Here is my chart as it sits right now with no parameters passed
Filter command needs to let me pass in a string for the <criteria>
Dear Zoho Developers, I want to create a search page for my users where they can search on multiple fields and I am having trouble when it comes time to write the Filter statement. It seems like the only way to write a Filter statement is to hard-code the <criteria> part, e.g. contacts = Contact [ name == input.name && expiration_date > input.exp_date ] However I want this to be variable; if the user only enters something for name, the statement should be: contacts = Contact [ name == input.name
Form Submission and the Dredaed Never Ending Spinning Arrow
I have launched a private application to collect contact information. While many people have not had any issues submitting the forms and adding data, there are instances where forms seemingly do not submit (with a Never Ending Spinning Arrow), although the data was added. In other instances, people click on links and my pages present a Never Ending Spinning Arrow with "please wait..." I'm wondering if there are browser limitations. For example, I'm thinking that some of my private urls are so long
Unable to View Public Perma's when Signed into different account
Issue: What I created: Created multiple perma public perma views. After creating views... I sign in as a different user then refresh the Public Perma views sitting on a separate tab. Outcome: I receive the "You are not authorized to access this view in Zoho Creator. Go home."
Invite User
I invited a user to a Creator App, but he can't access it. When he follows the link in the invitation mail he receives a notice that he has no permissions. Thank you.
Features added recently ...
Don't know if anyone else noticed that this page ... http://zohocreator.wiki.zoho.com/Working-on.html ... was updated over the weekend to indicate addition of these two features ... # Range search for Date and Numeric fields # Deluge Code Editor improvisation (Completed) I did a quick test on the Search feature ... you click on the drop down item called "between" ... to get the two boxes where you enter the range limits ... looks pretty good ... users should be able to get a lot more out of their
Cannot edit or view script in "Help Desk" application.
Hello, Apologies if this topic has already been covered beforehand. I have installed the “Help Desk” application from the marketplace. I managed to successfully make requests through an admin account with a form called “Add Request”, which had a drop-down field “Requester”. However, when I opened the application in a different account, a different form called “Add Request Requester” appeared. The “Requester” field was now single-line and disabled. I then tried to change the type of field, but was
Online Survey Thank you email
Hi Zoho developers and community! Is there a way that I can send a "thank you" email automatically to those who have filled out my surveys in zoho creator? granting that the one who took the survey filled out the email address line? Thank you!
Search entire application
Hi All, I have the need to search and replace in my entire application. I know this has been asked for before in this forum but I cannot find the answer. I apologize for the resubmit... Even if there is not an inherent way to do this in the IDE is there a way to export the entire code base to a text file to do a search? Or some other work around? tt
Wildcard search
Ok guys, I am sure Zoho must have a wildcard search but I'm not sure what it is. Lets say I want to search for 'Kevin' in my name field and have it find: 'Kevin Smith' 'Kevin Jones' What is the correct syntax in my Fetch command? Thanks! Kevin
Using Look-Up Field To Display Price
How do I set it up so that the corresponding price shows up in another field based on the item chosen in a look-up field or possibly two look-up fields? Simple example: Item Color (look-up field #1) + Item Size (look-up field #2) = Corresponding price from the same record.
Can I set a status message?
Hi gang, I'm writing a view that does some processing of records then calls openUrl to go back to the main list view. I would love to set a status message that tells the user "operation complete." Is there some way I can do this, like adding a parameter to the url in my openUrl call? Thanks, Kevin
Either SORT RANGE is broken or I am an idiot
This issue has been fixed!.... Dated 6-18-09 Ok, 99.9% of the time any problems a user is having can be explained by user error or incorrect scripting However, recently all of my app users have been complaining that the HTML page pagination in the app I built for them is completely wrong. The pagination simply does a for each collection with a sort range of 0 to 35 then 35 to 70 I tested this hundreds of times before adding to the marketplace. And the weirdest thing is that Harsha helped me build
Calendar
Hi, I'd like to change the look on the calendar that pops up with the Calendar field. Looks too much like windows 95. I'd like a more modern look. Any suggestion?
Help with multi select
Just re-iterating this as did not get a response. I have a multi select box in which a number of filters are applied to so that when the final selection is displayed the use has only a few choices. Of the 200 parts, by selecting a site, and then a fault type the list is reduced to 6-10 selections. This work fine while there is nothing selected, but once the incident is edited, the selection is lost, and I want to re-apply the selection (which is often more then one part of equipment) so that it reflects
(Not ZC specific): programming code for total based on price/quantity
I have a non-ZC related, general programming question I thought I would post here: A = the price of purchaser's 1st apple B = the price of any 2 or more apples, different than A C = the price of purchaser's 1st banana D = the price of any 2 or more bananas, different than C X = total number of apples, can vary, can equal zero Y = total number of bananas, can vary, can equal zero total = ??? I'm having an algebra meltdown and can't wrap my head around this seemingly simple equation...
What is this??
Error details: Error occured while executing on click script. unknown Task : Task personality is 287 Unique constraint Failed for the table t_306497000001242896 The error row values are:t_306497000001242896_PK = 306497000001282211RECORD_TYPE = 2LunaSKU_306497000001242900 = 9999988RECORD_LINK_ID = 306497000001282213ADDED_USER = mbrunner72ADDED_TIME = 2009-06-16 09:05:38.171MODIFIED_USER = mbrunner72MODIFIED_TIME = 2009-06-16 09:05:38.171ADDED_USER_IP_ADDRESS = 24.14.165.82MODIFIED_USER_IP_ADDRESS
date-time default entry
How do I entery a date without a time? Right now if defaults to today's date and current time (to the minute!!). I only need to enter the time on a select few records. How can I make the time default to all zeros?
can't find code to embed in website
Hi I have created a form and clicked on access this application. When I go to the more actions I can only see copy application save as script share this application customise Theme/Layout Where do I find the code to embed the form in my website? Thanks Lisa
Zoho apps
To all Zoho staff...keep up the great work!! I love your apps...
Zoho gives an error inside conditional
I'm trying to count the number of instances of a particular variable, then if the count is above 0, add that variable name to a field. Here is the code: for each account in Accounts
{
account_name = account.Client_Name;
account_count = count(Projects[Project_Status == "Open" && Project_Type == "Chargeable" && "Account" == account_name]);
if (account_count != 0)
{
Account:ui.add(account.Client_Name);
}
delete user
I am trying to delete a user (storysnoopsjn) from my account settings. I have already closed the account but it is still taking up one of my user slots. I can't delete the user or deactivate the user without getting an error code. Please help!
How do I update data by merging
Hello to all- We are an organization that tracks our members purchases from many different vendors. These vendors send us excel spreadsheets that have our member name listed and then what their purchases for the month are. Currently, we look at the excel spreadsheet, pull up the member's record in ZOHO and then update the field that holds the purchase amount for each vendor. Is there a way to merge the spreadsheet so that automatically populates the member's record without having to manually each
Link between Forms
Hi, I have created 2 forms but do not know how to link the variables between the forms. I have,eg. - Form A with variables A1 and A2 - Form B with variables B1 and B2 - variable B2 should derive from A1 + B1 Can anyone advise me as I'm confused by the script builder? Thanks lots. Thomas
Multi Select Checklist
Hi, I have a multi select checklist which changes acording to differenct criteria selected within my form. When the form loads on edit, the exsisting selectections, which have been checked, do not show up as checked on load. I figure I need to use the Select / Deselect feature, and fetch the what the current record should be, and on load, check the boxes. Something like: current_equipment_type == Incident_Report.Equipment_Type_New
Equipment_Type_New.select(current_equipment_type) Is this down the
forward-back, next-previous in forms
I am trialling the free edition of Zoho Creator and I've noticed the lack of navigation controls in Forms, i.e 1st-last, next-previous. How do I get these onto the forms? Are they only available in the paid editions? Thanks...
Changing field names doesn't update throughout.
I changed a field name on the form but the corresponding field names in the "Field Actions" area refuses to update accordingly. Please advise. Thanks, Nathan.
Chart Lengend not showing properly
I have a line chart that is working okay, and it shows the legend, but the legend only shows a red square and a blue diamond, it doesn't label what these items are supposed to be (see attachment.) Can someone assist in this bug? Here is the chart script: chart SQUD4242N2_Usage
{
displayname = "42x42 2-Way Usage"
type = XYLINE
show all rows from Main
(
x-axis
(
title = "Date"
field = Date_field
)
y-axis
(
Formula Program Assistance (If>Then)
I am currently using the formula listed below to lookup the previous record and pull data. Altering the formula listed below, how can I write the formula so any number that returns as negative, will be altered to zero? if (count(Main[ID != 0]) > 0)
{
rec = Main [(ID is not null)] sort by ID desc range from 0 to 1;
//fetching the last added record
input.Usage_P1_SQUD7442N4 = ((input.OnHand_P1_SQUD7442N4 - input.Shipped_P1_SQUD7442N4 - rec.OnHand_P1_SQUD7442N4) * -1);
}
else
{
Publishing on Marketplace without install option
Hi, I am currently developing an application that I want to sell on the Marketplace. I want this application not to be installed by the users but just want to share it with them when the subscribe to it (very SaaS!). By doing this I will be able to give better support on the application because if there is a problem it will be solved for all users! However, the marketplace does not support this kind of selling. I think it would increase the possibilities for more complex applications! Is this option
On Submit Mail Question
I am having difficulty with the simple email notification feature once a Creator form is sucessfully submitted. It seems I can only have 1 email address in the "TO" field, and 1 email address in the "CC" field, and 1 email address in the "BCC" field. How can I set it up to send the email notification to 2 users in the "TO" field and 4 in the "CC" field. See code below: sendmail
(
To : "who@who.com"
From : zoho.adminuserid
CC : "who2@who.com"
Reply to : "who3@who.com"
Next Page