Trying to relate a form to the same form (ie: relate one product to
another product)
Any ideas how I can approach this? Scenario: I've 3000 parts & products. If I search for a product X, I want to view all related products or parts to Product X. EG: View a lamp and see the related bulb. If I view the Bulb I can see the related products. It must be a many to many relationship. A Lamp can have many related parts and each part can relate to many different lamps. Thanks in advance?
Invoke a function with multiple arguments
void SKU.generar_stock_Sku(Compras_de_Skus cn) { sr = SKU [Secuencia_Secundaria = cn.SKU_Secundario]; st = Stock1 [Origen == cn.ID.toString()]; x_x = Stock1[Status is not "vendido" && Numero_de_Serie == cn.SKU_Secundario].count( ); sr.Piezas_compradas_historicamente=x_x; } I have a function with an argument (void SKU.generar_stock_Sku(Compras_de_Skus cn)) This function (it is only part of it actually), generates registration within the "Stock1" form. -Now I want to be able to update
Update field when adding row to subform
Hi, I'm having trouble getting a script to work when trying to add rows to a subform. I have a subform called Tasks on a main form called Jobs and when I add a new row I need a field called Task_Unit in the subform to populate when the lookup field SOR_Code is added/updated. I have attached a screenshot of the subform showing how the Task Unit value is duplicating from the initial row (regardless of how many rows I add) , rather than taking the correct value from the lookup relationship (field
Change "null" to something else?
Hi Zoho, When I fetch a record that is empty I get "null". Is it possible to change the default "null" to anything else? (NOT by using a function for each fetched variable.... I mean from you end, or is it possible from the Zoho settings?) Thanks Ravid
Zoho Creator app creating duplicate rows on update function
Hi Team, Problem We integrated vendors app of Zoho creator with CRM. Everything was running fine & since last few days Zoho creator app has started creating a duplicate record on every update. Are we the first one to encounter this or somebody else had the same problem before?
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
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
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!
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.
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
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
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 },
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
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.
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,
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
Record Summary Alignment/Paragraph
Hello All: I have not used record summaries much to this point and am running into two issues with a proposal form I am setting up. When I set up an image or paragraph to be centered, it is not centered on the page when printed. I selected letter size for the record summary but it is still off. Also, I have a paragraph that is cutting of the last couple of words on each line on the right side of the paragraph. It doesn't seem like it is wrapping the text correctly. Any insight would be greatly
Only getting one record returned in my Page script
Hello, I am having a hard time figuring out this script for a page I am creating. As far as I can tell, it should be returning several values, but I only get one record returned. I am trying to get all the expenses for owner Kathi and show the payee and amount. When I write my script and access the page, I only get the last record to appear in the table. I do not understand. Can you look at my script and tell me what I might be doing wrong? htmlpage expense_test() displayname = "expense test"
Old records
Lets say that we are May 1st. I want to see records that are before April 15th. So I want to see the records before the last 15 days. Is it possible? Thank you
Auto-populate Sub-form Value
Hie , Have Three Forms A, B, C In Form C have 2 Single Line Fields In Form B have 2 Lookup Fields , a1 and b1(Based On Form C) In Form A have Sub-form (Based on Form B) whenever any customer fills Form A with Sub-form ,when value of a1 entered, automatically b1 value will auto-populate How we can achieve this? Thank you in Advance !!
Subform Lookup Field - no search option on mobile device
We have a Creator form which has a Subform. The Subform has a Lookup field linked to another module. That other module has over 800 records. When selecting the Lookup field value on the Web/Desktop interface, user can start typing text and selections will filter based on contains text. But on Mobile device/Creator App, this is not possible? User must scroll and find only using very big list. Please advise if there exist a workaround.
iPhone app does not work
Hello everybody, I use Zoho Creator (great app) and I wanted to also use it from my iPhone. I installed the last version, logged in and ... nothing. The app seems to reset to the initial state (little button to login at the bottom of the screen). Can you help me out? iPhone 7, iOS 11.3.1, Zoho Creator 5.9.4
Send Confirmation Email from Email Address other than zoho.adminuserid
Can anyone recommend a deluge approach (or 3rd party plugin approach) to allow for sending from any outside email address (smtp, etc...) other than from deluge defaults of zoho.adminuserid and zoho.loginuserid ??? Surely there is a method to call email functionality from outside zoho?
Search interface for dummies?... Please?....
I need a simple search interface to allow users to search one field at a time. I've found the "search function" template, I've created a stateless form, I just can't get it to work. I know the field I want to search. I just want the button click script to return records containing a matching term in the field. Maddeningly simple but I can't navigate the HTML and scripting needed. I know it is possible to use the search function in the list view. It's a lovely function. However I need the simple search
Ask the Experts 2: Live Q&A: Find out all about the new Page Builder in Creator 5.
Hi everyone, As you all know, we recently released the latest version of Zoho Creator 5. The update includes features and enhancements that reduced the complexity involved in app building. One of our favorite enhancements is the new page builder. With the new Page Builder, creating interactive dashboards is extremely easy. It eliminates the need of coding in HTML or CSS — users can just drag and drop the elements they want onto the builder. Also, they can customize them by using a range of pre-built
Report with old record
Hi! I want to build a report that shows only the records that the "Last modified date" is greater than 15 days ago. Is it possible? Thnaks
link to live event?
How do I log in to here this live event?
bigint * bigint gives "mismatch of data type expressions found"
Here is my script - ---------------------------------------------------- lineItemsCostWithTax = 0.0; lineItemsCostWithoutTax = 0.0; lineItemDiscount = 0; discountOnAllLineItems = 0; //Get details of the customer in current order detailsOfCustomerInCurrentOrder = Customers[ID == input.Customer]; selectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Select_Product.New_Product_Name; discForSelectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Discount_in_Rs; info
Next Page