Concatenate a formula field
I am trying to concatenate multiple address fields and put into a formula field. I tried: field1 + field2 input.field1 + input.field2 Neither of them worked. Any ideas?
Improve View Record Format
Take a look at this page https://creator.zoho.com/buzzap/ncsd/#View:Public_Post_Archive Then select to view a record. There are a number of issues with how the view looks Some of the records scroll horizontally off the page The column headers take up a huge amount of space: the view should scale to minimize the free space The printable view has the same problemsThanks, John Whitney
Integrating CRM information into Creator
I would like to pull key information from a Lead in CRM and populate at Creator Form which i can then add more information. For example, I have a lead and i put basic information about the lead into the Lead module. Then if/when i want, i can create a Creator form called Lead Profile where i can go into much greater depth about that lead but store it outside of CRM so that i dont use up all of my custom fields in CRM. Say that Mary Smith inquires about getting some care for her Mom at home.
Can records be imported from a text file into a search?
I have a set of records in a text file that I want to find in my Zoho data base. I'd like to import those records into a search and then bulk edit the records. I cannot figure out how to import records into a search. It looks like I have to enter search criteria manually, one record at a time. Is there any way to import a set of records into a search? If so, how do I do this? Thanks.
importing from excel - single field with multiple options
Hi, I am exporting a database into Zoho Creator and I'm struggling with one of the fields. On the spreadsheet, one of my fields has multiple possible answers, for example each line represents a client and each client can have one or more specialisms which I want to be able to capture. At the moment, each word or phrase in this field is separated by a semi-colon on the excel spreadsheet. When I import, Zoho doesn't recognise each phrase as a separate entity. Is there any way of doing this? I want
updating records in grid view
Hi, for 2 days now, In grid view, I only can updated six records at a time. Anything more than 6, it tries to "save records" for along time unsuccessfully. please help, i need to update 100s of records everyday. i cant do it in an increment of six. it will take the whole day thanks
How do I compare two text fields from two forms?
I have written\copied this code below, however, it isn't working. I wonder if it had to do with the fact that they are text fields. if (count (Mrs_Weaver_s_Question_of_the_Day [Question_of_the_Day == input.Question] ) == 0) alert "Question of the Day was not listed. Try again later"; cancel submit; Please advise.
I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator?
Hi, I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator? Thank you
Problem with Free-flow script view in IE
I'm using IE 9.08 and just today have had a problem with the free-flow script view. The font used to render the script (and the numbers to the left of the script) make the script unreadable -- they are all symbols. When I view the script in script builder, all is fine. This problem arises for both views and forms. The problem just appeared today. It does not show up in Chrome. As I said, the problem doesn't appear in the ScriptBilder, just in the free-flow script. What font is being used
Please Reply this Can I use My own Domain Name
Hi Team Can I use my own Domain name for eg:- Application Link is http://creator.zoho.com/l3admin/namexYZ/ Is it possible to use my own domain eg: http://mydomain.com/xYZ/ instead of http://creator.zoho.com Please reply this Smitha
Are there dynamic functionality based URLs for ZOHO Reports?
I love the Reports feature added to Creator that integrates ZOHO Reports. I noticed that the URL parameters functionality doesn't seem to work for reports. e.g. http://<your app URL>/#View:<view name>?<field name>=<field name value> The above allows the dynamic filtering of the view based on field values. It doesn't seem to work, however, for #Report:<report name>. Which forces the creation of multiple similar reports to handle various filter criteria (e.g. Totals this Month, Totals last Month).
Hide/Show Function Not Working
I have implemented the simple hide/show function on my form to achieve a simple outcome. I want to hide fieldA on load so I have added to the On Load Diluge Editor hide fieldA; I want to show fieldA when fieldB which is a radio box has the option "Yes" selected. I have therefore add to fieldA the following on user input script: if (input.fieldB == "Yes") { show fieldA; } else { hide fieldA; } For the life of me I can not get the simple function to work. Very frustrating. The form doesn't
Script Builder window can it be made taller
Hi, When working in Script Builder the height of the window makes it hard to see a complete for each loop especially if you have a lot of statements in between Any way to make this window taller ? so you can see more of the code ? thanks
Embedded forms, weird URL
Hi, Please take a look at the two embedded codes, both for contact forms on our web site: The forms are set up identical with identical sharing permissions etc. But #2 has all kinds of extra "GHJhj;HJB;HJ" in the URL. #1 does not have that... Why is that so? Kind regards, Bo Thygesen 1: <iframe height='500px' width='100%' name='zoho-smallno' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/bo.thygesen/smallno/form-embed/smallno/'></iframe> 2: <iframe height='471px'
placing two controls side by side is not happening
Hi, Zoho form is divided into two parts.In one part how to place two controls side by side.That is not happening. Please help me out of this.
URL in Creator contact form
Hi, we are using our creator contact form extensively through out our site. (we are a real estate agent, so at every property there is a contact form). So basically the same contactform is displayed on several 100 URLs. Is there a way to include the site specific URL in the contact form, so that we can see from which part of our site the customer has contacted us? Kind regards, Bo Thygesen
multiple criteria using bidirectional lookup fields
I am trying to use set criteria to use 2 different fields in a bidirectional look up to sort my data. (Warship_Name == input.Warship_Name && Engine_Type == "Main") in my engine view I define what ships can use that engine. and also define whether the engine is a main, mjet or scram. I would think the code above would only show me engines (in my warship view) that work with the listed warship and also need to be defined as Main. However it seems to only pay attention to the first part Warship_Name
Custom domain
Could a Zoho guy explain what the "custom domain" marked as complete in the working on feature list, refers to? Also, when can you implement the html to pdf WITH IMAGES and PAGINATION ???? Thanks.
Record level permissions
Here is what I want to do: 1. User enters email and a password. 2. Script compares to see if email is already in database. 3. If email and password match, the user can edit ONLY their record. I can do #1 and #2 - looking for help on how to implement #3. Thanks! Julia
Ive got a csv / xls file that i want to import automatically on a schedule
is this possible? i am open to thinking outside the box. Ive got a csv file with about 700 records, that i need added to a view on a schedule. for example, i need it to import this csv on a local hard drive every night at midnight. is this possible? i need help! Thansk!
Database
Hello if i creat an app on zoho ,, can i get the database to put it on my on server
bug with Bidirectional lookup?
I have created a one to many bidirectional look up. However when i use the many side to set up associations to a specific entry... they can on exist on one entry... when i set them to another entry as well it removes them from the first entry. in my example I am setting up a template that associates an engine to multiple cars. I also want to be able to say a more powerful engine could work with the same cars and that should be ok... however the database doesnt let me do this. Ie... engine X should
workspace app OR personal app?
hi i have professional account with 10 users what is difference for me (as owner and admin of apps) to use personal app or workspace app? using personal app i can make apps and add access to users what add workspace apps in functionality? for what it will be preferable to use workspace apps but not personal apps? special admins and developers for each workspace?
How can I delete form views in bulk?
I duplicated an application that I created which had a lot of form views. I need to delete all of the views in the new application, but I only see how to delete them one by one. How can I delete all the form views in bulk?
Help with boolean please
I have a multi-select box field. What I want to do is when a specific choice is selected an email will automatically be sent to the relevent department. This is the code before trying to implement this with the different choices: Medium_Published_to1 ( displayname = "Medium Published to?" type = list values = {"Shakti Durga's Media Centre (subscription)", "Public Media Centre (Shanti Mission)", "Teacher & Mentor Training Portal", "Shakti Durga - Youtube",
How can I align data in list views?
I would like to customise my views to center-align some fields. At the moment, some fields are right-aligned and some left, which results in the data in one column being right up against the data in the next. I know how to change column width, but not alignment. David
Group Modify
What happened to Group Modify ? Used to be available at top left of form ? Now all I see are ADD and SEARCH
New UI - Export Filtered Records Missing
I've been using the new UI for a couple of days. We needed to export to a spreadsheet only some filtered records and the surprise was that the option was missing from the menu. Is the option gone for good? What's the propose method for exporting filtered records? Thanks.
What's the URL of my form?
I have just made a public form using Creator. Where do I find the URL so I can tell people where to look for it?
How to check if an email address is already in my database.
I want to write a script that takes the information from my donation field and checks the email address against the contributor database. If they are not in the list, I want it to send an email to the address with a form for them to fill out and enter their information. I want to make a comparison like this: if (input.email not in contributor.email) ( send email ) the problem is that I can't figure out how to reference the contributor form from the donation form. The underlined reference does
JS overlay forms
Hello, Is it possible via openurl(...) to open a form the same way as when you choose edit on a view record? Thus as JS popup (DHTML) form instead of a new window/tab/popup window? This question seems to have been asked before but w/o an answer. Thanks, Stefan
Tab issue
Hi, For example ,I have 4 tabs.User first interact with first tab and he will move on to second tab.Right now in zoho, without filling first tab forms,he can fill the second tab form. My doudt is i want to restrict the user.Like first he has to fill the first tab then only he has to go to second tab.How to do this. Please suggest on this.
Add the Year 2010 to Expense Tracker
Expense Tracker reports do not have the year option of 2010 in the Year Selection field!
Hide Show tabs based on dropdown selection
Hi, How to Hide/Show tabs based on dropdown selection.I have a dropdown which has 4 items.If i select 1st item show 1st tab,2nd item show 2nd tabs and so on. Plz help me out of this.
Form response conditional on checkboxes
Sorry - I'm sure I'm being dim here. I am trying to complete a form which restaurants and bars complete to report their weekly sales. I have three check boxes at the beginning of the form- Food Drink Accommodation (for hotels) I want the form to reduce or expand depending on how many they tick. If they just tick food for example, then only the food part of the form appears. If they tick all three, then all of it appears. How can I do that with conditional commands? I hope it is easy - as my technical
Google Contact Sync
I want to start by saying I think you all are doing a great job here. Your product line is excellent for someone like me who has a tech background, doesn't want to write code, and is in an entrepreneurial situation. Thank you for your whole product line! I'm very interested in the possibility of switching from my current CRM (Insightly) to your product line. My "perfect solution" would be a combination of "Creator" and "Sites" because of their integration with one another and because of the flexibility
On success of first form how to load second form
Hi, On success of first form how to load second form.
Complete Newbie needs help
Hi, I'm trying out the trial version to see if this software will work for our non-profit. I'm totally new at this and have no programming experience. I've got a contact form that I'm happy with but for one thing. I have a drop down field that has 3 school districts listed as choices. The next field I want is School, but I want the School field to be populated with choices based on what was selected in the districts field. How do I do that? Thanks in advance for any help.
Error Executing the workflow ON_LOAD
Hi Good Afternoon. I have this app, [mfateammanager] when i try to enter data in a field or click on a respective category, i am getting this error. Could you please help? the system was working well. I haven't touched anything. I really need to recover this issue as soon as possible. This error occurred since you've updated your system Thanks
JSP error
I am getting the following error when I try to edit a view [ServletException in:/jsp/edit/view/viewedit.jsp] null' I believe its because the same field/column has been added twice. How do I share with support for it to be fixed?
Next Page