Splitting date and time help
Hi, In my form there are 3 fields I need help with, Field A. date and time field Field B. Date field Field C. Time field What I want is when Field A is filled Field B is filled with the date part of Field A and Field C is filled with the time part of field A. So Field A = 28-Mar-2013 09:00:00 Field B = 28-Mar-2013 Field C = 09:00:00 Can anyone help please Nigel
Dynamically expanding Checkboxes
Hey guys Im not sure if this is even possible but I though Id throw it out there. So I want to have a list of Checkboxes that are based on data from another table/view. this would be say for instance a list of Vendors that a member of staff can belong to, but if another vendor becomes part of the portfolio then the list would be updated and they can be selected, at the moment im doing something similar with a Multi Select field but it just seems messy to me... checkboxes would be sweet! any suggestions
Best way to launch a Stateless Form from a View
I want to display a set of records in a view and have a custom button on each row that will allow the user to choose the record, then open (in the same or new window haven't decided yet) a stateless form for that record. I will have it display the entire record, but also expose about 5 buttons that will do more complex stateless database functions and send emails, etc based on the button push related to that one record in the stateless form. I have not seen any particular info on this in the Deluge
Upgraded security framework
Care to elaborate? Thanks, John
exporting the PDF of an html view
Hi, Is it possible to: 1. Export a pdf of a html view to the system ( rather than downloading it ) and 2. Attach it to an email Thanks, Guy
Image reducing in view list.
I would like to have the images in a list reduced and I found this formula but I couldn't get it to work. There wasn't any descriptions on what to change so I am not sure I making the correct changes in the formula. Is there an easier way to change the image size? Please Help. (((((Image_1).replaceAll("border","height='200px' widht='200px' border")).replaceAll("sharedBy","zohologinuserid")).replaceAll("appLinkName",("image-workaround"))).replaceAll("viewLinkName","image_View")).replaceAll("fieldName","Image_1")
Populating drop down box selections
im creating a surgical case log. I want to create a procedure entry drop down box. I have an excel spreadshett with the 100 or so different operations I do. Is there a more efficient way to get this set up than manual entry as I'm afraid this will not be feasible from a time standpoint. Thanks for any suggestions
Apply filter and view result in a different view
Hi guys, my question is: can I made some search (or apply some filter) in a specific view (A) and view the results in another view (B). For example I have a form with this fields: first_name last_name adress city zipcode sex I need to search my friends for "sex" and I need to have a result view showing only last_name, adress and city. Is it possible ? Many thanks Vittorio
Another minor bug? unable to update script
When saving a Deluge Script that has certain syntactical errors the system says "Updating Script...." and will sit forever in this state. The script will never be updated and no error will ever appear. The only way to resolve the issue is to refresh the screen and enter the script again. Because there is no error reporting you have to find the error on your own. Of course this is less than ideal and could make life difficult for coders new to Deluge syntax. I believe this error is fairly new and
Need basic help with drop down or multi-selection
Let me start by saying I have zero experience here but I am a learning as I go. I have a small issue I am sure one of you can help with. In simple terms I want to ask customers how they prefer to be contacted. The options are Mail, Email, SMS, and Do Not Contact Me. I want to have a box appear for Email if they chose email as a preferred contact method and then also have box appear for Cell phone if they chose SMS as a preferred contact method. The address is required and we collect it earlier on
On edit script issue
Hi there, I'm recently getting an error that has not happened before. When I edit an existing entry and try to add a new Subform row, I get something along the lines of: " Error in executing On Add Row script of XXXX. Error. Error in executing Set Variable task. Unable to update variable XXX. Error evaluating NUMERIC expression: ... " Adding new entries does not produce this error. I suspect this might have to do with a recent update since
Edit Mode changes the view
So using Deluge script I was able to hide parts of a form but when I got to edit mode the entire form shows up is there a way to make the script work even when juist viewing it in edit mode?
Email Log
If you exceed your daily email quota of 500 emails per day the balance of emails are logged. Is it possible to access the log to see the initial 500 emails?
Google Calendar API
I am trying to learn how to use the Google Calendar API to add an event created by Zoho Creator form to a Google Calendar. I have a main calendar set up in Google with subcalendars. I would like to be able to add an event to the specific Google sub-calendar when the form is submitted in Creator. I am currently using the Creator Calendar Feeds which work great, but I am not happy with the lag (calendar is not updated immediately). I have seen this post: https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
Pagination Code
Hello friends, Today, I am sharing a pagination snippet with you. ( http://www.webnersolutions.com/ ) ============================================================================= Function name : calculateTotalPageNumber ----------------------------------------------------------------------------------------------------------------------------------------------- list calculateTotalPageNumber(int total_record, int display_per_record) { if (input.total_record <= input.display_per_record)
[HELP] Post data with php CURL
Currently I am trying to post data with cURL and PHP to populate my custom built app. However I can't seem to get anything to work. I can easily post data the same way to the CRM but not to the creator. This is my code: public function serializeModelling($object) { // Set the curl address $this->curlAddress = 'https://creator.zoho.com/api/xml/write?'; $this->scope = 'creatorapi'; $this->token = '***'; $this->extraParameters = ''; $xmlData = '<?xml
My Zoho attempt
Hello Zoho community, I'm new to Zoho, but certainly not new programming. Unfortunately, I have a hard time figuring out how Zoho could be used for creating any kind of application given the limitations I have seen so far in the level of flexibility of how views and forms can be mixed and the fact formulas don't update themselves as they should when lookup fields are involved, thus creating a large need for (OnInput) code, which is a far cry from the promise of drag and drop design, and requires
Successfully display 1 to 10 number without using for ,while , do while loop .
Hello frnds , I am a newbie in zoho creator.yesterday was my tough time in office when i saw we cant use for,while,do while looping statement then how to display 1 to 10 or more number in successor. My friend Nitin ,who works in webners ( http://www.webnersolutions.com/ ) help me in this.I am sharing a code of snippet with all of you. Function Name : makePageNumberList ------------------------------------------------------------------------------------------------------------------------------------------------------------------
'Merging' the records of two forms for display
Hi, I wish to combine the selected records of two forms: BalanceSheet, Invoices where they have similar fields: Date, Description, Amount I am then displaying a list of the combined results in a html view called Books. What is the best method to 'merge' and sort these records for display or is this the wrong approach? Thank you, Guy
Minor bug? unable to change certain field types on stateless form
Creator is not allowing a certain field type change on stateless forms. When trying to change a field from a Numeric to Decimal type in a stateless form the system allows the user to select the Numeric field for changes. As in the past, the system then allows the user to open the drop-down associated with the selected field and also allows the user to choose the new field type from the drop-down list. In this case, once the Decimal field type is selected the user can navigate away from the field
Deluge Script - Atomic test & set operation with concurrent users
Hello, I have an application which will be used by several users simultaneously. Each user can edit the same data e.g. same record may be removed, updated, etc. Is there some method to address the problem (i.e. race-condition)? Are there any atomic methods that provide "test&set" funcionality?
Feeding a date to a Custom Action function
From a view I need to modify several records at a time based on a date. I want the user to check the records in the view and then call a custom action that asks for the date and then performs an action on each of the checked records. I am feeding the checked records to the function as a form object. What is the best method of getting the date for the function? Herb Wexler
Access workspace apps via mobile?
Hi, is it possible to access workspace apps via the javascript enabled Mobile site (https://mobile.zoho.com/creator/)? I can only access my personal and shared apps but not workspace apps. I can access them via creator.zoho.com/mobile, but apparently this version is limited. cheers, Jeremy
creating a 'wizard' in Creator
Greetings I would like to create a wizard that allows my users to complete a series of forms to complete one 'profile'. Putting all of the data needed into one form would be clumsy and very large so I would like to give my users a page 1 then page 2 then page 3 etc. environment... something that they can save and finish later. A common profile would be like an application for a university or complete employee application with history of education and jobs or a form to gather up all information connected
Showing subforms using the client API?
Hi, I'm trying to use the Zoho Creator client API to show an internationalised version of my form. It works allright for text inputs, but when I try to add a subform, it doesn't show anything. Here's the code I'm using: <span id="first-name-label"><script type="text/javascript">Zoho.writeLabel("Language_Competency");</script></span> <script type="text/javascript">Zoho.writeInput("Language_Competency");</script> </fieldset> Coming from this form (edit access provided to support). Any tips? cheers,
XLS attachment in Report Schedules
How do I attach .xls attachments of my views in the report schedule? Currently the data is in PDF format, which isn't helpful. Thanks, Sudeepta
Downgraded to Personal Free Edition?
Hi support, Why was account sigroup downgraded to the personal free plan? Thanks, John M. Whitney aka buzzap and sigroup
Zoho Not Being Updated From Paypal
I have an application in which users are registering for events (a bicycle club). Starting March 7th, we have had multiple instances of people successfully paying for their registrations in Paypal, but Zoho never seeing the completion data from Paypal. As a result, we don't have a record that the transaction is paid. It's happened in about 20% of the transactions. There's no pattern that we can see as to the type of registration, the event, or the type of Paypal payment. All transactions run
When a Fields' Choices are Updated - Will the Deluge Change Automatically?
When a Fields' Choices are Updated - Will the Deluge Change Automatically? For example, I have a radio button list of 5 choices: Favorite Fruit: - Apple - Banana - Television - Kiwi - Persimmon Now in my deluge script I have: if (Favorite == "Television") { do something; } My question is, if I update "Television" when editing the field to "Orange", will the deluge script automatically change to: if (Favorite == "Orange") { do something; } Now, my specific situation is a LOT more complex. As I have
Multiple Forms with a single table
I have a single table which contains all my data but I want to use 2 or 3 different Forms to populate it. The trouble is as soon as I set up a new Form it effectively sets up a new Table. I want to be able to enter Fields like Name and Address in all the Forms but then add in specific data in just one of the forms. For example, I would like to enter a customers Name Address and Contact info in all the Forms but some forms may require additional information such as Delivery Info and another form Collection
What are the built in features in Creator to create a Calendar view like this?
Is there a way to create color coded events? Is there a way to append a check box for which events to display?
Change bidirectional field display type?
I have a bidirectional field that is currently a dropdown (single select) field, but I need to change this to a multiple select field. Unfortunately, Zoho does not let me create another bidirectional field or delete this one without losing data. Is there anyway around this?
Formula field not updated in Child form (Subform)
Hi, I have a Parent form (myParentForm) with the subform : myChildForm. In myChildForm I have a Formula field using the Lookup field related to myParentForm (this formula is to display a directlink to myParentForm record : href="http://....../" + input.<LookupField_to_myParentField> When I add rows in the subform, Formula field in myChildForm is not recalculated : href above stays with http://....../null instead of http://....../0123456. Can you make those formula fields update ? I know some workarround
Google Calendar API
I am trying to learn how to use the Google Calendar API to add an event created by Zoho Creator form to a Google Calendar. I have a main calendar set up in Google with subcalendars. I would like to be able to add an event to the specific Google sub-calendar when the form is submitted in Creator. I am currently using the Creator Calendar Feeds which work great, but I am not happy with the lag (calendar is not updated immediately). I have seen this post: https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
Could not find Insert Html
Hello zoho-users, I search a lot but could not find Insert Html. Please help me..
Decision Box Help
We were attempting to make a decision box that only showed the word "true" when it was checked and showed nothing (aka NULL) when the decision box was not checked. Right now, it says "false" when the decision box is not checked, and we do not want it to say that anymore. Is that possible? Thanks, Nicole
Embed Zoho Calendar with week filter in a Zoho Creator html view
Hello. I'm making a view. This html view has multiple views embedded. The basic filter of the view are a range of dates (a week). I know how can I embed a Zoho Calendar and how to put it in week view, but, how can i select the week to display? Is this possible? Regards.
Add buid-in function that returns file size or length something like <file>.length() returns long [FR]
Hi, This option will allow better usage management and permit other services integration as amazon 3s. Did anyone work it out somehow differently? Regards,
Replicate "Edit" dropdown
Hi, I have a global search feature which I copied from the CRM sample application. I process and display the results using a html view. In my results, I wanted to copy the "Edit" button you see under the Views so I used the code below <tr class="zc-viewrow zc-row-1" cls="zc-row-1" reclinkid="<%=c.ID%>" elname="zc-viewrowEl" receditallowed="true" recdeleteallowed="true" receditlink="/essistmgmt/assets/CUSTOMERS/record-edit/CUSTOMERS_View/<%=c.ID%>/" recprintlink="/essistmgmt/assets/record-print/CUSTOMERS_View/<%=c.ID%>/"
Dynamically Re-generate a Pivot Chart
I have a pivot chart that I would like to call through a "Custom Action" button that calls a function containing the OpenUrl. My question is, since data in the reports (i.e., Pivot tables, Pivot charts) are not automatically updated, how do I dynamically Re-generate the chart to refresh the new data through the script and without pressing on the little "gear" and clicking re-generate?? Thank you for your help
Next Page