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 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.
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,
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.
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)
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?
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.
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
how to close a stateless form
I have a stateless form that popups up on a condition. one of the buttons is to close the form. it dose not close. what am I missing.. openUrl("#Script:dialog.close", "same window");
OT - Creator is really good - but not well explained... (not complaining as such)
I do really like Creator and it has a lot of depth but some of it is quite buried. This is not a complaint - just a concern. Example; the "Pages" can (if I knew) really customise the look / feel of an application and I have been reading through the documentation and I think it is all there - but just a case of working through it all... I mean in Pages there is a little tiny icon in the upper right where it shows all the fields you can embed into your page. And in Reports there is a whole report writer
How do I populate an email by clicking a URL in a mobile view
I would like users of the mobile version of my application to be able to click a link within a record that invokes an email to be sent to pre-selected email addresses and includes inputs from the record in the body of the email. Example: A record is created by an administrator that represents one step from a checklist describing how to install software. In that record, 4 contacts with email addresses are assigned using a multiselect lookup dropdown. They are support personnel for that step. A user
HTML special Characters
Hi All, I want to include the up arrow ↑ and down arrow ↓ html special characters as part of a text string for a field value. However, when I try to add the html entity name, the string just shows the characters and not the symbol. Perhaps special characters are not supported in field values? Thanks in advance for any help.
Sendmail Custom Action
Hi All, I'm very new to Zoho and coding in general. I'm looking to create a custom action that will allow the user to select a record or multiple records and email it to an email address they specify (or at least to themselves if that's not possible). Is this possible? Can I email the record using a record summary template? Tim
How can I put a message on a screen that is dependent on the combination my form inputs
I'm struggling to create my first application and would appreciate some guidance. I want o create a small 'expert system' that displays a different answer based on different combinations on inputs. I can create an entry form easily enough. But I'm lost to know what to do next? thanks
Pivot chart creation
Hi, Is there any way to make the following chart from Zoho Creator? . Thanks Satya NHM
Is it possible to move a record from 1 form to another?
Hi guys I have set up a simple form which I want to use for inventory purposes. Each item is stored at the warehouse for a certain amount of time, before it is bought back to the production unit for work to commence on it. I would like the ability to move a record from the form that shows all of the items stored at the warehouse to a seperate archive form of records that shows all of the old items that are no longer stored at the warehouse. Is this possible? Many thanks Tom
On Validate allow either the Added_User or an adminuser to edit
on validate - I want to allow either the Added_User or an adminuser to edit a record. Other users should not be able to edit the record. I've tried a few different statements at "on validate" but cannot get them to work. I am an admin and I attempt to edit another users record as the test. So far, test failed. Any help is welcome. Two examples are below of statements I've tried to use. >> I've tried this if (input.Added_User != zoho.loginuser)||(zoho.loginuser != zoho.adminuser) { alert "You
PDF conversion for multi-page dynamic pages
Hi, I have a dynamic page generated from data in a form that fills in a template. This works fine and displays well rendering all HTML as it should. The issue I'm having occurs when I try to use the PDF exporting functionality. Since some pages extend over multiple pages, text at the bottom of the page overflows failing to respect margins and any padding. I have created a print-only style sheet that defines margins for the pages and padding for specific elements but the overflow is constant. Can
How to sum related records?
Hello, I have two tables: one list my works and another one relatated counts worked hours. I would like put a formula in works table that sum all worked hours for selected work. Thank you
Creator does not seem to have CRM's workflows?
One of the things I like about Zoho CRM is the "workflow" - Creator says "workflow" but it is programming. It is a shame it could not replicate the CRM "workflow" module. Does anyone else see any utility in it? Thank you Brynley
Next Page