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
Blank field not shown up
I would ask if you can assist on how to show up records that have blank field if this field is set as criteria.
View Criteria where a field entry is empty/nul
How can I select only entries where a field is not filled in. e.g. how do I select all employees who do not have an entry in a date field called retireddate. Is there some kind of NUL or UNDEFINED constant that I can compare with?
How do I get values from 4 separate queries to show in one table?
My objective is to build a budgeting interface. Where I can add to each budget products. And each product is made of Milestones and Tasks. My question is, how do I get values from 4 separate queries (Proposal; Product; Milestone; Task) to show in one table? Like the above image. Is this possible?
How to add a formula that subtracts date and times
Hello, I am new to app development. I am trying to create my own zoho app that is a call log. I have 2 fields that are date and time, one is start time, one is end time. I want to track how long I am on the phone. Can someone please show me step by step to get my Field, 'Total Time' to show how many minutes and seconds I was on the phone please? Thank you!
Conditional fields?
Can I use Zoho Creator to build a form with conditional fields? That is, a certain answer to one question causes a new field to appear on the form immediately below the first field.
Problems with forms
Hi, I have a problem, I´ve created the form and when I´m editing it i view it, but when I try to access it shows only the title, but not the fields, two questions then: How can I do to see the form? and: How can I know what is the web address?? Thanks a lot :D
Auto generated table ID?
Hi: Have checked online help, seems have different approaches for getting an auto generated table ID. Can you guys let me know: can we create a field which has auto generated number so I can treat that as an unique ID (for example: start from 1000, increment by 1 for each new record, same as MS SQL, or MS Access table). Thanks.
How to calcuate times (min/sec) between 2 date fields
Hello, I have 2 Date-time fields on my call log. How do I, step by step, calculate the time between the two because I want to track how long I was on each call, (including seconds) I also want to be able to see totals per day of number of calls, and time on each call. Will someone help me with that please? Thank you.
Zoho Creator help for a newbie: Form View
Hi all, I'm very new here. I'm attempting to build a database that has some simple category information (location, date, subject) by radio choice in addition to a large rich text block. I'd like to rich text block to be searchable by users. However, the only way I can seem to do this is to have the text appear as a column in the database view, which makes everything quite unusable because the entries are so enormous and the entire text is shown. Is there a way to gag or hide the big text column,
Lookup fields filtering
Hi -- I have a PROJECT form, then a TASK form linked through a lookup field. I need to be able to assign one or more tasks to people records in another form. I thought I'd do with two lookup fields, yet I want to task lookup to be filtered to only display tasks pertaining to the first project lookup field, so only tasks from this project will be displayed in the second lookup, what formula should I use? TIA. — AB
Cannot update my schedules when to do date.
I am unable to make a modification to my schedules. I get the following error when changing the "When to do" (number of days after). "Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again" Please help, refreshing and signing out of zoho and back in does not help. I have retarted my browser as well. Still no go. Thanks for the help
Visualize database structure (forms ans relationships)
Is there a way to visualize the database structure of an application? I would like to be able to show the forms, their fields and the relationships that exist between the fields.
Bug: Schedules module not behaving correctly or saving edits
The Schedules module is still buggy, driving me to frustration again. I set up a schedule to notify some staff members when a certain item w/ an expiration date (field = End_Publish_Date) is 3 days away. Suddenly this morning (1 day after setting it up) we got dozens of notification emails about expirations on items that aren't even in that form! And, to make matters worse, when I go to edit the schedule and adjust its criteria, I cannot save it! The form is called "Check_It_Out", and the schedule
Delete function no longer working and Java script error on page all of the sudden
I have a function in my commission tracker application that is a delete detail function. It worked for a few months and all of the sudden nothing happens when I push it. I am also noticing all of the sudden that I am getting a java error on page message at the bottom of my IE7 window. Any ideas? We use this app everyday so any help would be appreciated.
Next Page