NEW BUILDER ... terrible script debugger
So if you write buggy script, instead of telling you there is a bug, it says "script saved" but doesn't really save it. I lost about 20 minutes worth of work just now, because I assued script saved meant script was actually saved. But just as I was about to test it, I noticed my own error. l = Lesson[ID == input.thisLesson]; clear Student; for each s in l.Students{ if(s.status == null) { Student.add(s); } } Student is subform in Lesson it says "script saved on this"
Zoho Invoice Line Items are Creator subform lines
Hi There I'm developing an Invoicing app in Zoho Creator. It will take data from Zoho Creator forms and push it to Zoho Invoice for Invoice generation via Integration tasks of Zoho Creator with Zoho Invoice. My Invoice line items are entries of a subform named 'Food' in the main form Named "Food Inventory". I've declared a map variable that holds values for each line of subform. itemsList = List:Map(); itemsList.add({ "ItemName" : row.Food_Item, "ItemRate" : row.Rate, "Quantity" : row.Quantity
Decimals showing on Number field???
I added some number fields to my form. In live mode they show with 2 decimal places. Curiously if I change them to Decimal fields with 0 decimal points they show as whole numbers.
Error occured while executing on user input script
I am inputting test data into the following form https://creator.zoho.com/essistmgmt/assets/#Form:AGREEMENT and it suddenly closed with the error message above. Can I get more information on the error details to understand the cause?
Expert in Zoho Creator required!
I have a small project (10-20 hours) which requires some quick development, and ongoing developments as I no longer have time to do it myself! If interested please contact me via email: ashley@elprofesoringles.es or +34 633188512 Thank you, Ashley Williams
Schedule Delete Based on Date
I am building a property management app and need to run a scheduled script once a week to delete records. I need to delete records that are older the 14 days and status is set to "rented". I would appreciate any help. Thanks, Aaron
Check for conflicting dates
I am trying to create a form that will double check whether or not a person is already scheduled for a shift that is in conflict with another shift that I would attempt to assign the person to. I.E. PersonA is assigned to Shift1 from 7/1/2013 to 7/7/2013. If I tried to schedule PersonA for ShiftB that is from 7/3/2013 to 7/10/2013, the application will tell me that those dates are unavailable. on Validateif (Shift[ID == input.Shift && Shift_Start_Date <= input.Assign_End_Date && Shift_End_Date ==
Having problem with getYear()
Hi, I want to define a function that returns the no. of row count where the year in A_Date (Date field) is equals to the current year. I tried using getYear() but upon saving, I'm getting undefined and null. Is there something wrong with my codes? Here's my code : int Calculate.AttendanceTotal(int empID) { yr = zoho.currentdate.getYear(); c_VL = Attendance[Employee == input.empID && A_Date.getYear() == yr].count(); return c_VL; }
Margin problems when saving HTML view as a PDF
I have an HTML view that I have enabled the "PDF Header" option. As I expected, the PDF goes over a number of pages, but the problem I have is no margins (top, bottom, right, left) at all on the page. Any ideas how to set the margins?
Show additional fields after radio button selection
Hi Everyone, I am trying to make 4 extra fields show when one of my radio button selections is made. It is actually for Credit Card information. This is what I have been trying on user input: if (input.Payment_Choice == "Paid by Me") { show Credit_Card; Card_Number1; CVV; Expiration1; } else { hide Credit_Card; Card_Number1; CVV; Expiration1; } Keep getting error message on line 1, not sure why. Your help on this is much appreciated!
Unexpected error due to improper script.
I am trying to view my scripts under https://creator.zoho.com/essistmgmt/assets/edit/function/ Sometimes I get this error. When I refresh the page a few times, the error message goes away and I can see my script code. Can you please investigate why I am seeing the error?
Passing forms as parameters
I have found the help page at https://www.zoho.com/creator/help/script/form-objects.html#Adding_form_object_as_argument_to_the_function and tried to replicate it but am experiencing difficulties I created a function that has a form as an argument When I execute the form via the script builder and randomly select an ID, it works as expected. When I try to insert it into the form actions by calling the function and passing input.ID, I get the following error message. Why is it not working as expected
Custom script code disappeared
I was working on the following function udf_generateids.convert_numeric_to_alphanumeric_code and when I opened the function, it ended up seeing string udf_generateids.convert_numeric_to_alphanumeric_code_896426000014261704(int value, int digits, string code) { } My code disappeared. I never created a function with the name convert_numeric_to_alphanumeric_code_896426000014261704 with the random number. The other big issue is that all my script logic has disappeared. There is nothing in the version
Power of caret
Zoho creator appears not to support using the caret "^" as a power of When I try and runs this test code below int temp.temp13() { return 2 ^ 4; } I get the following error Lexical error at line 2, column 10. Encountered: "^" (94), after : "" How can I get the power of a number?
Unknown variable causing script error
I want to update the following GLOBAL_SEARCH html view located at https://creator.zoho.com/essistmgmt/assets/htmlview/GLOBAL_SEARCH/edit/ However, I am getting the following error message Error at line :2 The variable 'd' cannot be accessed at this point. There is no reference to variable d in the script. Can you please help troubleshoot? Thank you
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
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.
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.
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?
[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.
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,
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.??
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,
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
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?
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?
Uploaded resume from Creator form to Recruit
Hi, I'm running into an issue where when a candidate submits a form made in Creator, with their resume attached, the data does not get added to our candidates database in Recruit. But when the same form is submitted without the resume, the deluge task we're using works fine and the record is added. What can I do about this?
Load form in edit mode
Hi , How to reload the form in edit mode.At the time of accessing the application ,i need to load the form in edit mode.(not in on add--on load )
Search form for stage
Good morning, I need to make a loockup in Zoho CRM Zoho Creator to seek a potential with a certain stage. Is it possible?
Create a List from a String
I am building a search form to search CRM and manipulate the returned rows. I want to be able to search the CRM on one or more Account Names. I am working on the basis the user will enter a string such as "account1, account2, account3" into a field on a form and the system will return the Account Rows where the name Contains account1, account2 or account3. My plan was to use the searchrecords function but as this only allows one search criteria I have to run round it several times to cover all the
Script not adding fields, will not hold () in script.
Below is a script I am trying to use. The purpose of this script is to update an "Inventory" form's "Quantity" field. It will not give me the total of the two stated fields "currentinventory + Inventory_to_Add". When I enter the script via the GUI or free scripting method, Zoho always removes the () from the script. I am no scriptwriter by far, but isn't it supposed to keep the ()? So when i use my "Re-Stock" form, the script adds what I enter to the "Inventory" report but does not ADD them, it
SubDay Question
Greetings all... I am using the following to determine a date in a script: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(churchinfo.reminder_email_days); Where churchinfo.reminder_email_days is a collection pulled from a table where reminder_email_days is of field type numeric. When I put in specific number: input.email_reminder_date = rec.weeklyworship_worshipdate.subDay(4); It works fine, but when I use the code referencing the variable for the subDay it throws an error message.
'ADDTOPICKLIST' can be used only in on load actions - error message
Would like to be able to populate a drop down list based on value of another field. Works fine on load action, but on update get error above. if (input.Title == "Mr") { Singing_Voice:ui.add("Tenor"); Singing_Voice:ui.add("Base"); } else { Singing_Voice:ui.add("Soprano"); Singing_Voice:ui.add("Mezo-Soprano"); Singing_Voice:ui.add("Alto"); } Thanks Tim
Next Page