can user add new choice to existing drop down list ?
Hi, Can user add new choice to existing drop down list ? This added choice will be permanent in the list ou not ? If so, how should I do this ? Thanks
More about ampersands
There is quite a few old posts about using ampersands, but I fear there is still an issue with these. I have a 'Property_Name' field in my 'Properties' form which allows users to use the '&' sign in the text. However, when they do, the following does not work : message = "#View:Assets_Report?Property=" + property_details.Property_Name; openUrl(message, "Popup window", "height=800, width=600"); In all other instances, it works fine. If there is a technical restriction to the use of ampersands,
Auto fill sub form from main form
Dear all, Please help me with the duluge for this problem: 1. I have 1 form containing all Car information (such as car license plate number, etc) or Car Info Form 2. 1 have 1 form for Car maintenance form with subform of spareparts usage form. 3. In the Car maintenance form, i have a drop down lookup to Car License plate on Car Info Form 4. When i fill in the subform for sparepart use, i want the Car licence plate field on the subform to be filled with the chosen car from the main form. Please help
Simple update website form
here's the particulars of what I'd like. We need to build a form to update the elements/fields on this page this is the page. http://template.qbprocessing.com/about-us.html Avatar (image of face) Your Name Years in Business Business name Street Address City, State, Zip Free Initial Consultation Phone: Phone Number Fax: Fax Number Email: email address Web: BusinessPhone Number Then be able to update the bullet points under these "headers" Professional Credentials Certifications Industries Supported
Permalink to HTML view with embeded zoho views
Hi, Is it possible to open, trhough a permalink, an HTML view that contains other embeded zoho views? For the embeded views I am passing parameters in the URL in order to filter the records. I can open the HTML view but the embeded views don't seem to work. additional info about my application: My application is called: Sistema de Operaciones Yaxche The Form used to open the Permalink is: Registro (when clicking the "Enviar" button) The Permalink is meant to open the HTML view: Proyectos_Cliente
Problem sharing an application
Hello I've been developing an application but have run into a problem with sharing. I have shared all the forms and views a user would need to access and use the application but some of the shared forms do not display correctly when a user attempts to open them. The problem forms are meant to be opened when a user clicks a custom action in a view. The custom action builds a URL query string that opens a form and display a specific record. The URL displayed appears to be correct but instead of displaying
API/Deluge Limits Do you have hints and tips
So I am hitting limits (500 API calls and 5000 Deluge Statements) quite regularly, I just wondered if people had any suggestions. This is my position: I have a variable list of CRM Account ID's which has been built up in a previous step. My app needs to go and get Account Data and Related Case Data and Opportunity Data, when I have say 10 ID's it s not much of an issue. its just 30 API calls (10 for each module) and may be 300 statements to process for output etc. But with 200 I hit the API call
Duplicate App
I'm trying to duplicate one of my applications but only get the error message 12002. What to do?
Passing parameters to a function
I have a function that is called from two different Views. The function opens a stateless form. When it is closed I want to return to the calling view. Is there a way to tell where the the function is called from? I tried adding another parameter to the function but in the view the only option for parameters are fields in the view. Is there an option to type a string for the argument? Herb Wexler
Using dynamic authtoken or static authtoken
Hi, I have a website that integrates with Zohocreator using its API. There will be many situation where there will simultaneous use of the Zoho Creator Application through record additions or updates from the website. Is it sufficient to have a static authtoken or would it be better to have dynamic authtoken (an authtoken is generated everytime we want to add or update the record)? Hope to hear Regards
Pop-up Display
This seems like very basic question, but: I want to write a function which gets called as a Custom Action. In that function, I want to display a list of records in a pop-up window. I can't see any Deluge functions that allow this to happen. Is this possible? And if so, how? Thanks Alex
HTML page as email content
I need to send an html page (based on my app's data) as an email content. (the html page itself works great) I tried doing so as it says in this help page - https://www.zoho.com/creator/help/script/send-mail.html by copying all the html code from my zoho page, to the message content in the "deluge mode" (send mail task) It doesn't work. Anything I'm doing wrong here? Is there a limitation on the html code length when sending it as a mail? Is there any other way of sending an html page as an email
Default parameters for custom functions
I think it would be very useful for default parameter values for custom scripts functions. Can you please add this feature?
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.??
Next Page