Does insert command fail to execute if null values are encountered ?
Hi Team, I have a Parent From with foll fields Exec Name Designation Company Name (Drop down with list of existing companies from company master populated at runtime + "-Not in list- " Address City State Website When CompanyName = "-Not in list- "is selected, a text box is shown to the end user to enter the company name Other details are filled.. and form submit. On Form submit, I have Insert command for if(CompanyName =="-Not in list-") { [ insert into CompanyMaster Company Name = input.companynametextbox
Create 2 or more different forms to update same table?
Is it possible to create multiple forms with different field layouts but all saving the data to the same table. As far as I can tell each form is the table itself and only that form can update the table that stores the data. I know that many views can access the Forms data.... My input Form has "Set Email Notification" associated with it that is automatically sent when a record is added. However, my the database administrator needs to add records to the database/form and not have an automatic
Combining Data Between Apps
Greetings, So I have 2 separate apps that both share a similar need, creating educational classes. The equipment that is used in the classes is from the same location.Instead of opening up both apps separately, how can i create a shared view or report to monitor both apps at once? Can i use a stateless form to place data in two separate apps simultaneously? Any ideas would help, thanks.
How about a spot where we can view all the custom script we made in a Creator Database?
How about a spot where we can view all the custom script we made in a Creator Database? It took a while to understand deluge script, but I like it now. Would it be possible to create a spot in the program where we can view all the custom code in one location? I ended up writing so much code, that I had to start copying it to a text editor so I could visualize it all in one location. Just an idea. Thanks, r_gutowski
Form Email Notification Cap
There appears to be an issue when setting email notification for a form. It will not allow more than three email addresses to be included. The workaround I have found is that the limitation is only to each line item. So I can have three on the "To" line, three on the "CC" line, and three on the "BC" line. Is this limitation intentional?
Storing a radio button selection as a number for a quiz
I am creating a fitness survey. A portion of it is nutritional. I think this should be pretty easy, but I have several questions, all of which have the following answer choices: Never Rarely Sometimes Often AlwaysI want to be able to store the answers to each of the questions as a number. For example, Never would be a 0, Rarely a 1, and so on. I want it so that it will store just the number in a column so that I can add them up and give them a score later on using a formula. I can do the scoring
Manipulating data from user input to form
Hey Guys, I am collecting mobile numbers on a form which are inputed in the standard format. When the user hits submit I want to add a "44" to the beginning of the number and a "," followed by a space at the end. This would then be placed in the data column. I am not very good at writing these solutions and would be great if someone could help me out, step by step. Many Thanks Simon.
set up form and embed?
I have s simple form I want to put on my web site, let the reader fill in information and have it e mailed to me. How do I set up the form to have it e mailed to me? Then how would I get it into my website? Dwaine
Pick List Population
Hi, I've been having a problem and can't seem to find a way around this, hoping someone can help. I'm trying to populate a Radio Button picklist (Goal Title) with values from another form, that are based on a value within the current form (Employee ID): varManagerGoals = Goal_ID_to_Emp_ID_Mapping [EmployeeID == input.Reporting_to]; if (varManagerGoals.Goal_Title!= null) { input.Align_To = varManagerGoals.Goal_Title; } For some reason this code brings back EVERY value from within the data
Importing records
Please help. Really like Zoho, but can't seem to upload an .xls or .csv into my newly created database! When i click submit, it says loading and then just returns to the upload screen. It seems as if it might be complete, but when I try to look at my records, there are none.
Open Document in Creator View Online
I want to open online a file in a Creator View uploaded from a Creator form. I cannot do this with either Zoho's own "Zoho Companion" or through OpenIT online. I believe this is because of the way the URL is created through Creator. Does anyone have a workaround for this?
sending form to customer
Why can't our customer fill out our form? They get an 'access denied' error after 'logging in'. We don't want them to be able to change the form just to be able to answer the questions and submit.
Trouble appending data to text field
Cannot seem to get this to work. Fields: Services (multi select) Service_Date (date) Service_Date_List (text) When the user selects [Services] and a [Service_Date], the text "Service Service_Date" gets copied to [Service_Date_List] When the form is submitted, I want to append the info in [Service_Date_List] to the field [COMMENTS] as a log. The following does not work in (on Validate) or (on Success) if (input.Service_Date != null) { insert into Tracker [ COMMENTS = input.Service_Date_List
Formula for a column HELP!!
Im trying to make a column with the following variable (23 - x - y - z). 23 is a base, then I want to subtract the entered numeric values in cells x, y, z (where xyz have been defined by the field name) In the formula field I entered (23 - Sep_2009 - Oct_2009 - Nov_2009 - Dec_2009) But keep getting an error Error in statement at line number 0 The Left expression is of type STRING and the right expression is of type BIGINT and the operator - is not valid here Any ideas? Thanks!
How do I append data instead of replacing it?
I understand how to fetch and change records from a stateless form now, but how can you "append" to a text field from a stateless form? Right now this works to replace: -------------------------------------------------------------- if (input.Service_Date != null) { temp = Tracker [CLIENTID == input.CLIENTIDLOOKUP]; temp.Code_10_Record = input.Service_Date.toString(); } ----------------------------------------------------------------- but I want something like this, which will not work:
Using Zoho CRM Data to Populate Zoho Creator Look up Field
I'm building a simple Creator app to create invoices for our small business. All my customer and supplier details are stored in Zoho CRM. Rather than set up a form to duplicate all my supplier/customer records (which I need to produce the HTML View invoice), I would like to be able to access the Zoho CRM customer / supplier data directly in Creator - ideally by using a look up field to view all customers and suppliers names, and then using the selected customer/supplier name to pre-populate the address
Trying to delete selected records with OnClick in statless form.
Ok, here is my goal. I want to delete selected records with a stateless form. I'm using a checkbox to determine which ones are deleted in the main form. Name of the main form: claim Name of the checkbox: Extended Name of the stateless form: Clean_Up code for On Load of Clean_Up deleteList = claim [Extended == false]; that is a 'fetch records' function. I don't even know if that is the right way to start. code for On Click of Clean_Up cutOffTimeMicroSeconds = (zoho.currenttime.toLong() - 5 * 24 *
help Makin a password recovery
i have made a password recovery where i want to type in a computer number and it will give username and password for a site. and if you havent added your username and pass yet then you go to add_pass but thats where i have trouble. i need to add the input of user name and pass and comp pass to something so that at the 1st screen u can just enter your computer pass and it will pop a screen up saying your username and password.
Intruction on creatiing a html view
Hi! I am a new user of Zoho Creator and reading the instructions to create a html view in step two of the html view definition it says: "..specify the view name and the section under which the view will be displayed .." but I only have one textbox to input that information and I have no idea on the format used to enter the view name and the section. Can you please give me an example. Thanks in advance
Share specific parts of database ONLY - HELP!
Hi I have created a database, and will have 15-20 registered users, but I need each registered user to be able to view only their relevant portions of the database (i.e. John Smith..Project x, Hours worked) How do I do this? do I need to create a filtered view for each user? Please help! Thanks
LookUp Issue
I am trying to create a relationship between two forms. The first form is Donor Information with three fields (First_Name, Last_Name and Email_Address). The second form is Contribution Entry. I have placed three lookup fields in the second form and linked each to its respective field name from form #1 (donor information). Here is my issue. In the second form with the lookup fields, I type in the last name of a person all is fine. When I go to the next field which is the First name look up field
view criteria setting
Hello Support, Could you please check the criteria settings for the 'email view' of the LROC Membership Database (allowed access to support). I only want to see the data of the members who have NOT ticked the 'email opt-out' field. Somehow don't get it to work. Your help would be appreciated. Thanks. Cheers, Daniel
perma-form will not load
hi: I have a private application titled "control_paramount_realtors". in the form "feedback_survey" i have inserted OpenUrl command in the "on_add/on_success" section that is designed to take the user to the form "feedback_submitted". the URL is a form-perma snippet without login requirements, but the script only seems to run if the user is logged in. also the "send mail" command does not work unless the user is logged in.I have tried making the form public, nothing seems to work. i have even
Is my goal achievable
I will be embeding my form onto my web site. I would like to have my visitors that complete a form to have the ability to return to update on a monthly if not weekly basis. Can this person edit their own document, or do they have to become a user? Thanks in advance.
how can i create a header/detail form ?
how can i create a header/detail form , like I navigate to one customer at top, and all his payments would show in the detail section. _ I need to know if that is possible ??
Preventing changes to database by public
How to have public view but prevent adding/changing/editing records ( ie, make view read-only)
Questin about script
HI i am trying to have my application send an email when my formula equals a negativie number. Please help. Some thing like this. if FORMULA =< 0 SEND EMAIL
Currency:
Can the result of a formula be in "currency" format? If so, how do we display this in a view? Thanks, Rich
Auto Delete Record based on Age
I have been working with the scripting feature and I'm trying to figure out how to create a way to delete records automatically based on the age of the record. Any help would be appreciated.
Deluge comments disappearing
It appears that comments I have in my code are being removed. At first I thought I was going crazy, but after typing my comments numerous times, I feel confident in saying that my comments are being removed. It's not all of the comments all of the time. There's no pattern.
Creator Expenses Report question
The sub-categories are not populating with the Category selection. Meaning once I click the category, the sub category has the full list to choose from which is very annoying instead of just the subcategories that are associated with the particular category I selected.
Locking down certain drop-down choices
I'm wondering if it's possible to restrict the ability to select particular items within a drop-down field. Specifically, I have a field that has a long list of months/years to select from. I need to keep those old 2008 and 2009 dates, but I'd like to make it so nobody can ever select a past month once that month has passed.
Expense Tracker Question
I have my layout set up with the Tabbed Pane Left. I have added a few new Reports (Expense Report by Employee) etc. On the left pane it shows them at the bottom. What "View" do I need to modify or change to update the way Left Pane list order? Update: Nevermind... I found it.
In a form, custom function to recalculate a number of fields on update of multiple other fields
I have a form which contains 2 fields (disabled from entry) that I want to update with a recalcuation based on updates being done to anyone of 4 other fields on that same form. Have tried a number of different way, but it seems the only way is to put the code against the 'On Update' action for all of the 4 dependant fields? Thanks in advance
how to set the url field to open in a new window as default?
Hi, in my appliclation i have a couple of url fields, when the users add a record on the list i dont want to let them coose the target of the link, i need the target set as new window as default, there is anyway to set this up? The problem basicaly, is the kind of users i will have, the 99% of them wont have any idea about the new window / same window option, and if they by mystake choose same window, i will have a visual problem because my application will be embeded on another website, so i just
Formula IF or Case
I need a formula that looks at a numerical field and returns a text result. if (FIELD_A),'1','one' if (FIELD_A),'2','two' if (FIELD_A),'3','three' Any help would be appreciated tom
Pass data from form A to form B
I have a form called "Add Showing" (form A) When the form is submitted, an "on success" script autosends an email to a recipient specified in the form. In the body of the email is a link for a form entitled "Feedback Survey" (form B). Both of these forms have a field entitled "Property Address" When the email recipient clicks on the link to open form B i would like the Property Address data from form A to populate the Property Address field on form B. Is this possible? P.S. right now i am sending
Help Plez before I Jump
Hi Anyone Just made a form with a calendar and e mail return for my site. I am now lost, it looks ok, but how do i know it works?, how do i get the code to put it into my site. Been at this for 3 days now, love the form but Im totally lost now, can anyone help as I’m quite new to this. Plz help me Regards Euni
Make form public but view private?
I just created an application to prescreen job applicants. I want to send them to the form without having to sign up for anything, but keep the view hidden from them. So basically the form should be public for anyone who finds that URL to be able to submit, but the view would be limited to users. How do I do that?
Changing the value of zoho.loginuser
For testing purposes, it would be great if a developer of an app could change the value of zoho.loginuser. I've written an app that behaves differently depending upon who the user is. For testing, I have to login as each person to verify their roles. It would be better if I could simply change the value of zoho.loginuser and effectively become that other user without logging out and back in so frequently.
Next Page