.toLong() not working
I have a user defined function that calls .toLong() built in function I have added it to one line and it works fine. I tried adding it to another line of code but I get the following error. Is anyone else experiencing this issue? How can I overcome it? Not able to find 'toLong' function
Subform picklist problem
I mailed support about his problem a few days ago, but have had no response other than "we will respond soon". So I thought I'd try my luck here. I was running the script below on the On Edit > On Load action of a parent form to populate dynamic picklists on a subform with the data that was saved previously. This has been working fine until a few days ago. When I made a change to a different line in the script totally unrelated to this code I got an error message saying "variable record not defined"
Button on a form to run a script?
I have a series of data input fields, visible calculated fields and fields that show as set variable results. I want the script to run after the user has completed inputting the data and this is of course easy to do as an 'on user input' on the last field. However in many instances the user will see the results and wish to recalculate after modifying one of the input fields. I need something like a RECALCULATE button at the bottom of the page. Any ideas?
Label colour: change background or text?
It would be useful to be able to differentiate fields on a form by colour, either the text or the background. For example I have visible calculated fields and financial summary fields where this would be handy. Any ideas? Right now all that I can think of is running a red line in a notes field.
Make a form field mandatory based on response in another form field
For reference, see my Creator form at http://www.jaxareagolf.org/index.php/meeting-notice%E2%80%8E. In the Attendance Options, if a user chooses "Meeting, lunch, and golf", I want it to be mandatory that the user also put a response in 'Tee choice:' and 'Handicap INDEX'. I am not quite sure how to go about doing that. I would appreciate any help. Barney
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3 I have 3 forms Patriot_Time_Entry Client_Rate_Table Work_Type I am working in the Patriot Time Entry form When I select a Work TypeLookup that matches a Company Name in the Client Rate Table, I want to populate fields in the Patriot Time Entry Form.
Alternate to subforms
Let me start by saying I'm frustrated and losing faith in Zoho. Zoho pitches their service as easy to use and mobile compatible....but they neglect to make it clear that certain features do not work well on mobile devices. And the new Android Creator app does not handle subforms with image uploads. So I invested a lot of time and money creating and app that allows us to create work order tickets for our field service tech. Everything we do is documented by photos. It can be 5 photos or 20 depending
Another window type for openUrl
Hello! Can you add a new window type in openUrl function? Type "New Tab". "New window" is not easy to tabbed browsers. Thank you, Ulia
I can't get a condition for a Report to work
I have a report that lists all companies grouped by territory. I want to open that report restricted to companies in the territory in which the current user resides. The user's territory is PersonForm[Email_fld==zoho.loginuserid].Territory_fld In the report definition I want to say show all rows from CompanyForm[Territory_fld == this user's territory] But if I code it thus show all rows from CompanyForm[Territory_fld == PersonForm[Email_fld==zoho.loginuserid].Territory_fld] the
Is there a field limit?
I searched but could not find the answer. I have a zoho creator application that needs over a hundred fields on a single form. I get 99 added, but when I drag the 100th field onto the form, I just get a spinning "adding". Have I reached a limit?
Need unique case ID field
If I use the auto number field, it is hidden and the user cannot see the field to use that as a case id. Due to confidentiality requirements, using the victim name is not an option. I am assuming I will have to use a single text with no duplicate entries. But, this means the users will have to generate their own case ids. Is there a better way to insure compliance and consistency? I would really like to keep my current method, ##-####-#### first two digits, member program service provider id
Creating a composite report
Hi everyone, I need to produce a composite report for my database. The database contains student information. The first table contains the "front page" information, consisting: Name, DOB, Class, Residential House. Then there are other tables all with a lookup selection box in each pointing to Name+DOB from this front page. These tables contain: Home Information Family Contact Information Emergency Medical Information Daily Requirements etc etc I need to produce a final report using the majority
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
Next Page