Sum all numeric fields from subform and show the result in a field in basic form
Hello, i am trying to create an app to follow the payment of my customers. In the basic form (form1) i have the customer details and one numeric field where i write the total money i have agreed with my customer. In the subform (subform1) i have the payments, one record for each time with the fields "Date", "Amount" and "bank name" I want to add all the payments, substract it from the total and return to me the money my customer owes to me.
Problems with dynamic picklist and pull data without using look-up
I have 4 forms: 1)Customer info which has customer info and customerID(customerName + phoneNumber) 2)Customer site - a customer can have more than one site. 3) Consultant info 4) Site info is generated by linking 1+2+3 and it has unique siteId(Customerid+ customerSite) 5) In order form, a) When I input customer name, customer number is inserted using look up and customer id is also generated. b) I want a drop down(dynamic picklist) where related sites for each customerid are listed down when name
Deluge Scripting
Is anyone aware of any books which could help me learn Deluge Scripting. I am not a programmer by profession. Thank you in advance.
How can i filter my records in the sub form based on the main form field selection
Hi, I am trying to filter the data in the sub-form based on the field in the main form. Can i do the same? Thanks, S
Install APP from zoho.com to zoho.eu
Hello, we have account at zoho.eu. With an account created in the EU, can not be login to the marketplace. We created a zoho.COM account and installed app and exported app to .ds We tried an inport .ds file on our EU account. After import the file, the page redirects to the marketplace and returns to the home page of Creator and nothing happens. APP: https://creator.zoho.com/platform/public/showAppInfo?canvasurl=mzxpuwhdg&refererUrl=search%3FappName%3DBasic%2BInventory%2BManagement%26category%3D-1%26limit%3D10%26count%3D1&refererText=Back%20to%20Search%20Results
How do I filter the results on a embedded report using URL parameters?
Hi All, I am trying to create a project dashboard/page that has a few reports that all are filter with the results of that particular project. At the moment I am using a stateless form to change the url parameter of the parameter ProjectID, but the embedded reports do not filter the records to the URL Parameter. At this point I am using the page builder in the new builder. When I embed the report I set the filter to equal the input.ProjectID which auto populates as I have set it as a parameter in
Icon in the top rigth in Creator 5 Portal page
Hi, I have a small icon in the top rigth corner of my app. I'm using portal. See attached. What is this? Thanks!
inconsistency with built in function subString() function
I am trying to generate a part of string which requires subString function. For example If I want to extract between 3rd and 5th index for the word Tamilnadu, I have to do the following x = "Tamilnadu" x.substring(2, 5). a)Since it is based on zero index it should actually be x.substring(2,4) b)in the case of indexing starting with 1 it should be x.substring(3,5) Isn't it a bit confusing?
HTML Views Stop Working
Hi, All the HTML views from all my apps stop working, the Usage Logs do not record anything.
Build excel rater/calculator in Creator
Looking to replicate the attached rater in Creator to then be able to embed into a landing page. Is this possible? Where to start?
Criteria matched value to show up in drop down automatically
Hi guys, Kindly help me for following two things. When I use lookup filed, the value that matched with criteria (only one value) cannot show up in drop down (Look Up Field) automatically and I need to choose again for this value. How can I overcome this ???? Please refer me for sample script. can I pass parent form's field input value (From Look Up field drop down) into sub form and also vice visa. ??? BR, zzw
Import from Excel - Date not working
I am trying to import data from Excel. I exported my data from a ZoHo view to make sure I have the correct headings and columns. When I try to import the same file which I just exported, everything works fine except the Date. My Date field is a Date-Time. It exports to excel as "Apr 07, 2010 23:27:28". The cell is formatted as "mmm dd,yyyy hh:mm:ss" When I try to reimport this same exact file back into Zoho creator, the date time field is blank. I have tried to change the format in excel
STRING and right expression is of type BIGINT and the operator == is not valid
Please Help. This should be so easy? I have a lookup field to select an item by size from another form. Now all I'm trying to do is automatically update the price of the item to a field called total. if (count(iPrices[cabSize == input.cabSelect]) >0) { temp = iPrices [cabSize == input.cabSelect]; input.total = temp.ssPrice; } else { input.total = 0.00; } ...Error -> STRING and right expression is of type BIGINT Thanks for your help.
How can I create a download button on a report that downloads the file but doesn't show the file field?
I have created a document library. I realize that if you add the file field to the report the user can download the associated file by clicking the file name in the file field on the report. I don't want to show the file field on the report. Instead I want to show just a field for each record that shows a download button, that when the user clicks the button, it downloads the associated file in the file field.
Changes in Usage limit for free version in Zoho creator?
Hey, We have an application for internal process, which we have been using for the last one month. We had 6 active users, but all of a sudden today, all except 2 users got deactivated. When we tried to activate the users, there was a pop-up notifying to upgrade a paid version. Not sure if something has changed in the usage limits for the free version. Has anyone else faced the same? Thanks Vikas
Subform Data
I am wondering how the data entered in a subform is stored. Is there a hidden table under the hood with a foreign key to the table for the main form, or is it somehow serialized and stored in the main record. I have looked through the documentation for these details, but I have been unable to find any information.
API Integration Basic Authorization postUrl()
Here is my code and I am getting Internal Error for postural() call. By the way, one more thing I want to know how we can use verify_peer to 0(zero) for not using SSL things. What is wrong with my code? void SendSMS(SMS SMSObject) { //CONFIGURATION URL = "https://example.com/send_ack.php"; wbLogin = "wbLogin"; wbPwd = "wbPwd"; wbAccount = "wbAccount"; label = "label"; applicationName = "ADR SMS v1.0"; //BASE64 ENCODING Base64Encoded = zoho.encryption.base64Encode("httpLogin:httpPwd");
Do I pay a 1 time fee for the Customer Portal or each time based upon my app?
If I pay for the customer portal once, will that allow me to create a sepearate customer portal for each app I create or will I have to pay an addtional fee for each customer portal for each app I create? SC
Each MULTISELECT value INTO a separate ROW
Hi, I have a FORM (in Zoho Creator) with a MULTISELECT field and a SINGLE LINE field. The form is connected to a table in Zoho Reports. I would like to add each selected field in the MULTISELECT as a new row in the table. If possible copying the SINGLE LINE field in each row. Example The Form Barcode No - Products AB12 apple, melon The Table AB12 apple AB12 melon This is the script I am currently using: creatingMap = map(); creatingMap.put("Barcode No", input.Barcode_No);
scanning barcodes and the Customer Portal
I have a page that scans in a barcode and retrieves info based on the scanned value. It works perfectly. But...I can only get it to work if I'm using the ZOHO mobile applet to run my app. I can't get the scanner to appear if I use the app via the Customer Portal. I know that using the barcode option is only available for mobile devices, but since I can have potentially lots of customers using the app, it makes sense to use the Customer Portal. So...is there a way to make the Customer Portal know
Export record summary as PDF and rename it based on existing field
Hello all, I am trying to figure out a way to have a customized button designated as "export as PDF" when viewing a record summary from a report but the goal is to have the PDF file renamed based on an existing field when exported. I found some topics talking about generating a URL with a preferred name for the pdf but cannot seem to understand how to implement it. Any help? Thanks!
Mapping Zoho Creator fields to Zoho Subscriptions
We are currently doing a ZOHO Creator to Zoho Subscriptions integration and are unable to map the billing address fields in Zoho Subscriptions from Creator. We are able to map fields using the following format params.put("display_name",input.Display_Name); but the billing fields seem to be an object as below. Is there a way I can map the object/array fields? billing_address": { "attention" : "Name" "street" : "Street Name" "city" : "City" },9 },
Zoho Creator Migration
Has anyone else had issues / delays getting Zoho to migrate from .com to .eu. We have been told for weeks that this would be carried out without any progress (as far as I can see getting made). I just wondered if anyone else had the same issue?
Training Resources in Creator 5
Can anyone recommend some good training resources for learning and using Deluge in the new version of Creator? I am new to Creator, have an IT background and I'm trying to teach myself but I'm having a lot of trouble understanding and navigating the new layout of the Script Builder and Expression Builder. The "newhelp" documentation still references the old layout and it seems so much more intuitive and user friendly compared to the new 'wizard' based style of building scripts, especially with
Sending out files
Hi Zoho, I have a form with a field to upload file. I'd like this file to be saved on my Google Drive directly. What is the best way to do this? (Currently I have a schedule to send the file to my email and from there it's saved using a Google script, but I feel this is not the best way to do this...) Will appreciate any idea. Thank you Ravid
How to discount an initial amount
in a form I register a number of folio and an initial amount, they with that number folio in another form through a lookup, select the folio and load their expenses, I want the initial amount to be deducted their expenses that go up day by day and be reflected in a report
Mandatory but hidden fields silently cancel Submit
Hi team I have a Creator form that does not save to a Creator table because it's a public access form (Stateless). On Submit it takes a bunch of actions like emailing the form info. The form has a Radio Button field that controls which fields should be shown/hidden further down the form. Problem: Most of those further-down fields need to be made mandatory. BUT if they are hidden by the Field Actions of the earlier Radio field, there is no way to submit the form. Submit silently doesn't work.
Application Sections in Creator 5
I have my forms arranged in Sections in the old version but in Creator 5 I don't see an option to move a form between sections. Can anyone tell me how to edit the Sections in the new version? At the moment I'm doing it by reverting back to the old version and then going back to the new version again.
if ( condition ) for C5
Anyone have same issue with new C5 The new version C5 has been problem for me with Deluge Script in many times my if conditions for the Operator<opr> has to be in reverse. For example; Correct statement should be "if(Sch_Weekday == 2)", but I have use Operator<opr> "!=" (not equal) in reverse. if(Sch_Weekday != 2) { input.Monday_Date = input.Sch_Effective_Date.addDay(7); } else { input.Monday_Date = zoho.currentdate; }
How to create recurring revenue with Zoho services?
Hi Team, I am looking to create a software company where I can provide consultancy to companies and help them improve their business processes by using Zoho services. Before that I want to understand how can generate recurring revenue from Zoho services. Looking forward to this community so that I can achieve my dream. I want to create $10k to $15K per month. If anybody already working on something similar we can do something together also. Thanks
Backup and download all attachments
Hello, I am trying to backup and download all the data and file attachments stored in my application. I can download all the data without problem. But I don't know how to download all the attachments together. To do it one by one is not an option. I have been trying to find a solution in the forum without success. I found a file downloader tool but I cannot login. Could you please tell me how I am supposed to download all my data and attachments at once? Sincerely Jacobo
Report doesn't filter based on contains/doesn't contain criteria for checkboxes
I have a form with a checkbox field and I have created different reports to show data based on checked boxes. For example: Opciones does not contain "Factura". show all rows from Nueva_venta [!Opciones.Contains("Sin factura") && Distribuidor.Facturacion.contains("Individual")] This is not working and it's still showing all records.
New Page Builder - openURL in different panel?
Is it possible to have a button on the page open a URL into another panel on the page, like how an iframe works?
Workflow Not Working as Expected
I am trying to use Zoho for Risk Assessment calculations I have written this code if(Liklihood = "Low") { L_number = 1; } if(Liklihood = "Medium") { L_number = 2; } if(Liklihood = "High") { L_number = 3; } if(Impact = "Low") { I_number = 1; } if(Impact = "Medium") { I_number = 2; } if(Impact = "High") { I_number = 3; } Total = I_number + L_number; if(Total <= 3) { input.Single_Line = "Accept"; } if(Total >= 4) { input.Single_Line = "Manage"; } I have a field on my form with a deluge ID of Singl_line,
How to concatenate text fields on input
When entering name and address data I want to be able to copy and paste the concatenated data into another application. I have setup a Formula so that i have input.Name+" "input.Address+" "input.Town I get the following warning All reports involving this field also will deleted Do you really want to change expression? what does this mean??
Is it possible to hide or show a field conditionally once the record is saved in view and or report?
As the subject line stated, would it be possible to hide or show fields conditionally in view and or report, once the record is created and saved? Here is a sample voucher that I would to create: Created record after the following data entry Surname: Mitchel Age: 22 Gender: (X) Male (this radio button was selected) (O) Female Weight in lb.: 170 ---------Form the newly added record---------------------------- I would like to view or print the above record after it has been created (conditionally)
Need help in updated a record when a linked field is entered
I have two forms: Form 1 - Order_form Form 2 - Booking_Details In my booking_details form, i have a v lookup which links to the order number in Form 1 (Order_form). This is a drop down option where the customer can select the Order number. When a user selects the order numbers, I want the system to fetch relevant date to populate 2 fields in Form 2 . These fields are : Customer_name_bookingform and Port_of_Discharge . In Form 1 ( Order_form), the required date fields correspond to the following
How to Fetch Records for "this month"
Hey! Need some help with a fetch records request. I want to fetch records for "this month" based on a field called Next Occurrence (or Next Occurrence Date-Time, if an actual Date-Time field is required... Next Occurrence is only a date field) Here is the script (which works to fetch the records with the given criteria) KathiExpenses = Add_Expense[Owner == "Kathi" && Category1 != PaycheckCategory] sort by Start_Date; I assume I need to add a criteria of && Next Occurrence == "whatever necessary to
Iterate in a loop based on certain condition
Hi, I want to iterate between from date and to date and do certain tasks on each day increment based on the day of the week. How can I do it.. Pls. help Thanks, Milind Manohar
Access Form Image fields in HTML page using fetch records task
Hi, I have a form for Bikes master with Bike photographs (as image field) and I want to use these images in my HTML page using fetch records task. How can I populate these images in my HTML page. Once populated, I want to invoke an order form when a user clicks on the image. What should be image source for these images as they are somewhere on ZOHO servers. Thanks in advance for helping me out. Thanks, Milind Manoha
Next Page