Allow more space for form name in edit mode
When in edit mode for a form the form name appears above the code. However only the first 15 characters of the name are shown. Can this be increased or the full name show when the mouse is over the name. Herb Wexler
Carriage Return in list view doesn't show in html view
I have a form with a couple multi-line fields. They commonly get carriage returns just with an "enter" key during input. In a list view, those line feeds show up correctly. But when I pull those fields into an html view with a fetch, the line feeds don't show in the html view. Am I doing something wrong, or is there another way to do this? Thanks for any input...
Help on inserting capital names in single text box
Hi, i have a problem, i have a single text box where i insert names, is there anyway i can make the box give error if the name entered does not comply with a list of name i have in a form? or do an if not equals name condition? e.g. i have several names all with capital letters JOHN JAMES EMMA TIM but if the user inserts john or james or James or ja.mes or ema, Ema, Emma, resumming if does not match the name in capital it can´t be inserted.
Scoring Application
Hello, I am asking this question to see if what I am looking to do is possible before I waste a lot of time and effort trying to make it work. I would like to create a scoring application to track the results of a competition. There will be multiple athletes competing and there will be multiple events. Each event will be scored and the athletes will be ranked depending on how they perform compared to the other athletes in that same event. I have created a form for athletes and an event. I can enter
Opening an email using deluge script
Hello, I'm trying to set up an app to track on call staff members. One of the functions I would like to have is the ability to have a script open an e-mail addressed to a specific address using my computer's default e-mail client. The reason for this is that the e-mail address I would be sending to is an internal address that can't be directly e-mailed from outside our network. If the script were to open an e-mail using the default client (for all users, this would be Outlook), it would allow them
Zoho creator to Zoho reports
I have successfully linked a creator form to a zoho databe but are only aple to pull text fields and not the number or decimal fields. Has anyone had this issue? Pleae help. Regards, Michael
Clearing / Resetting an iframe
I've created a stateless form with 4-buttons - each button, when clicked, populate an iframe ("form-iframe") with another form. I'd like to tack on a "Reset" or "Clear" button that will refresh the iframe back to it's blank state. I tried blanking out the URL in the iframe parameters, but that didn't do the trick. Any thoughts?
On Update : Lookup error...
Hello ZC Team, I have a problem trying to call a function on a lookup field, I can sucessfully invoke and use on the user Input action but when I try to use same code on the "On Update" action I'm having problems: My code on de User Input is: list = base_de_curriculums.gconsu.gclistaconsultores(input.Skill_Disponible); Nombre_Consultor:ui.add(list); This is working very nice- Now I want same but in on Update, message error say" was expecting append, I change add by append and message say
Check number of entries in the database
Hi, I have a form to input a list of location with date. Now i want to consolidate to see which are the location i frequent the most, therefore I want to design out a form to list down the list of location with the number of time visited beside. How can I do so? Thank you.
update a row in zoho reports from zoho creator
Hi, i succedd add a row in zoho reports from zoho creator but can't update a selecting row. I wrote this deluge code. Where have i made a mistake please ? trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); mapResponse = zoho.reports.updatedata("BASE", "Table", trans1, "AFFECTATION ANALYTIQUE="+"'"+input.AFFECTATION_ANALYTIQUE+"'"); TY
update data in reports from creator/ criteria
I understand how to update data in a zohoreports table with the deluge tasks zoho.reports.updatedata ( BASE, TABLE, map, Criteria) but i don't success to use a criteria depending of the value of an input field. My example is : trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); a = "AFFECTATION ANALYTIQUE='" + input.AFFECTATION_ANALYTIQUE + "'"; mapResponse = zoho.reports.updatedata("BASE",
My Wish for 2012: Concurrent User Subscriptions
This is my wish for ZOHO Creator in 2012: For domain level accounts, offer application-level sharing for a limited number of concurrent users. For example, a 5 concurrent user plan would allow one admin and four active users to simultaneously access applications. If another user attempts to sign-in, he would be denied until one of the other four users signs-out, or until the admin deletes a user from the account-level share, or until another user logs 15 minutes of inactivity (no page refreshes or
3 small issues remaining
Hello, I am very very close to finishing my app! My Director is very impressed with what I have done so far - I just need some help with 3 outstanding issues that I am having. 1. - Filtering Issue numbers. I have 3 forms in question, Drawings, Issue_no, and Work_Order. When the user creates a new Drawing in the Drawings form, they also create a new Issue no in the Issue_no form which is a sub-form within the Drawings form. When the user selects the drawing from the Work_order (via. a look-up field)
Re get data FromSQL 2000 by getUrl tasks
Hi Akash: This is a http link through a query from SQL 2000, and then use the getUrl parse the xml file in the creator, the format is the basic reference creator to help complete the test data seems crawl, but can not display the data and found a different format, as follows 1，the sample from zoho creator 2，the sample from my link Grab the data format is as follows： my function code as follows： string test() { sm = "<table class=table zc-viewtable>" + "<tr class=zc-row-header>" + "<td class=zc-viewrowheader
Stuck on Fetch/Update Records to add a number value to a record (Sports-focused developers, please help - images provided)
Hello, I'm having trouble figuring out how to update a record from a value entered into a subform. I'm going to explain the process in plain English and my problem (I'd rate my skill in deluge as "low intermediate") 1- My "Game Score Entry" form is used to enter and update sports scores using a lookup field that contains entries from a "Team Info Entry" for the team name. 2- To keep in-game stats and attendance for individual players, I have a "Goals/Assists" subform with a lookup field that clears
Funtion for Currency Fields
Hello ZC team; I have this situation, in Application B I have a form with fields like: Name, Contract Number, Customer, Rate,etc. On Application A I have a form with lookup field Name, Contract Number, Customer, and other fields like Price,etc. I need that when I select the field "Customer" in App A a function is called in order to fill Price field from the valued stored in App B (in fact rate field). Both fields are currency type (Price & Rate). The link in both applications is the Customer which
How to format currency fields in HTML view
I've created an HTML view. Some of the fields I'm showing are currency type, but they display as regular numbers. Example: $42.00 shows up as 42. The tax shows up with all 4 decimal places. Is there any kind of format function that would allow me to show these fields as currency in the HTML? Thanks.
Auto Filters not working
A number of auto filters on my application have suddenly stopped working. I have emailed details to support and need this investigated and resolved as matter of extreme urgency.
Use Same Subform Twice in Main Form
Is it possible to use the same subform twice in a main form? I have already created an application in which this is the case, but the scripts that worked in the on user input of one of the first instance subform fields will no longer work now that I've added the second instance of the subform. Each instance of the subform has a different name. Another peculiar thing is that the subform contains a picklist that I've dynamically added to in the on load section of the main form. That works. However,
Fetching data
Hello, I have Googled and searched your forum for an answer but I can't seem to get the code to work. I am either looking at this wrong or making it difficult for myself. I have 4 forms Drawings; Material; Purchase_order and Work_order The Material form has been put as a sub-form in the Drawings form. There is a field in there called "size" which is a single line text I wish to "fetch". In the Work_order form the users selects a Drawing number from a Look-up field which is linked to the Drawings form.
Convert String to Time still having problems
This is the error message I get with the following script, please help? It worked fine for the first few reservations, this is the application Copy of Reservations form Reservations { field alignment = left column { First_Name ( displayname = "First Name" type = text width = 200px ) Last_Name ( displayname = "Last Name" type = text width = 200px )
authorization problem in record-edit
Good morning, I have build a small application with zoho creator, and I have shared some forms with other users. In only one case I open a form in record-edit mode via Editing Records via Record ID using (http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>). When I use this function logged with administration grant, it's ok, but when I use this function logged like another user, the system generate this error: You have logged in
multiple lookups - data consolidation
i am trying to organize information about the training sessions of athletes, i have a lookup field connecting a certain days workout to a certain athlete, but sometimes athletes work together - how can i link the days workout to both athletes and still be able to get streamlined search / graph results? i have tried multiple lookup fields (athlete 1 / athlete 2 / athlete 3 ) but sometimes "john" works out alone, or may be logged as athlete 2 or athlete 3 on other days workouts, i would like to be
Comparing Strings
Hi How do compare strings such as if string1 begins "s" { string2 == string2 + string1; }
My convert date and time is working intermittently
Hi I am getting error messages from my application that I built to make reservations. It worked perfectly for the first 10 reservations, then it started throwing out error messages and started to work sometimes and not at all for my staff. Maybe the 7:00 am needs 0's? like 07:00am to convert the date time string picklist to a Zoho 24hour time calendar? Currently I turned off all of the scripting using the // marks, but this is what the script with action looks like form Reservations { field
Data from 2 forms displayed in one view or report
Hi, I'm trying to get data from 2 different forms to display either in one view or report. I have one form which has details for properties on the market including the asking price of the property. I have another form which has potential buyers details including the maximum they are willing to spend. What I would like to see is a view or report grouped by properties with a sub-list of potential buyers for the properties based on the amount they are willing to spend being higher than the asking price.
Subform - Invalid Entries Found - Please Correct and Try Again
Dear All, I have added a subform to my main form. Every time I try to submit, I get the following error message "Invalid Entries Found. Please Correct and Try again". I notice that some others have had a similar problem, however I couldn't find a solution posted. For reference, Im using Mac OSX and Safari. Any help would be greatly appreciated? BW, Mike
AddMonth question
What value is AddMonth supposed to return when it overlaps into a month in the next year? For example, I am adding 3 months to a date field and the date is in October. I expected it to return a 1 for January but instead it returned a 3. Can you help me on this?
Calculating total hours
Hello, I need to calculate the total hours on a Works order form I have - but I am unsure how to fetch the data. The app work's like this: A form called Machines has the run time of each item identified by the Drawings form. This is linked with a field called Drawings_no There is another form called Works order which the user selects the from drawing_no field and enters a quantity then I need Zoho to do a small calculation of the quantity the user entered times the run_time stored on the Machines form.
On Mouse Over anyway to achieve something similar within Views
Hi, I have Zoho views for my data and if needed i can have HTML views in place Would be very very nice if my user can put their mouse on a record and see some additional information In my case mouse over a room record and see the name of the occupant As i understand Java script is no longer supported in Creator has anyone found a way to achieve this Thanks
Splitting a big form into multiple forms, then sending all data to just ONE view
Is this possible? We can't get around General error, message from server: "Got error 139 from storage engine" with our big forms (HUGE annoyance, by the way -- Formstack doesn't have this issue!). Therefore, we want to split our big form into maybe 3 smaller forms, embed all 3 in our site and then have all 3 populate just one single view. It would be way too time consuming for our client to have to search through 3 or more different views to get data for just one application.
ID usage question
I've been trying to make sense of the ID field and hope someone could straighten me out. Simple process: Input information into Form_A ID record is populated in View_A Ok, that's easy enough to understand Now, where my question lies is how to get View_A.ID to follow a record through several forms? Technically, I'll be using a UNIQUE IDENTIFIER, in my case "Opportunity_Title". This field will be referenced in every form beyond Form_A as a it steps through each stage of the process. As each Form_n+1
Populate separate field from the drop down
I have a pick list for Mfg, when I choose the Mfg, I also want it to populate the Mfg Phone, Phone being a separate field. Mfg ( type = picklist values = manufacturers.Manufacturers.Manufacturer displayformat = [ Manufacturer ] allow new entries = true [ displayname = "Manufacturer" ] sortorder = ascending searchable = true width = 206px on update
Get input parameter from current URL into iframe
I cant seem to get the code right to get the variable from a non-zoho-based URL into an iframe for instance a person has come to my microsite from a a parent site (which has passed a parameter), this has put them on a landing page with the following address www.MyMicroSite.com/UserName=JohnDoe the page itself is built in Wordpress and has zoho iframe snippet on it. I want the zoho form (within the iframe) to accept the variable JohnDoe from the URL and populate the value in the field called "userName"
Usage Limit Exceeded
My application has just started reporting usage limit exceeded messages. These messages are incorrect and my application has stopped working. Please contact me immediately to resolve this. My username is paulansell1965. I will email support with my contact details but am sure you already have them
Add a record through the html form
Hi, im trying to add a record through the html form with using curl, i read all guides, but it doesnt work here is the code: if(isset($_POST['button']) && $_SERVER['REQUEST_METHOD'] == "POST") { $message = strip_tags($_POST['message']); $_SESSION['message1'] = $message; $fname = ucwords($_POST['first_name']); $_SESSION['fname'] = $fname; $lname = ucwords($_POST['last_name']); $_SESSION['lname'] = $lname; $companyname = ucwords($_POST['company']); $_SESSION['companyname'] = $companyname; $address
How to make a View column with a display name and an underlying URL?
I have form/table with several hundred rows with two fields: Advertiser_Name (example: "Ford") Advertiser_URL (example: "http://www.ford.com") When I create a View including the above columns, how can I show JUST the company name, but make it a clickable link with the Company URL? Normally, I would create the following: <a href='http://www.ford.com' target='_blank'>Ford</a> I assume I can do this in the "View Definition" screen. Is that correct? Please provide instructions and a code snippet.
Parse variable from current URL into iframe
I cant seem to get the code right to get the variable from a non-zoho-based URL into an iframe for instance a person has come to my website from an adwords campaign, which as put them on a landing page with the following address www.MySite.com/AdCamp=ID2 the page itself is built in Wordpress and has zoho iframe snippet on it. I want the zoho form (within the iframe) to accept the variable ID2 from the URL and populate the value in the field called "referring_source" in the embedded form. How would
Change a Single-Line Text field into a Multi-line Field w/o data loss
Is it possible to change a Single-Line Text field into a Multi-line Field without losing data. I have a form with data for which I would like to change a single-line field into a multi-line field but I'm worried it might delete the pre-existing data. Thanks.
Stateless form Buttons 2nd row?
Is it possible to add a second row of buttons in a stateless form. Both Chrome and FF will automatically wrap a single row of buttons if the screen is not wide enough to display all the buttons. However IE 8 & 9 do not wrap the buttons. Another solution would be to add the ability to logically Hide buttons. This gives the ability to only show buttons that are relevant to what the user has entered on the screen. Another solution is for IE to work like FF & Chrome.
Next Page