Captcha not working?
I have gone through the Captcha help files and successfully added the function to my bespoke web lead form but whilst testing if I enter the wrong code in the Captcha field it still allows me to complete the form request. Can someone help as we are having a large amount of spam currently?
Style based URLs Embedded forms
Hi, parameters looks to be omitted in certain cases of embed forms : for example, in a HTML view, we embed a form with : <div elName='zc-component' formLinkName='FormName' params='zc_Header=false&zc_LblFontSize=18'>Loading...</div> The parameter in bold works correctly, but is omitted when we use the permalink of this HTML view (zc_Header=false is ok but not zc_LblFontSize - not tested with other customization parameters). There's no problem when we use Iframe instead of div. That's minor but good
Maintaining Links when exporting html to pdf
Hi, 1. Is it possible to maintain the <a href="link"> when a html page is exported to a pdf? 2. Does anyone know of a solution using creator/zoho to create a report/document in html and then turn it into a pdf with links. I would like to have thumbnail images that link to larger files if the user wishes. I realise that the application has to be public if I want to be able to export the images. 3. Is it possible to export a html page to pdf and then attach it to an email? Thanks,
Script Won't Save?
Hi, I came across this issue multiple times, and it is starting to get really frustrating. Basically, my script will not save. No error message shows up, it just keeps saying "Updating Script", but it never actually updates or saves. It happens when I am using a conditional statements where I use "&&" to add another condition. For example, this script will not save. //Alert Box that shows a pop up message if the user tries to select a bike that is already online x = Bike_Listings_Current[Bike_Serial
Basic Budget Application
I am trying to create a very simple budget application. When I submit a purchase in my Add_Purchase form, I want to send the Cost of that purchase to a form that tracks the Expense Account. In the Expense Account form I already have the budgeted amount for the year and I have a remaining balance formula field that will take the Budgeted_Amount and subtract the Amount_Spent from it. However, I cannot get the purchases once submitted, to shoot that Cost over to add into the Amount_Spent. Instead,
Twitter content
Dears, I'm using "html view" in Zoho Creator in order to show some content on my website. I have 2 questions: 1) How can I show the latest twitts sent to my Twitter account on the "html view"? 2) Can I add the latest twitts to my database as new records? Can you provide some code examples or scripts in order to do these tasks? Thank you very much in advance.
Monthly "snapshot" of data
I've built a PPM (project portfolio management) tool that tracks pending projects, active projects, complete projects, etc. Naturally, I always have a live view of how many total projects are pending, active, when they were last updated or other data. However, I'd also like to take a monthly "snapshot" of some data to show trends over time. Can anyone help me with the best way to approach this? Would I need to create a new form that captures the current state of data using the Scheduler? Is this
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
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
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
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
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
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,
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?
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
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
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%>/"
How to disable the export and print features in a VIEW based on the user right ?
Please advise. Thx, Jason
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!
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
How do I create a change log of the data entered?
I would like to create a log of the changes to the data entered in my application and who made the change. Either I want to show the old and new value or, I want to record the old value when I input a new value. The problem is, that when a record is created, if I try to use the On User Input function, the ID for the record is not known until the form is submitted so the log can not record the initial value along with the ID when the record is created. When I try to use the On Update function, the
Uploaded document link in view mode - want to view, not download
I am experimenting with how Zoho handles uploaded files. In the view mode, the file link is such that the file is sent for download. Example: https://creatorexport.zoho.com/DownloadFile.do?filepath=/1364178129140_100-873-Deed.PDF&sharedBy=bumcgi&appLinkName=document-upload&viewLinkName=sheet_data How can I create a link that will allow my browser to open the document. Specifically, opening in a new tab would be my preference. I have tried different browsers and right-mouse clicks and it always
deluge script not working in "on add/success" but working fine in "on add/on load"
Hi, I have a simple record-counter script that works in "on add/on load" but it doesnt work in "on add/on success" this is the script: Variables_de_Sistema = Variables_de_Sistema [ID != 0]; input.Numero = (Variables_de_Sistema.Ordenes_Ultimo + 1); Variables_de_Sistema.Ordenes_Ultimo = (Variables_de_Sistema.Ordenes_Ultimo + 1); the script updates fine the input.Numero field in both cases, no problem there. The problem is that in "on add/on success" the variable "Variables_de_Sistema.Ordenes_Ultimo"
Telephone number error
I have made a simple Contact Us form and no matter how I enter the telephone number it comes up with an error message - Enter a valid number for Telephone Number. Have tried every way I know including putting country code in front of it but still get the message. Suggestions? - jb
Dates and Aggregate Records
A simple task: find the latest entry in a database based on an input date. I have a stateless form with a date field. After entering a date, the aggregate record task would find the latest entry for that date. The issue is that the database uses date-time fields so this fails to work: max_date = Date_Time[Date_Time_1 == input.Date_1].maximum(Date_Time_1); Nor can we do this: max_date = Date_Time[Date_Time_1.toDate() == input.Date_1].maximum(Date_Time_1); Error in statement at line number 1 Either
Can I embed a report to Add Notes field?
Hi I don't want to jump to open a html view for display a report, like embed in a picture to Add Notes field , embedded in a report to Add Notes field, I tried the following code, but it can't work： plain ="<iframe height='500px' width='900px' name='zoho-report' frameborder='0' scrolling='auto' src='http://creator.baihui.com/stanleyguo/theone/report-embed/report/'></iframe>" Hope get your help.. by the way the Add Notes field extremely useful. Thanks Stanley Guo
total row data in reports
i cant view the total of rows in zoho creator report. all i can view is the total for the each column. how about the rows? Thanks
Slow replies from Zoho support?
Hi, I am getting a bit frustrated with the slow replies from Zoho. I have sent about 20-30 emails to support@zohocreator.com over the last few months. None of them were answered within 7 days and many of them were never answered at all, leaving me to fend for myself. What is Zoho's service SLA? Does anyone else find this or is it just me? Any tips on how to get a swift reply? Usually what I do is create a forum topic (so that other people with the same problem can find the solution) and use the 'email
Form On User Input Not Evaluating
One of my forms stopped working. When adding a new record, everything worked great. But when I edit a record, things stopped working. For example, I've deleted my entire On_Edit->On_Load script but many fields do not appear when the record first loads. Furthermore, when I edit a field, the On_User_Input does nothing while editing a record but it works fine when I'm adding a record. How do I fix this very strange error?
Send an email containing data from three forms
I need help to create an email comprised of data that exists on three different forms, all of which have relationships between them. Specifics: The email address the email is to be sent to is on the DONOR form. The email is triggered to send via a checkbox on the DONOR form. The email needs to include data located on the WISH LIST form. The email needs to include data located on the FAMILY form. Relationships: The DONOR form has a lookup field to associate donors (DONOR form) to families (FAMILY
Are multiple Forms for the same table somehow allowed?
I need to have several different forms available to enter data into the same zoho 'form' or table. The reason is that I want a simple form with only essential fields in one case and a full form in another case with all fields and some for in between. This is for different users of the system. I can hide or show fields conditionally in the 'on load' script based on the zoho.loginuser Just wondering if there is another way such as creating alternate forms for the same table and then changing the
Bug when importing a Deluge script file
Hi, I've found what appears to be a bug where a particular part of a form is lost when exported and then re-imported. Here's the issue: When using a lookup field, and checking the "Show a link to add new entries" box, the exported .ds file will contain this: allow new entries = true [ displayname = "Add Example Data" ] But when re-importing this file, those four lines are missing. This means that there will not be a link to add new entries in the lookup. Is this a known bug with Deluge script import?
Updating script. . . never ends
What does this mean when trying to update a script? Specifically, I am updating a form script on edit / on success. When I try and navigate away from the screen it warns that I will lose changes and indeed they are lost. I am trying to isolate the offending line, but it is difficult because of dependencies between different lines re. referenced variables. Regards . . .
RegEx trouble
I copy&paste texts into ArticleText field (rich text) from word documents. Due to text is always long, I create for a ArticleText View - ArticlePreview formula field, which should keep first 100 symbols of ArticleText field. Formula calls function getPreviewText(ArticleText, 100) Due to value of ArticleText is not a clean text, but html formated text, so I need to clean it from tags by string getPreviewText(string srcText, int len) { str = "<(.|\n)*?>"; input.srcText = (input.srcText).replaceAll(str,"");
Best Way to Invite Many Users to an App?
A related topic https://help.zoho.com/portal/en/community/topic/register-without-email is under review (account provisioning). However, I'd like to know what others have done to get a large number of people signed-up with Zoho Accounts. Cheers, John Whitney
Strange Error Message
Attempting to identify what code would be impacted by changing a field-type, I got this. Cheers, John Whitney
Next Page