How to open another form without validating fields in the current form
I want to include a button on FormA that switches to FormB. I use an OpenUrL() function in the button script on FormA, but the function first validates the fields on FormA. How do I switch to FormB without validating FormA?
CRM Search Record by Field other than ID
I need to retrieve records from CRM based on a variable other than ACCOUNTID. How do I do this?
Error: Zoho Creator does not convert openUrL() "form-perma" to "form-mobile" for mobile browser
When a form is opened on a mobile device using the openUrL() statement, Zoho Creator must convert "form-perma" to "form-mobile" so the form is displayed properly in the mobile browser. Zoho Creator does NOT do this. The form is opened as a regular form not mobile, so the form is too small and must be resized by the user. Example: openUrl("https://creator.zoho.com" + zoho.appuri + "/ form-perma /MyForm" should become openUrl("https://creator.zoho.com" + zoho.appuri + "/ form-mobile /MyForm" when opened
Records not automatically updating
Hi, I am currently using the JavaScript code as I cannot utilise the iframe code due to the hard-coded height. When I add a record it is not automatically updated in the results section that is embedded in my website. I have to manually refresh the webpage. When I tried to add the Next URL capability to it (that should provide a similar result to a page refresh) I received a 404 error. The target URL has a Zoho doman prefix for some reason. Is there a way to refresh the results page 'On Success'
HTML view - opening and closing forms
I have an HTML view page with an "Add Appointment" link which opens a form in a modal dialog, however I can't get the the form to close and then also have the HTML view page refreshed with the necessary querystring parameter intact. I have tried this: <a href="#Form:Appointments?zc_LoadIn=dialog&Client=<%=CID%>&zc_NextUrl=#View:Client_Details_View?CID=<%=CID%>">Add Appointment</a> After adding a record, the form closes and the HTML view refreshes but the "?CID=..." parameter is stripped from the
How can I collect user input before updating a record?
Hello experts -- I have an application that has a form which is doing 90% of what I need. Basically, it's form/report that shows orders taken (think shopping cart). When the order is ready to ship, I have my user edit the record, update a comments field, and mark the order closed by changing a status. Then they Submit and they're done. I created a button on the report for closing the order by just changing the status, so that's working fine. But I can't have the button prompt for user input. What
Best way to send email to a few hundred addresses
What is the best way to send email to a few hundred addresses? My concern is if I use a for each loop I will hit the 5000 statement limit or reach the daily max number of emails. The email subject & content is the same for all recipients.
Lookup Question
I am creating a very basic set of forms and reports to track a pet food pantry program. Our animal rescue supplies free dog and cat food to those in our community who are unable to afford. I have a form that tracks their information and then a form that we enter when they pickup which has a lookup so we can tie it to the person (customer). Two seperate questions: 1) Is there a way on the pickup form that we can have it automatically indicate in a field the last time they picked up food? 2) On
Records per page report property does not work
All list reports in my application always show all records even when a 'Records per page' display limit is set in the Summary section of the Report Settings. This is a major problem because it causes reports to load slowly and greatly impacts the usability of the application. I have verified that the the report definition includes the option to limit the display rows and have tried various values, non of which work: options ( display rows = 20 ... This error also occurs when the report
Help with Creator
Does Creator have capability to be viewed as a database? I cannot figure out how to link applications to form the database. Nor can I find an option to view my records already entered. Please help! RHouse
Problem Importing number field
Hi I am having trouble importing number fields from an Excel file. In my form I have to Number fields, one for the ID number and the other for the phone number. In the excel file the columns are defined as number columns and they have numbers like 1144035567 for ID´s and 3155467898 for phone number´s for example. When I want to Import the file I get an error alert for this two fields saying that those are invalid numbers for numeric fields. Error details of records that could not be inserted Row
Customize Layout Fails After Restore
I created an app in another account, exported to the DS file, and imported into a new file. That worked ok. However the restored app cannot the Layout or Theme. After the import it defaulted to one layout and it seems it is stuck. Any ideas?
If statement Function
I am trying to use a function to contain a large if/elseif statement and then simply call the function in the on user input of multiple fields in my form which would allow me to simply edit the function instead of editing every field when I need to make a change. My assumption is that this is possible but I'm quite stuck. I've written a simple test function using a form object and it seems like it should work but I haven't been able to figure out how to call it. Here's the function as I've written
How to programatically add one-to-many relationship??
I have a one to many relationship between Student and Course forms. Each student can have multiple Course. The intention of the following code is to test how to add multiple courses to one student. But unfortunately did not work. Can anybody tell me how to do it properly? Student.On Add.On Success: c1 = Course [Name == "Course 1"]; c2 = Course [Name == "Course 2"]; input.Course.add(c1.ID); input.Course.add(c2.ID);
HTML Page Issues
We have a dashboard built in a HTML page. Recently the dashboard has collapsed down to three or so lines, with the content overwriting itself and I think this is related to a recent Chrome update. Is anyone else having this issue or does anyone know how to resolve it?
Maximum number of fields in a form
What is the Maximum number of fields in a form? Thanks.
iPad: embedded report not scrolling
NOTE: This is not a Creator problem. It is a problem of rendering on the iPad and the scrolling works fine on a laptop, however I am hoping that someone can help me. Here is the problem: An embed script can be generated from a Zoho Creator report and used to embed the report into a page in a Google site. The embed snippet looks like this: <iframe height='500px' width='100%' name='reportEmbed-CLIENTRR1' frameborder='0' scrolling='auto' allowTransparency ='true' src='https://creator.zoho.com( actual
How to change display type for a relation?
Is it possible to change the display type of a bi-directional relation after it's created? How? I have a one to many relation, but i want to change it to one to many. Clicking on the display type won't do anything. See screenshot.
Importing data from excel to mandatory fields
Hi If I have a field set to mandatory, once I marry up the corresponding field in Excel to the field in Zoho creator, it fails. Is there a way around this aside from the obvious? Thanks
Form picks wrong email address
Good day, I have created a form where external parties can enter data and in the bottom fill below two fields: Send by: Pick email from drop-down Cc Receipients: Pick email from multiple select Then when submitting the form, same will be sent to predefined receipients, the sender (send by) in Cc, and then the defined Cc receipients. The first, Send by works fine and when replying to the emails, the email will reply to the actual email address stated. Howver, the Cc fields work in a strange way, as
Something is wrong with Views
Sometime between last night and this morning several of my views have stopped showing data in columns that point to linked forms. These are views that had been working in essentially their current state for years and now the columns are just blank. Is anyone else having this problem? Or have any ideas at a solution?
Zoho Creator Customer Portal - App access
Good day Zoho, I've read through the Customer Portal section - but I cannot seem to get a confirmation on whether customer portal is accessible via the Zoho Creator App or not?
Zoho Creator postUrl "Content Type (415)" Error
I have a simple postUrl script in a Zoho Creator App to receive an authentication key from an internal application. See below: myHeader=map(); myMap=map(); myHeader.put("Content_Type","application/json"); myHeader.put("Accept", "application/json"); myMap.put("userName","xxxxx@xxxxxx.com"); myMap.put("apiKey","xxxxxxxxxxxxxxxxxxxxxxxxxxx"); resp = postUrl("http://test.myeddy.info/habi-ws-ergon/api/v1/token", myMap, myHeader,false); info resp; However, It gives back a 415 HTTP error which I believe
Pretty Link Pro URL shortener
Has anyone tried to use Pretty Link Pro to brand published form URLS? Does it work?
Error Reference field not having the value when adding a record
Adding records fails when it involves a lookup field. Here's an example: I have two forms: Participants and Surveys. Participants has an autonumber field called Participant ID with a Deluge field name of participantId. Surveys includes Participant ID as a lookup field with a Deluge field name of surParticipantId. When the user updates a Participant record and submits the Participants form, the following is executed to add a survey with the Survey's Participant ID populated with the submitted Participant
Having trouble on edit.
Hello, I am working in a purchase order form with the following structure. Purchase order: date - date company - text provider - text email - email subform total order cost - currency Subform (in purchase order): reference - lookup to product catalog description - text cost - currency IVA - number cost plus IVA - currency quantity - number final cost - currency The form works perfect, but on edit mode I am having some trouble. The problem is that when I want to edit the Cost field or the quantity
Is it possible to Bulk Update Records so that Formula Values based on time Update?
In my app, as each month turns over, fees accrue. A formula field shows this accrual less payments already made. The value of this formula is the account balance until a new month begins. How can I bulk update records so that the balance reflects the beginning of a new month? Can such a bulk update be automatically scheduled to happen on the 1st of each month? I've been studying Functions here at Zoho Creator, but don't have a solid understanding yet. I am hoping there is a basic function code
Problem with formula
Hi, i'm having trouble using Formula for my business as investment mangager. I already created a module for "Investments" in wich i can establish the value of my clients portfolio. I just want a formula with some kind of button in wich i can add new money or interest payment to the field Cash inside my investment module. I would apreciate andy kind of help. Thank you Samuel
ZC and ZS integration issue
res = zoho.support.create("Requests", "test", "test", { "Name" : input.Name, "Contact Name" : input.Name, "Subject" : input.Request_Category }); Trying something like above, but got this error {"message":"Invalid Ticket Id","code":"1000"}
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
Record Summary Public
Is there anyway to make a record summary viewable to the public. I have a report on my website showing available inventory with a custom action to show more info by opening the record summary in a pop up. However, it just redirects my visitors to login to zoho and says they do not have permission to view it.
showing the rent amount as weekly or monthly option
I am trying to create a tenant reference form and in the form i need user to enter the rent amount as a weekly or monthly option. After user input the amount in rent amount field, i would like to achieve that user can specify the rent amount as weekly or monthly How do i achieve thanks in advance
field rule for if a field is empty or not
I'm setting up a DB for keeping track of product photos. One of the fields is "Date received", meaning the date we received a photograph back from the photographer. I have another field which is to be a "Do we have the photo, Y/N". This field will be used on another related DB so we can see if a photograph exists for a product or not. I'd like to set the "Do we have the photo" field with a rule that says "If Date received is NOT blank", then set this field to Yes. Is there a way to do something like
Deleting Records before import
When importing data from a CSV/Excel file inside of a Report (using the little gear icon), is it possible to write a script that removes all records from the database prior to importing? Each time we import data this way, we want to completely empty the existing data set automatically and replace it with the data we're importing. Any help would be greatly appreciated! Thanks
Lookup
Can a Look Up field view more than one field? For example, if a Look Up field is to select a Device Code field from the Devices table . But the Code field is meaningless. I would like to view multiple fields from the Device list, say a friendly "Name" field and perhaps a "Room" field when we select a device, we want to store only the Code field in the Look Up field. Hopefully that makes sense?
Functions does not work at Linked View from another Application PLEASE HELP!
Dear All Please help me About this issue. This is first view from Orginal APP lets say App name APP A Here all Functions work as you see "Sevkiyat Planla" "Boyahane Planla" ------------------------------------------------------------------------- This is lets Say APP B and here you can see Talepleri is Linked to APP A (lookup). After Click This as expected view from APP A opens. ----------------------------------------------------------------------- We are still in APP B here and we have view from
12 Hour Time: Simple Solution
EDIT 07-FEB-2012: I made a free marketplace app for you all to test https://creator.zoho.com/public/showAppInfo?canvasurl=kqpjzaljg There are a number of posts here about TIME in ZOHO Creator. Many have requested ZOHO supporting a 12 hour format. With some help from Gave a while back, I have been using a rather long function to verify if a user typed in proper 12 hour format (i.e. 12:15 am or 05:00 pm but NOT 1:15 or 07:00 PM). I found a better way to do this that only uses a few lines of code.
Changing the Date-Time format
How do I change the format of a Date-Time field? I don't want it to be 13:00:00 -- instead, I want it to show 1:00 PM. Also, is there a way that I can have the date also show the day -- so ideally it would read: Mon Nov 3 2008 1:00 PM Thanks. Ellen kidspace
Rich text editor for mobile phones
Hi Zoho, Just wondering whether rich text data input/editing capability for mobile phones is on the road map any time soon? Thanks,
Show user filter criteria of pivot chart on pdf export
How can the 'User filter criteria' of a pivot chart be shown on a pdf export? Ideally, I'd like the criteria to be the subtitle of the report. I have many assessments that users can create themselves. They see a chart of the results by choosing the assessment name from the User filter criteria on a pivot chart. Thanks!
Next Page