When can I use zoho creator to develop mobile applications (full support for Deluge Script)?
Hi When can use zoho creator to develop mobile applications (full support for Deluge Script)? Thanks! Stanley Guo 2011-10-6
How do I post raw code into a Rich Text field without executing?
Currently, when I paste sample XML scripting into a records Rich Text field, the record updates with the tags removed. For example, I want to paste <name> john </name> after updating the Rich Text field shows as john I don't want anything to be executed in this field. I've put in a Plain Text field as a workaround, but even those tags disappear when in a records view mode. Please help! The whole purpose of us creating this application is to track XML protocol information. Thanks, Brent
Import - Delete if exists
Hi! I have downloaded some data from my application and made some changes en-masse because I changed the structure of my database. I now want to re-upload the downloaded file to the relevant form and update the data. From what I have read, it looks like using the Migration Tool is the best option as it allows adding of data to Zoho Creator. However, I have been unsuccessful in updating the data as I cannot match based on the field that I would like to match upon. I only get an option to match based
zoho creator Send Email issue
Hi I have created a zoho Form and when submit button of form is pressed an an email is sent automatically.It is working fine on my PC. But on my clients Computer It gives following error when submitted using IE or Safari "Error occurred Please contact application owner".But it is running fine on even client's pc on Firefox. So i m stuck with this issue because i m not being able to understand the reason of this error. Regards Rana Ammar
Update a records Subform value or values
Hi Have fetched a record which contains a subform and i want to update (maybe later add) a subform entry to that records subform fields Script builder shows me the subform in the collection variable but from there i am lost Is this possible to do ? What is the syntax procedure thanks
Record id question clarifications
Hi Am about to embark on another coding adventure but need check on the following 1) If you delete a record in a form will its record ID ever be used again when adding a new record to that form 2) Are record ID's unique to the entire application or are they only unique to a particular form Thanks
Lookup Field by ID
I have a form with lookup field "Employee" reference to the employee form by Internal ID. with Display field "Name" For some reason I cannot have 2 records referencing to the same employee. if I select Employee that is used on another record, Employee from another record disappears. Problem 2: maybe related to the same issue, I cannot delete record now. Zoho loops
How to sum a separate table
I have two forms, an Expense form and a Purchases form. I want to very simply set up the expense form so it is: Account Number Budget Spent Balance xxx-xx-xxxx $15,000 $1,294.56 $13,705.44 yyy-yy-yyyy $20,000 $0.00 $20,000 Very simply I want the Spent column to automatically pull the total sum of all the records in the Purchases form that matches that account number. I tried doing all this scripting
Group the views menu (in edit mode) by their form/html/stateless
It get's really difficult to find the view you are looking for the way the view menu is laid out right now. I think grouping the views by their underlying form, html, or stateless would be very helpful to developers. Thanks in advance for your consideration ;) -Stephen
filter for a lookup field in a view
I have a form with a lookup field "Employee" that references to the internal ID field. In Advanced display option, I selected Display As: "Name" When I create view for that form and select Employee, column, it properly displays "Name field, however when I try to use this field in filters, the displayed values are internal IDs. Displayed values in the filter should match to whatever is selected for display. Another option would be to allow filtering on referenced fields, It would be even better,
Tool tip to be list items?
Hi, Right now, the tool tip shows the "help" description you put in the field configuration. But can the tool tip be configured to show each list item when it is hovered over? In other words, I have a drop down list. But some of the items are longer than the field length which makes it harder to read them. Can the tooltip be used to extend each list item's text? I've seen this done before elsewhere, but can it be done in Creator? I'd rather do this than expand the length of the field, which
NView not defined in the Workflow
For the second time in two days (two different applications), I got this error message when attempting to save a section code ... NView not defined in the Workflow ... this last time, I restarted ZOHO Creator, navigated back to this section code and (without making any changes) attempted to Save it ... and still got this message. Please explain ... a) what this undocumented/undecipherable message means b) how does one get around this ? Gaev
My Functionality based URLs is not stable
Hi, My client have a html view which passing parameters in the html view url, and fetch records by using the parmeters. However, after keep on testing, there are 30% chance that we can't fetch record in category and subcategory. I guess I make some mistake in construct the url parameters. I already enable support access. Could you please help me to take a look? Thank you. My client also intensive enter a lot of symbol in the database which cost a lot of problems. For example, " (This is for size,
Dynamically adding items to a drop down box present in a subform.
Hello just looking to get an update for when functionality to dynamically add items to a drop down box present in a subform will be available in Zoho Creator. This would be very useful for the application I am building to manage product configuration selection for customer orders. Cheers
Deluge script in for Schedules
i have a problem with my schedule, that falls for deluge scripting limits.. But i don't understand why: i have made many attenction to the scripting to not update all record but only the necessary records.. Thanks for urgent reply..
Dynamic Picklists Within Subforms
I've started trying to integrate the new subforms into my application, but have found that my dynamically crated picklists, don't dynamically change, when they are used as a subform. Is there a way to keep the dynamic nature of my fields, while having them as a subform?
intermittent issue with notification bar failing to update
The service is very slow at the moment. For example, saving a short script is taking 30-60 seconds. (EDIT: To clarify - as mentioned below, it later turned out the script is in fact saving ok but the green notification bar is sometimes failing to update.)
Urgent - Comments disappear when Saved from Free-Flow scripting
I was doing a test of a script section code and needed to temporarily disable a set of Deluge commands ... so I wrapped the command lines within ... /*abcd and xyz*/ ... but when I returned to the section later (after Running the Form), the block of lines were gone !!!! I did another experiment with just the //for a single line of comments ... that line disappeared too !!! I hope this is just a case of ZOHO Creator keeping its perfect record of "Make a platform change ... break unrelated functionality"
ABS or Absolute maths function for Creator?
Hello, Can anyone advise if an Abs function, or equivalent is available within Creator. I can't seem to find one...it is available in CRM and Sheet...so I am curious why one hasn't made it into Creator. Hope you can help. Regards, Liam.
Regex Matching Modes?
Does Zoho support these modes in the replaceAll() and replaceFirst() regex engines? /i makes the regex match case insensitive. /s enables "single-line mode". In this mode, the dot matches newlines. /m enables "multi-line mode". In this mode, the caret and dollar match before and after newlines in the subject string. /x enables "free-spacing mode". In this mode, whitespace between regex tokens is ignored, and an unescaped # starts a comment. /g - Allow global matching (all occurrences of a pattern
How do I create a Record ID link to sync/pull multiple data fields from one or multiple forms in a different view?
I am new to Creator and have a fairly basic database application question but can't figure out how to do it on Creator. Typically in a program like Access, you can tie records together by a certain data field and then pull certain other data fields into a form or view without having to re-enter the same data every time you input a record. For example... In my database "Contact Info", I have two fields, one - "contact" and field two - "phone number". Let's say I've created a view (not a report)
How to best link records within the same form
To make my database truly effective I need to show the relationships between records within the same form. In Form1, I'd like to indicate that Record1 is comprised of Record2 and Record3. I would also need to indicate if Record1 helps to comprise another record in the same way Record2 and 3 do for it. If I were to view Record2 I would want to see that it comprises Record1 and whatever else it comprises. The ultimate goal is to clearly see all of these mapped relationships. I've tried a few attempts
Update Button in View
I'd like to do something that I'm sure is simple, but I just can't seem to figure out the syntax. Here's the setup: 1. Form A has 20 fields. 2. Form B is a stateless form that lets users edit 10 fields in Form A. 3. I need an Update Button in Form A View that invokes Form B (the stateless form) and populates it with the 10 editable Form A fields from the matching record/row. My specific challenge: I can add a button (custom action) to Form A View and get it to invoke Form B, but I can't do it in
Render Image Problem in Different Views
Hello, I put an "Upload Image" and a formula "Display Image" in the form A. And I write the code below into the formula: ((("<img width='64' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Upload_Image + "&sharedBy=" + zoho.adminuser) + "&appLinkName=") + zoho.appname) + "&viewlinkname=Image_Upload_View'/>" When I go to the view A, I can see the image. There is no problem. But when I go to different VIEWS which I had duplicated from view A, I can not see the image. Could you please
More map variable love with insert into, mail to, etc
Maps are REALLY useful data holders. They can be passed and returned in functions, you can dump all form field values into a map really quickly, etc. Deluge already supports using maps in setting postURL, getURL headers, and post body data, why not expand this to allow a developer to pass a map to insert into or mail to? Example myMap = {"first_name" : "Stephen", "last_name" : "Rhyne", "Added_User" : zoho.adminuser}; insert into contacts(myMap) //or insert into contacts [ myMap ] Why add
Grid View
I have a Form with lookup field. Field selected on that lookup is ID ( Zoho ID of the referenced record). I have a grid view from that form. Making any changes to the data in grid view, removes values from lookup fields even though I edit not a lookup fields.
stringlist conditioning
Hi guys, I'm not into coding too much but i have an idea of the basics. I have a stringlist in my app, and when a certain value is selected (in combination with others or just that value) I want to enable another simple string field. Could you help me with the code? Thanx Cosmin
XML feed
I need to develop a Zoho Creator script to import data from an XML feed into forms -- could be multiple forms with relationship set up between them. I need to let the script automatically import at intervals, say every 12 hours. Is this possible?
Zoho Creator Help Desk cannot delete: you are not allowed to view / edit the script
I had installed the application for trial. Finally, I found no interest and want to delete, but I cannot..... "you are not allowed to view / edit the script" HELP!!!
Formula field help
I have a task form to assign specific tasks to individuals to work on them. I have "Estimated Hours", "Actual Hours" and "Remaining Hours" which is a formula (Estimated_Hours-Actual_Hours). I also have a Project Length lookup field that's a in which you choose how many weeks/months you have to complete the project and it will then formulate the Weekly Hours =(Estimated_Hours / Project_Length).round(2) which will break down how many hours a week you need to devote to the project to finish it.
How to display data in a form field?
Hello I want to display some data in a single field when i choose some option in a dropdown o multiselect field, or when i put some numeric values in a number field i want to display the sum total of that values in another numeric or currency field without going to the view from that form. Thanks for your time and patience Greetings from Colombia
If statement not working
For a Task form I've built, I want to be able to put in the Estimated_Hours of the project, the Actual_Hours of the project and how many hours a week I want to work on a project, Weekly_Hours. If the (Estimated_Hours-Actual_Hours) is less than the Weekly_Hours originally submitted, I want the Weekly_Hours to show the (Estimated_Hours-Actual_Hours) to have a better idea of how many hours per week you have committed to a project. For example, I'm working on project X and at the beginning of the project
API Add Record throws error 2900 if there is no fieldname in form matching submitted key value.
This is also an active ticket with support, but I figured I would look to the community for insight too. We use sendgrid as an external email provider. I wanted to send an email with unique record id in the header from zoho to sendgrid's web api (which then sends the email). The results from that send attempt would then be posted from sendgrid's event api back to zoho (to record bounces, unsubscribes etc). I was able to do all this successfully. But I hit a snag. One of the fields that sendgrid's
Set criteria not working
For a dynamic picklist I want to specify the criteria to show "Active" and "Maintenance" but not "Completed." I've tried this multiple ways and none of it will work though it accepts the command. I've tried: Project_Status = "Active" Project_Status == "Active" Project_Status != "Completed" I've even tried creating a decision box with "Active" and even that wouldn't work. To test it I've even tried what has worked in other picklist criteria and even that isn't working. Is this some sort of bug?
how to get the name of an unknown XML element?
For example, say the XML data is: <CustomerID>12345</CustomerID> <Name>Bob Smith</Name> <Phone>99999</Phone> But I don't know the exact names of the elements in advance. How can I extract just the name of each element - i.e. "CustomerID", etc - from the XML? Anton
Deluge Scripting textbooks
I am looking for Deluge Scripting textbooks. Can you help in recommending some good ones?
Importing data in views is not updated in zoho reports.
I developed an application and upload my data on creator views. In my application there are different forms. From them only 2 views data is not been updated to the zoho reports, others are able to get updated.
HTML View image only seen by admin
I have an image on my home page HTML View that uses this code: <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/1266858680427_HydeParkLogo.gif&sharedBy=<%=zoho.loginuser%>&appLinkName=hyde-park-data-center&viewLinkName=Images_View'> When logged in as admin it shows, but not when I'm logged in under my test user account. Any suggestions? Thanks, Bruce
Fetch Records to update dropdown box
Hi, I am currently trying to put a FetchRecords script in whereby a dropdown is updated with data from another table. The syntax I have is as follows: get_available_products = Available_Products [Product == input.Product]; input.Unit_Trade = get_available_products.Unit_Trade; input.Unit_Cost = get_available_products.Unit_Cost; input.VAT_Class = get_available_products.VAT_Class; The first two fields are normal single line fields and update fine. The VAT Class is a dropdown but does not seem to
ZOHO Creator & Payment Gateway Integration, is this possible?
I am in the middle of project and requirement is Form submisison created usin ZOHO creator result into payment process system, Is this possible? Please help
Next Page