Sign in and Sign out
hello im new here, would like to ask a question i have a website wanted to create my sign in & sign out for visitor or members what is the code?
ZOHO Creator extremely slow
In the last hour creator has almost ground to a halt. What's the problem?
how can I use the Rich Text Format to show a picture
except for link,i want to show a picture and some words,how can i do? thanks
Zoho Creator
I know I've asked before, but I'm really perplexed and swamped. Maybe I'm too dumb to figure this out? Sheesh. I need to do date calculations in Zoho Creator. Can someone help with this? Here are the various calculations I need to do. I'm a volunteer book review editor, and need to keep track of books I've assigned to reviewers. I need to log in the date a book is received by a reviewer, add 30 days to it, and generate a date the review is received. I also need to take today's date and subtract
Sharing an App that uses the Shared user's form.
BACKGROUND: I'm considering upgrading to professional express in order to market an app. The scheme is to sell the right to have the app shared by the buyer for a specific length of time. The problem is that if I have 1000 users who generate 1000 records I will quickly have a 1,000,000 record count and at $5/mon/1000 records a $5000/mon ongoing Zoho record charge which would make the scheme un-profitable. One solution I have imagined is to share my app, but then have the user/client install a second
Entries Missing
I have a database where one of the fields in the form allows you to select which person the entry should be associated with (we have 6 users that share a username, so this allows someone to sort the list view to just people that are associated with them). However, all of the entries associated with one person suddenly disappeared. When that person tries to add a new entry it will not show up in the list view either? Any ideas about what happened and how to fix it?
Scheduler Goes Black
I am new to scheduling, however, I walked through the wizard to setup an email to fire off one of the views I created. When I click on the "Exceute Now" button the screen goes black and the email does not fire off. I am not sure where to go from here. I have allowed access to support in my application.
Linking to a document (pdf)
Hello, How could I create a link to a PDF file on my HTML view? My app lets the user upload a drawing for each drawing number (via. Google Docs or local upload) but how can I create a link from my HTML view to the drawing so they can view it? The Drawing is in PDF format and ideally would be "downloaded" or "opened" via the PC or tablet software. I'm not really sure what my options are so if someone could point me in the right direction that would be great! Many thanks in advance Ben
How to show Decision Box as checkbox in View
I have a form that has multiple decision boxes. I can't get it to show as check boxes in my view, only true/false. In a test view newly created it works just fine. But not with my original data. How do I find the data/ code to change?
total of a sub-form in a form
Hi i´m trying to do this and can´t seem to figure out how it´s done the "Total = 1379", how can my form give me this total regarding the values come from the sub-form? https://help.creator.zoho.com/Creating-SubForms.html#Deluge_Script Thank you.
Pop up after on click
Dear Sir / Madam I have created a form, where user having facilating of deleting a record, But I want before deleting record, user must get an alert or pup up box which shows "Are you really want to delete ?" On user confirmation only record can delete. i.e I need a double confirmation from user before record permanently delete. Could some body tell me how I use this functionallty on "On Click" Option.
Issue with Client's Application
I am assisting user viviennepbe with her pbe-ergonomic-evaluation-form. The form Ergonomic_Evaluation is stateless, but experiences this error for some submit types Error details: Error occured while executing on click script. Error occured. Also, I cannot delete records in Chrome, only IE 9. I think there's an issue on your side with this account. Enabled support edit access John M. Whitney
Can't ex[prt all data
I cannot EXPORT data from a database that has in excess of 30,000 records, yet I can in one that only has a few hundred. If there is a size limitation, how do I break apart the large database ? Is this the problem ? I have tried using both Firefox and IE 9, and get the same results each time, only the column headings and one record will be in the XLS backup.
New User - Advice Needed
Hi there. I'm a brand new user to ZOHO and I'm excited by what I have read. I wanted to see if I could post my question for some input from all of the experts here to make sure I'm going in the right direction prior to getting too lost in the details. Here's the scenario. I manage a number of websites for our local high school. All volunteer work. Example is http://www.MarcusDrillTeam.com. I work (limited) with SQL databases where we collect data through forms. I have even posted to the SQL DBs
HTML View with Iframe and a form record opened for editing
Hi Need a HTML view which works as follows Top half has an iframe which contains a view I decided on an iframe for 2 reasons 1) The view is very wide with an iframe you can scroll left / right 2) below the iframe i want a from which needs to stay in a fixed position, with the iframe above i think this can be achieved Ok... now where i am stuck Bottom half of the screen i want a form opened with the record i want to edit So far i have tried to 1) Embed my form but that only seems to allow for a form
Alert Or Popup message after "On Clik" Submission
Dear Sir / Madam I have created a form, where user having facilating of deleting a record, But I want before deleting record, user must get an alert or pup up box which shows "Are you really want to delete ?" On user confirmation only record can delete. i.e I need a double confirmation from user before record permanently delete. Could some body tell me how I use this functionallty on "On Click" Option
Re Add record to Creator from web html page through creator api
Hi Yoge I try to many times for add record to Creator from a web html page by Creator api,but failed to achieve,my html page code as bellow (in accordance with the help of Zoho), Steps, the first code saved as a the test.html and then use the browser to open <form method="POST" action="http://creator.zoho.com/api/xml/usana/apitest/add/ "> <input type="text" name="name" value=" Column Value "> <input type="text" name="age" value=" Column Value "> <input type="hidden" name ="apikey" id="apikey" value="3d8a1cea7b8efc6141c4f0233a155eed">
Synchronize Zoho Creator and Zoho CRM data
What is the best way to synchronize data between Creator and CRM ? Here's my plan, but I'm open to something better. Export data from CRM and import in Creator Add a script in Creator (on add/on edit) to update data in CRM Run a daily schedule in Creator to bring back updated data from CRM in Creator Thanks for your input Pascal Veilleux
Passing an html parameter to an embedded form
I have an embedded form to which I want to pass a html parameter. A page "test.html" includes <iframe height='500px' width='100%' name='zoho-Student_Web' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/<user>/<app>/form-embed/Student_Web/Arg1=xxx'</iframe> I would like to call test.html&Arg=<string> and pass the value of Arg to the embedded form. In other words substituting xxx with the dynamic value passed to the html page. I've tried all sorts of options
How to tell if Print button pressed
I have an HTML form and have enabled the Print and PDF buttons on it. When someone chooses print, I want to set a field with the date that the form was printed. How do I capture the event when someone presses the button? Thanks, Michele
Subform look&field
Hello, I've created a subform where I have textarea fields in all of the rows. I've defined the width and height of that fields but when the form is loaded the look&feel (width and height) is identical to all the fields. It seems that subform feature doesn't allow to determine look&feel. Please, could you tell me what I have to do to set up the width and heigh of the subform fields? Thanks, Fidel Martín
Importing/uploading data from Zoho Recruit into Zoho Creator
Just need to know if this is possible??? If so can you forward me a link of how and where I can do this. Many thanks
Style the form field label and Passing data between forms
Display name or form field label Can I apply a style on the form label programmatically? Passing data between forms Normally values can be passed through URLs, is there a way to pass it by POST to another form?
And new field upon user input
Hi, We've been using Zoho Creator for 4 months now and love it. In addition to tracking data for our projects in Zoho we use a simple word doc with an embedded table to record activity. The data here includes user, date, time, activity description, expenses incurred, mileage incurred, and time incurred. With each new entry a blank row is formed for the next activity. I would like to quit using the word doc and simply do all of this within our application. Can anyone suggest ideas for creating
Experts i need your Opinion
Hello fellow zoho creator users, I need your opinion of this app Here I have to create a 3 view Admin Teachers Student How can i connect the teacher and the student view so they can communicate each other? Any suggestions?
Suggestion: Built-in Function for URL Shortening
After reading Gaev's post https://help.zoho.com/portal/en/community/topic/forms-working-since-last-september-now-causing-errors I thought of a simple solution to this problem that also would benefit other applications: Have a built-in function that performs url shortening. " There are several reasons to use URL shortening. The free hosting space provided by access Internet Service Providers for its customers may generate an aesthetically unpleasing address. Some web developers on mainstream sites
How to limit picklist in a Subform record when editing
The following code restricts picklist entries while adding a new record to a Subform, but when editing a record in a subform, how do I restrict picklist entries to the relevant ones? Denominations ( displayname = "12. Denominations Represented (Dénominations)" type = grid values = Denomination_Sub.ID width = 200px on add row { row.Country = input.Country; denomlist = Denominations [Country == input.Country] sort
Embedding Soundcloud Widgets
Hi Forum, I have created a database for our radio network of voice over talent. Was curious how to embed widget code from sound cloud. Right now I am using URL - but this has a funny effect of the code. Any help would be awesome. Please see the working side via the following link (sort on station 2DU) to see the two I have currently coded. http://www.zoofm.net.au/vodb/index.htm Thanks in advance for your help. Bret Murray
Re-arrange Application Order
Under Personal Applications is there anyway to change the order of your apps? I have 5 apps and of course the one I use the most is 2nd to last but I would like to move it so that it's the first application. Thank you, Valerie
Translating Google Apps UrlFetchApp.fetch to zoho creator
I am struggling with the syntax of converting the following piece of code taken from google apps into Zoho var resp = UrlFetchApp.fetch('http://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway', {'Content-Type':'text/xml', 'method':'post', 'payload':xml}); where xml is a variable containing xml information. Can someone please help with the conversion. Thanks, Mike
Experiencing very slow response times
Is anyone else experiencing slow response today?
Best way to do "threaded" comments?
I don't mean true threading (ability to reply to replies, etc.), but has anyone found a good way to duplicate the kind of simple Add Note functionality found in something like Zoho Project? Here's how it works: 1. When you go to a task there's an Add Note box. 2. You type your note and click the Add Note button. 3. Upon submit the page refreshes showing your note, which can't be edited/deletedI've by anyone but you. The note is followed with "by [your_name] on [the_date]" 4. Underneath the submitted
Forms working since last September now causing errors ...
Has the ZOHO Creator Team made any changes to the platform in the last few days ? I ask because this page (https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html) does not even report the changes made a few weeks ago (that caused problems for my client as reported at https://help.zoho.com/portal/en/community/topic/urgent-client-experiencing-problem-as-of-this-morning) ... now, another one of my clients ran into a different problem with Forms that have been working since last September/October.
Zoho Creator - Sites - Registered Public Access/CMS Integration
Good Evening I'm looking at Zoho Creator but would like to allow external users to register and provide access to elements of the application. Is this possible within Zoho Creator? if not is it possible to integrate creator with and an external CMS? Any advice or examples would be great. Thanks Ben
all my clients cannot access my data base after a mixed up with a credit card
ll my clients cannot access my data base after a mixed up with a credit card has deleted all access to my clients without any warning of a failed credit card inactive accounts were placed not happy can someone help
Question about Check Box / Multi Select
I have a checkbox with, for sake of example, the following information: Apple Pear Orange And for each person, I want to track which fruit they like... so: Johnny: Apple Bobby: Apple, Orange Susie: Apple, Pear ... and then I'm trying to import this data into Zoho's DB's to produce a report (no problem doing this), but then show a pie chart of how many persons like Apples, Oranges, and Pears... Therefore with this data, I would have a pie chart of 3 counts for Apple, 1 for Orange, and 1 for Pear.
Trial Version: no data after importing .mdb
I imported an Access Database into my trial account, but I can't seem to find any data, only forms. Does data not import in the trail version? Thanks so much, Buddy
Populate one form from a database when a custom action button is clicked
I am creating a database for a small school library. I have created a custom action button for each record called "checkout". When the button is clicked the CheckOut Form pops up in a new window but it is empty. I would like the form to pop-up with the information of the record from which the button was clicked. For Example: If a teacher wants to check out the Book "The Red Pyramid" she can search the list using multiple criteria. Once the book is found she can click on the "Check Out" button.
Cleaning Up Zoho Creator
Hi, I appreciate Zoho taking steps to clean-up needless excess Zoho re-branding in Creator. It gives a more professional and cleaner appeal! Thank you
adding new view and locking old one
How can I add a new View based on my existing Form, and simultaneously lock the old View ? I would like to continue to use my Form but put a records into the new View and simultaneously not deleting the old View.
Next Page