add "text:" when inserting new line
In reference to document below: http://www.clickatell.com/downloads/smtp/Clickatell_SMTP.pdf I have a multi-line text box. I want to add in "text:" when entering a new line. This can be done at any stage, as long as it is formatted before the email to clickatell is sent. I would also like to add in if easy enough: - character restriction for line length (not essential) - character restriction for text box
Form customisation - field spacing and position
Having searched this topic, I learned that 4 years ago, form customisation was being developed. I have noted the customisation options, and perhaps this was the outcome. However, I'm looking for some control over my fields eg. when 'from' and 'to' dropdown options are used, where clicking from and to displays times eg. from 9.00 to 11.30 Title data field ________________________ data field ________________________ data field ________________________ data field ________________________
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
Shared App Not Displaying Properly
I've created an application with a free account and I'm attempting to share it to another user. Whenever that user loads the app they are seeing a nested view of the page with two navigation bars and none of the content. Any help would be greatly appreciated.
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
Recovering Deleted Data
Hi, One of our well-meaning staff members went into our Zoho Creator database and deleted a dozen or so records. This happened about a week and a half ago (November 18 or 19). She thought she could simply add them in again later and all would be fine. Problem is these records were part of a relational database and now the hundreds of links between these records (they are "users" in our system) are gone. Is there any way to recover the data and the relationships that have been lost? Mike McIntee
API Code
Hello, Requested and received my API Key. Wanted to link my MailChimp account with the ZOHO account. It did not work, MailChimp tells me that the API Key is incorrect. Could you please help. Thanks. Regards, Daniel
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?
WEB STUDIO 5 WEB SOFTWARE LINK WITH ZOHO
How do you utilise ZOHO database creator using your website as interlink between your clients and database? Lets say you intend to get 100 000 members of your siciety/clients = 100 000 database lines/records. This database would be updated automaticaly when people fill in FORMS on your WEBSITE, pay bills ($ VAULE database record in this case), and some of database records would be calculated values... So you do want your clients to update your database indirectly via forms entries and see READ
HTML View
Is it possible to put 2 table views side by side in a HTML View
Spaces and capitals
Hi, In my application I want to remove uneccesary spaces on input and also change the case from lower to upper (Capitals) Kind regards Dave
email with attachment
If a form has a "file" field, when I submit the form, can I configure to have the file sent to the email recipient as well?
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.
Import data from QuickBooks purchase order
I created an app that tracks the status of projects. The initial information is typed manually from a purchase order generated in QuickBooksPro. Is there any way to export the data from QB and import it as an entry into the form in Zoho Creator? Christopher
Integration of Zoho with Dropbox
I tried using Zoho docs for a couple of months and it really didnt have what I needed. I now use Dropbox which is great. What I want to be able to do is create URL fields that link to files stored on my dropbox account. Is this something you have on the roadmap or would consider. I want the link to be dynamically created so when I click the URL in Zoho the file just opens (assuming you are logged into Dropbox). The issue I have found is that Dropbox does not give a fixed URL unless you specifically
To access the form without login
Previously it work's. Now it's ask me for upgrade. Have you stop giving such facility to free user ?
Subform - Two questions
Hello, I'm starting working with subforms and I would like to do two things but I don't know how to do it. 1) On load picklist subform field based on a main form field value We have a form with a subform that have 6 rows by default. And there is a picklist in that subform. We would like that picklist values were loaded based on other main form field. The main consideration is that we want to that when loading the main form. How can we do that? 2) Is it possible to create subform lines through
I cannot share a form to make it public to all now
Hi, Why now I cannot share a form or a view to make it public to all? As alternative getting a permalink to access the view without login does not work, and instead of getting the typical encripted key it appears a constant or something like this: ZC_PUBLIC_REQUESTED When was this policy changed?
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
Dropdown initial value doesn't work - select always displayed
Hello everybody, Just getting started with this kit, and fallen at first hurdle (APU). I'm trying to replace "select" with something more meaningful to the forms needs. Tried modding the initial value, but nothing changes (edit, options, appearance, initial value), neither does the value I entered appear anywhere (that i can see). Is this a bug or am I doing something wrong?
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.
Newbie question: to create a custom application for product price comparison
I'm wondering if anyone here can help me out here, please? I have not started using Zoho Creator, but based on reading what this application is about, I'm thinking that it may be a good platform to solve our problem. I would like to create an application to allow my staffs to record price comparison details. One can create a new record for any product, and anyone can add/modify details about this particular product. For example, Staff A creates a new product record (say, tropicana orange juice)
Firefox submit form not working
Today the form to submit doesn�t go through in my Firefox 2.0.0.7, but worked fine in IE...I am clueless
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
Select more than 200 records?
How can I select more than 200 records at a time with the user interface?
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"
Is there a way to allow edits of records for a limited time?
In other words, I would like the user to be able to log in and edit their records until a certain date. Is this possible?
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
URGENT - service has ground to a halt!
Hi, The ZC service is running extremely slowly at the moment in both editor and live modes - taking up to 60 seconds or so to load a page or save a script. Please fix and advise urgently. Regards, Anton
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.
Sending mail to form does not apply form when using alias
I'm using one of the forms in Zoho Creator to 'mail' a response to the Creator Application so we - as a support organization - can easily track emails going back and forth. We are currently using the zoho email address associated with the form, but would like to use our own email request-update@company.com to forward to the zoho email address. Even with filling out the alias field I cannot get this to work. Thank you, -Jaap
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.
Picklist preserves previous choices
Hi tech support We have an application (for church service and roster) which contains multiple dropdown picklists. These picklists' choice is empty and dynamically generate items according to choices from other picklists. It all worked fine until recently. What I discovered is every time dynamic picklists generated, selected and submits, the chosen item actually inserted to the picklist statically. After 30 odd times, the dropdown picklist has 30 entries. On the form, using 'clear picklist', I can
Next Page