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">
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
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
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
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
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
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
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
White line in header
Most (not all) of my html pages with embedded views show a white horizontal line between the view header and the column headers (see pic). That looks ugly. Please assist. Here is the div tag I used for embedding (I don't see how this one is different from the views which look fine though): <div elName='zc-component' viewLinkName='Players_embedded' params='zc_Search=true&zc_AddRec=true&zc_DelRec=true&zc_Header=true&zc_Footer=false&zc_DuplRec=false&zc_EditRec=true&zc_EditBulkRec=false&zc_Summary=false&zc_RecSelect=true'>Loading
Should Developer Role in Creator give you ability to "Edit this Application"
I would like someone besides me, the Admin, to be able to edit a form in my Zoho Creator. I thought making someone a "Developer" would do that? But when they log in they don't see anywhere to Edit the application? Thank you, Andrea
I need some help
I'm a realy noob in zoho creator, i need to set up my registration page that will connect to log in page so no duplicate information and also username and password should match the data that is enter in the registration, I having lots of error, can you help me? I really dont know how to start, Hope you can help me. Richard
Test if form is loaded in "on add"-, "on edit"-, or "on delete"-mode?
Hi! I have an "on user input" field action for a dropdown field that I only want executed if the form is loaded in "On Add"-mode. Can I somehow test for this in an if-statement in the script? Thanks, Espen
toList() can it build a list of inter type
Understand that toList() is implicitly a string function In my case the toList() is for type integers Any way to tell toList() that the list to create is of type INT ?
NO Admin or CSR answer may question, almost 3 days ( i will repost it here)
I need help regarding my log in page, I need to set up my log in I need to match the username and password so it will execute in and transfer to next page Then if is not match i will stay on that page. Please help me
Link to edit a field in a record- Can this be done??
Hi All, Just wanted to see if this is possible before I try developing it. I have a event where I would like to email each contact (whose details I have in a contact form) containing a link that on clicking would confirm their attendence. I suppose it would very similar to an unsubscribe link in a email you get from an online trader. If this is not possible, could the link direct them to a html view where they would pass their email address/name as a variable and clicking a button would update
Views not showing custom actions in view header
Hello, I've tested this and it is working in -precreator.zoho.com-, but not in standard creator.zoho.com. I can create custom actions and show them per item properly, but when I tell them to display in the view header, they do not display (even on a mouseover). Very nice work on views at precreator.zoho.com by the way :) Best, Andrew
Tracking referrals from leads or contacts
Would it be possible in Creator or another way to add the ability to capture multiple referrals from existing leads or contacts that would be reportable or trackable?
Having Data already filled out based on the link of the Form
Is is possible to have someone click on a link to a form, and based on factors, have some of those items already be filled out?
Stuck on updating record from a stateless form
I've made some progress on creating an effective comment system, but I'm stuck on something that I would have thought was simple. My scenario: 1. I have a view for a Project Request Form with a custom action/button that calls a stateless form. [this is working] 2. The stateless form has a Notes field, which it populates with the Notes field from the Project Request Form with the matching ID. [this is working] 3. I want the user to be able to edit the Notes field in the stateless form, which updates
Passing parameters 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
Can registered users update their information with a password?
Hi people, I have a question which I couldn't find the answer in the support forums. I have developed an online database for volunteers. www.evsturkey.com The volunteers are filling the form and make their registeration. Now I want to create another FORM for updating the records. I found out to update a data in a from from another from with "STATELESS FORM". But what I want to do is something further: When the volunteers make their registaration I want them to define a password in the "Password Field".
Course Registration View Help
We have built an application which is used for course registration by our employees. The issue seems very simple, but has been difficult to resolve. The following link is of a simple application that Zoho Support was helping me with, but wasn't completed. The issues with the app is detailed below: I would prefer the when a student clicks register it automatically will register them. Not open a form and they select the course. It does not appear to behave correctly. Example: I registered for Zoho
Pre-filter Reports based on signed-in user's ZOHO ID
When a report is loaded, is it possible to pre-filter the data graphed/tabulated based on the user's ZOHO ID? In other words, hide some of the data as the report is loaded? Use-case: Managers need to view local inventory at their site, but should not see the complete inventory in the company as this is a security policy voilation. Thanks, John M. Whitney
Criteria in zoho.reports.updatedata ??
hi i use the zoho.reports.updatedata deluge task from zoho creator. i would lik to use a criteria depending of an input field value. i dont find the good way to write this criteria wich must be a string.... trans1=map(); trans1.put("Agence",input.Agence); trans1.put("AFFECTATION ANALYTIQUE",input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE",input.LIBELLE); trans1.put("AFF-CS-PS",input.AFF_CS_PS); a="AFFECTATION ANALYTIQUE=" + input.AFFECTATION_ANALYTIQUE; mapResponse = zoho.reports.updatedata("BASE","TABLE",trans1,a);
Delete records does not work properly for decision boxes
Hello, I've created a test application to expose this issue, which I have shared for tech support (it is named "delete-bug"). The issue is the following: I create a decision box for my application, and submit it as FALSE into the database. I then run a script to delete the decision box, but it only deletes data if the decision box was marked TRUE. The code is as follows: delete from decision_box_form[ Box1 ]; The only way to get this to work is to compose: delete from decision_box_form[ Box1 == false
"zc_Header=false" doesn't work in view-embed (since view enhancements)
Hi, Style based URLs: "zc_Header=false" doesn't work in embeded views since view enhancements. Regards, Leszek
Field does not update/update properly on "on input"? / Adding values of selected entries in real time
Hello, It's probably something small that I'm missing here, but I'm trying to get your example application, "calculate-multi-select-price" to update with the price of the items selected in real time. The application is shared with development and is entitled "Copy of Calculate Multi Select Price" (http://creator.zoho.com/andrewkahn.me/copy-of-calculate-multi-select-price) I placed the code from the on success script (which does work properly for On Success only) into On Input: val = 0.0; for each
How to create a filter in a database?
Hello, Exactly, that I would like to do is to create a filter: The user will have to choose between different option of language: English, Spanish, French, Deutsh .... In fonction of the answer of the questions the user will be redirected in a different dataform. In the same time, when the user create some filter in the product finder price, type, brand, features.... he could find the correct device. How can we do that? Thanks very much for your help,
Purpose of Function and Scheduler in Application Home Section
Sorry maybe i missed the announcement, or cant seem to find it What is the purpose and difference of the Function and Scheduler in the Application Home Section as opposed to what i have been using Functions and Scheduler for individual apps ? I have an idea but don't want to waste time writing stuff in the wrong section
Need help for convert string to date or number in HTML view
Hi Why can't convert a string variable to date or number in HTML view by using toDate() or toLong() built-in function? I try to so many times it's can't save the script like bellow: Waiting your help and thanks Stanley
How to make notes appear in the email sent when the user clicks submit?
I wrote an html code and added it to the form with the field notes and I want it to appear with the rest of the information that is send to me when the user clicks submit. Thank you for your help! :)
Could use some help with challenging script
Hi, I'm at a loss. It seems I'm terrible at math and not much better at scripting Here's my issue: I'm developing matching software for a speed dating like event. There will be roughly 20 people from 2 different categories ranking each other after a series of first round "dates". Think of them as 10 males and 10 females. After the first round, each person will submit their top 5 choices and we will come up with their 3 best matches for the 2nd round of dates based on comparing everyone's top choices.
zoho.currentdate.subMethod(1) returning wrong value
current date: 03/30/2012 <%=zoho.currentdate.subMonth(1)%> returns 03/01/2012
Custom Action on phone
Is there a way to use a custom action on a view on a phone (Android or Iphone). Currently the view is displayed in Summary style which does not show my Custom Action button. Herb Wexler
Using zc_LoadIn=dialog to edit and add records from an HTML view
I have an html view and would like to mimic the Edit and Add record found in a standard list view. I can get Edit to work, but the required zc_NextUrl and openUrl("#Script:dialog.close", "same window") in the form definition are clunky at best. I can not get Add record to function, however. The add record form opens in the popup window, but the NextUrl does not cause a refresh and the #Script:dialog.close in OnAdd...OnSuccess does not close the popup. I will respectfully disagree with Gaev (About
Next Page