Need to limit field criteria on a form by another field on the same form
In the criteria section of the dependant field, how to I refer to another field in the same form? If you need more info... Form name "Purchase_Order" Field 1 "Vendor_Name" Field 2 "Vendor_Account_Number" Field 2 is a look-up field from table Vendor_Account_Number which in turn has a field "Vendor_Name" I want to set the criteria for Fields 2 to only include records that the Vendor_Name == Vendor_Name on the current form Thanks
.replaceFirst() Function is Broken !!!
@ZOHO Creator Team: Looks like the .replaceFirst built in function is broken ... when I try to Save (previously working) script sections that deploy this function ... even without making any changes ... I now get an error message ... here is an example script command ... input.Result_of_Action = (input.Original).replaceFirst(rFrom,rTo,true);... and here is the error message when I try to Save the code ... Encountered "," at line 3, column 65. Was expecting one of: ")" ... "*" ... "/" ... "%" ...
Long Relational Forms
I have created a relational database, and now am putting up forms on my website to collect the information (application). The problem is that I collect company information in one form, then I send them to another form where I hope to allow them to make as many contact entries for their company as necessary. I suppose the best way is to add a button at the bottom. So after the usual submit (which may be changed to submit final contact) and reset, there should a button that says add another contact.
Fetch from same form, Update two records from same form
I am having a problem updating two separate records as a result of a change in my incident report form. When you select the equipment that has faulted, and has been replaced, the faulted equipments status changes to "Faulty", and what I want, is when you select the replacement equipment, that it's status changes from "Backup" to "Active". Unfortunately if I put the bold code in below, I get a 'null' response on update. if((input.Condition == "Faulty & replaced with spare")) { EquipmentStatus
New data not appearing in Reports or Charts!
I'm testing the Reports and Charts feature and find it potentially very useful except... To simplify testing, I've created a "Record Finder" view to gather the needed fields from my Client intake form. I then created several reports and charts built on this view. On the date I create the report or chart, everything looks great but..... As new data is added in the following days the new data appears in the "Record Finder" view but not in any of the charts or reports. Here's a link to the Record
Export to Excel: numbers and dates are coming in as text
When I export a table's contents and choose the Excel spreadsheet option, upon opening the document Excel gives me that little green diamond and alert box that says that "numeric data is stored as text" (same for dates). I have to select that column and tell Excel to convert it to a number before I can do anything useful. This is not a show-stopper, though it is annoying and I would love to see it fixed. Cheers, Kevin
Importing data does nothing
I've tried to copy and paste, and import a csv file into a table, but when I hit "import" nothing is imported and no error messages are displayed. Literally nothing happens. I've tried in both internet explorer and firefox. Thanks
Import in Creator is not working.
The import function in creator is not working. Nothing happens.
Current Date failing sometimes
Hi, Only today I have a field with current.date script that failed in this records: 92720000000443743 92720000000443477 The system return null value. About other 20 data the script run regular. There are other field with formula that, obvious, return in the same value null when current.data not run. Help me to know what happen. Application: Consulado-geral-do-brasil Form: Matricula Consular Field: Expedida em e Validade até Thanks Mic
How do I restrict Edit Parameters on certain form fields?
Hi, I have created a view, but on certain fields I want view access only and no edit access/permissions. How do I do this? Thanks Bram
How do I change View Types when embedded in HTML???
Hi I need to be able to have the option for my users to change VIEW types in my HTML embedded code. From List or Grid View. How do I do this? If it is not possible, My 'UPLOAD files' fields are not showing up in my Grid view, any work arounds for this? I need my users to be able to change views from the website and upload files based on either LIST or GRID view Thanks Bram
Duplicated Auto-increment number from zoho system
Hi, this records below have experienced a duplicated autoincrement number. Probably two member staff have added data at the same time (but with different profile). 92720000000462187 92720000000462179 How may prevent this? The auto-increment number it's a company identity code and duplicates may cause serious legals problems. Regards Thanks Mic
Why is a parameter added to an HTML view always a string?
I am new to zoho, please bear with me! I added a parameter to an HTML view named PurchaseOrderID I only want the view to display one record, so I am planning to pass the parameter of the record that will be used as criteria. When I go to fetch the record, and enter the criteria as x = Purchase_Order [ ID == PurchaseOrderID]; it tells me "The Left expression is of type BIGINT and the right expression is of type STRING And the operator == is not valid here" Is this because the parameter
Sort by ascending integers
Subject: sorting numerically I'm constructing a database in which I want to sort a column by integers (1, 2, 3, etc.). Using 01, 02, 03, etc., lets me sort correctly, either ascending or descending order. Everything was fine until the numbers reached 100 and beyond. What do I need to do in order to sort in numerical order above 100?
Can I prevent the use of an iframe from specific web sites?
Hello, Currently anyone who copies my iFrame code from the HTML source page of my site can embed that into his or her own site and show my view. Is there a way to prevent that? So that only when I access the iFrame from a predefined domain / site the iFrame will be displayed?
share in zoho creator returns an error
i am a paying subscriber. when i invite a user to access database in zohocreator they click on link and it says zoho component does not exist. when you click ok to close that message you can then access the database. why is this happening please respond asap
Reference Function params through tooltip
Suggestion for easier function coding... I absolutely love the simplicity of your functions. While not as flexible as js functions they sure get the job done. Often times I need to quickly reference the params for a function. I think it would be so great if you added a "tooltip" on hover for the function links in the function menu bar. This way you could really quickly reference the order and typeOf params being passed in an existing function. Wow, this would be great. It doesn't even need to be
Help with IF deluge
In my application I have a radio button with 3 options "New", "Yes", "No". I have a multi line field called "If no, Why" I want the person editing to be forced to enter notes in the multi line box if they select "No" on the radio button. HERE IS MY SCRIPT if ((input.Hired == "No") && (input.If_No_Why == null)) { alert "Please explain why this person was not hired"; cancel submit; } If I take out the && (input.If_No_Why == null)) I get the alert and cancel submit, when I add the &&...
Nonprofit Access?
I represent a nonprofit gaming recreations program called GameHearts (GameHearts.org for more info). We have been searching for an database import program that can list redemption cards for our participants and today I began working with your site. Unfortunately, I encountered a couple of limitations - First, the "free" package is limited to 1000 entries and, Second, apparently we cannot share our data entry with our participants without their logging into our account. Are these issues something
Assign based on location selected
In my application the end user selects from a drop down list which location they want to work at. I want to be able to "assign" those to particular people. Examples: Applicant1 applies for job in Stockton, CA - some designation is given that "Steve" is responsible for follow up. Applicant2 applies for a job in Battle Creek, MI - this person is assigned to "Mary" for follow up. Sorting is not sufficient as the person following up is responsible for several locations and sometimes in different states
TOO FAST!
How do I slow down the "Your Data Has Been Successfully Added" after a users finishes enter and updating the CReator form? It doesn't stay on the screen long enough. Thank you. George YourBizzWizz
Alert and Cancel Submit Script When Input ==null
Hi, I have created an app that is used for people to apply for a job. Everything is fine on the form side. I have fields that are hidden on the form that are shown in the view. This is so that I can add notes for each persona from the View. I am trying to make it a required field or setup a script so that when I go in to "edit" I have to enter something in this notes field. Nothing in the script builder selections is working. Can this be done? How?
Nested lookups ???
I know someone has asked this but I didn't see a response so .... Can you do nested lookups in forms - I want to do something as follows I want to create a form that has two dropdown lists ( say Industry Sector and Industry Sub Sector ) The values of Industry Sub Sector should be displayed dynamically based on my Industry Sector selection. For example suppose my Industry List is { "Energy", "Healthcare" } and my Industry Sub Sector List is {"Oil", "Pharmaceuticals", "Health Care Equipment & Services"
Creator "Reports" Beta bugs
I'm using Firefox 3.5.5 on my MacBook. I'm using the "Drop Down Menu" Layout in my App. When I put more than one Chart or Report on a tab, they display properly in a drop down list but can not be selected. Moving the mouse pointer over the report or chart item turns the arrow into an "I beam" as though it was trying to edit text. Other forms or views on this same menu behave properly. If I change to any other type of layout, the issue is resolved. Rick Clay
How do I select only the latest entry?
I have a multiple dated notes for each of several subjects. How do I view only the latest note for each subject?
Scheduler in Zoho Creator - Preview
Dear Users, We are excited to announce the beta testing program for one of our forthcoming releases - Scheduler. If you're interested in becoming a beta tester, please sign up and we'll contact you with further details. This beta program is for limited people. So hurry up and be one of the first to try it out. Register now Starting from tomorrow, we will start enabling the preview for the registered users over a period of time, depending on the number of requests. How can Scheduler be useful for
Script editor not loading
The script editor is either very slow or does not load. It only displays the loading bar
Brilliant
This is a really brilliant application. I can achieve in hours what would have previously taken days
How do I create a simple report that displays data from 6 different views?
I am trying to create a printable summary report using zoho that takes data from 6 different forms and compines them to one printable view? what is the easiest way to accomplish this?
if count being criteria being ignored in form
When appending to the first of 3 multiple selection field look-up form/tables, the following code adds a blank record to the remaining 2. It seems that the "if (count" criteria of "== 0" is being totally ignored. The following malfunctioning code comes from my "Child Training Report" form in the "On Success" section: if (count(Training_Subjects[Training_Subject == input.New_Subject]) == 0) { insert into Training_Subjects [ Added_User = zoho.loginuser Training_Type = input.Training_Type Training_Subject
ZOHO Creator Reports: Issues
This is what I'm seeing. You can see it live by visiting the Cycle 3 Voting Statistics page....
Is it possible to share a view with a user that can only edit one field?
Hello, I can share a form with a user and define that the user can edit the records. But is it also possible to allow a user rights to only a specified field? What I want to prevent is that a user can change some fields that are automatically updated. Greetings, Rob Bastiaansen
Double My Revenue Please
2-1-10 Today I went through ZOHO creator and replicated a database that will help my company grow leaps and bounds over the competition. The form design module in Creator is fantastic. It looks like the prodution version of the app. Here is the problem: 1) Email Invite to users did not work and no it was not blocked by spam filters and I used multiple domains to test 2) Frequent SSL errors warning that some content was not being sent securely Can these items be fixed? Your answers just might
Date/time calculation to stop date/time being selected within 12hrs of current time
I am creating a booking form where I need to stop entries being submitted if the proposed booking is less than 12 hrs away. How do I calculate this to so that the booking cannot be made?
HTML PDF blank
Hi, I have a html view based on form that I open in pdf with onpen url command "on success" of this form. At the moment when I send the data really the system open the pdf with the correct name but the pdf it's blank. It's a wrong html tag or script? Thanks Mic Application: Consulado-geral-do-brasil Html: Imprimir Relatorio Form: Relatorio Consulado Itinerante
HTML view font size
I noticed that all of my HTML view's fonts just changed size in the smaller direction. I have not changed anything to result in this behavior. I'm wondering if anyone else is seeing this or if Support could shed some light on this. tt
Email based on input
How can I email results of a form based on what a user choose in a drop down? Thanks!
no-cache setting prevents exporting data
The no-cache setting on the export data link/page is preventing the download of our database in all but the html format. I used a registry setting to tell IE 8 to ignore the no-cache setting, per Microsoft support, and it did not work. Please help.
How do I view only certain records in a form
I have a master form, then a user form. I want to select/view only certain records. How do I easily do this? It would be nice if the web page had a search button, but I don't see one or a way to add one. Thank you. ~rich
Form view
In zoho creator, I have built a form to obtain information for the talent agency I run. Models upload their photos into the form, along with other information (contact info, etc) My question is this: Is there a way for me to customize a view similar to Microsoft Access that enables me to create "cards" that show me the information of the talent including the photos (not in link form)? Thanks so much. I hope this makes sense!
Next Page