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?
Trouble adding a user to share app
I am using the free version and have added a user to share the app. I have shared and sent an invitation. The user has not received the invitation to login. Is this feature not available with the free subscription?
Added User == zoho.loginuser
When i try to add criteria to the report Added User == zoho.loginuser After that I don't see any date of the view I want to give my customers a report based on data they has already entered and will enter but this method don't work And another problem, zoho.appuri returns my workspace name zoho_ill1 (with 1 of the end and zoho_ prefix) but link of application is https://creator.zoho.com/userhome/zoho_ill/dashboard Why ? And how to change this workspace name? And how i can use roles in Customer portal
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?
A way to log in as customer on customer portal?
Is there any plans or would you consider creating a method for the admin to log in to customer portal as a customer? This is a continuous unknow and area of extreme concern for our organization. It is very scary not really knowing for sure what some of our customers see when they log into our customer portal. We would like to be able to log in as a customer to see. Currently we need to either ask for their password (not a good method) or we need to create fake email addresses for them and manage
Set Null Users Field
Good day, I have a function to create records with deluge insert into, inside the form I have a Users field (Customers), the problem is when the Record is created this field fills automatically with the loginuser info, even setting in the insert into instructions to set this field as null. What should be happening?
Find records for value in Multi Select lookup
Hi There We have a form (Case_Details) which has a Multi Select lookup to another form (Client) On saving a new Case_Details form we want to find any other cases that relate to any of the selected Clients on this new case. I have the following deluge script and the line highlighted bold is not valid for some reason clients = Client[ID in input.Client_Names]; email_body=""; for each c in clients { //find any other cases which are for the selected client matches = (Case_Details[Client_Names.contains(c.ID)
Order Management - Services Purchased and Sold
Good afternoon, Can Order Management application be customised to include purchases and sales of services as opposed to products? If it doesn't cater for services then it won't be Fit for purpose. I'm new to Zoho and am not sure if existing applications in Creator can be customised or if I will be better off to start off from scratch.
Bug: Insert into deluge script doesn't work on Mobile.
Hi, Insert into deluge script doesn't work on a standard form via the Zoho Creator Mobile App. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Standard_Form Please advise. Regards
Duplicate Allowed and Successful - When It Should Not
In testing my application, I have found that ... I have a form with a field that does not allow duplicates (LoadID) and is mandatory. However if I go to the record and select duplicate, the process will succeed and I will have a record with a missing LoadID, as well as the corresponding child records. Why is this? I can think of a handful of potential clients that may find the duplicate feature useful, but as it is, I will have to explain to all that "duplicate" can have unwanted results until such
Reload Dashboard from Iframe
Good day, I have a Dashborad and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("DashboardUrl", "parent window"); When I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window. There is any alternative to reload the main window Dashboard?
Iframe Record Edit OperUrl
Good day, I have a Page and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("MyUrl"parent window"); My problem is that when I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window, there is any alternative to do that?
URL field Link name as variable
I have a URL field that is set to link to google maps. When the address fields (Street_Number, Street_Name, Suburb) in my form are filled out, the URL link is generated based on the address details (as in the yellow highlight part below). That aspect of my URL field is working well. input.Address = "<a target='_blank' href='https://www.google.com/maps/place/" + input.Street_Number + "+" + input.Street_Name + "+" + input.Suburb + "/'>Address</a>"; I need help with the Link Name part highlighted in
using distinct function
I have a blank multiselect field called 'WO subtotals ' (WO short for Work Orders) I have subform Containing a WO Group field and an Est. Hours Field and a Create New Group Field in each row starting with a value of 1 in the 1st row in the WO Group field each new row will be also be 1 until I select 'Yes" in the Create New Group field of a given row, then that row along with all succeeding rows becomes 2 until I press it again, then it become 3 and so on I want the sum of Est. Hours for each
Next Page