Restricting Calendar View to Working Hours
Hi: I'm trying to implement a calendar which displays all of my customer appointments. Currently, the calendar shows all 24 hours of the day. Is there a way to restrict the hours to simply the times my business is open? Thanks!
Rich Text/WYSIWYG Input Area
I'd like to have an option on ZoHo creator to create an input text area for HTML/rich text formatting. :)
Automate data upload process like reports
I'll start with the end in mind. I want to basically keep certain creator tables updated with data that are in a sql database/tables in our office (employees, active jobs, employee positions) so I can reference that data and not have to duplicate it by hand every time someone adds a new job or employee in the office desktop software. Here are some thoughts I had about how to do this, but am unsure as to whether any of them are actually possible and how to go about it from there: Is there any way
Here's how to set a numeric field to null or to blank
I'm not sure this tip is discussed anywhere, so I thought I'd share it. When a form has a numeric field, it initially is blank (assuming you have not given it a default value). However at runtime, once you give it a value, you are not able to clear the field again.with a script unless you click the reset button or reload the form. Unfortunately, that will clear all the fields in the form, not just the one field. Although you can compare the value of a numeric field to null, you cannot assign a
Royalty/Sum Calculation app based on uploaded statements.
Good afternoon. I'm relatively new to Creator but have adopted the software for my new business currently setting up. I plan work in music publishing and have the following question. Is it possible to build an App in creator where i can upload a royalty statement from a record label (as a .CSV or Excel File), align the columns and then calculate % splits and report out the new statements? Something similar to this - https://label-engine.com/record_label_accounting.php
Automating Backup
I have moved my business' blood and soul to Zoho Creator. Is there a way to automate backup so it happens every day without any action from me? Thanks much. S
Add time on the x axis of the page's graph
Hello, I use Creator 5, and I would like to be able to insert the time's fields on the x axis of the graphs on the pages. Actually I see only other field's type (number, text, ecc.). Thanks Best regards
Is it possible to use the Column sum value in script
Hi, I wonder if it is possible to use the sum value of a view's column to say fire off an email when this value exceeds a certain number. I can't see how this can be done at the moment because the variable doesn't seemed to be defined anywhere. If this is indeed not possible at the moment, is my only option to add a forumla to the form which will calculate the running total of the value of the the formula field in each form? Is this method documented in the Help wiki or the forum - can't find anything!
How can I export the entire app so I have a backup in case?
I am sure I have come across this in the interface but maybe getting confused with some other aspect of the app. Could you tell me how to make a backup 'export' of the app in case I need to upload a copy in case of disaster or just to make a point in time copy in case I break my application?
Customer Portal
Hi, Customer portal is great and we use for our external application. Unfortunately the application is used by users who I require to have different permissions. I know you do not support this currently as you state that all users must have the same permissions. It is limiting. I'd really like to be able to use the share unshare deluge command to control access using the users zoho,loginuserid, primarlily on sections ie I don't want certain sections shown to users and a combination of sections to
New Built in String function(string.matches(<regular expression>))
We have introduced new string function matches for testing if the string matches a given regular expression. This function will be useful validating a given string for particular format. For ex, following code snippet can be used to validate a phone number string for the formats - (123)456-7890, 123-456-7890, 1234567890, (123)-456-789, (123) 456 7890, 123.456.7890, (123).456 7890 phone = "(123) 456 7890"; if(phone.matches("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$") == false) { info "Please
Horizontal arrangement of the radio buttons
Hello, In trying to create a survey that is a single page w/o scrolling, I would like to have the radio buttons (numbered 1-10) horizontally arranged rather than vertical. Is this possible? 1 2 3 4 5 6 7 8 9 10 o o o o o o o o o o I have only half a dozen questions but the survey is 70 mines long and doesn't seem like it needs to be. Thanks for any assistance any viewer of this post can provide. Cheers
Add a record and immediately get its id?
Hello, I am building a stateless form that allows the user to enter a Contact and a Payment for that contact, each of which is its own form. I create a Contact record first, then need to get the ID of the newly created record to use in the Payment record. I could always do a find using enough fields from the input that I can be confident I will always get the record I just created, e.g. name, address1, address2, email. However this seems a bit kludgy, and I'm used to working with APIs that automatically
Encoding a string in a HTTP Post
Hi, I'm trying to use the Google API for adding placemarks on maps. The HTTP body needs to have the following: <atom:entry xmlns='http://www.opengis.net/kml/2.2' xmlns:atom='http://www.w3.org/2005/Atom'> <atom:title type='text'>Faulkner's Birthplace</atom:title> <atom:content type='application/vnd.google-earth.kml+xml'> <Placemark> <name>Faulkner's Birthplace</name> <description/> <Point> <coordinates>-89.520753,34.360902,0.0</coordinates> </Point>
Refer Fields box should show the current form
Hey Zoho, it bugs me slightly that the Refer Fields box shows the most 'alphabetically superior' form rather than the current form. Could you change this? (See screenshot below)
Creating an event in Google Calendar
Hi, I have listed below the deluge code snippet for creating an event to GoogleCalendar. The script uses the PostUrl function to send header parameters and write XML Data in the request body. Function for generating authoization header string getGoogleAuthToken(string email, string passwd, string GoogleService) { accountType = "HOSTED_OR_GOOGLE"; url = "https://www.google.com/accounts/ClientLogin?accountType=" + accountType + "&Email=" + email + "&Passwd=" + passwd + "&service=" + input.GoogleService;
Creating CRM Task from Creator application
For certain requirements, there may be a need for creating a ZohoCRM task from your Creator applications. This post is about using a Creator form to create a CRM Task. Below is a simple To Do form which creates a CRM Task for each record added. In the above form Client is a CRM Field that refers a Contact Module. Refer this post for including CRM modules in Creator form Below is the code snippet that should be written in the on-Success action of the form to create a CRM Task taskinfo = {
new calendar view - suggested improvements
Please consider making the following improvements to the new calendar view: Colour code events based on a field value. (In our case we need to colour code appointments based on which practitioner is linked with each appointment record.) Increase the amount of text displayed for the description (display value field). This could be done by a mouseover pop-up and/or text wrapping where there is sufficient vertical space. Restrict the display of time-slots to user-specified business hours in the weekly
Improve View Record Format
Take a look at this page https://creator.zoho.com/buzzap/ncsd/#View:Public_Post_Archive Then select to view a record. There are a number of issues with how the view looks Some of the records scroll horizontally off the page The column headers take up a huge amount of space: the view should scale to minimize the free space The printable view has the same problemsThanks, John Whitney
I made function for money number convert to Chinese words
Hi I'm exciting made the function for money number convert to Chinese words. I want to say ZC it's powerful so let me share the code and get your further help for optimize the code more.. string sz.num2rmb(float je) { vzf = {"0-零", "1-壹", "2-贰", "3-叁", "4-肆", "5-伍", "6-陆", "7-柒", "8-捌", "9-玖"}; vws = "万仟佰拾亿仟佰拾万仟佰拾元角分"; rdw = formqj [cat == "小写大写"]; vje = ((input.je * 100).round(0)).toString(); vcd = (vje).length(); vwszf = (vws).subString((15 - vcd));
Provide EDIT option for CRM integrated tasks in Deluge script builder
Hi, As of now, all CRM related tasks in ZC apps are performed by manually typing the code eg: <CRM Response> = zoho.crm.create(<CRM Module Name>, <Field values as map value>) <variable>= zoho.crm.searchRecords("<moduleName >", "<criteria>", fromIndex, toIndex); These are working just fine.. However, we dont see a EDIT option, for these lines of code in scripting mode. Not all are code-savy. Having this in script mode will make things easier for not-so-code-friendly-people as well What does the rest
Short circuit boolean evaluation
Good evening... I was wondering how creator handles boolean evaluations, does it use "short-circuit" evaluation? What I mean is if I have the following statement: if (a || b) { ... } Then if a is true it will NOT evaluate b and execute the if block (a or b could require counting records that meet certain criteria or other complex operations). Similarly, if I have: if (a && b) { ... } The if a is false it will not evaluate b and skip the if block. Thanks,
Allow more space for form name in edit mode
When in edit mode for a form the form name appears above the code. However only the first 15 characters of the name are shown. Can this be increased or the full name show when the mouse is over the name. Herb Wexler
Testing Scheduler?
Is there a button to test the scheduler? In other words once I've created the schedule is there a way to cause the event to trigger without waiting for the clock to roll around to the time of the event? Herb Wexler
Add a "Run Now" option to the scheduler.
Since the only way to write a custom script to be performed on the database and process it on demand is by creating a custom schedule. A "Run Now" option would be a simple and nice feature instead of entering a time in half hour increments. This way once the save button is pressed the script would run immediately. This would be helpful when there are thousands of records that need bulk edits made instead of using the bulk edit feature and only being able to update 200 records at a time.
Quotes updates in CRM
Hi, I want to update a quote in CRM from my Zoho Creator. I use that code : updated_itemsList = List:Map(); sl_no = 1; for each sales_prodsList in Synchronized_Sales_Products [(Quote_ID_of_CRM == cur_Quote_ID_of_crm && Use_for_Insert == false)] { updated_itemsList.add({ "no" : sl_no, "Product Id" : sales_prodsList.Product_Id_of_CRM, "Product Name" : sales_prodsList.Product_Name, "Quantity" : sales_prodsList.Quantity, "List Price" : sales_prodsList.List_Price, "Discount" : sales_prodsList.Discount
Update existing records using "Import Data" option
My app references records that change daily. A raw report can be generated to show these changes, but I can't import these reports into my app and update the older records with the changes. To be able to do this would be HUGE. If there were a work around (perhaps using the OnChange script) please let me know.
Add Paypal payment option in form.
Hello Respected members Please add a PAYPAL PAYMENT field for forms in zoho creator. by this PAYPAL payment is also allow as a required field. Thanks REGARDS NP
I want to a PAYPAL Payment option in ZC.
Respected Members, After review all things i feel that if ZC adds a Paypal Payment Option in Form, then this is very attractive, i review many customers record and then i will give this fact: 89% peoples want to Paypal payment Option. Please proposed this idea to your Developers or Administration Is there is any problem to implement this feature? Thanks for Reading
Zoho Creator should be implement these fields
Hello zoho Administration My list of requirement is too long but i am only described here mostly required: 1. A Password Field see below example: Password 2. A address field : see below example Address * Street Address Street Address Line 2 City State / Province Postal / Zip Code Please Select United States Abkhazia
How to Insert paypal html code in zoho and get llink?
Hello! I had a paypal and money bookers integration html code ,and i need it to use in zoho and get a permanent link which can be accessed by my users. So can you tell me ,How can i do this?and which Zoho can do this? Please explain me with clear ,as im basic html known person!!!
Function for returning date after adding x number of business days (no sat, sun)
I have a customer that wanted to let a user schedule 4 BUSINESS DAYS out. I couldn't find a saner way to do this so here's my function. date helper.bizDays(int days) { iterator = helper.iterator(); time = zoho.currentdate; for each n in iterator { if (input.days > 0) { time = time.addDay(1); if (time.getDayOfWeek() == 7) { time = time.addDay(2); } else if (time.getDayOfWeek() == 1)
Creating Apache ESME messages using a Zoho Creator application
We have created a Zoho Creator application that creates Apache ESME messages. The application includes a very rudimentary UI to create the message. Note: Please remember that currently, the information entered in the form is also be stored in the internal application database so that anyone can see the tokens that are being used. It would be pretty easy to add a small routine to the script to delete the data after it has been sent to Apache ESME. The code to create the Apache ESME message is very
Free flow scripting
Is there a way to set the editor to free flow scripting by default or a url parameter to always open up in free flow scripting? tt
Clickable links to parent records
it would be great to be able to have the field in a view that is a lookup field to be a clickable link to a view of the parent record that it points to. It would be great to provide this as an option in the views. I found it a very helpful feature in webex office.
Bulk Update - is it possible?
Hi, I want to add some new fields to an existing form and then update these fields for all existing records from a spreadsheet. Is it possible to do this type of Bulk Update somehow? Thanks, Lee
IMPORT and REPLACE
Hi. I think that Zoho Creator is a big step for all in building Great apllications. Bravo ! I would like to use it as a lead repository for my sales people and partners. (Channel Management) I would love to have the possibility to have an IMPORT and REPLACE functionnality This feature will help us 1/ "Export Data" in a spreadsheet, 2/ Mass change and Mass update these existing data, 3/ re-import my data and have them REPLACE the whole "old" record (perhaps we can do this if we provide the Record
zoho.crm.update() OR zoho.crm.updateRecord() or zoho.crm.updateRecords() - is this wrapper for the API call updateRecords coming soon?
Hi, Obviously zoho.crm.create() works well...but there doesn't appear to be a function zoho.crm.updateRecord() OR zoho.crm.updateRecord() or zoho.crm.updateRecords(), which would also be really convenient. Is there any sign of this update wrapper function being created? I can use the API (XML-RPC) stuff...but the wrapper is so much easier. Hope there's some good news coming on this front? Regards, Liam.
Global Variables
Re-posted idea from http://help.zoho.com/portal/en/community/topic/stateless-fields-and-push-buttons-in-a-database-form There is value in having a programmatically accessible global variable list. It would be similar to our global functions in that global variables can be used anywhere in an application (similar to zoho-defined variables). Here we could define our own variable names, types (numeric, date, string, etc), and optionally add default values that could be referenced in any code or form
Conditional Formula
Hi, This is a great application. I love it! Is it possible to make Formula values conditional on the value of other fields? eg NewField ( type = formula if ($OldField == "Old") { value = "New" } else { value = "Old" } ) Thanks, Lee.
Next Page