interface bug in drag and drop form editor (notes field)
Steps to reproduce: Drag and drop a notes field to a position between existing fields on form Format text and click done "Please wait" continuously displays until page is refreshed Note field either does not appear, or appears in the wrong place after the page is refreshed I am using the current stable release of Chrome (12.0.742.100). Anton
Is Chrome fully supported?
I am noticing that various aspects of Zoho Creator are a bit 'flaky'. This is mainly just interface glitches and does not (mostly) lead to errors in the scripts or application itself. Is this simply because I am using Chrome and it is not yet fully supported by ZC?
Formula Field
I would like to reference a field value in another form. Is this possible ? Example: Form A field 1 Form B field (formula) Formula definition in Form B Form A(field 1) * 100
Importing Street Address (multi-line) from Excel
If I try to import a field with multi-lines from Excel, the import wizard breaks the record into two records at the carriage return. Inparticular, I'm trying to import contacts that have a Street Address field that looks something standard like this: 1420 E. Main Street, Apt. #2 Flagstaff, Arizona 86004 The field that I'm importing to is a text field with multi-line capabilities. Is there special formating that I need to import the multi-line data? Thanks, Jeff
How to make more text show up in the title of a calender entry?
It seems as though there is a 15 character limit on the length of the title that appears in a calender event. So another words if i add a new calender event through creator it will only show the first 15 characters of the title of the event. This is a mojor problem for me. How can i get it to show more of the title?
Problem with "view-perma" mode
Hi again, https://creator.zoho.com/f1ps3online/campeonato/view-perma/GenerarGrupos is KO https://creator.zoho.com/f1ps3online/campeonato/form-perma/GenerarGrupos is OK Why this difference now? It worked perfectly till now
Function not working in header but works in each record
Possible bug in calling functions. I have a function that only has an openurl statement. It is called from a view the intention is to open a new view. When I set it in the View Header it does not work however when calling the same function from 'Each Record' it works as expected. An alert/info statement shows that the function is being called but the openurl did not open a new view. Here is the function void Rides_Full_Year() { //op_52=CURRENT_YEAR openUrl("http://creator.zoho.com/soundcyclists/scbc-ride-list/view-perma/Schedule_List_Full_Year?Ride_Date_op=52",
Filter a record by a certain field not being blank
Hi, I am trying to create a view that only shows records that have a value for the field "Payment_Date" I have tried setting a filter that "Payment_Date" does not equal empty (I left the field blank) but this did not work. Is there another way to do this? Thanks
Create Function to pass value from one form to another
Hello, I'm new to Zoho Creator and love it! But I simply cannot figure out how to create a function, and it appears that I will need a function to do what I'm trying to do. Here's what I'm trying to achieve: I have a web page with 5 tabs. Inside each tab is an iFrame holding a zoho form. So the user can simply click on the tabs to access the various forms. Up above the tabs is a zoho form with just a single input field. I want the user to be able to put a value into that lone input field and
error occurred while creating the report
I am trying to create a report but get 'error occurred while creating the report'. The application has 14 forms & 25 views.Currently there are no reports. I am using the 'Business Free Edition'. I tried creating a report from different views with the same result. Any idea what is causing this error? Herb Wexler
Disable RTF not working
I have a form with a RTF that is disabled. However users can type in the box and on submit the changes are saved. The RTF field is used to display information from a RTF field on a linked form. All of the toolbar controls are unchecked. Herb Wexler
JavaScript error on Rich Text Field in Form
This is probably something simple but I can't find a forum post on it. When I embed a rich text field in a form then if I try to use any of the more complicated rich text icons when completing the form e.g. font, font size, insert table icons then I am getting a JavaScript error (see below about className)..and the icon is not working. I see that those same icons (on the discussion page into which I am now typing) are working fine here on this page...just not on my application form! I am on
Share Application not working
I am trying to share my application and it simply will not allow it to be shared. At the moment the application is shared with no one, yet every time I try to send out an invite, when the person clicks on the application it signs them into MY account. Or when they log into their Zoho account it shows up on their shared applications list yet when they click on it it won't allow them access and says they do not have permission.
data validation
I was trying to validate a form with the following code: if (count(Address[Address_Name == input.Address_Name && client_code == input.client_code]) > 0) { alert ("An address with the name already exists for this client. Please enter a new name."); cancel submit; } But it is not working. Sometime the validation works and throws the alert and sometimes the user can enter the data successfully. I thought it was a really easy validation. Am I doing something wrong or there is something wrong
Even without a registration
Even without a registration, the application charges that exceeded my quota I have 6000 records and 15,000 records. How can?
Time tracking attendance
I would like to know if there is any way on a form that you can type in a number e.g. 1234 press enter then in a table it adds 1234, the date and sign in time.Also usin the same form if you type the 1234 in again it will add sign out time. Any help please? payroll check calculator
world-viewable Creator app: URL for my client?
I have a simple scheduling app built in Creator. This will be used by my corporate client. Is there any way to share a URL for the app that doesn't reference my Zoho account name? Glen
How can I do this: Public can add records, but not edit or view details of previously entered records
I have a "Public" app which allows people to register themselves for events on a calendar. For privacy reasons, I can't allow other people to edit or view those previously registered people. How might I achieve this?
How can I do this: Provide an "Admin" area only available to signed-in user
My "Public" app allows users to register for events on a calendar. I need a separate Admin area only accessible to signed-in users which allows the Admin to view/edit/delete event registrants. Any tips would be appreciated.
Change view based on drop-down?
My organization is trying to decide between QuickBase and Zoho Creator and a question will help clarify if Creator can meet our needs: Is it possible to have an HTML page which has on the top half a set of dropdowns, through which on the bottom half a different view is generated? An example would be: 1) On the top I have a drop-down list of offices that collect donations for a non-profile 2) On the bottom half a different view table is generated based on the drop down selected in 1. Additionally..
navigating through forms
Hi all— I'm contemplating moving to Zoho from Google docs, but I'm stumped as to how to do a basic action. I'm creating a test form for an employee to use when conducting telephone surveys. I'd like to start with a Multi Select question that would navigate her to another page of the form depending upon which option she selects. In a Google spreadsheet this is handled with a check box that reads "Go to page based on answer" and then there is a drop down list of all the other pages in the form. In
Error On User Input Script
I'm having this error, could someone helpme with this? Thanks Error details: Error occured while executing on user input script. Unable to update variable Address r.Address is null r is null This is the Script associated r = Store [Store == input.Store]; input.Address = r.Address; input.City = r.City;
Pasting Graphical Content into View/Form
I need to be able to paste mixed content (text and graphical) into a form field in Creator. I created a test form with an RTF field. I WAS able to copy part of a Internet Web page (formatted text and graphical content)... and successfully PASTE into that RTF field and view. No problem there. When I copy content from an open Word document from the desktop (formatted text, images, graphs)... ONLY the formatted text portion shows. The images and/or graphs do NOT paste. Can you tell me what
new sharing interface bug
Steps to reproduce: Go to "Share / Shared Details" Click on a form/view Share or unshare the form/view with a user Click on another form/view to make further changes The share/unshare/quick invite panel disappears and will not reappear I am using the current release of Chrome (12.0.742.100). Anton
Can I use the /api/xml/formsandviews/ function to list views in applications that are shared to the user?
Basically I create an application and share it with a user. I create a ticket using the user's credentials and try to use the following to list the views in the application. https://creator.zoho.com/api/xml/<application name>/formsandviews/apikey=<application key>&ticket=<users ticket> It returns error 2892: "Specified application name is not valid. Provide a correct one." This works fine if I use a ticket generated from the creator of the application - however I want to list only the views that
Any samples or advice on how to script the following ?
I have one form that has personnel with hourly rate. I have another form tallying the number of hours worked in a task. I'd like to generate a view (from second form) which multiplies the number of hours x hourly rate to get cost for the task. Then this form could sum the cost for the total cost at the bottom. Any ideas of what the best way is to do this ? Any help would be appreciated.
Using multiple forms during user registration.
I am trying to create a solution for registering children for swimming lessons. I would like to be able to split the registration over multiple pages since it is long. I have created separate forms where i collect the parent information, then the child information, then the class registration. Is there a way to pass say a customer id from one form to another? I may change the order to be Child info first that way it is a one to many relationship with childinfo being the "parent" to parentinfo as
Field not updating
For a disabled lookup field ("Problem Field") I set the value through Deluge script in the 'On User Input' event of another field (on the same form). So depending on the value selected in this field, the value in the Problem Field changes. This works fine for existing records. On new records the value remains "-Select-" until I save and reopen it. My app bmpm is shared with support (edit access). To reproduce: - go to tab 'Admin' - open view 'xxxx' - click 'Add' - In field 'Player' select the entry
Error "Invalid entries found. Please correct and submit again." Lookup Fields?
Hi, Everyone I have just completed a database and I am getting the error "Invalid entries found. Please correct and submit again." I am guessing that it might be some kind of problem with the Lookup Fields and the dynamic update I have on dropdown list. Anyone has any idea on how to solve this? Please let me know. Regards, Leandro PS: I have just submitted it to support.
waiting to hear from support
I have submitted 3 support tickets by email over the past 3 days (the most recent is 2 days ago) to which I have not yet had any reply. Should I be submitting support requests in a different way to get a more timely response?
SOLVED: Zoho settings - date format
Hello, I've noticed important and great changes on Zoho account setting. A great option is to have a Custom date format for myZoho Account. I set format to yyyymmddhhmm, this is the standard kind of format in medical bussiness. The problem is that for date fields there is no option to have this kind of format. The date is still in yyyy/mm/dd hh:mm format. Is there a way to have date fields like in medical bussiness? If is not posible through Zoho options could they be implemented through scripting?
Stringlist converting to a string
I have a string list field in one form and when I convert the form a new form opens up and then puts the detail in an html view. I am having problems writing the function so that the item that was chosen in the list appears in the html view. Assistance would be helpful! :)
Group by month
How can I group records by month, ie. "January", "February" etc, and have the records in correct date order? I can derive a new month field, but cannot get Creator to group by it in date order, instead of alphabetical order. DabbleDB does this out of the box...
The same formulas and different view records
Hi there I have a problem with my Form. There are two formulas: 1. minus za ratio 2. obrona minus minus za ratio both have the same expression as below: How is this possible that there are different View records?
Intermittent issue in accessing the views for a section of users
Few hours ago, there was an intermittent issue in some of our applications servers. Due to this, a section of users were not able to access the views. We are now bringing back all the affected servers to normalcy. This should be completed in another 10-15 minutes. Affected users can access https://precreator.zoho.com till that time. We will keep you updated once all the affected servers are brought to normalcy. Charles
Help! cannt see contents, blank pages for Views
Forms and HTML Views work fine, but the normal Views are returned with blank pages. (Firefox, IE / Win XP) They were working fine before but about an hour ago, this problem occurred suddenly. Please help! Thanks!
Today my app all views can't open
Hi Today my app all views can't open,it's system maintain？ Awaiting your settle the problem Thanks Stanley Guo
existing creator form shows blank screen
As of today (although I haven't checked it lately), I get blank screens in the form part (fill-in) of the 2 forms I have created - this happens on Firefox, Chrome and even on internet explorer - i.e. it's not linked with browser type or version. Edit shows what is should, as well as view - I can even see filled in forms when I edit an item, but still, when <i go to the form page to create an entry, all I get is a blank section of page (left pane shows and work) Any idea of what's going on?
Pulling data from another table (UPS tracking numbers)
We have two tables: Open Orders (has a Sales Order # entered at order start) Tracking Data (imported from UPS with the Sales Order # as a column once the order has shipped) Trying to create a view that will list all the line items in Open Orders and pull the tracking number from the Tracking Data table when the Sales Order # matches. Any advice is GREATLY appreciated.
How to properly declare a user variable?
How does one declare and use a non-field variable? I'm attempting to autoincrement a field, using the example at https://help.creator.zoho.com/Auto-Increment-Field-Values.html I receive the error message that the user variable is not a field. "Field x does not exist in the form " Yes the variable is not a field, that is the intent of the example cited for the Auto Increment script. I find no indication in the documentation what form of variable declaration is required. The information provided at
Next Page