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
Invite users email
Just now starting to get into the 'Invite users' cycle. I'm finding it really annoying that that the Invite email on the Invite/Sharing page is not stored. Surely this makes sense as I do not want to cut and paste the email each time I invite a new user? Am I missing something. Chris
Daily Calendar View
Zoho has a Monthly Calendar View format. Does it (or will it) have a Daily Calendar View format?
Can openUrl in a Function open a Stateless form?
If yes, what is wrong with this function code? (The code sets the Invoice Number (as string) field for records whose current string is "0 (un-paid)". After that I want the Form named Add_Invoice to open as a popup. It is not opening. Please help me figure out why not. Thank you. void SetPayCode() { NewInvNum = InvoiceNumberList [FilterAid == "Next"]; rec = Session [InvoiceNumber == "0 (un-paid)"]; rec.InvoiceNumber = NewInvNum.Code; openUrl("#Form:Add_Invoice", "Popup window",
Can variables be declared in a conditional formula?
For example, how would I get something like this to work? InvoiceNumbers = (Payment[ID > 0].InvoiceNum).getall(); if( InvoiceNumbers .contains(ThisFormInvoiceNumber) == true, ThisFormInvoiceNumber , ThisFormInvoiceNumber + "<font color=#FF0000>An Invoice Needs to be Made for This Group of Records</font>")
Edit ''Added_User' fields
My Zoho database has been public to date but I'm adding a private view of data that was entered via public pages. The Added_User fields that I use to restrict users to seeing only their own data, is therefore set to 'Public'. I'd like to edit this field so that it shows the user e.g.firstlast, otherwise users will not be able to view or edit data they have already entered via the public page. Although I can see the Added_User field in the view, I am unable to edit it in the record view. As Administrator
Failed to retrieve stored file
I am failing to retrieve the files stored at Zoho Creator. The effect is intermittent: sometimes I can retrieve them, while other times I can't. If you wanted to replicate my results, please look in my apps, whose access has been grated to Zoho Support. Thanks!
Need help for Character conversion
Hi When through the deluge to the SQL server insert into the Chinese data(English is ok), add data garbled, so how to convert the utf-8 to GB2312 or GBO ? Thanks Stanley
Single Record Duplication
I would like to duplicate a single record from a view. I do not want to enable the ability to create multiple duplicates, as setting the permission to duplicate would allow. I imagine this would take the form of a custom action button (on each row), that would simply duplicate that record and open that in edit mode so that I can run some validating script before submission. Anybody have any thoughts? So far I'm terrible at understanding how to write custom functions.
current month record restriction
how can i restrict adding a record with a date field only if the date field is within the current month? please let me know.
Script stopped working
Hello, A script has stopped working on one of my forms, all I get is the arrows going round and round. I haven't changed the script but its now, not working. What can I do? Many thanks Ben
Can in-row Custom Functions pre-load Stateless Forms with data specific to the record in that row?
Can in-row Custom Functions pre-load Stateless Forms with data specific to the record in that row? If the answer is yes, please send some script my way. Thanks.
Re Sort in Drop-down box of Deluge Builder
Hi Form a lot of no sort is difficult to find so suggested bellow Drop-down box can be sorted in Deluge. Thanks Stanley
Edit record in full window
Is there a way to force the edit view into a full window like a new record? Navigation for large records gets a little tricky, particularly when record contains large subforms.
Suggestion
Hi In the execution of a Deluge function can have a similar to the alert box is even more convenient,OR release info function for all users. Thanks Stanley
cannot retrieve data by internal ID in view
I have a lookup field by ID with display "Name" on the form then I have view with This lookup filed ( it displays name) from that form. I do not want to display internal ID on the view!! I need to opne this view from another screen and display all the records with specific internal ID. The only way I know of is to use openUrl function however, it does not work by ID field. only if I search by Name it works: openUrl("https://creator.zoho.com/ito_mu/ep-tracker/view-perma/All_EP_Registrations/EP_Name="
Need developer to integrate shopify and email feeds with zoho creator.
Hi, I'm looking for a developer to help me with some (to me, rather complex) API issues. I would like to make my shopify.com site automatically feed all orders to my zoho cretor app and also be able to update records automatically via emails from transferbigfiles.com... I don't even know if this is possible... If you are interested in the gig, or have further questions, please contact me by email: silver@atomicdisc.com. Hoping to get some help soon! -silver www.atomicdisc.com
Export Data PDF
I know the known limitation of zoho to export grouping, number formats etc to pdf. Is there any alternative to print views in a nice format (ie repeating column headers, page numbers) without exporting to another program?
List View store additional hidden information in a unique column and row
Hi, Maybe more of a html question looking for ideas I have a view which represents rooms (booked, free etc) Each column is a separate unique room and the rows are dates, for each room i use HTML in the list view to show <strong><span style="color: rgb(51, 153, 102);">Rm01</span> GREEN BOLD <strong><span style="color: rgb(255, 0, 0);">Rm02</span> RED BOLD Along with this i now need to store the Zoho ID of who made a booking for that room i have no more fields left on the form (hit the limit) So i
On Load value for URL field?
I think I've figured out how to populate Link Name in the URL field using On Load as follows: input.project_docs = "<a href=''>Project Docs</a>"; However, is it possible to disable *only* the Link Name field On Load, so that the user can put whatever URL they want in but the Link Name will always be "Project Docs"? Thanks!
Sign in and Sign out
hello im new here, would like to ask a question i have a website wanted to create my sign in & sign out for visitor or members what is the code?
Zoho Creator
I know I've asked before, but I'm really perplexed and swamped. Maybe I'm too dumb to figure this out? Sheesh. I need to do date calculations in Zoho Creator. Can someone help with this? Here are the various calculations I need to do. I'm a volunteer book review editor, and need to keep track of books I've assigned to reviewers. I need to log in the date a book is received by a reviewer, add 30 days to it, and generate a date the review is received. I also need to take today's date and subtract
Sharing an App that uses the Shared user's form.
BACKGROUND: I'm considering upgrading to professional express in order to market an app. The scheme is to sell the right to have the app shared by the buyer for a specific length of time. The problem is that if I have 1000 users who generate 1000 records I will quickly have a 1,000,000 record count and at $5/mon/1000 records a $5000/mon ongoing Zoho record charge which would make the scheme un-profitable. One solution I have imagined is to share my app, but then have the user/client install a second
Linking to a document (pdf)
Hello, How could I create a link to a PDF file on my HTML view? My app lets the user upload a drawing for each drawing number (via. Google Docs or local upload) but how can I create a link from my HTML view to the drawing so they can view it? The Drawing is in PDF format and ideally would be "downloaded" or "opened" via the PC or tablet software. I'm not really sure what my options are so if someone could point me in the right direction that would be great! Many thanks in advance Ben
total of a sub-form in a form
Hi i´m trying to do this and can´t seem to figure out how it´s done the "Total = 1379", how can my form give me this total regarding the values come from the sub-form? https://help.creator.zoho.com/Creating-SubForms.html#Deluge_Script Thank you.
Issue with Client's Application
I am assisting user viviennepbe with her pbe-ergonomic-evaluation-form. The form Ergonomic_Evaluation is stateless, but experiences this error for some submit types Error details: Error occured while executing on click script. Error occured. Also, I cannot delete records in Chrome, only IE 9. I think there's an issue on your side with this account. Enabled support edit access John M. Whitney
New User - Advice Needed
Hi there. I'm a brand new user to ZOHO and I'm excited by what I have read. I wanted to see if I could post my question for some input from all of the experts here to make sure I'm going in the right direction prior to getting too lost in the details. Here's the scenario. I manage a number of websites for our local high school. All volunteer work. Example is http://www.MarcusDrillTeam.com. I work (limited) with SQL databases where we collect data through forms. I have even posted to the SQL DBs
HTML View with Iframe and a form record opened for editing
Hi Need a HTML view which works as follows Top half has an iframe which contains a view I decided on an iframe for 2 reasons 1) The view is very wide with an iframe you can scroll left / right 2) below the iframe i want a from which needs to stay in a fixed position, with the iframe above i think this can be achieved Ok... now where i am stuck Bottom half of the screen i want a form opened with the record i want to edit So far i have tried to 1) Embed my form but that only seems to allow for a form
Next Page