Linking information from two forms together
I have two forms: One is a database, and one is from the Autumn term. If I add a person to the Autumn term, I want to be able to view this in the database as well, I want the class they have enrolled for & their booking number I have entered under the Autumn Term Form, to come up automatically in the Database view. Is this possible & if so, how can I link this? Help!
Need guidance to build my app
Hello, I am new in Zoho and what I'm trying to do is to build a simple app to place my customer's orders in and have my customer check my website to see the order status. 1. I have built my form and populated it with my customers' orders. 2. I have built a view to update my customers' orders. That I will do myself. 3. I need a view that I will imbed in my web for my customers to type in their invoice number then when they click submit they will then see the order status information. I need
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
Create a Filter that works across divisions in an HTML view?
As an example, lets use students on a bus: The HTML view has a top division view of Bus records with fields: Bus_ID_Number, and Total_Count_Students_On_Bus. The bottom division has a view of Student records showing who was on a given Bus with fields: Bus_ ID_Number , and Student_Name. My goal is to enable users (public or Zoho) to filter the HTML view so that each division is filtered for the same Bus_Number and therefore presents in one concise view both a summary above and detail related to
Need in-row function to populate values in HTML view...
How can I make a function that will open an HTML view which recognizes the record of the row the function button is placed in and allows me to populate the HTML with values from that record?
Hidden fields in a form are being shown as subform.
Hi, I have put some fields as hidden fields for the rest of the users in a form. Then I am using that form as a sub-form in another one, but the hidden fields are shown. I know how to solve for my application, but that is a bug, it should work differently. Kind regards, Mari.
Example for a valid delug criteria
Hi, http://api.creator.zoho.com/REST-API-View-Records-in-View.html The Api above has a criteria field as post parameter. I'd like to see and example how can I use that. It says I should enter a valid delug criteria, but don't know how is the format of that. I can set it from GUI, though. To be more specific I'll give an example. I have a two forms, Accounts and Lists. A List belongs to an Account so the List have a lookup field in it for Accounts. I'd like to create the deluge criteria for Lists
Export file size / column amount / line amount
Hello together, short question - what will be maximal file size column amount line amount We have to export at least file size - greater than 6MB column amount - 160 line amount - 20.000 What export options are recommended and which are possible? Thanks!
How to disable action buttons while the scrit is running.
Since the application that I am developing should run several scrip before loading the next step after submission, the user could push the action button again although the script is still running. There is a way to disable the action button in the meanwhile? Kind regards; Mari
Fecth records in a subform depending on a field in the form
Hi, I am developing an order management application. We want to have all the product pre-loaded so the user doesn´t forget any item. For user experience reason, we want to show him the products of a specific category. I am pre-creating all the products in the subform, but I want to fetch the records to show just the information of a specific category choosen by the user. It is possible to do it. How could I do that? Thanks, Mari
Suggestion in how to implement a validation on a view
Hi Zoho creator guys, I want to implement a validation in a view that should be activate when the user start it. Basically I have a view of "orders to be processed" and I want to check another view with the "products unavailables", and let the user know about these products. What do you suggest to implement this feature? Thanks in advance, Mari.
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?
Multi Customer Application
I want to create a single application for multiple customers. Each customer will have their own Zoho username, when they login they must only be able to see their data and add their data. However, me, as an administrator must be able to see all customers data and create and modify data on their behalf. Is there any general guidance and best practice for this?
What Can Zoho Do for you Today?
I have been spending some time working in Zoho and I must say that I am very grateful for a tool like this. It has all the features to allow my vision to become a reality without me having to depend on programmers. I have a good working knowledge of database and form communication and as I get deeper into my project there are a few questions that arise. I searched all over the forum but did not find answers. I was hoping that some of the community members might be able to answer my questions: 1.
Subform looks in form view/mode
I have a form with subform, and I want to have the subform to be showing in the same design as the form. Currently it shows as a list inside of the form. Like when I crate a lookup field, and click on +Add link next to the lookup field, it opens a new form on top of the main form. That's how I want the subform to work. Please let me know if that's possible to arrange. Thanks, Anri
exporting field data
when I input a new item in a form, i want data from one field to be copied into a text file I have sitting on my server. how do I do this. Thanks
Generate Turnover Graphics
Hi, I don't understand how i can create a Turnover graphic per month. (i've created a CRM) Have you got any solutions ? Thanks
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?
How can I send an email from Form A that includes data from Form B?
I have a Zoho Creator application with multiple forms. I need to trigger an an email to send when a checkbox is checked on Form A that will send to the email address listed on Form A, but I need the rest of the email to pull in fields that exist on Form B. How can I do that?
Fetch selected record
I seem to remember using Form [ID==input.ID] in order to fetch the record selected in a view to be used within a function. Now I get an error message: "Variable ID is not declared". Please help me remember the correct way to fetch the selected record.
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",
submit to local sql db
Is it currently possible to submit records from Zoho creator to a local SQL database? I am pushing records from a local sql database into creator, but i want to be able to push into A local sql database
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
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
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.
Calculating distance between two points
Hi all, I have built a ridesharing app in Zoho Creator. The problem is, right now, users can't filter the rides by their 'from' location. For example, it would be ideal if I could search for rides that were within 5km of my home suburb. I have a vague idea of how I'd do it but I'm stuck on one point (step 3). My proposed solution 1. Get longitude and latitude (see here). 2. Get a list of the rides within 5km of the search point by converting this PHP script into Deluge script. 3. Filter my embedded
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?
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
Call Centre to Add Records Only
HI I have a call centre taking details and want to send them a link to my Zoho form. The thing is I only want them to be able to enter new records - not to edit existing ones, and I'd like them to do his without having to log in (since it could be different members of staff entering these details.) How can I do this? T
Help with SEO
I have a database https://creator.zoho.com/mrcomputer/lts/# and embed the code to my website using an iframe http://www.mrcomputer.biz/pc-parts.php. we want the google crawler to identify the data in the form and create a link to http://www.mrcomputer.biz/pc-parts.php rather than https://creator.zoho.com/mrcomputer/lts/#.
Creator support not replying to emails
I have not received any email replies to the last four emails I have sent to support with the following subject lines: 01-Aug: "new calendar view - suggested improvements" - with follow ups on 04-Sep and 06-Sep. 27-Aug: "date filter options not sorted chronologically" - with follow up on 06-Sep. 07-Sep: "view record modal window too wide for browser window" 18 hours ago: "duplicate column/field showing in preview screen in view edit mode" I no longer require responses to #1 and #2 as these issues
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
Lookup Sorting
Hi I've got a lookup field in a form which is Bi-Directional. It shows a consignment number and postage date on its advance display options. When the user is in the main form selecting this, they select a consignment number which has already been created in the lookups form. However, it shows the oldest date first in the list, and I want the lookup to sort by the newest date so the user doesnt have to scroll through lots of historic consignments. I know this can be achieved through the deluge script,
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
Style Based URL Embeded Views No Longer Working in HTML Views
On Friday the style base URL embedded views in my HTML view were working. Today they are not. I'm not able to determine the cause. Please look into it for me. Here is the link: https://creator.zoho.com/smspdd/bookings/#View:BookerAdm?Pdr=Monsanto&Yr=2012&Sls=Marty%20St.Denis I have opened edit access. Please let me know if you need anything else from me.
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.
Some Fields not clickable in a form
Hi I have a simple form with couple of single line, multi line and file upload fields. The single fields when I click using mouse I get the typing cursor. For multi-line field when I click on the upper part of the multiline field I get the typing cursor, but when I move the mouse to the lower half of the multiline filed, mouse cursor changes to arrow and when I click I don't get typing cursor. Also file upload control, I am unable to click on the upload button. I have enabled the form verification
Add the Year 2010 to Expense Tracker
Expense Tracker reports do not have the year option of 2010 in the Year Selection field!
Next Page