how to calculate days in month
hi how can via function calculate numbers of days in month (current or future)? example - right now is may-2015, and there is 31 days in june-2015 there is 30 days how can i make automatically this type of calculations?
Dialog Helper function
Hello everyone, It's been a long time! Anyways, I'm working on a client application that uses a lot of view actions and dialogs. Just thought I would share a nice helper function to make building dialog's (using openUrl) with complex params much easier. void open.dialog(string resource, string resource_name, map params) { keys = input.params.keys(); str_params = "?zc_LoadIn=dialog"; for each k in keys{ str_params = (str_params + "&" + encodeUrl(k) + "=" + encodeUrl(params.get(k)) ); } url
Creating a function to populate another field
Hi, Working on a small inventory system here and running into bumps along the way. I am importing some 900 entries into this form and trying to populate a unique inventory number for each. The On Add > On Success or On Edit > On Success actions I've setup dont work for bulk edits or imports, so im thinking maybe its an idea to just have a button in the report that says 'Update Inventory Number' for those times that new records are imported which is hardly. But I dont want to go and manually update
How to add placeholder in a Zoho Creator field?
Dear All, I would like to ask you if there is any way to add a placeholder with a message in a field (lets say a multiline field) like the Zoho Invoice. I know that I can write a Tooltip Message but what about placeholders? Is there any hack way with CSS?
Create subform from a different app
Ex Code: Subform ( type=grid values=investigators.Investigator_Registry.ID ) This doesn't work at all now and it was working yesterday. Now everytime I try to add something to it, it says error null (I'm paraphrasing). Also if i try to change a subform value through free-flowing script mode it gives me a error null message again. Really though I want to be able to create a subform from Investigator registry app and implant it into PCRS Project tracking app. Also I'd appreciate a more
Drop down list values
Hello, I am trying to build up an Inventory Number creation script… or at least, a form where some of the values will generate an inventory number in a Function field. I have a drop down with 4 different values for an employee to put in… for example Part Structure Object Value Other I am calling this in the function field however I don't want the word to be generated in the Inventory Number. So if a user selects 'Structure', I would like to have the Function Field show a number instead of the actual
how to count entries with multiple variables?
hi! right now works the next code res = zayavki_form [sold_result.contains("0.1")]; count = res.sold_result.getall().size(); if (count > 0) { alert "Alert"; cancel submit; } this code works fine. it counts all entries from zayavki_form which contains "0.1" in sold_result. how can i count number of entries which in same time contains "0.1" in sold_result AND "zero" in field_A ?
Auto Increment Number based on other field values
I was curious if there was a way to Auto Increment Number based on the values of another field? For example, If Field 1 =A and Field 2 =B then increment by 1 based on the amount of entries containing 'A' and 'B'… So if I have 32 records where Field 1 =A and Field 2 =B, then the next record I add which has A and B will increment to 33 If i then make another record after that one, that has Field 1=J and Field 2=B, and I have no previous records that have those conditions, the auto number will display
Embeded public html views and error 400 (Bad Request)
Hi, i have embeded multiple html views in a website, with public sharing option. When i load the page, the first items are displaying correctly but others are not displayed, i get the zoho creator login page instead of the content i want to publish. Using Developer tools for chrome i can see the errors that are generated : 400 (Bad Request) Unsafe JavaScript attempt to initiate navigation for frame with URL The frame attempting navigation is neither same-origin with the target, nor is it the target's
Looking for Zoho Creator / Developer - remote work --- my client in Dallas, TX
Need 6+ years developer (.net or java or php) along with 2+ years Zoho Developer (Creator / API ) experience - certified Zoho developer or equiv experience. Zoho Code Review / Analysis -- enhancements ..... Contract Role - 3 months and could extend START June 1st 20-40 hrs per week -- flexible on hours jeff.kohnle@correlationpoint.com 214-450-4494
How to add attachments in Zoho Invoice mail using create zoho incoice function
Dear All, With the usage of create zoho invoice I can send an Invoice (as an email) to a user-client with a default text (which is editable through Zoho invoices.). Does anyone know (if there is any way) how can I add an attachment in zoho.invoice.createinvoice ? Because I would like to send an email with an attachment (which I uploaded it in a File upload button). I found this but I do not know how is working.
Cannot adjust manually the width of a radiobutton in a subform
Dear All, I created a form with 2-3 radio buttons. Then I used this form as a subform in another form.As we know in the new form the radiobuttons are shown as dropdowns. My question is, I am trying to adjust the radio buttons width (dropdowns in the subform) manually but they are not shown in the Configuration pop up. Why this happens? Is it a bug or is is something else? Is there any explanation for that?
Double digit number field
Hello, I was curious if there is a way to enforce double digits in the number field? For example, i inserted a Number Field with a starting value of 01, however when it displays the form, it just shows 1. Also if I call it in a formula it returns 1, and ignores the 0. I would like to force the display of the 0 because this is part of a formula I am trying to write to formulate an inventory number… Example JW 01 01 15
Email Dependant on Input
Hello, I am creating a form which will be embedded on my website, On the form we use a "Postcode" field which we expect our clients to input their postcode. Within this field we expect the postcode to begin with either BD or S. We want an email to be sent to a person based on the postcode entry. So any postcodes beginning BD would need to be sent to John Smith and any postcodes beginning S to be sent to Joe Bloggs. Is this possible?
Feature request: show list of CRM fields
Hiya, I'm creating a custom CRM contact modification form. It involves mapping fields from CRM to creator and vice versa. It's quite tedious to switch between tabs to get the field names. It would be great if I could have a field list from CRM as well as the field list from Creator so I could quickly copy/paste field names. cheers -- If you need any help with this or anything else related to Zoho, check out www.nuanced.it or email me at jeremy.nagel@nuanced.it
Mandatory format of a value in a field
Hello, I can't find the following functionallity. A single line field can be filled in like: 12AABB I would like ZoHo Creator automaticlly adjust the value in the field to: 12-AA-BB. Or is it possible to make the punctuations mandatory? Hope to hear from someone soon! Greatings, Erwin
Manipulating text string
Hi, I need a favor. Would yo give me a clue on how to remove the HTML remarks from this text string by using deluge script? I want to leave the red text only... Thanks a lot Luis <span style= 'font-style:italic;'><span style= 'font-style:italic;'><span font-style:italic;>Ideal para MDF, Acrílico, Papel y tela entre otros. Excelente calidad y detalle para su proyecto. Disponible tamaño de hoja completa 1.22 x 2.44m </span></span></span>
Passing parameters to a embedded website view
I have a view embedded in a website and want to filter based on certain input. I tried for hours the Zoho creator examples for passing url parameters and none didn't work. The form is asking me to login. <iframe height='500px' width='100%' name='Form:Copy_of_Reporte_de_Pedidos' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/jaflores/pedidos/#Form:Copy_of_Reporte_de_Pedidos/?NombreCtaHide='sedyco'></iframe>
Having trouble constraining reports to specific content
Hello, I'm having trouble running reports based on specific criteria in my application: Form (A) collects different Job Types (Help Desk, Services, Development, etc). Form (B) collects Employee Info including Name and Job Type (using a lookup to Form A) Form (C) assigns Office Equipment to different employees I need to run 2 reports on Form (C). The first is a pivot table, and the second is standard report. However, these reports must be limited to employees of just 1 Job Type. How
Integrate SalesIQ into Zoho Creator App
How can I add SalesIQ tracking to my Zoho Creator App? Oliver
Simple text formula field
I want to reference a field from a parent form in the child form. The parent has a lookup field to another form; and I want that field statically represented in the child form. In SFDC it's a simple Text=(Insert field) How is this done in Zoho? Thanks.
How to remove a starting newline?
How would I remove a starting newline from a string, if it exists? Since I created the newlines using "\n" I'm not sure exactly how to check for it and then to exclude it in the revised string. FYI I'm building a string by concatenating multiple values and starting each with a newline. Those with no value are skipped, but the end result can be a starting newline. The logic would be something like this, but I don't know the deluge syntax or best practice, I'd think it involves startsWith, Length,
Creating a Function to edit another record
Hi all, I have a request manager tool I am working on (and constantly improving) and within the tool I have a main table that captures all my requests and I have a second table that captures the asset and serial numbers of the device or devices for each individual request. The device details are captured int he main form as a subform. One of my reports concentrates on the asset details and the report is based on the device table, however what I want to be able to do is search for a specific asset
Can data in a report column be SHOWN for some records and HIDDEN for other records?
Is there a way to configure things so that on Reports, for most Profiles, for a certain field, let's say "Price", data can be shown in the column for some records and hidden in the column for other records? This would be based on another field in the record, say "Internal/External". So, for most users, for the "Price" column, on Reports: for records marked "External", users see the "Price" data for records marked "Internal", although the Price data exists, users see blank (the data is hidden). And,
Aggregate Excluding
Working in Creator on a Pivot Table. The table is an aggregate table of pricing for products across multiple vendors. Col 1; Average price, excluding our listed price. Col 2; Our price. Col 3; % difference between the two.
Validation using forumla field
Hello there Zoho community, I'm a bit stuck and wonder if someone can help me... I have a form with a formula field which generates a customer reference: Form name: Registration form Single line: Last name Date: Date of birth Formula: Customer reference ((((Date_of_birth.getMonth())) + Last_name) + (Date_of_birth.getDay())) + (Date_of_birth.getYear()) I'd like to set it so that if someone tries to fill in the form again (and therefore generates the same customer reference) an error message will show
Script for capitalisation
Hi, I am using the following script in functions in order to make the first letter of text uppercase and the rest of the text lowercase: 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; } Although it works when text is input in all lowercase, it does not work if text is input in all uppercase. Do I need to add a bit of script in order to do this? Thanks
How to access individual records of a sub-form in a report
Hi, My report is based on a form which has a sub-form. I am not able to access individual records of sub-form. I can not put any filter nor I can group on any field in the sub-form All sub-form fields are shown together in the report with whatever separator I use. Not able to show them in different columns. Also filters and grouping does not work on the sub-form columns as mentioned earlier. Please help. Milind
incremental search
is there any in built function for incremental search (find as you type). I have a form that has 1000's of names which I'd like to use in a dropdown but prefer not to use in dropdown.
Not able to populate picklist dynamically
Hi, I am new to Zoho creator. Pls. see the script below- proglist = Student_Program [ID != 0]; Program:ui.add(proglist.Program_Details.getall()); I am trying to populate a picklist (Program) in one form with field (Program_Details) from another form (Student_Program) without any filter. However when I run the application, I get ID in Program field and not the name i.e. Program_Details. What mistake I am making ? Pls. help. I have attached a screen shot when I run the application. Thanks, Milind
Report: List 3 last sales in each district. possible?
I have a list report, but want it to only list the 3 last sales (based on a date field) for each district. How can I make such a filter / any functionality for this?
Create relationship between two existing forms?
I have two forms(tables), both with imported data from different sources. Both forms are full with data. Form A Name (Single line) Descript 1 (Single line) Descript 2 (Single line) A_ID (Number) Form B Local (Single line) Descript 6 (Single line) Descript 72 (Single line) B_ID (Number) Now I want to create a relationship between the two forms. One-to-many (from Form A to Form B). Do not really want to add more fields to these tables - if I add a new lookup field to these tables now, I will have
Custom Action to Partly Duplicate a Record
A custom action in a report that partly duplicates a previously entered record and opens it in a new form that the previous record was created in, additionally populating a reference id field of the old records autonumber. I have created custom actions in other reports, its really the script to duplicate a previously entered (Into Form A) record (certain fields) and open Form A with some of a previous records data pre populated. Also a way to copy a autonumber field and populate a reference field
how to add print button to deluge script
I was told that I can't add a print button. Upon investigation I found that you can use a link to create a PDF. So I use: https://creatorexport.zoho.com/USERID/ordenes/print/Generate_Invoice/orderRecId=2769016000000090461 This works great with my user, but if I try this in another computer/user, the link is changed and it removes everything after ordernes/ rendering this solution useless. Any ideas? Leo
Functio to Update Zoho CRM Record from Zoho Creator
Hi, I am trying to create a function in ZC to update the respective Zoho CRM contact Record.But I am getting error and I can't figure out where is the problem in my code void CRM.CRM_Sync(ContactForm rcd) { for each rec in rcd sort by Added_Time desc range from 1 to 20 { srt = rec.Zoho_CRM_Contact_Name_ID.toString(); com = TV_Station[ID ==rec.crm_TV_Station ].Add_TVStation_Name.toString(); dat = TV_Station[ID == rec.crm_TV_Station]; net = Network[ID == dat.Add_primaryChannel].Network_Name.toString();
Stripe button in Zoho form
Hi, I wonder if the below script can be passed into one of the Zoho form or page? It is actually a post request to Stripe server and it returns in json format, including a token and also other data. Then I would like to use these data in zoho forms further. So, the code should be embed into Zoho because the "answer" from Stripe server will return to a page where the code was embed but adding "/charge" <form action="/charge" method="POST"> <script src="https://checkout.stripe.com/checkout.js"
Update records between apps
I'm having trouble trying to figure out how to update records between apps. My end goal is to have a form that will repopulate with information from a previous unfinished record so that you can finish it. There will be two apps. App1 has the original form and databse attached to it. App2 will have the form that will repopulate and allow customers to finish unfinished records. How do I update records in app1 from within app2? Also how do I comment out the code in deluge?
Request: Subroutines in deluge, and hide/show "all fields"
We have some large forms and use hide/show to present the right mix for various cases. As a feature enhancement, please consider: (1) Offer subroutines within the deluge script. This would allow sets of hide/show/enable/disable and any other form statements to be coded and maintained only once, yet re-used within the script. Such as: if checkbox_a = true { sub_hide_fieldset_1; sub_show_fieldset_5; sub_show_fieldset_6; other.... } We are aware of custom functions, but they
IF statement not working (dependent on checkbox field)
I am not sure why the 2nd IF statement is not working... The first one triggers an email to be sent, as well as the third one, but the second one does not. if((input.Type_of_Sign.toString() == "In-Store") && (input.Type_of_Sign.toString() != "Event/Trade Show")) { sendmail [ from:zoho.adminuserid to:zoho.adminuserid subject:"New signage request" message:"Signage request details:<br />\n<br />\nName: " + input.Name + "<br />\nDepartment: " + input.Department + "<br />\nDate: "
How to duplicate columns in creator in one go?
Hi folks, We have built a internal database wherein we wish to duplicate data in an existing column to another field/column. Is there any way to automate that?
Next Page