Script doesn't work in edit mode
Hi, I have an issue with the edit mode of a form. My form is loaded with a lot of scripts, both configured "on add" AND "on edit". It works fine, except in one case. I created a view to allow some people without login to edit some records. It's a search form, that opens a view with selected records through a "non login" link. In this view, users are allowed to edit records. The problem is there: in this specific case, the scripts doesn't work... Has anyone an idea ? Regards.
Can the user add additional fields as needed?
Hey all, What I would like to do is allow for multiples of select fields such as email adresses and phone numbers if needed. For example if someone has multiple email addresses you could fill in the first one then add an additional email address. It would be great if they could name the email with a tag of sorts like home, work etc. Is there a way to accomplish this? Thanks
URL Encoding Error
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
How to make a condition in zoho creator
How to create a condition for example I create a checklist field and then when I select no nothing will happen but when I am going to select the Yes button I want to display below the checklist which is a single line "How many" and in that i can be able to put a number on that. Please help me.. or contact me in skype i need an answer skype: srepoyo
UpperCase all text
My client wants all data in zoho to be stored in upper case. What is the easiest way to do this? There is already data in mixed case and there are over 30 forms.
Extracting Account Name from CRM Contact Records in Creator
I'm building a Creator application where customers submit a monthly status report. I'm provisioning a representative at each customer as a Creator user, using the email address that is in that representative's CRM Contact record. Then that representative will log in to my Creator application after each month ends to submit a report. When a representative logs in to Creator, I retrieve the login email. Then I want to look up all CRM Contact records with that email, retrieve the Account Name for
Null error when saving html view
I have a html view called GLOBAL_SEARCH which I want to modify. I have tried adding in new code and I get a "null" message when I try to save my changes. As a test, I refreshed the page and made no changes to the script. When I clicked Save Script, I still get the "null" error. Why can't I save any changes?
Open URL problem for Edit
In the Workfolw application i am using an OpenUrl for form edit like: Urlstr = "#Form:Job?recLinkID=" + input.RecID + "&viewLinkName=Inbox&zc_LoadIn=dialog"; openUrl(Urlstr, "same window"); It is working perfect when logged in as admin user and owner, but if i share the application with another user the Job form is not opened, but instead the first TAB /Dashboard in the application. The openUrl call is done in the function Forward. Application is Workflow, and it is open for support. Dan Andersen
Criteria for Lookup Field - Non-Consistent Results
I have a FORM called People, and consider it to have only two fields : NAME COMPANY Second form is 'CATEGORY' with two fields COMPANY CATEGORY NAME I have another FORM called 'Request', with the following Fields NAME - Lookup from form 'People' COMPANY - Single Line CATEGORY - Lookup from 'CATEGORY' using Criteria Category.Company=input.Company Request Detail - Multi Line I have some deluge script on 'User Input' for the FORM 'Request' whereby, I get the 'PEOPLE' record corresponding to the name
Carriage Returns without XSS security set to low
Hi all I have looked through previous posts to find out how to insert a 'carriage return' in a multiline text field using script and have tried using "<br>" and "/n" however to do this you have to set XSS security set to 'Low'. However I belive that it is now longer possible to do this. Has anybody else come across this and know how to achive this. Script below takes each record and adds two fields seperated by a hyphen to a string then adds the string to the mutiline text field followed by
Field types don't match?
Hi, I am trying to write a function that will go through a set of records and sum a given field (Field B) if criteria for another field is met (Field A). So if Field A = "Yes" then add Field B to a sum. Below is a function I use to sum all the values in Field B (Man_Months in this case): float TotalJobsCon() { countMonths = 0.0; for each r in JobCreationSchedule [Man_Months != 0] { countMonths = (countMonths + r.Man_Months); } return countMonths; }This works perfectly
create link for downloading
I am uploading a file as an administrator, and trying to share this file with a non-administrator, ideally without necessitating a login. I have found the link, and instructions on how to create it (thought haven't actually successfully used deluge to generated this link). However, when I try to follow this link (by using 'inspect element' in Chrome) I receive an error message: You have logged in as AdministrativeAcct. You are not allowed to access this view. Please click here to login as a different
creating a Link to the website created in Zoho.
Hi, I have a website created in Zoho. I would like to create a link in another website to which it will redirect the user to the Zoho website - to login and access it. So how do do you embed the link? Regards Shavendra
Add data to a view using Custom Actions without having to select a record
Hi, I need to load data in a view using custom actions. So for that i don't have to select any record. Is there any workaround to achieve this??? Thanks
Zoho.currenttime 1 more day??
How to use zoho.currenttime 1 more day to a field in the form? Thank you! ------------------------------------------------------------------------------------------------------------------------------------------- Solved! Used as follows: data_fim = (zoho.currenttime + '0W:1D:0H:0M:0S') It worked perfectly. Thanks to all!
Service aplication
Hi all I need some help. Our company services printer and we need to create an application where our clients can log a serive call online. The application then needs to send a mail to our service department and to a technition to start the job. Every day the application should send a list of all the service calls that needs to be done on that day. We also need our technition to log on to a new application and states of the job is finished and what parts has been replaced. That application should
Access restriction by IP address or range (urgent!)
Hi I seem to remember having seen somewhere that access to Creator apps can be locked down to specified IP numbers. However I can't find this feature anywhere now, and can't find any reference to it in the documentation. Has this been disabled? Anyone got a reference URL or some advice for me??
Can ZOHO......?
Hi, I'm a regional manager for a Hotel management Company and I'm hoping for an online data solution for the following goals: 1) Each hotel can login to a central system and enter their hotel's information (weekly & monthly). 2) This data can be combined to provide a company performance sheet of all hotels. 3) Data can be selectively shared to owners (i.e. 2 hotels may only be shared with one person). 4) Data is stored in such a way that future modifications can be made to present old data in different
Upload and read CSV file line by line
I am looking for a way to upload a CSV file and read the contents line by line. I have the form named CSV_Importer and the field name is CSV_Upload So far I have ... for each row in CSV_Importer [CSV_Upload != ""] { echo row; } I'm familiar with PHP and can script in Python , but I'm not understanding the syntax because the above gives me errors in the script builder.
Restore fails. Does backup/restore function?
I'm at a stage of trying to import old data into a newly built app. Not wanting to kill it with dodgy old data I duplicated my project export/imported all existing lists and created a backup of it. Under Backup Apps I now see mandoe-tech-dev v1 2013-05-13 13:59:01.0 Download Restore Seems good! When I hit restore I'm presented with a dialogue in which I can change the name of the retored app if I want, I went with the default "mandoe-tech-dev_new". After the all to brief restore process I browse
UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
UI Tab redirect
Hello. First sorry for my bad english i'm russian :) . I use UI tab container for data but basic functional is not solved my problem . I want redirecting to another page by click in navigation panel. Not showing content in tab body. I trying this solution from stackoverflow : $("li.last a").unbind('click').click(function() { this.href = $.data(this, 'href.tabs'); but still not have wanted result. How i can do this ? Thanks for any help.
passing 2 or more parameters to an html view
So in the example: https://www.zoho.com/creator/help/views/create-html-views.html htmlpage "Expense Report By Date"(From, To) <%{%> ................... .................. }%>but what would the script for the button be??? openUrl("#View:ExpenseReport?from=" + input.From ???,"Same window");
Script doesn't save properly
I am trying to save the following code to one of my scripts for each schedule_row in input.SCHEDULE { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({schedule_row.SITE_ID}), schedule_row.ALL_SITES, input.AGREEMENT_ID, schedule_row.SCHEDULE_TYPE, "0", "0", "0"); } for each variation_row in input.VARIATION { thisapp.udf_ccc.get_ccc(input.CUSTOMER_ID, list({variation_row.SITE_ID}), variation_row.ALL_SITES, input.AGREEMENT_ID, variation_row.VARIATION_ID, "0", "0", "0"); } When I click Save Script, I
Add record by post url stopped working
I have been using a post to url with auth token for awhile . Today at 10:30 it stopped adding records to zoho. I have changed nothing please advise
Zoho Creator Regular Standard plan: how many email notifications?
Hello Zoho team, I want to select the correct plan for my customer, who needs email notifications that will be kicked off by Schedules. The Zoho Creator pricing page (https://www.zoho.com/creator/pricing.html) shows the different plans available. For example, Regular Standard has "5 Users; 10,000 Records; Storage - 1 GB; Unlimited Apps; 10 Reports; 50 Schedules; Backup". (Note: it does not mention email notifications) Underneath the plans it lists the Add Ons to those plans, such as "Email Notifications: 500
I cannot use order by clause in select ouery of my html view...... ????
there is always an error of xmlparsing.. i m getting data from reports and showing it through xml parsing but order by rand() clause used in the select query of my html view is not working all others are working....and that orderby rand() is also showing results in reports query table..... can anybody have an idea how to run it ...
modification of email on custom action
If we wish to modify the email before sending on custom action, as per the record in the view .. How is this possible?
App location? (Future proofing an app)
I have my first app currently being trialed by my company. As I created the app the URL for it is "https://creator.zoho.com/my_user_name/my-app-name" but what happens at the point when I decide to leave the company and they want to kill off my account? Am I better off having the app run from a generic account from the beginning i.e. "support_dept" and setting myself as the developer or can a backup be performed by me and then restored by another user at that time so the URL will change to be their
Script sort by code disappears
I want to show results sorted alphabetically. However, I am finding issues with the sort by code disappearing after I try to implement it. When I try to save the following code c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID sort by CUSTOMER_ID).getAll() in my form script, I see Script saved However, when I refresh the code, I see c = (CUSTOMERS[CUSTOMER_ID != input.CUSTOMER_ID].CUSTOMER_ID).getall(); Script generated I have tried both in the Script Editor and Free Flow Scripting. It
success message - Specify Duration(Optional)
Hi, Please explain the type of input expected when setting on a form its On Success success message. Is it units of seconds? Should it be written 8s? It is not explained in this page: http://www.zoho.com/creator/help/script/success-message.html Many thanks,
Warning prompt on custom action
How can i show warning message on custom action??? Help........
Temporary fields in Forms with store data in Creator
Hello! Very often I need to have some field in Form, which I use only for control of Form behaviour during displaying, and dont neet to store its value in database. It will be great if I can set parameter for each field "Don't store value in database" For example desision box which is used for displaying or hiding group of fields, or auxiliary lookup field, which help to control data in Form while editiong and so on
Invalid Entries detected when updating records from the Report view
I am receiving the Invalid Entries error when editing records in the report view of a couple of my forms. This will be a required feature of the application for actions such as administrator approval. It appears when I select Edit on a record and then Update it, even if I have not changed any of the data in the record. Usually this issue does not occur for the first update I make but then persists for no obvious reason.
Zoho Calendar view only for a certain time range?
I'd like the Calendar to only display for 9am to 9pm, is there a way to do this?
Chrome openurl new window is a popup not a new window
Firefox openurl command with new window opens a new tab Chrome openurl command with new window opens a popup which starts life as being blocked chrome ver 15.0.874.121 Any ideas ? anyone Thanks
Validate form and change value
I want to change field values when a form is validated. I have a CONTACTS form with a mobile and phone field. If either are empty, I want to populate a message with instructions. As I have multiple rules, I do not want to use alerts but instead populate the contact_msg field. I have the following code on validate if ((input.CONTACT_MOBILE == "") && (input.CONTACT_PHONE_OTHER == "")) { input.CONTACT_MSG = "Please enter either a mobile or other phone number"; cancel submit; } When I run
Send mail from one form to matching entries on another form
How would I go about sending an email to all people in Form B that match certain criteria in Form A. My application is being used to match up people looking for a job with employers in their area. Form A is where the job seeker submits their info (contact info, resume, etc.) Form B is where the employer lists their info (contact info, city/state/zip they are hiring in) For example: When a job seeker submits their info with a zip code of 91320, an email is sent to all employers requesting notifications
problems after recent platform change
I have troubles after a recent platform change, and some existing code no more works. 1. The most serious problem is that it is no more possible to concatenate a string with an integer, a thing which was allowed in Deluge . An example - a test function string test1() { nr = 2; return "The number is " + nr; } The code is saved without error, but an error appears when the function is executed. I have to change the return statement to return "The number is " + nr.tostring(); in order to make
WTF! [ServletException in:/jsp/edit/view/viewedit.jsp] null'
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
Next Page