How to show report from button onClick event?
Sorry, can't find this in Help. I want to show report for a particular month, selected by user. I create stateless form for month input, with Submit button; all works well. Now, from onClick deluge script, I plan to launch an existing report. What is syntax to do it? Second question: how can I send a parameter (month number) to a report, and how can I use this parameter inside report scripts, what will be a name for this parameter?
Is Hide/Show available for formula fields?
We're desiring to conditionally hide/show a set of fields, 2 of which are formula fields. All is OK except for the formula fields. The editor refuses to save, unless we comment out the 2 formula fields. The error is "Hide function cannot be applied for <fieldname>". And, "Show function cannot be applied..." These 2 fields have the "Show on Form" option selected, because we DO want them to show on the form. ...Unless they are hidden with the set of fields. (I am using the Deluge names for the
Error occurred while executing the workflow
I'm getting this error when I execute a function "Error occurred while executing the workflow". The function reads a record and then creates records in several other tables. Does anyone know what error this message indicates?
How do I persist values in lookup field?
I have a timesheet application, where the field "Customer name" is a lookup in Customer table. The customer table will occasionally be wiped and new valus inserted. Unfortunately, this deletes the lookup values in the Timesheet table. How do I keep the lookup values? It is OK that the lookup values is not valid for old records, but new entrys should only use current rows in customer table.
Unable to hide/show field based on fetch data field
I have two forms: New Request and Request Status. In the New Request form, I have an AutoNumber field, then many other fields, including Request Type. Staff members are to enter info into the New Request form, then based on their requests, an email is sent to the appropriate Purchasing Staff member. Request Status is a stateless form, and I have the Puchasing Staff member entering the AutoNumber that they received from the New Request form email notification into this, which then auto-populates fields,
Inserting Comments into Free Flow Scripting
Can't find an answer to this, so hoping it hasn't been raised before. Whenever I attempt to add a comment in free flow, like this: //comment text I get a "null" error. It works in script builder, but I want to be able to do it within form definitions and so forth.
Auto Filling from the same field.
Hi! I have an application that can be used by both new clients and existing ones. The form has a decision box which when checked distinguishes the user as an already existing client. When this is checked a look up table is shown with all the existing clients, Once a client is selected I want to be able to auto fill his client information, Email, number, etc.. I am unsure how to auto fill this information when the information I need comes from this forms report. Thanks!
TIP: Using Deluge, create URL field with dynamic parameters such as record ID.
Using Deluge, create URL field with dynamic parameters such as record ID. After reading dox and lotsa forum posts, here is what worked for us just now. We're sorta new at this, maybe there are issues, or a better way. Our purpose was, on the convenient "pop-up" page that can display when on a report you click on a linked item's name, to have a linked field at the bottom for "Edit This Record". (A big convenience if you spot a need, you can edit it right away w/o going to a the different report
Data dump
Hello, Does Zoho offers the functionallity to automaticly generate a data dump for example Excel? No export from a report. We can use this data dump for intergration in a financial application we use. Greatings, Erwin Fennema
Alternate View in Report
In a list report I've a "customer" column field which links to the customers form, and when clicked shows the customer view (customer name, email, address, etc.,). How can I change this view to show aggregate data? Id rather see the number of purchases, total purchases, order history, etc.,
Multiple if statements in a formula field
I'm trying to figure this out with no success. Can someone chime in on this one? Thank you. FIELDS: QTY_Suspect is a number field Piece_Price is a currency field Suspect_Product_Disposition is a lookup field if (input.Suspect_Product_Disposition == "Sort at customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Return to plant", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Scrap at Customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition
How do I change columns to Row in a pivot table?
Hi all, Can some one help me in placing column to row I want to shift that to rows. Thanks in advance Venkat
Help with sub form please
Basically I have a field called Documents which has a list of check boxes, when the box is checked it will show a date created field and a upload field. My problem occurs when I create a subform of my Documents form, when I run the application the subform will display all of the fields even though the code is set to hide. How can I make the subform work as intended ? Thanks! :)
Date Field
Hi, I am currently having some trouble with my date field. At the moment I have my date field set to upon the form load it will fill with todays date, however this is all good for making a new user but when I wish to update and existing user it will only display the current date, not the original date when the user first became a new client. Thanks! :)
Can't open page editor (AGAIN!!)
I have an html page, and when I try to open the editor, the page hangs and never loads. The html pages still load, but I can't make changes to them. Anybody have any ideas? I have submitted to support already... Last time this happened, it was because I used "count" as a variable, which is apparently not supported. I got the ever-helpful troubleshooting error of "null". I have not made any changes since last time this happened. See that conversation here: https://help.zoho.com/portal/en/community/topic/can-t-open-page-editor#2266000005930001
Page break in Record Summary
Is it possible to have a page break in a record summary. I want to print some of the fields from a record on one page and the rest of the fields on a second page.
Autofill subform
Hello, I have the following issue. Form 1: Field 1: Number Field 2: Subform Form 2: Field 1: Lookup (based on form 1 number) Field 2: Subform Now I want the subform in field 2 filled, with the values of form 1, when selecting the number in field 1. I have made the following script in form 2: x = form_1 [ID == input.field1]; for each row in Subform { row.Description= X.Subform.Description; } The problem is he only fetches and updates the first row. Greatings, Erwin
SendMail - specify the 'From' name
Hi, a quick question... When using the sendmail function in deluge, is there any way that you can specify the name of the person / company sending the email - as opposed to the email address of the admin person showing. e.g. Currently shows as receiving the email from admin@company.com, want it to show 'Company Name'. Thanks in advance for any help... Paddy
sub-form Creator
Hello, Is it possible to automaticlly fill in a sub-form? For example: Form 1: Generates invoice number and I use a sub-form for different articles, price, quantity, sub-total. Form 2: Looks-up the invoice number and has to automaticly fill in the sub-form. Is this possible? Greatings, Erwin
Make a report more simple
hi all, I have a problem and I got stuck, I want to make a summary report from several different record and print it at the same page (at least). can you help me with that and show me how to do that step by step. I've attached the image of my needs, I hope it can help you to understand it better. Thank you so much.. From this report data become more simple report (as you see, it makes the same Car Number Data as summary) PS: just ignore the Using Date
Lookup field won't display desired fields
I created a lookup field on Form A (Head of Household) pointing to rows on Form B (Apartment). This is a 1-to-1 relationship. The fields which I want to display, Building Number and Unit Number from Form B, won't display in the lookup field on Form A. Only the ID and other system-generated fields will display. What am I doing wrong? Thanks!
Update Form information using a stateless form.
Hi, I have a stateless form that I'm using to enter information into a regular form. Once the information is in the master form, I'm also using a stateless form to show the user only the fields they can change.If the user changes any of the fields: How do I update the information back into the the master form from the stateless form? Thank you in advance, Alan
Security
Hello, Which measurements does ZoHo takes to protect the databases and the application? Does ZoHo automaticlly makes back-ups? Which measurements does ZoHo takes to secure the databases? Does ZoHo has escrow? Which measurements has Zoho taken to ensure the continuity of the application? Hope to hear from someone soon. Greatings, Erwin Fennema
Trial Period payment form value sent to PayPal
I'm trying to configure a form to submit a payment for a monthly subscription service. The issue is, I need to be able to add a "set up fee" to the initial transaction, followed by monthly payments. The initial fee is equal to the monthly payment plus the set up fee. Paypal has a "Trial Period" for subscription based payments, which can be different values than the set monthly payment. Is there a way to pass a "Trial Period" value to PayPal within the Payment form created in ZC? Thanks, DL
Google Maps
Hello, Is it possible to put a maps from Google Maps in a form/record with a pinpoint in it? Greatings, Erwin Fennema
Sent mail with the content of Lookup field
I have this code to the sendmail the value from the lookup field: TorneosForm = Torneos_Form [ID == input.Torneos_MDE]; ContactosForm = Contactos_Form [ID == input.Nombre_Arbitros2]; sendmail ( To : input.Correo_Electronico From : zoho.loginuserid Subject : "Cambios en la Asignacion" Message : <%=TorneosForm.Torneos_MDE%> ) Receives this error : Error at line number : 6 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Pass Custom action Form Object selected records to html view for loop?
I have a custom action that executes for a collection of records. (ie, I select several records in a view and execute the custom action.) This uses a form object with record ID's. My function is as follows and it opens an HTML View: void Shipping.Order_Batch(Purchase_Request_Form ID, int Order_Number) { openUrl("#View:Order_Batch_HTML&ID=" + ID + "&Order_Number=" + input.Order_Number, "popup window"); } I want to pass the list of record ID's into the Html view and use the selected records as
How to import data into a page
I want to use zoho to fill out a contract automatically if we choose a customer (name,e-mail,address.etc.). I made the contract as a page. I've added the contract text with INSERT HTML, but I don't know how to add expressions from a form. (I made a stateless form to choose the client and I've added this to the contract page). Can I get some help,please ? :)
Details on the working ?
Hi, I am very new to the Zoho, so I came across many doubts in the same, 1) Whats an application ? with the forms created in application how can I gather data from my customers ? 2) Can I create a single form with 135 fields ( 25 Dropdowns, 70 text, 20 Checkbox, 20 Date ) in one form ? 3) If not how can I do it with multiple forms ? 4) Ho can i implement the multiple form application to get data, if single form is used we can embed it to some of the web page and get data, in case of multiple form
Update records using Function
Hi, I am trying to create a function that will update the respective fields when it meets the respective criteria . see below form screenshot , there you can see the Coverage-01 and Coverage-02 are blank. I want to input "Full" in the coverage fields if respective MVPD fields is not null. like - for station : TV1 , the MVPD-01 is not blank so Coverage-01 field should be updated by "Full" but Coverage-02 should be blank since MVPD-02 is blank. I was trying to use below Script but not working **********************************************
other not working in drop down
Hi, I have added the other option for some of the drop down fields in the form. They all show in the report view except in the case of 'spread sheet view' but while I export the data none of them are shown in the exported data. Am I missing something ?.
'clear' can be used only in on load actions (deluge error message)
But In the following page: https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html you say: Example Below is an example code that can be specified in the On User Input action of a subform picklist field. list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall())
Page with embedded form requesting login but shouldn't...any workaround?
Hi All, I have a form embedded in a page using the script builder embed form gizmo: <div style='border:2px solid rgb(125,186,0); margin:4px;' elName='zc-component' formLinkName='DataEntry' params='zc_Header=false&zc_SubmitVal=Next&zc_ResetVal=Reset'>Loading Form...</div> Accessing the page via its permalink, I am asked to log in in order to see the contents of the form. How do I get the form in there without login request? Do I have to scrap the Embed format and insert the public access
Finding out the logged in user's role and/or profile from within Deluge Script
is there any easy way to determine the role and/or profile of a user that is currently logged in, in a similar manner as we can find the zoho.loginuserid - can the role and profile of the user be retrieved in deluge script at all ? thanks in advance, Jennine
Adjust editing in report
Hello, Can I change the order of the edit options in a report: Edit Delete Duplicate Print View record See attachments for a print screen. Greatings, Erwin
update formula when script updates fields druring edit
I have a formula field that sums the total value of several decimal fields. Example: Formula 1 = Decimal field 1 + Decimal field 2 + Decimal field 3 I have some on edit scripts that update the decimal fields with certain decimal values when a user changes certain fields. My question is how can I get the formula field to update / recalculate its value when an on user input script is triggered and updates a decimal field with a new value? It seems that when an On User input script updates one of the
Quick Access to Forms and Reports (right sidebar) questions
Maybe someone can help: 1. The titles (bold font) of the respective apps don't change although I changed the report and the form names. See attached image: The word 'Qualifikation' should not be there anymore. How can I change the titles or is it a bug? 2. Can I change the order of the quick access to apps and forms? At the moment it just places the forms and reports I added last at the bottom. I would like to move some up... 3. Can I make this sidebar stay there forever? Because everytime I acces
Maximum amount fields in form
Hello, What is the maximum amount of fields in a form? Greatings, Erwin Fennema
Main form sub form question
I have a two Main forms and 1 subform Form A Subform A (embedded in A) Form B I have data stored in multiple rows in the subformA of Form A ex. Form A SubformA record 1 record 2 on success of Form A, I would like to insert 2 new records into Form B that contain information from Subform A Any help would be greatly appreciated
No access to application
I have been shared an application through my gmail account. I have downloaded Zoho creator from the App Store and can log in and access the application on the mobile app using my gmail credentials. However, when I access the Zoho online, and log in with Google, I'm told that "You are not allowed to access this application." There are currently only two users for this application, myself and its creator. The creator can access the application through a browser or the mobile app. She tried logging
Next Page