Update Date Field after sent email
I have created a send email form, which works fine but I need to update a date field to show when the email was sent and am having a hard time with the script
Email link to a form
I have created a form that records support issues from clients. What I'd like to do if possible, is when the form has been updated, an email is automatically sent to an external person that contains a link, which when clicked, would display the details of the support ticket using a Zoho summary view. Is this possible? Thanks, Martyn
Dropdown list is not updating correctly
I have a dropdown list that updates when another dropdown list is changed using scripts. I've noticed that the update is only working selectively on some records but not all. Why? I have not thuroughly checked but it seems to happen on the records that I imported instead of manually entering into the db. Please advise on this as without this working I cannot use my application correctly. I will enable access to support. Please check the "Division Orders List" form. Try selecting a 'Lease"
View/Table is not present in the database
After attempting a backup I am getting this response to most of my reports. Please assist.
Currencies and graphs
The units used for currency fields for reports is defaulting to $. This is in spite of the fact that the field value has been set to local currency of ZAR.
getting exception
when i try to save my script, i keep getting this exception after waiting for a long time java.lang.RuntimeException: java.lang.Exception: com.adventnet.persistence.DataAccessException: java.sql.SQLException: org.jboss.util.NestedSQLException: Interrupted while requesting permit! Waited 0 ms; - nested throwable: (javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms)
Inconsistent Null Behavior
When the “No duplicate entries” checkbox is checked, Single Line text fields do not allow more than one null (blank); however, numerical fields such as numbers, currency, and dates do allow more than one null. This inconsistency can cause confusion with developers. Zoho should choose a behavior and use that same behavior for all types of fields.
use of Replace functions with special characters
Dear all, I would like to create a script which would identify specific text strings within a field and replace them with XML formatting tags. Say I this specific string is "XML", the tag is "<XML>" I guess a correct use of the Replace function would look like this : replaceAll("XML","<XML>",true) I tried is but the "<"">" characters would not be output. I also tried to use backslash characters in the replace function like this: replaceAll("XML","\<XML\>",true) But then the backslash characters would
Custom Action not responding
I'm having a problem with one of my view's Custom Actions options because it's no longer responding when clicked. All other views are fine. Any ideas?
Problem when trying to Edit Application with Internet Explorer v7
Today, I needed to have simultaneous Access to ZOHO Accounts owned by me and my Client ... so I signed on to one of the Accounts using Internet Explorer v7 ... found out that it has a defect ... when trying to view/edit Custom Actions for a List View ... a) it did not list the existing ones b) when attempting to create a Custom Action, Internet Explorer reported that the connection with the website was no longer available. Gaev
URL syntax
Can you help with the required syntax for the following: I want to create a function that is linked to a view that when clicked opens a new form and passes a value from the view to a field in the form: The view is called 'support_view' and has a field called 'ticket' - the form I want to open is called 'support_note' which also has a field called 'ticket' - it's the ticket value I want to pass to the form. Thanks, Martyn
Drawing numeric value from another table
Hi - I've consulted the Forums on this topic but can't seem to make this work. I have a numeric value in one form - form is Product Information, field "Number" - and I want to import this value into a second form- Product Cost - so that I can use the "Number" value as part of a formula. In the second, "Product Cost," form, I set up a field and tried to import the "Number" value from the "Product Information" form, but I can't seem to make "Fetch" work. In the first form, the "Number" corresponds
Need Help: Creator "Reports" are displaying decimal values as integers and not summing correctly! Help please
I spent the last weekend setting up Creator reports for my organization only to discover that when the reports are generated they have a MAJOR problem that renders the entire Report function UNUSABLE. The problem is that any decimal values being displayed in a Creator Report (e.g. 0.50, 3.5, etc) are rounded down to an integer, resulting in INACCURATE DATA being displayed and summed in the report. Example below.... note: all values shown as integers though many had decimal data, no decimal values
help
hello. my name is ben and my research group is aiming to deveop a website that will manage records that will be submitted by multiple users. and im wondering if i can use zoho to store the records in the database at the same time manipulate it on offline mode. there is also a prcoess wherein the the input that will be sent by the users will be stored on a temporary storage and will be filtered by the administrator of the application. can zoho do that?
Feature: Browser tabs should display VIEW NAME (useful!), not "Zoho Creator <Your Org Name>" (useless)
I, like most developers while working w/ Creator, keep several browser tabs open at a time, each w/ different Zoho views, forms and editors displayed. But, when you look up at your row of browser tabs and all you see is "Zoho Creator <Your Org Name>" repeated several times... it's useless. BUT, if the tabs were to display the NAME OF THE FORM, VIEW, or EDITOR displayed instead, then that would be really useful (and easy to implement on Zoho's end). Otherwise, I'm constantly clicking nameless tabs
Creator App using Project API
I am using the Project API from Creator. I am trying to get all time logs (timesheets) for all users, but I am only getting the logs for myself. The "ticket" that I have created for the api is using my userID/password. Please help - this is a critical requirement for my application.
Is it possible to have a realtime updation of graphics.
I have a question regarding real time updation of colour of certain graphics. For example, suppose that I own a lodge having number of rooms. Customer 'ABC' is booking a room(i.e.room no. 10) from Delhi at the same time another customer 'XYZ' is booking the same room(i.e.room no. 10) from Chennai. Now the problem is that if customer 'ABC' booked the room(i.e.room no. 10) one second before 'XYZ'. How can a booking agent at Chennai come to know that the room is booked, so that he can tell customer
Automated application documentation
I've created an application in Zoho Creator - a whole lot of forms, views, custom actions, functions etc. While the application is shaping up quite well, I've begun to realize that I have not created any documentation on the application software. Without documentation to fall-back on, I can imagine life getting quite messy down the line. I believe the Zoho team can come up with a simple solution for this. The fields, forms, views along with their actions (on load, on submit, on user input etc) are
Open Duplicated Records in Edit Mode
I'm tracking certain items where new records often are the same as old with the exception of a change of date or other minor difference. It would be useful for the duplicate function to open the new (duplicate) record in edit mode so that I don't have to scroll around looking for it after it's created. Thanks.
on update ....can not make it work....About to dump zoho.
Hi, I am almost giving up witht he On Update command. I am trying to update fields that I called out and following the example and I can not make it work. I want to query using the serial number and puplate the rest of the fields (that pieces is working) but then I want to be able to modify such fields and update them back ino the DB,......... that piece is not working. here is my complete code in case soemone can guide me.... form Actualizacion_De_Players { displayname = "Actualizacion
Changing view criteria based on user?
I have an public form that i have multiple sales people submitting sales information to me from. I want these sales people to be able to view all records that they have submitted. I do not want them to be able to view other sales persons records. Is there a way using html views to have them input a user name and password. If it is correct, view all records that they have submitted? I figure they submit a logon form that then does an if then and determines if it should forward them to the view
Adding a new User
I've been trying to add a new user by entering their email address, but no email is being sent to the new user? Am I missing something? Martyn
500 Internal Server Error
I'm trying to post a new record to my Zoho Creator app via the REST API POST and JSON format, but I get a "500 Internal Server Error" back. I'm using the format: http://creator.zoho.com/api/private/json/<applicationName>/<formName>/add/ What might I be doing wrong?
Another Defect ...
Just noticed ... In List Views ... when specifying Set Criteria ... with Show Restricted Records ... it lets you select the Field Name and the Field Value ... and allows you to click on the Done Button ... but when you return to this section, the Field Name is reset to Modified User IP Address. Tried it in multiple Views with different (single line text) field names ... same result. Is this another case of Another Update ... Another Defect ????? In any case, it needs to be corrected urgently as
Number of Form Fiels Available? I need to have a form with many many fields........
I have run into a problem. I need to collect data various data on a form. I have to collect sampling data on 13 items subdivided into 6 categories having aproximately 7 to 10 questions each. For Example: 1. We require our inspectors to inspect boxes. 2. For the number of boxes recieved, a certain amount need to be inspected. 3. Each box will have 7 to 10 questions that must be anwsered as to the condition of the product recieved. Once the data has been collected, various
Intermittent strange text artifacts in Free Flow editor -- what is it?
I occasionally get very odd text artifacts in the free-flow editor (image below). I've seen this effect in both Firefox 3.66 (Mac) and Safari (latest version), and I think I even saw it in Chrome (Mac) one day when trying to escape the effects. For no clear reason, the editor sudden displays a shadowy replica of the code in light gray shifted down a few lines. It creates problems with cursor placement and readability. This effect is intermittent, not all the time. But I've seen it almost daily.
Is there any way to filter releated fields values with dropdowns choise?
Hello! I have two views with records like View 1 Field A 1 2 View 2 Field A Field B 1 A1 1 B1 1 C1 2 A2 2 B2 2 C2 Both views have fields 'Field A' with values corresponding to each other I need to create a form 3 where selection 'Field A' value = '1' in dropdown for the 'Field B' will show only records 'A1,B1,C1' (releated to 'Field A' value = '1') and on select 'Field A' value = '2' in dropdown for the 'Field B' will show only records 'A2,B2,C2' (releated to 'Field A' value = '2') is there any
Global Search
Over the years several people on this forum have asked how to build a global search. Unfortunatly I could not find an answer in the forum. I need the user to enter a search string and then a view of all records that contain the string in any field is returned. Any suggestions? Herb Wexler
How do you restrict viewing of solutions?
I am using Zoho Creator Helpdesk through Google Apps. I want only certain users to be able to see the solutions. I couldd have some private and some public, but if the only way to do this is to make them invisible to all but the techs, that is okay to. I tried to use the criteria for the Solutions List, but could not find a way to make this work. Any ideas?
Emailing Help
Ok I Am Makeing An Emailing Function In My Forum I Have A Email Options Where They Put The Email In The When They Hit Subbmit It Emails Me But I Want It To Email Me and The Email That Was Subbmited In The Form. Is There A Problem Or A Bug With This Could Someone Please Help Me. Thanks, Russell P.S Sorry For The Spelling
Is It possible access zoho crm database with creator?
We are developing an application in zoho creator embedded in zoho crm and the need to recover customers, articles, contracts ... from the crm database. How we do it? Thanks
Registration for my website
Hi I'm trying to find out if I can seamlessly use Zoho Creator to provide a register and login function on my website. I want the user to feel as if they are registering and logging into my site rather than to a 3rd party database/service. Is this possible? Many Thanks!
Graph Currency
I've created a graph but the currency symbol is $ - how do I change it to £? Martyn
free flow scripting - editor does not work properly in chrome
Hi, I am trying to use creator and work with free flow scripting in the chrome browser. the display is totally messed up
Insert Domain to Requester
Hi; We have 4,000 requester and i like to insert Domain in the requester information.
How does one stop processing of a second click?
I face this issue both in a regular form and a stateless form. The processing of actions for both necessarily take time on the server side, and "Loading" alert pops up sometimes, but frequently it doesn't. The user is therefore tempted to push Submit again, which leads to a duplication of data creation. I found the "cancel submit" option for forms, based on the data having already been created; however, a user pushing the button a second time quickly will beat this creation process and a second
Query only rows where column matches X criteria?
I know this has to be simple. I could write this query in my sleep in SQL, but I'm short on time and trying to figure this out in Deluge. Basically I'm trying create a report that will only list the values that I specify in my script. For example... say I have column called ComputerName that lists out roughly 400 computers. I want to pull a specified list of computers. In SQL I would write it like this... select * from database where ComputerName in ('computer1','computer2','computer3',)
OpenURL query
I want to be able to display transactions between two dates using the following script, but doesn't work: openUrl("#View:Expenses_View?Date_field=" + input.Start_Date;input.End_Date, "new window"); Any ideas? Martyn
Where is the Save Setting being Stored?
I applied the steps described at https://help.zoho.com/portal/en/community/topic/how-do-you-to-sort-on-a-hidden-column-in-a-view#2266000001132452 that tell how to sort on a hidden field. After several attempts, it finally worked. But when I examined the .ds file I was unable to see where the change was made. The script of the view looked the same before and after I did the save. Can anyone tell me where this setting is being saved? Is this setting only good for the user who is saving the setting
HTML view: Error when use Rich text mode
Hi, If I try to make ANY changes using the rich text mode in my HTML view it gives me the following error: Lexical error at line 1, column 12. Encountered: "\\" (92), after : "" It doesnt even let me shift to plain text mode after this. All I can do is press cancel - but then my changes are lost. Please help ASAP Thanks
Next Page