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?
Formula Field & Aggregate Record (Count)
Are there any plans to allow a formula filed to support the aggregate record function? The use case is a vacation day application. Users can see the number of days they can take and the number of days they have taken (via record aggregation). I'm using an html view to do all this now. Cheers, John Whitney ZOHO Creator Developer
Hoe to create a view showing only "today" records
Hi, I want to create a view showing only "today" records submited. I already tried to create a view with the following criteria set: Criteria : Added_Time == zoho.currentdate But it`s not working (doesn`t show any records) Is it because zoho.currentdate is not the same time zone i`m using (GMT, Lisbon)? If so what can i do to correct this "bug") Thanks in advance, Jose Pedro Alvarez
Can't duplicate this application
I want to duplicate this application but can't . Please help me. Thanks
Can one delete a Zoho Creator application?
Can one delete a Zoho Creator application? If so, how? Larry
Data not populating fields in form
Hello, I am having an issue where data from my stateless form is not populating the fields in the form it is supposed to be INSERT INTO. Please see code below. What is supposed to happen is this. 1. In the STATELESS FORM The user enters data into "input.Lateral_Vibrations_Bin_One" this value should be multiplied by 0.5 then the sum should be loaded into "input.Lateral_Vibrations_Bin_One_Weight" 2. When the user submits the data the value from "input.Lateral_Vibrations_Bin_One_Weight" should then
Creating CRM Task from Creator application
For certain requirements, there may be a need for creating a ZohoCRM task from your Creator applications. This post is about using a Creator form to create a CRM Task. Below is a simple To Do form which creates a CRM Task for each record added. In the above form Client is a CRM Field that refers a Contact Module. Refer this post for including CRM modules in Creator form Below is the code snippet that should be written in the on-Success action of the form to create a CRM Task taskinfo = {
Cannot provide admin rights to my developer
I cannot provide admin rights to my developer. Can someone help? When I go into my application settings I don't have any option to add admin rights. See image attached. Please help as I'm wasting time with my developer and they too are getting pretty frustrated with the lack of access to help build my forms and capability.
Creator client api sort pick list?
Hi, Is there a way to specify a sort type for a select (pick) list using the Zoho Creator Client API? Or have it honor the Zoho Creator form attributes for the field? The default Zoho.writeInput(<fieldName>) sends a case sensitive sorted list which isn't what is displayed when using the form directly. Kind Regards, Carol Hatcher
How do you set the value of a Lookup field in a child form?
I have 2 tables - Sites and Person. I have joined the tables using a Lookup field in Persons which is the ID of the relevant record in the Sites table and displays the Site name and town fields. I need to have a button next to a record in a view of Sites, 'New person', that opens the Persons form with the Site field set to the record ID of the record in the parent Sites table i.e. to add a new person to that site with the site field already set (to make it simple). How do I do this?
How to use Zoho Produts for my site
I m owner of http://www.freecss.in/ ( Free Css templates ) . How can i use zoho products to make my site better
SQL queries in Zoho
I am going to a new job which requires a lot of SQL query skills. Is there a way to learn this in Zoho Creator? If not, how to get started on Deluge Script and programming on the Zoho interface? Thanks.
Next Page