Integrating existing application in to Zoho
Hey guys, hopefully someone can answer this question. Pretty new to Zoho, so just poking around. I have a PHP app that requires users to authenticate with a database. I want to be able to add this app to zoho for other users in my group to access. It seems like my app runs in an iFrame on zoho, so my question is, is there anyway for me to bypass authentication and use Zoho authentication of the user that is currently trying to access my app. In other words, user clicks on my app from within Zoho,
How to Alert the User on whether their Web Browser is a Supported Browser
Hello. I'm interested in writing a script within an HTML view or within the html coding of the View to notify the user of whether or not they are using a "supported browser" on my Zoho App.(I got over 100 Zoho users on my App) I get a lot of help desk calls and most of them are related to unsupported web browsers such as Safari & IE version 8. Any suggestions for this would be greatly appreciated. Thanks.
Why is Data Retrieval for Dynamic Picklists So Slo-o-o-o-o-o-w?!
My app collects state, city, and school data. I have one table (I know zoho creator calls them forms) with a single field and 51 rows - one for each US state plus DC. I have another table with state (lookup) and city. I have another table with state (lookup) and school. My actual user input form has (obviously) state, city, and school. The city and school fields are picklists that get auto-populated from an "on user input" script on the state field that looks like this:if (count(City[State ==
Can't See My Form Anymore - What Did I Do?
I go to edit my Form at http://creator.zoho.com/mcgeepj2/form/9/edit/ and I no longer see all my data fields all I see is this screen shot below. What did I do? Where did my form go with all the data fields? The form still works on-line at http://creator.zoho.com/showForm.do?formLinkId=9&link=true&sharedBy=mcgeepj2 Thanks
Can limit on outgoing mail (from Creator sendmail) be raised from 500 to 2000?
My org's mailing list is currently 2000 email addresses, and growing. But I can't send more than 500 per day from Zoho. This seems like a very low limit for any organization using Zoho Creator for a contacts database. How can the limit be raised to higher numbers? Please advise. Thanks. Greg Malone Santa Fe, New Mexico, US
Is a random() or rnd() or rnd(x,y) function available in Creator?
I want to display a randomly selected record in an HTML view. Try as I might, I cannot find any workable references on how to get a random number, or select a random record, etc. Any help? Thanks. Greg Malone Santa Fe, New Mexico, US
Criteria for embeded view: how to implement 'many-to-many'?
I have an html view in which I have implemented deluge script to fetch a list of cities from a certain "Form A" record (multi-select field). Below that (in the same html view) I want to embed a view that shows all "Form B" records where at least one of the selected cities are the same (Form B also has a multi-select field with cities in it). Is there something like: <div elName='zc-component' viewLinkName='TestView' params='Cities={London:Paris:New York}&Cities_op=99>Loading View...</div> where 99
Sort drop-down alphabetically
I would like to sort the lines in a drop-down (lookup) menu alphabetically. I have checked the box "sort entries alphabetically" (or something like that) under the drop-down menu options. But the entries still appear in random order... Is that an application error or is it me? :-) And ever more important: how to make it work? Any thoughts? J
Can't import csv or xls files
This is the first time I've used this so it might be something stupid. I created a form by importing an xls file. This had a single 'record'. I am now trying to import a similar xls/csv file but with multiple 'records' ie rows. The file has exactly the same row headings and I am checking the 'first row' is column headings.
Issue with date format when importing data
When I import data into an existing form, the import defaults to assuming any date is in a dd-MM-yyyy format, and sets the format to MM-dd-yyyy if it detects that the date is invalid in dd-MM-yyyy format but is valid in MM-dd-yyyy format. For example, if I import the following data:Transaction Date Transaction Amount 9/5/2008 52.39 9/12/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39 Zoho puts the data into my form as: 5/9/2008 52.39 12/9/2008 31.43 9/16/2008 -75.59 9/19/2008 31.43 9/26/2008 52.39
Font and Size will not change ina NOTE field
The FONT will not change in a NOTE field. The FONT SIZE will not change in a NOTE field. Please advise.
Can't share with developer, can't duplicate, can't import
I really need to give edit access to a coworker for one of my applications (currently shared to support). I've followed the instructions found in other posts, but I cannot share with my coworker as a developer - I continually receive a "please try again later" pop-up when I try to change the application settings. In an attempt to work-around the issue I've hit brick walls in trying to duplicate the application, as well as exporting and re-importing with a different name. How can I allow another user
Rendering of File Upload field contents
Aparna: This is a followup of the discussion here ... http://help.zoho.com/portal/en/community/?ftid=2266000000540065 ... starting a new Topic to explain my exact situation. One of my first projects included the following that worked perfectly ... a) Form called Staff Records has ... - a File Upload field called UploadPhoto - a Formula Field called Photo with this formula ... ("<img width='64' height='75' title='Staff Photo' alt='Staff Photo' src='http://creator.zoho.com/DownloadFile.do?filepath=/"
How to copy application.
I created an application. Now i want to create a new application based on it. I click duplicate but nothing happens?
Separation of digits (thousands, millions etc)
Make, please, a separation of digits (thousands, millions etc) in formula fields and in total row.
Position & Hide/Disable Buttons just like Form Fields
Hi Zoho developers, I have a small request. Would it be possible for you to implement the following: For Buttons in the stateless form, 1. Hide/Show 2. Enable/Disable 3. Reposition buttons, exactly like Form Fields 4. Change the "text on this button" via script --------------updated--------- 4. These buttons would have several 'States' 5. User can add, remove 'States' 6. Button will be switched within 'states' like this: If ( input.nameverify == input.name ) { Changestate button1
Integrating Zoho Creator with Zoho Docs
I've created a form on Zoho Creator; and I have a doc library in Zoho Docs. Based on the values inputted into the form, I want to open a doc from my Zoho Docs library for editing. The doc selection is dynamic - depending on the inputs into the form, the name of the file (to be opened from Zoho Docs) and its folder location will vary. How do I get this done?
having created form sent
ok here is what I am trying to do: I created a sports registration form that I embed on my website. The goal is to have a parent of a child access the site, fill out the registration form, and then have a copy of the actual form get emailed to the person who filled out the form, as well as to the treasurer of the association (we are a non-profit church group). So far, I have been able to have the form filled out and the database updated without a problem. I believe that I have the access so that
URGENT!!! Zoho Creator Form Issues!!!!
My application is continuing to have major issues. It is taking 10-15 minutes to load a view or to add/edit a record and I can't add any additional form fields. Now any views that are associated with my form receive the following error message: "We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com" I've contact support by e-mail and phone with NO resolution. Please HELP!!! My data is locked up and my sales team (40 agents) can't
Make it stop!
I have a simple "on user input" invoked function to make some text conform to a standard. input.RMC = thisapp.inventory.RMC_CHECK(input.RMC); It works, but the "on user input" keeps running forever (little spinning arrow next to input field). How can I specify this function to only run when a human changes the input field, and not when the function itself acts on the string in the field?
New String Function
Here's a simple request to compliment the built-in string function: xyz.removeAllAlphaNumeric() Please support: xyz.removeAllNonAlphaNumeric() Thus "OUCH! I banged my little @#$% toe!" would become "OUCHIbangedmylittletoe" Thanks!
how to create an editable multi select dynamic picklist?
for example dynamically create a books_i_like picklist from all the books. then allow a person to check and uncheck their selections without destroying their previous choices by rebuilding the picklist.
multiple pop-up windows / dialogs
Hi, I wondered if it's possible to have a pop-up dialog on top of another pop-up dialog? I've tried this myself, and it seems to have some odd behaviour. So I'm guessing it's not valid, but I just wanted to double check? Here's what I did: I created a view, with custom actions. The custom action is to pop-up a view (as shown in the attached picture). The pop-up view *also* has a custom action, which is supposed to pop up another view. But this second pop-up just seems appear momentarily, and
Creating an Image View that can be printed
Hello. I've created a form that lets me upload image files. I'd like to create a HTML view that lets me see a particular image in a full page size and have on the bottom a button or text that would allow me to print the image shown on the html view. What would be the best way to approach this? Thanks.
Strange behaviour on HTML embedded views that receive params
Hi all! I'm making an HTML view called 'Test' within 2 embeded HTML views. Both embedded HTML views are the same HTML view, but receiving diferent parameter values to print. See the code below: htmlpage Test() <%{ <div elName='zc-component' viewLinkName='HTML_view_A' params='message=FirstMessage'>Loading View...</div> <div elName='zc-component' viewLinkName='HTML_view_A' params='message=SecondMessage'>Loading View...</div> <%}%> And htmlpage HTML_view_A(message) <%{%> <%=message%> <%}%> Ok,
Permalink will not work
I created a permalink with a success message and nextURL and it will not open. I get a vague error: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to HomeI created the permalink throughout the More Actions--> Permalink in the Embed in your website creation box. I tried to recreate the link, tried logging out and back in, tried different browsers. It is not working. This is the second issue I have had today.
Disabling the standard edit and view links in a view
Hi, I badly want to know how I can hide the standard edit and view linktext in a view. These linktext always seem to be present in a list-view. I do not see some settings to disable those (and I need this because I want the users to edit the recors via a function via Edit a record via Record ID). Or is this dependent also on whether you are an admin of an application? Any help is appreciated. Kind regards, Silvester
You are doing it again! Fix it!
I have had this same issue in the past and I was told it was fixed. You are adding a variable name to your JSON api calls.... Like this.... instead of just {"Client":[{...... it's var zohosrhyneview204 = {"Client":[{... Fix it! This is like the 5th api bug I have had to point out to you guys.
forms not working anymore (private / public issue ?)
Hello, Two Zoho Creator 'contact' forms have been used with success for quite a long time already on two different of my sites. Yesterday, a third one was implemented on a third (in the making) website (see: http://sites.google.com/site/kuntheacom/contact-1). It appears that, while the application remains 'private', the form must be made 'public' for it to become accessible to anyone. It took me a while to understand this, because the procedure was different before (as far as I remember). It was
leading zero
Hello, i have used an int field for my zip codes. Now i discovered that there are zip codes with leading zeros which disappear. I can't change my field to string, it's tooo much work. Can I do it an other way with some other tricks to let leading zeros be where they belong to? thx
How to show a field that is in another form?
On Add, I would like to add code that will allow me to Show and Enable a field from another form. When I select the Show option the pull-down menu does not display the fields from another form.
Filters contra views - performance
Hi, I wonder, what is best to use - filters or views, if performance in ZC is considered? Br Skouboe
Can't copy view
I tried for five minutes to copy a view and cannot do it. I get an error: Error occured while duplicating this view.<br>Kindly refresh the page and try again.I tried to refresh multiple times, signed in and signed out, tried with different browsers and nothing worked. What is going on?
image loading is very slow
Is there a problem with the loading of attachements as the service is very slow, and is almost unusable due to the process. It actually appears as though it stops. Can you advise please? dp
Need calendar widget that shows database rss feeds for an "events calendar"
Hi I need to make a calendar or widget that pulls in specific things to do for each day that comes from our zoho creator events database application. can anyone tell me how to make this - if one already exists - or if I can use another third-party calendar or tool that will show a calandar of say, the week ahead's events, and music only, arts only, etc, etc....?? Thanks! andrea
When using IF I want to use the or function for a set of inputs but cannot make it work
When an input is made on a form and on field actions on user input I want to set a set of or conditions if (input.Key_post_code_area == "AB") however, I cannot make this save, and have had to add it condition by condition, which slows the process. Can you help? dp
Disable export in Zoho Creator
We have been helping customers get started in Zoho and ALL of them ask if Zoho can disable exporting and printing. This feature is key to protecting business data. I see that others have asked for this feature. When will it be available?
Unexpected Zoho Creator behavior changes
Hello Support, I am really tired of you making changes to your application environment and behaviors WITHOUT NOTIFYING YOUR USERS/DEVELOPMENT COMMUNITY! Example. I have had the same 40 users using the same application for about 5 months. I have two forms embedded on one html view. For the last 5 months when submitted, these forms just refresh the page. NOW when either of the forms are submitted. They SHOW ME A LARGE "Data Added successfully" Header in the middle of a blank page! I am sure it has
How to program dynamic calculation ?
I explain my problem : I have a Project , containing Steps (Step A & Step B, for example). My users declare activities on project belonging to step A or step B. These activities have a value of days (0.5 or 1 or more). I would like to have an dynamic udate of the consumption consolidating all activities declared by step. For example : 2 users declare activities on step A. 1 declare 3 (days). The counter of consumption for step A becomes "3". Then a second user declares 4 days on step A. Then
Add selections to multiselect checkbox field
I am trying to figure out the best way to add selections to a multiselect check box field in a current record. I do not want to open the entire form and edit it but just see that one field to edit. I've created a function that successful opens a stateless form with the checkbox fields and the parameter for this list selections are being passed to the URL, but it is not actually selecting the corresponding fields. Is it actually possible to populate a multiselect checkbox field from a URL parameter?
Next Page