Preserve Multi-column Layout for Dynamically Created Radio Buttons
This may have already been mentioned, but I just noticed that setting a 3-column layout is ignored when the radio buttons are dynamically added upon form loading. Thanks, John Whitney
Google Apps UrlFetchApp.fetch to zoho creator session does not close
Hi , Am calling the Zoho Creator get ticket API call using UrlFetchApp.fetch After the call the session remains active on my Zoho Account and as is the case if too many sessions remain open to Zoho the API will stop responding. Anyone know of this issue or knows of a way around it. thanks
Special View Criteria
Sharing a view with a user gives that use full rights to see all the data. What if we only want him to see a sub-set of data? I'm guessing view criteria is not sophisticated enough to handle this. The only way I can figure out how to enable this would be to have a new column in the data with the user's zoho ligin ID and set-up criteria to filter on that. Comments? Cheers, John Whitney
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
On this page: https://creator.zoho.com/webmagnets/view/17/edit/ I am getting this error: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
Help needed- need to total hours worked per person in understandable format
Help needed- need to total hours worked per person in understandable format Anyone know how to do this? I have a formula box that totals the time, but it comes out in seconds, and it would be great to somehow look up each person and get a total in readable hour/minute format. Any ideas? formula zoho end time date-zoho end time date = total time person worked (I have this already) BUT WHAT I really need is a sum of all of the hours that person has put into a work month... Any ideas please help,
In-place editing of a lookup field for multiple records
I have an application for organizing people into focus groups. When a Study is created, the user names 1-n possible focus groups (e.g., "group 1" "group 2"). People are recruited to a study and must be assigned to focus groups. To assign a Person to a focus group, the user needs to look at a variety of background information on each person. Thus, I'd like the interface to look like: (for a given Study) Person 1's name Gender Experience etc... <lookup drop down with possible focus
many mails in input.Mail
Hi, i made a variable Mail, can i put more than one mail in input.Mail? if so, what is the separation, ";" or "," or any aother?thanks
Create a search function that will pull existing records
Situation: I am allowing users to enter membership data. But, if a membership record already exists, I would like for them to search for it and then be redirected to an 'edit' page where they can edit that existing record. I'm not sure how to do this. What I tried: I made a 'search' box where 'on user input' it searches for any record with the information entered and populates the form with the record information. BUT it will save a duplicate copy if you submit it...that's my dilemma. Any help
Does delete or backspacing a Date field to blank create the null value?
The on Input script below is designed to set the penalty field value to 30 if the day of the month is after the 15th, and to 0 if the date is not after the 15th OR if the date is blank (I'm assuming a blank date is null). The problem I am having is that when I delete or highlight and backspace the date to a blank (and then click outside the field to trigger the script) the penalty field is not reverting to 0. Can anyone hazard a guess as to what is wrong with my script? Thanks to Gaev for sending
Simple 'many to many' search example
Hi, I am trying to find a simple example of a many to may searchable database built with creator. For my needs, there are a number of 'instructors'. The only details I need are the full name and the postcodes they serve. Each instructor teaches in a number of 'postcodes'. Each postcode can be served by a number of instructors. The list of current instructors is a lookup from another form so as to always be current. In the end all I want the user to see is a search box. They would input the postcode
View to show latest record for each group of data
Hi, New to creator and just starting on my 1st project. Have some self taught experience of access and SQL but this is a long time ago. Am working on an asset tracker for use by us as an OEM and our customer as they use and distribute our machines. Mostly I need to track current location and current condition. I have a base form for my machine data such as serial number and then some other forms for input of location change and condition change. As the machines are used they will move around to lots
HTML view print problem
Hi, I have a html record view which get parameters from a form, when i wan to print the html record view, i get the following error Not Found The requested URL /bilgain/hr/print/Payslip/&Name=test&Date_field=01/12/11 was not found on this server. this is the print link https://creatorexport.zoho.com/bilgain/hr/print/Payslip/&Name%3Dtest&Date_field%3D01%2F12%2F11
Audit or History of Changes
Is this correct? 1. If I use a combination of getfieldname and getfieldvalues: a. Used in the ON LOAD or VALIDATE - it is null b. Used in the ON SUCCESS - it returns the new value 2. The old. property only works in the VALIDATE Is there any way to marry these two, so I can build a routine that will store the original value of any field that is changed?
Copying text from 1 sub-form to another
Hello, Is it possible to copy text from 1 sub-form to another. For example: I have a 4 forms In the Drawings form I have a sub-form called Materials and the user adds as many material sizes as need. Then in another form called Works_order the user selects the drawing number via a look-up linked to the Drawings form - then from that, can Zoho find all the materials in the Materials form and add them to another sub-form in the Works_order form? I'm basically asking how to come all the "rows" from one
Not sure why this code fails validation.
Background: I wanted to have Zoho assign custom IDs for certain forms so I followed the advice online and created a counter system wherein an Auto_Number form keeps track of the highest IDs and simply adds one to the appropriate counter when a new record is created. I would like to have the ID reset based on the year so that the last ID in 2012 might be 20125689 and on Jan 1 2013 it would automatically become 20130000. I'm trying to achieve this via the scheduler which I have never used before.
How do I delete unwanted column formula?
I have created some unwanted /incorrect column formulas which seem to attach themselves to all Reports associated with the same view. I really don't want them listed but am unable to see how I can delete them, otherwise it looks like they will stay defined forever! Chris
HTML Views Not Showing on iPhone
We created a Creator app with an HTML view. However, the HTML is not appearing on the iPhone or Form/View list even though it shows up on the Desktop computer. Can you tell us how to fix this? Thanks!
how do i make additional fields appear based on a users previos input in a checkbox
I have a checkbox field with various diagnosis. The can check more than one. What I want to do: If the user checks the NPH diagnosis checkbox, then a whole new set of fields should appear for him to fill out. If he doesn´t check that particular checkbox then the additional field wont appear.
Print Single Record
I have read that you have a 'print single record' function in beta which you can add on request. Please could you add to my Train2Drive application (edit access is open....somewhat hopefully!). Thank you
Web page hanging on user Zoho log-in
On a page on my web site I have six embedded reports. When a user comes to the page and logs in, they are presented with a 'Loading... Please Wait' message in each iframe. The page then hangs. Refreshing the page using F5 immediately brings up the content. This feels like a bug? Chris
create a Function Specify Arguments group object drop down list is one selection off !!
Weird issue, maybe me, am using FF latest Create a function Use builder give it a name Specify Arguments: (put something in) In my case i am selecting a group object What ever form i select in the drop down the next one on the list is the one which is written to the function. Its like the drop down is One Value off Thoughts ?
Integrate Zoho Creator with Zoho Calendar?
Zoho Calendar currently has nice functionality that does not seem to be available within Zoho Creator yet. I'm specifically interested in the ability to display multiple calendars as different colors on a single calendar view. Also the ability to easily toggle which calendars are displayed. Is the multiple color coded calendar capability going to be added to Zoho Creator? How can I integrate the two apps so records created and maintained within a Zoho Creator app can automatically be displayed
Add Event to ZOHO Calendar
I tested the zoho.calendar.createEvent task (ref) and have some observations and questions. Documentation: Instruct users to create a calendar name in Z Cal or use an existing one. Also, it would be helpful to provide examples of converting Z Creator date-time into Z Cal accepted format. There should be a way to pull a list of calendar names to populate a drop-down field. Rich-text in descriptions not working: I assume there will also be ways to edit or delete events? Cheers, John Whitney
openurl with reports and passing criteria.
Is is possible to use the openurl to pass a parameter to a report. For example I want a user to see a report that only contains records entered with the same userid. This is easy to do with views but does it work with report-perma? Herb Wexler
Suggestions for can be generated viiew by Deluge
Re Suggestions for generate viiew by Deluge 1, the view through the deluge to define which fields to show or hide; 2, if the define the view of read, write, edit, delete, etc. the better; 3, in deluge through the calculation to generate a new calculated field; Through the deluge to generate viiew can be saved to create many different types ofview, just do an all field of view and then hide it, based on all fields of view can begenerated through the deluge to the various types of view, so that very flexible
How to create fields to enter weekly sold unit for an item
Hi, Our company has about 50 Sku, and we want to keep track of the unit sold for each sku on weekly basis. I want to create an area where it has number fields for me to enter weekly units sold each year, what is the best way to do this? I want to be able to use those information to also create reports comparing the same week from past years.
Problems with Subforms
Until now I have not had a need to investigate subforms. But a need arose to create a time-input manager at work and since many people work on multiple projects, a subform seemed to be the base scenario. But subforms are really buggy! First off, it took a while to find how to update a running total of hours as people used the subform to enter projects. Yoge has a demo in the marketplace showing this. To calculate a running total, you treat the subform as a collection (for each row in SUB_FORM)
Preview function popup not working in IE
Hi, I am having an issue where the popup window from my custom action preview function is not appearing correctly in Internet Explorer. I have version 9 and others have reported it in versions before 9. The address is https://creator.zoho.com/slaafws/registration/#View:SLAA_Intergroup_Listings on click of the blue "More Information" buttons. One time you click the button the window might appear, then the next, it doesn't appear, and shows only a transparent gray band at the very top of the page.
Issue with a null lookup field that is of type Number
In a Normal form (Year Records), I have a lookup field whose type on the parent form (Year) is "Number". In another stateless form's onLoad event, I am testing the value of the Year field on the Year Records form and it seems there is no way to determine whether the value is null or not null as both the statements below return false: Year_Records[Name == "Two"].Year == null Year_Records[Name == "Two"].Year != null I am referring to this sheet - https://sheet.zoho.com/publishrange.do?id=0d9c0b681f5501ffcf6f935a335ab5e6 but
Import to Subform
I have a forrm with subform. I managed to prepare import that creates new record (in main form) and also creates 2 records in subform. it works just fine. Here is my problem, I need to import subform records to already existing main records ( none of them currently have any records in subform). It does not work. The way I tryed it: I used "ID" field of the main record, this record is updated, however it does not create records in subform
Sorting Lists or Maps
I've been pulling my hair out trying to solve this one! A client's database in ZC contains contractors, projects, and project costs. Many of these contractors have multiple projects. My client wants to generate a "report" showing three columns: contractors, total number of projects for the contractor, and total cost for those projects.The report should be sorted by total number of projects. In addition, this report is a filtered view based on other criteria. I approached this problem by generating
May 2012 Calendar Update: How to lock past events.
How would one lock past events now? In the old system one could simple disable the date field in Edit mode. In the new system the Drag & Drop feature only calls the date field On Update script, so what On Update script would one use to cancel such an attempt to change a past event using the Drag & Drop feature? UPDATE: To prevent the Drag & Drop from changing dates I put a script at On Update for the Date field which basically changes it back right away to what it was and then refreshes the page...BUT
new update broke radiobuttons layout
It seems that the new update in Zoho Creator, with multiple columns layout for ckeckboxes and radiobuttons, just broke something important. Just an example. I have in a form some radiobuttons: Nothing special here. I add the following code at on form load, in order to make "Andet" the last record. The fields is named. Copy code instType = Institutionstype [Institutionstype != "Andet"] sort by Institutionstype ; InstTypeField = instType.Institutionstype.getall(); InstTypeField.add("Andet"); Institutionstype:ui.add(InstTypeField);
Creator form not working properly this morning
Since this morning, our company daily report form is not working correctly. The radio field "Crew Leader" is displaying horizontally where they used to be vertical, and the Actions on User Input on "Crew Leader" field are not working. Not sure what would be causing this. Here is the link to the form: copy-of-krystal-klean-co-payroll-manager1/#Form:daily_report
Something goes wrong in Zoho Creator
Since Morning I have been unable to put New entry .. Below is the error An error occurred while on Success script. Unable to update variable An error occurred. https://creator.zoho.com/piju2111/penta-crm-11#Form:To_Do_Form Note: edit access has been given to Support.
Adding a Record
How come when a record is added to another table neither the validation nor the success scripts of the receiving table are observed by Zoho Creator ?
How to auto-generate URLs for each record in a list?
Hello, I'm using an HTML view to generate a bullet list of upcoming events. Here's what I have so far: <%displayevents = (Event[Date_is_final_confirmed].Event_Title sort by Event_Date).getall();%> <p><%if (!displayevents.isEmpty()) { for each index var_index in displayevents {%> <li style="padding-left:30px;"> <%=(displayevents.get(var_index)).getPrefix(",")%> <%} }%> So right now it displays all events whose dates are final,
Need help for execute a url in Deluge
Hi Sankar I have a url it's can insert a record to SQL Server like bellow: http://cs.868982.com/getdata?sql=INSERT INTO cl_hpkc (field1,field2,field3) Values(value1,value2,value3)&root=root put the url in address of browser it's can be executed ,but I want to execute the url in Deluge I try used openURL() but failed,so hope you can help me. Thanks Stanley
Scheduler attachment limits
I can use the following code on the criteria section of a view but if instead I include the code in the crieria section of an attachment it will not save. What I want in the attachment is only records added in the last week. (Added_Time >= (zoho.currentdate - '1W:0D:0H:0M:0S') && Added_Time < zoho.currentdate) Herb Wexler
How to get openURL in Function called in Custom Action to "wait" until all selected records have updated
My goal is to set the invoice number of selected billing records in a view and then open an Invoice form that loads its field values based upon the values of that selected group of billing records. In the code below the Function SetPayCode sets the InvoiceNumber field for each billing record selected from the Session Form which has a current InvoiceNumber value of "0 (Not Yet Billed)... to the value of the field named Code that exists in a InvoiceNumberList Form record with the field named FilterAid
Next Page