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.
Error in summing and counting a subform data
Hi there I made a form with a subform, where I want to add products names and quantities by adding a line for each new product, I then made another two boxes, where i want to count(product names) and sum (quantities), i did: input.Refer_ncias_com_erro = clientes.count(referencias); input.Quantidade_Total = clientes.sum(qtd); but it doesn´t seem to be counting and summing, can anybody give a hand? thank you in advance
Add tasks to Mail Suite Tasks from creator
Hi, is it possible to build a web form in creator that will add tasks to the Mail Suite Tasks? What i want/ need is a web form from where my clients can add/ request tasks that needs to be done, and i want these tasks automatically to be added to our tasks lists in Mail suite.. Bo
Programmatic access to user groups
Are there plans to allow programmatic access to user groups? Use-case: A form allows a user to select a site location as his primary place of work. The on-submit code places this user in a specific group (in the share module). This is similar to how Sharepoint groups work. Group membership determines what a user can view/edit/access. I suppose this makes most sense of domain-enabled Creator accounts. John M. Whitney
View Data in Google Earth
My data is all based off of addresses. Is there a way to load this into a Google Earth view through Zoho Creator? Ideally, I'd like to be able to select the records I'm interested in, click a button, and have them appear as Placemarks in Google Earth.
Starting a function by clicking on a button / link in an HTML view - is it possible?
Does anyone know if this can be done? Suppose in an HTML view I have a link or a button that says 'execute function x', is there a way to get this to run function x when it is clicked without making it into a link to another HTML page with the function call embedded in it? Thanks, Chris
Update formula field from custom action
I have a form that contains (2) fields called Reg_Users (lookup multi-select) and Reg_User_List (formula). The reason for the formula is due to the View criteria not working correctly. Example: If you were to set the criteria as Reg_Users == zoho.loginuser it will not work correctly, but if you use Reg_User_List (Formula: "" + Reg_Users) it works. My issue is the formula field only updating if you edit/update the form. The application uses custom actions to update the Reg_Users field, which does
Allow invited Users to update their records - without login required!
Is it possible to allow invited users to update information of their records ONLY. What I want to do is send each user an email link that will take them directly to THEIR record without having to do any login. These users will NOT have a ZOHO account and neither should they be asked to create one. The link that I provide should allow them to see/update their records only and nothing else. The idea is for me to create a database of my Users and occasionally ask them to verify their information.
Disabling public Views in Application?
I have a public application for which I have several unshared views; as expected, they do not show up when a public user accesses the public form. However, I'd like to set up a public view (for editing reasons, I can go into this in more detail if necessary) without the view or report showing up as links in the application. See the attached image for an example; in the top illustration I had made a view (in the reports tab) public, causing the Reports tab to appear; in the bottom case I made a
URGENT - CREATOR VALIDATION FIELD with SAFARI, ZOHO response
Hi, I really need strong support on this; I am using soho creator to use its forms in my web site. 1- Zoho form became unstable since the last 2-3 months. Very frequently it changes its response time during loading or after the data submitted. This is not something I experienced by myself but also the people who filled out the form via my web site. The browser status lines say 'Waiting for the server zoho.com' 2- Zoho creator's field validation DOES NOT HAVE A PROBLEM in ALL SAFARI browsers. I am
Usage Limit error
Between my two application I have 581 records. My account allows for 1,000. End users are receiving a usage limit error. I believe this is incorrect. Can someone please look in to this? Thanks Aron
Subforms and scheduler
Hi I have two forms, Form A and Form B. Form A contains the details of a product and Form B as a subform. Form B contains the name and email address of a person and a date. I want to run a scheduled job which 3 weeks after the date on form B emails the person on form B. However, the email must contain the relevant product information from Form A. The problem I have is getting the relevant information from Form A. Additional information: Form B permits duplicate entries ie a person's details may
Input masks?
Can someone tell me how to create an input mask in Creator (such as automatically formatting a phone number with hypens)? If this capability is not already in the product, can someone suggest a way to make this happen upon update or upon add?
New Field Type "GRID" for Zoho Creator
Google Docs Forms are pretty limited in comparison with ZC but I do like this form element:- It collects a lot of data in a small space and means that feedback forms, profiling forms and questionnaires can be built closer to the levels required by my customers. It allows me to define how many columns and their names e.g. change from 1-5 to Disagree, Neutral, Agree in 3 columns and also to define the Row Labels. Each row: Comfort, Reliability & Design should relate to a single column in the view/table.
Little issue with View params zc_SecHeader=false
Hi, When we use zc_SecHeader=false, the paging management is hidden too, even with zc_Paging=true. As a workarround, I set to false all the SecHeader params (add/Search...), but "export Data" and "Total count" params are missing (I didn't find it). Cyril
Next Page