Script Error
The following fails to compile: fetchedNotices = Notices [Violation_ID == input.ID]; input.Resolution = (fetchedNotices.count()).toString(); Error at line number : 20 Form 'fetchedNotices' does not exist in this application If I remove the parentheses that were added by the system and use: input.Resolution = fetchedNotices.count().toString(); it works just fine. Bruce "Speedy G" Peaslee The World's Fastest Programmer
show records based on login
Our application contains records for several hundred customers. Each customer has an account manager assigned to them. (This is a one-to-many relationship, in which each customer will only have one account manager, but each account manager will have many customers.) Account managers should only be able to view/edit their own customers' records when they log in to the application. In the past, we have managed this by creating a separate view for each account manager, with a filter so that only the
Vertical list report
Hello, Can I create a vertical report but not as a pivot table but as a regular list? How could I achieved this? Thanks!!
default to current date
Is there a way to make date fields in a form or subform default to the current date (with the option to select a different date, of course)?
setting column sizes in subforms and reports
I'm trying to limit the width of columns that appear in list view reports and subforms. The default width is often much larger than the field name or any data contained in the field, and it makes for a lot of undesirable scrolling just to read or enter data. For the reports, I've tried going to column properties and setting the width for each column there, but it doesn't work. For the subforms, I have no idea how to go about doing this--and I really need to limit the amount of scrolling across the
HELP!!! filter lookup in subform android app
Hello. I'm having an issue using the set filter option. I have a lookup list filtered based on input from another lookup list on a subform. Works perfectly on the desktop but does not work on the android moblie app. The lookup doesn't populate the list. Anyone have any ideas? Thanks
Related List App and Prefilling Field
Hey All, I've been working on creating a Zoho Creator app that acts as a related list within Zoho CRM. Until recently we had trouble getting it added, but thanks to support, it's not linked up in Zoho CRM, and showing the records we want to show. That said, there is one minor usability quirk that I'm wondering if anyone know's how to work around. The "Add" form is "keyed" on the record we're looking at. (In this specific example, when we add a record to our custom app, it's keyed on the potential
Autopopulate a field based on 'New' action
Hello, I have created a custom module that has a mandatory name field. I need to autopopulate this field with a default value 'BST' whenever the user clicks 'New' to create a new record. The user does not have to enter a value in the name field. It should autopopulate. Please help. Thanks, Imran
Cannot duplicate an application
I have submitted a support ticket and sent an email to support and there's no resolution yet after a week of waiting. When I try to duplicate an app, the screen message says "duplicating" yet nothing happens. I have also downloaded the .ds script file and then import the script, and nothing happens. Some of my other apps also suffer from this, but not all This is under account sigroup Fix this today! John M. Whitney a.k.a. buzzap
Summary and paper size
How/where can I specify that, using the summary report, I'd like to print 2 records per page? Or 4 (2 across, and 2 up and down)? Is any of that possible?
can not copy/duplicate sample applications
Hi all, I recently started to use Zoho and am hoping to use sample application to learn faster. However, I could not successfully copy/duplicate the sample applications at https://creator.zoho.com/sampleapps/. The error message always shows me You have logged in as xxxxx@gmail.com. You are not allowed to access this application. I have tried to duplicate dozens of sample applications, none of them worked, but I can install free applications in Zoho market place. Is this due to the plan I have is
Show/Hide fields on subform based on selection from dropdown on same sub form
Hello. I need to know how to hide/show a dropdown picklist on a subform based on user input on another dropdown on the same subform Thanks in advance! Arlan
URL links for forms and pages for an application going to the Marketplace
I have a new application (my first to go to the marketplace) and need to know what format should links be so they continue to work when run by someone who buys the application. Are there placeholders for the top URL segments so they always resolve properly. I'm not sure at this point what part of the URL changes once someone is running their version of the application. Thanks. Regards... Rick Davey
count rows in subform
What am I doing wrong? I just want to count the total number of records in the subform that meet a certain criteria and input that count into a field on the main form. input.fieldinmainform = count(Subform[fieldinsubform == "LBR"]);
Sub Items And More users!
Hello, I just signed up for the free account but am very excited about using Soho for all my invoicing needs for my company. There are two huge questions remaining before I would be able to move forward. 1) How close are you to adding sub items? I have hundreds of products and need to be able to break them down into categories to make adding items to an invoice user friendly. 2) Is there the possibility of adding more users? I would like to be able to have 12-16 users. Please let me know.
Best Way to Archive Data?
My team has currently hit a dead end. We are trying to figure out the most efficient way to archive our data. Currently, the only way I know how to do this, is to have two separate forms. One is the “Current Bike Form” and the other is “Archived Bike Form”. On the “Current Bike Form”, once a certain criteria is met and when the submit button is pressed, it will add that record to the “Archived Bike Form”. While this method archives data, the data can get very redundant under the “Archived Bike
Bulk Edit - excludes one of my lookup fields
I have a form with lots of fields, some are lookups and some aren't. When I use the Bulk Edit, one of my lookup fields is not included as a field that I can update. Any idea why that one field is excluded???
How to Add Criteria to a API Request Using Form Method GET
I'm following the API directions to fetch a single record from a view using the form Get Method. I'm not a programmer and the documentation says you can add criteria to your request, but I don't know how to add the criteria. I can successfully access the view. The request returns the entire record set, I just want a single record returned. Can anyone help me with adding criteria to my API Get Request Here is my request with an attempt to add criteria as a parameter. Not working of course. <form
Pull multiple fields from Form A into lookup field in Form B
In Form A I have 3 different fields, Contact, Contact 2, and Contact 3, plus Email, Email 2, and Email 3. In form B, I have a lookup field that currently will only lookup the value of Contact and auto-populate the associated email. In the lookup field of Form B I need to pull the values of Contact 2 and Contact 3 also (if value is present) into the lookup field. Is this possible?
Skip weekends formula
Hello, I am building a database that will allow a user to set a target delivery date and choose a shipping zone. Based off of this information the program will auto populate the "needs to ship on date." My issue is i can not find a formula to add in the extra two days for the weekend if there is a weekend in the middle. This is what I have so far. Thanks in advance for any help. if (input.Shipping_Zone != "-Select-") { days = ((input.Shipping_Zone).subString(0,1)).toLong(); if (days >
Bi-Directional Relationship
FormA has a multi-lookup to FormB, with ability to "add new" FormB has an "existing relationship" lookup to FormA. My expectation is that, from Form A, I can add new values in FormB - the problem I'm having is that: I think FormB should automatically KNOW the value of the linking field, without my having to enter it, and it doesn't. Should FormB be able to automatically know the value of the linking field, because of the bi-directionality? Or is it really necessary to add the value manually????
How can I save a photo to an app with an iPhone or other mobile device?
I have an app that requires photo documentation in the field. I want to be able to enter text data into a form and then take a picture to be attached to the form in a field. I want this to be done with a Blackberry, iPhone and Android phone. Can this be done? Snap a picture and then attach/ upload? If not directly, does anyone have any recommendations on how to do?
HTTP JSON request - return no such view error
Hi I am trying to fetch data in JSON format from one of my views The below fetch call returns There is no such view in Zoho Creator http://creator.zoho.com/api/json/<application_name>/view/PriceSheet_Report/apikey=XXXX I like the above url to return the data in JSON format. Can please help me? Cheers -Jag
Assigning "Numeric Value" to Radio Buttons
This is a two part question (I will take one answer at a time if not one person can answer both LOL) Q1: Is it possible to assign a value to each individual option on a radio button? e.g. Radio Button Field 1: Was the Main Objective completed? Options: Yes = 50 No = 25 Radio Button Field 2: Was the minor Objective completed? Options: Yes = 50
importing apps
Have imported the Apache OpenOffice app for my linux documents, but while it seemed to install properly [even has own icon], when try to access it, all get is message that have lost contact with the page -- again and again and again. Anyone have a solution?
view an image or a file in a stateless form that is fetching data from another form.
Can this be done? I would like to be able to view an image or open a file that resides in another form in a stateless form.
anyone know why this happens?
From the iPhone app, when loading information from a lookup field, it only shows the following, 1 option selected instead of showing the actual info in the field.
Copy form to new form
I have been trying to figure out a way to create a new form based on the completion on a previous form. Im creating a master manufacturing record. Once that form is filled it & saved I need to create a batch production record based on that info from the MMR each time I make a production run. The MMR includes a subform that is built while completing the MMR. For example it includes mfg steps. Some MMRs will have 5 steps while others have 12. This subform is built using the add new option to certain
How to set column formats in table chart view?
Hi there I have a table chart pivot report. I would like to be able to configure the format of data within each column. For instance, I have a date column and I have selected "Month and Year" but instead of showing "Mar 2014" it shows 201403. Similarly, I have a column showing Average. This is an average of currency so I would like to restrict that to showing 2 decimal places instead of default (12?) Thanks for your help
Can I have 2 pop-up windows open at the same time?
I have a report, and I have a custom action that opens up another list, in a pop-up window. While that pop-up is open, can I use a 2nd custom action to open a form in another pop-up window? The only work-around I've come up with is to open a 2nd tab in the browser....
Data in form "A" not saving in form "B" in a nested IF/ ELSE statement
I have a customer service app (Form "A") that needs to save a date back to (customer_Info) form "B". The code is nested in a IF/ ELSE statement. The rest of the function works, but the updated date is not saving back to form "B". It is populated by the ID of form "B". ---> SiteInfo = Customer_Info [ID == input.Site_ID]; This section sends the email ok and with all of the info from form "B". It dose not save the date into form "B". What am I missing? // If the service is marked completed and the
esignatures
is there any way withint the zoho creator (or zoho writer) to add an esignature?
URL link for uploaded file v. download link
Is there a way to link directly to an uploaded file via a standard URL that allows the email/browser app to handle the file accordingly. For example: http://creator.zoho.com/zoho.adminuser/zoho.appname/FILES/uploaded_file.pdf I don't know what path 'FILES' would be? versus: http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName The form scheduler option to send attachments with emails is limited to 100 per
disable field on edit
Hello. Is there a way to disable a field on edit if it has data in it using script? Example: I have a service ticket for my field techs. One guy will add a record, then another will edit and add more data. I'm looking for a way to prevent the second guy from deleting data from the first guy. Each guy opens and edits the record multiple times so just can't disable on edit...only if data is there is what I need. Thanks
How to change message Invalid entries found??
Hello, Changing the message to my language Português Brasil? Invalid entries found. Please correct and submit again. TKS...
Calculation on a page
I need to calc this on a page Table: EntradasRomaneio Sum Field: Valor Grouped by Field: Contas_Banco I want to show the sum of Valor field grouped by Contas_Banco field in EntradasRomaneio Table
Adding record into form with lookup field (by custom action function)
I created a function to load a new record with data from one row of a report. The form I'm trying to add a record into uses a lookup field (integer). The lookup field is mandatory. When I execute the function, I get an error: "Reference field unit_code not having the value 465,202" (the 465202 is the integer I'm trying to enter into this field, but the error is showing it with a comma, could this be the problem?) Must a lookup field always be entered by hand?
replace date field datepicker with Calendar view?
I'm developing a job tracking application. There is a form, Jobs, that tracks each new customer job. Within that form, there is a subform for entering appointments with a client for estimates, jobs, etc. There can be more than one appointment for a job. The subform, events, has the basics for scheduling an event (event name, start datetime, end datetime, etc). I also have a calendar view of the events form. The event form is basically a schedule of all past and upcoming meetings with clients. When
Enforce Lowercase
I have an application set to only allow unique emails. However, I noticed that the same two emails can be registered as long as the upper/lowercase character are not the same. Is there a way to convert a string to all lowercase?
Can I show a related field in a form, without having a field for it?
Can I fetch and display the value of a field from a related form, without actually having to have a field to hold the data? This would be in On Edit, On Load example: fetchPerson[ID == input.person]; show fetchPerson.Email;
Next Page