View Entire Record
When I choose view record I get just the fields that are in that current report. Is there a way to show all of the fields? Or define which fields to show?
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
Adding fields from two forms to an html page
Hi, I have a very simple html test page that works fine when only calling from one form, but I cannot figure out how to add field values from another related form to this table. Can I just modify the parameter "<%for each rec in testzoho" to include another form called testzoho2?? The page below works for the first two fields that are in my testzoho form, but I am trying to figure out how to add 'newfield1' and 'newfield2' that exist in a form called 'testzoho2' to the table. I know html and
Default image size in Email
I want to send an email with images from a URL box, and I want to define a size, example 141 x 141 What is the code that allows me to have a specific size? I have tried normal html codes but not funcionana or get error: http://mx.tuhistory.com/files/escapebacteria.jpg" width="141" alt="" />
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
Over 200 Fields
Hi and I hope you can help. I have mastered the basics of form building and basic deluge script writing. Actually I am quite pleased with myself for what I have achieved so far so thank you to Zoho for this fantastic bit of kit they have developed. Now this project is blowing my mind. I have a client who wants me to create a database that would be an ongoing development plan. Here is my problem. we need nearly 250 fields to make the project work. Now I know the maximum in 1 project as long as they
Feature Request - enhanced "Role" outline view
Under "Users and Permissoins", in the "Roles" outline, please consider adding under each role, a row for each User and their Profile. With many roles, a complex outline, and many users --this will be a BIG help in understanding the picture. Perhaps make it optional. (Currently we have to click each role to get a page that shows its users.) Thank you! CEO UserName - ProfileName UserName - ProfileName MANAGER
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?
Lookup value in script
I have a lookup form STATUSES: ID STATUS NOTES NAME 21677000001558756 301 SENT NOTE TO USER; WAITING FOR FEEDBACK TO TAKE NEXT ACTION ITEM. PENDING USER FEEDBACK This form is used as a lookup column in MAIN_FORM1. Whild creating a Deluge script in referring to the STATUSES form, using the STATUS lookup field: for each r in MAIN_FORM1 [STATUS == 301] { r.STATUS = 305; } In this case, shall I use for each r in MAIN_FORM1 [STATUS == 301] or for each r in MAIN_FORM1 [STATUS == 21677000001558756]
Automatically create PDF
Hi, I am trying to automatically generate a PDF of a Custom Record. Ive created a custom record to generate a pseudo Purchase order form. I can download the pdf manually but I am looking for automation in workflow. Basically, one will fill out the requisite form ive created (step 1). Once its filled out, it will automatically send emails to appropriate people to update the approval status. When this approval status is updated to "approved"(Step 2) . I want to automatically create a PDF of the Custom
How to create a Form with a variable number of fields?
I want to create a form where the number of fields can be specified by the user. For example, I want a form to ask how many children I have. After telling the form I have 3 children, the form should present three fields to collect their names. Is this possible?
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
Dropdown values
Dear Coleagues, I am new user of ZOHO (just started today). May you share ideas how to make such thing. I have 2 forms: Customers and Products. In the third form "Problem report" I need to enter Customer name from Customer form (I used lookup) and Product name (I use dropdown). Product name dropdown list should contain products names which choosed customer has. May you explain how to do that? Thank you! Evaldas
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!
Adding records using REST API gives error
When I make the following request I get error code 2899 response with the xml file. I have shared the application and have obtained a valid api key from the server. Any idea what the problem could be? <?xml version="1.0" encoding="UTF-8"?> <form method="POST" action="https://creator.zoho.com/api/xml/sensor-test/form/temp_and_time/record/add/"> <input type="hidden" name ="apikey" id="apikey" value="MY-API-KEY"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="humidity"
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
Wrapping in multiline
Hi I'm creating a form in zoho creator. I'm creating a multiline box that is shown only if a button is checked. I prepared a text that always has to be shown in the multiline box, like following: if ( input.test("yes") ) { show Info_test ; Info_test = "first line: ,second line" ; Now: how can I have a wrapping text in the multiline box ( Info_test),as this: first line: second line: ....: ....: Thanks
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?
Make the result of a subform were in the same form a
I would like to make the result of a subform were in the same form as the application : Order management . I have the following codes, and it works, but I can not transfer it to the form. row.Total=(row.Piezas * row.Precio); itemtotal=0.0; for each Sub_Total in Articulos { if(Sub_Total.Total != null) { itemtotal=(itemtotal + Sub_Total.Total); } } Total=itemtotal; ------------------------- for each Item in Articulos { input.Precio = (input.Precio + row.Total); } Thanks!
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.
Export File using Webhooks!!!
For a product which blows all the competition away in nearly every other area, when it comes to handling uploaded file's ZCreator is severely lacking. I've just lost my 2nd client in as many months because of the inability of ZCreator to export a file using an api. @ZohoCreatorSupport: Seeming as you managed to allow files to be transferred from Creator to Crm, is there a possibility that the same capabilities could be extended for external api's??? Damien Cregan Hire an Expert
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
Affilate program
Hello, Do you know how to organize and start affilate program in Zoho CRM? How can I do this in Zoho >>> https://www.youtube.com/watch?v=46lW5iLTI1U Thank you
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
Error in logo and footer
Hi, I published my website 2 days ago but the logo and the footer are not visible. Only code. I didn't change any code and simply used zoho's features to upload the logo and create a footer. I'm not any IT specialist so i would appreciate any help ... Thanks
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
Backup shared app(s)
I have certain apps shared to me in zoho creator. I would like to perform backups of the apps and try to export some of the data to a .CSV file, but unfortunately the backup app isn't available for apps shared to me. Any help would be appreciated.
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
Request call
Hello Zoho, I've tried to call you guys serveral times. Why don't you call back?
Next Page