Change Custom Action button
Is there away to change / disable an action button? I have a button that is for sending a request for proposal. Once it's sent I want to disable the button so you don't resend the same RFQ to the same suppliers. How would you change or disable a custom action button after it has been used? The code Im using in the formula that creates the button is as follows: "<a class='zc-formbutton' href='#Form:Send_Request_for_Proposal?zc_LoadIn=dialog&Request_ID=" + ID + "' >Send RFQ</a>" How would this be changed
Reports Scheduled
I have had my auto scheduled reports going now for about 7 months without a hitch, now the last three days it stopped. When I went to look at the schedule, it added all my reports that are in my database, instead of the one I had. I tried to remove the others, but it will not let me, even when I delete the schedule and redo it. GREAT......:(
Application group share setting can not use
Hello group share setting can not fetch my google apps group information I can only specify the share setting in users mode did the server side anything wrong? Regards Matthew
Form fields onUpdate action
Hello, Now, when you update fields in Form by deluge script, onUpdate action of this field is not executed. But sometime you need to do it. May be it's possible to make new deluge statement to 'fire' this action in database? like this: appName.formName.fieldName.update()
ZCML search - how to?
Hi there, I don't quite get how you define specific search patterns using ZCML. Say I want to get a list containing only Date2=="15/12/2014". Here's what I tried: <script type="text/zcml" elName="zc-component" id="firmwares" viewLinkName="List" params="" appLinkName="iac-schedule" sharedBy="kfiram" adminuser="IAC" params="Date2=15/12/2014"> I've tried substituting "=" with "==" or "?" or any number of different thins, but no matter what I do, I always get the full list, and the params value is just ignored.
input fields aren't accessible in Import Data tasks
BrandModels = (Model[Brand == input.Brand].Name_utilized).getall(); if(BrandModels.contains(input.Name_utilized)) { alert ("Duplicate Brand - Model pair!"); cancel submit; } That simple validation works perfect in form but ends up with error on Import Data. While debugging I came up to conclusion that no "input" is accessible because if you try to: test = input.Brand;... it crashes with same error. How should I validate Imported Data if I cant access it via input? Any Ideas?
Links for Forms/Reports/HTML-Reports in application menu
It will be excellent to have ability to place links for Forms/Reports/HTML-Reports in several menu actions For example: we have sales and tech departments. Sales employers have their instruments only in "Sales" section of application, technical persons have many sections for different processes. But they both use one special HTML-report for edit client information (contacts list, addresses list and so on). And it's logical to place it in Sales section and some section for tech department. Now I need
Zoho Creator Reports - Grouping by Month
I run training classes as a business. I would like to run a report that show revenue by month. I have a report that list the reports in chronological fashion but how do I group them by month? The report is closed.
Zoho Creator API to modify HTML?
I thought this would be very easy to do, but I am having issues. I want to use the Zoho Creator API to hide/show an HTML element with CSS. This is on a custom web site and we want to show/hide a div based on who is logged into Zoho and the field variable attached to their login. For example, If somehow with the Zoho API in html we could do {zohovariable == true} then CSS is display:none. It seems that the Zoho API is used for form elements in HTML only. Is there a way to pull a field value
Changing an e-mail address
Say over the course of a few years I used a certain e-mail address all over my zoho database. Now that e-mail address is no longer used. How do I change each instance of that e-mail address easily and efficiently? Is there a way to change all in one step or do I need to go in and change each one individually?
Error in Fetch Task
Hi Dears, today we have trouble in ´´on success´´ time with our form CMC_Eleitoral. System reporting that an ´´Error in executing Fetch Record task. Unable to fetch Matr_cula_Consular and update variable temp´´ happen. Yesterday we tried to modify a script in on success, but without any reference to this fetch record reported from the system. We have checked all fetch record script but any error wasn´t found by us. We hope in some help from you. Thanks a lot M&Y
Issue with executeXPath attributes? Any ideas what Im doing wrong?
I'm trying to use the executeXPath function upon doing a getURL call and am able to get the element text but not the attribute text. I've used the xPath builder for the following XML and all I get is blank info when I run it in Creator. Here is a sample of the XML I'm attempting to parse: <Availability> <BookedStays property_id="1596-60334"> <BookedStay> <ArrivalDate>2014-01-17</ArrivalDate> <DepartureDate>2014-01-21</DepartureDate> </BookedStay> </BookedStays> </Availability> I
Can you change the Picklist value not to be the ID
I have written a system for a client that uses a number of Lookup Dropdowns (Picklists), the picklist displayed a description but the 'Value' stored was a different column from the source. This was done in the old version. They client has now asked me to add some more functionality and I cannot seem to be able to replicate what I did before as the Picklist will not allow me to choose what Value is stored, it always chooses ID. Two questions really 1. Do I now not have a choice and have to used ID's?
Call function from other app - unsolved
Hi Related to the recent problem (call function from other app): Unfortunately, it doesn't fix the problem - actually the problem is a bit different. The function(s) Works well in the report when this is opened in the "mother" app. But we have made another app and on a Page we embed the report using the script builder Embed Form/Report (the code: <div elName='zc-component' appLinkName='event-manager' sharedBy='jesper.johansen' viewLinkName='FreeApp_event_overview_2014' .....) And HERE the functions
Integrate zoho creator with joomla users
Hi, I'm completely new to Zoho Creator. My idea is to develop an application and integrate it with my Joomla website. I'd like users to log in and be able to keep their data in the server so that when they come back or login from another location the data is still there. I've done this before using PHP and JSON files for other projects. Basically, every time data changed, a JSON file was created in the server and reopened when the application started. I would like to know if zoho creator allows exporting
Call function from other other app - unsolved ver 2
Hi Again, We just testet Again. On the Freelancer App/Home (where we embed the report/view from Event Manager App) the functions are NOT working. Have tried with both IE, Chrome and Safari. Have also tried with different logins. This is pretty vital. If it doesn't Work we have to downgrade from Prof to Enterprise edition. Thanks
export the data definitions
We are trying to rationalize two databases into one. I would like to take my primary data entry form in Zoho Creator and export the data definitions including field type, length, drop down choices etc. Is there a quick and dirty way to do this?
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
Next Page