Embedding form in wordpress?
I have a simple form and I am having some trouble getting it into our Zoho Creator form to post to our Wordpress site. I have seen numerous discussions on how to do this, but it does not seem to be working for me If I copy and paste this (with the appropriate address): <iframe height='800px' width='600px' frameborder='0' allowTransparency='true' scrolling='auto' src='https://form web address here'></iframe> nothing shows up. Also, once I do that, how do I suppress the "form title" within an iframe?
Use of tags separating Deluge script and html: Script Builder
Hi I followed the tag explanation given in Create Html Pages which explains the use of the <% and %> tag to separate the script from the html. However the example shows the use of the <%}% as the tag marker with no explanation as to the difference. I input my script as a free flow. But when I save it, script builder has changed "simplified" my closing tags. Why? Original: html page <%{%> .........html script <% start my script %> end my script tag <%}%> close my html script
Find & Replace
Is there a "Find & Replace" option ? Example: find all occurrences of "141 BN" in all or selected records and replace all found with "114 BN".
Update Multiple Records from Single Stateless Form Submission
I have created a stateless form that has a multi select lookup field and a couple other fields. I want the form to update all of the records selected in the multi select lookup field. Can this be done? I have made stateless forms work when only selecting and updating one record at a time but im not sure how to do this with multiple records at once. Im using this for a Batch Shipping Application. The idea is you can use the multi select field to choose the orders that have shipped together at the
Change 'true' to 'Y' on reports
If I have a Decison Box field in a Form, how do I get it to display as Y or N on reports, as opposed to true or false?
Strange OpenURL behaviour
Hi, I am getting strange behaviour with an openurl statement. I can recreate this at will If I log in a fresh to the creator dashboard and choose my app I get presented with the first form (stateless) no problem, on the first form I choose a record from a drop down,again no problem. I then use a button which uses the open url to view the detail of the record chosen. The openurl format is openUrl("../appname/#Form:Sensor_Codes?Ref=" + input.DDRef, "Same window"); Where DDRef is the reference of
How do I do pattern matching on a field
I want to validate a text field on a form to match a particular pattern as follows: PPXnnnn Where: First 2 chars = "PP" (upper case) Next char = upper case letter, eg Q Next 4 chars = numbers, eg 1111 It would also be good if I could default the PP so the user doesn't have to type it in as it will be the same for each record. Any help would be appreciated.
Lookup field: change from Multi Select to Single Select
In my forms, I have some lookup fields which I want to change from Multi select to single select. However, that option ig greyed out. Unforunately, I have to had to resort to deleteing all of my script code, delete the lookup from the form, and recreate everything from scratch. This is a huge pain.
Zoho creator - real time search filtering
Is real time search filtering available in zoho creator? i.e. where the results narrow as you type in the search field. See link for video demonstration (note that it searches through all fields and not just one as in zoho creator): http://youtu.be/wfNIK-nhySc Or is there a google search plugin that can be used to search the zoho creator database? google search has some intelligence built in whereas zoho creator creator requires that the user types exactly what theyre looking for eg if i have a field
Need a Developer for Creator/CRM
Is there a Zoho Creator developer in the Las Vegas area? If so, I would love to consult with you.
Need to export Zoho creator pages
Hi, I have created a page using Zoho creator, and want to export this page as a pdf to external users. However, I am running into two issues: 1. I have used an iframes to display objects in the page. On manually exporting this as a pdf, the form does not show up. Instead, it asks for a login id and password. Is there a way to make these iframes public. 2. I need to export this page as a pdf or as a link to external (non-zoho) email addresses. Basically, I need to schedule export. Is there a way to
Using Pin # as Signature
I am creating a form that allows Supervisors to do training record keeping online via mobile devices. I already have a form that has an Employee List. There needs to be a confidential PIN number for each employee. The employee would enter this in during the creation or revision of his/her record in the Employee List. Is there a way to hide the characters the employee enters during the record creation or revision? Is there also a way to validate that the employee has 4 numbers in his/her pin?
Update field in the subform
I have a problem, when I change a given in a Subform, eg, dumb a product of company A to company B, it does not update the data in the subform company B. He even updated in the database, but not in the subform. Once changed the owner of the product in the subform, I deleted it from the company, and want to know a way to populate the subform company B. Anyone have any ideas? tried using row.SubFormField = input.FormField; but it still fails. att.
Add records in a form via stateless form
I have a form(example) with three single fields (season, from, to). I also have a stateless form (example2) with 3 fields also. A lookup field(with name example) to season, and two single line fields (from, to). I also have a button (ADD). What I want is to add records from the stateless form to EXAMPLE form. I wrote this code in on add-> On click field but it does not add records. It only updates the record. What am I missing? r = example [ID == input.example]; r.From = input.Form; r.To = input.To;
Paydates
I have tried this, but I am still a little confused on how to show a start date, and let it auto date. ex: January 10,2014, January 24, Feb xx and so on. I set the initial date field to Dec 27 (Fridays) but when i try it, it shows Feb 4 (Tuesday). I need to get it to auto bi monthly on Fridays only. "input.Pay_Date=zoho.currentdate.addday(14);"
How to get image to display on a form
I have added an image to my form by adding a Notes field. I don't have an Add Image button so I did this by inserting the link by clicking on the HTML button and typing the following (which is the copied link from the mediafire web site): <img src="https://www.mediafire.com/?o1d6gqqf9g3tbfg" /> When I go back to look at it, it has changed to: <img src="https://www.mediafire.com/?o1d6gqqf9g3tbfg"> I'm not sure if this is relevant to my problem. When I view the form, it's showing an image place holder
Allowing electronic signing on forms
Hi folks, I have developed some online forms and I was wondering whether I can now have clients sign these online on a tablet without having to print them out and then scanning back in for emailing? Thanks.
Invalid Entries, failed to add data - only for embedded form.
When I embed a form I am getting the invalid entries, please try again pop up error message and failed to add data error message is appended beneath the form fields. This is odd to me, because when I access the form and submit it I hit no problem. I was also able to use the form for a while, but suddenly it stopped working. My suspicion is that a script I saved a while ago has not been overwritten, even though the little status button by the workflow scripts in deluge is only green on On Add ->
Editing Records from Reports don't link to base Form (since about 30 Minutes)
I've been working on a Creator application for the past couple of days and all of a sudden things don't work as they used to (since about 30 Minutes). Previously, when I clicked on the Edit button in the left-most column of a Report, the original base Form would appear with all the fields and all the validation logic, etc. Now what I'm getting is a dialog box with just the fields from the report. I have rexported the application and diff'ed it to an older copy, but I can't find any difference that
Non-existent function stops me from deleting fields
I have a function in my 'shortcuts' workspace called getIssueNumbers(). Somewhere along the line Zoho has managed to create a ghost version of this, tagged with what looks like a record ID number, which I can neither find nor get rid of. Anybody have any ideas how to delete it?
NEED AN EXPERT
Hi , I am very new to creator and never been good with technology. I am looking to setup a small business and needed an expert to build me a system on creator. I have spoken to both zoho sales and zoho creator who have advised my requirements can be met. If any expert is available to speak to I would be happy to speak. Any help would be great. Thanks Bash
Look up variable from one form into another
I've spent an hour trying to research how to solve this, and I'm hitting a wall because it seems so simple, yet I can't get the thing to work. In form Component_Name there's a text field Component_Name. In form Template_Name, there's a text field Template_Name and a field Component_List that's a multi-select of field Component_Name. In form Page_Name, there's a text field Page_Name and a field Template_List that's a drop-down that pulls options from form Template_Name. In form Data_Entry, there's
fetch multiple records and sum
I would like to fetch all records wit the same unique Id number from one table, add the data in a specific field in each record so I get one total for multiple records ... and then put that total in a separate field in another form. How do I do this. example..... Employee Time Form PO number | Reg Hours | OT Hours 12345 8 4 12345 8 6 54321 8 0 54321 8 6
Incorrect Record Summary displays for report
I have three reports that reference the same view. Two of the reports do not have a custom record summary template created for it. One report does. When I look at the report with the custom record summary, the radio button is selected correctly and this custom record summary will display ok if I just updated this report. The problem is that whenever I run any of the other two reports that do not have a custom record summary and then run the report with the custom record summary, the default record
Configuring add notes field after fetching data
Dear All, I have a form (Hotel Details) with a single Line field (Hotel Name). I also have a second form (Seasons) with an add notes field. I used the following <font color="#ff0000" size="5">Add your Note here ...</font> to change the size and the colour of the field. What I am doing is to fetch the value from the single Line field to the add notes field. I used openUrl(((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Seasons?plain11=" + input.Hotel_Name, "same window"); and it works fine.
Filter lookup and populate filed in a subform
Hi. I have created forms: 1st form: Roof Type - which has different types of roofs we service in one field 2nd form: Problem/Solution Roof Types - lookup based on the Roof Type form Problem - Field which is a common list of items we find based on Roof Type Solution - Field which has the solution for the selected problem. I have another form with the work order request. On this form it also has a lookup related to Roof Type. I created a subform for multiple records with a lookup for Roof Type. I added
hide names of hidden fields in form
hi just make number of fields in form as hidden for user. but when editing entry - user can see all list of all fields in form. and pick hidden field for changing. how can i hide for user name of fields that are hidden for him in form?
how to make backup scheduler?
hi how can i make scheduler which will be backup whole app every scheduled time?
Roles in scripts?
A couple of months ago I had this application dropped onto my lap when the previous admin moved on. They gave me access to the application, the URL and a hearty good luck. I have web development background so I have a basic understanding of the scripting and how most of it functions. In the scripts it refers to Roles, but I am unable to find where the roles are defined in the application. I have searched Google and the forums, found several articles like CRM Help - Creating Roles, it refers to clicking
Lookup field content does not display in a view
Hi I have one lookup field between two forms. When I select a view combining fields from both forms my lookup field appears in the report header but the contents of that field are empty. Do I need to link the two forms in some other way in addition to the lookup field? I have followed "Creating_a_relationship_using_single-select_lookup_field in the documentation." The form builder links the two forms and I can select the additional fields from the second form and enable them in "column view".
Update Multi-Select Field in another form based on input.Course field
i have a multiple select field under Students form with the available sessions for January. Field name is January In the Course form, I have a multi-select lookup field for the students. When I save the Course form, I want to update the multi-select field of the selected students to reflect the course name Course name in the Course form is the same as the options in the multi select field under students. Is this doable? Thanks!
Generate duplicate count in each record using formula
how to write formula to generate a duplicate count in each record, example: FormA Name Age Count(auto generated number of same age) Lily 16 3 Lucy 20 2 Kate 30 1 Bill 16 3 Jean 16 3 Carl 20 2
Report emailed is not same format as template
I have taken the time to make a report template of two columns and when I fill in all the information and click on submit it emails me a copy and when I get that copy the form is not the way I have it set up. It seems like once I hit submit it reads the from from top to bottom of the left column and then from top to bottom of the right column and emails it as such so my cells and the information is not side by side.. Example would how it should be is.... first name last name pax 1 name
XML RPC API Zoho CRM lookup field
I have a Zoho CRM lookup field in my form that looks up the customer's name from the CRM. When I attempt to import data using the XML RPC API, I receive the error "Failure, Invalid column value..." I have tried to use both the customer's name and the customer's ID from the CRM. How do I fix this problem?
Linking two tables in HTML View...
Hello everyone, I am working on an automated script to pull menu information from two different tables based off of criteria in only only one table. I will attempt to illustrate my problem below: We have two tables i need to draw from: Beer_Locator & AVLBeerManager. AVLBeerManager contains all of the information about specific beers (ABV, Description, etc.) Beer_Locator contains all information about where the beer is currently on tap (we are a chain of beer bars that has multiple locations with
Redirect to another page and set default value
Hello, I have a form called Employees with a field called Name (Single Field). I want when I click Submit then to redirect in another form (Details) which has a lookup field (connected with Name) called User name. I did it with the usage of openUrl urlStr = ((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#Form:Details?"; openUrl(urlStr, "same window"); My question is how can I set the value (which I will insert every time in the Name field) as default in the lookup field? I did this one but it
Contacts Sync with Google Apps
Dear Team: We have created a Contact Form in Zoho Creator. Can we set a sync in a way so that when a contact is added into Google Apps, it creates a contact in Zoho Creator as well. Please suggest. Thanks
submit via email problem
hi submit through email works fine if i send direct email to zoho app's email address on site i can install zoho app's email as first or as second recipient and when there are few emails in recipients - entry do not adds in app. why? zoho app's email is in recipients sender email is email of zoho app users
Write field contents to two tables
Hi there, I have a form named "Observation" which has in it a multi line field labelled "Issues". We enter items into this field separated by commas. When submitting this form I would like the contents of this "Issues" field to also be written to another table from a different form. I'm guessing I need some sort of on-submit script but don't know where to start. Is this feasible? Many thanks!
Report to show only users info
i created a pivot chart to track employee vacation time. showing vacation requests approved and total vacation accrued. My report is pulling all the vacation accrued from everyone. "vacation accrued" is a field in a form that is manually updated but is located in another form other than the leave request. Thanks for the help.
Next Page