Deluge: How to return the first 3 letters of a string and capitalize them..
Thanks
Nested checkbox list
Hi, I am wondering if it might be possible to accomplish the following through deluge and a standard form (seems you can do it as a html page but I'd rather not go there). I have a set of checkbox lists that look like this Checkbox 1 Checkbox 2 Checkbox 3 Checkbox 4 These items are not hard coded but rather are dynamically added from a table in the application. What I need to be able to do is to nest some items under each checkbox. So for example, if you click on checkbox 1 you would see something
Converting Simple Excel Formula to Deluge Script
Hi I'm currently evaluating Creator and have fallen at the first hurdle. I have a simple excel formula to calculate commission on sale price: =IF(Net Sold Price <50,Commission Level *Net Sold Price,0) I know that I need to write a script in Creator to achieve this same result. I am not a developer, i don't know java or VBA so this simple task is extremely frustrating. Can anyone provide the script that I need to enter in to the form? Any help would be much appreciated! Thanks Adam
Glitch in the Add Records Deluge Script Builder
This is hard to describe. On Success, I was trying to use the script builder to add records from Form A into Form B. The script builder in not functioning properly. When Selecting Form B as the target, the available field list is showing fields from Form A. Switched back to the old script builder and it works fine.
Script name change
When I change the script name of a field or eliminate it, Creator doesn't recognize the change. I have to exit Creator altogether and restart.
Can someone translate this from Creator Deluge to CRM Formula Syntax?
I can't figure out this formula system... Anyone experienced enough in both platforms to translate this to CRM for me? if (input.Cafe_Machines_Needed > 0) { input.QTY_Cafe_Machines == input.Cafe_Machines_Needed.toString() + " - Cafe Vending Machines"; }
Writing an entire application with Deluge script
How can I write an entire application using Deluge Script? The advice given here does not seem to work: http://www.zoho.com/creator/help/script/app-builder-deluge-scripting.html#writescript I cannot seem to find this option. Does anyone know where I can access this mode?
How to display images in HTML views?
Hi there! I am creating a list of items with images. The "summary" view is inadequate, so I am working on creating an HTML view that will nicely list the image and a few other fields for each entry. How would you go about displaying images within HTML? Here is my HTML/Deluge code: htmlpage testpage() <%{%> <%totrec = Illustrations.count(); for each r in Illustrations {%> <%=r.Name%> <%=r.Image%><br/> <%} }%> Resulting in displaying the content of the "name" field correctly but
Populating Subform through Deluge Script
Hi, I have looked extensively through the support section, and while accessing subform data is relatively easy, I have still found no way of adding subform data through Deluge script. I am trying to automatically generate invoices when a booking is made, but the line items for the invoice are in a subform. Any pointers in the right direction? I have already inserted the non-subform data into a new invoice: Customer_Invoice_ID = insert into New_Invoice [ Added_User = zoho.loginuser Address_1
How to get deluge script criteria to show the correct records in a view
I'm pretty new to zoho and deluge scripting. I have tried to do this thing that seems straightforward, but it is not working. I have a membership form and a payments received form. Members pay dues each year. I want two views: one that shows who paid dues for 2012-2013 and one that shows who did not pay dues for 2012-2013. My deluge criteria for the NOT PAID view is: show all rows from Payments [Year_Dues_Paid_For != "2012-2013"] This fails because if people paid in other years, they show up
If then script
Hello. I am trying to figure out the Deluge Script in Zoho Creator. The result I am trying to generate is this: Through inputting, these variables are defined. vs (this is a percentage) Week_Gross (this is a decimal generated through a formula by adding several previously inputted numbers) Guarantee (this is an integer) In plain speak, the result I want is If vs * Week_Gross is greater than Guarantee, then output vs * Week_Gross, otherwise output Guarantee. I have generated the following
Simple Dynamic HTML
Hi, I am aiming to make a very simple Dynamic HTML page, do you think You could help me? Basically we're building a Database of Local Work Seekers. The Work Seeker Application form has all the information for that Work Seeker. Upon Submit, we want the App to generate a Resume for that individual based on their data. Below is the link to the App. https://creator.zoho.com/dylanvdb/good-help-employment-marketplace/#View:Curriculum_Vitae (I have opened up the App to Support.)
Sorting has no effect on the order
Hi, i'm trying to process data in small batches and i have a hidden field called "RecalcPending" that by default contains the value TRUE. After the script processes one line it sets the value to FALSE. And setting the sort condition to Asc or Desc has no effect and the 130 or so lines of data never get processed by this script. I can see them in the view but so they have to be stored somewhere and the sort condition is not doing what it should do. Here is the for each line where the sorting is with
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
Variable Questions
I need a variable that can be accessed by multiple 'on user input' things. I don't seem to be able to declare the variable in the onLoad section and then access in the onUserInput sections, is there any way to make this work? I don't want to have to make a form to store a variable in a database. It seems like such a waste.
Deluge script: IF (condition) in On User Input is behaving oddly
Since some days ago, most of my forms behave oddly when I use the "if" and "else" in On User Input, to show or hide fields. The application seems to completely ignore the condition and always executes the "else" part. I didn't change anything in these forms since a week ago, and everything was working completely right, so it's not an error made by me writing the script, I even reviewed the script and everything seems to be OK. This is one of these scripts: f((input.medio == "Página Web")) {
"contact card view" with editable info and a call/email log
So i have a form that users can input their leads with. Similar to a CRM except WAY more basic. I already created the form and fields for the initial input of the basic information. here is what i would like to do: 1. Have a place where they can view the information that they have already inputted. on this form will be more detailed information that they can fill out. 2. Would like, on this form, a way for them to be able to track phone calls, or really ANY communications sent. a. just needs
Easiest way to create a dynamic updatable list
I have a form that uses a list / dropdown box. the list is static for the most part but i would like to maybe have a user be able to click a button (or some other action) and be able to ADD an item to this list. the user will only ever need to select just one option.
Zoho Creator getURL hangs and does not return
Hi, I am trying to use getURL to integrate with a bulk SMS provider. The following URL (with actual password etc) works fine from a browser http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=xxx&password=yyy&sendername=Rentoys&mobileno=9199999999&message=Hello+World However when I use it with getUrl, the call hangs and never returns. I have tried passing headers (User-Agent etc) and I have tried simple and detailed response. But none of the options return. Is there any way to debug
Alphabetize With Deluge
I am currently using a deluge work around to add the fields to a lookup list and keep from having the same entry twice. The problem I have from doing this is that they do not get put in the field in alphabetical order. So my question is, is there a way to alphabetize a list in deluge?
Deluge scripting failure
Hi support team, In july, I wrote a deluge script using apitite Creator-CRM library from the market place. The purpose is to retrieve a few records from a CRM custom view and populate a table in creator for reporting purpose. Everything was working fine in July, but it appears now nothing works anymore for no reason. After half a day trying to understand what was going on, deleting script parts in order to pinpoint the issue, upgraded to the latest apitite version, I tried to follow the running script
How to order the data in a table according to dates?
Hi, I have made an events form and a view of this form. When the user enter data with the begin and finish dates, I want the for to be ordered according to begin date putting the nearest event to the top followed by the coming dates. However when the current date is later than the finish date, I want it to be automatically removed. For example today is 08.09.2010 and there is an event beginning on 08.09.2010 and finishing on 10.09.2010. I want it to be at the top due to its begin date. On 11.09.2010
How to give a link attribute to submit button?
Hi, In my form, I want the page to navigate to a specific url when the user fills the form and clicks the submit button. The success message shall still be there, but in the meantime the web page should navigate to the desired url. Is tis possible by deluge or some other way? Many thanks, Vera
Hope Zoho Creator team could improve the way of showing error message when debuging
I create a HTML page and write some script in it. When I click "Save Script", then ZC check Deluge Script and report error. There is no problem for this flow. But the error message looks unfriendly. eg. there is a simple error, however ZC tell me the following error message: Encountered "<" at line 30, column 21. Was expecting one of: "Workflow" ... "output" ... "bool" ... ... "float" ... "list" ... "map" ... "xml" ... "var" ... "htmlpage" ... "string" ... "date" ... "void" ... "this" ... "input"
Parameter passed from non-Zoho page into an embedded view not working
Here's my dilemma. I have an HTML view with serves as a dashboard to two other forms. Both of these links call different forms and pass to each the field Username to it in an attempt to prepopulate the Username field. The HTML view dashboard is embedded in a non-Zoho webpage. The non-Zoho webpage passes Username as a parameter to the HTML view. Thus, the intention is to pass the Username from the non-Zoho webpage to the dashboard, and then to the appropriately-called form. Somehow, the Username parameter
Basic development questions on displaying and keeping records
I really like the simplicity of one particular sample app (Basic Lending Library ) and would like to learn how to tweak a few things to better understand how to use Creator. If I wanted to track a member's borrowing history on Book Copies, what would I need to add? Such as Dates for check in/out, and writing to the member records what copy was borrowed. Under Book Title's All Title View you can see how many copies exist, is there anyway to display rather than number of copies the Book ID numbers
Why 'on success' is disabled in http://creator.zoho.com/zhaoshiting/test/test/record-edit/test/299974000000557572/
Note: The application is public, you can click here and try it. It cann't pops window when clicking 'update' button in http://creator.zoho.com/zhaoshiting/test/test/record-edit/test/299974000000557572/ The code as follows: on edit { Update ( type = submit displayname = "Update" on success { openUrl("#Form:test", "popup window", "height=100,width=100"); }
Restrictions on a lookup field
Hi I tried to set a restriction on the lookup field. I have a field called "Active". It's a decision box. So I set the deluge criteria to be Active == true But every time I enter this criteria into the field definition it gets ignored. Is it because of existing records in the tables?