Single or double equals (or no equals) for boolean criteria
Hi, A fairly basic question but it would be great to have a definitive answer and I can't find one anywhere. What is the correct format for boolean criteria for a conditional expression (like an if, or to select form data)? And does it matter which format you use? (Because it doesn't seem to make any difference when I test out the different versions). A. One equals, e.g. FormData = Form[bool = true]or e.g. if (bool = true) {<expression>;} B. Two equals, e.g. FormData = Form[bool == false] or e.g.
Picklist within subform
Good afternoon, I have a picklist inside a subform wich I dynamically populete base on a lookup field. Is there any way to select one item on the picklist?? I try row.<fieldlist>.select(value); But the system answer: <fieldlist> does not exist in this form Thanks in advance for your answer. Ricardo
How to set up help button in a form dropdown
Hi, In a form a line which has drop down ( can I have a Help button around it - which displays pdf diagram which helps choose the choice for the drop down). Please help I am a newbie to zoho. Thanks, Geeta
Customer Portal Document Access
Our application has documents within the database, however the users we have set up through the customer portal are unable to open these documents with their userid and pwds. When they click on the link for the documents they are asked to sign in again via a link to the url via zoho and NOT our landing page, but their credentials do NOT work, making the documents within our application un-accessible to them. How do we fix this issue?
usage limit (how to manage)
OK, I have been using zoho creator for some time and has worked so far fine for my purpose. I do business process management and also store sales transactions. The sales transactions in particular I cannot afford to delete when I reach the usage limit. the other suff I can. Eventually (soon) I will reach the usage limit filled up with sales transactions. I need to figure out a way to manage this before that moment arrives. Obviously I can buy more records, great but eventually these will be used
Zoho CRM integration for dropdown field
I have the following code that works (in the load of a form): accountlist = zoho.crm.getRecords(("Accounts"),1,200); for each rowvar in accountlist { Client:ui.add(rowvar.get(("Account Name"))); } My question is how do I sort the Account Name for my dropdown field (Client)? Thanks
Duplicating an embedded view in a page
Hi I had an existing search form embeded in a page. I wanted to add another search form on the same page. I simply duplicated the first embedded form (so that I could then modify the search parameters) but when I inserted this duplicate into the html, the duplicate form would not appear. However if I changed the view link name of the duplicated form, then it would appear. This was the html: <tr><td><div elName='zc-component' viewLinkName='Search_Form'></div></td></tr> if I copied this row then
How can I create multiple rows of numbers and then connect US to it
The promo code is alpha numeric making it a pain in the ass to enter them 1 by 1 instead of doing a range of codes owned by a consultant. I would like to find a way to enter the fields: Country - (This could be a checkbox or text box or radio button) the options are either US or CH Code - (6 digit code) # of Codes - (How many sequential codes to assign to the consultant) Somehow I need to write a script that takes <code>+1 repeated <# of codes> then add or connect Country. So after inputting US 101010
Customer Portal Basic Questions
How can a user change his email? Are there plans to customize the sign-up from with more fields? Upon sign-up, there seems to be no way to control where the user lands in the application. True? Since I'm building the app in my own account with an intention to export the ds file to my customer, will my customer have issues with the customer portal aspect upon ds file import? Cheers, John Whitney
zoho.loginuserid not working for customer portal
A few hours ago if I logged in to my customer portal app, a form with Email=zoho.loginuserid; would correctly display the email of the user. Now it's simply blank. However, if I place <%=zoho.loginuserid%> on an html page, the email is displayed to the portal user. Something must be broken with the customer portal? I submitted a support ticket and shared the app with zoho. Cheers, John Whitney
iFrame vs JavaScript embed to show full report? Help Needed!
Hi, I am trying to embed reports in my website via "IFrame" so that the user has the "search" & "sort" options. But no matter what I try, it will only show the first 10 records of the report and is using "paging". I want the entire report (all records) to show, just as it does automatically if I use a "JavaScript" embed method instead. Unfortunately, when I use the JavaScript embed the user has no access to "search" or "sort" options. I would actually prefer the JavaScript embed, if I could get
Populate data field
Hi, How can you do that when you select a dropdown and a number is typed into a text field will auto fill other field and the final amount has to be half the user write. Dropdown field name: Tipo_de_Prestamo Data field with the amount : Prima Data field to populate: Comision
Customizing a Record Summary to show continuous records
I would love to know how to make a form almost exactly like the invoice shown on this example page: https://www.zoho.com/creator/help/views/record-summary.html. The problem I am having is the data from the subform that would go in the Item,Quantity, Rate part of the view displays all in one record with a comma between them (so instead of two records, "Widget A" and "Widget B," I get one record with "Widget A, Widget B." I'm a new user and it might be that there is a relationship problem in my
custom action to edit record
Is there a way to use a custom action to open the edit record dialogue? I want to avoid passing data back and forth between a stateless form and also do not want users using the standard edit record method. I want a custom action that opens the record for editing. Is this possible? Does the edit record popup have a url i can pass to the OpenUrl() function? Is there another way? thanks
Forms and reports
Is it possible to create a report based on 2 different forms that are not linked in any way?
NULL Search
How do I select records for which a field contains no data, sometimes called a NULL search? Thank you. Roger
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field.
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field. example,... project db, has the following fields, project number elec design hours mech design hours technician hours assembly hours time entry table has the following fields Project number job function (drop down with selection of elec design, mech design, technician design, assembly) Total hours I would like to update the proper field in
Managing Our Products (Price List)
Hi, We would be interested in someone developing a database for us with the following fields, if interested, can you please get in touch with me? Product Name Product Code Manufacturer (drop down) Manufacturer Name Manufacturer Code Length Width Height Diameter Weight Cubic Metres (calculation L X W X H) Cost (USD) Exchange Rate (perhaps can be auto filled online or happy to enter it manually) Cost (AUD) (formula COST USD X Exchange Rate) Landing Costs per cubic Metre (I will manually enter this)
Zoho Creator REST API
I'm trying to extract some data from a Zoho Creator App using perl as follows: #!/usr/bin/perl use HTTP::Request::Common; use LWP::UserAgent; $ua = LWP::UserAgent->new; my $req = GET 'https://creator.zoho.com/api/slowclay/xml/copy-of-slow-clay-registration/view/student_view', [ authtoken=> 'bd73c9ac318d2fab9f8d89fce9509c29', scope=>'creatorapi', submit=>'View Records', ]; $content = $ua->request($req)->as_string; print "Content-type: text/html\n\n"; print $content; But I just get the response
Need help creating a simple search interface PLEASE!
I've created a form that organizes job, job id and location in a form, but I need help creating a simple search interface that makes those three things searchable, and brings up all the information about a particular item searched. (For example, when i search LPN, I want it to show me "LPN", the job id AND the location. How can I do this? Please help!! I've tried for hours to figure out this coding ,but it just isn't working for me! Thank you in advance to anyone who's willing to help!!!!!
Search over multiple fields of subform data
I have a list showing the data from the subforms. I have several fields from the subforms showing. I am concatenating the fields from the subform so they can all be seen on the view. When I search I only get matches against the first field in the list of fields that are concatenated. eg. main form has name, sub-form has age-band and location. If a row shows "Martin" for name and "London 0-10 11-20" and I search for contains "0-10" I receive zero matches.
Translate to Portuguese
Hello, Is there any plan to translate Zoho Creator to portuguese, or a feature for the developer to translate commands of ZC like Delete, Edit, Add and staff like that. I have several clients that do not read english so I have to create html views with buttons in portuguese, so I have to re-invent the wheels all over again, and I'm not using one of the best things than ZC have, the views. Thanks Rodny :)
username microsoft windows
Hello, is there a way to know the user name logged in microsoft windows? Thanks in advance. David
Embed Calendar view in Creator doesn't work
I can't seem to get calendar view in creator to embed properly in my website. All I get is the report view, not the calendar view. What am I doing wrong?
lookup field on a lookup field
Hi there I am trying to add a Look-up Field onto a Sub-Form that appears in the Parent Form, BUT the Parent Form Field I require is also a "Look-up" field, linking this to another table in my App. I tried creating a Look-up to the Linked table (Not my Parent table), but this does not allow me to run reports with data from my parent table. Any assistance? Thanks Kevin
Set default value in lookup field after submission
If I have a lookup field (dropdown) with countries, is there any way when I select a country and click submit then automatically set this country as default? . Can you please send me an example of this? I tried (in On Load) to fetch records like value = Country [Name_of_Country = "Germany"].ID; Lookupfield.select(value); With a country like Germany it works but I do not want this.
Zoho Creator: Error in executing Send Mail task. From Address is NULL.
Hello everyone. Just created an application including one form and one report via Zoho Creator. I set the form so that anyone filling the form will then send a confirmation email (one copy to me) including all data given. I tested the form and it works perfectly to me, I receive the confirmation email (I filled the form using my personal email account) and I also get it as a copy to my other email account as creator of the form. The problem is: when everyone else is filling the form, they don't appear
Field with Change Log?
Hi, I have a project tracker application, and a rich text field I use for keeping action notes, I was wondering if there’s a way to have a change log recorded option, and easy way to access it if I want to go back and look at notes I have deleted as I updated the field for new notes or projects
HTML in a formula field being displayed in a view as text
Hello, I have been using HTML in formula fields for some time and no problem at all. Today I was developing an application where the HTML code in the field resulted in plain text shown in the view. Is there anything I am missing? I am talking about a code of this sort: (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>" below you can see what I am talking about, the field Titulo is a formula
HTML Page - iterate rows for each record
Hi everyone, I logged a call with support a few days ago, but have had no response and need to get a report finished for tomorrow, so am struggling. Herb has been fantastic assisting me with resolving some other issues but I hope someone on here might be able to help on this point. I have a database of student data. I have created an html page to display the data held on 15 tables, all of which are linked to the student personal information through a FullName lookup. Some of the tables contain multiple
Create HTML+Deluge Script button in a Formula field???
A Zoho Creator developer recommended that I add a Formula field to my form that contains the following HTML+Deluge script in order to create a 'View Details' button. (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>"What the code produces is seen below. Since this is put in a formula field it is displayed on any of the views in which I choose to view this field. The Deluge script pulls
Problem signing into database after user changes email address in Zoho account.
Hello, I am the administrator for a database. One of the users changed their login account to a different email address: Now they are getting an error message when trying to log into the database: The error message is: "You have logged in as adminvs1. You are not allowed to access this application. ..... Please click here to login as a different user." I had already changed the usrer's email address/login to the new email address the user has changed to. The user is able to log into her Zoho account
Return the last two digits of the current year. For example return "14" in 2014
I wish to have it returned as a string value that i can concatenate into a file name. I guess that it is an index value truncation but I cannot remember.....
How to Assign multi-select records for Selected user and Allow Permission to view by only the User
Hi Guys, How to Assign multi-select records for Selected user and Allow Permission to view by only the User. I have couple of users (user-A, User-B, etc.) and couple records (record-1,record-2,record-3,record-4,record-5, etc.) in the application. I want to create one form with multi-select for records and lookup for user. on submit Select records must assign to the selected user. Such as for user-A assigned records record-1,record-2,record-3 and user-B assigned records record-4,record-5 Once done
custom action html view
Can I build a custom action button and open in a pop up an html view? When I try this i get a popup that just says "loading view" and after awhile it closes but the html view never actually opens or shows. Is this a bug? I found another post from years ago talking about this problem. Has this still not been fixed? Please help I would prefer not to screw around on this for hours if its just plan old broken. My custom action forumla button has the following code: "<a class='zc-formbutton' href=#View:RFQ_Send_Production_Order?zc_LoadIn=dialog&Request_ID="
Refresh the Captcha
Is there any way that a user can refresh the Captcha? I have a couple of forms that require the user to correctly fill in the captcha before submitting data. During testing, I've on occasion had to either guess 4-5 times, substituting 0 for O, I for l, Z for 2 (you know what I mean), and have a few times had to resort to resetting the entire form and adding all the information in a second time, hoping the new captcha will be more obvious. Am I missing the tool that ZOHO provides to accomplish this?
Error inserting value to linked field
Hello, I have a stateless form that is uses "insert into" command to populate two tables, "Contacts" and "Contact_History" in the "On Click" script of the "Submit" button. First I insert data into the "Contacts" table. The "Contacts" table automatically adds a 'Contact_ID' value via an auto-numbering field. Next I fetch that Contact_ID value (assigned to 'r') and use it to add linked data into the "Contact_History" table, attempting to populate the 'Contact_ID' field which is a look-up to the Contacts
input. removed from formula fields
I have a custom action in a formula field using the following code: "<a class='zc-formbutton' href='#Form:Approve?zc_LoadIn=dialog &Vendor_ID=" + Vendor_ID + "&Request_ID=" + Request_ID + "&RFQ_Response=" + input.RFQ_Response + "' >Select as Winner</a>" Immediately after saving this code the input value of RFQ_Response is working and the form that opens up has the proper value in the RFQ_Response field. Trouble is, if i edit the button or save the form later the code on the custom action seems to
Call a function on Field Action , On User Input
Could someone help please? I have this function which works fine on test: void workorder.UsedQty(Work_Orders workorder) { for each recRow in workorder.Pick_Items { Item_Name = Maintenance_Item [ID == recRow.Item_Name]; Item_Name.Qty_on_Hand = recRow.Qty_Remaining; } } But when I want to set variable or call this function, I get the error “UsedQty is not a valid function” I am trying to call this function after a Field Action , On User Input , script as follows which
When creating a form is their a way to duplicate fields?
I am building a Materials Tracking application which has both shipping and receiving forms. On those forms we have 24 pallet and weight fields. Each Pallet field would be a drop-down to select the type of commodity being shipped or received. I would like to add them without having to manually input all options for each field. Also, as an add on question, is there a way to show the next pallet and weight fields only if the previous have been filled out? Thanks, Chris
Next Page