Google Drive function?
I've find this Google Drive function in deluge script... any news?
HI
even though i publish my website i cannot access my website :( it indicates that web site cannot be found (DNS PROBLEM )but the site publishes sucessfully
19-digit number replaces the original data in report column
Hi An error has shown up yesterday in a report. Instead of the proper data - in this case the name of the assigned caseworker ("sagsbehandler") a 19-digit number shows up. Same goes for the assigned consultant (konsulent-kontaktperson). When I group the colums by caserworker or consultant it will readily display the name but not when they are just data in a column. Please have a look at the attachments. I thank you very much in advance for your help. Best regards Thomas
Can't delete profiles
I have created an app and shared it but they can't log in. An error message pops up saying that they are logged in but they can't access the app. Your suggestion on the topics is to delete the profiles, "Deleting the roles and profiles for the user will solve the issue. Please click on the below link and follow the steps to delete the profile. https://www.zoho.com/creator/help/security/clone-profiles.html#Deleting_Profiles But there is no "X" to delete a profile and the edit is greyed out. I only
triple column
Hi Is it possible to create a triple column as it is possible to create a double column on the form of zoho creator? thank you
Customer Portal & Ipad App & other issues
I have a few questions about the customer portal We created a customer portal user, but: A. The customer can not log-in using the iPad app. Does a user of the customer portal not have use of the android and ipad creator apps? B. When they log-in the old version of zoho creator is what appears. What needs to be does to insure that the new ui appears when a user logs in through the customer portal?
to populate a subform based on a form
Hi, I have a form named "inventory" with product_name and quantity. I would like to have a new form named "inventory entry" with a subform that populate each product_name in order to fill the new quantity to add. How can I do it? Thanks, David
Free form Deluge code displayed differently than it is saved and executed. Subsequent edits cause errors.
First example: If I switch to Form Builder view and then back to workflow view, the line: lstAnswerChoices = recAssessment.subAnswerChoices.ID.getall();is changed to: lstAnswerChoices = recAssessment.subAnswerChoices.getall();If I then try to save without making any changes I get an error. Second example: If I save the following line and navigate back to the function, it is displayed without the first set of parenthesis which returns a completely different result: strDisplayName = (rec.rtfQuestion
Can I create an App to calculate Selling Prices?
I want to be able to calculate selling prices for Items in Zoho Books/Inventory, based on a number of factors including: - The buy price in currency - The Currency Type for a Vendor - The exchange rate - etc Can I create a Zoho App using Creator to do this, perhaps triggered by a custom button in Zoho Inventory? John Legg Owner: The Debug Store
Precreator.zoho.com unavailable anymore?
I remember being able to access https://precreator.zoho.com/ to get the latest features in beta for ZohoCreator. However this morning, the link is dead. What happened ?
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!
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,
Next Page