subforms
when I create a subform for a parent_form, I call it child_form. One record from the parent_form is linked to multiple child_form records. So the linkage between the two forms should be in an "associate form" ,right? Where do I find the information about this associate form? Second, for the child_form, can I create a lookup field called "parent_form_id", and have the field auto-populated, non-changeable, with the parent_form ID field value for the parent_form record being updated? Thanks!!!!
Fetch and Update
Greetings All, Can someone point me to a clear explanation of "Fetch and Update"? The link http://help.creator.zoho.com/Fetch-and-Update-Records.html is extremly vague. Senario: I have one form that will be storing data. I will be using a different form to collect data. My work is as follows: 1. Complete "Form A" "Form A" will have several fields that will not be completed initially. 2. "Form B" will be processed multiple times. Each time "Form B" is processed, I will
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
HTML View
Is it possible to put 2 table views side by side in a HTML View
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?
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>
Deleting entry with a field, possible?
Hello, I have a barcode scanner and I'm creating some entries in the database with it. Is it possible to make a field where you can delete the original entry when you enter the same barcode. For example I have "7012345" entry in the database. And i go to "Remove barcode" field and write the same "7012345" number and it deletes the entry from the database, so I don't have to go and select the "7012345" entry and click delete. Thanks in advance
Make your HTML views (appear to) load more quickly
Just a small trick I discovered the other day... When you embed a view into an HTML view you get a piece of code that looks something like: <div elName='zc-component' viewLinkName='My_View' params='zc_Header=true'>Loading View...</div> In this case, when the user loads up the page, they'll see 'Loading View...' for a second or so, then the view itself will pop onto the page once it's been fetched from the Zoho servers. As I discovered, you can replace 'Loading View...' with anything else and Zoho
If condition upload field in subform
Hi, I've problem with script that on validate Alert that it's necessary to Upload a document in field3 (of subform). //if (((input.Field1 == "Option") && (input.Field2 == "-Select-")) && (Subform.Field3 == "")) //{ // alert "Insert a upload document!" // cancel submit; //} The script don't run, Any help. Thanks. Mic
Date format
Hi, anyone know a on input/script to automatically insert slash to separate dd mm yy. I explain, I need facilitate the life of the user and transform a date inserted as a number like 010212 in 01/02/12. Also I need ignore the date when people choose to insert it in the correct mode like 01/02/12. Is too complex? Anyone use similar script? Thanks in advance. Mic
'Duplicate' record button in Grid View
There doesn't seem to be a 'duplicate' button when viewing in Grid View, the 'duplicate' button only appears in List View. For my app, I sometimes need to duplicate records very often and change some fields for each duplicated record. Normally, what I've done is to select the record in List View, click duplicate record, then manually edit each duplicated record. Ideally, if I could duplicate the records while in Grid View, I wouldn't have to manually open up each duplicated record to edit the fields,
How to add line separators
Hi.. I am trying to run a small survey using Zoho Creator. There are about few questions, which can be logically grouped into a few sections. In the survey, i want to add a line in between each section, to improve readability and make the form look cleaner. However, I just cant figure my way through. I am really new to zoho, just been using it for 2 days. so please bear with me as i learn. Regards Sreeny
problem with dynamic lookup picklist
How I want to create a dynamic lookup picklist based other field entry? for example, If State A is chosen, list of City under State A will be listed if and only if entry for Enable field for that City is "Yes".. if Enable field is blank or "No", the City will not listed.. i have tried a lot methods but still doesn't work.. thanks..
Pop up window
Hi, Is the a window that can pop up and allow you to answer yes or no then take the answer bach to the form Thanks Nigel
Form view criteria help please
Why wont the following form view criteria restricted records work? Date_Collected is formatted to zoho time field. ((Date_Collected < 'zoho.currenttime')) So in my head this should stop all jobs that have been collected from displaying in the jobs view. Thanks Nigel
How can I have Zoho Creator Data automatically entered in a Zoho Docs spreadsheet?
I set up a paypal payment through zoho creator and would like the info (conditional to choice made in a drop down box) and payment amount automatically entered to a zoho docs spreadsheet that is embedded in a private page so customers can see their balance in real time as payments come in. Does anyone know of a quick way of getting this done? Any help would be appreciated.
Zoho not working
Cant get access to Zoho Creator, are the servers down. Please advise as I cant work.
Printing one record per page
I have a view with a list of customers and products. I have grouped products by customers but now i'd like to print the list in defferent pages for every customer. is this possible?
How do I create a keyword list based on user input?
I need to be able to have a list of all keywords that have been entered popup so people can choose from existing keywords, or add their own, the way Google blog does. How do I do this? Is there an "other" feature in the value checkbox lists that people could put in their own words for categories etc.? I have to fix this to finish off our database and "go live. Help! Thanks, CatherineTodd, ctodd1000 at gmail dot com.
Calendar - Start & End Dates - automatically populate the dates in between
I wanted to use ZOHO Creator to build a holiday request system for my team, so they can request holidays, I can approve them and they can see everyone's bookings on a calendar view. However - I ran into the same problem that it looks lilke many 'Zoho-ers' have come across in the past.....at best you can register a START and END date in a calendar view.....but difficult to get the days in the middle - without manually entering a record for every day. Having looked through the forums & discussion boards,
Enabling editable fields
I have a table with a lot of columns, and I choose to fill out the data by constructing views with many of these columns filtered out. I would like to be able to be able to click "edit" and only have those fields that are visible on the view be editable in the form. Instead, to accomplish this, I have to change the "disabled" and "hidden" fields in the script. This becomes unmanageable quickly. Is there a way to have editable views with ONLY the fields that are visible on the view without having
E mail editing records
Is there a way of enabling my users to edit the information they've sent in earlier by email?` Say they send in a form containing among other things a company name which in my database will be unique, can I in some way let them use that to alter the rest of the record on the company through email on a later point using that company name? If not is there an easy way to merge the information of two records into one record?
Is it possible to create HTML Page View to print out certain CELLS within a ROW or Export it with XML?
Hi, I wonder if it is posible to create HTML Page View or Print/PDF button which allows to print only certain cells within a row OR Export certain XML data like XML Zoho RSS but only for a row NOT for the whole data list I have a special PDF form to print out a Visa to Kyrgyzstan http://www.kyrgyz-embassy.org.uk/print.pdf which imports special XML data sample XML is here <?xml version="1.0" encoding="UTF-8"?> <VisaForm> <!-- ****************************** name: JOHN surname: SMITH born: 1950-12-25
Alert not working
This is not working since your update if (count(Customers[Address == input.Address]) > 0) { if (input.Input_Type = "From Job") { alert("This address is already in the database, click ok to go back to the job form"); rec = Customers [Address == input.Address]; input.Address = rec.Address; openUrl("#Form:Job?Lookup_Customer=" + input.Address, "same window"); } else { alert("This address is already in the database, click ok input another
Lost all my Content
Help. Logged in a few days ago and all my database content is gone. Forms are still there but data is missing. Has it been compromised or is it a technical issue? In Canada. Lost important data. ------------------------------------------------------------------------------------------------------------------------
Field Number
Hi, anyone may suggest how to display in the number field the zero (0) at the beginning of the number string? And also, anyone know if exist an option to format the number as this example: 000.000.000-00? Thanks!! Mic
Need help with null values
I have two fields that I want to add. Deposit 1 + Deposit 2 = Total, however one or the other might not contain a value. How do I get it to add to give me a total if both fields are not completed?
Login for users - basic question
Hello, My company is looking to use Zoho creator to collect sales reports. I've created the necessary form, but I am wondering if each sales person can only have access to their specific sales reports and not every else's. In other words, when one of our sales reps logs in, I want the form to know it's them and only show them their reports in the spreadsheet view, but have managers able to access everyones reports within the company. Is this achievable? Thanks everyone!
Mail merge
Could someone please create an example so we can grasp the idea of mail merge in Zoho Creator. I have a for with Name, Address, Telephone No and Email. I have a form with a multi line field that I want to include a mail merge so each email is personalised with the name and address. I then want the text in the multi line to be emailed to the correct email for each recipient. Thanks for any help you can offer. Nigel
How to automatically insert a value into an email from a completed form
I made a simple form to retrieve lead data for an upcoming show, see the form: https://creator.zoho.com/millward137/medtrade-vegas-2012/# The first field is "First Name". I need this information to go into my email that I send to them from the view area but can not for the life of me figure it out. Please help. Thanks,
searchRecords & updateRecords of SalesOrdes in CRM
Hi, I want to search records and & update this Records of CRM's Sales Ordes from my Zoho creator, But the searchRecords("SalesOrders") don't supported. And also for updateRecords("SalesOrders") don't supported. How can I do my task? Can anyone help me?
Gantt Chart in Zoho Creator
Hi Guys, Is there any way to make gantt charts from Zoho Creator data ? I'd like to make simple chart with multiple StartDate and EndDate for each task. See the picture. Maybe with Zoho Project ? Or other web service ? Any tips will be appreciated. Thanks. Pascal
conditional information in Email
Hi, I use CREATOR forms and its Set E-Mail Notification (under More Actions Menu). I can insert any form fields in the e-mail. I want to replace the information from the field depending on the value of the field in the mail message Here is the example If the value of input.field1 equals/includes etc "Yes" then I want to place the text "You are joining to the party" else I want to place the text "You are njoining to the party" into the mail message Is this possible? Regards, Aydogan
Update Zoho Campaign member status from Creator
Hi, Is there a way to update Zoho Campaign member status from Creator ? How can we get this variable ? Thanks. Pascal Veilleux
prevent a user to record/submit a form more than once by the same user
i need to make a form that cannot be completed by the same user twice , regardless of what he will do, something like an ip banned, or for a period that i set and to be able to edit that period anytime with any values. pls help me !!!
adding a row (not column) of numbers
Hi I have a form with multiple columns, marked Jan1 to Jan5, and TOTAL. Let's say that in Row1, there is a '1' under those columns Jan1-Jan5. Can I edit the TOTAL column to get the Jan1-Jan5 total of 5 ? It seems a simple request, but I'm just getting familiar with Creator and can't be sure it exists... Thanks Paul
Question from newbe
I made a html with 3 slideshows with the help of the Beginner Demo of JQuery Cycle Plugin (see below). But I don't know how I can get rid of the text which comes in view when the htlml is shown: $('#s1').cycle({ fx: 'fade', speed: 1000 }); This text seems to be necessary for the code. How can I hide the code? Can anybody help? This is the code: <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"
Is there a way to have a checkbox fill a text box?
Is there any way to have a single line text box fill with the choices from a checkbox list and have them separated by commas?
Can I add organization information into Saasu from Zoho-Creator?
I have an account in Saasu. And also have an account in Zoho. I created an application in Zoho-Creator. In that application I am trying to insert new Organization records in the Saasu account. How can I do this? I have the webservice key and fileId of Saasu. Can any one help me?
How to pass URL field value to Zoho Creator XML RPC API
How do I pass the value of an URL field to the Zoho Creator XML RPC API, e.g. to add a record? Regardless how I specify the URL, either as "naked" URL, as HTML link <a>, or as CDATA section, I'm always getting back an error "Failure, <field name>*Enter a URL value for <field name>" Thank in advance!
Next Page