Trouble deploying Share command ...
Hi: I am having problems deploying the share command. I have a Stateless Form with an Email Type field (called User Email) and a Custom Button with this code ... share section("Home", input.User_Email);
share form("BizHours", input.User_Email);
alert(input.User_Email);When I run this Form ... enter the email address of another ZOHO User ... and Click on the Button ... I do not get any error messages (I am the AppAdmin) ... but when I go back to Edit Mode and look within the Share Tab ... this Share
Date Field value DISAPPEARS
My application is tracking domain names. There is an 'expire_date' field and there is a rating field called 'NFJ_Tier' (Multi-Select) I display the data in a 'spreadsheet' view (called SCORE) so that I can quickly make changes to NFJ_Tier for many records at once. Even though 'expire_date' IS NOT used in the SCORE view at all... When I "save" changes (scores on NFJ_Tier) every corresponding 'expire_date' value changes as well to NOTHING. It CLEARS THE expire_date field ENTIRELY! This is NOT GOOD.
Possible bug when entering Expression for Formula field
Hi: Thought Support might be interested in this problem I encountered when trying to enter a formula (for rendering an image uploaded in another field) like this ... "<img src='http://creator.zoho.com/DownloadFile.do?filepath=/" + UploadPhoto + "&sharedBy=scriptedlogic' title='Staff Photo" + "' alt='Staff Photo" + "' width='64' height='75'/>"... using the Edit this Field facility. After entering this formula for the first time ... as soon as I click on the Done button and return to this Dialog Box
Date field / Calendar Icon
Is it possible to restrict date entries to the Calendar Icon only? We are getting frequent reversals of the day with the month on data entry and would prefer to limit date entries to the use of the calendar only. If so, how do I block the date field? Thank you for any assistance. Frank P.
Note field span
Is there any way expand the note field so it spans across both form columns. I need produce a form sub-header.
Problems with Quotes for HTML Link in Creator
<a href="url">Link text</a> I am trying to get this syntax in a auto fill form I have. I can't get the quotes to work around the url bit. This is what I have: website_new.URLhtml = "<a href=" + input.Webpage + ">" + website_new.First_Name + " " + website_new.Last_Name + "</a>"; what syntax do I need to get the quotes are input.webpage? THANKS!
How do I add quotes into this sting for autocreation of weblinks from my form:
I am trying to add quotes " around my input.Webpage so that it is a html link so I can download the list and upload to my website without having to format. I cannot get the quotes to work... I have tried " but the creator script gives me an error. Any help would be appreciated! NEED THIS: <a href="url">Link text</a> website_new.URLhtml = "<a href=" + input.Webpage + ">" + website_new.First_Name + " " + website_new.Last_Name + "</a>";
multi-line input box
Hi, Is there anyway of making an auto carriage return in the input box of a multi-line field or putting in max width? I have designed form to fit neatly on page, but if person does not do carriage return manually then when entering in the multi-line field it stretches it too wide? tks
[Feedback] Application Published
Dear sir, I have published my applications to the Marketplace, but I am not getting displayed all application in my Developer Zone. Why is it happening, please solve the problem. I am removing my app Classifieds but not getting removed from Developer Zone. I want to republish my "Share Files" App to the marketplace but there is nothing to do, please help me about. Regards Manoj Kumar
automatically logs me out too soon
I can stay logged into zoho planner all day long without having to re-login. However, zoho creator seems to log me out after a certain amount of time. This means I have to log in about 10 times a day which is a total pain. Can you please either extend the amount of time before the system logs me out or make it a user option? Thanks.
Cannot add new records
Hi, I just added a couple of new fields in my application and now when I try to add a new record nothing happens. The record is not added.
Stateless form submission invokes script
I have successfully created a stateless form that sends data to my "default" Zoho Creator database. What I'd like to know is if this submission can trigger a script in the default database to send me an email. I put a simple script in the default database's On Add>On Success section, but did not recieve an email. Any advise on this issue is appreciated.
"Set Criteria" for an embedded view in HTML view with a parameter
Hello, I have a doubt concerning parameters in HTML views and embedded views with "set criteria". I have an HTML view with a parameter named "CODE", and inside this HTML view I have an embedded view of a list of products (each one is related with one of this codes). I would like to know if it is possible to embed the view with the "set criteria" the parameter "CODE" for only displaying the products with the defined "CODE". Thanks in advance! Carlos
business cards
Hi. Is it possible to make a business card with a photo using Zoho? Thanks
My form
I made a contact form that I've started using but the emails are blank. Can anyone help me to recover this information? It is not making me look good to have a form that doesn't work. Please email me if you know how to make this work at williamtheoutlawATgooglemailDOTcom Thanks!
Added Time - can only date be shown in view
I like added time field to use for filtering, but would only like to see the date, not the time i.e.: 4/03/2009 not 4/03/2009 21:45:46 I cannot find where I can set this field (it seems to be a hidden field). Any help would be appreciated. Keep up the good work - this product is amazing!!!
Trying to create simple applicaton
Seems like a simple enough thing, but I'm having difficulty figuring out how to do this in Zoho Creator. All I want to do is have a database of records and have a front end form that users can use to type in a code and only the records in the database containing that code will be displayed to the user. Is Zoho Creator the right tool for this? And, if so, how is this accomplished?
Forms with Multi HTML views
Hi, I have a Form with about 20 fields that I use to track request made via our website. However, I want to display selected fields on 3 different HTML web pages hide some of the fields. I don't want to create a form for each as I wish to keep the request in One Database Can someone recommend any tips? Dom
Change of 'Modified_User' behavior in update record through script
Dear User, This is an announcement regarding the change of behavior in 'Modified_User' value when updated through script. Though this is minor behavior change/issue fix, we thought of informing the users. Every form in zoho creator will have an internal field called 'Modified_User'. When a record is updated in zohocreator through any views, the login id for that particular user who is updating the record will be automatically stored in the 'Modified_User' column of that record. However, when a record
Hide app name in summary view
I put the iframe of a list view in a webpage and when the user clicks on an item, it takes them to the summary view of a specific item. There's a link at the top to my app that says "app name by username". How do I hide this? The link is clickable so the page is loaded within the iframe. Is there a way to edit this? Ideally, I'd like to be able to customize the heading so that the information is specific to my item (maybe a link to a wikipedia page, or something). Other options would be to just hide
can't access my apps on zoho creator?
HI i can't access any of our apps on zoho creator. i can access creator.zoho.com, but the apps page is blank when i sign in. i was able to use one of our applications (ie, i submitted a form and it worked fine) but i just can't access it from the creator.zoho site to look up our data. any idea what is wrong? if there's more info i can give please let me know thanks brian
Slow Performance
ZC has slow performance today? Anyone know why?
File upload issues
Hello there guys, I'm here to report a problem I've been facing with a form I created for my blog. In it theres a upload file line, which doesn't seem to work. All the other data added in the form by users are sentto my email, bot not the attached file. Someone has a clue of whats happening? I've searched everywhere to try to solve my problem. Hope you can help me.
Importing - arrgh!
Is a a new/better import feature in the works by ZOHO developers? The current "paste your data" function gives me problems all the time (certain data not making it to the application, others being imported to the wrong field, sometimes nothing is imported at all). And I've followed the suggestions I've found on this forum (pasting directly from Excel, a converted tab-delimited file, and from a CSV file). Still errors! The most basic databases I've worked with in the past had much better import features.
Personality Variable
Can anyone tell me what a personality variable is, or how I would declare it? Here is the code: if (count(Further_Category_Options[Sub_Categories_Selection == input.Material_Sub_Categories]) == 0)
{
clear Further_Category_Options;
}
else
{
for each subcategory in Further_Category_Options [Sub_Categories_Selection == input.Material_Sub_Categories.toString]
{
Futher_Category_Option_Field:ui.add(subcategory.Futher_Category_Option_Field);
}
} In line 7 I added "toString" because
Application duplicates keep appearing
Multiple copies of my Creator database labeled 'Copy of ...' keep sprouting up for no apparent reason. All I've been doing is editing individual records. What's that all about?
How do I create a "demo" of the application?
Hi Techies-- I'm baaaaaaaaccccckkkkkk!;-) This time, I am trying to create a demo of the application to publish. Any advice?
Need to Hide Input Form
Hi Techies-- I have a few forms I created for the purpose of summarizing information to be used by corresponding chart views. I do not want this form to be available to the end users. I see that I can set permissions, etc. on views--but i don't see how i can exclude a form -- or in some way make it unavailable. any advice?
Many-to-many relation.Help needed.
Hi there, currently I am testing Zoho many-to-many relation capability. I managed to create a test application with 3 tables Student, Course and Student Course. http://creator.zoho.com/webappsatwork/many-to-many-relation-test/ I would really appreciate your help if you could clear up following issues: 1. Is it there in Zoho Creator any other possible way to organize edit/view data what courses the student is going to attend acept from view/edit through this view: http://creator.zoho.com/webappsatwork/many-to-many-relation-test/#View:Student_Course_View
Hide Field command messes up the input.Field value ...
Hi: I have the following code in a Stateless Form's on Load section ... it is meant to be called from another Stateless Form with the StoreNumber passed in the url Hide StoreNumber; if (count(Stores[StoreNumber == input.StoreNumber]) > 0) { //get record from Stores Table thisStore = Stores [StoreNumber == input.StoreNumber]; etc. etc. In order to prevent someone from directly requesting this Stateless Form, I make a check to ensure that there is no matching Stores record. But it does NOT work
Would like to learn more about using built in functions
Hi, While there is some information in the Help on the definitions of built in functions, there is little in the way of examples on how to use them to make your application more powerful and elegant. I'm guessing that some of the functions are fairly standard amongst many database platforms so there most something in the way of resources to teach me how to use these even if there are not directly related to Zoho?? Are there some example of how to use and call these functions in the Help files that
How to send mail to a group of contacts
Hello there, I'm new to this Zoho Creator thing and I'm learning it. I have a need to create dynamic communication list using the email of my contacts form application (in Zoho Creator). Here is the exact sample. I have a contact directory with 1200 contacts. Some of the fields list are, NAME, GROUP, EMAIL. Lets say that I want to invite the people that belongs to the "ENVIRONMENT GROUP" to a conference. For that I run a view form with the filter "ENVIRONMENT" in the "GROUP" field and they are 163.
Chart Views: Group by issue
Techies, Brainiacs and Wizards-- I have an app (written under free version) that captures consumer information about creditors. The main form captures the zip, state, dollar value, opinion questions, etc. It appears that the database behind the forms is creating a unique id for each user--which is good--exactly what I want! So here is the trouble--I want the bar chart/pie chart to group the total dollar amount by state. What is happening is the chart is grouping the dollar value by state by id--I've
roundup
I'm looking for a function similar to the Excel function roundup(number,num_digits) that will always round up to the specified number of num_digits. Example: roundup((39.97/36),2) = 1.12 (actual answer of 1.110278 is rounded up to 1.12) Are there any plans for a roundup function? Or a way that I can accomplish this programmatically? Thanks in advance!
Newbie Warning:
Hey Brainiacs, Warlocks and Wizards– I LOVE, LOVE, LOVE this ZoHo creator product–what a fantastic tool–even though I’ve only been working with this tool for a day, I can see its potential!:-) I am REALLY confused about something though. I want to create a payment allocation matrix. What I want is a single currency field which takes any $usd value–let’s say for this example: $100.00. I then want to create the matrix for a lookup based on a customer/client that is predefined. So, let’s say user
About Import Fields (Picklists) ...
Hi: I am trying to setup a Table of (US) States and (Canadian) Provinces ... to be used as a dropdown with Import Fields in other Tables. I want the entries to appear in alphabetical order ... but all the (US) States first ... followed by all the (Canadian) Provinces ... so I can not make use of the checkbox labelled "Show choices in alphabetical order" ... as a work around, I thought of bulk uploading (Import) the records in the desired order ... and I ran into two issues ... a) since the records
Report Writing
Hi I have developed a sports medical screening database capable of producing individual patient reports and team reports. For example If reference cell A2 = 3 then the reports reads " it is strongly recommended you address this issue with your Sports Doctor" All the results from A2 can then be summaries in a "team summary" I can see how Zoho Creator allows the formation of a Summary, but I would like to be able to produces "Individual reports" for each player. Ideally these would refer to Multiple
all contacts doesn't remember settings after edit view
Hi, I'm trying to set up the 'all contacts' view to 50 records per page and sorted by name. As soon as I edit the view, the list goes back to the default 10 per page and no recognizable sorting. I'm using firefox 3. Any ideas?
How to sort by refered lookup field ?
Here's my sample case I have to forms: Form1 Product Color Size Owner (lookup based on Name in Form2) Form2 Name City I'd like to have a view based on Form1 and sort for a specific city (and maybe not showing City in the view). I'd like to sort by URL like this https://creator.zoho.com/<user>/<appname>/#View:<viewname>?City=Montreal Thanks for your help. Pascal | nsisolution
help with date fields and numbers in formulas
I need to take one numerical field and add it to a date in a date/time field to result in a new date. Using a form to create a schedule of activities to be done from certain number of days and weeks post hatching. Example: reduce temperature - 7 days post hatch date - results in date to perform the activity Hatching_Date (date/time field) + 7 (days, weeks, or months) = Activity_Date I know how to do it with static number (ie Hatch_Date.addDay(7) How do I do this with two entry fields?
Next Page