Livedesk chat window customization
Hi, I have a developer access for one application. But i am not able to customize livedesk chat window. i have attached the screenshot for your reference. Kindly assist me. Thanks Satya NHM
zoho send email
I have created a reservation report. I have customized to send mail notifications with cc and Bcc recipients. 1.But the problem is the mail is sent only if all the recipeients field are filled. The mail is not sent if there is only mail recipient. 2. Company Name Guest Name Room Name Check in Check out 3ds Mr. kkk SD45 - R1 null 17-Nov-2014 26-Nov-2014 In the column "RoomName", notice the 'NULL' . RomName has fot two options in the form and only one could be selected. This null
Zoho Creator Signature Field
Hello, it looks like You added a signature field to zoho creator. Will you update the mobile apps soon? They are crashing as soon as I enter the layout that contains new signature field.
Android subform display issue
I have a sub-form in my invoice form which only displays correctly when I access the invoice form. When I am in the invoice report, and access the subform, it displays incorrectly. This is the correct display, which displays the fields "Crops" and "Variety" first. When accessed through the invoice report, the display becomes like this, which makes the sub-form basically useless:
different logo for defferent app?
hi there is description how to change logo for all apps in account https://www.zoho.com/creator/help/account-settings/customize-logo-and-links.html#Steps_to_upload_your_logo but how can i set different logo for different app in my account? app1 - logo1 app2 - logo2 and so on..
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
Next Page