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?
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.
Image field and File Upload field in stateless forms
Image field only takes image links in stateless form and we cannot create a file upload field in the stateless form.
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
Error Executing Workflow On User Input script
so i get this message when trying to convert from native price to euro in lookup to single field - Error Executing Workflow On User Input script Price (Euro). - Error occurred while executing the workflow. please contact support@zohocreator.com failing code: euprice = Price_Native_currency1 [ID == input.Price_Native_currency]; if (euprice != null) { EuValue = (euprice.Price_Native_currency.toLong() * 0.10836).round(1); input.Price_Euro = EuValue.toString(); } And if im not doing "if" then
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
Link auto number across forms
I want to use a lookup field to link two forms. One the first form I have an auto number field, as well as a single text field. I would like to use the text field as a lookup to another form, and to have the auto number auto populate on the second form in order to maintain data integrity. How would I get the auto number field to auto populate? Thanks
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>"
How to insert a chart in XPATH?
I need to add a Xpath code that be displayed as in the chart below where varibles replace values. Whether this is not possible, I would like to create graphics as it is in HTML or any format that supports Zoho to use variables such as values, and was told that was impossible, or use different forms within the same graph. <?xml version="1.0" encoding="UTF-8"?> <chart> <title>Población</title> <subtitle>Fuente: INE (2004)</subtitle> <name_value1>hab</name_value1> <type>bars</type> <header_height>80</header_height>
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
I Can't access my Zoho Recruit information to populate in Zoho Creator
Dear Support, Please could you verify what is wrong at my script? I'm following the instrutions on help but I can't have success. I include some alert to debug, but the end doesn't show anything for resp. I include some printscreen to help you to understand the sequence that I'm doing. Thanks. Paulo Miguel. script: moduleName = "Candidates"; condition = "(email|=|" + input.Email + ")"; fromIndex = 1; toIndex = 20; resp = zoho.recruit.searchRecords(moduleName, condition, fromIndex, toIndex);
How do I duplicate entries more than once?
Hi. I am trying to put together a raffle which gives the user the option to purchase more than one 'ticket'. What I would like to do is multiply the data entry based on the amount of tickets purchased e.g. if the user purchases 3 tickets, the form would automatically create another two entries. If anyone could help me with a way of doing this, it would be much appreciated. Thanks
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
How can access zoho pepole employee form from Creator
Hi We are bulding an application wich needs info from our employes, this info we have into ZOHO PEPOLE ¿how can acces the info in zohp pepole form zoho creator?
Next Page