How can I filter the form view to show only the sum totals in my groupings
I have a form view that shows several groupings by city and all of the city's records. How can I filter the view to show only the city grouping name and it's sum totals on the last row?
How to reformat the Date-Time string (e.g. 05/28/09 11:00:00)?
Been searching through help docs and trying substring manipulations, but getting nowhere, so asking this kind forum for assistance. The "Time" field in a form generates values that are formatted like this: 05/28/09 11:00:00 When building a Dashboard, I don't want the trailing "seconds" to show in the time, so I've tried several things: - looking for a preferences setting that would change the default time format -- None exists that I can find - searching Help Docs for a code statement that allows
Formulas
How can I make a formula into dollar signs? The two fields that are included in the formula are dollar amounts but the formula isn't. Any suggestions?
Restore error 'java.lang.NullPointerException '
OK another friendly error message attempting to restore a backup. The entire application gets restored but not the data or customization (theme)???
hide/show not working on Edit
In one of my forms (Inventario) I have been using the script hide/show to hide or show fields based on the condition of other fields. They work as they should on a new form input but when I go to edit a record the form doesn't hide the fields, it just shows everything. Am I using the script correctly or am I missing something? Thanks.
dons't work for current view to total number
Hi When associated with another table, dons't work for the view to total number,although the show yellow， like bellow screenshots Stanley Guo
Enable New PDF Generation Beta
I was checking my account tab in ZC today and noticed this: Does anyone know where this new beta feature presents itself? I would guess its available when selecting View Record from a View that has a Custom template assigned to it in the 'Record Summary' section within the View/Report settings page? When I try to use this function though any PDF I export is corrupted and will not open in Adobe Reader. Print option seems to confirm my thinking though as it prints the data as set out in the custom
How to Filter using a Related Field?
Hello, We are a Real Estate Company and wanted to try out Zoho. We have made an application for managing the various Projects we have. Our DB Structure is as follows: Project (one-to-many) Configurations Location (one-to-many) Project ------------------------------- Configurations: Project Name (Lookup Field Project Table) BHK Type Area ... ... ------------------------------- ------------------------------- Project: Project Name Location Group (Lookup Field - Location Group Table) Exact Location
Can Creator duplicate everything that Zoho CRM can?
If so, I need for someone to develop an App for me... I'll pay. It needs to duplicate everything in my CRM
More ADMIN users
How can I asign ADMIN privileges to more than 1 user in Zoho Creator? Thanks
create a picklist based on criteria, how to setup the formula?
In Form Class, the field linked to For Student is a multiple select lookup In Form Student there are fields First_Name, Last_Name I have another form, called StudentInfo Field: Student (picklist to Form Student) Field: Class (picklist to Form Class) But I only want to load Class that are linked to that particular student chosen. Consider example: Student: Name: Jane Doe Student Name: John Doe Class Class Title: Science Students: Jane Doe, John Doe Class Title: Math Students: John Doe In my Form StudentInfo
"Duplicate Application" function not working for one of my applications
I contacted support, they could replicate the error. But I haven't received any confirmation and don't remember if they gave me any kind of support ticket number or anything of the like. My application is available for support to access. What would be reasons, for application not duplicating?
What is the proper code indentation convention in HTML pages?
I'm finding it confusing to read code with both <% type tags with zoho script code. For instance how would you tag and indent a block of code for each, which fills in cells of a table? What if you have nested loops? <% for each i in IForm { %> <%for each j in JForm { %> <%=j.data %><% }}%>So maybe its not so so confusing with this simple dummy text, but then the editor automatically does some corrections of its own and spaces things like crazy, so what rule is it following?
Criteria Help!
Hi- I am looking to restrict the number of entries in a lookup field in my form and need to specify the deluge criteria. I'm stuck! I currently have two fields I want to restrict with the return of records: "status" field and "discharge_date" field. I want the criteria to return only records that are either "active" status or have a discharge date within seven days of the current date. Can someone help me with the correct criteria to use? Thanks, Troy
Make public to all visitors over the web??
Hello! What pricing tier do I need to enable this radio button?? "Make public to all visitors over the web (Upgrade to use this option) " Is there anyway this can be purchased as an "Add-on"?? Thanks, any advice would be great!
Linking Creator Form to Report
I've found a lot of support for older versions of Creator but haven't found step-by-step instructions for the following using the new application builder: I need to link a Zoho Creator form to an already existing report in Zoho Reports. In addition, how do I deal with a multi-select field from Creator in Reports? Thank you in advance. Adina
Importing incorrectly triggers "length of field" error for related field
Issue: Form has a lookup field to another form When importing, Creator occasionally--and incorrectly--indicates imported value for this field is too long Workaround is to rename value to something very short, import, then change the name back Example: One form called "Restaurant Types" with value "Fast food restaurants" One form called "Restaurants" with fields "Name" and "Restaurant Type," the latter referencing the "Restaurant Types" form CSV import attempted for "Restaurants" with record having
Script for "Today and prior"
If anyone can provide this, I'd appreciate it very much.
Auto add records
Hi I would like to create a new record in a form & then when submitting it automatically create a number of new records in a second form based on a number in the first form. I have a "Print" & then a number of "editions" of that print so that when I add the "Print" details I would like to create an edition record for each number of the "edition". How would I do that ? Thanks Derek
Currency VND
Hi, I used currency VND but your software display it as ZNK??? What is the problem?
Sub-forms and PayPal
Hello! We want to use Creator to capture registrations and bill for that registration(s). I have a primary form where the parent or guardian enters their information AND they are able to submit a donation of any amount if they choose. That Creator passes to PayPal. However on the sub-form where they are then registering their children (at a price of $10 per record/registration) which I have setup as hidden fields (the item, cost, quantity), after hitting Submit it's only passing the donation amount,
Sub-Forms of Sub-Forms?
Hi I've checked all sub-forms but I couldn't find an answer. My form X can draw a "single line" info from Table 1. My form can not draw a "subform" info from Table 1 (or any table). Does that mean that only single lines but NOT sub forms can be accessed via look up? Thanks Ben
How to restrict users to access a record in the table
I am making family/individual management application. I want all users to login to add/edit their family/individual records, but they should not see others' information. Adminstrator group, on the other hand, should have a full access to those people's information. I am new to Zoho creator. Is it technically possible to do with Zoho Creator?
form layout in html view
Is there anyway to drastically change the layout of a form in an HTML view? I'd love to be able to use my own styling and put the fields where i want them to go - I have a rather lengthy list of data, and I would much rather be able to arrange it as I see fit across the page, instead of a long list down the page. Any ideas?
Using our own domain name for our Zoho App
We are using Zoho Creator Professional Plus. Could we use our own domain name instead of the <creator host> (https://creator.zoho.com/) part in the URL, for our Zoho App? i.e.: https://creator.zoho.com/my_username/my_app to https://my_domain.com/my_username/my_app
100K records - what if you want more?
Hello all, very newbie question I am sure. I currently work as a project manager for 2 different companies implementing a 3rd party management suite for finance, supply chain, property management and tenancy. I was looking for an alternative "approach" and being a long time user of zoho in its other flavours, I thought I would see what it could do here. How is a record define? Is it just a row in a table? what if you need more than 100K? can a record be split across multiple tables and count as
Script doesn't update
I am trying to modify a user defined function that I have called udf_ccc.get_ccc. After I make my changes, I get an endless "Updating Script..." message. The function would not update and I would close it after 5-10 minutes. As a test, I added the following code test_variable = 0; The first time I saved the script, I got a "null" message. I'm not sure what it means so I tried saving it again. The second time I saved the script, I get the "Updating Script..." message and it does not finish updating.
custom domain
Team Creator, I continue to be impressed with the quality of Creator and the patient, helpfulness of the support team. But the killer feature I have been waiting for over a year on is still a mystery. Can we please get some kind of concrete update on the future of being able to customize the domain of our apps? Many thanks.
Code for Form Being Ignored - Urgent!
Shared to support Form:Contact_Record Try to edit a record: The type option for student and parent is not working to show/hide field values App: buzzap/edirectory Cheers, John Whitney
Upload proble; Exportto different field names problem
Hi Zoho people In my new event app form some things dont work: ( I used new builder) (generally great by the way!) 1 Sub form > I have "name" field and "instrument" field. This data arrives on export as a long row of digits instead of words e.g. LINE UP : 1112234000000026029, 1112234000000026033 2 Uploads of images, PR docs: not appearing in exported file (images was small < 500k) In the sent email the FIELD NAMES for those do not appear either. 3 A problem using drop down font selection in
Schedule Email reminder for every 3 days based on Status
Hi All, Actually i want to create a schedule which sends reminder for every 3 days till status changes to other value. Please let me know if there is a way to achieve that method. kmkr :)
Setting privileges
I am restricting data access to views by using the filter Added User == zoho.loginuser. This works great to ensure that separate users do not see each other's records, however, I need the Admin to have access to ALL records from ALL users. How can I do this? Thanks.
large database support
Our database of consumer records is now pushing well past the 100,000 limit for Creator and I would expect it will continue to eventually grow into the range of several million. Has anybody worked out integration with SQL type service to manage the larger datasets while still being able to import/export in campaign sized groups of say 25,000 and be able to keep using the applications we've built with Creator? Malcolm.
Change row color in View when field is not null
Hi, I already found a post where it's shown how to color a particular entry. I actually need to change the color of each row in a view, when a particular field of that row is not null. Plz help! Thanks...
Urgently need help for execute event in Sheduler
Hi Akash I try many times for execute event in scheduler,but they all failed and I checked the email address is correct,the screen disply as bellow: Error details:Error in executing 房源状态图示 script(Custom Schedule). Error. Error in executing Send Mail task. InValid email Address Found. Thanks for your help Stanley Guo
Reply to: not functioning properly in new app builder
If I add a reply to: or change and existing one in the new app builder, I get an error when I save: zoho.sendmailtask.rpltonotallowed And a red box around the line. If I switch back to the classic app builder, it saves fine.
Refer Fields box should show the current form
Hey Zoho, it bugs me slightly that the Refer Fields box shows the most 'alphabetically superior' form rather than the current form. Could you change this? (See screenshot below)
Trying to add the resuts of formula fields - Help
I'm trying to make formula field, where I'd like to use variables from another formulas in this form. In result there is warning message, that "variable is not declared". I would like to add the sum of the formula fields to get a total cost. Thanks Ed
Create View showing records for Today and next 7 days
Hi, How would I accomplish creating a view that would display records that occure between Today and the Next 7 Days? This is waht I have, but it's not working. (Start_Date >= zoho.currentdate && (Start_Date >= (zoho.currentdate + '1W:0D:0H:0M:0S') && Start_Date > zoho.currentdate)) thank you.
Problem Restoring backup
While trying to restore a backup (and after changing the name of the application to "AppName backup" on line 6 I get another error about [Sub_View] column 'FORM_ID' cannot be null . No idea where this error occurs in the script or how to find it.
Next Page