Can I use a custom action to open a form and populate a lookup field?
I'm using a report with a custom action, trying to open up a form and populate a lookup field with a project code but having issues. My custom action function is as follows: void display.BookAppt(int id, Add_Project proj) { openUrl("#Form:Book_Appointment?Project=" + proj.Project_Code, "same window"); } On the Book_Appointment form, I have a lookup field called "Project" and I'm trying to pass the "Project Code" value from the Add_Project form, but it isn't working. if I change the function to
Transfer data from dropdown to a new form on submit
Hello, On submit I transfer data to another form which is working. However when I transfer data from a dropdown it reveals the ID of the dropdown and not the text. How do I code to transfer data from a dropdown into a dropdown on another form on submit? insert into Paraplanning [ Added_User = zoho.loginuser Case_Details = input.Brief_Details_of_Advice_Given Case_Status = "New Submission" Client_Full_Name = input.Client_Name_to_be_Used_within_the_report Date_Received = input.Date_Submitted
API Response Javascript Function
Hi, the problem is that a creator api call return a variable or javascript function and no valid json response. Can you please add a valid json response. Thank You, Daniel
How to remove applications in Zoho creator I no longer want?
I do not see these applications in my account through the computer in order to eliminate them. I already deleted them but I know it's still there. I know they exist because I see them through the application of the cell phone and when I try to create another it tells me that I can not add any more. I see the application of the Electronic Teacher's Book as four times and I'm not interested.
get link value of URL field
How do you get the value of the link from a url field? I want to use openurl to open the url from a url field. If I use openurl(url_field, New Window) It uses the Link name not the actual link.
Embedded Report in HTML page: Header title being cut off
How can I fix the issue below? The Header title is being cut off
Average weekly visitors
Hello, I count daily visitors, have unique names. Users want to have the statistics, where they see average Distinct weekly visitors in a month. Lets say first week I had 11 distinct Visitors . Next week I had 15 distinct visitors. So the proper calculation would be that I had (11+15)/2 = 13 .. on avarage in one week I had 13 distinct visitors. Is it possible to do this in Pivot report? It gets more complicated when I have the whole month andin this month 4.5 weeks, I have then to do the maths as:(11+15+12+17+6)/4.5.
User permission for application?
Hello Zoho Team, is it possible to setup my application for the user's (Login via E-Mail) that he only can create a new record and not delete anything in the database? Regards Carsten
How to find and set a value into a field from another form?
I have 2 forms. On occasional basis, I add new name into the first form and assign particular tax rate and commission to that name. Daily, I need to enter data into the second form. I choose a name from "lookup/drop down" menu connected to the first form and fill out couple numbers. The form calculates the rest. What I need is, depending on the name I select, to automatically look up and fill the tax and commission that were set in the first form. What would be the best way to accomplish this? Thank
Convertir Numeros a texto?
Quiero saber si es posible convertir números a texto en Español, Quiero enviar facturas con números y texto: ejemplo: 1000 (Mi ) ó 20000 (Veitemil) Es posible o algúna funcion similar dentro de zoho?
Zoho Api Question
Hey All, Have a quick question regarding parsing json. I believe my code is valid however it doesn't display a response when i search for specific key / value. I can however return the response->uri just fine but can't get anything other than that or the full file. function GetLeads() { $file = fopen("https://crm.zoho.com/crm/private/json/Leads/searchRecords?authtoken=API KEY&scope=crmapi&criteria=(Last%20Name:test)", r) or exit("Unable to Open File!"); while(!feof($file)) { $theData = fgets($file);
Include lookup field in function
Hi I have two forms (A and B) connected with a bidirectional lookup. I want to copy records from one to another including the value from another lookup (from form Country) which they both include. So far the function looks like this: void copyRecord(string First_Name, string Last_Name, string Email, string Profession) { insert into New_Profile [ Added_User = zoho.loginuser First_Name = input.First_Name Surname = input.Last_Name Email = input.Email
Total income calculation form
Hi , I wonder if anyone can help me. I have a job process form where by the user records a job undertaken, which calculates agains a job form. So there is a list of jobs complete in a report. I want to a separate form where the user can select a month of the year, and it will calculate the earnings over that period. I have attached a screenshot below of the "Job Proccess Form" which i would like to build this new form from. Thanks for your help in advance. Danny
Add edit button to record summary
Hello, I have taken a look at these 2 posts https://help.zoho.com/portal/en/community/topic/how-do-i-create-a-link-to-a-pop-up-edit-window-in-an-html-view https://help.zoho.com/portal/en/community/topic/tip-using-duluge-create-url-field-with-dynamic-parameters-such-as-record-id But none of these posts solved my problem. When I click on a linked record from a record summary, I want to be able to edit that record in a popup view within the application. I've gotten this far temp_param = input.ID.toString();
How to get value of field in current record
Hi, I have a table called 'Classes' In that table, I have a field called "Class1" - it is a drop down field. On the action "On user action", I want to save the value that is in the field if a user removes that value. So, if the value in Class1 == null, I want to know what it was before it was removed and save that value in a variable. This gets me the value that is in the field before it was deleted. ctemp1 = Classes [ID == input.Class1]; How do I save that value though after the field value
"?Terminal.Id="
What does the "?" in front of the "?Terminal.Id=" mean?
Enable and disable fields in a subform On Edit - On Load according to an other field value.
Hi Zoho, I have a subform and I would like to know if its possible to enalbe or disable a field "Quantity" according to an other field "Status" for different rows when I open the record to edit it. I was trying the following code, but I can't even save it. for each rr in Detalil_RC { if ( rr.Status == "Approved" ) { disable rr.Quantity; } } It says "rr" is not defined. Any help will be appreciated.
Retrieving zoho.loginuser variable using email address
I am trying to retrieve a zoho loginuser variable by using an email address so i can link only relevant information to the specified customer.
Pre-populate "Add New" Form based on Main Form data?
Hi, Is there any way to prepopulate the "Add New" form based on the input of the main form as shown in the picture?
Allow customer to look up record via one field entry.
I don't exactly know how to explain this so someone would understand - I have a parking citation application that I would like to be able to embed some type of search form, or report in a web page, and a driver can then go to the website, enter their license plate number (which is entered by the officer) and view their parking citation online. Is this possible? I know I can embed an entire report, but I can't figure out how to allow someone to search for their (and only their own) parking citation
Creating multiple Products for your Quotes in Zoho CRM.
Hi, We now support creating multiple Products for a Quote using zoho.crm.create task. Below is the deluge code for creating multiple Products for a Quote in Zoho CRM through Zoho Creator. string createQuote(string productId1, string productId2) { maplist = List:Map(); product_map = {"Product Id" : productId1}; product_map2 = {"Product Id" : productId2}; maplist.add(product_map); maplist.add(product_map2); resp = zoho.crm.create("Quotes", { "Subject" : "Quote for ABC Corp,Ltd",
Need help to build a Labour hire app - Developer wanted!
Hi , I am looking for a developer to help with building an labour hire app where we can get the employees to Register online Update work history bank details and tax file number availability for shifts each week online timesheet - supervisor to access to approve Employee inputs shifts worked Tables for clients rates. ie $20hr flat rate, time & half $35 , double time $ 40 Allowance: for each client table: Travel allowance $10, meal $15 Employee - payslip and update details portal access Regards
Using libraries
Can I make use of external libraries in any programming language in Zoho Creator for hashing passwords or displaying a CAPTCHA in a web page? I would like to put some code in the Validation part of the workflow for a form.
Find correct script
Hello, I need to use this script for count all record inserted at 06:00 AM, but it doesn't work (Error at null): void dati_per_report() { x = Dati_chiamata [ Added_Time.getHour() == 6 ].count(ID) ; } Any idea? Best regards
How can I add/fetch the data extracted from a QR code scan to a lookup field.
How can I add/fetch the data extracted from a QR code scan to a lookup field. I have a form with of all addresses and info of my customers (each has a QR code) and another form to capture deliveries. I want to give my drivers the ability to scan or look up manually the address in the lookup field linked to my customer form. Thank you for you help
Ideas Needed for Inventory Management System
Dear all, My idea is to use Zoho Creator to build an inventory management system with tracking capabilities which mimic the current Excel/Paper use in my company. It has to have the current features: 1. Able to display daily inventory level with - Base Inventory (Sum of each items until yesterday) - Outgoing (Today's outgoing) - Receving (Today's incoming) - Total (Base + Recv - Out) 2. Able to track Lot No. of each inventory. - In my test system, I am able to record
Column Hide and Show
I have a column " Lead type " with two dropdown value company and individual and other column "group" so I want when the lead type will be company then group column will show or if the lead type will be individual group column will be hide show how can I do that
API View Related Record's ID Instead of Display Name
Hi, Let's say there are two forms: 1) Person 2) Family A Person can be assigned to one Family. Let's say there are the following Families: #) ID - Name 1) 1 - Johnson Family And there are the following Persons: #) ID - Name - Family_ID 1) 2 - Mary - 1 2) 3 - Paul - 1 When I use the Zoho Creator API to download the Persons data I get the following information: #) ID - Name - Family_Name 1) 2 - Mary - Johnson Family 2) 3 - Paul - Johnson Family I do not get the ID of the Family. So if I
Access data by user owner - RLS
Dear gurus, I started testing ZOHO Creator, and one of features is of course RLS, meaning that users can access only his own data. As I read in instructions, this is the default feature in access rights (Advance sharing settings), but in my testing application each user can access all the data? I now have only free version. Can you guide me on what should I do? Rg G
dynamic dropdown
I have a dynamic dropdown but i want to add a search function to it, It's possible?
Pivot Tables: Associate data shelf with different rows
I would like to have my Updates column relate to "last modified" while my New Issues relates to "added time". Is there a way to do this in the same pivot table? In the example below, I want the number 8 to be on the month Apr because all my updates were during the month of Apr. The example below shows that 3 updates were in March because the record was created in March. I need to see the sum of updates that happened within the listed month. https://creator.zoho.com/appbuilder/joeybuck/host-care-managment/report/Month_to_Date/edit
Fetch record referenced to on another form
Hello, I have three forms in my application: "Projects", "Contacts", and "Activities". On my project form, I associate every new project with a contact. On my activities form, I want to be able to pull up a list of all active projects via a lookup, choose one, and then display that project's contacts details (e.g. full name). How would I go about doing that? Activities Form Lookup -> Project A -> Project A Contact Record -> Full Name Thank you!
How to set different logo in different Customer Portals under the same organization account
I think that my question is not supported for now. We have 2 working companies under the same organizational account. We have also created 4 applications (2 for the one company and 2 for the other) and we also use customer portal for these apps. My question is if it is possible to have different company logo in each application. 2 applications with the one logo and 2 with the other. I think no, as it is not possible to manage 2 companies under one organization account like Zoho Books for example.
Multiple Payment Methods
I am setting up a registration form for classes that we offer, and I'd like to give people the option of paying either online with PayPal or with cash or check at the event. Is there any way to do this?
Run script On Load of application?
Hi! I would like to run a script when the application loads. If this is possible, how do I accomplish this?
Exporting to spreadsheet creates duplicate lines
Hi! I have a client who is exporting a report from Zoho Creator. In the Creator report, there are no duplicate lines. In the exported spreadsheet, however, there are (very occasionally) lines that are duplicated. Has anyone else experienced this problem? Thanks!
Auto populate form based on dropdown selection
Hello all, Thank you for taking a moment to read my request for help. It has been a few years since I have worked in creator, so please be patient. I have a form named Build_Sheet where several values are entered during an assembly process. Such as serial numbers, configurations etc. I have a second form named Data_Collection where additional information is stored about the equipment in the Build_Sheet form. Workflow is as follows. Assembly builds a new tool comprised of multiple serialized
HTTPS in iFrame not working
I am trying to create an iframe of the page of my gmail. But I cannot do this. Why? I have experimented with "www.zoho.com" and I can click on everything without having problems except when I click "access my account" then the iFrame goes blank. How do I fix this issue?
Show a specific report when application loads
I would like to show a specific report (calendar) when the application first loads. I have 3 main menu items positioned at the top of the application.These each have links under them to pull up certain reports. I know you can change the order of the sections, but in this case I do not want to. My 3 main menu headings are: Patient Information Calendar Reports The Calendar report does not have any drop down links. The other two do. I would like the Calendar report to load as the as the default
element positioning
Hi , I have selected two column in my application. Now after inserting some elements in the left column I want to position an element in the right column adjecent to specific element. Only problem is the space above is empty and any element inserted in column 2 gets positoned to the top. How to solve this?
Next Page