Form definition unavailable
Form definition is currently unavailable for me using FF3.6 and Chrome. In FF I get dumped to a search page when a page is unavailable, but in Chrome i get this error: The web page athttps://form/733/edit/script/&action_show=false&defleft=true might be temporarily down or it may have moved permanently to a new web address. More information on this error Below is the original error message Error 105 (net::ERR_NAME_NOT_RESOLVED): The server could not be found. Unsure if related or not but am also unable
Else statement is not working in HTML view
I cannot seem to get the else statement to work in this view. The if statement works fine, just not the else. Thanks for the help. htmlpage Approval_Form(pAccountKey, pOrderKey) displayname = "Approval Form" content <%{ account = Accounts [ID == (input.pAccountKey).toLong()]; order = Orders [ID == input.pOrderKey.toLong()]; services = Order_Service_Charges [Order_Key == order.ID]; billing = Billing_To [Order_Key == order.ID]; shipments = Shipments [Order_Key ==
Add multiple records on one screen
I have built a simple time sheet app. One each input page, we have the following: Date Employee Name Client Hours In this way, the employee needs to enter a few times per day. It would be better if the app can be designed in the following way: Date Employee Name Client 1 Hours Client 2 Hours (2) Client 3 Hours (3) etc. Can the input page hand one page entry to multiple records (same date and same employee name) Thanks, Sam
Custom HTML Forms?
Hi there, I was wondering how would I be able to create custom HTML forms rather than use the form builder? I'm a web developer and find the form builder extremely limiting. I would like to do simple stuff like this: <div> <label>Firstname</label> <input id="firstName" type="text"> <label>Lastname</label> <input id="lastName" type="text"> </div> Is there a way I can do that? I find the default forms layout (table based) very limiting as it doesn't allow for better use screen space.
Time picker?
On the forms page, there is a drag and drop element for Date-Time. However, if I only need and want the user to be able to select a time, how would I be able to do this? The Date-Time picker seems to have such a large focus on the date controls and doesn't have large enough controls for the time picker. In terms of UI, it makes it more difficult for users to simply just select the time. Thanks in advance,
Changing Location Of Filters
Hi - Is there a way to move the location and layout of the search filters on a View? For example, can I have them appear on the left-hand navigation rather than at the top of the grid? Thanks for the help. JL Scott
Defects/Deficiencies relating to Share Functionality
I have discovered defects/deficiencies relating to the Share Functionality within ZOHO Creator ... I did not want to hi-jack this topic ... http://help.zoho.com/portal/en/community/topic/an-issue-with-unshare ... so I started a new topic here. A couple of months ago I was asked to evaluate an Application (running since January/2010) for a Customer ... their previous Developer had gone AWOL. This Application had never been backed up ... and the first attempt to do so failed ... the ZOHO Support Team
An Issue with Unshare
Share/Unshare is confusing me (ref http://help.creator.zoho.com/Sharing.html) I have added a public HTML "start page" in a private application with multiple views and forms. The start page has logic to share certain views and forms based on the ZOHO account email of a signed-in user (the logic criteria references emails in a "roll list"). I have verified that the share operation not only places a user on the application's share context (for views/forms/etc) but also places the user into the "Account
how to check if it is a number in a field
Hi: What is the function that check if user input is a number, something like: If (isNumber(Input.NumberOfItems) == true) Thanks.
Generation of more than one records in a single form entry
We are trying to generate e-commerce application for bill collection. Table-1 contains customer detail in 06 fields. Table-2 contains bill detail in fields. Now we want to generate one form having all these fields. It is simple. But we want that customer data will remain as header data i.e. should be entered once and bill detail data can be entered more than once on a same form with total amount showing in the form at the bottom. i.e. if one customer wants to enter his three phone bill detail at
Adding a record count
Hello, How can I add a record count on this application (I've put it on our website)? Thank you, Lisa
Render image formula field requires upload field
I used instructions on this page to render uploaded images in views, and it works, but why do we have to display the upload field in the view for the formula field to work? Or am I missing something? To me this is just bloating/breaking views' tables with useless loooooooong file names. Is there a workaround for this besides an HTML view? TIA.
Corrupt Script Hanging - Will Not Load
In my "Admin System" application, my form "Task_Attachments" on-edit:on-success script has become corrupt and will not load. I am unable to load the script builder OR the free-flow script in order to correct the issue. 1) can you please go into my application and delete the "on-edit:on-success" action script for the "Task_Attachments" form. I have a backup of the script and will place this back once I can get back in. 2) Zoho needs to implement a feature where we can edit scripts in a "safe mode"
"for each" loop exits when sendmail fails
I am sending email to a subset of records satisfying a condition. The problem is that occasionally a record has an invalid email addresses and the "for each" loop exits in this case. This is a problem because everyone in my records needs to get that message. How do I make "for each" continue to the next record without exiting? for each X in Registrar [SEND_EMAIL == 2] { sendmail ( To : X.Email_Address From : zoho.adminuserid Subject : "Estás invitado
Target works when logged in but not when...not logged in
Hi, I've a form in my app that reloads two frames upon submission - ie rec = Performance_information [ID == input.recordID]; newfurl = "https://creator.zoho.com/rsoftley/ast/form-perma/Performance_information/zc_Header=true&zc_SubmitVal=Add&zc_ResetVal=Clear&Venue=" + rec.Venue; openUrl(newfurl, "iframe", "formFrame"); newurl = "https://creator.zoho.com/rsoftley/ast/view-perma/Performance_information_View/Venue=" + rec.Venue; openUrl(newurl, "iframe", "frameName");This works
Form Layout
I am new to Creator. I need to create a form that will be used for data input. I know I need to create a stateless form. What I am finding is I can create a form that list the fields I need in a linear fashion. Example: First Name Last Name Street1 Street2 City State Zip Company Job Title I would like my form to look more like First Name Last Name Street1 Street2 City State Zip Company Job Title How can I get my
Free-Flow Scripting is DOWN!!!! (in firefox)
this problem started in the last hour... it is a firefox problem
View form directly load in search mode
I want that view form directly load in search mode. i.e. I do not want to give access of all data of my publicly shared application to everybody who access the application on net. Anybody who access the application (directly view form), will have to enter search criteria so that he can view only that much data. How to do?
Need help with Lookup Criteria
I have 2 forms: Project and Workarea The Project form has a field- NAME; the Workarea form has a field- AREA and a field STATUS I have a 3rd form, Workflow. On it I want a user to associate a workflow with a workarea. To do this they must choose a project name from the dropdown lookup. This works fine. They then need to choose a workarea name (aka AREA) from the dropdown lookup. Here's where I can't get the criteria right to choose only the workareas associated with that project. Also- this has
Database structure + dynamic fields
Sorry about the topic title, I wasn't sure how to call this. I've got Parts and Sequences. Right now these are two separate tables/forms. Each part has got a title and a number. So for example, I've got 7 "plumber" parts + 75 "deputy" parts. Each sequence has got a title. Relationship is PARTS n <----> n SEQUENCE I need to assign parts to sequences, that's easy as I can display checkboxes in the sequence form using a lookup field, BUT, I would need to be able to assign an amount (number) of each
Can a Dashboard (HTML View) be used on a mobile device?
I have created an 'Instructions' page as a HTML View. I see it on the PC version of my app, but it doesnt show up in the iPhone via http://mobile.zoho.com/creator. Is it not supported? also- in the mobile version it shows headings of FORMS and VIEWS in the interface. Can these heading titles be changed in the mobile? On the PC side, I renamed them ADD and VIEW/EDIT.
Using Creator script can I control files on my local hard drive
Hi. First, I love your program Creator. We have been working with it for only a few days and have found it easy to use, flexible and scalable. We have a need for an online asset management system as our warehouse is remotely located from our sales office. I have started to create an asset management database using Creator. I have the asset data collection form completed. Each asset has a unique SKU number, auto generated from creator using a maxvalueholder form. During processing of our assets we
Variable Declaration
Hello, I was able to get the show/hide fields to work with a check box. Now when trying to show/hide fields using a drop down box response, should I claim the variables at the beginning of the Form Definition? I know they are localized instances, but in declaring them onload, will I need to also declare them at the instance point? Or would it just be the reference in the on input if/else? Thank you.
Server speed..
Anyone else getting really slow ZC performance? Given popularity of ZC and it's Herculean feature set I'm gonna assume there's going to be slow times but this is pretty bad. It's not my internet connection. Any reports of things going on?
Embedded calender view
I have embedded a form, a list and a calender into my website. the form and list are fine but i cannot get the calender to fill the whole width of the page and differant days seem to have differant widths. The data works fine but it does not look very good Any ideas as to how this can be solved
Need to print job tickets.
I'm completely new to Zoho creator and trying to create a job tracking software. We run a small sign printing business. I want to print a job ticket to physically follow each job through our system as we print it. I have a form build that we'll fill in all the fields, I just need a way to print a ticket that includes data from one record. I realize I can go into the form view, and with a right click>view>open in new tab I can view and print one record at a time, but I would like to be able to edit
How to prevent users from editing data in view and force to use form with logic?
I am thinking that in a workflow with conditional steps, a user could edit the data in a view and avoid the conditional logic which would give bad data. How can I prevent editing in a view and force editing only through a form?
DIY Dabble DB Migration Tool
For all Dabble Db Users looking to migrate to Zoho Creator, here is some good news. We made the migration process a lot more simpler than it was.. We came up with a Do It Yourself migration tool. The official announcement came out yesterday. In case you missed it.. Read about it here. Did you like the comic video we made for it?? Then you'd surely be interested in our behind the scenes story.. Thanks Aparna
import record limit
I'm trying to import records to a new application. I receive the following message 'Record limit reached. Kindly upgrade to a suitable plan to import more records.' This is a free account. I am importing 43 records. Each record has 1 field. There are 435 records in another table with an additional 14 in another table. Why am I hitting a limit? Herb Wexler
Issue with Importing Excel or CSV
Having an issue in Creator where I cannot import data from a file. I had played with this yesterday, and everything was working fine. Today I am continually getting "contact support" error messages. I have simplified my imports to literally one cell of data, I have exported from Creator and tried to reimport the same data format (ie, put in different information), but it continually errors. Any ideas? Thanks in advance! R~
How to get 4 records per page in view?
Hi! I would like to limit the numbers of records per page to 4. The hight of one record is covering more than one screen, and it wold be realy nice to just flip page and not scrool trough the screen. The view is caled "Casting view". It is just dummys in the view at the time. Please do help. Best regards Benjamin Sjur Blom
How to select a form based on a variable?
I have a series of data collection steps that are required to be followed based on the state that you are in (like Texas, New York, California, etc.) I need to associate this state-based form with a lab sample depending on which state sent me the sample. How can I go about doing this? Also- It needs to be fully supported from a mobile device like a Blackberry, Android phone and iPhone. These are the primary data entry tools not a PC. Your help is greatly appreciated.
Zoho forms - Changing Form action from Add to Edit at run time
Hi, I'm facing a problem. We have list of contacts can be add / editable. We also have a unique field Email. When some one enters the same email next time, Form should be going to editable mode. That means update mode. Any idea how to do it ?
View Mode Filters Not working correctly
Hello, In my application "SDI Tool Parameter Tracking Database" the view mode filter does not work correctly. I have left the Select District filter included in my "Global Summary of all tools and districts" report for support to review. Please let me know if this is a bug or if i have programmed something wrong. Jason Rapp
Importing Data into Table View: Date Format dd-MMM-yyyy hh:mm:ss does not exist for date/time fields
I have a field (column) in the time and date format, e.g. 26-Oct-2010 11:30:00. If I export as .csv or .xls and re-import immediately without modifying the file I am unable to import the time because the option "Date format for the column(s)" doesn't list dd-MMM-yyyy hh:mm:ss, it only lists dd-MMM-yyyy. This fix needs to happen fast because I have a lot to import. thank you.
Why does my form not work?
I have created a form and embedded it here: http://www.autoliftuk.com/disabled-access-lifts/hi-rise-lifts.html On a windows PC with IE it displays just fine, but on Ipad, Iphone and Safari it displays a cookies error? What am I doing wrong? Chris
Acces data from previous entry
I have field which is formula. And the formula used the data from the last entry. How or what is the syntax for accessing the last entry. The formula is: balance = (previous balance from the last entry) - amount
View individual record
Hi there, I'm new to Zoho, so please bear with me if I'm missing the obvious. I created a form with quite a bunch of fields (about 30). Worked fine. I created a summary view, which works ok as a summary. When I click "View" next to each record, I've got this popup. What I would like is a link on each record, to a page with complete view for that record (not edit view). Do I need to create a view for this? How would I link from the summary view to this new view for each record? TIA.
Conditional field (step by step)
Hi -- (I already posted this, but as a reply to an "Answered" topic. I'm reposting it here for clarity's sake ; sorry if I'm breaking forum rules) I have a radio field : "Gender" with Male/Female as possible values. I would like to display a text field "Maiden name" only if Gender = Female If I try this : if (input.Gender == Female) it says "Female" is not declared as variable. I tried to use "Set variable", to no luck so far. Would a kind soul provide a step by step tutorial for this? Many TIA's.
when do I need use: "input." and when I shouldn't
Hi: Can you let me know when I need use: "input." and when I shouldn't use that? For example: input.Today_Date = zoho.currentdate; //this is correct. (get today's date and show on the Today_Date Field) disable input.Today_Date; //this syntax is not correct. disable Today_Date; //this is correct. (set this field read only). Thanks
Next Page