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
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.
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
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.
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!
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.
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
Looking for a CREATOR GURU (Form developer)! Are You available?
Hi, here is the project ...I need your help in order to develop the right Form for my website! As an Advertising Agency (New and Poor! :) )we need to allow our customer to Logging in (So, I think I need a DB in order to store customer info?) and fill out the Online Form (Integrated in our website) and save the order. The Form Order require many fields and may need to be exported as csv. file and organize this file for fast interaction with google or other search engine software to upload the file
"Click Here" link no longer appears when exporting a private embedded views without login
Previously, this was working fine. However, today when I try to export a private view using CSV feed, the link to enable "To access the view without login" is no longer visible. See below. Also, here is the documentation that describes what I am trying to do: http://help.creator.zoho.com/Embed-Form-View-in-Website.html#To_access_private_embedded_views_without_login To access private embedded views without login To access the embedded view without login, select the Click Here option displayed in the
Unable to update multiselect field
I have a form with a multiselect lookup field "Known_Players" that points to the field "Name" of the same form. When the name of a player is changed I want to update all the Player records in which the name is selected in the Known_Players field. For this I have the following code in the on success / on edit event: for each player in frmPlayer [Known_Players.contains(input.Name_before_edit)] { oldList = player.Known_Players; newList = List:String(); for each item in oldList
How to implement IF THEN logic in a database?
I have an app idea where I don't want the IF THEN logic coded in the app. I instead was thinking that it would be easier to manage and change if it were in its own database. Think of it like a conditional question and answer flow. The answer to a particular question will lead you to a different question. In the table I was thinking: Question1 IF answer x THEN goto Question2 ELSE goto Question3. Is this possible like this or does it need to be coded in the logic of the form?
My Application form promoting login details
Hello Respected Members I am enabled my public service for embedded form in website without promoting login then in my application there are three forms in my application two forms are work normally then can't promoting login details but one form promoting login details please give me a solution Thanks
New user: First of many questions: Filtering drop down lists
Hi, I know that this question has been answered several times in the forums, and I have tried using the script but I am obviously doing something wrong as it keeps throwing up errors. I must be making mistakes when changing the code to fit my form names and field names. Please assume zero knowledge when replying to this - sorry! I am trying to create drop down lists that filter to 4 or 5 levels. I have a small business that has 2 different divisions: design and printing within these divisions
Creator App Recommendations Please- can it do this?
I need to create a database Web app to be used both from a PC/Mac, iPhone and Android Phone. It needs to be multiple user. Users will pay a monthly fee to use the app. Users will be able to look at just their data. The app needs to provide a Wizard-like step through of a technical lab process and prompt the users for each step of the workflow for data to continue. The app will ensure compliance with lab safety procedures and needs to be very simple for anyone to use. How can I create this in
User Submitted Data
Sorry, I know this question has been asked before but cannot locate an answer to help me. I do not have the "User Submitted Data" checkbox to enable me to attach the information rendered on my form in the e-mail I send to the users. My form is open for support. Please review it and tell me what I need to do. Note: I had it in the very beginning when I was testing the firm, but it is missing now. Thank you, Vanessa
Changes not saved
I'm freaking out. I made a crapload of changes (new fields, tons of new information), and I just went to access my application and THEY ARE ALL GONE. WTF??? How do I get help with this? I need to report to my boss tomorrow and now I don't have half the research I had done. I am beside myself.
How do I . . . Adding fields together (script)
MABAH Profile Information Confirmation for <%=Email_Id%>. input.First_Name input.Last_Name How Do I make type the script that will enable these two fields to list the first and last name (e.g., Vanessa Griffin). Thank you.
Crash-o-rama!
I was trying to create a work around for a search form I needed and now every time I try to access the scripting area I get the error below: [ServetException in:/jsp/edit/script/sbuilderedit.jsp] null' What I did was create a new form with links to all tables (aka forms) that I wanted to access terms to search on. Then I created a new list view and picked the columns I wanted to give my users the ability to search. Then - Crash-O-Rama! I have since found a new method to accomplish my goal since
Exporting Single Form Submittals - HELP!
Forgive me if this has already been answers, but this is what i need done, and have been trying to figure out for weeks now... I know its sad, but some PLEASE HELP! I took some of the various paper forms that our company's HR department uses for accident and injury reporting and recreated them digital. I embedded the forms on a local site, as well as the form views. I am trying to figure out a way to be able to have the various employees in the HR department login to the system, Once logged in the
Using custom fields as part of web to leads
I can get web to leads data captured perfectly when using standard lead fields. However when I introduce custom fields, any data input does not get captured although data for any standard fields is captured correctly. Any ideas why the custom field data is not coming across?
Creator CRM Link
Hi, I'm devolping an Creator app that retrieves info from Zoho CRM using the new deluge task - zoho.crm.getrecords("<ModuleName>",<fromindex>,<toindex>). Are there any plans to make this task more adaptable? The maximum number of records it can fetch is 200 and I have over 400 records in my CRM. I don't want to fetch all of the records, but there doesn't appear to be a way to filter the records before they are fetched. There is also no way to sort the records (alphabetically etc). At the moment
I can't embedded my Form to my website without promoting to login details.
Dear Members In my Account public service is enabled so i can embedded my form in my website without promoting login details i have two forms and i can embedded first form successfully without promoting login details. but in another form when i embedded in my website then i click on Customize Form Properties & Look and Feel for looking something good and i will give my customization to form. then i am embedded this in my website but this time it promoting login details. I check my form again but
sned mail
Sendmail will not send email if I add one of the expressions/variables (dropdown). Other expressions/variables work fine. The data is received and viewed correctlty with all of the variabes, however it will not send with one specific expressions. Need assistance
Values from new "Add a <field>" enabled lookups don't backup/recover properly
I have a lookup field using the "add a record" option. I had to recover values backed up, I got error messages and an empty data column for this field when recovered.
Is it possible to count a word in Multiline ?
Actually I have integrated SMS API with clickatell. Now for SMS Body I have selected Multiline but unfortunate there is not MAX Digit option. I have to limit 160 Digits. Is there any way to do so ?. Thanks
How can give following restriction in my form ?
Hello Respected Members, I am in problem and i want to solution of it, first i am described my whole application and then i am tell you my problem. I have a application which name is "VIP ZONE" it has two forms first is "VIP REGISTRATION" and another is "DEMAND FORM". My first form "VIP REGISTRATION" this is like as a registration form,this form have following fields : USER NAME - string type VIP_ID - string type Your Email ID- email type VIP Membership Type - Drop-down list (pick-list) this Drop-down
Calling a function from ASP server Side
Hi, I am new to Jquery. I have a small jquery popup function which I am using for displaying help file. It works fine when I call it from getfocus of a control. I would like to call the same or similar function from ASP server code to display a message after a successful update. I would like to display the popup without hitting a button or link. How do I accomplish call that function from asp server side using c#. function showPopup() { ShowPopup(); setTimeout(HidePopup,
How can give following restriction in my form ?
Hello Respected Members, I am in problem and i want to solution of it, first i am described my whole application and then i am tell you my problem. I have a application which name is "VIP ZONE" it has two forms first is "VIP REGISTRATION" and another is "DEMAND FORM". My first form "VIP REGISTRATION" this is like as a registration form,this form have following fields : USER NAME - string type VIP_ID - string type Your Email ID- email type VIP Membership Type - Drop-down list (pick-list) this Drop-down
Delete records using stock prices
Hello, Is there a way for me using scheduler to delete certain fields by checking the current price or closing price of a stock against a price set in my database and if the values are > or < execute the deletion? Basically I just need a way to check current prices or closing prices of stocks from within creator or scheduler. Thanks!
Creator and Project Integration
I would like to pull all projects into a drop-down list from creator and am having difficulty with the project api. Any help is appreciated. Thank-you
Can I completely Rebrand with ease?
We are new to this, and are looking for a program to create an app with a database for a type of inventory control. Where our client logs in through our site without knowing how or where we came up with our unique way of inventory control. That is why we are in business for our own ingenuity and thinking. I have read a couple threads of rebranding topic, but can I accomplish this with little effort? Is that the purpose of the business account? I read about the logo, but I also read that the same
Bug with Exporting to PDF AGAIN !
Hello Zoho team, at first, thank you for repairing this problem last week. But today we see that the problem with exporting to PDF is hier again! We use this function for printing invoices and our customers are very ungry to us :-( Thank you for your repair. Mirek (webinare.cz)
How to build a sub-model of ZOHO server web site?!
Hi every body... I'm a new in this world ! -mean the world of designing data base and other programming application. Firstly, I was study now computer science and espicially Java development, Oracle and Web-development application and this my last year on my faculty, and i search now for an idea about my graduation project..... So i found an idea about design a server web site for Designing own your Data base for any thing ... But i was found finally this site, i'm really wonder it .... SO I WAS
Why won't my Creator app be converted to "public" access?
I developed a new Creator app and have requested that it be changed from a "private" app to a "public" app over a week ago. I sent messages to support and they responded by saying the following: a) We need to know your position in the organization? What organization?? I am an individual ! b) We need further contact information on your "public profile" ? They have all my account info with email and phone numbers in my account. What more do they need? Surely thaey don't want a facebook account,
Allow users to add new entries: form doesn't reflect all "on load" actions
The new functionality is good, but the form that is brought up after clicking "Add a <form entry>" option doesn't reflect the actions for "on load." I created a form with a lookup that counts whether a user's login is listed multiple times, and if not that particular field is hidden. This works fine in the actual form, but not when initiated through clicking the "Add a <form entry>" option. As an example: Support has access to the application: Final Meaningful Use Method. The relevant form is
HELP! Error Message keeping me from editing fields
I edited 2 existing forms: "RTO Listings View" and "RTO Sellers View" and created a new view called "Shannon - RTO Listings" Now I am unable to edit any of these entries/fields for these 3 views. All the other views are fine. For example, I go into RTO Listings View, I pick any file to edit, I don't make any changes and just click UPDATE. An error message comes up saying there's an invalid field (which has happened to me before when I forgot to complete a required field)... When I scroll
Export report data to a local file / Print report data to the local default printer
My client has two requirements; 1 - to be able to export data from a report to a local *.CSV file - mission critical*. 2 - to be able to print a report to a local printer in formats other then PDF. *When I say mission critical I do mean that if this is not available then Zoho Creator may not be the correct platform for this client. John Fergus It Management Solutions Canberra
Error in quantities while adding items to form
More than an error it is a "weird" behaviour, since quantities are added correctly to the specified field but randomly another field value is changed. In my specific case, while tempting to modify quantity in "Riepilogo_Alimenti" from the main form "Gestione Casa" ( which is a list of look-up fields with conditionals show/hide on load ) a random element quantity is variated. Specifically, adding one ( 1 ) item to the third last object in Riepilogo_Alimenti causes and increment of nine (9) in the
Next Page