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
Syntax highlighting bug - parentheses
Until a few weeks ago the syntax highlighting feature was working for each set of opening and closing parentheses. I.e. "( ... )", "{ ... }" or "[ ... ]" for closed parentheses and "{" for an opening parenthesis that has not been closed. However, a platform update broke this feature. Can you please reinstate it ASAP as it makes it hard to spot where missing parentheses should be added.
How to disable the export and print features in a VIEW based on the user right ?
Please advise. Thx, Jason
unable to save script in edit view / free-flow script mode
The "updating script" message is displayed but the script is never saved. This applies even if no changes are made to the script. The same applies to all views in my app.
URGENT ... CANT ADD NEW DATA *PLEASE HELP*
Hello, When i start any form and fill it and click on submit this message comes up. "Invalid entries found. Please correct and submit again." and when i go to Error Details i find nothing. Please help. View Error Details Error details: Error occured while on Success script. We are working on giving more meaningful error messages on script failures
Displaying Data on a Form
I have data imported from a spreadsheet that I would like to display at the top of a form. It is to be referenced prior to the person filling out the form. Is there a way for me to import data into the form and then have them add the content and save the form with the data being added to that record??? Example: We are doing a round of phone calls. I would like the caller to be able to reference the person's name and information before making the call. Then when they make the call they will be able
Multiple Select field very slow/not responsive
I have a form that has 2 multiple select fields, one for COUNTRY and the other for POSTCODE/STATE. The POSTCODE/STATE is dependant on the COUNTRY field. When I select the COUNTRY option that contains a lot of data, the POSTCODE/STATE field takes too long to populate. I end up closing it after waiting for several minutes with no response. Can you please resolve? One workaround I have found was to fill in the form with an incorrect COUNTRY and POSTCODE/STATE before selecting the correct COUNTRY and
How to create a Single Line Field with only one acceptable answer (as alternate to picture verification code)?
Greetings, We have had some of our customers complain about how it is very difficult to read the verification code from Zoho, and that it doesn't work on Apple Safari web-browser (both Windows and Mac versions). As an alternative to the verification code, I would like to implement a Single Line Field that is presented in the form of a question with only one acceptable answer; for example, "What is the ZIP code of Company Co.?" with an answer of "123456", or "What phone number should you dial for
Thumbnail without changing proportions
Hi, is there a way to create a thumbnail from an uploaded image in a way that proportions are allways kept as the original picture? following the help topics there is a way to create thumbnails but in these instructions one defines the dimensions of the thumbnail where the original image proportions can be distorted. Rgds Luis
How to direct to a specific page after completing a form.
We are using this as a form to fill out on our site. The form is here: http://fcpresearch.com/JoinOurNationalDatabase.php We would like to redirect to this page when someone submits the form but I cannot find where to make that the setting. http://fcpresearch.com/thank-you.php I changed the URL on the links and images page, but it didn't do what I need. Any help would be soooo appreciated!
Multiple select removing values not displayed correctly
Hi, I have a form with a multiple select list. When I view the form, I can easily add and remove values. See below. However, the customer cannot see the red "X" when they view the form. See below We are both using Chrome. Do you know why there are inconsistencies with the way it is displayed?
Fetching exchange rates on the fly
Hi, Is it possible to get the latest currency exchange rates using Paypal Currency Conversion API from Zoho creator to keep the Exchange rates up to date? Best regards, Nitin
Update a multi-select field via function
Hey, I'm trying to have a value selected in a multiselect lookup field via a function - I'm stuck on getting the 'fetched record' updated because The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Anyone have any idea how to get around this? The help documentation and other forum posts related to this error message are pretty opaque. FYI - All of the values available in the first form's dropdown field are the same as the mulitselect
Forms - import forms from an old account
I started a few weeks ago in Zoho and I originally set up a number of forms. Our business looks to be changing name as so I need to get the form onto the new account, as I cannot use the user name. This is because when we link the forms, they have our old business name, and for legal reasons it looks like I need to change this. So I have registered a new account, but I need to import somehow the forms from the old account. I also need to transfer the plan. Can anyone help me??? Thank you
'If..else if' conditions
I'm stuck on the 'if...else if' condition. Let's say that i have a list of sectors and different lists of subsectors, each one exclusively reffered to one of the sectors from the first list. Let's say that i have a table of all the clients that i'm working for. I'd like, for each client, to specify the sector they belong to: here it's easy with the dropdown menu for example. Then, i'd like that, once i choose one sector, in the subsector column only the proper subsectors list will appear.
Next Page