email
the email sometimes does not work
Confused by lookup field
I have a status field that I use to track the reservation record. I have a couple of statuses that I write via script that I do not want to be set by a user. So in my lookup table I only included the statuses I want the user to set. If I create a new record or edit a record I also see the statuses that I have written via script in the lookup field choices it is not just the values from the lookup table. Why is it showing these extra values. That does not make sense to me. Is there a simple way to
Lead Owner Tab
How do I edit the lead application in Zoho Creator so each user/lead owner can view only his/her leads not all the leads for all lead owners in the CRM? I can't seem to find the instructions neither any functions that disables users from viewing everyone's leads. Your helps is very much appreciated. Thank you.
If statement in Formula
Is it possible to have an If statement in Formula field. I'm looking for something like this: formula1 = "XYZ" If field1 = "A" { formula1 = "ABC" } Herb Wexler
Sort a link column based on the shown record
I have a column that is a link to a pop up window with more information specific to that record. The column is called Common Name. Because each entry within the column is a link, when you want to sort the data based on that column, it does not sort correctly based on what the user can see. Is there any way I can have zoho sort the column based on what the user can see rather than what is really in the record? Or is there a better way of implementing something like this?
How to design a rank field?
Hi, I am doing a an online survey. I want the respondendts to rank few parameters. Is there any way that I desoign it in zoho HTML form builder? Your respone will be of great help to me. Thanks in Advance. Regards, Balamurugan
Adding attributes to images added to image field in form
FYI if you add an image URL to an "Image Field" in a form ZC automatically creates the "<img src=...../> html around it... This can be both convenient and a nuisance in some situations because it blocks you from quickly adding CSS/HTML attributes... Use a function like this to remedy this inconvenience... string translate.edit_img(string url, string attributes) { first_part = (input.url).subString(0,5); second_part = input.attributes; third_part = " " + (input.url).subString(5); return
"Item" checkboxes and Total Amount on an Order Form
I have an Order Form of sorts with a Total Amount field. I have a checkbox field for different items on my form with associated hidden price fields. When a user checks an item's box, the Total Amount field is updated to include the associated price. However, the SAME action happens when a user unchecks a box, i.e. the price gets added again to the Total Amount field. Granted, I'm just playing around right now, so my code looks like this: if (input.items.contains("Fruit Loops")) { input.total
Big Problem
I have a big bug: We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com and the aplication don´t send a copy of all the data :( too. I enable the access support. Can anybody help me?
Can I display different data in list view and summary view?
Hello again, Is it possible to have a list view which only shows some columns, but a summary view which shows the entire record? (My list view is very wide). Thanks again, Ollie
Need Assistance w/ Look up Field (3rd Request)
Hi Guys: I'm sure you're really swamped, but for the past week I've been trying to contact someone that might be able to give me the answer to the following question: I have two views (Brokerage and Agent) and the relationship between them is that "an Agent belongs to a Brokerage." In setting up the Agent view I have added a "Lookup" field to pull up the "Brokerage name." So when I save an Agent I assume it saves the name, not the ID, of the brokerage in the Agent view. In a traditional database
Setting "Alphabetical" in Lookup field causes field to disappear from form editor
UPDATE TO THIS MESSAGE: Suddenly, the "bug" is no longer manifesting itself exactly as described. Go figure. Don't know why, but it seems to have corrected itself, at least for the moment. But I am still seeing intermittent vanishing of fields from the form editor, which reappear when refreshing the browser. ORIGINAL POST: I've seen this before, thought it had been fixed, but am seeing it again now consistently in a particular form. The bug: I have a form with a Lookup field. The Lookup field
How can I change the displayed fields of a lookup value?
When a lookup field is created, we need to select a display field. When I edit the lookup field properties I cannot change that field. I tried to change it in the script but received: Error modifying the page Error at line : 43 Type change from import type to another import type is not allowed as it may lead to data loss.If data is not a problem, then kindly delete the old import field and add the new one on your own. How can I change the display field in a lookup field? Thank you -andrzej
Unable to be added as developer..
My zoho id's are srhyne and zo_how, my users are trying to add me as a developer on an application I placed on the marketplace however I am unable to see my app I developed and they are sharing in their workspace on my account. Their workspace shows up in the dropdown but the application is not there. Application... PDI Connect
HTML View styles
Is there a reference list of the styles that can be used in an HTML view? I would like to format an HTML view to look like the standard creator views but am unsure how to do this.
column widths
Setting column widths on my application has no effect whether I use pixels or %.
Function call not working
I have defined the following function to sum a list of values from a form... float gamOrgBalanceSum(string clientID) { returnVal = 0.0; for each gamOrgBalance in Client_Gaming_Account [(ClientID == input.clientID && (GBP_Balance != null))] { returnVal = (returnVal + gamOrgBalance.GBP_Balance); } return returnVal; } When I execute the function manually all works fine. However, when I execute the function from an HTML view as follows... bal5 = thisapp.gamOrgBalanceSum(clientRow.nameCode);
fetch on pickinglist
Hi I have a system in which I have a piece of code called(Action on input): dat = EmplDetails [Name == input.EGName]; input.EGDepartment = dat.Department; input.EGEmail_1 = dat.MailId; This works fine! I would now like to add a new field named Plant (fieldname "plant") also in the appl. "EmplDetails". This however is a pickinglist. How can this be done? BR Skouboe
Get info on delete
When a record is deleted from my system an email is sent to the administrator with the details of the record. I would like to include information on why the record is being deleted. Is the best solution to open a stateless form? If so how do I close the form? Herb Wexler
Date/Time Calculations
I have a question about how Zoho interprets date and date/time fields, specifically in calculations. For instance, if I have a date field (not a date/time field), is the date field actually a truncated version of the date/time field, or is it simply a date field? For instance if the date field reads: 18-Jun-2009, does zoho really interpret this as 18-Jun-2009 00:00:00? Thanks, Leo
Script Builder Frozen
Something up in Zoho land?
keyword search
I want to search my entire database for all records that conatain a certain keyword. How can I do this without searching each individual column separately? Ollie
Custom themes aren't working for me
I've created a custom theme in Zoho Creator, but when I apply it, I just get a HTML page of my application that looks like it has no stylesheet applied. I've tried creating another theme just to test it, but that one does the same thing.
Confused by Contradictory Usage limits Information ...
Charles: I am confused by some contradictory information regarding Usage Limits. a) Over here ... http://zohocreator.wiki.zoho.com/Usage-Limitation.html ... the new container for ZOHO Creator Help Documentation ... it says ... The usage limits for an account is listed below: The maximum number of deluge statements that can be executed per day is 5000. For E.g. If an 'on success' action has one send mail task, it means the number of statements is 2. b) But when I click on my Account Settings link
How to pass a For Each record parameter (r) to a different HTML view and access the record passed in the parameter
I'm trying to pass a record index number as a parameter to a second HTML view and use it there to access that same record... and I'm failing after much effort. I have an HTML dashboard view that successfully lists records from a form using a 'for each r in <formName>' loop. I've put a link w/ each output record that links to another HTML view that will (when this works correctly) elaborate on details of the individual record being clicked on. I've setup the second HTML view w/ a parameter called
no total
Please inform me how to get total of the items
Combining - On Edit and On add (On load)
Hi I've only been developing my app for the last couple of days so forgive me if this is really easy to do but I haven't found it in the help: I would like the "On add' and "On edit", "on load" parts of my form to execute the same set of commands. However it seemed to me to be bad programming to copy and paste the same code. Typically I would simply call the same function from both the "On edit" and "on add" sections however since a large amount of my onload script is using show and hide commands
zoho.currentdate in url?
Anyone know if there is a way to specify criteria in a url that ranges between the current date and a future date? My lame attempt was: https://creator.zoho.com/user/events-calendar/#View:Events_Form_View?Day=zoho.currentdate;30-May-2009&op=58 ; which doesn't work ;-). I'm sure I'm mixing my metaphors, as it were....
Date Time Field Issues
I know you are working on the date issues and you may be aware of this but I figure information is helpful. I want to build a list of options by the start date and time range. Example code: for each r in Reserve_a_Room [(Start_Time >= tdds2 && Start_Time <= tdde)] sort by Start_Time. I thought this was working but I was testing it today and it seemed to not be working correctly. I thought my default date type was a dd-mmm-yyyy but it was dd-mmm-yy. Maybe that is what changed. I messed with
Can anyone tell me what's wrong with my Zoho Creator form?
When I embed the iframe on my site, the success message is shown OUTSIDE of the iframe and not on the iframe. What's wrong?
Can I transfer ownership of an app to an alternate user account that I use?
I created my first Zoho account and started app development. But then I created a second Zoho user account that I wish to use as my main account, but I also want to transfer complete ownership of the app created under the first account to my new main user account and continue development from there. Can I do that? Or do I have to start over again w/ the app in the new user? Greg datazen1@gmail.com Santa Fe, New Mexico US
Browser Back Button and Strange Form Behavior
In my application, a user visits a website to "request" a form by email (this insures he owns the email address by the way..nice trick). When he submits this stateless from (his name and email), a random number is generated and added into a new "blank" entry on the ZC database. When he opens his email, and clicks the link, the link is keyed to open the new blank form using the aforementioned random number. He then fills out the form, and clicks submit. The code reloads the page with a thank you message.
A Variable's Scope
When declaring a variable used in an element (e.g. FormElement > On User Input). Does the variable's scope apply to the element or the form? For instance is there any problem with using the same variable name in multiple elements within the same form? Thanks, Leo Saumure
View - criteria - only show records belonging to own userid
Hi, looking for some help here. I have a simple form with just two fields: a username field and multiline text. The form automatically adds the zoho.loginuser as the username field - and that works fine. I want a view that shows only the entries of the logged in user - simple enough right? So I set the view criteria for username field == zoho.loginuser nothing shows in the view (I checked the CRM app in the marketplace and that doesn't work properly either so it's not just me) I've tried getfunctions
Confusion about sharing after changes
I'm getting confused about how best to share my application with my colleagues. I'm building an internal system that a great deal of my co-workers (50+) will be accessing. We're currently in the testing phase, so i'm still adding new views and forms to the app. I find that even though I add these users in the "sharing" tab, the new views/forms don't automatically show up in their view of the app, but instead a second listing of the same application shows up in their Shared Applications tab and
Image thumbprint
When displaying an image in a field, the image displays full size when you open the record. Have images display as a smaller thumbprint until you click on the image to view full sized.
Sharing ZC app w users, then deleting those shares, then adding new shares fails
I shared an app w two users (my limit for this presently free version), then I deleted those sharings, then tried adding another and am told "To share more users Upgrade your user plan" I think the program is not adjusting the number of shared users when they are deleted, so the program thinks I am still using my maximum # of shares. Could you please verify this, and fix if I am correct? Thanks.
Export to excel
Hi, Why can't I export data to excel in this form? http://creator.zoho.com/rmod59/inqu-rito-biblioteca-escolar/form-perma/INQ_BIB_CR/
Frequent Form Corruption
I have been having various issues with a form in my application:INZ Database. The form in question is:frmEvent The problem seems to be centred on some Deluge script that I have placed in the On User Input of control:cboEventAgencyID. The script reads as follows: //If cboEventAgencyID does not equal "-Select-" then
if (input.cboEventAgencyID != "-Select-")
{
//Enable the following combo boxes
enable cboEventVenueID;
enable cboEventClientID;
enable cboEventContactID;
//Set the
url field not working?
suddenly, my url fields have stopped working correctly. If I specifiy them as "must have" I get an error on submit that says "Select a value for URL" even when there is a url typed into the box. If I remove the "must have" it submits fine
Next Page