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
ZOHO Creator
It's too bad that I can't use an icon for a field; ie. a paperclip to indicate an attachment and a yellow note icon to indicate a note. betty
Formula Field Update Frequency
My app is designed for elderly people. I need a formula field displaying how many months have passed since the record has been updated. But my formula will always display CERO because the record is updated everytime I try to update the formula field by giving the order r.formulafield=r.formulafield; ¿What is the "updating frequency" of the formula field ?
Views can't display data of two identical subforms
Hi, I need to use two subforms in a same parent Form. Those two subforms use the same form (there's just one column displayed alternatively [Stock-in and stock-out for example]) All works fine, except in the views. To display subform data : it's displayed in one column and is concatenated (like this : SubFormData1SubFormData2), instead of two separated columns (SubFormData1 | SubFormData2). Even in XLS Export, I use exportDisplayData=false to have data in separate tabs, but it creates only one tab,
downloadable scripting instruction manual
Is there a downloadable version of the scripting language? It is extremely difficult to determine an exact question that asks precisely what is being researched. For example, I have designed a form that has a dropdown with data from another form. I want it to display the dropdown information, but I also want other fields to populate based on the data selected from the dropdown box. This should not be a difficult procedure, but finding the answer in the knowledge base is difficult
How to update a boolean field via XML RPC API
Hello, how would I pass a boolean value to the XML RPC API, if I want to update a boolean field (Decision box)? When I use the following XML <ZohoCreator> <applicationlist> <application name='TestApp'> <formlist> <form name='TestForm'> <update> <criteria> <field name='ID' compOperator='Equals' value='519261000000601003'></field> <reloperator>AND</reloperator>
Copy Name from form to sub form
I've read through all the topics, but I cannot get it to work. Seems to be simple. Main form is named "Contacts", sub-form is "Invoice". I just want the field "company" to populate into the sub-form. on load on "Inventory" Input.company = company.company Help please!
Link PostGreSQL
Hello, Is it possible to link a PostGreSQL database to forms etc written with Zoho Creator? Thanks, Jen.
Which plan should I get to start a business?
Hello, I plan to develop a baseline app and sell. Assuming each customer has 5 users, and there are 2 customers, A and B. Does that mean I'll duplicate my baseline app twice for them? If customer C requires customization, I'll duplicate baseline app and customize for them? So now I have 4 separate apps right? I would like to bill customer separately, and just give them user IDs and passwords to use the system. In other words, I'll be meeting prospects face to face or through phone to sell my app.
how to round robin like functinality in leads
leads gets a number from 1-6 and after it again number starts from 1 and end on 6.
Print Views
It would be helpful to be able to select a record from List View and print the detail of that record in a nice format. Right now, I have to open it for editing, highlight the fields and then print selection. How about a print button on the record summary screen? A print button on every view that would popup a version formated for printing would be another nice option. I tried limiting the summary view to just one record, but it only works if that is the default view.
Single record view
How can I create a single record view in Creator that shows the fields of only 1 record? Thanks!
Trying to wright to Subform field inside a "for x in" loop
In the code below, the "Notes" field is a Subform field I'm trying to wright to when an auto reminder email goes out. I can't get the syntax correct to access the Subform field. What am I doing wrong? The Main form field name is "Notes" and the Subform field name it wrights to is "Notes" I've tried y.Notes.Notes, row.Notes, y.row.Notes ******************** for each y in test_emails[Received] { y.Notes = zoho.currentdate + " Auto DEL notice"; // Trying to create an entry in Subform field "Notes"
Schedules Attach Summary View as PDF
Is it possible to attach a summary view to an email in the Schedules section? Currently it convert the Summary view to a regular list view. Herb Wexler
can not access the application in Zoho creator (account stanleyguo) from China
Hi I can not access the application in Zoho creator (account stanleyguo) from China, but be able to access Zoho Home,also can access creator application through Special VPN software, I do not know what happened has been a smooth access to the creator application, can not access from yesterday. Have any special status? Waiting your help and thanks Stanley Guo 2012-3-12
Next Page