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?
RMA TRACKER
Is there any way something in Zoho can be setup so that I can issue and track an RMA?
Paypal Within the Portal
A few years ago, there was a problem where Paypal payment notices were not getting back to forms in the Portal. So if the form connected Paypal and the user made a payment, the On Add/On Success event of the form did not know that the payment had been made and never completed the transaction. Does anyone know if that has been fixed? Can I put a form that uses Paypal in the Portal and have it receive Paypal notices reliably? Thanks Jon
Build contact manager in Creator
Hi, I want to replicate Contact manager in Creator. That is I want a vendor page that I can link multiple contact records to. What is the best way to go about this? Thanks
deluge statement execution limit
Hi. I have function: float z(float k, float g) { // size = XS and 6 s = 0.0; if ((input.k < 700) || (input.g < 700)) { s = 6; } // size = S and 8 else if (((input.k >= 700) && (input.k < 900)) || ((input.g >= 700) && (input.g < 900))) { s = 8; } // size = M and 10 else if (((input.k >= 900) && (input.k < 1100)) || ((input.g >= 900) && (input.g < 1100))) { s = 10; } //size = L and 10
How to populate a drop down field with data from last two records fetched from another form
I just don't know why this does not work. I'm fetching all the records from form "Received_Ingredient" in which the "Grains" field is "Rye". I want to populate a drop down field, "Rye_Lot_Number" with the "Lot_Number" in the latest two records. I think the last two records will be the first to be fetched, but if not I can sort by a date field in each record. This won't compile without error. count=0; for each delivery in Received_Ingredient[Grains="Rye"]; { if(count<2) { count=count+1;
does the strings in Zoho Creator starts with "." ?
I am trying to get a number from US Format "11.11" to European Format "11,11" using strings and the built in function: "replaceFirst". However I found an interesting behaviour: tmp_string_price_ = "abcde"; tmp_string_price = tmp_string_price_.replaceFirst("c",","); returns "ab,de" as it should be however tmp_string_price_ = "ab.de"; returns ",b.de" Correspondingly, it seems that an "." is found at the first position, even if is not what I have stored in that string. Obviously, with numbers
updating data from a field in child so it appends to a field in parent
Hi, Is it possible in Creator to write a Deluge script that will over write data in a field in the parent with up dated data from the mirrored field in the child? I am bringing in data, from a lookup, into the child record. I have created mirrored field names in the child form and the lookup deluge script functions as expected. If the data changes in the 'Remarks" field of the child record I would like to over write the data in the "Remarks" field in the parent on save and on edit... How best to
Migration from zoho.eu to zoho.com
Hi, I hired a developer to create an app in creator, and it worked perfectly but I needed Zapier integration, which is not available on Zoho.eu, so I migrated to zoho.com and imported the app. However the app is acting up whereas before it was fine. The issue is an autonumbering system that is now listing as "NULL" when before it was working fine. Anyone know what the issue could be. Zohosupport sucks crap, I had to migrate everything myself, took them 3 days to NOT DO anything about it, and I´m
301 Moved permanently
Creator cant export to PDF , 301 Moved permanently
Session Variables in Zoho Creator
Hi, I want to set some session Variables for a user using the Creator from a particular IP Address. For example Zoho.ipAddress is a session variable I want something like user.key Is it possible?
list separator
Hi, I am using below function and it contains a list variable by default list separator is comma (',') but I would like to use other separator in list like # or @ .. So how can I do that so the content in list variable will be separated by "#" or "@" instead of "," see below function : void API.Conver_MasterLineup(string mrkt, string lineupID, string lineupName, string lineupType, string ProviderName, string ProID, string SerArea) { lineID = List(); for each rec in lineups_Zipcode[Market == input.mrkt
Next Page