Passing parameters via URL in embed form (or permalink) not working on iPad
Hi guys, I can't pass parameters via URL on iPad... This is working everywhere else. Is there a way to make it work ? http://creator.zoho.com/nsisolution/<appname>/form-perma/iPad_Test/from=iPad Thanks Pascal
How to Sum across all records in an application
I have an application where there are 2 fields that capture numbers in dollars. I want to be able to total all numbers for all of the reports. How would i go about doing this? Here is the application I want to be able to get a total for all records for the fields "PAID" & "BACK" thank you in advanced.
Trying to fire an email that contains a group of reports for a single country
I'm trying to fire an email that contains a group of reports for a country. For instance reports due for this month or reports past due, etc. I've got it sending 1 report per email - not what I want and I've got it sending all reports to every country (not just their own, but every single one) - not what I want What I want is to send only the reports for a particular country in a single email. As in sending the 4 over due reports for Ghana in one email. Thoughts? ******************** This sends every
GApps Users
I tried pulling in the GApps Users option from the form builder, but when running the application from a Google Site - all I get is "Select" in the dropdown field and no user names. I don't particularly want a dropdown list - I'd rather actually capture the GApps User's name behind the scenes and tag the username for the user adding data to a form. Any more examples of how to implement? I've tried logging out and logging back in to my GApps acct to see if that would trigger it, but that didn't work.
How do I integrate a Creator Form into CRM?
I created a Form to update the contact information in crm. Is there a way to post this data into crm when the submit button is pressed?
[Form Customization]: How go control the location of placement of a control in Zoho Creator
I think I had come across this information at some place a while back but can't seem to find it now that I really need it. I need to layout the controls on the form so that they are placed over three vertical columns (v/s two columns that is the default). Actually in my case, most users have a wide screen and prefer to have the controls laid over three columns such that they all fit in a single screen view without any scrolling. I do not want to break the controls over two forms either as they want
Custom Action - E-Mail Notification Question?
Hello Zoho Community, I Would Like To Have A Custom Action - E-Mail Notification Button ("show action in view header") that sends notification to all that meet the following condition. void MonthMembershipExpirationNotification() { for each record in Form [(E_Mail != "" && Method_of_Payment = "Cash" && zoho.currentdate.getMonth() = input.Month_Membership_Expiration_Notification.getMonth()] { sendmail ( To : record.E_Mail From : ""
How to find Zoho expert in Nashville, TN
I'm looking for help in configuring zoho for specialized real estate company
Submit Print Button
Hi I use this link https://help.zoho.com/portal/en/community/#topic/2266000000362158 for print a view but I have a problem: howe can i change the default header and footer to invisible when i print a view??? this my mail: walid.jaha@yahoo.fr thanks
Share by information in a View
I would like to share portions of an application by information in a View. For example an application may have a list of members that are either Active or Inactive. I would like to restrict access to some sections to Active members. In the share section it would nice to select a View and indicate the column which contains email address. When a member changes from Active to Inactive there would be no need to go back to the share section and change the list of email addresses. This feature can evolve
Commissions Calculation
hello all, In my application, am trying to calculate the commissions to be paid out to sales people. I already have the criteria for the commission, e.g if a clients purchases product A, the sales persons gets "x". am having difficulties in writing this code; it would run like this: if the Product is A, then commission is "x". Any ideas on this? kind regards,
Need help email notification.
hello all, I would like to enable email notification on a stateless form, based on the following criteria: my application is based on managing the sales task force, I use the stateless form to update the status of the clients that the salespersons talked to. In the form, I do not capture the salespersons email id, but I do have their email i.ds. How do i enable, that when each client details is updated, an email is sent to the sales person about the status of the client, including the details? Thank
Frame tageting is broken again.
Hi. Behavior that has been working for 2 years is now not working. The submit success message is breaking the frame targeting. Use Case: 1) Target a frame using the anchor link attribute TARGET. Like this: 2) Open this page and click this link: Matthew Trouts <a class="_Lnk" target="tskCal" href="http://creator.zoho.com/ensobase/david_bartels/Listings/record-edit/All_Listings/243881000033951289/&zc_SuccMsg=Finished" style="font-weight: bold;">Matthew Trouts</a>3) The proper form loads in the Frame.
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
Next Page