Service Interruption?
According to my users and this http://status.zoho.com/, many ZOHO services are having issues. John M. Whitney
Fun With PHP
This may be obvious to some, but it's the first time I ever did this... If you have access to a web host that allows PHP, you can use Creator to post to a PHP page and send an email. Here's an example of the Creator post script: (the input.message is the rich-text field) MAIL_DATA={ "to_email" : input.to_email, "from_email" : input.from_email, "subject" : input.subject_field, "message" : input.message }; RES = postUrl("http://my.site.org/index.php",MAIL_DATA); alert RES; And here's my php form: Note
Example source code for PHP Post Method call to Creator Form (from PHP Command Line) - seems to work.
Hey all, after some happy hacking...I appear to have been able to get this working from a command line call like this... C:\PHP_TESTS>php testcalltoZohoCreatorForm.php ...the PHP seems to work OK whether from a Windows (XAMPP PHP) or Linux environment. Being able to do this is useful if, say, you ever need to schedule some activity, such as a nightly or hourly data transfer from one server to another. Thanks to some other forum posts, I was able to get this working from a HTML form (i.e. webpage)...and
Grid views values being blanked out
Hi, I had posted the same problem in August 2010. We have been facing this problem over and over again and there doesnt seem to be any logical reason. Can you kindly look into this problem again. Here is the description. I have a form A in which the name, registration number and other details of a student are stored. I have another form B in which the name, registration number are imported from form A and marks of the student are stored. I have a GRID view based on form B in which I use the lookup
How to control window dimensions in opened URL link from HTML View?
I have an embedded iframe containing a ZC HTML View, seen in-part here: I want the "More Info" button to open a new window containing another ZC HTML View, and the window is *sized* and preferably *centered*... i.e. a popup. But since ZC doesn't allow any Javascript, I'm at a loss for how to do this. Though the openURL() function does have a popup size parameter, it is an immediate-acting function... i.e. it can't be triggered by a click on a button in an HTML View, as far as I know. Anyone have
How to add a parameter to a Embed View in a HTML VIEW
My question is, how can I add a parameter into a Embed View. The parameter and the Embed View are in the same HTML VIEW. The code of my html view htmlpage Entidad_Comercial1(Identity) displayname = "Comercial Enterprise" content ... <div elName='zc-component' viewLinkName='EContacts' params='zc_Header=false&zc_Footer=false&zc_SecHeader=false'>Loading View...</div> ... In the EContacts I have one "Comercial Enterprise" field and I wanna show only the Contacts of the EContacts list when the field Comercial
Need row variable to be formed as a result of user input or as a result of an expression
Hi, I have a form and am using a for each record statement which gets assigned to getroomstatus in my form i then need to check each column in a row for a value, the column is selected by user input I can use if getroomstatus.column1 == free , if getroomstatus.column2 == free etc etc This works ok but i have have 50 columns to check better would be to make getroomstatus.column1 as a result of user input I tried whichcolumn=getroomstatus+input.roomslected but this does not work also tried whichcolumn="getroomstatus."+input.roomselected
Embed Uploaded Document In HTML View
I am trying to find a way of embedding an uploaded document into my HTML view, like using scribd etc. Can anyone help? Thanks, Damien.
Bulk Update - is it possible?
Hi, I want to add some new fields to an existing form and then update these fields for all existing records from a spreadsheet. Is it possible to do this type of Bulk Update somehow? Thanks, Lee
IMPORT and REPLACE
Hi. I think that Zoho Creator is a big step for all in building Great apllications. Bravo ! I would like to use it as a lead repository for my sales people and partners. (Channel Management) I would love to have the possibility to have an IMPORT and REPLACE functionnality This feature will help us 1/ "Export Data" in a spreadsheet, 2/ Mass change and Mass update these existing data, 3/ re-import my data and have them REPLACE the whole "old" record (perhaps we can do this if we provide the Record
Public Access pending
Hi, Good day, I made the request last few days ago, but now still pending, can kindly help me to solve this problem. Thanks, Calvin
Data base limitation
well, first a couple of quistion, what is the data limitation of a table in Zoho creator? how many rows and columns of information can I paste? I have being trying to create a table importing from excel but it crash every time, the excel sheet is 4 columns 10,000 rows, about 1.16mb. thank you, nice software! urena.jose
Questions about users and shared elements
Hi We have a professional plan with some users. When an added user log in a shared app, he has a message like "you are in free edition, we have special offer for you etc" : if he is included in my plan, why those messages ? If he creates its own app, what are the limits : the limits of my plan, or is he considered as a new (and unknown) "free" user ? Just another idea/suggestion about my users : when they go to their home page, they just see the (my) shared app. Is there a way to also display the
Passing a form to a function
I hava a same question; http://help.zoho.com/portal/en/community/topic/passing-a-form-to-a-function if I can use this feature to include returning form object from functions? thank you . on line waiting .
Calculating between two dates
So far i'm able to calculate the days between two dates, but is there a way where it can update the number of sick days the person has instead of it defaulting to the initial 14. For example I put in for Mike that he was sick between 14 and 15 and now he has 12 sick days left, is there a way where if I put that Mike has another 3 sick days it will use the formula from the previous email but instead of 14 it will use 12? This is the formula i have so far but i keep on getting a error message. i
Update field based on selection of lookup from another field
Hi, I am new at Zoho, and I am starting a new database. Right now I have 2 forms: Client and Call Log. The Client form stores all contact info: name, company, address, phone numbers, etc. The Call Log form will track all phone calls, emails and meetings with our contacts stored in the Client form. I have created the relationship between the two forms using a the Client Name field. Now what I want to do is have the Company Name field on the Call Log update automatically based on the selection of
Change in Field Position Failed
I am getting this error when trying to move a column in edit mode of a view. It says to try to refresh or try again later, any clue? IS this related to the slowness right now?
Insert html in multitext
When I click on the 'insert html' option in my form view, it doesn't give me the option to insert html; instead, it acts as if it's opening a window but never does. Any suggestions will be appreciated.
Upload Documents When Not Logged In
Maybe I'm just missing something, but is there a way I can create a form for non-Zoho users to upload documents as part of a form? I'm creating a scholarship application that includes an essay, and it would be much easier to have the option of uploading documents, rather than using a very large text field. Thanks, JP
setting up records that are based on other records?
Hi, please pardon my naivete in advance...I'm not the most fluent person in database-speak, although I do know the very basics. I'm helping my local tennis club set up a small database to track all our members. The complicating bit is, some of our members are "individual" members, and some are members in "group" memberships. For instance, I have an "Adult (18 and over)" membership, as an individual. However, a family of four people can join under a "Family" membership. In that case, the membership
Import Error
I'm getting 100% import failure and have no idea why. I don't see any other error messages. The preview looks fine. The fields are all text. I've tried Excel and CSV. How can I find out what the problem is?
Use of primary and secondary admin email
In Send mail task, it could be useful to be able to choose the email "send FROM" between the primary or the secondary email registered in the admin infos. Example : in temporary events where a specific (temporary) contact email is used to send mails, we have to set this temporary email as "primary"... Then the notifications af all the other app are sent with this "temp" address. Same remark for the forum (but not very important) : choose the email for the notifications. Cyril
Speeding up renedering of images
Hi I've managed to get uploaded jpegs to appear as thumbnails in my list view - thanks for the forum tips to get this done...BUT Even TINY 100px wide thumbnails take forever to load in, and I plan to have a lot of them in a list. I presume there is a way to speed this up a bit? Thanks for your help!
A new be question - Live update of a numeric form field
I would like to be able calculate cost for items and see the tax amount in a field and the total in a field, but I'm not sure hoe to do this, with out using the function field, the going to the view. cost - $100.00 --- I enter tax - 8.25 --- auto calculate total - $108.25 --- auto calculate thanks
how do i get a feild to react to another field
i see the "add item" option that allows me to select an item from a pick list based on an input into that field, but what I'm looking to do the same function, but insert the data into a numerical field. Similar to a spreadsheet. So I could say what the tax and total would be on a purchase for example.
Condition Display in HTML View
Hello, I am trying to create the Delivery Note after adding the values through Forms & HTML View. I am successful in doing so. I am facing some problem with - The HTML View on top is displaying Powered by Zoho Creator Logo, Can i eliminate it? I need to conditionally load values from record in the HTML view. Like if srno is not empty then only the html row will be display.Thanks. Umesh
How can I close automatically, a pop up after clicking on update or cancel?
I lauch a pop up by a custom action, to update record by record, i would like that the pop up closes after I click on upadte or cancel. Thank you.
Creator - Server Slow and Inaccessible
We've been experiencing off and on accessibility to our creator database. It occasionally moves extremely slow and other times won't allow us to access at all. It appeared that the issue was fixed earlier in the day, but it seems that there is still a problem. We were told that the server connected with our account was going down. Please provide an update as to when we can expect this issue to be resolved.
Access Issue
Access has been hit and miss for the last 48 hours, and now it appears to be totally off-line. Is there a Zoho site that displays service status? PLEASE HELP!
Search functionality using existing forms
Sorry as I know this has been asked a lot, just can't seem to find a simple solution. If I've already built a form inside of Zoho that I use for data entry, can I just use that form (or duplicate it as a stateless form) as a search page? So instead of using the form for "data entry", I now simply want users to be able to use one or more of the data fields there and hit a "Search" button at the bottom which takes all the criteria they entered, search the existing database, then take them to one of
Is there a way to have 2 forms be the same
Is there a way to have information entered from Public Application A to show up in a view on Private Application B? ( and be linked to a form with the "same" fields? I am thinking this might be a way to over come the Internet Explorer issues, since Explorer does not accept I frames Is by having a public application with a form A and then the information gets recorded at the private form B Any ideas on this?
Action on all records?
I see how to define a Custom Action that can optionally be invoked on selected records in the live view. What if I want this to happen without any user involvement other than opening the application or a view? So, I want to invoke an action on all records when a Creator application is opened, or possibly when a View is opened in the application. A typical action would be checking a date field in each record against today's date - if today is later than the date field in any record, another field
Public Access Feature Pending for over Five Days
Why after five days are my forms still not permitted to be public. I made the request last Thursday. This is the message I see when I try to get the web embed code for both my forms: To access the form without login, Public Access Feature needs to be enabled in your account. Your request for this feature is pending.
Can I use a form as a filter to send me to a view.
I would like to create a form that a user can select options. When I push submit I would like the fields that were selected to show in a filtered view. What is the best way to approach this? In my case I would like to select a state and city from a drop down and when the user presses submit have the selected fields filter a view.
how can i create a particular Form View
hello zoho I am create a application in which i am use some formula field, now i want to that when user enter data then after the submit button they redirect to the Form View and in this form only shows the formula fields, the view doesn't contain the user input fields. and please suggest me is there is any way by which i can group together many Fields of View : like the Form View contain - USER NAME USER EMAIL ID USER ADDRESS USER PHONE_NO. then these all four fields are grouped in one - like that
some newbie questions.
Hello, Im a newbie coming from dabbledb. Please let me ask some questions. 1. I have a table with many columns (fields). Is it possible to hide/show certain entry fields to certain users? 2. I have a field that import data from another form with more than 800 of entries. How can I multi-select these data without having to select from a long checklist or drop down? A series of search box maybe. next that appears after a search box is filled and submitted? 3. Is there a derive field functionality?
Can I create a button that mass updates a form?
I have a cash flow tracking form that includes aggregated account amounts. Is there a way for me to create a button for this form that pulls and summarizes account amounts from a transaction log form when the button is pushed or when the form is loaded? If help text exists, can you point me to it? Thanks! Ann
mycheckboxlist:ui.add(...) wipes all design-mode options
When my form On Add On Load executes ui.add(...) to add an option to my checkbox list, it wipes all the options I have set on /edit/ i.e. in design mode. Is a fix planned?
jump to a view
hi i have an app with a form where my employees enter their inventory for our store at night. once they are have completed and added/updated it i want to jump to a view where I have some specific instructions on what to do next based on the data they have entered. how would i do such a think?
ZOHO AND NEW GOOGLE APPS INTEGRATION PROBLEM
Hello Since adding a current Zoho Application to our Google Apps account via Google Market Place, our users are having constant problems logging into our application. The error message from IE is below. The message on the browser screen is Loading....Please Wait Message: Invalid procedure call or argument Line: 114 Char: 25 Code: 0 URI: https://accounts.zoho.com/openid?openid.ns=http://specs.openid.net/auth/2.0&openid.mode=id_res&openid.op_endpoint=https://www.google.com/a/e-qas.co.uk/o8/ud?be=o8&openid.response_nonce=2011-04-19T07:23:10Z-yrzL5ITQsWvSA&openid.return_to=https://accounts.zoho.com/openid&openid.assoc_handle=AOQobUcNrBSAvj9OCwpZTfnZ_itQuj4de1qisuk5v-jw7SG9VqnQfYmTPCUbQs1nuHHeN-y6&openid.signed=op_endpoint,claimed_id,identity,return_to,response_nonce,assoc_handle,ns.ext1,ext1.mode,ext1.type.firstname,ext1.value.firstname,ext1.type.email,ext1.value.email,ext1.type.language,ext1.value.language,ext1.type.lastname,ext1.value.lastname&openid.sig=6LUOx7GsvCyljMQGTAWbmbRfKlH8qSGY+OTVhNIrLhE=&openid.identity=http://e-qas.co.uk/openid?id=104986572590317029791&openid.claimed_id=http://e-qas.co.uk/openid?id=104986572590317029791&openid.ns.ext1=http://openid.net/srv/ax/1.0&openid.ext1.mode=fetch_response&openid.ext1.type.firstname=http://axschema.org/namePerson/first&openid.ext1.value.firstname=rick&openid.ext1.type.email=http://axschema.org/contact/email&openid.ext1.value.email=rick-colton@e-qas.co.uk&openid.ext1.type.language=http://axschema.org/pref/language&openid.ext1.value.language=en-GB&openid.ext1.type.lastname=http://axschema.org/namePerson/last&openid.ext1.value.lastname=colton
Next Page