Questions to integrate paypal with zoho.
1. Do I need to setup the paypal developer before I could integrate with zoho? 2. I followed the instructions in https://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form How can I configure the submit button so that it will linked to paypal website to make payment? 3. Can anyone please provide a step to step guide so that i could follow? THANK YOU!!!
Error Assigning Null to a Date Field in a Subform
Hi, I have a working script. It works great! The problem is now I want to edit it and I cannot. I can't even save the script without making any changes. I receive the following error message: Expecting TIMESTAMP expression found NULLTYPE expression Below is the code the generates the error: //Alert if the Move Out Date is not after the Move In Date if (row.Move_Out_Date < row.Move_In_Date) { alert("The Move Out Date cannot be before the Move In Date."); row.Move_In_Date = null; } I
Trimming field values
How can I make a form automatically trim the leading and trailing spaces of a text-string? I wanted to do this to avoid duplicate entries. Thanks.
Creator down
Hi, We're currently looking into service interruption issues with Zoho Creator. We'll keep you posted about the status. Sorry about that! Regards, Mani
API Edit Multiline via XML RPC
I'm trying to edit a multi-line field via the XML-RPC API. When I ADD a record, the format is: <field Name='myfield> <value> the value which can be multiline </value> </field> However, in the EDIT spec, I have to format it like this: <field name = 'myfield' value='some value'></field> This format, where the value is a parameter of the field node, and not a separate node, doesn't seem to support multi-line. Any suggestions on how to work around this problem?
Excel / Creator integration
Wondering if it is possible to create an excel page that takes the data directly from Creator? or any other suggestions to this question... I want to print ID cards from the database collected through Creator. The data is already in Creator but I need it to access it live, print a single small id card customized to a certain look with graphics etc. Thanks in advance.
Bug in Usage Limit and Buying Addons
We're on the Professional plan, which gives us 20,000 records. Today we received an error staying that we've reached our limit, and the dashboard indicated that we'd already exceeded our limit by 1,194 records. So we bought an addon for 5,000 records, but now for some reason our dashboard says that our quota is 40,000 (instead of 25,000) and that we have still exceeded our limit by 1,194 records. In other words, there appear to be 2 bugs: 1. We bought 5,000 additional records, but the dashboard indicates
Can I upload accdb files to Zoho ?
I´ve managed to upload an Access .mdb file to Zoho, but it failed for .accdb. I got the following error message: Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error. Can anyone help me with this ? Thanks in advance.
Allow Administrative Users to remove their own Delete and Bulk Edit privileges
BACKGROUND: The system does not currently allow Administrative Users to limit their own ability to Delete or Bulk Edit selected records. This means that operating an app while logged in as Administrator risks unintended deletions or bulk changes. The only current way to work around that is to create a second Zoho identity and share the app with oneself with the attendant extra work of sharing and setting up quasi-delete procedures using check boxes and filters. SUGGESTION: Apply the current system
Updating fields from other application
Hi, Is it possible to update a field from other application using Deluge Script? I used a form from my application A as a look up to my application B. I want to update a decision box from application A using Deluge Script in application B.
Post and Get MAP variable across ZCreator stateless forms?
https://creator.zoho.com/compname/myapp/form-perma/Stateless_Form_2?a={%22ln%22:%22cccccc%22,%22fn%22:%22aaaa%22} I am using OPEN URL to post my MAP to form2. What is the way to get the MAP variable on form2 from query string. URGENT PLEASE!!! Also what is the best way to transfer form data across multiple forms in ZCreator.
Is there any way to use JQurey in future?
Dear Team, Can you please provide an official JQurey in future ? so that users can use it in Html page, to achieve a lot of very dazzling effects.
Error using User Function - even with Script Builder
Having written a function (to convert Decimal to Hex), I wanted to use it in my script. Either using Free-Flow or Script Builder (and have tried it in both old & new versions)....I get an error just trying to add the function....
Cannot Locate Duplicated App
Using the new-ish interface I have duplicated one of my applications so as to maintain an unadulterated version should I need one after coding forward. The interface provides a yellow tag that claims the app is being duplicated ("Duplicating . . . "), but I never see the duplicated app. Where the heck is it?
How do you I download the deluge script in the New builder?
Thanks. -Varun.
I'm probably just being a clueless newbie, but...
I keep getting repeated choices on my checkboxes and multi-selects. A choice will appear several times in a row when using the form, but only once while editing it, so I can't delete the duplicates. Even if I move the affected choice, the duplicates remain. They disappear if I delete the choice and re-enter it, but that's extremely irritating and time-consuming. There must be an easier way to deal with this. Is there?
Sub Form to show records related to parent form.
I have a parent company form and I need a sub form of employees to show the employees that work for that company. Can anyone please help?
Reference a field name using a string
I want to retrieve data from the nth field (i.e. column) in a record (i.e. row). Can I retrieve data from a field by referencing it using the string equivalent of a number i.e. "Record.column" where "column" is a string variable containing "1", "2" or "3" etc.?
[IMPORTANT] Notes field not refreshing.
Hi, When I update the contents of a notes field (on say 'submit' action), the updated content won't render on the display. The case for worry is that the same feature works on another account but not the one where I want it to. Attached is a Form Definition if anyone feels kind enough to try and report the behavior in their account. Many thanks, Varun.
How to create a custom sort key
I'd like to be able to sort data in a view by a custom key (i.e., not by a standard alphabetical, numerical, or date sort). I'm a pastor, and have an application that I have developed to keep track of my preaching schedule. It has the following forms (among others): Sermon Series (each entry is a separate sermon series) Field: ID (autonumber integer) Field: Series Name (string) Field: Description (rich text) Sermons (each entry is a distinct sermon) Field: Sermon Date (date) Field: Sermon Series
IP address Issue
Sir/Madam, I created a form in Zoho Creator and made one netry. Subsequent to that, when i tried keying in one more enttry, i got the message which said " ONLY ONE RECORD PER IP IS ALLOWED". Please help me in solving this issue. Regards, Mukund Ramasubramanian Praxis Business School Kolkata
Bug or change in Filter setup with the new App Builder
Hi all, I have found an article on dynamic lookup list: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup However, when I try this with the latest app builder, I click on the Set Filter box and it pops up with proper fields and such. But when I type in the condition like CONTEXT_CODE equals input.Country_Lookup, when it saves, it keeps saving as CONTEXT_CODE == "input.Country_Lookup" and treat my variable name as literal constant. In my case,
Easy way to define variables over forms
I have a few variables that are defined under inputs, however, these variables are not defined over the entire form. Although it is possible using another input field, I really don't want to have multiple disabled inputs for no reason. I want to define a variable over the entire form. Is this possible? I tried the defining global variable help, but I don't think that solves my issue. My script is basically: a = productDet.get("Reimbursement"); which is inside for/if loops under a specific user input
Zoho Creator accoun has been blocked
Hi I am trying to sign up to Zoho Creator but havent been able to log in even thoug I am currently usinz Zoho reports, can you help me please.
Lookup Drop Down Field
I want to use a lookup field to relate two tables in Creator. Does the function change to a search and select if the number of rows in the related table exceed 200. Otherwise a drop down will not work. If there is a max number for a plain dropdown record count is that number a configuration somewhere.??
Set Column width in new application builder
I have switched to the New Application Builder and want to set column widths for a view. The problem is that there is no option to set the column width. If I want to, I have to temporarily switch back to the old builder or edit the Definition. Can you please include an option to set column width in the New Builder?
Bulk update: missing columns
I want to bulk upload the SITE view at https://creator.zoho.com/essistmgmt/assets/#View:SITES_View I am missing the CONNECTWISE REF column from the dropdown to update. Can you please investigate? Note, The application has shared access.
How to load a form in edit mode?
Hi I'm looking information about how to load a form in edit mode. I found this forum post https://help.zoho.com/portal/en/community/topic/load-form-in-edit-mode#2266000004613049 Sadly the resources linked there doesn't exists anymore. Can anyone explain me or redirect me to a resource where explain how to do this on the current Zoho Creator? Thanks,
Application integration
we are interested in using several of the Zoho applications if I sign up for creator can I use all the applications I need without paying separately for them? otherwise it becomes very complicated and cumbersome. I would like to use HRMS, CRM, Books, Invoice and develop (or have someone develop) an online booking system for us. Also interested in using sites.
File Size workaround - open question to the community?
Hello, So Zoho creator does a poor job with file uploads in general. That much is clear. But I have seen the community come up with pretty innovative solutions for all sorts of roadblocks that Zoho cannot or chooses not to handle. So this is an open question to everyone. I have hit a wall and really need your help. What workarounds (third party scripts, third party online solutions, zoho api integration, anything) have you used or seen or think might work to do the following: When a customer
Programmatically create a new view
Hi Guys, Is is possible to create a view programmatically and dynamically using deluge? i.e. using a conditional if statement. Rgds and Thanks Andrew
link "#Form:formTest" in a view perma
Hello all, I have a page with a link like this <a href='#Form:formDummy?zc_LoadIn=dialog'>Test link</a> This works when the url page is normal (https://creator.zoho.com/xxxx/yyyy/#View:pageDummy), but when i try to use this link in a view-perma (https://creator.zoho.com/xxxx/yyyy/view-perma/pageDummy) doesn't works. Why? Any idea?
Problems with "parent window" openUrl function
I have my Zoho application embedded in my website. Today I just noticed that many of our application's buttons aren't working. They all use the parent window parameter in order to refresh the iframe its embedded in (I have a website with my zoho application embedded in an iframe. Some zoho applications views has iframes embedded so I use 'parent window' to refresh just the main zoho application iframe). I wanted to ask if there has been any recent changes (implementation wise?) to the openUrl
Need to remove or hide Duplicate option in my view
I don't want users to be able to Duplicate a record in my view. I set permissions so that the "Duplicate" option is not checked, but it still shows up in the menu. I found something about the view parameter below, but I don't know how/where to use it: Show/Hide "Duplicate" option zc_DuplRec=<true/false Any help is appreciated!
Date Format for a View
Greetings all... Does anyone know if it is possible to format a date field in a view? I don't want to change the default format for the entire app, just for one field in a specific view. For example, currently I have a view grouped by a date field which displays 08-27-2013. But I want it to say, Tuesday, August 27, 2013. Thanks in advance, Joel
Generate permalink for not logged users via an Script
Hi I want to know what it is the algorithm for create the not logged in permalink for a form. In my application I need to notify to the users (not zoho creator users) with the link to a form with some pre-populated data. I found some guides but them only say: Go to your form and get the permalink from there. Those links doesn't change? It is reliably form me insert those links on my email template? Thanks,
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
Get data by column number
I would like to retrieve data from a table/form by column number i.e. the nth field. Does anyone know how to do this?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Is Zoho Creator Report Shows Real Time Data?
Hi, I'm created a simple report and placed it into my dashboard using iframe. But then I noticed that it's not taking the real-time data. (I've added an record but it's shown in the reports only after like 5 mins?) May I know what is the refresh frequency?
Next Page