Percentage and deluge
I am trying to update a commision value field with certain values based on two parameters, but are not doing this correct as getting errors, have not been able identify exactly how I need to code same in the help section hence reaching out here. What i want to achieve in this case is when Pay At equals DEBRVTM and Currency equals USD the ADDCOMPCT should update to read 1.5% The two determining fields are radio buttions and the ADDCOMPCT field is percemt field. Current code as below. if ((input.Pay_At
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
Military Time Date/Time Picker
Has anyone come up with a work around to change the date/time picker to show standard am/pm time? The military time is just not useable for our purposes, so we can't use the date/time picker unless it can show normal time.
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
How to display total numbers in a report?
I created a form and added number of records. The problem I have is that the report shows each record separately. Is there a way and how would I create a report that would show the total for certain period of time. For example: I would like to keep track of all rentals I have made. I enter each rental into the form. In the end of the month I would like to print a report that would show total numbers from all entries in that certain period of time - like total rental amount for the month, total tax
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
how to set age field to autopopulate based on DOB field
I'd like to create a field in a form that is called age and have it automatically calculate based off another field called Date of Birth. Is this possible?
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
How do I make a report with the last record for each employee?
Basically I have a report that displays records (evaluations) for each employee. I would like to have a second report that will display only the last record for each one. How do I do this? What option/filter would I use to display last record for each employee?
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.
Notes visible in a Report
Hello India ! Does anyone knows here if it is possible to show a note of a form on a report? thank you
Check if a string can be converted into numeric
Hi, Is there a way to create a function to check if a string can be converted to numeric ? isNumeric I'd like to convert kg in lbs but I want users to write "N/A" or other text instand of numeric values. I setup 2 fields. If the user write text, I want to copy text, If he enter numeric value, I want to convert. Thanks for any tips. Pascal Veilleux
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
How can i group a list of input fields?
how can i group fields in a form, to call them in my workflow since a variable?
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.
Auto Generate field based on other fields
I was wondering if i can create a field that will auto generate using what i picked in the form for example. I am creating a form for clothing inventory and I have the following fields Brand - Nike Type of clothing - Shirt Size - L I was wondering if i can generate a autonumber based on what i pick./ So it wuld generate NIKSL003 This number would not repeat Any Ideas??
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.
Calculate distance betwwen two area
I hv plan to create app for car booking like OLA,UBER. Is it possible to get source and destination place from map and calculate the distance b/w two area. Pls Suggest any idea to make this app.
I seem to have locked myself out of my own app
I created an app under my personal account then authorised my work email address to be the administrator and demoted my personal account to Manager. What has now happened is that regardless of which account I sign in on, it reverts to my personal account and tells me I am not allowed to access the app. I had expected that my work email address would become the CEO/Administrator and I'd go from there... I realise now that I should have kept my personal account status as CEO and left the work account
Lost all my data
Hi, I have been trying to create a rect tracker. I had loaded a lot of data and now I find that all the data is gone. Can you tell me why this happenned? What is the security level that is currently there on the site. Pl let me know. Also if I want an audit log of the users can I have that. PLEASE HELP!!!!! Rgds Raghesh rdasannachar
edit entry by record ID only having link
hi how can user edit zoho creator's entry by record ID only - if user has only a link to this record - user do not authenticate himself on creator.zoho.com https://www.zoho.com/creator/help/views/editing-records-via-record-id.html so - how to edit record without authentication and only have a link ?
Just starting out. Is Creator the right choice?
I'm just starting a new project. Its a (minority) sports results system, where members of the sport can input their results and see how they compare to other members. Stats need to be run on the whole results list. Simple database stuff, but with a few thousand end users. What would the cost be? I also want it interactive so people can put their own personal goals in and training plans and have the app return achievement awards. I want the users to link to their trainers and and so the trainers get
How to display image from previously submitted form
Hi, I am trying to display last submitted image in current form. Coll = Form [ID != 1] sort by Added_Time desc; input.ImageBox = Coll.ImageBox; Nothing happens unfortunately. On my mobile it shows loading .....
Lookup fields
Hi. I have 2 forms. In 1st form i collect all data about land plot (number, cost, status, square etc) - it's form like databes - only for administrator. In 2nd form i want to add lookup field "Status" ( dropdown type: sold / free) from 1st form for manager. But i can't do it, i don't see this field in lookup type.
Next Page