Don't want website visitors to edit records
I have set permissions but have not checked edit record. but in my data view (list) I am still seeing bulk edit still available. View OK. Not edit record.
View Criteria error
Hi, I have a form with 2 views, each trying to set a certain criteria to display a set of data. one of the views works fine with the criteria, however, another view always return this error when i set the criteria, no matter in script or ide mode. here is the error msg that come up when i tried to save the script Error modifying the page The following column names are duplicated in this table [t_882922000000021615.Order_Loca_882922000000021617] the code i put are as follow [location == "Ipoh"]
Fetch records based on a form date field then update the collected records
Hi I have a form with a date field so i fetch a range of dates like this rangetocancel = Hospital_Rooms [(Date1 >= anycancel.Admission_Date && Date1 <= anycancel.Discharge_Date)]; seems to work as the collection holds 4 records and there are 4 dates from admission to discharge Then i want to update another field in the same form rangetocancel.room1 = "empty"; BUT it only seems to modify the first date Admission Date not the date range from Admission to Discharge any ideas ?
How to count records that meet criteria and show in HTML View?
I have an HTML view that acts as a home page for an app. On it, I want to show some usage metrics for the app: - # Available Items - # Expired Items - # Items Added in last 30 days from today Example: "43 Available Items 16 Expired Items 10 Added in Last 30 Days" How can I count these records On Load and display them in the HTML View? Will this slow the view down as more records are added to the app?
Email Notification question
Hi, I have a couple of question regarding the email notification 1. Is it not possible to include formdata in the message for the email notification during On-delete - On success event? 2. I wanted to custom display the login name for the from address, here is what i put but it seem not successful "zoho.loginuser<" + zoho.loginuserid + ">" is it possible to put the display name associate with the user name of the login user id? 3. How do we display some of the input field in the subject header
3 user defined filters, and an automatic filter used to populate multiple fields.
I already have a support ticket on this particular issue, but I thought some other developers may find the information useful if a solution is found. I wish to have multiple fields in my Pulser_Report form. 1. I will need nine pairs of numeric fields that will be named “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours”, “Run_2_Total_Hours_Below_Rotary” and “Run_2_Total_Circulating_Hours”…….. 2. Every pair of fields will be hidden on form load. 3. The operator will
Summation of column in a form field, (NOT IN A VIEW)
Hello all, I am trying to auto populate the field Total_Hours_Below_Rotary in my Pulser_Reports form from the Service_Hours_Below_Rotary in the form Lifetime_Hours. The below code is returning the first value entered in the Service_Hours_Below_Rotary column. What I need to display is the SUM of all entries in the , not just the first entry Service_Hours_Below_Rotary column that match Job_Number, Description,and Serial_Number. for each value in Lifetime_Hours [((Job_Number == input.Job_Number &&
Urgent! need your help that want to make a band diagram of navigation bar in ZC from
Hi Ruben/Akash/Latha I want to make a band diagram of navigation bar in ZC form. I would like to embed an image form in the html page, when I click a picture, the picture links to a FORM or VIEW embedded a iframe in the same html page. I know that if not the picture form can be done, I tried the following methods: In the note field to insert pictures, will add a link to this picture, but did not find the link to open the target in no iframe. Already get a very long time can not be achieved,
Unable to get functional URL to work
I have a application with a View and which to use a functional url to access the view and set the criteria. This seems very streight forward enough accordsing to the documentation, but although my view does display it completly ignores my criteria setting and defaults to displaying all the records. Here is a sample of the url I am construction to limited views to client A https://creator.zoho.com/appowner/appname/#View:View_Name?Client=Client A This format will display the view, however it displays
Picklist from same form?
Hello, I have a contact form where each contact has a recruiter, and each contact can be a recruiter. I want to have a field 'Recruiter' in the contact form, which tracks the recruiter of each contact. I would like the recruiter field to be a pick list of all the contacts. Thus the picklist 'Recruiter' on form 'Contact' refers to the 'Name' field also on form 'Contact' Is this possible? If not, can you see a workaround? Thanks, Kenny
What script should I use to open a view with the same criteria?
I have a view with a custom function. the function opens an edit window on click and when the edit is committed it returns the user to the view with the edits implemented. The script that returns the user to the main view is: openUrl("#View:Tasks", "same window"); However, when a user selects a filter to narrow their view and then uses the custom function, the user is returned to the view WITHOUT the previously selected filter. Is there a way to change this script to include the previously selected
database multiple vendors
I want my vendors to input their products in their individual online catalogs. Do each and everyone of them have to be a paid for user? Craig
Insert into record lookup with no value selected causes on success error
Hi Basically i am copying a record and inserting it with a few new fields Problem... any lookup fields from the original record which have no value -select- are causing an on success error If i select a value the selected value gets inserted any suggestions ? Thanks
Referencing Subform Data From Another Form
I have a form called Stores_info. Stores contains a field called Store_ID that is unique for each store. The Stores form contains a subform called Zip_Codes_Served, and the subform consists of one field called Served_Zip_Code. For example, Store_ID #1 serves zip codes 10001, 10002, and 10003. Thus three rows in the Zip_Codes_Served subform for Store_ID #1, with the one of the rows containing Served_Zip_Code = 10001, another containing Served_Zip_Code = 10002, and the third containing Served_Zip_Code
Need help getting PayPal to work please on form
I have shared my app sportspenguin with support. I have a PayPal business account. It is an app that basically acts as a classified ad list for people to sell things. An anonymous person can list an item to either be given away or to sell for a price. They list their item on the 'Item' form. If they list an item for free, there's no cost and no need for Paypal. Here the field 'Asking_Price' in the Item form = 0. The item will be listed for x Months where the user specifies the number of months.
noob questions about form schedules ::your help is needed
hello all I am trying to create a form schedule that will send an email to a list of people however there is a twist. I was wondering how i could get the form schedule "when to do" tab to get the date and time from one form AND get the "what to do" tab to get the list of people i want to send the email to from a different form. I hope that I communicated my issue clearly. thanks in advance....because i am stumped. evio
Sorting has no effect on the order
Hi, i'm trying to process data in small batches and i have a hidden field called "RecalcPending" that by default contains the value TRUE. After the script processes one line it sets the value to FALSE. And setting the sort condition to Asc or Desc has no effect and the 130 or so lines of data never get processed by this script. I can see them in the view but so they have to be stored somewhere and the sort condition is not doing what it should do. Here is the for each line where the sorting is with
Common field between a form and a subform
I am working on a job order application. It has a subform with staff assignment to that particular job. If I go into the staff view, it shows no association to the parent form. I want to be able to go into the staff view and see a column of the job order number the particular subform was entered under. How can I accomplish that? I hope I am explaining it right :)
Dropdown Field Is not Working in IE7 in embedded forms
Dear all, The drop down fields are not working when we access an embedded form using IE7. How can I fix it? I've just registered this issue, my ticket Support ID is 658219. Thanks in advance, Danilo Medeiros
Adding fields
Hello, I have a form called 'drawings' and I want to have some fields where users add notes about the drawings. These notes are 'operations' The problem I have is each drawing will have different operations, some only 2 operations, others maybe 12. Each operations will have a run time too, so 10mins for operation 1 and maybe 30 mins for operations 2 (for example) What is the best why to deal with this? I hope I have explained it well enough, I am new to zoho but so far it's bloody amazing so far.
Updating Field with another Field's Data in the same form on Input or Update
Looking for help with the following: I have three fields in my form: Bid Price Final Price Result I need the form to automatically update the Final price with the Bid Price when the Result = "Successful". Anyone have a script or can point me in the right direction? I'm confused as to whether I need to attach the script to the Result field to update the Final Price or if the script needs to be attached to one of the other fields and what the script would look like. Please help.
Uploading file into creator as view it in report
Hi, I want to upload some data into the creator form. Like other fields i use creatingMap.put to map the creator into reports. What i want to know are: 1. If i want to upload a file from my local computer what should i write in Action on success (in Free flow scripting). 2. How could i download the data from zoho reports?
Custom Dashboard
Can I create custom dashboards with graphics and charts etc using creator? something like http://www.projectmanager.com/ ??? Thanks
Non-professional programmers, to write as a professional management program, because of the ZOHO Creator
各位爱好者、关注的朋友 本人，老郭，非程序员出身，搞业务，做买卖的。随时都想着如何把生活中、业务中的现象和逻辑模拟到计算机里，把他们管起来，同时让这些程序为我服务、工作，只憾没有合适的能游刃有余掌握的工具，只停留在那些望而生畏的代码基础面前，现在找到了，它就是创造者，太适合非编程人员的掌握和发挥，因为他们具备了多年的业务逻辑和经验，只是用创造者这个易用强大的编程工具去实现管理的优化、去迈向管理的起步。 在使用创造者的过程中有以下体会分享给大家.. 1，创造者是业务逻辑和编写程序的桥梁 往往写程序的不甚太了解业务，懂业务的不懂写程序，因此程序通常由专业的程序员去写，而企业的业务逻辑在经济活动中又不断的发生着变化，导致程序的更新与业务管理需求难以同步，使得企业原有的管理程序很难满足企业不断变化的需要。另一方面由于传统的软件开发需要具备非常多的专业基础，致使业务管理人员很难难介入。但当创造者出现了，这个问题逐步得到了解决，搞业务的可用这个工具去根据自己的业务需要轻易的、快速的去定制企业所需要的管理，无论业务逻辑如何的调整变化，业务人员可用这个工具随时调整满足业务的管理需要。 深刻体会:每个企业有很多的个性化的需求，没有一个标准的的软件能覆盖每个企业的所有个性需求(即便是行业标准软件)，但如果使用创造者工具可最大化的解决企业定制化需求问题，使企业的管理正真有一双完全适合自己穿的管理鞋。而且，这双鞋是动态的尺码都没有问题。让我深刻认识到，企业管理程序定制化程度越高，其生产效率是相当惊人的。
How to clear a text field in an on edit on load script?
The clear command doesnt seem to be used for common text fields. I need to clear a text field on edit on load with a script. How can I do this? I cant just add a " " (blank space) because it needs to be completed and compared to another field for accuracy. Please advise. Thanks.
Need days since record added calculation- help
In my app, I need to change the status of a record from Available to Unavailable after 30 days pass from the date when the record was created. How do I do this? I was trying to use this formula, but I cant seem to figure out how to get the date added from the system: ((zoho.currentdate - DATE ADDED FROM SYSTEM) / (1000 * 60 * 60 * 24)) Help?
PDF URL request ignored?
Every-time I put in the same script two PDF URL to be open one after the other, the first request is ignored. This is new didn't happen some months ago. For example, I need to save in -my downloads- a PDF containing some records with my contact info. And with the same click save also in -my downloads- a PDF containing exactly the same records but with extra non public fields. Every time I press this button, I only get the second document, while the request for the fist one is ignored. I need the
Public App Login Screen
Hi guys, I have a question that I know has been asked in one way or another before in this forum. However, I have not found answer that satisfies my needs so I thought I would ask the question again. When I develop a Web app for one of my clients using the Java platform, one of the first things I do is to make sure that only authorize users can access this app. So, A simple algorithm of how this would work would be as follows: 1. User accesses login screen and enters credentials 2. The user
HTML view as popup
Hello all, I'd like to popup an html view I've created upon the user making a selection from a radio button. I have used the OpenURL function on the "On User Input" event for that radio button. The popup displays fine but the html view doesn't display properly. Static text is displayed properly but the embedded view below the text doesn't show and instead says "Loading" indefinately. The html view is a simple combination of basic text and an embedded view in list mode. Any ideas why this is happening?
Need help with permissions for public app- confused...
I have a public app: http://creator.zoho.com/redatomnetworks/sportspenguin . The app will allow someone to list a good to be donated so others can get it. e.g. donate a chair for free and others can see the chair listed and contact the person to get it. I want to open it up for anyone to use without logging into Zoho. They need to be able to submit and edit their own forms. I dont want them to be able to delete forms at all once submitted. I also want to hide or prevent access to the Admin views
Two or More forms Insert to one Table
Is it possible to create multiple forms then insert the records on one table (or form table)?
scripting reference to bi-directional field
Hi, I've consistently had the problem I'm about to lay out in my application and thought it was a limitation of Zoho. However, I don't see it listed anywhere else as a complaint so maybe it's just our application and someone can fix it? The problem stems from bi-directional fields and trying to reference those in scripts. For a specific example, we have a Monthly Meeting form. We use this form to do multiple things, including track attendance at our monthly meeting. The Attendance field is an import
Viewing a Zoho Doc uploaded to a creator form
I attached a Zoho Doc to a creator form using the file upload field. In the view when I click on the link it asks if I want to download the file. I was expecting it to open Zoho Writer and show the document. Is there a setting to get it to open in Writer? Thanks Herb Wexler
Calculating Last Month
I have a view with a date field called Date1. I'm trying to set criteria to show only records where Date1 is last month. . If today's date is any day in October then the view will show all records with a date from September 1st to September 30. Herb Wexler
Effective input view
How can i tell a view that only un-touched form fields should be shown in that view? thanks
Filtering my drawing numbers
Hello, At the moment I have 3 forms: Drawing Customers Works order When you add a drawing number, I use a "look up" to select the customer name from the Customers form. So the creator knows that a specific drawing number is tied to a customer. In the Works order form, the user will select a customer from a drop down box, they then need to select a drawing number but at the moment it shows all the drawing numbers available. Is it possible to filter the drawing numbers that are associated with the
Go to URL & Permalink
Hi there, hope someone can help. I have a form which goes to a Thank You page (another form) when submitted. But, when I access the form via a permalink it won't go to the Thank You page. Anyone know why? Here's an example permalink: https://creator.zoho.com/activeimpact/of-course-we-can/form-perma/Event_Finance/dwWCpEGNk6HCHHugXrfnuDJk8EZbMq5PvPFewTUPgPu89VgDCz23rM62krhOUJnk09CPRgKFMBTU91GnjMmfThessn64VHe8VBZy/
Zoho Challenge API Integration
Would it be possible to get the results of a test completed in Zoho Challenge and use the result in Zoho Creator to verify a passing score? I have built a training application and certain courses would require passing a quiz before they can be marked as completed. Can anyone suggest a solution? The goal would be to get the quiz results via Zoho API and emailid (zoho.loginuserid) of user. Then when the user clicks the custom action to complete the course, it will verify that the quiz has been passed.
Please help me implement Global Filter
Hi there I want to filter all views according to a value in a field called Client in a table called GlobalFilter. So, I want each view to show only values where Client == GlobalFilter.Client I'm guessing this won't work because the LHS of that formula is a string and the RHS is an array. Please advise how to achieve this. For the record, I am preventing the user from entering duplicate Clients into the GlobalFilter table. Justin
Dropdowns not working?
When I try to use the dropdowns on my form, accessing it from an outside computer and not logged into the site, as any third-party user would do, they scroll in the window, rather than dropping down. Is there a glitch or some change in the way these are working. Since my mouse scrolls three lines at a time, I can't even see all of the options.
Next Page