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......:(
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?
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
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
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
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.
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
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
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
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?
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?
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
User Id without the email.
Hi, I have one application that has a user with id without the email.com in it. e.g. "name1" Now I added another user but it is not able to log in without adding the whole email. e.g. It doesn't work with "name2" It asks for "name2@gmail.com" as the user id.
Paydates
I have a new form as Paydates. I also have a main form called Timesheets. In the Timesheets form is a field with a calendar. I am looking to try to get this field to show next pay date automatically based on a bi weekly pay schedule. ex: 01.01.2014 Next paydate 01.15.2014 Have it auto populate based on current date Maybe something like zohodate == input.paydate
Getting Full Page Data Added Successfully Message
One of my forms gets a full page "Data Added Successfully" message. The normal little pop-up message displays briefly and then my data form is replaced by a display that is nothing but the words "Data Added Successfully!". What is it and how do I stop it? My data form is a standard data form with nothing in the "go to URL".
How to show Calendar View depending on User Type
Hi All, Is it possible to filter the Calendar View via script? Users in the application I'm building belong to various company sites in different physical locations. I'm trying to find a way of displaying the Calendar View, filtered by the user's location, without the user manually selecting this filter. In addition, it is important that Site A cannot access Site B's calendar. Currently all the Tasks go into one Calendar View. I don't think it is an option to create additional Calendar Views for
Call function from other app
Hi, I have a simple function defined in order to debug why our functions do not work.. void Testfunction() { openUrl("http://www.url.com", "Same window"); } This is called in an app report as custom action and works well. In an other app we show the report in a page, but then the function does not work and just spins forever?
Next Page