specialized list
I have a database with one report (list) - I/m not sure what to call it. It has 18 columns and many rows. I want to create from that list, a new list that I only would use to update info, and it would look the same, but only 4-5 columns. The other columns still there just not displayed. Columns I'm not interested in updating would not show. Thanks
Auto populate field from lookup
How auto populate one field when the user select the drop down lookup. I have this code for normal drop down: if (((input.Arbitros == "Juan") || (input.Arbitros == "Jose")) || (input.Arbitros == "Miguel")) { input.Porciento_de_Descuento = 0; } else if ((input.Arbitros == "Richard") || (input.Arbitros == "Michael")) { input.Porciento_de_Descuento = 5; But I need this same result with drop down lookup field.
how to run scheduler every 30 min?
hi need to run internal scheduler every 30 minutes. how to make it? complex workaround - make 48 same half-hour schedulers. need simple solution.
Re Subform :Check box to be chenged Multi select ?
Hi Anbu I I have a Check box field in a form,but when as a Subform into other form the Check box has changed a the Multi select ,could you please let me know what's happed, By the way after selected a or more value in the Multi select and then Cause the other script can not run,it's bug?or cause of the check box is replaced by multi select? New problem :if selected a value in Multi select and then can't submit like bellow screencap looks like the problem for that if Multi selec dynamic filtering
Display text based on dropdown choice
Hi there, I have a form called "Attempt" that has a drop down menu that is a task number that is a lookup from a "task view" I have. Based on the number selected I'd like to display another field from the "task view" for that record along side the number. I'd be happy for this to be uneditable text as it's only for display purposes, I don't even need it to write to the view for the form in question. Any ideas? Hope I'm explaining this ok. Another way to look at this... Imagine a set of questions
Relationship between databases
I have a database with details of all my clients (about 20 in total) I have another form which my clients use to book an appointment and I need to know who is making the booking. I want the client name entered on the booking form to equal the client name in the client list and I do not want the client to use a drop down box as I do not want clients to know who my other clients are ... Is there a way for creator to ensure fields match without disclosing the options
Configure Formula Field
Hi. I have the following formula: "((today - PlantDate) / (60 * 60 * 24 * 1000 * 365.25)).round(1)" The number is rounded to one decimal but still two decimals are shown, the second being a 0. I wish only one decimal to be shown. Where or how can I set this. I cannot find a method or area to set this. Many thanks.
How do I allow an override
I want to make an entry mandatory, but allow a manager to override it (with a password), is there a way to do it? if there is, can I leave a note only when I override
Send email with record summary attached when record inserted via deluge
Hiya I have a course management system and when I add a record to my Enrolments table I'd like to add the invoice details to my Invoices table, which will then send off an automated email with the record summary (made up to look like an invoice) attached. I've configured the Invoices form so that when a record is added manually it sends the email with invoice attached. I've also coded the Enrolments table so when a record is added it automatically adds it to the invoices table. Only problem is when
Hide Fields from a form
I have created a form with Zoho creator. Users are able to access a form and a report from that form. However, I want to include certain fields in the report that will only be editable by the admin, but the users can have a view of these fields. How can I create these fields without including them on the form?
Design Template
What are the best practices with Zoho for development workflow? Is there the concept of a design template where I can make changes to a test version of the app and then apply those design changes to the live app?
Zoho Creator API json format not working? xml OK
https://creator.zoho.com/api/json/student-record/view/Invoice_Extraction_Report?scope=creatorapi&authtoken=mytoken&zc_ownername=ricwilson returns a 500 error but https://creator.zoho.com/api/xml/student-record/view/Invoice_Extraction_Report?scope=creatorapi&authtoken=mytoken&zc_ownername=ricwilson works. This was all fine a few days ago. Please advise if this is a current issue. Rewriting interfacing to process xml instead of json is not an option.
when i provide a user with a permalink they cannot see images
When I provide my users with a permalink they are unable to see images.
Record Summary As PDF on Email for lookup record
Is it possible to include a Record Summary as a PDF in an email if the Record Summary is from a lookup field? Perhaps by fetching the record and then qualifying the record summary in the email. Lookup_Record = Student_Record [ID = Iinput.Lookup_Field]; sendmail ( To : input.Send_To From : zoho.adminuserid Reply to : zoho.loginuserid Subject : Subject Message : Email_Body + "<br />\n<br />"
Create a Report with Criteria calling a function
Is possible creat a View, in creator, with a criteria calling a function? Like: branch==thisapp.return_branch(zoho.loginuserid) See the attached image
Export Invoice as PDF on Mobile Phone
Is there a way to make a custom action that will export an invoice as a PDF (or JPEG) from my report onto a mobile phone? I would like the delivery driver to be able to print receipts using a smart phone and a mobile blue-tooth printer.
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 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
Next Page