Scipt on Duplication
It would great if you could have "On Duplicate" as an option for form actions. The duplicate feature is great but there are some fields we would like cleared.
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 ?
Show list of potentials from CRM in Creator form
Hello, I'm very new to Zoho Creator. I am building some apps that I want to work alongside Zoho CRM. The first feature I need is to be able to select a relevant potential for an account that I have already selected in creator. So I have created a "Zoho CRM" field called Customer in my form. here I will choose the relevant customer. I then want a field (maybe a dropdown or similar) that lists the potentials relating to the customer I have chosen above. How on earth do I do this? Laurence
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
Error Occured while publishing
Hi! I am new here. When try to publish my site the very first time, I got"Ërror occurred while publishing" right away. It is registered under http://audioreplayph.zohosites.com/. Hoping for your guidance.
Cant Launch my Site
Hi i have completed my free domain and site and i am ready to launch to the web. Error message saying below what can i do please help ? Error occured while publishing Contact Support
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
My 2 cents
Spend more time/text describing how the "lookup" feature and process works. You sort of discuss this implementation but I feel you do not go into enough depth regarding it's use and when and when not to use bi-directional selection. Other developers coming from other backgrounds can run into trouble as they make "assumptions" about what is going on and how to "build the relationship", that will only "sort of work". In regards to designing a truly efficient [relational] database, the relationship
Zoho Developer Protections For Commercial App
Can someone direct me to a link describing details of the Zoho Creator Marketplace details. In particular, I'd like to find what is possible in terms of selling a Zoho application and what sort of protections are available that keep an application from being shared by my customers to other non-paying customers. Is this possible? How are developers protected from their work being copied and re-distributed under another app name? Other questions come to mind but I'm sure there must be some detailed
insert a warning message into a function
Hello, in a report, for each record I have a custom action that sends emails if the date in the record is equal to zoho.currentdate. It would be nice to enable the custom action only when the action can be done but I can not, so I need a message warning the user that the action is interrupted because the dates are not equal. How can I do? Thanks in advance. David
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?
Record Summary Template invoked via Custom Action
Hello I am trying to use a sendmail function in a custom action to send out a record summary as a PDF using a record summary template. This currently isn't possible, and we are forced to send out a pdf of the view, which is not very aesthetically pleasing. This functionality would really help out my company
Employees As Users - I'm confused about adding users.
Hi, I have a .Net background so I'm getting there (slowly) with Creator however I have got myself really confused with adding users. I am building an Employee Time Management app for a client and I want to be able to have multiple employee's that can see only their own information when they login (which I think I can do), however does that mean that each employee has to be added as a user? https://www.zoho.com/creator/help/overview.html#share There is no way the client is going to pay $10/user
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
import email field and send email
Hi, I have two forms - 1 for employee details & 2 for item allotment. Employee details contains - employee name and email Item allotment contains - item name and emp details (lookup used from employee details) I want to schedule an email to be sent from item allotment page to the emp whom am selecting from the dropdown. How I can do that please help. Thanks
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
Sort Options For Lookup Field Types
I'd like to also request an option to sort lookup fields by various typical means. For example. In my app loads are entered in order and the carriers LoadID always increments larger, along with the record level ID. When a user needs to add a child record, they must select a valid load. It would be nice if the "most recent" additions were at the top because these are the most likely to have additional child records added. (I'm also displaying other fields in the lookup that make record recognition
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.
embed form with logout
Hi, how do I insert a logout button on an embed list view?
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?
RSS
I am trying to get the RSS for my Zoho Creator application. I am confused about where I get the link from. I read this, but it really didn't help. "The RSS feed is automatically updated. Once you copy the link and submit it in a RSS feed reader you will be able to see the latest 25 records submitted. To see the entire records, add complete=true at end of the link. If your view is private, use the Enable Private Permalink option in the Export dialog, to get the private link. You will get a link in
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!
Duplicate Forms and Offer Custom Form Templates
As you may know, while it's easy to duplicate views, the same is not true for forms. The best to to duplicate a form is to view its "form definition with action", copy the code, create a new blank form, and then paste-in that code. This is a bit of a runaround but works. I tried to explain this to a client and they came away more confused. It would be nice to have an option to duplicate forms. The same client also asked if I could provide some custom from templates. Alas, this is not possible. It
Script for capitalisation not working
I've seen this script posted many times and is even found under the toUpperCase as an example. However, I can not get it to work. The field name I am using is named "Name_Business". Can anyone fill in the exact syntax for me to use the script below. Thank you. string getCapitalised(string txt) { if ((input.txt).length() > 0) { input.txt = (((input.txt).subString(0,1)).toUpperCase()) + (input.txt).subString(1,(input.txt).length()); } return input.txt; }
Custom schedule report date changes
I have created a few custom schedules to run yearly from a start date. I have found that when I refresh my completed and saved schedule, the start date has increased by a year. For example, if the original year selected was 2016, the year now displays 2017. Does anyone know any way to fix this?
How to fetch column name from view dynamically
Hello I need to fetch columns name from view dynamically in zoho creator by using deluge. Please tell me how can I do this?
Next Page