Zoho security
Hi Can you tell me if it is possible to store my creator Data on a secure dedicated cloud. Thanks Nigel
Lookups of lookups
I have four forms: Form B has a lookup field based on Form A; Form C has a lookup field based on Form B; Form D has a lookup field based on Form C. Now when I develop a view based on Form D, I can display fields from forms C and B, but not A. There is no way I can link the forms to display any field Form A, though Form A is used in Form B, and B in C, and C in D.
Lookup of lookup
If I have a lookup field on a form, it can only be set to a standard filed on another form; but it cant' pull any "lookup" fields on the other form.... how can I overcome this?
Rental Check in and out with Time calculations
Hi I'm trying to work out a way to get a form for my Ski and Snowboard Rental department up and running. I'm stumped on how to calculate the number of days the guest will have the rentals out. The part that is tricky is that we also calculate what time they take the rentals from the store and when they return them. Let me use a weekend as an example. Rentals can be picked up after 3 pm on a Friday, used that Saturday and returned before 3 pm on that Sunday. I do not count the pick up day (Friday)
"AGGREGATE"FUNCTION IN FORM VIEWS
hi currently for each column of a view I can define: Min : 0.00 Max : 0.00 Average : 0.00 Total : 0.01 Would it be possible to add an aggregate value called "count not null"? It counts all values ; but null values are not counted. thanks! thanks!!
is the mail merge function available on Zoho?
HI, I am currently trialing Zoho with a view to using it as a database for our company, but cannot seem to see if there is an option to mail merge pre loaded documents from our document control lost and merge the customer details from the record at the click of a button. Does anyone know if this function is available on Zoho? Thanks in advance
Project Manager Plus
If anyone is a Project Manager Plus guru, we are having troubles assigning / sharing with users and being able to see the full list of sections that they should see if we set them up ans Manager/Admin type users. We think this App will suit our needs but sharing it with other users and having all the functions available to them seems to be our biggest headache at the moment. Any ideas would be very welcome :)
Messaging the user
For various reasons including error reporting, useage guidance and information, I wish to message the user. I have tried a number of ways: 1) Using info only display the message to the the administrator/developer so is no use for regular users. 2) Opening a form with a note field set to display a message is hard to control the form behaviour and post particulalrly the location on screen; quite often I find the message form out of the field of view and the window has to be scrolled up to see the message.
Documents in creator
I need to make documents available within creator, somewhat like the document feature in CRM. Can you please tell me how to achieve this. E.G. on any given record in creator I need to be able to upload multiple documents and allow users to download the same documents and upload their own. Your document feature in CRM looks like what I want from Creator. Thanks
Disabled field on grid view
Hello, Is there a way to disable a field under the grid view? On the guidance (grid view section) there is an example, please see picture below, on this example one column (category) seems disabled, like a read-only column, this is exactly what I would like to achieve. Can you please tell me how I can do this? Many thanks
Get data from reports into creator
Hello, How can I do a query on tables or views in my Zoho Reports account in deluge (from Zoho Creator)? Thanks David
nightly batch data jobs
How do I schedule nightly data batch jobs for updates? I am trying to use the scheduler but it does not allow an interval .
Update form A according to values in form B
I have form A with about 300,000 rows; Form B has about 500 rows. Form B column1 has 500 distinct values , used as foreign key in one of the columns in Form A. Now, I want to update Form A column2 if column1's value is found in Column B. How should I go about this? This is very easy with any RDBMS but with Zoho scripting, how should I do it? Thanks.
Zoho creator: daily schedule to update form per a list of values
I have a special situation. First I need to generate a list/array of values from a form, let's call it List A of 100 values....... Then from the same form, for each row/record that satisfies a condition, let's say Collection B..... for this collection, I need to loop through each row, checking one field from each row against List A....... if the value is contained in List A , then another field is updated to "True"..... how can this algorithm be coded? Also wonder how to get comprehensive
Decimal input trim
For text-string input, I can do STRING1.trim() on user input to trigger a trimming action.... for for decimal numbers, how do I activate trimming on user input and before submit? Thanks!
TIP: Can import the URL fieldtype as separate Link, and Link Name
Found that we can successfully import URLs with their Link Names --if the imported URL value is HTML. <a href="http://server.com/path_etc/">Your LinkName</a> Tested with the Excel Migration tool, reading from an XLS file. Works whether updating existing records, or adding new.
Exporting report to excel 2010
When I export to spreadsheet I normally want to make a merge operation in Word But as I use Word/Excel 2010/2013 I have to open the exported 2003-2007 excel file format and save in 2010 format (XLSX) Is there any way to get over that step. Poul
How to send sms as a custom action in a report view?
Hi, How do I send an sms as a custom action in a report view? I've tried using the function shown here: https://www.zoho.com/creator/help/script/sending-sms-from-a-zoho-creator-application.html and made the changes as instructed on the page but for some reason it's not working. I'm using Clickatell as a third-party service. Thanks in advance, Siya
Adding Multiple Records from a Single eMail
I needed to post a number of records into my form, ideally from a single email (and not having to have extra coding on the source system to implement the API). However, Zoho only supports single record submission from a single email. I therefore devised a work-around, which maybe useful to other people needing a similar system. I would also appreciate any comments on code improvement. My Form (IMPORT) has 10 fields, as below. Date Hour Channel Site Break_Type Month-Year Guest_Weeks Promocode
Create Rule Based Upon Unselected Dropdown Field
Is it possible to create a field rule that is based upon a dropdown field NOT being selected? More specifically, I want to hide the rest of the Zoho form below this dropdown field when the user hasn’t yet selected an item from it. Basically the rest of the form shows ONLY once you make a selection in this field. Before you do this, everything below this field is hidden. I don’t know what language to use when writing the rule to refer to the unselected dropdown field. It displays as -Select- when
creating a new input page
Hi I need some help with an input page please Lets say I have a form with the following fields Name Address Tel no Visit time Agent Instructions agent special instructions ETC Now I want to create a new form with the fields Name Address Tel No I want this form to have the ability of creating a new record in form 1 Hope this makes sense
Embed & controls
I am embedding my databases into my web pages, and all seems okay, except I do not get the "tape recorder" functions at the top right of each page, which allow the viewer to move thru the records a page at a time, instead of individually. Backwards one page, forward one page, first page, last page. What do I need checked "SHOW or HIDE" in order for those functions to appear at the top of every page ?
Extracting information from an email.
Im creating a booking system for a hostel. We receive regular emails every time a booking is made through hostelbookers. Everytime a booking is made an email is sent. What i would like to know is how extract data from an email, every email is written in a set format. I know how to forward the email to the zoho email address so that i can import the message body. But is it possible to tell the database where to extract information from that message body, such as number of people, date?, because the
Embed database in webpage
I am trying to embed my databases into several webpages. Seems to go okay. I note that although all of the databases are marked (or not checked) to prevent anyone from making changes, when I embed in the web pages and publish, some will only have the SEARCH option for viewers (which is what I want), but a few will also include the ADD option, which I certainly do not want . And this ADD function will actually add to the information. I don't see any thing different in the makeup of those databases.
Search Engine vs. Web Page
I want my databases to be seen and found thru search engines. But they don't seem to appear or if they do are way down in the relevance order. Will I have better luck with them being found as stand-alone databases or as a part of a web page ? My web sites all score high in the search engines.
Transfer data to and from web site
Can someone help with some logic please This is all an example of what I am trying to do So my web site has a line that says "hello I am a x" On my database I have the following fields Number Hello I am a Code in on user input in Number is if(input.Number = 1) { input.Hello_I_am_a ="Dog"; } if(input.Number = 2) { input.Hello_I_am_a ="Cat"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number = 3) { input.Hello_I_am_a="Mouse"; } if(input.Hello_I_am_a = "") { Number=1; } if(input.Number
Frequency Chart / Histogram
Is there any way to create a chart/pie graph displaying the percentage of times a response is recorded? For example: Yes Yes Yes Yes No Then, create pie chart displaying: Yes = 80% No = 20%
Help with some code please
I have written some code to send to a web site to include in an embed statement on the web site. The code is if x = 1 { input.rep = "<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.signedfast.mymomentis.co.uk/products-residential-uk.asp?CO_LA=UK_EN">"; } Trouble is because the line has more than one " in the statement it returns an error. How do I enter this statement into a field on creator. Thanks in advance
Remove box-shadow on Embedded Form
Hello, I just attempted to use the code found here (https://help.zoho.com/portal/en/community/topic/is-there-a-way-to-get-rid-of-box-shadow-on-embedded-form#2266000006342219) to hide the box-shadow on my client's form and while most of the code was accepted and used, I am still finding that the specific box-shadow value is staying the same as it was originally (box-shadow : 0 1px 2px #cdcdcd ;) and will not be overwritten, no matter what I code. The specific page is here: http://www.sharespace.co/practice/
Creating a lookup field
My organization is comprised of divisions, corporate branches and an entity called TELF. Divisions contain portfolios, which in turn contain programs. Branches contain business units which contain groups: Divisions Name of division Name of portfolio Name of portfolio Name of division Name of portfolio Name of portfolio Name of program Name of program Name of portfolio Name of program Name of division Name of portfolio Name of portfolio Corporate branches Name of branch Name of branch Name of business
Create relationships between two existing forms
I have two forms with existing data in them. They are not linked; one is master and the other child. How can I link them together with a key to foreign-key relationship? Thanks!
Object-linked Custom actions
Hello! I'm trying to implement in my application the following conception - using of standart Object-linked Custom-actions: You can check here (click on Client name): https://creator.zoho.com/smt_online/custom-actions-test/#View:Projects1 For example, I have Forms: Clients, Orders, Projects and so on Each Form (or Object) has accosiated standart custom Actions, which are used very often, and you need to do these actions from different places of your App: Clients: rename, block, check_status, send_notifiction
specialized list
I have a database with one report (list) - I/m not sure what to call it. It has 18 columns and many rows. I want to create from that list, a new list that I only would use to update info, and it would look the same, but only 4-5 columns. The other columns still there just not displayed. Columns I'm not interested in updating would not show. Thanks
Display text based on dropdown choice
Hi there, I have a form called "Attempt" that has a drop down menu that is a task number that is a lookup from a "task view" I have. Based on the number selected I'd like to display another field from the "task view" for that record along side the number. I'd be happy for this to be uneditable text as it's only for display purposes, I don't even need it to write to the view for the form in question. Any ideas? Hope I'm explaining this ok. Another way to look at this... Imagine a set of questions
Relationship between databases
I have a database with details of all my clients (about 20 in total) I have another form which my clients use to book an appointment and I need to know who is making the booking. I want the client name entered on the booking form to equal the client name in the client list and I do not want the client to use a drop down box as I do not want clients to know who my other clients are ... Is there a way for creator to ensure fields match without disclosing the options
Creating reports - calculating entries from multiple forms
I need to build a report based on the same form being filled out multiple times by the same user. We are recording the number of each users consistent responses and changes over several instances. The following is an example of the form, the user must select one or multiple decision boxes. The form automatically determines sum total, percentage and time taken, The user then will complete this same form several more times. We need to create a report that can filter by user name and time period
Calculate number of marked responses in a form
Hi I am trying to find a quick way to automatically calculate the number of responses a user marks (true/ correct) on a form and then calculate the overall percentage score. Below is an example. I am using the decision boxes where the user will mark each response they feel is true. Any ideas would be appreciated. Ian
Drop down list - auto fill other text field
Hi Sorry - I think I have already posted this question in the incorrect area on the forum. My question is: I have 2 forms - Form 1 - 'Memorial Branch Details' Fields: - Branch Name - Email address - Telephone number Form 2 - 'Warehouse list' In this form I want to have a drop down list which contains the various 'Branch Names' from Form 1. Once the 'Branch Name' has been selected, I would like a text box in Form 2 to auto fill the corresponding branch email
Two time stamps in a single form
I am looking for a way to measure the amount of time it takes for a user to complete a form, where the user can start and stop the clock. I see this working as having 2 time stamps and a 3rd calculation field Step 1 - Time stamp 1 - Record Start Time Step 2 - Time stamp 2 - Record End Time Step 3 - Formula Calculation - Time taken ( End time minus Start time) is this possible using the current creator functions?
Mail Merge with Creator
Hi I am very new to Zoho Creator. We are looking to use Creator to store a database of information. We wanted to be able to use this information in a Word mail merge. Specifically to print labels and create documents that use specific information from individual records. Is this possible? Thank you.
Next Page