Multi Line --> List
Hi, How can I convert data from Multi Line field into a string list (each line in multi line field to one list item)? Thanks for help, Leszek
Dynamically Updating Subform Links
Hi there, I'm having trouble updating systematically updating parent form links according to new subform information. I have a parent form, FORM A, which has the main information about an organization, address, phone number, etc. On FORM A, I have a subform, FORM B, which would contain transaction information. Each transaction contains a ton of information so I want to be able to add transaction information individually without having to go through FORM A each time. Because FORM B is also a form
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.
Formula - Net amount from multiple options
I have tried, and (probably stupidly) failed to create a formula that fulfils the following function. It is really a postage type formula. The following fields must be filled in by the sender: Letter type: *Postcard *Letter *Package Letter size: *small *large *packet Location: *UK *Abroad - Europe *Abroad - World I would like a "net value/total cost" type field to update depending on the combinations of options chosen. Apologies if similar questions have been asked before, but I would appreciate
Grabbing variables from URL Query String within functions
Is this possible? I have a custom action button set to appear on each row of a view, and as part of the action I want to be able to take some values from the record in question, as well as a parameter from the URL query string. I know this can be done in HTML views with parameters but is there any way to do this with a standard function script?
Image Field
I am creating a database for resources at my school, and am going to enter details such as name, location, etc. I want to enter a small image of each resource, so included an "Image Field", but can not seem to get an image to load. What am I doing wrong? Am I missing something obvious? Any help would be greatly appreciated. Thanks.
Searching creator app via mobile
I developed a creator app with multiples views that have the search function available. When I access the same creator app via my mobile phone, I cannot do a search in the same views. I don't see the search function anywhere. Can you please advise as to what to do since I need to be able to search for records via my phone. thanks, Ray
Variable not passed to subform record after the 6th record is added.
I have a subform that receives a value "Country" from a selection in the Parent form, when a record is added to the subform. The following script works up to the 6th record then fails every time on the 7th and stops the form from being submitted with an error. The attached screen shots are from the same page but it was too long so I had to capture into several consecutive images. There was a 4th image but just found that 3 attachments are max. ************* Code to pass Country to Subform record:
Filtering a View while the filtered field does not show up in the view. Is it possible?
Hi, I understand that in order to filter a standard view that is posted in an HTML view, it is necessary to have the field I want to filter for, active in the view. If this field I want to use for filtering is something meaningless to the user, say for example the record ID, I would preffer if the field actually does not show up in the screen taking valuable space that can be used to diplay more usefull information. If I diselect the field though then the filtering does not work and I end up with
Picklist behavior is strange and not working.
I pass a value of a Deal to a form to be looked up and then populate the lookup using the following code. if (input.cmd != "") { //input.cmd is the deal ID passed. theDeal = Deals [ID == input.cmd.toLong()]; input.Deal = theDeal.Deal_Name; }This is not working anymore. (I haven't touched this code in a year!) Also, why do these two drop down look different?
Open URL with Http Header
Hi, I would like to write the user help documentation with an external tool. I choose Google Sites - it's easy and looks good. Our costumer needs security, so site pages cannot be public. Then, I try to open the desired site page passing the authortization as http header. When I use getUrl it works fine but, then I receive the html page as text - I dont' know what to do with it. When I use openURL, ops, I cannot pass http headers. Is it possible to pass http headers to openUrl function? Is there
Search button on the views is not working.
This morning the search button was working fine, then stopped working. I've been trying the search button several times during the day and is not responding.
De- Dups, DeDuplicating, Removing Duplicates, Eliminating Redundancy
Stamp out and obliterate redundancy! I use Z Creator to keep a large database of addresses for a free snail-mail newsletter I use in my marketing. I am always trying to add names of new prospects, delete defunct prospects, and, in general, keep the list clean. I currently de-dup by dumping the list into a spreadsheet, sorting the various columns and using a simple formula to check for possible duplicates (If A2=A1 Print "Duplicate"). I then scan each possible Duplicate and decide to drop or keep
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,
Excel Query
I know that a form can be exported to Excel but can Excel directly query a ZC form?
zoho creator
hello I need to know how I can display "product name" when I select their "product code" in a formalaire know that I exrtaire code "Zoho CRM" to "zoho creator"
number format
Is it possible to change the numer format I am inputing times of min.sec.decimal such as 1.01.34 is this possible and how do I acheive it thanks Andrew
Drop downs autofill on subforms question
I have a script on a form called billing form that autofills information from a Form called Add Kids Form and Add Parents Form I understand this does not work on subforms because of some issues and I've read up on it, but I still don't understand how to implement it on a subform. Can you please help me rewrite the code below so it would work on a subform? And please tell me where to place the code. Thank you. the script is: if((input.Select_Child != null)) { rec = Add_Kids_Form[ID == input.Select_Child];
How to parse json string in Creator application?
In many case, zoho.crm functions just return json string, such as: 1, zoho.crm.searchRecordsByPDC 2, saleItems in following code, saleOrders = zoho.crm.getRecords("SalesOrders"); for each saleOrder in saleOrders { saleItems = saleOrder.get("product"); } How to parse json string in Creator?
Viewing multiple records associated with a single record in another form
How do I create a filtered view of records which are associated to a single record of another form? I want to be able to click on a record from a list and be taken to a view of multiple records that are 'linked' to the record I click on.
zoho.crm.getRecords("SalesOrders") bug?？
There are TWO sales orders in my crm, one has TRHREE items in product details and another has just ONE item in product details. I've following code : salesOrders = zoho.crm.getRecords("SalesOrders") ; for each salesOrder in salesOrders { info salesOrder; } I'm confused that why there are 3 records in salesOrders? It seems that there're 2 records for the sales order which only contains one item in product details: one is for the sales order itself, another is for product item in the sales order.
View photo while entering data
I'm trying to create a simple app that allows me to view a photo on one side of the screen and enter data from that photo into fields on the left side of the screen. However, the only thing I've been able to do so far is to see the photo next to uneditable fields. In order to enter data I have to click on the "edit" link which then covers the photo with an editing screen and prevents me from easily seeing the data in the photo. Anyone have some ideas on how I can do this? Any help would be greatly
Deletion of Fields
Hi, seems that the deletion of singel records does not work for me as well, as for some other users before me. I check the records, click delete and the loading logo spins forever. any hint? thanks, stefan
Creator Form Design
Hi I looking at creating some data entry forms which have quite a few fields which will take them over the page. To keep the formatting clear it would be ideal to mix some sub forms in too as well as using the column formatting. It appears from investigations that there is a limit of two columns to per form which I can work with but I'd like to know if there is any other formatting that can be used with columns. I can't find any further documentation. This formatting also doesn't play nicely with
Creator: Tables in forms
similar to https://help.zoho.com/portal/en/community/topic/question-in-table-form I want to be able to add values into a table for various categories over a period of time so we have something like this: 2008 2009 2010 2011 cat a <field> <field><field><field> cat b <field> <field><field><field> cat c <field> <field><field><field> Is this still not possible at all ? or can I have something like cat a 2008 <field> 2009 <field> 2010 <field> 2011<field>
Why cant I delete a record?
Why cant I delete a record from this form/view? https://creator.zoho.com/yaxche/control-de-operacion/#View:F1_Lista
html edit & record delete error
Dear team, 1>Free Flow script can not show now. Before it can show. 2>Script Builder for html dashboard can not show with IE/Mozilla/Firefox. 3>can not delete record.
Delete Records stuck at loading screen
Ok, Support team please get back to me asap. I cant not delete any record in my app. stuck at loading screen. I am on a Enterprise Plan, so please do not ignore this post. This is urgent as my users need to get back with their work. Thank you.
Ignore HTML when sorting
I have a database of numbers that link to specific pages. Three cells in such a column might read thusly: <a href="http://juiced.gs/index/v1/">1</a> <a href="http://juiced.gs/index/v10/">10</a> <a href="http://juiced.gs/index/v2/">2</a> Is there a way to tell Zoho to ignore the HTML and sort this information numerically?
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
building a form that need to have lots of rule but has heavy restrictions given where it will be uploaded
hi, i want to use your form builder to create a form which i have been able to do on some free form building websites but i have some futher restrictions id like to place on my users before that submit... a bit of background.... im having trouble making a form with lots of rules in it. i have a html script that was written for me some years ago for my old website that consists of 3 vertical colums. this script can be emailed to you would like to see it or viewed (not working) at www.thepclub.weebly.com/moonee-ponds.html
Importing dates in forms
Hi, I am having some trouble importing date fields in Zoho forms. I set the application preference to MM/dd/yyyy. I have come to realized that Zoho cannot handle a date like 12/2/2011 or 1/31/2012, since it want exactly two digits for the month and date fields, such as 12/02/2011 or 01/31/2012. Unfortunately the application generating my source CSV data does not add zeros in front of single-digit months or date fields. Is there a workaround? Thanks
Code that once worked now does not
I have 3 nearly identical forms that contain look-up fields and sub forms. All were functioning properly and in use. and have stopped working as of today 2/2/2012. The forms contain a report type look-up field and a country look-up field which has On Update code to limit picklist values for Region, City etc. Both fields report type and Country pass their values to 3 subforms. As an example one of the sub forms is "Training Subjects" that were taught at the event. Upon adding a new record in the subform,
Is this a non starter?
I've just signed up the free package to evaluate the software. It won't let me set up any applications say that I've reached my limit, which is impossible as I haven't added anything yet! Any ideas where I'm going wrong?
Permission problem
I am trying to limit certain users to be able to edit data in certain applications but not in others and am running into problems. Suppose I have one main application (Personnel) and a related application (Projects). I want users to be able to edit the information in Personnel but not in Projects. Projects is private and not shared with anyone, and yet it seems that by creating a link in the Personnel form to Projects (Personnel can be connected to one or more Projects), it opens up the user to add
How to upload static image files and use them to decorate my html view pages
Hi there, I need many images files to decorate my html view pages. Can Creator provide spaces and management functions(such as upload, remove etc) for static files used by my application? Thanks, Roger
Can add a record, but get error msg when try to update it later.
Hi I can enter new student records, but as the title says I can't get into the record to modify it. Could you please advise. Thanks
Cannot add new records via API, if the form contains a subform
When I try to add a new record via XML RPC API to a form that contains a subform, then the API call returns success, but the new record doesn't show up. It doesn't matter whether I don't set the subform field (i.e. create a new main record without subform records), or whether create a subform record before and set the subform field of the added main record to the id of that subform record (i.e. create a main record with one subform record). Adding records manually works well. I can also add records
Next Page