How to get current table name in the ZC Deluge?
Hi How to get current table or Form name in the ZC Deluge? Thanks Stanley Guo 2012-2-14
Is it possible to reference a form dynamically in Deluge Script?
Hi! Is there any possibility to reference a form dinamycally using string literals? Something like this: Form myForm = zoho.getForm("App", "FormName"); myRecords = myForm["Foo" == "Bar"]; It would be fantastic!
Cannot delete record
I have 2 forms: "EP Configurations" and " EP Core and Menu Default" I added lookup filed "EP" to " EP Core and Menu Default" from "EP Configurations" - > field "ID". Later I decided to get rid of this field. (I deleted it) Now, If I added new record to EP Configuration, and then try to delete it, system hangs forever. The only way I found to delete this record, is to create "EP" lookup field again on the " EP Core and Menu Default" screen I shared the application, you can take a look "EP
Help with Date calculation
Hello all, I would kindly like to request for help in writing a code that does the following: On my form, I have two date fields, 1 with the date, the client makes an order and the other when the client is to make a payment. I would like to do the following: within 14 days, of entering the 1st date, the second date should be updated i.e the client should make the payment, if not then send an email to the client informing him/her of the due payment. If however, within the 14 days, there is a payment,
Can't copy or duplicate application
The application won't copy or duplicate, which of course is necessary to test it.https://creator.zoho.com/utl_la_rochelle/adherents-utl/ Can you help? Thanks so much Joël REMAUD Webmaster jremaud@utl-larochelle.org
Problem with hide/disable of subform field
I have the following statements in the on edit on load section of a form hide Order_Actions_subform.Courier_Count; hide Order_Actions_subform.Owner_Count; They work as expected. However when I switch to scriptbuilder mode the statements are converted to hide Order_Actions_subform; hide Order_Actions_subform; Which hides the entire subform! Herb Wexler
How can I pass a value to restrict a picklist from a subform when adding a new record to the lookup form that populates the picklist?
For instance if I had a main form that contained the field "Country" 1. and a subform in which I needed to add a new entry into one of the subform's field's picklists 2. and the lookup form that populated the subforms picklist had both a "Country" and "City" field, 3. how do I filter the lookup's "City" field by the "Country" selected in the main form? Or in other words how do I pass a the "Country" variable value 3 levels deep to the lookup field. I can easily do it if it's a lookup for a field
ADD / Remove modules
hi..is that possible to rename the main modules like FORM, VIEW, and add extra modules ??
Dynamic picklists. Field selected vs field visible in form
Hi, when using Dynamic pick lists, how can I populate the pick list with say, IDs form the applicable records of the target list, and yet see other field in the pick list like name for instance. In other words I wan to emulate what the default picklist field does in a form. you link to a field but can see other field/Fields. I want to link to IDs but wan to see name. thanks for the support, application details below My application: Sistema de Operacion Yaxche Form: Productos Cotizados Dynamic Picklist:
Grabbing variables from URL Query String within functions
Is this possible? I have a custom action button set to appear on each row of a view, and as part of the action I want to be able to take some values from the record in question, as well as a parameter from the URL query string. I know this can be done in HTML views with parameters but is there any way to do this with a standard function script?
Variable not passed to subform record after the 6th record is added.
I have a subform that receives a value "Country" from a selection in the Parent form, when a record is added to the subform. The following script works up to the 6th record then fails every time on the 7th and stops the form from being submitted with an error. The attached screen shots are from the same page but it was too long so I had to capture into several consecutive images. There was a 4th image but just found that 3 attachments are max. ************* Code to pass Country to Subform record:
Filtering a View while the filtered field does not show up in the view. Is it possible?
Hi, I understand that in order to filter a standard view that is posted in an HTML view, it is necessary to have the field I want to filter for, active in the view. If this field I want to use for filtering is something meaningless to the user, say for example the record ID, I would preffer if the field actually does not show up in the screen taking valuable space that can be used to diplay more usefull information. If I diselect the field though then the filtering does not work and I end up with
Picklist behavior is strange and not working.
I pass a value of a Deal to a form to be looked up and then populate the lookup using the following code. if (input.cmd != "") { //input.cmd is the deal ID passed. theDeal = Deals [ID == input.cmd.toLong()]; input.Deal = theDeal.Deal_Name; }This is not working anymore. (I haven't touched this code in a year!) Also, why do these two drop down look different?
Open URL with Http Header
Hi, I would like to write the user help documentation with an external tool. I choose Google Sites - it's easy and looks good. Our costumer needs security, so site pages cannot be public. Then, I try to open the desired site page passing the authortization as http header. When I use getUrl it works fine but, then I receive the html page as text - I dont' know what to do with it. When I use openURL, ops, I cannot pass http headers. Is it possible to pass http headers to openUrl function? Is there
Viewing multiple records associated with a single record in another form
How do I create a filtered view of records which are associated to a single record of another form? I want to be able to click on a record from a list and be taken to a view of multiple records that are 'linked' to the record I click on.
View photo while entering data
I'm trying to create a simple app that allows me to view a photo on one side of the screen and enter data from that photo into fields on the left side of the screen. However, the only thing I've been able to do so far is to see the photo next to uneditable fields. In order to enter data I have to click on the "edit" link which then covers the photo with an editing screen and prevents me from easily seeing the data in the photo. Anyone have some ideas on how I can do this? Any help would be greatly
Creator Form Design
Hi I looking at creating some data entry forms which have quite a few fields which will take them over the page. To keep the formatting clear it would be ideal to mix some sub forms in too as well as using the column formatting. It appears from investigations that there is a limit of two columns to per form which I can work with but I'd like to know if there is any other formatting that can be used with columns. I can't find any further documentation. This formatting also doesn't play nicely with
Why cant I delete a record?
Why cant I delete a record from this form/view? https://creator.zoho.com/yaxche/control-de-operacion/#View:F1_Lista
Delete Records stuck at loading screen
Ok, Support team please get back to me asap. I cant not delete any record in my app. stuck at loading screen. I am on a Enterprise Plan, so please do not ignore this post. This is urgent as my users need to get back with their work. Thank you.
building a form that need to have lots of rule but has heavy restrictions given where it will be uploaded
hi, i want to use your form builder to create a form which i have been able to do on some free form building websites but i have some futher restrictions id like to place on my users before that submit... a bit of background.... im having trouble making a form with lots of rules in it. i have a html script that was written for me some years ago for my old website that consists of 3 vertical colums. this script can be emailed to you would like to see it or viewed (not working) at www.thepclub.weebly.com/moonee-ponds.html
Code that once worked now does not
I have 3 nearly identical forms that contain look-up fields and sub forms. All were functioning properly and in use. and have stopped working as of today 2/2/2012. The forms contain a report type look-up field and a country look-up field which has On Update code to limit picklist values for Region, City etc. Both fields report type and Country pass their values to 3 subforms. As an example one of the sub forms is "Training Subjects" that were taught at the event. Upon adding a new record in the subform,
Permission problem
I am trying to limit certain users to be able to edit data in certain applications but not in others and am running into problems. Suppose I have one main application (Personnel) and a related application (Projects). I want users to be able to edit the information in Personnel but not in Projects. Projects is private and not shared with anyone, and yet it seems that by creating a link in the Personnel form to Projects (Personnel can be connected to one or more Projects), it opens up the user to add
Cannot add new records via API, if the form contains a subform
When I try to add a new record via XML RPC API to a form that contains a subform, then the API call returns success, but the new record doesn't show up. It doesn't matter whether I don't set the subform field (i.e. create a new main record without subform records), or whether create a subform record before and set the subform field of the added main record to the id of that subform record (i.e. create a main record with one subform record). Adding records manually works well. I can also add records
postUrl not working
I always get internal exception from postUrl,can anybody help me?the script work well several days earlier. helloworld = map({ "Airway_Bill_Number" : input.Airway_Bill_Number }); result = postUrl("http://vytalhost.com/zoho/shipmentValidation.do?Declared_Value=" + input.Declared_Value, helloworld); I'm sorry,but I,m dying to solve this problem,please help me.
Custom Actions - Select E-Mail Notification
Hello Zoho Community, How To Have A Custom Action in View That Sends E-Mail Notification Where You Can Pick The Column Range Like 1 - 50? Looking Forward To Your Help. Thank You.
Displaying PDF files in a view
Hello, In my application the user can create a drawing and upload a .pdf file that has the technical data on it. Is there a way I can view or create a view that shows all the different drawings in a grid form, so the user can browse all the drawings easily and then select the drawing they need? I have seen a sample application using JPEG images but unfortunately I need something that works with PDF files. Many thanks Ben
When do these options become available? or never?
Hi, for one thing i dont understand why Zoho CMS not yet include 2 basic things: 1. Lock Record To lock a record, i now use the Lock ID form. but if a user clicks on Edit, and click cancel, the record is still there in Lock ID form, meaning the record is still locked. b/c there is no Action on Cancel. this work around only works with Action on Success. so a work around is to have custom schedule running to delete records every interval needed. now i have to come up with a bunch of lead time for bunch
Latha ：Urgent need of help..
ZC team: I have a business application needs: 4s in China's auto shop to read specific data in their databases, ZC have a way with their database docking? Have any suggestions or solutions? The means is ZC is there a way to get data from external databases? Thanks and waiting your reply Stanley Guo 2012-01-31
Similar script produces error
The application in question sends an email "on success" to the end user. Subsequent follow up emails are sent over the next few weeks using an "on load" script. I have been trying to add a script which continues to produce an "on load" error. This is the script just before the new lines I am attempting to add. It works fine, as do the scripts above it. (NOTE: I have removed the email content so that this post doesn't exceed character limit). else if ((lead.Added_Time.addDay(30) < zoho.currentdate)
On Load View - Check Fields & Input Value
Hello Zoho Community, On Load View I Would Like To Check Fields & Input Value. FOR EXAMPLE: When I Click On The View. It Will Auto Check Each Record If Current Date Before 1 Month > Membership Expiry Date Then On Input.Status Show "*" On Load View For Each Record If zoho.currentdate (BEFORE 1 MONTH) > input.Membership_Expiry_Date { Input.Status = "*" } Looking Forward To Your Help. Thank You.
Custom Action - E-Mail Notification + Input Current Date
Hello Zoho Community, Custom Action To Send E-Mail Notification + Input Current Date. void email.EmailNotification(int toaddress) { sendmail ( To : zoho.adminuserid From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message" ) input.Sent_Date = zoho.currentdate; } Looking Forward To Your Help. Thank You.
Sub Form Field Validation ?
I have a subform where I have set a script for converting the contents of a field to 'Upper Case' input.Product_Description = input.Product_Description.toUpperCase(); And when I access the form directly, it works really well - and I can add the script to On Add, On Edit, Validate etc..doenst seem to matter... But when I enter data through a master form, that has the first form embedded as a subform, the field criteria are not inherrited, so the data entered does not get converted to Uppercase....
see only selected records (updated)
I have 3 forms the first form is called "Car " single line "Automobile Make", single line"Model", single line"colour" single line"unique ID" (database driven) Each Automobile has 5 wheels and tyres hence 2nd form is called "wheels" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile Make" single line" Wheel1, single line" tyre 1, single line"wheel2, single line"tyre 2, etc etc Form 3 is called "emissions" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile
No hyperlink for underlying data in ZOHO creator report / chart
Hello i am a ZOHO creator enterprise edition user i have created some reports / charts for my colleague but only the Admin user can use the hyperlink to see the underlying data could any one show me how to share charts with underlying data enabled thanks regards, Matthew
Custom Action showing on clicking on view
I love the new feature of being able to put a custom action in any location on a View. However when I click on the view button to the left of the record the custom action shows as a field label. Apparently it pushes the other field names down on the list so the data associated with the field label is offset by one. If the view is: Field1 Field2 Custom Action Field3 Field 4 Field 5 Data1 Data2 Button Data3 Data4 Data 5 Then the view is Field1 Data1 Field2 Data2 Custom Action Data3
will the ical feed work with 30 boxes?
Unfortunately, Zoho doesn't have a robust calendar for scheduling, so it has referred developers to Google Calendar. I (and a number of others) am very unhappy with the Google Calendar and am trying to find an acceptable alternative. I have heard 30 boxes is a much better calendar that google, but I can't seem to get the Zoho generates iCal url to work in 30 boxes. Do you know if it will work with 30 boxes or not? If so do you have any tips on how to make it work with the zoho generated ical feed.
ZC there any way to get SQL or ORACLE data in these databases?
Hi ZC there any way to get SQL or ORACLE data in these databases? Thanks Stanley Guo 2012-01-29
Stateless buttons not wrapping in IE 8 & 9
When I embed a stateless form in a website Internet Explorer does not wrap the form to fit in the space. Firefox & Chrome will wrap to fit in the space on the website. In IE 8 & 9 the buttons do not wrap and the form is truncated. I attached a document with screen shots. Is this an IE bug or is there some code I can add to get the form to wrap to fit the space? Herb Wexler
Lookup Forms Issue
I'm on my trial and I have an issue that is a kicker to determine going forward. I'm setting up a business process that each form will build on a previous form's submitted data. Form 1 - initial input to start process Form 2 - management form, to be used to accept what is in Form 1 - this form uses a lookup field to get "Name" from Form 1 Form 3 - is the next set of criteria that "Name" will need to go through. (HERE IS THE PROBLEM - see below) Form 4 - another management form to determine going
Adding links to Edit Form and Pass Value
I have a relatively simple DB schema. I am building an application for a charity auction. There are multiple bidders, each of whom will likely bid on and win a number of different items. We won't know the price they will pay for an item until the auction is over. At end of the auction, we need to list all of the items that each bidder won and total up how much they owe. There are 3 tables: (1) Bidders. While there is information here like name and contact info, we are concerned with 3 fields:
Next Page