Drop down list - auto fill other text field
Hi I have 2 forms - Form 1 - 'Memorial Branch Details' Fields: - Branch Name - Email address - Telephone number Form 2 - 'Warehouse list' In this form I want to have a drop down list which contains the various 'Branch Names' from Form 1. Once the 'Branch Name' has been selected, I would like a text box in Form 2 to auto fill the corresponding branch email address in. What is the best way to do this? Many thanks Tom
Auto populate look up fields
Hi, I have a "Product Type", "Products" and "Sales" form. In the "Sales" form, i want to choose the Product Type in a look up field (can be radiobutton either) and below i want a look up field that shows only the products belonging to the product type selected in the above "Product Type" look up field. How can i do it? Thanks! Xarana
Auto Fill form based on selected drop down value and another form data
Hi, I have a form Form A (see below screenshot) where there are two columns : Market and MVPD. Each row of this form is Unique I have another form where I need to auto fill the fields based on selected drop down value and above form data . see below screenshot Example: When I select "M1" from "Market drop down field then I want to run a script that will fetch the related MVPD values from Form A . see below when I select Market as "M1" -- Could anyone please help me what script I should Use ? Thanks
Histroically accurate lookups
Hi How should I proceed in order to fetch historically accurate records from one form to another? For example, I may look up the price from my Products form for my Order form. The price may change in the future but i do not want the prices in my previous orders to change, as is the case if i simply use the lookup field. For those of you familiar with filemaker, what are the equivalents in zoho creator for lookup and portal. lookup in filemaker copies the value so that it will remain historically
Pivot chart filtered by loginuser
Hi 1) if any possible to Pivot chart filtered by loginuser 2) it is possible to set Criteria for Pivot chart Thanks Satya NHM
Forms and reports Landscape not working
Hi 1) Check the pivot table report in iPad ,Reports are shows outside of the screen attach the image please check 2) Rotate iPad in Landscape ,Reports and Forms are not rotate Thanks Satya NHM
Relationships between Add On > On Success and original
Hi all, If I create new records automatically via above Action, what would happen to this automatically added data if I then edited or deleted the originally imported data? E.g. If I import 1 apple, with a Form Action automatically creating a new record that doubles the amount, so new record is 1 apple. What would happen if I wanted to delete 1 apple as it was an error? Would the new data, 2 apple, automatically be deleted as it's related to the original 1 apple? Or do I need to go and delete all
Get all values from a picklist
Hello everyone, I would like to get all of a picklist (dropdown) field's values (field name Inverter_Manufactuer_text) and add them to a list. I then want to append that list to another picklist (field name Inverter_Manufactuer) What I have got so far is: temp_list = List(input.Inverter_Manufacturer_text); Inverter_Manufacturer:ui.append(temp_list.getall()); I am getting a 'not able to find 'getall' function error message at the moment Any help appreciated!
zoho send mail
Hi, I have created a Email field.If i submit a data ,send mail to that email id,its working.But my need is i want Cc the copy to set of people. Thank you,
Three DB for data capture, three further DBs that automatically flow from first - is this possbile/sensible in Zoho?
Hi, I'm a newbie to Zoho and I have 12 days left of my 14 day free trial. I'm trying to achieve the following, but really don't know if Zoho is a sensible platform for achieving it or if it's possible. Be great to get some advice from the community. What I am trying to do? I want create four DBs with the ability to create rich and dynamic reports. So far so easy. The hard bit is, I only want to input data in to one Master DB and for the other three DB to all update automatically, based on a set
Invoking Function error
Hi all, I can't figure out why I'm getting an error. I'm trying to Create a field in Form2 when a record is successfully created in Form 1. I want the new record in Form 2 to be identical to the one in Form 1 apart from field, Amount, being increased by 50%. I have defined the following Function: AMR = (input.Amount * 1.5) ; return AMR; which works when I test it by executing it. Then, in Form 1 workflow, I have chosen Insert Record in the Add On > On Success Tab In each category, I have simply
Calendar report filtered by loginuser
Hello, I have a calendar view that I've set up a criteria to only let the loginuser view entry's they've made. See below: (Service_Status != "Completed" && Added_User == zoho.loginuser) This works great!... Now the twist. Say I need to transfer a created service request to another technician. Naturally if I change the assigned technician to another technician it only appears in the form. Using the above criteria the newly assigned technician never sees the service request on their filtered calendar.
lookup fieeld in a report
Hi, I need support, i am trying to have a lookup field in a report but all the data are in one column, i want one lookup option in a different column in the report.,
Insert HTML - not displaying edit window
When editing HTML pages, the 'HTML Task' of (Insert HTML) does not launch the normal editor 'pop-up'. Other tasks, such as 'Insert Expression' do launch the pop-up editor. I have tried this on both Chrome & IE...... Is there a problem
Creator FieldMap not pushing more than 6 fields to Zoho CRM
Hey everyone, I have a fieldmap which then pushed my data to CRM (updates fields). It wont update more than 6 fields. As you can see I have tried clearing the Fieldmap but only the first 6 will push across. Any help appreciated myField2Map = map(); //Convert the lookup fields to string Stringinv_make_model = Solar_Inverter_Details [ID == input.Inverter_Make_Model]; myField2Map.put("Inverter Make/Model", Stringinv_make_model.Inverter_Make_Model); //function to push to CRM - set to update myField2Map.put("AC
Is possible to get data from a Zoho Spreadsheat?
Hello, We have a form in our Creator. The user type some data and we need to use this data to do some calculations. Is it possible to call or get in some way this calculations from a Zoho Spreadsheat? Thanks,
Printing Mailing Labels (Mail Merge / Export Data / SQL Query??)
Hi friends, I'm trying to create a database to replace an existing excel worksheet. One of the requirements is that we can print labels that contain various pieces of information about each record. They are not simply name / address, but I suppose that's as good a place to start as any. We currently update the information in an Excel spreadsheet, do some concatenation and formatting in another sheet, and then do a mail merge in MS Word against that sheet using an SQL query through MS Query. When
Disable chart menu in HTML page ?
Is it possible to disable chart menu in HTML page ? Thanks. :)
Creating reports - calculating entries from multiple forms
I need to build a report based on the same form being filled out multiple times by the same user. We are recording the number of each users consistent responses and changes over several instances. The following is an example of the form, the user must select one or multiple decision boxes. The form automatically determines sum total, percentage and time taken, The user then will complete this same form several more times. We need to create a report that can filter by user name and time period
Lookup
Hi. I have two tables: Table A: "Field1" Character Unique "Field2" Numeric not unique etc... TableB: "Field1" Character Not unique "Field2" Numeric Not unique etc... Naturally the two fields in table A together form a unique key. The two fields in TableB together form a unique key. I wish to create a view where using the two fields in table A the required row is read off table B. TableB has a whole set of identical "Field1" rows and the value of "Field2" indicates which row is required. This is a
Open a record-summary with an openurl statement?
Is it possible to open a record-summary with an openurl statement? I would like to do this from a decision box on a form. I want it to popup over the form and when it is closed come back to the form. Is it possible to automatically bypass the browser from blocking this as a popup?
how to localize system menu?
hi need localize system menu.
Mail merge from filtered list
Hi. I have a database that records pallets in and out of our warehouse. I need to create a mail merge or other method of printing pallet labels which contain some of the fields for each record in a filtered list. Ideally I need to create an A4 label for each record which print when selected without the need to export the data to .csv files and merge with another office program. Can this be done from within Zoho Creator. Thanks.
Calculate number of marked responses in a form
Hi I am trying to find a quick way to automatically calculate the number of responses a user marks (true/ correct) on a form and then calculate the overall percentage score. Below is an example. I am using the decision boxes where the user will mark each response they feel is true. Any ideas would be appreciated. Ian
MultiLine Field in Pivot Tbl
Hi, would like to create a Pivot report which will include 2 MulitLine Fields/TextAreas, however, I am only able to use 1 multiline field in my Pivot report. Thank you.
Image in html view using publish url
Hi, I have one HTML page name is Welcome and one report name is Image Report. I want to fetch the image from Image report and displayed in Welcome page. Finally i want to embed Welcome page in my website. how to get a image src link in (Image report) publish url? Thanks Satya NHM
Delete record from a Form and Insert the deleted record to another form
Hi, I am trying to figure out script that delete a record from FormA and insert the same deleted record to another formB Below is sample what I am using to delete the record if (input.Update_Sub01 != null) { if (chan_count1 < 1) { delete from Chanel_Database[ (CD_tvId == input.Update_TVID && CD_channel_NO == input.Update_channelNo01)]; } } I want to insert the above deleted record to another form - FormB Could anyone please help me ? Thanks Arfater
Change dynamically radio button values in a subform which are related to a lookup field
Dear All, I have the following subform which consists of a lookup field (Excursions) and a radio button (Radio). The excursions are loaded in the on load action when I open the form. I would like when I select the Radio (Full Day in that case) in the 1st row then to show the 'Full Day' automatically in the 2nd row (because they have the same Excursions Selection). When I select 'Half Day' in the 3rd row then to show 'Half Day' in the following 2 rows (4th-5th) etc. In other words, if I have the same
how to localize buttons?
hi just made localized text on buttons in form. but when open entry - there is text in english how to localize it correctly?
Verify Records exist in one form that are in another form
I want to verify that records exist in more than one form. FormA and FormB I want to verify that records exist in FormA that are in FormB ( I would like to count the number of records not in FormA)
Drop down list - auto fill other text field
Hi Sorry - I think I have already posted this question in the incorrect area on the forum. My question is: I have 2 forms - Form 1 - 'Memorial Branch Details' Fields: - Branch Name - Email address - Telephone number Form 2 - 'Warehouse list' In this form I want to have a drop down list which contains the various 'Branch Names' from Form 1. Once the 'Branch Name' has been selected, I would like a text box in Form 2 to auto fill the corresponding branch email
Disable subform fields one by one
Dear All, I would like to ask you if it is possible via deluge code to disable only some fields - cells in a subform. In the following example I would like to disable the fields one by one. Is it possible? If yes, do you have a short example to show me?
Two time stamps in a single form
I am looking for a way to measure the amount of time it takes for a user to complete a form, where the user can start and stop the clock. I see this working as having 2 time stamps and a 3rd calculation field Step 1 - Time stamp 1 - Record Start Time Step 2 - Time stamp 2 - Record End Time Step 3 - Formula Calculation - Time taken ( End time minus Start time) is this possible using the current creator functions?
insert new record based on data called in a subform
Have a button on a subform, and when I select it I want to insert a new record into a separate form. I am having trouble.
Error while inserting data
Hi, I'm trying to add data from Form A to Form B, I have added the script in Form A "on edit - on success". Form name explanation: Form A = To_Do_Form url - https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/To_Do_Form/workflow/edit Form B = P_L url https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/form/P_L/Sales_Ticket/workflow/edit Script in Form A: insert into P_L [ Purchase_Date = input.Closed_Date Purchase_Ticket = input.Ticket_No
How to get IOS data for a single contact into a ZC client form
In many cases the basic date already exists as a Contact in in the IOS Contacts app. Is there any way now with the new Apple extensions to transfer the contact data directly into the ZC client form? For example the app Docusign can now immediately access the IOS contact on the Ipad and use the data. This is very very useful and eliminates constant duplication of data entry.
Custom filter - filter records older than a specified time
Hi I am sure that there is a very simple answer to this - I just can't seem to figure it out! I want to create a custom filter that will display all records in my database that are older than 6 months. What is the best way to do this? Ideally I would like to set up a number of filters, so that I can show; - records that have been in the database for 6-12 weeks - records that have been in the database for 12-18 weeks - records that have been in the database for 18-24 weeks Any help
Get Zoho Support Record by ID
Hi, I have to build a scheduled task to get a record from Zoho Support and check its ticket status on a periodic basis. I can use zoho.support.getRecords(), but it returns multiple records which is not what I need. Is there a function I can use to fetch a single Zoho Support record by id that is equivalent to Zoho CRM integration function zoho.crm.getRecordById()? Thank you.
Concatenating 2 fields from different tables and showing them?
Hi there I have Contact Header (eg; Companies) and Contacts (people working at that company) = so far that is good. I then want a Leads/Projects that is linked to Contacts. So ideally I'd like to be able to see a list of Contacts and Companies for the user to select from. Example: (Contacts combined with Companies) Abby (Internet Spotters) Tony (Freds Emporium) Will (Angus Traders) So when the user creates a new Project then the user would auto-type/select from a drop down list of Contacts. The reason
Error in script when sending emails
Hi my script has always worked but now I was trying to modify it and I could not save the new script. I got this error message: In cases where From: address is not a zoho.adminuserid or zoho.loginuserid, the To: address can only be zoho.adminuserid and the sendmail task cannot have any CC: or BCC: address. The script sends an email from the address of a specific Zoho user (USER@rossatogroup.com) according to the selected county ("Provincia") in the form. Each county ("Provincia") is associated to
Next Page