Creator Background Image
How can i change the background like this?
Ordering Sections in Android App
The Sections (Tabs) are ordered alphabetically in the Android App, while the Sections are ordered as defined in Settings -> Sections. Seems to me the Android App should also order Sections as defined. Can we either change the Android App to respect the defined order or have the option to go either way? Thanks, Joe
Sort rows in a subform with display numbers
Dear All, Lets say that I have a subform with two fields like Description and Display Number. I would like when I click submit to sort the list with the Display numbers which I gave. example The first will be Guide Excursion... The second Bus transfer...Land People The third Bus Transfer...Thessaloniki Each time when I give the display Number then to sort them. How can i do that?
Printing on View Record page not working properly
I have embedded a published report table on my website and created a template for "View Record." On the "View Record" page when I click the print button it redirects me to a zoho login page for my app. This is unacceptable for my workflow. Please let me know if there is something I can do.
Email Notification Multi-Step
I have a multiple step form, that requires email notifications at different steps in the process. How do I do this? Example: In my Human Resources Time Off Request form, the employee must first fill out a time off request. After the employee completes his section, the form should notify the employee's manager via email (with the record). The manager goes in and approves or rejects the request. The form should then notify the office manager via email (with the record), that a request for time
Dynamic Picklist
I was wondering what I have to do to my dynamic picklist so that if value "a" is present multiple times for it to only show in the pick list once script: Product = Add_Product [ID != input.ID]sort by product_type; select_product:ui.add(Product.product_type.getall());
adding form data via sms
is it yet possible to add form data via sms?
Populate Checklist with fields from different form
Not sure if this or possible but would make life so much easier. Form A has 100 different fields. 1 Field ( lead_type) will be a lookup field to form B Form B has just a few with one of them being a check box listing all the fields from form A. In form B we will check the fields we want to appear for the different lead types ( based upon the look up) Then show or hide them accordingly . Now can i do this as an array of some type or will i have to do code for each leadtype i add I want to be able
Please Wait problem came back
Previously working code is now hanging with the Please Wait screen that never goes away. I submitted the problem to Support but maybe someone has experienced the same issue. Some words of wisdom would be greatly appreciated. Thanks in advance, Henry
Picking up openurl parameters from the stateless form I have opened
Not sure if I have phrased that correctly so apologies if I have. I have a report for a Call Centre which list outstanding referrals to follow up. The referrals are entered via a comprehensive form previous to the Call Centre seeing them. The Call Centre Report only shows limited details of the referral (due to confidentiality) but they do need to update certain fields in the referral record. So I have create the report for the CC and a custom action which now successfully opens the correct record
Multiple reports. one big one sending information to smaller ones
When i import an xlsx table it only goes into the table im importing to. what i want to be able to da is import to the main report and from there the information is linked to smaller reports big report contains: Item nr Product Name Active ingredient ATC Code Formulation Strength Type of pack Pack size MA holder License (EMA or National) Country Price (Native currency) Price (Euro) where the smaller ones only contains one of each element for the lookup field option. and maybe the option
Trying to sign up for : Zoho Creator Developer Program
I tried signing up for the Zoho Creator Developer Program. I got an email instantly with a payment link . But the link does not work. Is the program still active?
Changing report window size in a pivot report
When I generate a pivot report in Zoho creator and then click on a value I get a new zoho reports window of a fixed size. Is it possible to make this window larger or smaller? Chris
Pivot Table Criteria?
Hello, How can I display a Pivot Table data based on the zoho.loginuserid? I know I can do that applying a criteria in a List report but I don't know how to do it in a pivot Table report. Thanks a lot!
Calculate field using data from parent form
Hi I have a parent form with a field called CostPrice. I have a subform with a field called RetailAdjust. I want to create a calculated field called RetailPrice. RetailPrice = (CostPrice + (-1 * RetailAdjust) I can't work out how to fetch the CostPrice. I probably have the rest of the equation right, bit some pointers would be great. Thanks Brendon
Currency defaults back to $ in pivot report
Hi, A Creator form has currency input fields that are set as EUR. When I create a pivot table with these fields, the data is displayed as $ instead of EUR. Is there a way to make sure that the pivot follows the formatting that is set in the form instead of jumping back to (what I assume is) the default value? The same applies to the formatting for aggregate formulas: these ignore the formatting for the fields in the formula and default to $ if you pick the currency datatype. How can I change this?
Application with sub-applications as sections
Is it possible to create a main application with sub-applications as sections? Like Zohomail. Which has a menu called Apps and it has mail, crm, creator, contacts etc as sections which are separately applications. I would like to create something like that for my company.
Zoho creator app management
I have certain apps shared to me in zoho creator. Currently there isn't any support to directly backup the coding from another persons app in zoho creator that has been shared with me. Why this would be helpful is because it would make it more seamless. For example, an owner of a business wants to delegate control of a project to a manager which includes creating, updating, and backing up any apps in current use under that managers scope. Another example of it making things more seamless is the fact
Special characters (#) causing problems
I am unable to pass a field variable with a # in it. I have tried turning it into "%23", but it does not help. Fields without special characters are working. Specifically, what I am referring to is Location=<%=post_location%>& Location_op=18 I can't get this to work if the "post_location" string has a # in it
display external web data in a form?
I'm new to Zoho Creator and it looks pretty awesome so far. I'm wondering if it's possible to make a call to an external web service and display the results within a form ("on edit" or "on view"). Similar to the twitter integration example I'd like to display something like that in the form "on edit" or "on view". If it's not possible to do that, is there a similar way to basically show a record in my database and include dynamic data from external services around it?
A unique problem involving unique records & date/time.
Hi, and thank you in advance for any help you may be able to lend. After many years of being overly-proud of my Excel expertise, I started taking the necessary plunge into relationship databases, So as a novice, I'd really appreciate any guidance. Here is my problem, that I'm seeking a solution to... I currently have a project where fifty people are going door-to-door daily to collect information from a targeted list of homeowners. I have a master target list (~11,000 homes) and a survey form for
Problems with Zoho Pages
Trying to embed a published page in my website and functionality does not work at all. Within the Zoho page we have embedded forms and report views. We made sure they were all published, but are getting a message saying "you are logged in as public@zohocreator.com" etc etc "you do not have permission to view this application."
Create a List
Hi, I would like to create a list List01 based on other fields values like when Sub01 is not null then List01 contains 1, then when Sub02 is not null then List01 will add another value 2 so Final list will be {1,2} . This is something looks like below if ( Sub01 != null) { List01 = {1}; } if ( Sub01 != null && Sub02 != null) { List01 = {1,2}; } then, If (Sub01 = null && Sub02 != null) { List01 = {2}; } Could anyone please help me how do I can create the above list ? Thanks Arfater
extra statement showing on html page "function doaction(recType) "
I have many reports that I want to open in a html page so the report name does not show in the browser address bar. I created a table of a report code such as ABC and the actual link name. When I call the html page I send it the report code and then lookup the linkname. This works as expected but at the bottom of the report I have function doaction(recType) { } $(document).ready(function() { doaction(); }); Here is the html page htmlpage Report_View(Report_Code) <%{ Report_Link_Record = Report_Names
Odd and Even Numbers
Is there a deluge fuction to detect Odd and Even numbers? Or maybe a function to know if a number have decimals, Best Regards,
intersection of Two lists
Hi, I have two lists such as List1 = {0.1,1,2,3,4,5,6,7,8,9,10,11,12} List2 = {0.1,2,4,6,7,10} What I would like to do is create a intersection of above two lists Final_list =( List1 - List2) = { 1 ,2 ,3 ,4 ,5 ,6 } - { 2, 4, 6} = { 1 ,3 ,5 } then input the first index of Final_list in the Channel_No field , that means input.Channel_No = 1; Please help me how to write the script to achieve it Thanks Arfater
how integrate google analitycs to creator's form?
hi how to integrate Google Analitycs to creator's form need to view how manager clicks fields in form
Change font
Hello, Is it possible to change the font of al whole Zoho Creator application? If yes, how can I do this? Hope to hear from someone soon. Greatings, Erwin Fennema
Use value of lookup field dropdown menu in a formula field
Hi there, I have a look up field on a form. I've tried to get the value of that lookup field into a formula field but it returns the entry ID such as: 1365899000000729278 I have previously used a code in deluge script to get the value by using this technique: Checkpoint[ID == input.Checkpoint].Checkpoint However, if I try to use this in a formula field i get an error stating: "Expression not supported in formula" Is there anyway I can get the value of a lookup field into a formula field? I need to
File field, empty or not
Hello, I need to writ a script that distinguishes between a file field being empty or not. This is needed to generate a page displaying or not the image contained in that file... The issue I am having is that non of these options seem to work: if (file_field=null) {script} if (file_field="") {script} in both cases, the result of the if statement is true even though there is no file contained in the field. would you please let me know how to make the if statement work fine and return false when there
Notification into one form
Hello, I'm building an application and have a question about it. I would like to script the following: Step 1: 1. An user can make a mention in Zoho Creator for his vehicle like: Mirror is broken. 2. An other user can make another mention in Zoho creator for the same vehicle like: headlight doesn't work. Step 2: The manager can check out these mentions and fill in another form for a supplier to fix it. Step 3: The manager fills in a form and selects the licenseplate of the vehicle and the supplier.
is it possible to make this app
so i need and app where i can import xlsx tables filled with new data every month and be able to create new data based on lookup fields except the Price (Euro) it is auto filled. What i have at the moment is all the lookup fields, the auto calculater, the hidden reports (not hidden atm), the single field to create new column lookups names to a hidden report which is fetched by the lookup field. Is this possible to make a Main report and combine all these hidden reports so that the main report updates
Can I open a Stateless form from a Report custom action
Hi I have a referral system that I am developing and the main referral form has been created ok. However part of the process for the referral is for there to be a follow up call via a call centre to arrange a telephone consult. So I have created a report which filters new referrals which only the call centre will be able to see. But I would like them to be able to click a 'view Referral' button next to each entry in the report and see a version of the main referral form with some of the confidential
Notification form when value
Hello everyone, I have a question. In a form I have a choice box. You can chose: 1. Yes 2. No When "Yes" is selected I would like to send a notification by e-mail with user submitted data included in PDF. If I make a on update function "send mail" I can't attach user submitted date included in PDF. When I go to the form settings notifications I can. Can I us the notification in form settings for this function? If yes, how can I? Hope to hear from you soon, this would really solve some problems for
Creation of HTML page Problems
Hello, 1) I have a problem. when I try to create an HTML page, screen becomes gray and nothing is clickable. I have to reload the page. 2) at link https://www.zoho.com/creator/help/views/create-html-page.html i read: "6. You can create your view based on a template by selecting the Choose Template button". where is this button? thanks a lot
Users can't download file uploads.
I am having troubles making it so a user who is in a group can download a file that has been uploaded. They can see the link inside of a view, they can click the link but they do not seem to have access to download the file. The user has the view and the form shared to them already. The file upload is inside of a subform on the main record. What is wrong? is there something else i need to do? I don't want files to be public, I want a logged in user to be able to download any file they can see in
Possible to set filter on multi-select lookup?
Hi, I have two lookup fields in one form: Lookup 1: Services Lookup 2: Activities When these are single-select lookups I can set the filter so that the menu of activities is dependent on the service selected. However, when these are multi-select lookups the same filter does not work. i.e. on activities lookup ((Service.ID == input.Services)) Is it possible to set filter to multi-select lookups so that all services selected display all activities related to those services? Thanks! Lindsay
Html Table Fix
Good day, could you please help me how do I align this columns to put one beside each other (no intermediate space), output = output + "<table class='tableSize' align='center'><tr><td style='width:60%;vertical-align: top;'>"; output = output + "<table border='1' cellspacing='0' align='center' style='border-color:#EEE;width:60%;margin:0px 0px 0px 0px;' id='billingAdd'>"; output = output + "<tr class='rowHead'><td>Nombre</td></tr>"; for each y in EquipoUtilizado { output = output + "<tr class='rowVal'><td>"
Zoho authentication API
Dear team, Do you have by any chance an API to authenticate through Zoho? I need to do a portal (and I cannot use for this purpose Zoho Creator) and I would like to have my users be able to authenticate through a Zoho account. We may use Zoho Creator to create the users but then front end will be in another technology. How could we proceed? Is this something already existing? Many thanks in advance for your input. Best regards, Christophe Mendez | MZ Consultants - Zoho Alliance Partner
Is it possible to upload files to Zohodocs from zoho creator using api
Hi Is it possible to upload files to Zohodocs from zohocreator using api I refer the zoho docs api below link, but its not clear https://www.zoho.com/docs/zoho-docs-api.html Please help me how upload files to zoho docs form zoho creator ,if any sample code please post it Thanks Satya NHM
Next Page