Confirm submission option for stateful and stateless buttons
Changes to data that have large consequences should have 2-factor confirmation. It would be useful to have the option to enable a 'Confirm Change' for buttons in both stateful and stateless forms. The button editor could have a toggle to turn confirmation on/off along with a text box to configure a custom message that would display in the modal confirmation dialog presented to the end user. The modal dialog would have 2 buttons: OK and Cancel.
Add amount every time form is submitted
Hi! I have a report of contractors and I also have a form to record each time I pay them. I would like to see the total amount paid on the contractors report. Below is the Pay_Contractors form And this is the report of another form called Contractors I would like to see the total amount paid for each contractor. How do I accomplish this?
Simple way to track rent received from tenants
Hello, First off, I'm totally new to databases, forms and the terminology so please bear with me. I manage a property with 50 tenants. I'm trying to create a way to have a list of current tenants that includes name, site number, monthly rent amount, and what they are paying for. I then need to be able to track the date we received their rent, amount received, payment form (check, cash, credit) and their rent paid through date. Some people pay multiple months in advance. Then ultimately an easy
How do I parse JSON to use variable? toMap and getJSON are confusing...
Hey Everyone! I would love some help with this. I'm stuck. I have the following JSON. { "result":[ { "bearing":-1, "currentStateDuration":"00:53:14", "exceptionEvents":[ ], "isDeviceCommunicating":true, "isDriving":false, "latitude":34.9946861, "longitude":-106.659889, "speed":0.0, "dateTime":"2017-03-02T19:31:44.000Z", "device":{ "id":"b1" }, "driver":"UnknownDriverId",
Pass dates to OpenURL
I am trying to create a stateless form that has two fields a Start Date and an End Date. The idea is to pass these dates to the OpenURL and generate a report based that includes all the dates between Start Date and End date. but when I follow the example on the functionality based URL's, my report does not filter the unwanted records out. openUrl("https://app.zohocreator.com/notjustanothername/order-management#Report:ALLORDERS?Order_Date=input.Start_Date;input.End_Date&Order_Date_op=58","same window");
Rich text fields in Subforms
Hello. When I create a field in a subform, I get the following type options: As you can see, Rich text doesn't appear as an option. Is there an alternative way to use Rich text fields in a subform? Thanks in advance.
What does it mean "Error at line 0"?
Here is the function that I wrote: map externalapps.GetCurrentSymptoms() { symptomMap = map(); for each Symptom_ID in Symptoms [notContains(Symptom_Name,"Deprecated")] { symptomMap.put(input.Symptom_ID,input.Symptom_Name); } return symptomMap(); } When I try to save, it gives me this error: Error at line number : 0 Mismatch data type for function 'put' at argument index 2 expected data type STRING found data type SymptomsI don't really know how to debug this one? Symptom_ID
Prevent duplicate item on same date
Hi! When I am adding a new record, I would like my dropdown menu (that is in the form) to grey-out the items that are already recorded on the same date as the field in my form. In other words, I would like to prevent an item being double-booked on the same date. How do I do this? I would like for the dropdown of "Facade" to grey out any other items that are being used on the same date. The date is in "Date of Event". I should also mention that "Facade" is a lookup field.
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
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
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
Next Page