Functions within a form (Form scope, not application scope)
Wondering if it's possible to create a reusable function with form scope only. It appears Creator only allows application scope functions. Form scope functions would make it easier to reuse code that is specific to the form and make for less lines of code and easier maintenance.
Show/Hide events on calendar view
Hi, I have a create_event form and it has 5 different types_of_events. How can I code such that the report can show or hide events pertaining to the type_of_event selected as a custom function? Thanks!
newline base64Encode bug when using very long strings
Hello, I have a bizarre bug to report using the base64Encode function. When trying to encode a very long string like this: tokenStr = "averyveryveryveryveryveryveryveryveryveryveryveryverylongusername:anotherveryveryveryverylongtokentypeofpassword"; auth = zoho.encryption.base64Encode(tokenStr);As you can see below, the result of the encoding includes a newline (which is invalid): YXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnlsb25n dXNlcm5hbWU6YW5vdGhlcnZlcnl2ZXJ5dmVyeXZlcnlsb25ndG9rZW50eXBlb2ZwYXNzd29yZA==
Change field name with "if" deluge script
Hi! I would like to change a field name with an "if" function in deluge. How do I do this?
Formula results in dialog box
Is there no way to have a formula and simply place the results into a "dialog box" on the report somewhere and give the results in that box? I do not want the results to be on every line for every record although the result is correct I simply want it in one place. Jerry
Zoho CRM Invoice from Creator
Hello I want to create entry in ZOHO CRM Invoices module from Creator form. Can any one know how can i add multiple products in Creator form and on submitting form, create Invoice entry in ZOHO CRM Invoice module?
Resolved - "Error modifying the page" when copying a Form to a different app via definition copy/paste
Thanks in advance... I'm trying to copy a form from one app to another (we created as a standalone app and now we want to move its objects to inside our main app instead. It only has 2 forms and a few reports.) Form is very simple. It is a simple "documents list", with 4 fields to name and describe the document, plus a File Upload field. In the target app: Created a blank form, using same form name. In the source app: Copied all code for the form "with action" (even though it has no actions). In
Need to add more data in a form
I wanna to create employee database which is in 4 parts 1. Personal information 2. Education 3. Employee details 4. Other information. Every parts has many information to collect. it's nt gud way to create in single form. I need like Step 1, 2, 3..... The Employee has to enter the data in step wise. And also i need to store in single database tables. Pls suggest any idea.
How to get data selected in subform onSuccess
Hey, I'm trying to get the products and quantity selected in a subform and put them in a map. Here are my forms: Form 1: OrderForm: Fields: 1.Name (Single_Field) 2. Products (Subform - Form 2) Form 2: ProductsForm Fields: 1.Product Name (Dropdown Lookup Field to Form 3) 2.Quantity (Single_Field) Form 3: Items (Here is where I insert the products into the system, the user is not able to see this form) Fields: 1.Item Name (Single_Field) On submit in the OrderForm, I want
Performance Issues
Hi, We have been experiencing reduced performance with Zoho creator since the 24th Jan, this is especially noticeable with API calls now taking in excess of 2 minutes to respond. Has anyone else been experiencing issues? Thanks Rgds
Deselect all values on a single select radio button in a stateless form based on a button click
Hi, I'm trying to allow a user to erase their answer to a question on a radio button field. The user is answering many questions displayed one at a time using a stateless form. I reload the form to go from one question to the next. In this case, the user wants to go back to an answered question and erase their answer after realizing they are not sure of the correct answer. I'm trying to do this using a button on the form. The following commands had no effect: rdAnswer= null; and rdAnswer= "";
Product Subform getting records from Zoho Books Items
Hey guys, I have a main Order Form, and in it I have a Subform Products, so I can add as many products to the Order as I want. How can I populate the dropdown in the subform with a predetermined list of products(retrived from Items in Zoho Books). I can't put it in the onLoad in the products form because (I think) tecnically that form will never load, it will only be called from the Order Form.
Help!! disable and enable input of subform
Hello, I have a small problem and I want to disable a field of a subform while it is empty or is null, I try from the Form Action - On Load and from the Field Actions, but I have not been successful, these are the 2 codes that I put: Form Action - On Load: if Item.Producto == null { disable Item.Valor ; disable Item.Cantidad ; } else { enable Item.Valor ; enable Item.Cantidad ; } -------------------------------------------------------- Field Actions if row.Producto == null { disable row.Valor ;
Increase Photo Size Limit/And or easier solution
I know the limit was recently increased to 5mb, but anything larger would still be helpful. Still having issues with clients submitting through a mobile form and their camera pictures being too large. Many new phones have quite the high resolution which causes the file size to increase greatly. If this isn't possible, does anyone have any other elegant work arounds to getting larger sized pictures attached?
Problem accessing subform values
I have forms with the following structure: Student Name Contacts(Subform) Contacts Name Phone List(Subform) Phone List Number In another form name "Add Phone Entry", I have the following fields: Student(Lookup of all "Students" in the system) Contact(Lookup based on what "Student" the user selects) Phone Number(Lookup based on what "Contact" the user selects) I am having a very difficult time accessing the subform values. Any help in this matter would be appreciated! Thanks.
logging zoho remotely
I have a wordpress website , and zoho account , what i want is when i login to wordpress i also get login into zoho. Problem is 1) i am not able to do that using SAML ( onelogin ,miniorange ... others too ) 2) Secondly , my wordpress user donot exit in zoho and vice versa 3) If i register in wordpress i should register in zoho user. But i amo not getting any idea hot to do this everything is getting complicated.
Debounce / Ajax problem with Lookups
We have found an issue with Lookups in our Zoho creator application where typing into the field does not not return all records which match that text! For example, if you type "dif" in our lookup it only shows up one record. (just typing the letters at a pretty normal rate) However if you type 'd' then 'i' then 'f' waiting for the ajax call to finish each time you get (correctly!) all the results that should be found This seems to be a pretty significant bug in how your ajax calls (or whatever you're
Pushing Data from Zoho Creator App to another
Hi All, Is there any way I can push certain data from one zoho creator app into another ? Basically I have an app that we use to book and track laptops and/or desktops coming back to us. In certain situations we will know these are coming back broken. In those instances, when the drop down is selected as "Hardware Replacement" I would like the app to open up a ticket in the repair log app we have and copy the main reference number and the asset number across. Is this possible ? Kind Regards MattP
how to make table with checkboxes?
hi how to make in application table with checkboxes like on picture? for each checkbox there no any descriptions. example: for messages type №1 - send email, send SMS for messages type №2 - send SMS, send twitter for messages type №3 - send SMS and so on
Need a mentor in the Detroit area.
Hello, all. I have been trying to get started with several Zoho apps, and I am running into a pretty big learning curve.This is not my day job, but I have a lot of time invested exploring what I can do. I either need someone to develop for me, or to help me learn. My preference is to find a mentor who can get me going more quickly. I have found that when I try to hire the work out, it can take too long to get the idea across, and then I am not getting what I need. I work in a health care setting,
Deluge Map From Zoho Books to Dropdown List in Creator
Hey guys, In Deluge, I'm getting all my items from Zoho Books into a map. And now I want to insert all Item Names into a dropdown list in the form onLoad(). How can I do that? I know I can add stuff to my dropdown list doing this: Dropdown:ui.add("Item_name"); I'm getting the items likes this: myMap = zoho.books.getRecords("Items", "123456789", "name"); I'm doing info myMap and it returns this: {"code":0,"message":"success","page_context":"{\"per_page\":200,\"sort_column\":\"name\",\"custom_fields\":\"[]\",\"applied_filter\":\"Status.All\",\"has_more_page\":false,\"page\":1,\"report_name\":\"Itens\",\"sort_order\":\"A\"}","items":"[{\"created_time\":\"2017-02-21T11:52:03+0000\",\"reorder_level\":\"\",\"last_modified_time\":\"2017-02-21T11:52:03+0000\",\"item_id\":\"571662000000056054\",\"item_type\":\"sales_and_purchases\",\"tax_name\":\"\",\"is_linked_with_zohocrm\":false,\"purchase_rate\":1.23,\"description\":\"\",\"item_name\":\"Farinha
Embedding Creator page in Wordpress site - implications?
I am hoping to use a couple of Creator applications embedded in a Wordpress site, and have a couple of questions if anyone can help: 1. We want to have users to be able to post an individual record to social media via a button link. One of the applications is an event calendar, the other a directory of businesses. Is it possible to include a button in each record displayed to post to Twitter etc, and have the posted link pointing back to the specific record? 2. Are there any SEO implications on what
Calculated value in form field not showing up in Report.
Hi, I wrote a small script to calculate a CURRENT DUE value based on a few other fields. The script is below. I have it attached to run when a user EDIT’s the form. It works fine in this context. However, when I create a report and include this field (CURRENT DUE) in it, the value is incorrect. Sometimes it’s zero, other times it’s another value. But in every case so far it’s not the correct value. Do I need to attached this script to a different user action to have the CURRENT DUE value appear
Formula: Difference between 2 dates displayed as weeks and days
Hi all, Could anyone help me creating a formula that calculates the difference between the current date and another date from my form and that period of time to be displayed as xx "weeks" and y "days"? The formula field that I created so far has the following expression: ((zoho.currentdate - Data_um) / (1000 * 3600 * 24 * 7)).round(2) but it shows me the period of time like xx.## weeks which I am not so happy with. Is it possible to show that field in the report only if that computed value
Count through variables
I have a form with fields named like this: Field1 Field2 Field3 ... ... ... Field10 Rather than writing validation for each field individually I want to write a loop that iterates trough each field based on a counting variable after clicking submit, for example: $count = 0 Do { count++ if ("Field" + $count == "value") { Do something } } until ($count == 10)
Trying to get the Sum of a Currency held variable
In the function below, I am trying to get the sum of a series of Currency variables (student.p1amt, student.p2amt, etc...) When I run this, I am getting the concatination of the strings, but not the sum of the numbers. How can I change this to sum the values and store them in the 'amtDue' variable? Thanks! Mike void PaymentsSpace.PaymentsDue() { amtDue = ""; for each student in Students [ID != 0] { info student.First_Name + " " + student.Last_Name + " " + student.p1rec;
Limitations horror !
" A function calling itself (also known as recursive function) cannot be called more than 75 times. If the limit of 75 is crossed, it throws an error "Call Stack limit exceeded" ." I am planning to create medical system to hospital , Limitations is the ghost who stopped me to continue with zoho creator , Can you imagine when application stop because user exceeds the daily function call for example ! perhaps I have misunderstanding on this point, I tested report button with use of function more than
Reporting with sub forms
Hi there, I'm trying to create a report, within Zoho Creator, that pulls through data from a sub form. However I want 2-3 fields from the sub form to show in separate columns in the report output, rather than in one. Is this possible with Inner Joins or an easier method ? The main form is called Service/Claim Request, the Sub Form is called Product Details and the fields I want to pull through from the Product details report are: Product Type Serial Number Asset Number Appreciate
Changing column width in PDF report?
Hi Zoho, I have an email with a PDF rent every week to certain users. How can I set the width of the columns in the report? Adjusting the column width using the report "column properties" views ok on the browser it but on the PDF all column are distributed evenly (not the preferred option) Thanks! Ravid
Check if all the fields are full
Hi, I have a form that has 80 number fields. I want to check if all of them are full and then send a mail. I know I can do something like: If ((field1 != null) && (field2 != null) and so on until && (field80 != null)) { sendmail } Is there an easiest way? without having to write 80 times the condition.
Custom Modules
Hi.. I am trying to retrieve a record from a custom module in CRM. However, when I try to read the individual field values I am just getting null values. In the example below r1.get("customer") returns null value, is there a naming convention i'm not aware of ? crmResp = zoho.crm.searchRecordsByPDC("CustomModule2", "customer", "xyz123"); if (crmResp.size() > 0) { for each r1 in crmResp { input.Customer= r1.get("customer"); } } else { alert "No machines
custom button on stateful form
Is there a way to include a button or hyperlink on a stateful form that would enable one to call a function in the manner of a Custom Action on a report? I understand that you can do it on a stateless form, but stateless forms are a lot of extra work for such a simple request.
Javascript forms to Creator ?
Hello I see CMS like lightcms provide html,css & javascript ability to design the site, Can I create forms in JS to send / receive data from Creator & CRM ? Thanks Fahad
Need Help :How to pass/retrieve the values from query string
Hi, How to pass the values by using querstring and retrieve it in another form.
Integration to Mercadolibre with Post url Task
Hello, I would like to make an integration to Mercadolibre (ebay mexico). At the moment I want to do something like update some basic data but I do not get it to work and I want to know if the code I have at the moment could work ... http://developers.mercadolibre.com/products-sync-listings/#Update-your-item I try to integrate with third party apis using get / posturl tasks. I recommend it, I'm not sure if it is possible. Header_map = map (); Header_map.put ("Content-Type", "application / json");
Pivot table filters old data?
Hi! So to explain this easy: I have a form with columns and rows. The row has numbers (ID) and a column value which can be set to true or false. Entry with ID 1 has the column set to FALSE. When I filter the pivot table that I only want to see the entries which are marked as TRUE - it shows up. As TRUE! Even though it is not. In the Zoho Report popup Windows the value is TRUE But when I check the list - Its FALSE. Seems it has cached some old data? Is there a way of fixing this without having
Is it possible to integrate creator with zoho projects?
I would like to integrate creator with zoho projects. Is this possible?
numbers into words
Hi, I have decimal field in a form.I need convert that field number into words(for example: 123654=one lakh twenty three thousand six hundred and fifty four).I try to write a function to convert that number into words but it didn't work.I also referred in zoho forums for that,But It has a code for international numbering system(BILLION,MILLION) ,not for INDIAN NUMBERING SYSTEM(CRORE,LAKHS). kindly help to write solve it. Thank you.
Public Zoho creator page
hi everyone - was wondering if I could get some direction on a zoho creator page...I have the report ready to go, but in order to have it look like I want to with the custom css, I need to have it embedded in the zoho creator page itself. However, when I go the Publish option under the Page/Settings/Publish, it gives this if I am not logged in: This report is not accessible. Sorry Public, you are not allowed to access Featured_Resorts. Please contact your administrator to get access. I assume this
concatenate text fields with hyperlink fields
Is it possible to concatenate text fields with hyperlink fields? I have 4 fields: text1, text2, text3 and hyperlink. I need to have them together as: text1 + text2 (with the hyperlink hided) + text3.
Next Page