Dynamic Field Names (referencing fields on the fly)
I have the following code fire OnUpdate for my input.banana Decision Box field on my order form: if (input.banana) { input.total = (input.total + input.banana_cost); } if (!input.banana) { input.total = (input.total - input.banana_cost); } When a user checks the Banana decision box, the Total field gets updated with the amount in the hidden field banana_cost. Now, I have to perform this same function (hint hint) for 3 more fruits: apples, apricots, and grapes. I've attempted to
Add record from flash application
Does anyone know if I can add data directly from a Flash-style web-app. I simply want to post the score and name from an on-line quiz. The main issue is that I don't want the user to be able to edit the score before sending. Taa
Free account users, can't get the second free user
Hello: I have a free account that can include two users, but when I try to share an application, with myself as the only user, Zoho tells me that I have to upgrade to the paid version. Thanks Alberto
hello, i have a question.
may i know how can i embed my free zoho creator form? please. i want to embed this on my website.
"Date-Time" field data being cleared on Edit if field type was originally a "Date" field but changed to "Date-Time"
If you put a "Date" field in your form, and then reclassify it as a Date-Time field, and then use it in a live form, whenever you go to edit a record in that form the Date-Time field will be cleared, causing loss of data if you re-submit the form. This does not happen if you start the field as a Date-Time field (i.e. not as a converted Date field). Bug.
help with embedding views
I have a view that when I copy/paste the html, the end user sees the "edit" option like an admin does. I thought it was because I was still logged in to zoho so I logged out and then it asked me for a password even though the "embed in your website" setup box says "through this code snippet, you can access the view without login" Please assist. Also, when I use the "get javascript snippet" it works fine. Thanks Rob
Upload contact info from zoho contacts or reports to CRM
Using the Zoho CRM,how do you upload or copy over all your contacts from zoho contacts or from zoho reports. Cannot tell I have to physically enter in every single one,must be a way
Trouble sharing forms and views
I cannot figure out how to alter the list of shared forms and views that is shown in the Share Tab of my application. The email address of each user I'm sharing with is shown, with a link to the right that says (for example) "9 Forms and 11 Views". Clicking the link, it shows me a wonderful list of all the forms and views in my application, the shared ones are green-- the unshared ones are red. But I cannot find a way to turn the sharing on or off. Some of the red ones need to be green, and vice-versa.
Feature request: Ability to search through all scripts in an application for word/phrase
I find myself wishing to find a certain code snippet buried in one of my many scripts in many forms, and searching for it manually is time-consuming and something done better by software. Could you consider adding a "Search All Scripts for: <word/phrase> " functionality to ZC? Would obviously be Freeflow oriented. Greg datazen1@gmail.com Santa Fe, New Mexico US
Deluge Dilemma - Mark Australia
Deluge Dilemma Zoho Creator Team or patient Zoho creator programmers. My name is Mark. I decided to try and build an online BOOKING program myself for my small rental business because I had been let down by so many programmers in the past. I handed over $ 7,500.00 to a company in Brisbane Australia who took my money and produced virtually nothing and six months over due. I had to cancel them and try and find someone else. I never got my money back. And I have had silly quotes since then, for
Logo
Some time ago, I asked about the possibility of having a designated logo for an app, instead of a universal logo for my account. I have got no response. Is it at all possible? Thanks.
email
the email sometimes does not work
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
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
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
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?
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
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.
Next Page