Is the zoho creator totally free by allowing multiple users in employee management application?
Is the zoho creator totally free by allowing multiple users in employee management application? please reply
Skip errors when inserting rows
I need to write a Deluge script to insert 10,000 rows into a form from another form. How do I skip error rows when "unique key" condition is not met, but continue with the other rows? Thanks. Also looking for a full Deluge training manual.
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
How to replace the value (not id) in a lookup field with data in a lookup field from a different form
Hi there, It's days that I am facing this problem, and hope someone can show some light on this. I am a newbie to Zoho Creator. I am trying to create a Job Card application through Zoho Creator so I have created so far a form named "Suppliers" where I can store all the details of the suppliers of machines we sell, in this form I have also created a subform called "Systems"where I store the different machines model name. Then I have created another form called "Machines" where I have implemented 2
Check for duplicates using two fields
Hi, I have a form where I enter different types of products for different countries. So the form has two fields: Country and Product. I would like to make sure that there is only one product entered (no duplicates) for each country. I can't simply set the product field to unique, as this would not allow me to have eg. 'beef' in both Italy and Spain. I there any way to have the system check whether a product already exists for a given country? thanks, Anne
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.
A too long form
Hi everyone, I have a form which is very long and complex, i would like if possible to segment it into several forms. For example, based on the Conditional output of form A, the sister form : form B will be prefilled and/or precreated The forms should be in a certain manner be interconnected to each other's My problem is : 1 I don't know how to interconnect to Form 2 i don't want to create millions of records for the same implementation thank you
How can I visualize an image that I have in a report and be able to see it on a page html?
This is the image the the report contains. And this is how it appear in the page html. how can i do so that the same image apper to me in the report?
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
Add Verified Email Address
Hello, Newbie question: I do not see the option to add a "verified email" address in my form's email notification page to allow me to use a different email than the default zoho.adminuserid in my script. Any ideas? Andy
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
How to create custom search bar on with stateless form.
I want to be able to have a search bar on a stateless form that lets me search (by last name) 3 different forms records and then list them below the search bar separated in three different sections (for each form). What would the script have to looks like for this to work. Thanks a ton!
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.
Sendmail not working
Is anyone else having and issue with sendmail not working? We have a couple of sendmail scripts that have been working for over a year and have suddenly stopped working.
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
Next Page