Using ZC form (with dynamically generated url parameters) on NING
Hi Team Ticket ID:1745299 Subject:Trying to integrate ZC form (with url parameters) witn NING (Community page) I am trying to integrate ZC form into a NINGpage. This is a three part process WebForm 1 -Basic ZC contact form embedded on client page - with predefined field values passed as static url parameters Works good, no problem here Form submit > initates an email with a link to Webform 2 Email is passed as parameter url parameter is generated based on the user-email in webform 2 URL is getting
set up field when pickup field
hello. I have 2 forms: 1. FORM "blogtext" whith pickup field "name" (i pick it up from form podr1) and field "mailto" 2. FORM "podr1" with field "name" and "email" What can i do to: when i choose the name in form "blogtext", need to set up emal from choosen person to field "mailto" Thanks
Please ! urgent... Update a total after deleting a row
Hi, Thanks to you folks, I'm now able to have a total in the main form that sum values from a subform. This part works fine. But there's still a minor problem I can't solve: if the user delete a row with a value in it from the subform, the total is not updated. It seems logical, given that there's no "user input". So I tried to apply the same script on "on delete row" but nothing happens. Any idea ? Here is my script: temp_total = 0.0; for each x in FPA1 { if (x.Montant != null) {
More effective Group Member management
We have hundreds of volunteers in several counties around California, each of whom will be a User in our Zoho account. We are creating an Application and a Group for each county's volunteers, and Sharing each county’s application with that county’s volunteer Group. Volunteers come and go all the time, and only current volunteers should have access to one of our Applications, since the Applications will contain sensitive information. Thus, we need to be able to easily compare each county’s list of
How to hide/show forms based on user selecting "Accept" on terms and conditions page?
Hi, We have the following requirements: 1. User (Not Admin) visit our site and will show the terms and conditions tab only each time 2. Once he click the "Accept" radio button and click "Submit" button then shows other forms (which are tabs) to him/her. 3. If Admin login, it should show all tabs. Please let me know how to implement it. If having code snippet that will be awesome. Thanks, Winson
Double Vision in Chrome Version 23.0.1271.64 @ Freeflow script mode
Hi ZC team Double vision happens in all apps (personal, shared, developer access) when viewd in chrome irrespective of form / view / Schedule / Functions etc This happens only in FreeFlow script mode Script builder mode is working fine Please see attached jpeg. Thank you Best Regards -Deepa Govind http://homepreneur-online.com/
Submit through mail
Hi there, I have a doubt. When I fill in a form it sends a mail with the information to my client, is it possible that if he replies to the email then it fills in back to the form with the rest of the information? It´s like the submit through mail option but it has to fill back regarding the ID. Thank you
Populating Subform through Deluge Script
Hi, I have looked extensively through the support section, and while accessing subform data is relatively easy, I have still found no way of adding subform data through Deluge script. I am trying to automatically generate invoices when a booking is made, but the line items for the invoice are in a subform. Any pointers in the right direction? I have already inserted the non-subform data into a new invoice: Customer_Invoice_ID = insert into New_Invoice [ Added_User = zoho.loginuser Address_1
Add Items in a PickList Dynamically - Not Working
I am trying to add some Products to a picklist dynamically. I have a form where there is a lookup field called product1. By default it gets all the products from a separate form. I then have another form called "Setup_Delivery_Locations" where I have another lookup field back to the same products list. I want the products list to be filtered by the "Setup_Delivery_Locations". So here is the code that I have: VShiptoProducts = Setup_Delivery_Locations [Delivery_Locations == input.Delivery_Locations];
Adding records to zoho creator with REST API
I'm trying to add a record to one of my forms in zoho creator using the REST API and python. My code looks like this: from httplib2 import Http from urllib import urlencode access_token = 'AUTHTOKEN HERE' h = Http() data = { 'authtoken' : access_token, 'scope' : 'creatorapi', 'zc_ownername' : 'reviewpro', 'external_id' : 1 } resp, content = h.request("https://creator.zoho.com/api/json/desk-com-cases/desk_cases1/add/", "POST", urlencode(data)) print content And I always get the same
Missing tabs even log in as site admin. Please help!
The site works before but just missing all tabs all of the sudden. Thanks,
Email Notification When Someone Updates a Form
How do I get an Email Notification When Someone Updates a Form. Right Now I only get Email notification when someone submits a new form.
How can I test for no entry in an RTF field?
The test ... if (input.RTF1 != "") will not evaluate as false when RTF is left blank. The test ... if (input.RTF1.length() > 0) will not evaluate as false when RTF is left blank. No matter what I try, a Rich Text Field will not let me process ONLY if it has user entered content. It always passes the tests i try to apply and acts as if there is data in the control. What I am left with is entering some generic data such as "n/a" and then testing if the field equals that generic data and using that
public form how to generate a "one time" view of the data ?
Hi, I have a public form and I'd like the user who fills in to have a pdf version of the data submitted. Sending via email is not good here, because I'v several subforms and those datas doesn't show up in the mail. I manage to open the view via "on success" script, but I don't want this view to be public, only one shot to allow the user to have a proof (record the pdf, print it, ...). How can I do it ? Thanks Sam.
Zoho Creator ID returned in scientific format
I am pulling records from our ZC account via the API, but having an issue with the ID field. The values in ZC are shown fully as 1934572634234345645 for a sample ID value, but via the API, 1.93457263423E18. I have seen elsewhere to change the ID value to text, but I believe these values are generated automatically as new form entries are created, and can't seem to find where to change the field's properties. Can anyone point me in the right direction? Thanks!
Play video in popup
Hi, I have a requirement to play the video on popup when user clicks on the link in Zoho form. But currently its playing in the same form.The problem is once user click on the link ,it plays the video.Once its done the user has to go to other form means,the user has to select the browser back button.That should not happen for me. And while playing the video on popup , i should not get the tabs/menus to popup.Only video has to play on popup. Please help me out of this.
What's the proper syntax for Else If Condition
Hi, I'm stumped on getting some script correct. Can anyone help? I have three fields: Field1 is a radio field with 2 options Field2 is a lookup Field3 is a lookup On loading the app I have: Field1 defaulted to option1 Field3 is hidden On User Input I have: If option2 in Field1 is selected then Field2 is cleared and hidden and Field3 is shown. After this I can't get the script right. I want to clear and hide Field3 and show Field2 again, if the user changes Field1 back to option1. Can anyone show
Missing tabs even logged in as admin of the site. Please help!!!
tabs are missing even log in as admin. It works before but just disappear suddenly. Please help!!!
Zoho Creator - integration with crm - set crm-user lookup field
Hi, I have a requirement that I must set "Zoho CRM"-field value "On Load" of a form. The field gets its choices from Zoho CRM Users module. It would be something like this (let the field name be "selectedUser"): selectedUser = someID; This code sets value of the field correctly but text of the field remains empty - when I select paticular user using UI the field gets populated with "UserName". How can I set field's text value using Deluge Script?
Existing Record Subform
Hi Will it ever be possible to have an "existing record" subform. This would enable the function to be able to edit existing records and link them to one form. I know you have lookups, but this doesnt allow the user to edit fields on the existing record directly. Maybe have a feature on the existing subform "add new record / Add Existing record? Thanks
Urgent Need help
Hi, In zoho form,how to place anchor tag/hperlink(Visible link name should be "Click Here",not the actual link). Please help me out of this.
Zoho Creator for HP TouchPad
Any plans to develop an App to use Zoho Creator on the HP TouchPad? We use Zoho quite extensively and would love to be able to use it on our TouchPads. Thank you!
Require/Check for Entry in Prior Field
I have a reservation form with a property field (dropdown) and a check in date field. The user enters the property and then the check in date and the system looks up the available rates. The issue occurs if the user skips the property field and then enters the check in date, the system then crashes with an error (as it is trying to look up a null value). Is there a way for me to check if the prior field (property) has an entry upon entry of the second field (check in date)? I am thinking this
htmlview [calendar] in an iframe/htmlview issue
Hey, I was trying to reference htmlview [that includes e.g. a calendar] in an iframe. The result of this looks partial, e.g. only the secondary-header appears in the iframe. Using views/form have no problems. Did anyone manage to have an htmlview within an iframe section? any examples? Many thanks,
Counter Field in Subform
Hi - new user I like to use a counterfield as a unique ID for related Forms. I have placed script to create the counterfield value - it works fine in the forms . However it does not work when the form is placed as a subform. eg it returns only the previously succesful data - not the current field I am trying to link to: eg Form . Clinical Counter Field Clinical ID Form . Clinical Detail Counter Field . Clinical Detail ID as above they work fine and auto update for the next "new"
Function Help!
Hi I am making progress with my website and have embedded a view successfully, including an email function that allows you to select a record and send an email. Currently the only email I can get to send is the standard one you configure when building the function. What I need to do is create a function where you can write a personalised message (and attach a file) rather than the standard one. Is this possible? Many Thanks! James
relating date field to a view
i have two forms. one is for adding participants to the database. the other form is for adding "events" that participants have attended, which includes the event name, participant list, and date of event. within "events" there are several types of events to choose from that will be repeated over time, including "tutoring", "lunch meeting", "ski retreat", etc. ideally i would have used a dropdown for this field, however since dropdowns are not available for lookup fields it is simply a single line
Charts issue
Hi, I have an HTML view,where i have created 2 iframes.In the 1st Iframe i have placed one bar chart and in 2nd iframe another bar chart. By using openURL iam trying to access the HTML view in the form.While accessing the application its showing the 2 IFRAMES along with the tabs.But i dont want the tabs.I need only 2 bar charts to display. Please help me out of this.
Bug with subform interaction
Hi, I've found a bug that comes up when I'm pulling data from one subform into another. Please review the two screenshots below. ============================================================================ Case 2: I enter a name in the Child subform It seems like there's an error that occurs in the Event Location On Input function because the row.Debug updates don't work. However, I can't debug the function because Zoho doesn't let me use info commands in OnInput functions. No error messages appear.
Is Zoho Creator Down?
I was working on an App and now creator.zoho.com isn't responding at all.
Hotmail (and other email clients) converting a & to url encoded %26
Hotmail (and other email clients) are converting a & to url encoded %26. This is a problem as I have a couple of variables in my url and once this is emailed to a hotmail account or others this issue happends. Question: Is there any way that I can get zoho (in a stateless form) to recognize the %26 as an & sign? That way I can URLencode and fixe the issue?
calculated field requirement
Hi My database contains amongst other things a table of owners and a table for assets. I would like to be able to create a field in the owners table which adds up the capacity field of those assets and displays that in that owner table. I've looked around but can't see any documentation which explains this. I would also ideally like to be able to pull that information into a third view which is contacts and partially made up from the owner table displaying related fields. Please help Many Thanks
How do I downgrade zoho creator subscription?
I have looked all through the forums for instructions on how to downgrade my subscription. I cannot seem to find any button to return it back to the basic package. Please help.
bgcolor in Creator
Hi, Why is form, made with Creator, having a white bg, not using the bgcolor as set in the external style sheet? Thanks for your help. jm
how can I change the "add +" button in a subform ?
Hello, Is there a way (I guess there is !) to customize the "add + / add new" button in a subform. I need it in french for a public access form. Thanks. When you access the application, the Subform will be displayed within the main form, as shown below. Here, the "Order form" displays the "Items" subform to add the items ordered. You can use the "Add +" or the "Add New" button to add entries to the main form from the subform.
Scripting Problem
I'm having trouble getting a simple Hide/Show script to work. I keep getting this error when I try to enter the script to the "On User Action" section: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Here is the script I'm using: if(input.projectType=="Print") { show Quant_Print; } Please help.
Chinese interface
I need to used a Chinese UI for my users in China. Can Zoho Creator do this?
Send Mail when Dropdown field is changed
How would I create a script that sends an email when a dropdown of an existing record is changed/updated to a specific option. For example: a database record has a dropdown with three options (a,b,c) when it is changed from option A to option C (and submitted) I would like to send a notification email to a user. But specifically from A to C, not A to B. Is this possible?
Some preliminary set up is required for this task zoho.crm.searchRecordsByPDC
I got this error when i use this line code crmResp = zoho.crm.searchRecordsByPDC(("Accounts"), ("accountid"), input.Cliente); Error details: Error occured while executing on user input script. Some preliminary set up is required for this task zoho.crm.searchRecordsByPDC . Please contact the workspace owner to do any actions on this application . Somebody have a idea?
move database to another administrator account
How can I move a database I set up to another users account?
Next Page