Custom action button in HTML view
Hi, I have a HTML page where I embedded a view .I want to show the custom action button on that HTML view but I can't figure it how to do that. Could any one please help me what parameter I should use ( style based url ) . below is the code I htmlpage TV_Station_Report1() displayname = "TV Station Report" content <%{%> <div elName='zc-component' viewLinkName='TV_Station_Database' params='zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true&zc_Summary=true&zc_RecPrint=false'>Loading
How do I add an ID to a subform longlist?
Hi, I have a query relating to subforms and how the data is stored and accessed. I have created two forms, A and B. Then I insert B as a subform into A. Now: 1) I add a record A1, with subform entries B1 and B2. The subform entries are stored as records in form B. 2) I add a record A2, with subform entries B3 and B4. They are also stored in form B. 3) When I view A1 or A2 the subform magically shows only those B records in the A record in which they were originally entered, i.e. B1 and B2 show up
Reports. Group by/ count. Show "out of stock if count(item)=0, "In stock" if count(item) > 0
Basically have a report showing something similart to this: ID Type 6524 A 8472 A 2145 B 3254 B 1254 B 2158 B 6528 B 1235 D Want to alter it so a get a report likt this: Type Count A In Stock B In Stock C Unavailable D In Stock Is this possible, anyone done something similar? If I use pivot table, I can get the following: Type Count A 2 B 5 D 1 But I do not want to show the actual count. Want just to show "In stock" (or "more than 2") Thanks.
Maximum Capacity check
Hi, I build a script that was supposed to check a field value on a related form (Maximum Capacity) and then compare it to the count of specific records. And show an alert if it was reached. See below if (input.Britcham_events != null) { Cpct = Britcham_events[ID == input.Britcham_events].Maximum_capacity; Trgt = Britcham_events[ID == input.Britcham_events].Target_nr_of_participants; cnt = Participants[((Status == "Attending" || Status == "Confirmed") && ID == input.Britcham_events)].count();
Accessing the identifier for getRecordById to work
In a workflow custom function I am looking to access the Contact ID from a CustomModule record. Here is what I have coded: ToDoCrm = zoho.crm.getRecordById("CustomModule4",input.ToDoId); controlid=ToDoCrm.get("35-Control"); client=ToDoCrm.get("35-Client"); contact_id=ToDoCrm.get("contactid"); This is where I start have problems contactinfo = zoho.crm.getRecordById("Contacts",contact_id.toLong()); This line fails email=contactinfo.get("Email"); account=contactinfo.get(("Account Name")); dos=contactinfo.get("Date
How to get users email id
I have configured Zoho signing with gmail. I have a 'Employees' form which has a users filed.I have the appearance of the field to display the email address of the uses. How do I get this user id field in other forms? I am trying to get the email address tied to the user in other forms. When I try to display Employee forms user_id, by default it displays the username and not the email id tied to that user. Thank you Anand.
Error Handling Best Practice
In a large and complex ZC app with functions often being called 2 or 3 levels down, is there a best practice for error handling? I think there are at least 3 requirements: 1) A status message - text to describe any warning or error condition [or indeed success]. Because the message may be produced 2 or 3 function calls down, it must percolate back up and be displayed properly to the user. 2) A status code - that can be tested to see if the function status is anything but 'Success' and may dictate
"Set Filter" works in it's own form but not when it is a subform.
I have a form called Accounts_Form which includes subforms created from existing forms: Add_Edit_Sites (bidirectional link to Accounts_Form) Add_Edit_Contacts (bidirectional link to Accounts_Form) Add_Edit_Contacts has a Lookup field called "Sites" which looks up site names from Add_Edit_Sites and has a "Set Filter" (see screencap) to filter out only sites with the same account name from the Accounts_Form. When adding a new contact from the Add_Edit_Contact and selecting an Account from the lookup
Version?
I am working with the user amaio1968@hotmial in the instance of leandro@addtarget.com and I can not see the types of fields: file upload Subform Autonumber Formula Signature Is this instance an old version of creator? Thank & regards
Creator Form usable on IMacs
Hi I've recently had a creator form created for our client brief. It works perfectly on a computer, tablet etc but when I try and look at it on my 21' imac its almost impossible to use. Can someone please give me a couple of suggestions.....
sendmail attachment
Hi It is posible to send pageas pdf as attachment in sendmail function?
Creator down again...
I assume you are aware that creator and other services are down again. That's two days in a row... Also the whole status.zoho.com thing is never correct im not sure the point of that site. Whole office sitting on their thumbs again... ETA?
Feature or Solution Request: A non-cubersome time field
Hello I created a simple time clock app for a client that allows them to enter and clock in and clock out and then auto calculate hours worked. Currently using the date/time field. I am getting so many complaints on the hard to use time entry (i.e. clicking and or dragging to get hours and minutes) Does anyone have a more elegant solution? Dear Zoho: Please consider fixing this, hardly usable in my opinion.
Creator and Amazon MWS?
Hi, I run an e-retail business and sell on Amazon.com and other marketplaces. Currently I run most of the business using Excel. I make updates to Amazon using CSV file imports from Excel, and also receive Amazon reports as CSV files. All my sales analysis, forecasting, P&L etc. is also done in Excel, driven by this data. As this involves a lot of repetitive manual work to import/export data, I'm considering moving to a database-driven system and am considering using Creator. I'd like to use the
Send Mail with a formated address Name <email@email.com>
I am not having success in formatting an email address in deluge, and have it sent using the Send Mail function I want to format as follows: John Smith <john@zoho.com> I can not seem to add the <> using deluge. is there another way of doing this ? In other words I want to personalize the address. is this possible ?
Using Fetch
I have 3 forms 'Add Employees' with user name and user initial, 'Add Property' with Property code and Managed By (this is a lookup of user initial) and lastly a 'Add Job' form which has some text fields, property code (lookup on Add Property.Property code) and Managed by text field. I am trying to auto populate the Managed by column with user initials when a Property code drop down values is selecte. Here is the code I have if (Add_Property[ID == input.Property_Code].count() > 0) { x = Add_Property
Cancel Submit Inside of If Else If Question - What happens?
What happened when Zoho encounters a "Cancel Submit" inside of If, else If validation logic? Does the code leave the If branch and abort the remainder of the code? I'm working on a stateless form and want to go through each field (about 8 fields) and insure the proper data is there, looking for nulls, duplicates, etc. I just want to be aware of the best way to abort the Submit at any point along the way, and NOT deal with the remainder of the checks down the code. EDIT: I now learn "Cancel Submit"
Multiple forms
We have several forms with one main form. We want to have the ability to show one of the other forms for data entry from the main form if they select certain criteria. I have not been able to get this to work
Subform not appearing in report, but is part of the form
I have a subform that is part of a main form. The subform appears on the main form and works. But when I open the report corresponding to the main form, there is no subform shown. What possible reasons could there be for the subform not to display on the report when it is visible in the main form? Sorry if this is a real basic question, but I am new at this. Thanks.
Recently check value in checkbox
Is there a way to get the most recently checked value in a multi select checkbox? I need to execute some code that depends on the most recently checked item in a multiselect checkbox. I have been trying to use list functions to figure this out. I seem to be having a problem where the order of the list is the same as the order of the check box field items. Another words as I check items off they always appear in the list in the same order as the check box field check box items are set up. I cant
Stateless forms, custom button, on click, not able to modify any form value
Hi, Using a custom button in a stateless form I am not being able to change the value of any field in the form through the "on click" script. Say for instance the script below. I am trying to clear the content of a pick list. The script does nothing at all. I have tried other type of fields like a simple line of text and still not able to make any change to it. If this is the case then what's the purpose of the custom button?? actions { Clear ( type = button
List functions, contains and distinct limitations?
Hello, I am trying to use contains() and distinct() and sort() functions but it seems there is a limitation in number of records these functions can handle? Look at this script for example, this is an iteration of distinct() function after I found it wasn't working: Note V.Categorias field is a text field with items separated by commas. Application link (in case you want to look at the actual code) Categorias_Lista = List(); for each V in Vectores { V.Categorias=V.Categorias.toUpperCase(); C=
Filter based on multi select field
Hi there I have the following 4 Forms System Access - User ID, User Email (both set by system), First Name, Last Name (input by user) Membership - First Name, Last Name, Licence (input by user, can be different to System Access) and a Lookup field to System Access form with multi select enabled. Nomination - Logged in User (set by system) Entry - Sub Form of Nomination, fields are Licence (choice field), First Name (text), Last Name (text) The end result I am trying to work out is that on the Nomination/Entry
MultiTenant subscriptions?
Is there any way that I could create an own-branded Creator app and then sell subscriptions to use it to multiple companies each of which might have 1-50 users? Could each company's data be stored, accessed and billed entirely separately? I get the impression that Creator is not really designed for this type of thing.
Pull a Zoho CRM contacts information into a Creator form .
I have added a Zoho CRM "look up" field into my form. The form currently pulls the contacts name. Is there a way to pull the email and contact phone number simultaneously into the form automatically from the same contact record?
Appending a apply now link to every record listing in a report
I have created a custom Job Database. I am displaying the results in a report form. I would like to append an apply now link (that takes you to the application) to every row. This way someone reviewing the jobs an applicant can click and go to the application. Any ideas how?
Another Android Issue? Subform With Calculated Expression.
I am finding that Android will not save parent form edits if a subform [on the parent form] contains a calculated expression (even if subform is hidden and disabled). If I delete the calculated expression in the subform, I can save edits to the parent form data. In my case I am using an if statement to display a character in place of true or false in a decision field found in the child form.
Noob Question: How to Use ResponseText
Hi All, I'm not a programmer, but can usually follow other examples to accomplish what I want. I'm having trouble understanding how to use data being returned from Google Distance Matrix API. I have 3 inputs: From_Address To_Address Distance Once someone puts information in the To_Address, I want to return the miles in the Distance input. I've set up getURL to Google Distance Matrix API and have a successful response back. I see that the data is stored in map.get("responseText"). Here is the complete
Smartphone/Tablet Options For Developers?
I've been playing around with Zoho Creator for a week now. I like it for the most part, as it has great potential to easily build multi-platform data-centric apps, easily and quickly. However I am finding a few setbacks here and there, and another is the presentation differences between iOS and Android tablets. It seems some "bar labels" aren't being handled correctly and it's difficult to know exactly what you're doing and where you are at. For instance, on Android tablet, when I view a report
Zoho Creator On Android
Hello, I was trying to get though to your support for the last 6 days, no one has responded. Since the last upgrade, my android users are having issues with numerous text fields while doing data entry. It seems like as the users type in some of the fields, the cursor resets back to the begging to the field. This literally causes text to be typed BACKWARDS into the fields. So if I type in MIKE, it turns out to be EKIM.... I cannot figure out why this is only happening to some of the fields. I
Can I call a custom function in the on user input of a field?
Dear All, Lets say that I have a dropdown (input.Dropdown) with 2 choices (Text A, Text B). I also have a single line 'Description'. I would like when I choose Text A then to fill the phrase 'Text A' in the single line. I know that I can do it in the on user input like this if (input.Dropdown = "Text A"} { input.Description = Dropdown; } etc. My question is if I can do it with custom function. Can I write custom functions and call them in the on user input? I know how to call functions in
Filtering Reports
Good day, Im filtering a report using Functionality based URLs , in my report I have a origin and a destination, its possible to use OR functionality? For example I want the report to show me the records if the origin is = "blue" OR the destination = "blue", Best Regards,
Is it possible to Convert or Delete a CRM lead from Creator?
I want to be able ton convert a CRM lead from creator, is this possible? If there is no direct way to do this I assume I would need to do the following: Create new customer record Create new Potential Delete CRM Lead I know how to do everything except delete CRM Lead. So basically i need to know how to either convert a CRM lead from creator or how to delete a CRM lead from creator. Please any help would be appreciated. Thanks Matt
How to pass lookup field value to another form.
Hello How can I pass lookup field value from form1 to form2? -Form1 and Form2 both has lookup field to form0. -Report of Form1 has custom action button which "openurl" of Form2. -When Form2 is called from Form1 custom action, I want to pass Form1's Form0 ID to Form2 as a default value. I tried like "openUrl("https://...#Form:form2" + "?form0=" + form1.form0, "Same window");" but form2's lookup field to form0 is null. How can i pass lookup field value in openurl method? Thanks Tadashi
Context Sensitive Menus
Is there any way to disable/enable Custom Actions in header and/or edit record menus? There are many situations where a particular action is inappropriate and it would be helpful to be able to disable it. If this isn't already possible nor in the development wish list then please add it.
Copying field for rows within subform
1) I have a string field called group names that I want to pull the same value from the previous row? Formula?
Null value handling in Subform
First, please accept my apologies for my poor English. The followings codes work perfectly for my main/sub form setup. Until when some records are carrying no subform records. I google for the solution for almost 2 days now. But I still have no glue. for each row in input.Shipping_Quantity { x = (x + row.Shipping_Qty_Packs); input.Total_Shipped_Qty = x; } Thanks!
Customer Portal Users Status
Hello, Kindly, Just a suggestion to add the Status (Active /Inactive) for Customer Portal Users Like Zoho "Users & Permission page" : Thanks, Omar Khamam
Narrow Column Report - Down - Over - Down. Possible With Creator Report Template?
Is it possible to take a very simple single field data set, create a report (template) and have the records go down the left section, then over and down the center section, and so forth? And perhaps put the report groupings in the columns, as well? Asking for too much? I've been spoiled on Microsoft Access the last 15 years, so please understand. Just trying to create a very compact "grocery store list" of checked items and don't want to use the entire page width to use 1/4 page width of text.
Add Application Name Variable in Report Template?
I can not figure out how to add a custom field that displays a system variable. Such as " = zoho.appname" to a template. I have a custom template (invoice type) that I'd like for the application name/version to appear. Is this possible?
Next Page