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'
Script to create a new record with a subform, and populate data
Consider this example So what would be the code to create a new record? insert into Class [ date_field = zoho.currenttime (?) insert into Student [ name = "Billy Bob" ] insert into Student [ name = "Jane" Doe" ] ];
restrict characters in single line field?
Is there a way to prevent users from using, for example, spaces in a single line field? If not, is there a way to replace spaces with, for example, underscores during the submission process? Thanks.
Looking for a Developer or Programer
Hi I have running a Mobile phone Retail and service Bussiness. and i need a programer to design or create a online SaaS program for my bussiness. first this software has to log at least 10 users in same time and it has to install on our domain ( windows server dedicated and SSL certificate) it should have following modules. Sales-Sales return. Multi Currency accept- Split payment Purchase - we do direct purchase only. so we need to enter directly purchase invoice. items has to enter by category
remove 'home' link on non-admin acct
Can I remove the 'home' link at the upper right of a form for a non-admin account? Thanks.
Need help
Hi Ayisha How write the RegExp code in the matches () function to determine whether A string in the capital to capitalize A to Z？ like this ？ if(input.string.matches("(?([A-Z])")) == true) but try many time is failure... Thanks Stanley Guo
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator ?
How to attach pdf document of record in Email templete to send these attachment on a custom action in zoho creator
Doy you plan to make function calling in filter criteria of Views
Hello! It will be great to have this functionallity to have ability to use functions in filters criteria of Views (in Advanced Mode) For example, now, I have such a task: Our company have many business Partners (Form). Each business partner have several zoho accounts (each account represent some role in our application). Some Forms contain lookup field (linked to Partner Form). I need to have ability to filter Views, when Partner logged in this way: View: criteria field: where partner==thisapp.to_which_partner_belongs_logged_user(zoho.loginuserid)
Make each user only be able to view records that apply to them.
I have a form that customers fill out and Users/Sales Reps will have access to the records. What I want to accomplish is for each User to only be able to view the records that apply to them. I have chosen a User ID field to be the identifier/filter for this, but I'm not sure if this is the best way to do it. Also, I'm not sure how to set it up on the backend. Would there be custom DS involved in this? Any help on this would be much appreciated. Thank you, Mike
I can't edit my application
Hi, The app I'm trying to edit is https://creator.zoho.com/zohocreator/cobe123/zc-tutorials-15-0. It was working fine yesterday and all of a sudden, I can't edit it anymore. It gives me a blank page. Someone please help. Thanks
link does not load and application is restarted
Hi all! I am trying to develop an application for data collection for a master thesis. I have a form where people have to encode some words according to a rule in a certain amount of time. After they submit their answer they press Finish and should get to a form that would show them their score. I built an HTML view that loads 2 Zoho forms, one with the encoding algorithm and one with the exercises. Since I couldn't built a timer in Zoho, I had one built and stored at a certain web address. All Zoho
Please help me solve this GENERATEJS_TASK task error
I am trying to fetch a record and update a stateless form with the results. I have been getting a cascade of errors; Error in executing On Add-On Load script; Error; Error in executing IF rule: Error in executing If block; Error in executing For Each Record task; and finally Error in executing GENERATEJS_TASK task. The section of the script that is causing the error looks like this; if (input.Email1 != null) { for each myPhys in X_Physical_Profile [Email1 == "xyz@gmail.com"] //hardcoded the
Tooltips on buttons in new editor not saving with FF or Chrome
Here's a video demonstrating the problem in Firefox 20.0.1. The same problem exists with Chrome 26.0.1410.64 m Thanks, Jeff
Please help a newbie
Hi, I'm trying to create an extremely simple registration form to embed within my moonfruit created website. I need to capture basic name email which is fine, but I also need to get people to select from a pre populated list of schools. As there are over 16,000 in the UK I need people to be able to to first click on their county. This will then bring up only schools which are within that county. Can someone tell me how to do this?
Next Page