Lookup filtering and subform
Hello, could you help me? I've a form (i.e. customer) with subform(i.e. cars). in another form, I need to filter lookup CARS when I choose the CUSTOMER. How can I do it? I already seen the link, but it don't help me. Will place an example for clarity FORM A Customer name Subform Cars (plate, type, color) FORM B Lookup Customer Lookup Car in Form B, if I select the Customer "Mr. White", I would like to see in the lookup Car only the cars of Mr. White. Can I do this with lookup filters? How? Thanks
Hangs on "Adding..." when inserting new field to form
My items were all working correctly yesterday until mid-day when suddenly adding any new fields to the form (Drop down, Single line, Check box, anything) result in the page simply hanging with "Adding" for the field. If it is a lookup source, it does go through to steps to determine what the source will be and has the same result of the addition simply hanging there... Any suggestions?
Custom Schedules
Hi Guys, I have a requirement to create custom schedules that run every 14 days and every 30 days. It looks to me that I can't do this as the options are daily, weekly, monthly and yearly. Perhaps I'm missing something? Thanks for any assistance!
Subform Links in List Report
I have put Multiple SUbforms in my Parent Form but when I access the Report, List style, and i choose to access the Info in the SUbform Via a link in the Report i am no being shown the Data inputed into the fields. I am only getting Field names displayed when the link is clicked. Is there something i can do to have the Data included in the window generated by the Link?
How to learn input.vars or the Record ID within "On Delete" script?
Seems that both OnDelete.Validate, and OnDelete.Success, are unaware of the form's input vars?? The same scripts that work in OnAdd, and OnEdit, don't work when in OnDelete. Seems not even aware of its own record ID, at least not via input.ID. I must be missing something... :-) I have searched the dox and forum. How do I learn at LEAST the record ID, so I can look up the field values via x = <Form>[ID = input.ID]; ? In this our first brush with On Delete, we are updating some record counts successfully
Cant access my forms, blank page shows when trying to load any regular form
all of my forms are showing up blank
Retrieve data based on each Multiselect selection
hi, I have a multiselect field and I would like to retrieve the value from another view based on each multiselect selection and input it another field View1: Form: when user first selects the 1001 in the multiselect field then a script will retrieve the respective "Subs" value from view1 which is 3000 and input it to "Est.Subs-Selected Fips" and then when user selects next Fips value --1003 -- then the the "Est.Subs-Selected Fips" will be updated to 4000. Could anyone please help me on script ? Thanks
Kitting or multiple units, stumper
So I have multiple forms: Form1 Form2 Form3 Form4 Form2 contains a 1 to many relationship with Form1 example... in form2 I have UNIT A, which contains multiple Items from Form1 so UNIT A may have ITEM 1, ITEM 2 and ITEM 3, all with different quantities I want to be able to select UNIT A in Form3 and have it create an individual record in Form4 (I think thats what i want to do) for each Item in UNIT A Thanks
can you pass data from one form to another that the first form opened with an open url command?
can you pass data from one form to another that the first form opened with an open url command?
Look up field value different in view than when editing record?
Please take a look at the following screen shot. Highlighted in Red: Request_ID shown in view = 1185428000007018175 - m3steele@gmail44.com - 9 Highlighted in Green: Request_ID in edit record = 1185428000007018240 - - m3steele@gmail44.com - 9 What is wrong, why is this happening? Im not sure if the value is set wrong or what. I know the lookup field is referring to the correct record because of the part " m3steele@gmail44.com - 9" that is also included. These values are not in any other record in
Track number of times form completed by each person
Hello, I wonder if anyone out there can help me. The nice guys at Zoho support have tried to help me but unfortunately it doesn't allow me to do what I need. I have two forms: 1. SERVICE USER DETAILS (name, address etc). 2 WELLBEING They are linked through a look-up field on the wellbeing form (last name, first name, DOB). Each service user will complete the wellbeing form a number of times over a period of months/years. Each time they complete the form, I would like it to capture that this
Linking fields and forms
I am creating a client database for my Dog daycare and i am running into a couple problems with linking fields and forms. I have one form called Customer info and this form has fields for name, Dog's name, number, email, Daily Credits and a sub form for vaccination records. MY second form is called Dog account/payment history. This has a look up field for Dog'ss name, a radio button for Checkin/Checkout , a payment field, and a Credit field. I would like to link a couple items: 1. I would like to
using stateless form from data entry
I am using a stateless form for data entry (timesheet application) I would like to attach a file or image of the actual timesheet to each record i create with the stateless form. I know you can add a file with a normal form and copy it to another form when you submit.
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
Next Page