OpenURL with passing multiple values fails in Firefox and Safari
I use a function, initiated through a view's custom action by row, to pass values from a record to a form. The OpenURL command shown below (values have been substituted) works for Internet Explorer and Chrome, but it passes only the first value (main) to the form in Firefox and Safari. Is there another way to formulate this such that it can work for all 4 browser applications? http://creator.zoho.com/ito_mu/final-mu/#Form:Add_Action_Step?TempMain=,value for main>&& TempSystem=<value for system>TempThird=2.1.5-
Getting Error when submitting a Zoho Creator Form
Hello. I'm getting this error when submitting a form. 1 . [t_396699000000776035] Exception occured while setting value in PreparedStatement for the Column [PatID_396699000000800173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_396699000000776035] Exception occured while setting value in PreparedStatement for the Column [PatID_396699000000800173] Check whether the datatype for this column is given as specified in the data-dictionary I've allowed access
Can not delete field
In my form 'Asset' the field 'Assigned_Player' can not be deleted. When I try, I get a message listing various places where the field is supposedly used. But it is not. To make sure, I downloaded the whole app as script and searched for the field name. I found only some views and the field itself. Edit access for support is enabled. Thanks for looking into it. Regards, Filip
Error msg when trying to save code
I am trying to enter the following code into the On Success event of a form: //Populate Sources_Usernames field (used for dynamic views for external users) for each person in input.Source_Player { if (count(frmPlayer[Name == person]) == 1) { recP = frmPlayer [Name == person]; if ((recP.Username != "") && (recP.Username != null)) { if ((sourcesUsernamesStr != "") && (sourcesUsernamesStr != null)) { sourcesUsernamesStr
___How to "set Email Notification" in VIEW when in EDIT form
Hello, When editing a FORM there is under "More Actions" the "set email notification" when data is submitted and an email is sent out automatically. Can that be done in a VIEW when click on Edit and form pops up for data input... when that data is saved can an email automatically be sent out just as is in the "set email notification"? I noticed the Views Configuration has "More Actions" but doesn't show "set email notification". However, on the left panel under "Actions" / "Custom Actions" can
Settings not saving
Hello, I have started on a new revision to one of my applications. "Tool Tracking v2" In form "RFC 5x5" there are two fields that I can not get my desired settings to save. First field: Description: Unable to save the Initial Value, or the Hide this field to others option. Second field: Part Number:Unable to save the Initial Value, or the Hide this field to others option. This feature is working in other forms with no problems. Edit access is already granted. Please Advise. Jason Rapp
Optimizing Creator Forms for Mobile Browsers
Is there a way to optimize forms for mobile browsers? I'm just starting out with Creator and it seems like a brilliant product. I've got a few basic forms that I would like to start using to capture data in the field. I can open them up and use them on my iphone but I have to do a lot of zooming and scrolling. Is there a way to make my forms "recognize" if I am mobile or on a PC and format the manner in which it displays accordingly? Hope this questions makes sense. Thanks! JG
Lookup based on previous selection
I want to create a field that is a Lookup from a different table, but I want to set the criteria dynamically based on a previous selection of the user: Example: Table Clients has String Company_name, String Address Table Contacts has String Full_name, Company:=Lookup from Clients.Company_name I want to create a third form that will contain a Lookup from Clients and a lookup for Contacts After selecting a Client and going to selecting a Contact, only contact from the same company as the client will
Unable to delete a field
Hello, In my SDI tool Parameter Tracking application there is a field named "Delete Me" in the Data Entry form that I can NOT delete. I keep receiving and error telling me the operation failed and to try later or refresh adn try again i have done this with no success. Please help fix this issue. Access has already been granted to support for this application. Jason Rapp
How to find No of Fields or Columns available in a Form and refer in views
Do you have any working examples on getFieldNames formdata function
BUGS (and design concerns) in new feature: Add new entry for lookup form
I love the new feature, but it has a few issues: 1. Not a bug, but a design issue, the label should display in the same style (font size, etc) as the text it accompanies: 2. Bug: The 'Plus' symbol does not appear as advertised. Below is how dev says it is supposed to look, but as seen above, there is no Plus symbol (Firefox latest)... 3. Bug: Changes made to the label name are not displayed: resulting in: 4. Adding new list elements results in very poor formatting of results (see below): 5.
The hard-to-see CURSOR in Free Flow Editor
I remember when you couldn't see the highlighted text in the Free-Flow editor because the highlight color was too dim... but dev fixed it eventually and now you can see highlighted text. But not equally made visible is the insertion cursor in the free-flow editor. I know I'm not alone in this. I often simply cannot visually locate the insertion cursor... it is TOO DIM. How many times an hour does one move the cursor around with the arrow keys on the keyboard and try to find where the cursor went?...
On Focus / On Blur for multiple inputs
On a form, I want to get a div to change background color when a user is in either the password or password confirm input fields. I can get it to work individually, but the problem is that I need to be able to capture the active element and then check if it's either password or password confirm. If either is active, I can use the .css method to set the background color or if both are not active, I can reset the background color. I'm struggling with figuring out what element is active. Any ideas?
Add items from views to another form
I've created an example app to show my question: you can find it here I have two form: 1. Inventory : where are stored all items 2. Supply Ordered : where are stored all orders made for new supply What I'm trying to obtain is simple: once a supply which is in the Supply Ordered form is delivered I wish to add its quantity directly into the Invetory without the need to delete it from Supply Ordered View and then insert manually into the Supply Ordered View. I've tried with a Add Record action on the
Upload field displays, accepts attachment, BUT...
A colleague shared his Zoho computer lab reservation system with me - which allows teachers to sign themselves up for the computer lab on a certain day/classperiod. It also requires them to attach lesson plans/seating charts. He also had a modified form within this application which allowed teachers to sign up for mobile equipment. It appears that the lesson plan / seating chart fields were hidden - but when the user tries to make a reservation, they are given and error message since they didn't
help regarding Lookup field..
hello guys, To start off, i have no coding experience =) i have form Shipping and form Freight form Shipping has field Invoice# and Total Amount When in form Freight this is the scenario that i want. 1.Lookup field called Invoice to retrieve drop down lists of Invoice# from shipping ---accomplished 2.field called Amount to retrieve the CORRECT Total Amount corresponding to the said Invoice, no dropdowns. -- fail Thanks in advance i hope someone helps me out =)
How to add seperate record for each and every selected value in multi select field in form
Can some body help me to solve the below problem: How to add seperate record for each and every selected value in multi select field in form
Bug: scroll arrow has disappeared in Free-Flow Field Actions box in one Form
While working on the script for one of my forms, the scroll arrow in the Field Actions box in the Free Flow editor has ceased to appear, though it does appear alright in other forms. I've restarted browsers (tried 3 different browsers, too) -- all the same result -- no scroll arrow anymore in this particular form. See screen grab here: The form is named "Contacts". I've shared with Support. Please advise asap. Thanks. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Dropdown Listbox Size is too narrow
I am having trouble witih some listboxes that are too narrow and not allowing me to see the label in full. How can the size be changed to allow each entry to be seen? Thanks
Please explain why saving ZC scripts take so long
No doubt every Zoho Creator developer has wondered why it takes so long for a seemingly small script to be saved/updated from the editor view. So, it's obvious that the script gets uploaded, it's syntax is checked, and the script is compiled, or whatever processing happens on the server side to make it ready to use. Since saving script updates is something a developer does countless times a day, this slow-down in the workflow is more than just a little troubling. If you would, Zoho Creator support,
Zoho Calendar and ICAL feed
I have a ZOHO app with the following items. Single Line Called TITLE, a multiLine called DETAILS, a Drop Down called ALLDAY and 2 date-times called STARTS and ENDS. I want to change it over to an ical and import it into ZOHO calendar. For some reason when I go to my calendar and click subscribe to and enter a url UNDEFINED pops up in the corner and nothing loads. Any ideas why this would happen. Here is the link I am using https://creatorexport.zoho.com/tulsadirect/mycal/ical/CALDATA_View/5nvZsm4GVqKJw2uBSvxArBvnCdya4XTJKEMQbUrv70g5HeP9M67QYCW2Wf6a2zTFwmvVF09ZBrDeMGUM6BXAO3VFBUQw7bG6dE9x/DTSTART=STARTS&DTEND=ENDS&SUMMARY=TITLE&DESCRIPTION=DETAILS&ZC_FULL_DAY_EVENT_VAR=ALLDAY
Please clarify issues re: PRECREATOR server
I'm wanting to check out the PRECREATOR dev server, but have a quick question or two before doing so. 1. At this link (https://accounts.zoho.com/ui/unauth/authorize.jsp) there is a disclaimer that on the surface seems concerning, see the red arrow below.... Question: What should I understand about this statement? Is PRECREATOR not under the responsibility of Zoho? Why is Zoho distancing itself from PRECREATOR in this statement? Does Zoho truly have *no affiliation* with PRECREATOR??? How
Another Free Flow editor BUG: Firefox suddenly displaying ghost text in Free Flow editor
Now, suddenly, Firefox is displaying ghost text in Free Flow editor, making it impossible to edit the script. It never happened before, including just minutes before, but now suddenly it does, even after rebooting, etc. etc. (see below) I must ask: What is going on at Zoho Creator dev? Suddenly this morning I'm blocked from editing scripts from both this bug and from the bug I posted only moments ago about the scroll arrow disappearing in the Free Flow editor. And this is only one day in a long
Check if all choices are selected in a field
How do I check with Deluge if all choices of a multi select field have been selected? Thanks, Filip
Is there a way to create a new view upon submission of data field using the same table?
I am new here, I have been a computer tech for years but have not done much programming since DOS and GWBASIC. I working a new Zoho Project, my actual first attempt at this. What I have is a form to input some filed date into a table. I have one field that will generally be left blank, but if the field equals anything other than null, I want to create a new view for the same table. However, I want the view filtered to only show data from the table that correlates to another field that has a drop
Grid view embedding
Hi, I have a private grid view which I want to embed into another website to share with others. However I do not see the option for accessing the view without login when I try to get the code to embed. I have enabled permissions for edit and bulk edit for other users for this view Similarly, when I try to access the permalink for this grid view - I do not see the option for accessing the view via the permalink without login. If I change the grid view to a list view, I see the options. Is there a
Browser Detection
I know that ZOHO Creator supports the Firefox browser. Indeed I have never had any issues using FF with ZC and it's what I use all the time. I have also seen that Internet Explorer 8 does not have any (to my knowledge) issues with ZC. Now on to my issue: Many of my users in education, and therefor typically use Apple computers. The Safari browser is not compatible with ZC. Recently at one of my workshops, a Mac user was having all sorts of problems with ZC forms not rending properly and/or experiencing
Create a new Creator application from a Zoho Sheet
Is it possible to create a new Creator application from a Zoho Sheet - without downloading the sheet and then uploading it again? It seems odd that I can create a new application from an Excel workbook on my local PC but can't find a way to do the same thing from a Zoho Sheet that is already on the Zoho server. Thanks in anticipation, Peter
The record ID as a view criteria returns the error "We are unable to fetch this data, sorry!"
I send the ID of a record to an html view (recID). In this html view I have an embedded list view (div embedding) that uses the passed parameter as a criteria (...=false&zc_RecSelect=true&ID=input.recID). This embedded list view returns the error message: We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com If I use other fields of this form as criteria it works (but I need to use the ID). The list view displays a total of 27 columns,
Center column data in view?
Is there any way to center the data in each column of a view? It's hard to read when some of it is left-justified, and some of it is right-justified. Thanks.
Trouble importing spreadsheet
I'm trying to add a new form to an existing app using the import XLS button. I copy the information from the spreadsheet and paste it in the box (17 columns by 33 rows). When I click Done I get a Please Wait and the lower portion of the screen goes blank but no form is created. I tried this on two different computers. Both are using Firefox 3.5. Herb Wexler www.preventingmediocrity.com
Parameters for HTML Views
I'd like to propose the ability to also add integer parameters to an html view. In attempting to pass ID number, I'm forced to convert it to a string, pass that string via url to the view, and then convert the string back into a number. I see no technical issues passing numbers via url strings, do you? Seems like a real runaround. When adding parameters, one expects some options to specif what variable type it is. John M. Whitney
Encode Buttons on HTML View
What I'm trying to do is add some buttons to and HTML view that when clicked refresh the view to display new data. The application has a number of events with dates. By clicking one of two buttons, events for today or the next two weeks are displayed. John M. Whitney
Comparing current date/time to current date doesn't work
Here's the code: bool test.datetest() { start_date = zoho.currentdate; end_date = zoho.currentdate; current_date_time = zoho.currenttime; test = false; if (current_date_time >= start_date && current_date_time <= end_date) { test = true; } return test; }I thought this should return true since the current_date_time has a date that is equal to the start_date and end_date, but instead it returns false. Why doesn't this return true? If I change the end_date to be one
Column data based on start date
I have data that is start date specific for several types of products. For instance, I have a customer that will begin buying chairs in Dec. another buying chairs starting in January but also buying desks starting in November. I want to create columns for the next 3 years, that look at the start date, calculate the revenue from the sales of the item, and add it to that column. Each sales activity is a separate row and I would just like to carry that information out to additional columns in the
Variable in Picklist Criteria
Hello, I need help. I have a form X with fields OPIDX and Name. In another form Y, I want the user to input a value (OPIDY) which will seek to form X in a field / column specific (OPID given by the value provided by the user in the form Y), to then mount a dropdown. Example: Lookup_1 ( displayname = "Lookup 1" type = picklist values = FormX [input.OPIDY].name width = 206px ) where, "OPIDY" would be a variable input by the user. However, it is not accepted.
Embedded form does not load
I have embedded a form in an html view with a <div> tag like this: <div elName='zc-component' formLinkName='myForm' params='zc_Header=false&recID=473791000001064107'>Loading Form...</div>But only the text "Loading Form..." appears. Otherwise nothing happens. The recID was a entered by script before. I hardcoded it to make sure that was not the problem. I tried it with different form. Same there. The html view in which the form is embedded is opened within a Zoho dialog (href with zc_LoadIn=dialog).
Embedded Website View Will Not Show All Fields Within A Record
We are trying to create a view that shows a select number of fields from a record that we can embed within a web page. We want the viewer to use the search tools to locate a single or specific group of records and when they find one of interest, they would click on the view link and see all of the fields associated with that record. Right now, when we create the View with only a few of fields showing, the view link for a more detailed look only shows the same sort list of fields. Can we create a
Link preview in creator
Hi there Is it possible to automatically create a preview image of a website link? Either through the URL-field or through the image field? Thanks Thomas
How to show views in a form?
I have one question to all. I am new in this - and made a form that is submited to a posturl to a new form - on this new form I want to show a some of the date collected in the first form. Is that possible? Ex. Form1: name, address. ....... Form2: show -> name, address........ in a grit/table and have them verify the input? Please help
Next Page